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

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+26 lines)
Lines 22-27 VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname> Link Here
22
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos (Erwerbung)', '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 (Erwerbung)', '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 pendin    g 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>Title suggested</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
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>>', '
51
VALUES ('members', 'DISCHARGE', 'Entlastung', 'Entlastung für <<borrowers.firstname>> <<borrowers.surname>>', '
26
<<today>>
52
<<today>>
27
<h1>Entlastungsbescheinigung</h1>
53
<h1>Entlastungsbescheinigung</h1>
(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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
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>>', '
51
VALUES ('members', 'DISCHARGE', 'Discharge confirmation', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '
26
<<today>>
52
<<today>>
27
<h1>Discharge confirmation</h1>
53
<h1>Discharge confirmation</h1>
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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');
24
INSERT INTO `letter` (module, code, name, title, content, is_html)
50
INSERT INTO `letter` (module, code, name, title, content, is_html)
25
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
51
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
26
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
52
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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');
27
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
53
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');
54
('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
55
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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');
26
INSERT INTO `letter` (module, code, name, title, content, is_html)
52
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>
53
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 />
54
Prêts à <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+26 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 pendin    g 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>Title suggested</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');
31
INSERT INTO letter (module, code, name, title, content, is_html)
57
INSERT INTO letter (module, code, name, title, content, is_html)
32
VALUES ('circulation','ISSUESLIP','Ricevuta di prestito','Ricevuta di prestito', '<h3><<branches.branchname>></h3>
58
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 />
59
Prestito a <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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');
47
INSERT INTO `letter` (module, code, name, title, content, is_html)
73
INSERT INTO `letter` (module, code, name, title, content, is_html)
48
VALUES ('circulation','ISSUESLIP','Utlån','Utlån', '<h3><<branches.branchname>></h3>
74
VALUES ('circulation','ISSUESLIP','Utlån','Utlån', '<h3><<branches.branchname>></h3>
49
Utlånt til <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
75
Utlånt til <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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');
25
INSERT INTO `letter` (module, code, name, title, content, is_html)
51
INSERT INTO `letter` (module, code, name, title, content, is_html)
26
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
52
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
27
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/ru-RU/mandatory/sample_notices.sql (+26 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 pendin    g 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>Title suggested</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');
24
INSERT INTO `letter` (module, code, name, title, content, is_html)
50
INSERT INTO `letter` (module, code, name, title, content, is_html)
25
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
51
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
26
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
52
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (-2 / +26 lines)
Lines 84-90 INSERT INTO `letter` (module, code, name, title, content, message_transport_type Link Here
84
 'email')
84
 'email')
85
;
85
;
86
86
87
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 pendin    g 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>Title suggested</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');
88
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES
113
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES
89
('members', 'DISCHARGE', 'підтвердження на розрахування',
114
('members', 'DISCHARGE', 'підтвердження на розрахування',
90
'Розрахування для відвідувача — <<borrowers.firstname>> <<borrowers.surname>>', '
115
'Розрахування для відвідувача — <<borrowers.firstname>> <<borrowers.surname>>', '
91
- 

Return to bug 5770