From 913d520be7fddb8664753fa202f4f0362634c833 Mon Sep 17 00:00:00 2001 From: Alex Arnaud Date: Thu, 7 Apr 2011 16:30:13 +0200 Subject: [PATCH] Bug #6112 - Missing fields in overdues csv file Signed-off-by: Christophe Croullebois Signed-off-by: Chris Cormack --- circ/overdue.pl | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/circ/overdue.pl b/circ/overdue.pl index 3510a2be5a..f801644358 100755 --- a/circ/overdue.pl +++ b/circ/overdue.pl @@ -229,7 +229,15 @@ if ($noreport) { $bornamefilter =~s/\?/\_/g; my $strsth="SELECT date_due, + borrowers.title as borrowertitle, concat(surname,' ', firstname) as borrower, + borrowers.streetnumber, + borrowers.streettype, + borrowers.address, + borrowers.address2, + borrowers.city, + borrowers.zipcode, + borrowers.country, borrowers.phone, borrowers.email, issues.itemnumber, @@ -290,7 +298,15 @@ if ($noreport) { borrowernumber => $data->{borrowernumber}, barcode => $data->{barcode}, itemnum => $data->{itemnumber}, + borrowertitle => $data->{borrowertitle}, name => $data->{borrower}, + streetnumber => $data->{streetnumber}, + streettype => $data->{streettype}, + address => $data->{address}, + address2 => $data->{address2}, + city => $data->{city}, + zipcode => $data->{zipcode}, + country => $data->{country}, phone => $data->{phone}, email => $data->{email}, biblionumber => $data->{biblionumber}, -- 2.39.5