From f13f1a17b1692cbeddbbb163390df2f38d48dd80 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 16 Dec 2014 08:10:02 -0500 Subject: [PATCH] Bug 12933 - Add new OVERDUES_SLIP letter Signed-off-by: Amy Purvis Signed-off-by: Laurie McKee --- .../data/mysql/de-DE/mandatory/sample_notices.sql | 6 ++++++ .../data/mysql/en/mandatory/sample_notices.sql | 5 +++++ .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 5 +++++ .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 5 +++++ .../data/mysql/pl-PL/mandatory/sample_notices.sql | 5 +++++ .../data/mysql/ru-RU/mandatory/sample_notices.sql | 5 +++++ .../data/mysql/uk-UA/mandatory/sample_notices.sql | 5 +++++ installer/data/mysql/updatedatabase.pl | 13 +++++++++++++ 8 files changed, 49 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql index 01ae5d4..47cc9a6 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -131,3 +131,9 @@ Wir möchten Sie darüber informieren, dass der Benutzer <> Vielen Dank, Ihr Biblioheksteam' ); + +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql index 2281739..5162349 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ b/installer/data/mysql/en/mandatory/sample_notices.sql @@ -142,3 +142,8 @@ Thank you. Your library.' ); +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); 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 d66a2d4..0e17116 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql @@ -145,3 +145,8 @@ Thank you. Your library.' ); +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); 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 f1e8fb0..9bff24c 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql @@ -163,3 +163,8 @@ Thank you. Your library.' ); +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql index 50e0cd5..7bb8170 100644 --- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -145,3 +145,8 @@ Thank you. Your library.' ); +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql index a8d3046..d15ef8a 100644 --- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql +++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql @@ -145,3 +145,8 @@ Thank you. Your library.' ); +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql index db8976e..fab08d7 100644 --- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql +++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql @@ -144,3 +144,8 @@ Thank you. Your library.' ); +INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) +VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index c380800..5850b52 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9628,6 +9628,19 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } +$DBversion = "3.19.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type ) + VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue: + +"<>" by <>, <>, Barcode: <> Fine: <> +', 'print' ) + }); + print "Upgrade to $DBversion done (Bug 12933 - Add ability to print overdue slip from staff intranet)\n"; + SetVersion ($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 1.7.2.5