From a5aadae0a49bdcfbfc837079541c166f2d8ee71e Mon Sep 17 00:00:00 2001 From: Garry Collum 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 Signed-off-by: Henri-Damien LAURENT --- 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 @@ Status - + + + + + - + 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 @@

The subscription expired on

-

+

Available Issues

-- 2.39.5