From babafda93b82a982d15f7682fd272fde479a3292 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 31 May 2013 12:32:29 +0200 Subject: [PATCH] Bug 9032: Share a list (database revision for notices) Content-Type: text/plain; charset=utf-8 Adds notice SHARE_INVITE in updatedatabase and sample_notices. [Amendation: also adds SHARE_ACCEPT notice.] Test plan: Install or upgrade and verify that you have the new notice under Tools. Signed-off-by: Owen Leonard Signed-off-by: Marcel de Rooy Rebased on March 3, 2014. Amended the patch to add the second notice SHARE_ACCEPT. Tested upgrade with updatestructure step of web installer. Tested install by deleting all notices and running sample_notices.sql NOTE: Will add the notices to the other sql files in the other language directories as soon as this set of patches is ready to be pushed in order to reduce the need to rebase them constantly. --- .../data/mysql/en/mandatory/sample_notices.sql | 25 ++++++++++++++ installer/data/mysql/updatedatabase.pl | 34 ++++++++++++++++++++ 2 files changed, 59 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql index 2d09971..d385bb7 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ b/installer/data/mysql/en/mandatory/sample_notices.sql @@ -117,3 +117,28 @@ http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' +); +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' +); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 125a668..034d5c2 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8056,6 +8056,40 @@ if ( CheckVersion($DBversion) ) { SetVersion ($DBversion); } +$DBversion = "3.15.00.XXX"; +if ( CheckVersion($DBversion) ) { + #insert a notice for sharing a list and accepting a share + $dbh->do(" +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <>', 'Dear patron, + +One of our patrons, <> <>, invites you to share his list <> in our library catalog. + +To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar. + +<> + +In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks. + +Thank you. + +Your library.' + )"); + $dbh->do(" +INSERT INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <> accepted', 'Dear patron, + +We want to inform you that <> <> accepted your invitation to share your list <> in our library catalog. + +Thank you. + +Your library.' + )"); + print "Upgrade to $DBversion done (Bug 9032: Share a list)\n"; + SetVersion($DBversion); +} + + =head1 FUNCTIONS =head2 TableExists($table) -- 1.7.7.6