From fa6672f8196d8de7426d369ac62863c748996828 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Tue, 12 Mar 2013 21:40:46 +1300 Subject: [PATCH] Bug 9817 Add Goodreads reviews to OPAC To test 1/ Go to systempreferences and turn on goodreads reviews 2/ Search for a book in your opac, that is likely to be in Goodreads, and that has an isbn 3/ Look in the opac detail page for a good reads review tab Should work in both prog and ccsr Signed-off-by: Liz Rea Very lovely! Note: fixed a paste error in the database update description. Signed-off-by: Mirko Tietgen Tested both themes, looks alright --- C4/Auth.pm | 2 + installer/data/mysql/sysprefs.sql | 1 + installer/data/mysql/updatedatabase.pl | 11 +++++ .../admin/preferences/enhanced_content.pref | 12 ++++++ .../prog/en/includes/goodreadsreviews.inc | 43 ++++++++++++++++++++ koha-tmpl/opac-tmpl/prog/en/modules/opac-detail.tt | 9 ++++ 6 files changed, 78 insertions(+) create mode 100644 koha-tmpl/opac-tmpl/prog/en/includes/goodreadsreviews.inc diff --git a/C4/Auth.pm b/C4/Auth.pm index ca061b5..05b359e 100644 --- a/C4/Auth.pm +++ b/C4/Auth.pm @@ -336,6 +336,8 @@ sub get_template_and_user { noItemTypeImages => C4::Context->preference("noItemTypeImages"), marcflavour => C4::Context->preference("marcflavour"), persona => C4::Context->preference("persona"), + GoodReadsReviews => C4::Context->preference("GoodReadsReviews"), + GoodReadsKey => C4::Context->preference("GoodReadsKey"), ); if ( $in->{'type'} eq "intranet" ) { $template->param( diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index 5d536c5..f6b2c7b 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -423,3 +423,4 @@ INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ( INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('DisplayIconsXSLT', '1', '', 'If ON, displays the format, audience, and material type icons in XSLT MARC21 results and detail pages.', 'YesNo'); INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('HighlightOwnItemsOnOPAC','0','','If on, and a patron is logged into the OPAC, items from his or her home library will be emphasized and shown first in search results and item details.','YesNo'); INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('HighlightOwnItemsOnOPACWhich','PatronBranch','PatronBranch|OpacURLBranch','Decides which branch''s items to emphasize. If PatronBranch, emphasize the logged in user''s library''s items. If OpacURLBranch, highlight the items of the Apache var BRANCHCODE defined in Koha''s Apache configuration file.','Choice') +INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('GoodReadsReviews','0','Show Goodreads Reviews','','YesNo'); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 6285633..f324c34 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6499,6 +6499,17 @@ if ( CheckVersion($DBversion) ) { AND user_permissions.code = 'circulate_remaining_permissions' }); print "Upgrade to $DBversion done ( Add circ permission overdues_report )\n"; +} + +$DBversion = "3.11.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do( + qq{ +INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('GoodReadsReviews','0','Show Goodreads Reviews','','YesNo'); + } + ); + print +"Upgrade to $DBversion done (Bug 9817: Add GoodReads Reviews to OPAC)\n"; SetVersion($DBversion); } diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref index ba6a6ac..c009eba 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref @@ -326,3 +326,15 @@ Enhanced Content: yes: Enable no: "Don't enable" - the ability to use Koha Plugins. Note, the plugin system must also be enabled in the Koha configuration file to be fully enabled. + Good Reads: + - + - Good reads API key + - pref: GoodReadsKey + class: password + - you can get a key from http://www.goodreads.com/api/keys + - + - pref: GoodReadsReviews + choices: + yes: "Show" + no: "Don't show" + - a tab in the holdings section in the OPAC for Goodreads reviews diff --git a/koha-tmpl/opac-tmpl/prog/en/includes/goodreadsreviews.inc b/koha-tmpl/opac-tmpl/prog/en/includes/goodreadsreviews.inc new file mode 100644 index 0000000..48dda68 --- /dev/null +++ b/koha-tmpl/opac-tmpl/prog/en/includes/goodreadsreviews.inc @@ -0,0 +1,43 @@ + +
+
+

Goodreads reviews for [% title |html %]

+ + +
+
diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-detail.tt b/koha-tmpl/opac-tmpl/prog/en/modules/opac-detail.tt index 2617b54..b9b2124 100644 --- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-detail.tt +++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-detail.tt @@ -976,6 +976,11 @@ YAHOO.util.Event.onContentReady("furtherm", function () { [% IF ( IDreamBooksReviews ) %] [% END %] + +[% IF GoodReadsReviews %] +
  • Goodreads Reviews
  • +[% END %] + [% IF ( serialcollection ) %] @@ -1324,6 +1329,10 @@ YAHOO.util.Event.onContentReady("furtherm", function () { [% END %] +[% IF GoodReadsReviews %] + [% INCLUDE 'goodreadsreviews.inc' %] +[% END %] + [% IF ( OPACLocalCoverImages && localimages.size ) %]

    Click on an image to view it in the image viewer

    -- 1.7.10.4