From d52221b316b86d9d239706ebc8854eacb9ac5b8d Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 20 Jan 2010 10:06:15 +0100 Subject: [PATCH] [followup](bug #4051) add borrower "title", and complete address in csv this add the borrower title, and the complete address. --- circ/overdue.pl | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/circ/overdue.pl b/circ/overdue.pl index 0b2780b026..2e22e6d433 100755 --- a/circ/overdue.pl +++ b/circ/overdue.pl @@ -116,7 +116,8 @@ $bornamefilter =~s/\?/\_/g; my $strsth="SELECT date_due, surname, firstname, - borrowers.address, + borrowers.title as borrowertitle, + CONCAT(borrowers.address, '\n', borrowers.address2) as address, borrowers.city, borrowers.zipcode, borrowers.phone, @@ -162,6 +163,7 @@ while (my $data=$sth->fetchrow_hashref) { duedate => format_date($data->{date_due}), surname => $data->{surname}, firstname => $data->{firstname}, + borrowertitle => $data->{borrowertitle}, borrowernumber => $data->{borrowernumber}, barcode => $data->{barcode}, itemnum => $data->{itemnumber}, -- 2.39.5