(bug #4334) create needed sample datas

This add samplenotices.sql that disappear, and add in fr-FR:
* sample_notices_message_attributes.sql
* sample_notices_message_transports.sql

diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql
new file mode 100644 (file)
index 0000000..25be5d7
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_notices.sql
@@ -0,0 +1,52 @@
+INSERT INTO `letter`
+(module, code, name, title, content)
+VALUES
+('circulation','ODUE','Overdue Notice','Item Overdue','Dear 
+<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nAccording to our current 
+records, you have items that are overdue.Your library does not charge late 
+fines, but please return orrenew them as soon as 
+possible.\r\n\r\n<<branches.branchname>><<branches.branchaddress1>><<branches.branchaddress2>><<branches.branchaddress3>><<branches.branchphone>><<branches.branchfax>><<branches.branchemail>>If
+ you have registered a password with the library, you may use it withyour 
+library card number to renew online. If an item becomes more than 30 days 
+overdue, you will be unable to use your library card until the item is 
+returned. The following item is currently overdue:\r\n\r\n<<items.content>>'),
+('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not 
+Received','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\nOrdernumber
+ <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered) 
+($<<aqorders.listprice>> each) has not been received.'),
+('serial','RLIST','Routing List','Serial is now 
+available','<<borrowers.firstname>> <<borrowers.title>>,\r\n\r\nThe following 
+issue is now available:\r\n\r\n<<items.content>>\r\n\r\nPlease pick it up at 
+your convenience.'),
+('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha 
+account details.','Hello <<borrowers.title>> <<borrowers.firstname>> 
+<<borrowers.surname>>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser:  
+<<borrowers.userid>>\r\nPassword: <<borrowers.password>>\r\n\r\nIf you have any 
+problems or questions regarding your account, please contact your Koha 
+Administrator.\r\n\r\nThank you,\r\nKoha 
+administrator\r\nkohaad...@yoursite.org'),
+('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear 
+<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now 
+due:\r\n\r\n<<items.content>>'),
+('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You 
+have <<count>> items due'),
+('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item 
+Due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following 
+item will be due soon:\r\n\r\n<<items.content>>'),
+('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance 
+Notice of Item Due','You have <<count>> items due soon'),
+('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear 
+<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThis is a reminder of an 
+upcoming library event in which you have expressed interest.'),
+('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup 
+at <<branches.branchname>>', 'Dear <<borrowers.firstname>> 
+<<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of 
+<<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: 
+<<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: 
+<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>'),
+('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
+items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
+('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
+items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
+for visiting <<branches.branchname>>.');
+

diff --git a/installer/data/mysql/en/mandatory/sample_notices.txt b/installer/data/mysql/en/mandatory/sample_notices.txt
new file mode 100644 (file)
index 0000000..6f87af8
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_notices.txt
@@ -0,0 +1 @@
+Sample Notices
\ No newline at end of file

diff --git a/installer/data/mysql/en/optional/sample_notices_message_transports.sql b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
index 594da45..5aa2996 100644 (file)
--- a/installer/data/mysql/en/optional/sample_notices_message_transports.sql
+++ b/installer/data/mysql/en/optional/sample_notices_message_transports.sql
@@ -12,7 +12,7 @@ values
 (2, 'sms',   0, 'circulation', 'PREDUE'),
 (2, 'sms',   1, 'circulation', 'PREDUEDGST'),
 (3, 'sms',   0, 'circulation', 'EVENT'),
-(4, 'sms',   0, 'reserves',    'HOLD');
+(4, 'sms',   0, 'reserves',    'HOLD'),
 (4, 'sms',   0, 'reserves',    'HOLD'),
 (5, 'email', 0, 'circulation', 'CHECKIN'),
 (5, 'sms',   0, 'circulation', 'CHECKIN'),

diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
new file mode 100644 (file)
index 0000000..25be5d7
--- /dev/null
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql
@@ -0,0 +1,52 @@
+INSERT INTO `letter`
+(module, code, name, title, content)
+VALUES
+('circulation','ODUE','Overdue Notice','Item Overdue','Dear 
+<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nAccording to our current 
+records, you have items that are overdue.Your library does not charge late 
+fines, but please return orrenew them as soon as 
+possible.\r\n\r\n<<branches.branchname>><<branches.branchaddress1>><<branches.branchaddress2>><<branches.branchaddress3>><<branches.branchphone>><<branches.branchfax>><<branches.branchemail>>If
+ you have registered a password with the library, you may use it withyour 
+library card number to renew online. If an item becomes more than 30 days 
+overdue, you will be unable to use your library card until the item is 
+returned. The following item is currently overdue:\r\n\r\n<<items.content>>'),
+('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not 
+Received','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\nOrdernumber
+ <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> ordered) 
+($<<aqorders.listprice>> each) has not been received.'),
+('serial','RLIST','Routing List','Serial is now 
+available','<<borrowers.firstname>> <<borrowers.title>>,\r\n\r\nThe following 
+issue is now available:\r\n\r\n<<items.content>>\r\n\r\nPlease pick it up at 
+your convenience.'),
+('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha 
+account details.','Hello <<borrowers.title>> <<borrowers.firstname>> 
+<<borrowers.surname>>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser:  
+<<borrowers.userid>>\r\nPassword: <<borrowers.password>>\r\n\r\nIf you have any 
+problems or questions regarding your account, please contact your Koha 
+Administrator.\r\n\r\nThank you,\r\nKoha 
+administrator\r\nkohaad...@yoursite.org'),
+('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear 
+<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now 
+due:\r\n\r\n<<items.content>>'),
+('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You 
+have <<count>> items due'),
+('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item 
+Due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following 
+item will be due soon:\r\n\r\n<<items.content>>'),
+('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance 
+Notice of Item Due','You have <<count>> items due soon'),
+('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear 
+<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThis is a reminder of an 
+upcoming library event in which you have expressed interest.'),
+('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup 
+at <<branches.branchname>>', 'Dear <<borrowers.firstname>> 
+<<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of 
+<<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: 
+<<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: 
+<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>'),
+('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following 
+items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'),
+('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following 
+items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you 
+for visiting <<branches.branchname>>.');
+

diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt
new file mode 100644 (file)
index 0000000..6f87af8
--- /dev/null
+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt
@@ -0,0 +1 @@
+Sample Notices
\ No newline at end of file

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
new file mode 100644 (file)
index 0000000..8f89ff7
--- /dev/null
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql
@@ -0,0 +1,8 @@
+insert into `message_attributes`
+(`message_attribute_id`, message_name, `takes_days`)
+values
+(1, 'Item DUE', 0),
+(2, 'Advance Notice', 1),
+(3, 'Upcoming Events', 1),
+(4, 'Hold Filled', 0);
+

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
new file mode 100644 (file)
index 0000000..770bcac
--- /dev/null
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt
@@ -0,0 +1,2 @@
+defines default messages for items due, advance notices, and upcoming library events.
+

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
new file mode 100644 (file)
index 0000000..5aa2996
--- /dev/null
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql
@@ -0,0 +1,21 @@
+insert into `message_transports`
+(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
+values
+(1, 'email', 0, 'circulation', 'DUE'),
+(1, 'email', 1, 'circulation', 'DUEDGST'),
+(2, 'email', 0, 'circulation', 'PREDUE'),
+(2, 'email', 1, 'circulation', 'PREDUEDGST'),
+(3, 'email', 0, 'circulation', 'EVENT'),
+(4, 'email', 0, 'reserves',    'HOLD'),
+(1, 'sms',   0, 'circulation', 'DUE'),
+(1, 'sms',   1, 'circulation', 'DUEDGST'),
+(2, 'sms',   0, 'circulation', 'PREDUE'),
+(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
+(3, 'sms',   0, 'circulation', 'EVENT'),
+(4, 'sms',   0, 'reserves',    'HOLD'),
+(4, 'sms',   0, 'reserves',    'HOLD'),
+(5, 'email', 0, 'circulation', 'CHECKIN'),
+(5, 'sms',   0, 'circulation', 'CHECKIN'),
+(6, 'email', 0, 'circulation', 'CHECKOUT'),
+(6, 'sms',   0, 'circulation', 'CHECKOUT');
+

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
new file mode 100644 (file)
index 0000000..18e3431
--- /dev/null
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt
@@ -0,0 +1,3 @@
+Defines default message transports for sending item due messages,
+advance notice messages, and library event messages through email
+and SMS.