From 73d45ee3d5da055feba21a55dcf3876df2501434 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Nazl=C4=B1=20=C3=87etin?=
Date: Wed, 19 Dec 2018 12:18:22 +0000
Subject: [PATCH] Bug 5770: Notify for new suggestion - sample notices
Signed-off-by: Nick Clemens
---
.../data/mysql/de-DE/mandatory/sample_notices.sql | 27 ++++++++++++++++++++++
.../data/mysql/en/mandatory/sample_notices.sql | 27 ++++++++++++++++++++++
.../data/mysql/es-ES/mandatory/sample_notices.sql | 27 ++++++++++++++++++++++
.../mysql/fr-CA/obligatoire/sample_notices.sql | 27 ++++++++++++++++++++++
.../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 27 ++++++++++++++++++++++
installer/data/mysql/it-IT/necessari/notices.sql | 27 ++++++++++++++++++++++
.../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 27 ++++++++++++++++++++++
.../data/mysql/pl-PL/mandatory/sample_notices.sql | 27 ++++++++++++++++++++++
.../data/mysql/ru-RU/mandatory/sample_notices.sql | 27 ++++++++++++++++++++++
.../data/mysql/uk-UA/mandatory/sample_notices.sql | 26 +++++++++++++++++++++
10 files changed, 269 insertions(+)
diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
index 3a43322d15..e474592c2e 100644
--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql
+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql
@@ -22,6 +22,33 @@ VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <
('suggestions','TO_PROCESS','Benachrichtigung an Besitzer des Kontos', '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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 <> <>', '
<>
Entlastungsbescheinigung
diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql
index aa90881994..7551a2b796 100644
--- a/installer/data/mysql/en/mandatory/sample_notices.sql
+++ b/installer/data/mysql/en/mandatory/sample_notices.sql
@@ -22,6 +22,33 @@ VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 <> <>', '
<>
Discharge confirmation
diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
index 9caa94d22b..2f45cd84c7 100644
--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql
+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql
@@ -21,6 +21,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 2cb0386b01..2e2862fcaf 100644
--- a/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
+++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices.sql
@@ -24,6 +24,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 5759fb857c..3c087ce611 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,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 fdf776ee7d..1395c04165 100644
--- a/installer/data/mysql/it-IT/necessari/notices.sql
+++ b/installer/data/mysql/it-IT/necessari/notices.sql
@@ -28,6 +28,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 aaf9fc1571..6cccadfbdb 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,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 65fefd00ae..a44436af38 100644
--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql
@@ -22,6 +22,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 b2bae27313..8bb7c19606 100644
--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql
@@ -21,6 +21,33 @@ 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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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 c1e15ff54c..0c83a7ef2b 100644
--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql
@@ -84,6 +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 pending approval
+Suggested by
+
+
+Item on suggestion
+
+ - 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.11.0