From a5aadae0a49bdcfbfc837079541c166f2d8ee71e Mon Sep 17 00:00:00 2001
From: Garry Collum <gcollum@gmail.com>
Date: Sun, 9 Aug 2009 16:28:08 -0400
Subject: [PATCH] Bug 3292: Fix to display Branch names instead of branch codes
 in opac serial's displays.

Fixes display of branch name in opac-full-serial-issues.tmpl and opac-serial-issues.tmpl.  Also enables zebra striping in opac-serial-issues.

Signed-off-by: Galen Charlton <gmcharlt@gmail.com>
Signed-off-by: Henri-Damien LAURENT <henridamien.laurent@biblibre.com>
---
 C4/Serials.pm                                             | 2 ++
 .../prog/en/modules/opac-full-serial-issues.tmpl          | 8 ++++++--
 .../opac-tmpl/prog/en/modules/opac-serial-issues.tmpl     | 2 +-
 3 files changed, 9 insertions(+), 3 deletions(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 2bc39dc479..56558596df 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -588,6 +588,7 @@ sub GetFullSubscriptionsFromBiblionumber {
             aqbudget.bookfundid,aqbooksellers.name as aqbooksellername,
             biblio.title as bibliotitle,
             subscription.branchcode AS branchcode,
+            branches.branchname AS branchname,
             subscription.subscriptionid AS subscriptionid|;
      if (C4::Context->preference('IndependantBranches') && 
         C4::Context->userenv && 
@@ -602,6 +603,7 @@ sub GetFullSubscriptionsFromBiblionumber {
           (serial.subscriptionid=subscription.subscriptionid)
   LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid 
   LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id 
+  LEFT JOIN branches ON branches.branchcode=subscription.branchcode
   LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber 
   WHERE     subscription.biblionumber = ? 
   ORDER BY year DESC,
diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-full-serial-issues.tmpl b/koha-tmpl/opac-tmpl/prog/en/modules/opac-full-serial-issues.tmpl
index f8318b540d..58582320ba 100644
--- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-full-serial-issues.tmpl
+++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-full-serial-issues.tmpl
@@ -41,11 +41,15 @@
                 <th>Status
                 </th>
             </tr>
-            <!-- TMPL_LOOP Name="serials" -->
+        <!-- TMPL_LOOP Name="serials" -->
+            <!-- TMPL_UNLESS Name="__odd__" -->
+            <tr class="highlight">
+            <!-- TMPL_ELSE --> 
             <tr>
+            <!-- /TMPL_UNLESS -->
                 <td>    <!-- TMPL_VAR Name="publisheddate" -->
                 </td>
-                <td>    <!-- TMPL_VAR name="branchcode" -->
+                <td>    <!-- TMPL_VAR name="branchname" -->
                 </td>
                 <td>    <!-- TMPL_VAR name="notes" -->
                 </td>
diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-serial-issues.tmpl b/koha-tmpl/opac-tmpl/prog/en/modules/opac-serial-issues.tmpl
index 56b5cdbe75..1a71cf9057 100644
--- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-serial-issues.tmpl
+++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-serial-issues.tmpl
@@ -83,7 +83,7 @@
             <p>The subscription expired on <!-- TMPl_VAR name="histenddate" --></p>
         <!-- /TMPL_IF -->
 		</p>
-    <h2><!-- TMPL_VAR name="branchcode" --> <!-- TMPL_VAR name="notes" --></h2>
+    <h2><!-- TMPL_VAR name="branchname" --> <!-- TMPL_VAR name="notes" --></h2>
   <!-- TMPL_IF name="recievedlist" -->
     <h3>Available Issues</h3>
     <p>
-- 
2.39.5