From d52221b316b86d9d239706ebc8854eacb9ac5b8d Mon Sep 17 00:00:00 2001
From: Nahuel ANGELINETTI <nahuel.angelinetti@biblibre.com>
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.20.1