From ec9c797776a5e524e9f536ca80532c6e0d502712 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(+), 0 deletions(-) create mode 100644 koha-tmpl/opac-tmpl/prog/en/includes/goodreadsreviews.inc diff --git a/C4/Auth.pm b/C4/Auth.pm index efe1200..c370de2 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 e3966ce..2929606 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -421,3 +421,4 @@ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES( INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('PatronSelfRegistrationAdditionalInstructions','','A free text field to display additional instructions to newly self registered patrons.','','free'); INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UseQueryParser', '0', 'If enabled, try to use QueryParser for queries.', NULL, 'YesNo'); INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('FinesIncludeGracePeriod','1','If enabled, fines calculations will include the grace period.',NULL,'YesNo'); +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 f0a9269..53caeec 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -6502,6 +6502,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 74e6553..b9f0553 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 @@ -319,3 +319,15 @@ Enhanced Content: - pref: HTML5MediaExtensions class: multi - (separated with |). + 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 6321efd..396b602 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.2.5