From 420561045f08bc68d19e0a01c8562ceee92907c5 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

---
 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 2fb639b..6c035d5 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 288620b..0a78f0c 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/serials/claims.tt
@@ -265,6 +265,7 @@
                     <th>Vendor</th>
                     <th>Library</th>
                     <th>Title</th>
+                    <th>ISSN</th>
                     <th>Issue number</th>
                     <th>Status</th>
                     <th>Since</th>
@@ -287,6 +288,9 @@
                         <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>
                         <td>
-- 
1.7.10.4