From c5309f68b0547d82f0e7b4a05f856a6f4fc274fe 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: 1/ Go to serials claims page 2/ Do not choose a vendor and submit 3/ 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 543b1dc..51acc64 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