[Koha-patches] [PATCH] [followup](bug #3667) don't delete if member is guarantor
Nahuel ANGELINETTI
nahuel.angelinetti at biblibre.com
Wed Dec 30 16:51:26 CET 2009
this fix cleanborrowers to don't delete guanrantors.
---
C4/Members.pm | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/C4/Members.pm b/C4/Members.pm
index 7644c36..bd9e60b 100644
--- 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 ""){
--
1.6.3.3
More information about the Koha-patches
mailing list