From: Nahuel ANGELINETTI <nahuel.angelinetti@biblibre.com>
Date: Tue, 19 Jan 2010 11:00:42 +0000 (+0100)
Subject: (bug #4051) add columns in csv export of overdues
X-Git-Tag: v3.00.06~95
X-Git-Url: http://git.rot13.org/?p=koha.git;a=commitdiff_plain;h=846bef3f8590bf5c0cd253b5e1a2aa8a8517dc73

(bug #4051) add columns in csv export of overdues

this patch add 2 columns in the csv export :
* item callnumber
* issue date
---

diff --git a/circ/overdue.pl b/circ/overdue.pl
index 2140206b66..2360028e0e 100755
--- a/circ/overdue.pl
+++ b/circ/overdue.pl
@@ -121,7 +121,9 @@ my $strsth="SELECT date_due,
   borrowers.phone,
   borrowers.email,
   issues.itemnumber,
+  issues.issuedate,
   items.barcode,
+  items.itemcallnumber,
   biblio.title,
   biblio.author,
   borrowers.borrowernumber,
@@ -155,10 +157,12 @@ $sth->execute();
 my @overduedata;
 while (my $data=$sth->fetchrow_hashref) {
     push @overduedata, {
+        issuedate      => format_date($data->{issuedate}),
         duedate        => format_date($data->{date_due}),
         borrowernumber => $data->{borrowernumber},
         barcode        => $data->{barcode},
         itemnum        => $data->{itemnumber},
+        itemcallnumber => $data->{itemcallnumber},
         name           => $data->{borrower},
         address        => $data->{address},
         city           => $data->{city},