View | Details | Raw Unified | Return to bug 5770
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+27 lines)
Lines 22-27 VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname> Link Here
22
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos', 'Anschaffungsvorschlag wartet auf Bearbeitung','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nEin neuer Anschaffungsvorschlag wartet auf Bearbeitung: <<suggestions.title>> von <<suggestions.author>>.\n\nVielen Dank,\n\n<<branches.branchname>>', 'email');
22
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos', 'Anschaffungsvorschlag wartet auf Bearbeitung','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nEin neuer Anschaffungsvorschlag wartet auf Bearbeitung: <<suggestions.title>> von <<suggestions.author>>.\n\nVielen Dank,\n\n<<branches.branchname>>', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
29
   <li><<borrowers.cardnumber>></li>
30
   <li><<borrowers.phone>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
33
</p>
34
<p><h4>Item on suggestion</h4>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
48
 </ul>
49
</p>',1, 'email');
50
51
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('members', 'DISCHARGE', 'Entlastung', 'Entlastung für <<borrowers.firstname>> <<borrowers.surname>>', '
52
VALUES ('members', 'DISCHARGE', 'Entlastung', 'Entlastung für <<borrowers.firstname>> <<borrowers.surname>>', '
26
<<today>>
53
<<today>>
27
<h1>Entlastungsbescheinigung</h1>
54
<h1>Entlastungsbescheinigung</h1>
(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (+27 lines)
Lines 22-27 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email');
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
29
   <li><<borrowers.cardnumber>></li>
30
   <li><<borrowers.phone>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
33
</p>
34
<p><h4>Item on suggestion</h4>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
48
 </ul>
49
</p>',1, 'email');
50
51
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('members', 'DISCHARGE', 'Discharge confirmation', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '
52
VALUES ('members', 'DISCHARGE', 'Discharge confirmation', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '
26
<<today>>
53
<<today>>
27
<h1>Discharge confirmation</h1>
54
<h1>Discharge confirmation</h1>
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (+27 lines)
Lines 21-26 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
29
   <li><<borrowers.cardnumber>></li>
30
   <li><<borrowers.phone>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
33
</p>
34
<p><h4>Item on suggestion</h4>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
48
 </ul>
49
</p>',1, 'email');
50
24
INSERT INTO `letter` (module, code, name, title, content, is_html)
51
INSERT INTO `letter` (module, code, name, title, content, is_html)
25
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
52
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
26
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
53
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+27 lines)
Lines 24-29 INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, m Link Here
24
('suggestions','ORDERED','','Suggestion d\'achat commandée',0,'Suggestion d\'achat commandée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons le plaisir de vous informer que le document a été commandé.\r\n\r\nVous recevrez une nouvelle notification quand le document sera disponible à bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
24
('suggestions','ORDERED','','Suggestion d\'achat commandée',0,'Suggestion d\'achat commandée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons le plaisir de vous informer que le document a été commandé.\r\n\r\nVous recevrez une nouvelle notification quand le document sera disponible à bibliothèque.\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email'),
25
('suggestions','REJECTED','','Suggestion d\'achat rejetée',0,'Suggestion d\'achat rejetée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons évalué votre suggestion aujourd\'hui et décidé de ne pas l\'acheter cette fois.\r\n\r\nLa raison de notre refus est : <<suggestions.reason>>\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
25
('suggestions','REJECTED','','Suggestion d\'achat rejetée',0,'Suggestion d\'achat rejetée','Bonjour <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nVous nous avez suggéré l\'achat du document <<suggestions.title>> par <<suggestions.author>>.\r\n\r\nNous avons évalué votre suggestion aujourd\'hui et décidé de ne pas l\'acheter cette fois.\r\n\r\nLa raison de notre refus est : <<suggestions.reason>>\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <<branches.branchemail>>.\r\n\r\nMerci.\r\n\r\n<<branches.branchname>>','email');
26
26
27
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
28
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
29
<p><h4>Suggested by</h4>
30
 <ul>
31
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
32
   <li><<borrowers.cardnumber>></li>
33
   <li><<borrowers.phone>></li>
34
   <li><<borrowers.email>></li>
35
 </ul>
36
</p>
37
<p><h4>Item on suggestion</h4>
38
 <ul>
39
   <li><b>Library : </b> <<branches.branchname>></li>
40
   <li><b>Title : </b> <<suggestions.title>></li>
41
   <li><b>Author : </b> <<suggestions.author>></li>
42
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
43
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
44
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
45
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
46
   <li><b>Publication place : </b> <<suggestions.place>></li>
47
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
48
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
49
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
50
   <li><b>Notes : </b> <<suggestions.note>></li>
51
 </ul>
52
</p>',1, 'email');
53
27
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
54
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
28
('members','DISCHARGE','','Quittance',0,'Quittance pour <<borrowers.firstname>> <<borrowers.surname>>','Quittance\r\n\r\nLa bibliothèque <<borrowers.branchcode>> certifie que l\'utilisateur suivant :\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\nCardnumber : <<borrowers.cardnumber>>\r\n\r\na rendu tous ses documents.','email');
55
('members','DISCHARGE','','Quittance',0,'Quittance pour <<borrowers.firstname>> <<borrowers.surname>>','Quittance\r\n\r\nLa bibliothèque <<borrowers.branchcode>> certifie que l\'utilisateur suivant :\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\nCardnumber : <<borrowers.cardnumber>>\r\n\r\na rendu tous ses documents.','email');
29
56
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+27 lines)
Lines 23-28 VALUES Link Here
23
('suggestions','TO_PROCESS','Avis au propriétaire du poste budgétaire', 'Une suggestion est prête à être traitée','<<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> / <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
23
('suggestions','TO_PROCESS','Avis au propriétaire du poste budgétaire', 'Une suggestion est prête à être traitée','<<borrowers.firstname>> <<borrowers.surname>>,\n\nUne nouvelle suggestion est prête à être traitée : <<suggestions.title>> / <<suggestions.author>>.\n\nMerci,\n\n<<branches.branchname>>', 'email'),
24
('members', 'DISCHARGE', 'Quitus', 'Quitus pour <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Quitus</h1>\r\n\r\nLa librairie <<borrowers.branchcode>> certifies que lecteur suivant :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numéro de carte : <<borrowers.cardnumber>>\r\n\r\na bien retourné tous ses documents.', 'email');
24
('members', 'DISCHARGE', 'Quitus', 'Quitus pour <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Quitus</h1>\r\n\r\nLa librairie <<borrowers.branchcode>> certifies que lecteur suivant :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numéro de carte : <<borrowers.cardnumber>>\r\n\r\na bien retourné tous ses documents.', 'email');
25
25
26
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
27
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
28
<p><h4>Suggested by</h4>
29
 <ul>
30
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
31
   <li><<borrowers.cardnumber>></li>
32
   <li><<borrowers.phone>></li>
33
   <li><<borrowers.email>></li>
34
 </ul>
35
</p>
36
<p><h4>Item on suggestion</h4>
37
 <ul>
38
   <li><b>Library : </b> <<branches.branchname>></li>
39
   <li><b>Title : </b> <<suggestions.title>></li>
40
   <li><b>Author : </b> <<suggestions.author>></li>
41
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
42
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
43
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
44
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
45
   <li><b>Publication place : </b> <<suggestions.place>></li>
46
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
47
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
48
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
49
   <li><b>Notes : </b> <<suggestions.note>></li>
50
 </ul>
51
</p>',1, 'email');
52
26
INSERT INTO `letter` (module, code, name, title, content, is_html)
53
INSERT INTO `letter` (module, code, name, title, content, is_html)
27
VALUES ('circulation','ISSUESLIP','Ticket de de prêt','Ticket de prêt', '<h3><<branches.branchname>></h3>
54
VALUES ('circulation','ISSUESLIP','Ticket de de prêt','Ticket de prêt', '<h3><<branches.branchname>></h3>
28
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
55
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+27 lines)
Lines 28-33 biblio.title>>\r\n----\r\nGrazie per aver visitaro <<branches.branchname>>.', 'e Link Here
28
('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <<borrowers.firstname>> <<borrowers.surname>>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <<suggestions.title>> by <<suggestions.author>>.\n\n Grazie dell\'attenzione,\n\n<<branches.branchname>>', 'email'),
28
('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <<borrowers.firstname>> <<borrowers.surname>>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <<suggestions.title>> by <<suggestions.author>>.\n\n Grazie dell\'attenzione,\n\n<<branches.branchname>>', 'email'),
29
('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Liberatoria</h1>\r\n\r\nLa biblioteca  <<borrowers.branchcode>> certifica che il seguente utente :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numero tessera : <<borrowers.cardnumber>>\r\n\r\nha restituito tutti i documenti ricevuti.', 'email');
29
('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Liberatoria</h1>\r\n\r\nLa biblioteca  <<borrowers.branchcode>> certifica che il seguente utente :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Numero tessera : <<borrowers.cardnumber>>\r\n\r\nha restituito tutti i documenti ricevuti.', 'email');
30
30
31
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
32
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
33
<p><h4>Suggested by</h4>
34
 <ul>
35
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
36
   <li><<borrowers.cardnumber>></li>
37
   <li><<borrowers.phone>></li>
38
   <li><<borrowers.email>></li>
39
 </ul>
40
</p>
41
<p><h4>Item on suggestion</h4>
42
 <ul>
43
   <li><b>Library : </b> <<branches.branchname>></li>
44
   <li><b>Title : </b> <<suggestions.title>></li>
45
   <li><b>Author : </b> <<suggestions.author>></li>
46
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
47
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
48
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
49
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
50
   <li><b>Publication place : </b> <<suggestions.place>></li>
51
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
52
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
53
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
54
   <li><b>Notes : </b> <<suggestions.note>></li>
55
 </ul>
56
</p>',1, 'email');
57
31
INSERT INTO letter (module, code, name, title, content, is_html)
58
INSERT INTO letter (module, code, name, title, content, is_html)
32
VALUES ('circulation','ISSUESLIP','Ricevuta di prestito','Ricevuta di prestito', '<h3><<branches.branchname>></h3>
59
VALUES ('circulation','ISSUESLIP','Ricevuta di prestito','Ricevuta di prestito', '<h3><<branches.branchname>></h3>
33
Prestito a <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
60
Prestito a <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+27 lines)
Lines 44-49 VALUES ('circulation','ODUE','Purring','Purring på dokument','<<borrowers.first Link Here
44
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
44
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
45
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
45
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
46
46
47
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
48
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
49
<p><h4>Suggested by</h4>
50
 <ul>
51
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
52
   <li><<borrowers.cardnumber>></li>
53
   <li><<borrowers.phone>></li>
54
   <li><<borrowers.email>></li>
55
 </ul>
56
</p>
57
<p><h4>Item on suggestion</h4>
58
 <ul>
59
   <li><b>Library : </b> <<branches.branchname>></li>
60
   <li><b>Title : </b> <<suggestions.title>></li>
61
   <li><b>Author : </b> <<suggestions.author>></li>
62
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
63
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
64
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
65
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
66
   <li><b>Publication place : </b> <<suggestions.place>></li>
67
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
68
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
69
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
70
   <li><b>Notes : </b> <<suggestions.note>></li>
71
 </ul>
72
</p>',1, 'email');
73
47
INSERT INTO `letter` (module, code, name, title, content, is_html)
74
INSERT INTO `letter` (module, code, name, title, content, is_html)
48
VALUES ('circulation','ISSUESLIP','Utlån','Utlån', '<h3><<branches.branchname>></h3>
75
VALUES ('circulation','ISSUESLIP','Utlån','Utlån', '<h3><<branches.branchname>></h3>
49
Utlånt til <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
76
Utlånt til <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+27 lines)
Lines 22-27 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
23
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
23
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
24
24
25
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
26
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
27
<p><h4>Suggested by</h4>
28
 <ul>
29
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
30
   <li><<borrowers.cardnumber>></li>
31
   <li><<borrowers.phone>></li>
32
   <li><<borrowers.email>></li>
33
 </ul>
34
</p>
35
<p><h4>Item on suggestion</h4>
36
 <ul>
37
   <li><b>Library : </b> <<branches.branchname>></li>
38
   <li><b>Title : </b> <<suggestions.title>></li>
39
   <li><b>Author : </b> <<suggestions.author>></li>
40
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
41
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
42
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
43
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
44
   <li><b>Publication place : </b> <<suggestions.place>></li>
45
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
46
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
47
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
48
   <li><b>Notes : </b> <<suggestions.note>></li>
49
 </ul>
50
</p>',1, 'email');
51
25
INSERT INTO `letter` (module, code, name, title, content, is_html)
52
INSERT INTO `letter` (module, code, name, title, content, is_html)
26
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
53
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
27
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
54
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+27 lines)
Lines 21-26 VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f Link Here
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
22
('members', 'DISCHARGE', 'Discharge', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '<h1>Discharge</h1>\r\n\r\nThe library <<borrowers.branchcode>> certifies that the following borrower :\r\n\r\n    <<borrowers.firstname>> <<borrowers.surname>>\r\n   Cardnumber : <<borrowers.cardnumber>>\r\n\r\nreturned all his documents.', 'email');
23
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
26
<p><h4>Suggested by</h4>
27
 <ul>
28
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
29
   <li><<borrowers.cardnumber>></li>
30
   <li><<borrowers.phone>></li>
31
   <li><<borrowers.email>></li>
32
 </ul>
33
</p>
34
<p><h4>Item on suggestion</h4>
35
 <ul>
36
   <li><b>Library : </b> <<branches.branchname>></li>
37
   <li><b>Title : </b> <<suggestions.title>></li>
38
   <li><b>Author : </b> <<suggestions.author>></li>
39
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
40
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
41
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
42
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
43
   <li><b>Publication place : </b> <<suggestions.place>></li>
44
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
45
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
46
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
47
   <li><b>Notes : </b> <<suggestions.note>></li>
48
 </ul>
49
</p>',1, 'email');
50
24
INSERT INTO `letter` (module, code, name, title, content, is_html)
51
INSERT INTO `letter` (module, code, name, title, content, is_html)
25
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
52
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
26
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
53
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-1 / +26 lines)
Lines 84-89 INSERT INTO `letter` (module, code, name, title, content, message_transport_type Link Here
84
 'email')
84
 'email')
85
;
85
;
86
86
87
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
88
VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New Suggestion','<h3> Suggestion pending approval</h3>
89
<p><h4>Suggested by</h4>
90
 <ul>
91
   <li><<borrowers.firstname>> <<borrowers.surname>></li>
92
   <li><<borrowers.cardnumber>></li>
93
   <li><<borrowers.phone>></li>
94
   <li><<borrowers.email>></li>
95
 </ul>
96
</p>
97
<p><h4>Item on suggestion</h4>
98
 <ul>
99
   <li><b>Library : </b> <<branches.branchname>></li>
100
   <li><b>Title : </b> <<suggestions.title>></li>
101
   <li><b>Author : </b> <<suggestions.author>></li>
102
   <li><b>Copyright date : </b> <<suggestions.copyrightdate>></li>
103
   <li><b>Standard number (ISBN, ISSN or other) : </b> <<suggestions.isbn>></li>
104
   <li><b>Publisher : </b> <<suggestions.publishercode>></li>
105
   <li><b>Collection title : </b> <<suggestions.collectiontitle>></li>
106
   <li><b>Publication place : </b> <<suggestions.place>></li>
107
   <li><b>Quantity : </b> <<suggestions.quantity>></li>
108
   <li><b>Item type : </b>  <<suggestions.itemtype>></li>
109
   <li><b>Reason for suggestion : </b> <<suggestions.patronreason>></li>
110
   <li><b>Notes : </b> <<suggestions.note>></li>
111
 </ul>
112
</p>',1, 'email');
87
113
88
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES
114
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES
89
('members', 'DISCHARGE', 'підтвердження на розрахування',
115
('members', 'DISCHARGE', 'підтвердження на розрахування',
90
- 

Return to bug 5770