From f528da361bc8a66c5002421dd585c1b55deeba9b Mon Sep 17 00:00:00 2001
From: =?UTF-8?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
---
.../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 <
('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 <> <>', '
<>
Entlastungsbescheinigung
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 <> <>,\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 <> <>', '
<>
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 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 <> <>,\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 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 <> <>,\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 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','<> <>,\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 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 <>.', '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 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','<> <>,\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 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 <> <>,\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 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 <> <>,\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 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','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.11.0