Bugzilla – Attachment 25847 Details for
Bug 9032
Share a list
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 9032: Share a list (database revision for notices)
Bug-9032-Share-a-list-database-revision-for-notice.patch (text/plain), 4.42 KB, created by
Marcel de Rooy
on 2014-03-05 14:27:54 UTC
(
hide
)
Description:
Bug 9032: Share a list (database revision for notices)
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2014-03-05 14:27:54 UTC
Size:
4.42 KB
patch
obsolete
>From c1a6feacc9ccac5affca6cbf5b3c68ac598647cf Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >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 <oleonard@myacpl.org> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >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 | 33 ++++++++++++++++++++ > 2 files changed, 58 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://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower > > If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.' > ); >+ >+INSERT INTO letter (module, code, branchcode, name, is_html, title, content) >+VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron, >+ >+One of our patrons, <<borrowers.firstname>> <<borrowers.surname>>, invites you to share his list <<listname>> 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. >+ >+<<shareurl>> >+ >+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 <<listname>> accepted', 'Dear patron, >+ >+We want to inform you that <<borrowers.firstname>> <<borrowers.surname>> accepted your invitation to share your list <<listname>> in our library catalog. >+ >+Thank you. >+ >+Your library.' >+); >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index c8e883f..2adfd84 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8012,6 +8012,39 @@ if ( C4::Context->preference("Version") < TransformToNum($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 <<listname>>', 'Dear patron, >+ >+One of our patrons, <<borrowers.firstname>> <<borrowers.surname>>, invites you to share his list <<listname>> 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. >+ >+<<shareurl>> >+ >+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 <<listname>> accepted', 'Dear patron, >+ >+We want to inform you that <<borrowers.firstname>> <<borrowers.surname>> accepted your invitation to share your list <<listname>> 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 9032
:
18260
|
18542
|
18543
|
18546
|
18547
|
18587
|
18619
|
18682
|
18692
|
19377
|
19378
|
19379
|
19394
|
19934
|
19935
|
25847
|
25848
|
25849
|
25850
|
25851
|
25852
|
25853
|
25862
|
25886
|
25893
|
26253
|
26291
|
26292
|
26293
|
26294
|
26295
|
26296
|
26297
|
26298
|
26299
|
26300
|
26302
|
26303
|
26351
|
26458
|
26509
|
26513
|
26577
|
26578
|
26579
|
26580
|
26581
|
26582
|
26583
|
26584
|
26585
|
26586
|
26587
|
26588