From 79b55d858efd4022405ee8c21d9a1dae2c2e17c6 Mon Sep 17 00:00:00 2001
From: Alex Arnaud <alex.arnaud@biblibre.com>
Date: Thu, 7 Apr 2011 16:30:13 +0200
Subject: [PATCH] Bug #6112 - Missing fields in overdues csv file

Signed-off-by: Christophe Croullebois <christophe.croullebois@biblibre.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
(cherry picked from commit 913d520be7fddb8664753fa202f4f0362634c833)

Signed-off-by: Chris Nighswonger <chris.nighswonger@gmail.com>
---
 circ/overdue.pl | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

diff --git a/circ/overdue.pl b/circ/overdue.pl
index cad8e6d571..4a0c32036b 100755
--- a/circ/overdue.pl
+++ b/circ/overdue.pl
@@ -228,7 +228,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,
@@ -289,7 +297,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},
-- 
2.20.1