From 83a63829463bcb005de9a9f94b2847c9f91cd77b Mon Sep 17 00:00:00 2001
From: Paul POULAIN <paul.poulain@biblibre.com>
Date: Tue, 5 Aug 2008 18:53:29 +0200
Subject: [PATCH] partial fix for #2471, (overdue notice sent twice)

Signed-off-by: Joshua Ferraro <jmf@liblime.com>
---
 C4/Overdues.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Overdues.pm b/C4/Overdues.pm
index 0a720b8e1a..e735ff9979 100644
--- a/C4/Overdues.pm
+++ b/C4/Overdues.pm
@@ -973,7 +973,7 @@ returns a list of branch codes for branches with overdue rules defined.
 
 sub GetBranchcodesWithOverdueRules {
     my $dbh               = C4::Context->dbh;
-    my $rqoverduebranches = $dbh->prepare("SELECT DISTINCT branchcode FROM overduerules WHERE delay1 IS NOT NULL");
+    my $rqoverduebranches = $dbh->prepare("SELECT DISTINCT branchcode FROM overduerules WHERE delay1 IS NOT NULL AND branchcode <> ''");
     $rqoverduebranches->execute;
     my @branches = map { shift @$_ } @{ $rqoverduebranches->fetchall_arrayref };
     $rqoverduebranches->finish;
-- 
2.39.5