From f7b29294a772a4cd05e58752ed8579b360cec5c5 Mon Sep 17 00:00:00 2001 From: Alex Arnaud Date: Thu, 7 Apr 2011 15:05:05 +0200 Subject: [PATCH] Bug #6112 - Missing fields in overdues csv file --- circ/overdue.pl | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/circ/overdue.pl b/circ/overdue.pl index 3510a2b..f801644 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}, -- 1.6.3.3