Attachment 26143 Details for Bug 11861 – [PASSED QA] Bug 11861: Add ISSN column in serials claims table

[patch] [PASSED QA] Bug 11861: Add ISSN column in serials claims table

PASSED-QA-Bug-11861-Add-ISSN-column-in-serials-cla.patch (text/plain), 2.78 KB, created by Katrin Fischer on 2014-03-12 09:12:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2014-03-12 09:12:20 UTC

Size: 2.78 KB

patch

obsolete

>From cabb348086cd11517521f925049afa638270201b 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] [PASSED QA] 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
>---
> 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 83fdcf3..407482a 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>
>@@ -283,6 +284,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.8.3.2

Actions: View | Diff | Splinter Review

Attachments on bug 11861: 25691 | 26143