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

Nahuel ANGELINETTI nahuel.angelinetti at biblibre.com
Wed Jan 20 10:08:32 CET 2010


this add the borrower title, and the complete address.
---
 circ/overdue.pl |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

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




More information about the Koha-patches mailing list