[Koha-patches] [PATCH] [followup](MT3160) fix address request

[Nahuel ANGELINETTI]

If any part of concat is null, all the address field is null.
Now we use IFNULL() from mysql.
---
 C4/Overdues.pm |    6 +++++-
 1 files changed, 5 insertions(+), 1 deletions(-)

diff --git a/C4/Overdues.pm b/C4/Overdues.pm
index d9bd420..2a226ac 100644
--- a/C4/Overdues.pm
+++ b/C4/Overdues.pm
@@ -199,7 +199,11 @@ sub GetOverduesByBorrowers{
             surname,
             firstname,
             title,
-            CONCAT(borrowers.streetnumber, ' ', borrowers.address, '\n', borrowers.address2) as address,
+            CONCAT(
+                IFNULL(borrowers.streetnumber,''), ' ', 
+                IFNULL(borrowers.streettype,'') , ' ' , 
+                IFNULL(borrowers.address,''), '\n', IFNULL(borrowers.address2,'')
+                ) as address,
             city,
             zipcode,
             email,
-- 
1.7.0.4