Attachment 89147 Details for Bug 5770 – Bug 5770: Notify for new suggestion - sample notices

[patch] Bug 5770: Notify for new suggestion - sample notices

Bug-5770-Notify-for-new-suggestion---sample-notice.patch (text/plain), 25.60 KB, created by Liz Rea on 2019-04-30 17:20:14 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Liz Rea

Created: 2019-04-30 17:20:14 UTC

Size: 25.60 KB

patch

obsolete

>From f528da361bc8a66c5002421dd585c1b55deeba9b Mon Sep 17 00:00:00 2001
>From: =?UTF-8?q?Nazl=C4=B1=20=C3=87etin?= <nazli@devinim.com.tr>
>Date: Tue, 30 Apr 2019 16:17:54 +0000
>Subject: [PATCH] Bug 5770: Notify for new suggestion - sample notices
>
>Signed-off-by: Liz Rea <wizzyrea@gmail.com>
>---
> .../data/mysql/de-DE/mandatory/sample_notices.sql  | 26 +++++++++++++++++++++
> .../data/mysql/en/mandatory/sample_notices.sql     | 26 +++++++++++++++++++++
> .../data/mysql/es-ES/mandatory/sample_notices.sql  | 26 +++++++++++++++++++++
> .../mysql/fr-CA/obligatoire/sample_notices.sql     | 26 +++++++++++++++++++++
> .../mysql/fr-FR/1-Obligatoire/sample_notices.sql   | 26 +++++++++++++++++++++
> installer/data/mysql/it-IT/necessari/notices.sql   | 26 +++++++++++++++++++++
> .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql  | 26 +++++++++++++++++++++
> .../data/mysql/pl-PL/mandatory/sample_notices.sql  | 26 +++++++++++++++++++++
> .../data/mysql/ru-RU/mandatory/sample_notices.sql  | 26 +++++++++++++++++++++
> .../data/mysql/uk-UA/mandatory/sample_notices.sql  | 27 +++++++++++++++++++++-
> 10 files changed, 260 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>index 259851ab6b..b66054a7e5 100644
>--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
>@@ -22,6 +22,32 @@ VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname>
> ('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');
> 
> INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
> VALUES ('members', 'DISCHARGE', 'Entlastung', 'Entlastung fÃ¼r <<borrowers.firstname>> <<borrowers.surname>>', '
> <<today>>
> <h1>Entlastungsbescheinigung</h1>
>diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql
>index 4d37f9c71d..ffbef04a90 100644
>--- a/installer/data/mysql/en/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/en/mandatory/sample_notices.sql
>@@ -22,6 +22,32 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f
> ('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');
> 
> INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
> VALUES ('members', 'DISCHARGE', 'Discharge confirmation', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '
> <<today>>
> <h1>Discharge confirmation</h1>
>diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>index 12d9b3f41a..c15451d608 100644
>--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
>@@ -21,6 +21,32 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, name, title, content, is_html)
> VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
> Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>index 2cb0386b01..22ba70bc07 100644
>--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
>@@ -24,6 +24,32 @@ INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, m
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
> ('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');
> 
>diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>index 68bb26dce0..15bc96bc24 100644
>--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
>@@ -23,6 +23,32 @@ VALUES
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, name, title, content, is_html)
> VALUES ('circulation','ISSUESLIP','Ticket de de prÃªt','Ticket de prÃªt', '<h3><<branches.branchname>></h3>
> PrÃªts Ã  <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql
>index fdf776ee7d..67048eb627 100644
>--- a/installer/data/mysql/it-IT/necessari/notices.sql
>+++ b/installer/data/mysql/it-IT/necessari/notices.sql
>@@ -28,6 +28,32 @@ biblio.title>>\r\n----\r\nGrazie per aver visitaro <<branches.branchname>>.', 'e
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO letter (module, code, name, title, content, is_html)
> VALUES ('circulation','ISSUESLIP','Ricevuta di prestito','Ricevuta di prestito', '<h3><<branches.branchname>></h3>
> Prestito a <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>index 23236f6d79..14d3cee9cc 100644
>--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql
>@@ -44,6 +44,32 @@ VALUES ('circulation','ODUE','Purring','Purring pÃ¥ dokument','<<borrowers.first
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, name, title, content, is_html)
> VALUES ('circulation','ISSUESLIP','UtlÃ¥n','UtlÃ¥n', '<h3><<branches.branchname>></h3>
> UtlÃ¥nt til <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>index 90dde8f36d..42342843e7 100644
>--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
>@@ -22,6 +22,32 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, name, title, content, is_html)
> VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
> Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>index b99d43c674..ee48800231 100644
>--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
>@@ -21,6 +21,32 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.f
> ('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'),
> ('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');
> 
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, name, title, content, is_html)
> VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
> Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>index 297164a072..d28fd9ad0a 100644
>--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
>@@ -84,7 +84,32 @@ INSERT INTO `letter` (module, code, name, title, content, message_transport_type
>  'email')
> ;
> 
>-
>+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
>+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','<h3>Suggestion pendin    g approval</h3>
>+    <p><h4>Suggested by</h4>
>+    <ul>
>+    <li><<borrowers.firstname>> <<borrowers.surname>></li>
>+    <li><<borrowers.cardnumber>></li>
>+    <li><<borrowers.phone>></li>
>+    <li><<borrowers.email>></li>
>+    </ul>
>+    </p>
>+    <p><h4>Title suggested</h4>
>+    <ul>
>+    <li><b>Library:</b> <<branches.branchname>></li>
>+    <li><b>Title:</b> <<suggestions.title>></li>
>+    <li><b>Author:</b> <<suggestions.author>></li>
>+    <li><b>Copyright date:</b> <<suggestions.copyrightdate>></li>
>+    <li><b>Standard number (ISBN, ISSN or other):</b> <<suggestions.isbn>></li>
>+    <li><b>Publisher:</b> <<suggestions.publishercode>></li>
>+    <li><b>Collection title:</b> <<suggestions.collectiontitle>></li>
>+    <li><b>Publication place:</b> <<suggestions.place>></li>
>+    <li><b>Quantity:</b> <<suggestions.quantity>></li>
>+    <li><b>Item type:</b>  <<suggestions.itemtype>></li>
>+    <li><b>Reason for suggestion:</b> <<suggestions.patronreason>></li>
>+    <li><b>Notes:</b> <<suggestions.note>></li>
>+    </ul>
>+    </p>',1, 'email');
> INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES
> ('members', 'DISCHARGE', 'Ð¿ÑÐ´ÑÐ²ÐµÑÐ´Ð¶ÐµÐ½Ð½Ñ Ð½Ð° ÑÐ¾Ð·ÑÐ°ÑÑÐ²Ð°Ð½Ð½Ñ',
> 'Ð Ð¾Ð·ÑÐ°ÑÑÐ²Ð°Ð½Ð½Ñ Ð´Ð»Ñ Ð²ÑÐ´Ð²ÑÐ´ÑÐ²Ð°ÑÐ° â <<borrowers.firstname>> <<borrowers.surname>>', '
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 5770: 83384 | 83385 | 83386 | 83387 | 83388 | 83390 | 83615 | 83616 | 83617 | 84463 | 84812 | 89139 | 89140 | 89141 | 89142 | 89144 | 89145 | 89146 | 89147 | 89188 | 89189 | 89190 | 89191 | 89192 | 89193 | 89194 | 89195