Attachment 16119 Details for Bug 9817 – Bug 9817 Add Goodreads reviews to OPAC

[patch] Bug 9817 Add Goodreads reviews to OPAC

Bug-9817-Add-Goodreads-reviews-to-OPAC.patch (text/plain), 6.87 KB, created by Liz Rea on 2013-03-14 11:05:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Liz Rea

Created: 2013-03-14 11:05:46 UTC

Size: 6.87 KB

patch

obsolete

>From d10b93170e792341af7332db527fd71bd5220be4 Mon Sep 17 00:00:00 2001
>From: Chris Cormack <chris@bigballofwax.co.nz>
>Date: Tue, 12 Mar 2013 21:40:46 +1300
>Subject: [PATCH] Bug 9817 Add Goodreads reviews to OPAC
>Content-Type: text/plain; charset="utf-8"
>
>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 <liz@catalyst.net.nz>
>Very lovely!
>
>Note: fixed a paste error in the database update description.
>---
> C4/Auth.pm                                         |    2 +
> installer/data/mysql/sysprefs.sql                  |    1 +
> installer/data/mysql/updatedatabase.pl             |   12 ++++++
> .../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, 79 insertions(+)
> 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 cad409c..f0ebae9 100644
>--- a/installer/data/mysql/sysprefs.sql
>+++ b/installer/data/mysql/sysprefs.sql
>@@ -418,3 +418,4 @@ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('
> INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('Persona',0,'Use Mozilla Persona for login','','YesNo');
> INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacItemLocation','callnum','Show the shelving location of items in the opac','callnum|ccode|location','Choice');
> INSERT INTO systempreferences (variable,value,explanation,options,type)  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer');
>+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 317680a..8d8bd4a 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -6502,9 +6502,21 @@ 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);
> }
> 
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>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 @@
>+<style>
>+  #goodreads-widget {
>+    font-family: georgia, serif;
>+    padding: 18px 0;
>+    width:565px;
>+  }
>+  #goodreads-widget h1 {
>+    font-weight:normal;
>+    font-size: 16px;
>+    border-bottom: 1px solid #BBB596;
>+    margin-bottom: 0;
>+  }
>+  #goodreads-widget a {
>+    text-decoration: none;
>+    color:#660;
>+  }
>+  iframe{
>+    background-color: #fff;
>+  }
>+  #goodreads-widget a:hover { text-decoration: underline; }
>+  #goodreads-widget a:active {
>+    color:#660;
>+  }
>+  #gr_footer {
>+    width: 100%;
>+    border-top: 1px solid #BBB596;
>+    text-align: right;
>+  }
>+  #goodreads-widget .gr_branding{
>+    color: #382110;
>+    font-size: 11px;
>+    text-decoration: none;
>+    font-family: verdana, arial, helvetica, sans-serif;
>+  }
>+</style>
>+<div id="goodreadreviews">
>+<div id="goodreads-widget">
>+  <div id="gr_header"><h1>Goodreads reviews for [% title |html %]</h1></div>
>+  <iframe id="the_iframe" src="http://www.goodreads.com/api/reviews_widget_iframe?did=4504&format=html&header_text=Goodreads+reviews+for+[% title |uri %]&isbn=[% normalized_isbn %]&links=660&review_back=fff&stars=000&text=000" width="800" height="400" frameborder="0"></iframe>
>+  <div id="gr_footer">
>+  </div>
>+</div>
>+</div>
>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 ) %]
>     <li id='tab_idb_critic_reviews' style="display:none;"><a href='#idb_critic_reviews'>Book reviews by critics ( XXX )</a></li>
> [% END %]
>+
>+[% IF GoodReadsReviews %]
>+   <li id="tab_goodreadreviews"><a href="#goodreadreviews">Goodreads Reviews</a></li>
>+[% END %]
>+
> </ul>
> 
> [% IF ( serialcollection ) %]
>@@ -1324,6 +1329,10 @@ YAHOO.util.Event.onContentReady("furtherm", function () {
> </div>
> [% END %]
> 
>+[% IF GoodReadsReviews %]
>+    [% INCLUDE 'goodreadsreviews.inc' %]
>+[% END %]
>+
> [% IF ( OPACLocalCoverImages && localimages.size ) %]
> <div id="images">
> <p>Click on an image to view it in the image viewer</p>
>-- 
>1.7.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 9817: 16104 | 16119 | 16442 | 16826