From 97bbf04757227f2a26a6f5b1b216d2bab8efbdc9 Mon Sep 17 00:00:00 2001
From: Chris Hall <chrish@catalyst.net.nz>
Date: Fri, 22 Mar 2013 15:33:50 +1300
Subject: [PATCH] bug 10356: improve display of serial issue dates in staff bib
 details page

This patch adds the date published to the subscriptions tab in the staff
interface bib display and renames the former "Date" column to
"Date arrived".

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
---
 C4/Serials.pm                                               | 3 ++-
 koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt | 4 +++-
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index 76d3fc7e5e..4589a70a99 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -841,7 +841,7 @@ sub GetLatestSerials {
     my $dbh = C4::Context->dbh;
 
     # status = 2 is "arrived"
-    my $strsth = "SELECT   serialid,serialseq, status, planneddate, notes
+    my $strsth = "SELECT   serialid,serialseq, status, planneddate, publisheddate, notes
                         FROM     serial
                         WHERE    subscriptionid = ?
                         AND      (status =2 or status=4)
@@ -853,6 +853,7 @@ sub GetLatestSerials {
     while ( my $line = $sth->fetchrow_hashref ) {
         $line->{ "status" . $line->{status} } = 1;                        # fills a "statusX" value, used for template status select list
         $line->{"planneddate"} = format_date( $line->{"planneddate"} );
+        $line->{"publisheddate"} = format_date( $line->{"publisheddate"} );
         push @serials, $line;
     }
 
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt
index 9ebb4cb026..b3a4240788 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt
@@ -631,7 +631,8 @@ function verify_images() {
             <table>
                 <tr>
                     <th>Issue #</th>
-                    <th>Date</th>
+                    <th>Date arrived</th>
+                    <th>Date published</th>
                     <th>Status</th>
                     <th>Note</th>
                 </tr>
@@ -639,6 +640,7 @@ function verify_images() {
                 <tr>
                     <td>[% latestserial.serialseq %]</td>
                     <td>[% latestserial.planneddate %]</td>
+                    <td>[% latestserial.publisheddate%]</td>
                     <td>
                       [% IF ( latestserial.status1 ) %]Expected[% END %]
                       [% IF ( latestserial.status2 ) %]Arrived[% END %]
-- 
2.39.5