From 92aa2c577c8d0e51bbff4199e37d996ed3745d9e Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Tue, 29 Nov 2016 15:14:31 +0100 Subject: [PATCH] Bug 17703 - Add ISSN column in serials claims table - fix Bug 11861 added ISSN column in serials claims table, in a SQL query in C4::Serials::GetLateOrMissingIssues(). But this SQL query is in a if condition, the same change must be done in the else case. Test plan: - Make sure you have a subscription with some late issues - Go to serials claims page /cgi-bin/koha/serials/claims.pl - Choose a vendor and click OK => You should see a ISSN column, filled with subscription ISSN --- C4/Serials.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index b4897c2..79c5657 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -1856,12 +1856,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, claims_count, 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 ($missing_statuses_string) OR ((planneddate < now() AND serial.STATUS = ?) OR serial.STATUS = ? OR serial.STATUS = ?)) -- 2.7.4