[followup](bug #4051) add borrower "title", and complete address in csv

this add the borrower title, and the complete address.

diff --git a/circ/overdue.pl b/circ/overdue.pl
index 0b2780b..2e22e6d 100755 (executable)
--- 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},