[followup](bug #3667) don't delete if member is guarantor

[koha.git] / C4 / Members.pm

diff --git a/C4/Members.pm b/C4/Members.pm
index 7644c36..bd9e60b 100644 (file)
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1878,6 +1878,7 @@ sub GetBorrowersWhoHaveNotBorrowedSince {
         LEFT JOIN old_issues USING (borrowernumber)
         LEFT JOIN issues USING (borrowernumber) 
         WHERE  category_type <> 'S'
+        AND borrowernumber NOT IN (SELECT guarantorid FROM borrowers WHERE guarantorid IS NOT NULL AND guarantorid <> 0) 
    ";
     my @query_params;
     if ($filterbranch && $filterbranch ne ""){