From 92dd223c3cf18c54a62ddbd3f86b0cab68c1c157 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Mon, 30 Mar 2015 11:45:13 -0300 Subject: [PATCH] Revert "Bug 10606: Remove MySQLism in GetUpcomingDueIssues" This patch reverts a commit that breaks GetUpcomingDueIssues-related tests. This reverts commit 5ee0293ed6207a801df234b09f33bebb84e65e05. Signed-off-by: Tomas Cohen Arazi --- C4/Circulation.pm | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 80e5dc47b7..ed3faf6afa 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -2604,13 +2604,12 @@ sub GetUpcomingDueIssues { my $dbh = C4::Context->dbh; my $statement = <= 0 -AND (DATE( date_due )-DATE( NOW() )) <= ? +HAVING days_until_due >= 0 AND days_until_due <= ? END_SQL my @bind_parameters = ( $params->{'days_in_advance'} ); -- 2.39.5