From 65b62137fcd9101abadb79ca521281854b0ed055 Mon Sep 17 00:00:00 2001
From: Julian Maurice <julian.maurice@biblibre.com>
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 <koha@univ-lyon3.fr>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Added Sign off line.
Passes all tests and QA script, including t/db_dependent/Serials.t

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
---
 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 @@
                     <th>Vendor</th>
                     <th>Library</th>
                     <th>Title</th>
+                    <th>ISSN</th>
                     <th>Issue number</th>
                     <th>Status</th>
                     <th>Since</th>
@@ -282,6 +283,9 @@
                         <td>
                         <a href="/cgi-bin/koha/serials/subscription-detail.pl?subscriptionid=[% missingissue.subscriptionid %]">[% missingissue.title |html %]</a>
                         </td>
+                        <td>
+                          [% missingissue.issn %]
+                        </td>
                         <td>
                         [% missingissue.serialseq %]
                         </td>
-- 
2.39.5