MT 2360 : Adds address, city and zipcode to overdues csv export
authorkoha user <koha@copernic.biblibre.com>
Tue, 1 Dec 2009 14:29:03 +0000 (15:29 +0100)
committerHenri-Damien LAURENT <henridamien.laurent@biblibre.com>
Thu, 3 Dec 2009 21:30:45 +0000 (22:30 +0100)
Signed-off-by: Henri-Damien LAURENT <henridamien.laurent@biblibre.com>
circ/overdue.pl

index 7ca21e5..2140206 100755 (executable)
@@ -115,6 +115,9 @@ $bornamefilter =~s/\?/\_/g;
 
 my $strsth="SELECT date_due,
   concat(surname,' ', firstname) as borrower, 
+  borrowers.address,
+  borrowers.city,
+  borrowers.zipcode,
   borrowers.phone,
   borrowers.email,
   issues.itemnumber,
@@ -157,6 +160,9 @@ while (my $data=$sth->fetchrow_hashref) {
         barcode        => $data->{barcode},
         itemnum        => $data->{itemnumber},
         name           => $data->{borrower},
+        address        => $data->{address},
+        city           => $data->{city},
+        zipcode        => $data->{zipcode},
         phone          => $data->{phone},
         email          => $data->{email},
         biblionumber   => $data->{biblionumber},