From f792bf5c93c2d30970f338c1bc8c845aa4d79e49 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Nazl=C4=B1=20=C3=87etin?=
Date: Tue, 30 Apr 2019 16:17:54 +0000
Subject: [PATCH] Bug 5770: Notify for new suggestion - sample notices
Signed-off-by: Liz Rea
Signed-off-by: Martin Renvoize
Signed-off-by: Nick Clemens
---
.../mysql/de-DE/mandatory/sample_notices.sql | 26 ++++++++++++++++++
.../mysql/en/mandatory/sample_notices.sql | 26 ++++++++++++++++++
.../mysql/es-ES/mandatory/sample_notices.sql | 26 ++++++++++++++++++
.../fr-CA/obligatoire/sample_notices.sql | 26 ++++++++++++++++++
.../fr-FR/1-Obligatoire/sample_notices.sql | 26 ++++++++++++++++++
.../data/mysql/it-IT/necessari/notices.sql | 26 ++++++++++++++++++
.../nb-NO/1-Obligatorisk/sample_notices.sql | 26 ++++++++++++++++++
.../mysql/pl-PL/mandatory/sample_notices.sql | 26 ++++++++++++++++++
.../mysql/ru-RU/mandatory/sample_notices.sql | 26 ++++++++++++++++++
.../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 6f0883be25..d710bd6272 100644
--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
@@ -21,6 +21,32 @@ VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <
('suggestions','REJECTED','Anschaffungsvorschlag nicht angenommen', 'Ihr Anschaffungsvorschlag wurde nicht angenommen','Liebe(r) <> <>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>', 'email'),
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos (Erwerbung)', 'Anschaffungsvorschlag wartet auf Bearbeitung','Liebe(r) <> <>,\n\nEin neuer Anschaffungsvorschlag wartet auf Bearbeitung: <> von <>.\n\nVielen Dank,\n\n<>', 'email');
+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
VALUES ('members', 'DISCHARGE', 'Entlastung', 'Entlastung für <> <>', '
<>
diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql
index 0f38c53b70..6d676e73e6 100644
--- a/installer/data/mysql/en/mandatory/sample_notices.sql
+++ b/installer/data/mysql/en/mandatory/sample_notices.sql
@@ -21,6 +21,32 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>', 'email'),
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <> <>,\n\nA new suggestion is ready to be processed: <> by <>.\n\nThank you,\n\n<>', 'email');
+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
VALUES ('members', 'DISCHARGE', 'Discharge confirmation', 'Discharge for <> <>', '
<>
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
index d3d4cb9e25..965850ac91 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 <> <>,\n\nA new suggestion is ready to be processed: <> by <>.\n\nThank you,\n\n<>', 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <> <>', 'Discharge
\r\n\r\nThe library <> certifies that the following borrower :\r\n\r\n <> <>\r\n 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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<>
Checked out to <> <> <> <>
diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
index 37a0dfd114..e03aa21151 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 <> <>,\r\n\r\nVous nous avez suggéré l\'achat du document <> par <>.\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 : <>.\r\n\r\nMerci.\r\n\r\n<>','email'),
('suggestions','REJECTED','','Suggestion d\'achat rejetée',0,'Suggestion d\'achat rejetée','Bonjour <> <>,\r\n\r\nVous nous avez suggéré l\'achat du document <> par <>.\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 : <>\r\n\r\nPour toute question, veuillez nous contacter à l\'adresse suivante : <>.\r\n\r\nMerci.\r\n\r\n<>','email');
+INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
+VALUES ('suggestions','NEW_SUGGESTION','New suggestion','New suggestion','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type) VALUES
('members','DISCHARGE','','Quittance',0,'Quittance pour <> <>','Quittance\r\n\r\nLa bibliothèque <> certifie que l\'utilisateur suivant :\r\n\r\n<> <>\r\nCardnumber : <>\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 b30740b800..b3dfec24e5 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','<> <>,\n\nUne nouvelle suggestion est prête à être traitée : <> / <>.\n\nMerci,\n\n<>', 'email'),
('members', 'DISCHARGE', 'Quitus', 'Quitus pour <> <>', 'Quitus
\r\n\r\nLa librairie <> certifies que lecteur suivant :\r\n\r\n <> <>\r\n Numéro de carte : <>\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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Ticket de de prêt','Ticket de prêt', '<>
Prêts à <> <> <> <>
diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql
index 7684e2230a..adde2c45fb 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 <>.', 'e
('suggestions','TO_PROCESS','Notifica al proprietario del fondo', 'Un suggeerimento è pronto per essere lavorato','Caro bibliotecario <> <>,\n\n c\'è un nuovo suggerimento pronto per essere lavorato: <> by <>.\n\n Grazie dell\'attenzione,\n\n<>', 'email'),
('members', 'DISCHARGE', 'Liberatoria', 'Liberatoria per <> <>', 'Liberatoria
\r\n\r\nLa biblioteca <> certifica che il seguente utente :\r\n\r\n <> <>\r\n Numero tessera : <>\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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO letter (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Ricevuta di prestito','Ricevuta di prestito', '<>
Prestito a <> <> <> <>
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 5674f74b5e..794c797b0a 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','<> <>,\n\nA new suggestion is ready to be processed: <> by <>.\n\nThank you,\n\n<>', 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <> <>', 'Discharge
\r\n\r\nThe library <> certifies that the following borrower :\r\n\r\n <> <>\r\n 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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Utlån','Utlån', '<>
Utlånt til <> <> <> <>
diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
index cd55d8bf5b..115a6adc28 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 <> <>,\n\nA new suggestion is ready to be processed: <> by <>.\n\nThank you,\n\n<>', 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <> <>', 'Discharge
\r\n\r\nThe library <> certifies that the following borrower :\r\n\r\n <> <>\r\n 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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<>
Checked out to <> <> <> <>
diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
index 1a85fb119c..a979698dd1 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 <> <>,\n\nA new suggestion is ready to be processed: <> by <>.\n\nThank you,\n\n<>', 'email'),
('members', 'DISCHARGE', 'Discharge', 'Discharge for <> <>', 'Discharge
\r\n\r\nThe library <> certifies that the following borrower :\r\n\r\n <> <>\r\n 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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html)
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<>
Checked out to <> <> <> <>
diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
index 4cc4693faa..63319ad6e7 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','Suggestion pendin g approval
+ Suggested by
+
+
+ Title suggested
+
+ - Library: <>
+ - Title: <>
+ - Author: <>
+ - Copyright date: <>
+ - Standard number (ISBN, ISSN or other): <>
+ - Publisher: <>
+ - Collection title: <>
+ - Publication place: <>
+ - Quantity: <>
+ - Item type: <>
+ - Reason for suggestion: <>
+ - Notes: <>
+
+ ',1, 'email');
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type) VALUES
('members', 'DISCHARGE', 'пÑдÑвеÑÐ´Ð¶ÐµÐ½Ð½Ñ Ð½Ð° ÑозÑаÑ
ÑваннÑ',
'РозÑаÑ
ÑÐ²Ð°Ð½Ð½Ñ Ð´Ð»Ñ Ð²ÑдвÑдÑваÑа â <> <>', '
--
2.39.5