From 604c56c088a224cd0fa4c536e93967c89da78462 Mon Sep 17 00:00:00 2001 From: Olivier Crouzet Date: Thu, 10 Nov 2016 17:25:09 +0100 Subject: [PATCH] Bug 17470 Make overdue notices according to branch item only When a patron had overdues on items from different branches he received from each corresponding branch a notice claiming the complete list of these items. Signed-off-by: sbujam Signed-off-by: Jonathan Druart Signed-off-by: Kyle M Hall --- misc/cronjobs/overdue_notices.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/misc/cronjobs/overdue_notices.pl b/misc/cronjobs/overdue_notices.pl index 7504c7ad57..0aaf22abe0 100755 --- a/misc/cronjobs/overdue_notices.pl +++ b/misc/cronjobs/overdue_notices.pl @@ -465,6 +465,7 @@ SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, branchname AND b.branchcode = items.homebranch AND biblio.biblionumber = biblioitems.biblionumber AND issues.borrowernumber = ? + AND issues.branchcode = ? AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 END_SQL @@ -613,7 +614,7 @@ END_SQL ) unless $test_mode; $verbose and warn "debarring $borr\n"; } - my @params = ($borrowernumber); + my @params = ($borrowernumber,$branchcode); $verbose and warn "STH2 PARAMS: borrowernumber = $borrowernumber"; $sth2->execute(@params); -- 2.39.2