From 65b62137fcd9101abadb79ca521281854b0ed055 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 Signed-off-by: Koha Team Lyon 3 Signed-off-by: Katrin Fischer Added Sign off line. Passes all tests and QA script, including t/db_dependent/Serials.t Signed-off-by: Galen Charlton --- 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 2fb639bb52..6c035d5d62 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 83fdcf3ecc..407482a063 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt @@ -263,6 +263,7 @@ Vendor Library Title + ISSN Issue number Status Since @@ -282,6 +283,9 @@ [% missingissue.title |html %] + + [% missingissue.issn %] + [% missingissue.serialseq %] -- 2.39.5