From 420561045f08bc68d19e0a01c8562ceee92907c5 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Tue, 7 Jan 2014 15:24:58 +0100 Subject: [PATCH] Bug 11861: Add ISSN column in serials claims table --- C4/Serials.pm | 3 ++- koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt | 4 ++++ 2 files changed, 6 insertions(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 2fb639b..6c035d5 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -2027,12 +2027,13 @@ sub GetLateOrMissingIssues { $sth = $dbh->prepare( "SELECT serialid, aqbooksellerid, name, - biblio.title, planneddate, serialseq, + biblio.title, biblioitems.issn, planneddate, serialseq, serial.status, serial.subscriptionid, claimdate, subscription.branchcode FROM serial LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber + LEFT JOIN biblioitems ON subscription.biblionumber=biblioitems.biblionumber LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id WHERE subscription.subscriptionid = serial.subscriptionid AND (serial.STATUS IN (4, 41, 42, 43, 44) OR ((planneddate < now() AND serial.STATUS =1) OR serial.STATUS = 3 OR serial.STATUS = 7)) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt index 288620b..0a78f0c 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt @@ -265,6 +265,7 @@ Vendor Library Title + ISSN Issue number Status Since @@ -287,6 +288,9 @@ [% missingissue.title |html %] + [% missingissue.issn %] + + [% missingissue.serialseq %] -- 1.7.10.4