Bugzilla – Attachment 65454 Details for
Bug 17703
Always export ISSN in serials claims issues CSV
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17703 - Add ISSN column in serials claims table - fix
Bug-17703---Add-ISSN-column-in-serials-claims-tabl.patch (text/plain), 1.87 KB, created by
Fridolin Somers
on 2017-08-03 08:44:11 UTC
(
hide
)
Description:
Bug 17703 - Add ISSN column in serials claims table - fix
Filename:
MIME Type:
Creator:
Fridolin Somers
Created:
2017-08-03 08:44:11 UTC
Size:
1.87 KB
patch
obsolete
>From 92aa2c577c8d0e51bbff4199e37d996ed3745d9e Mon Sep 17 00:00:00 2001 >From: Fridolin Somers <fridolin.somers@biblibre.com> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 17703
:
57832
|
65454
|
65455
|
66150
|
101994
|
101996
|
101997
|
102000
|
102001
|
102197
|
102199
|
119444
|
119445
|
119446