Bug 15240: Do not process issues with a date due later than today
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 9 Dec 2015 11:10:33 +0000 (11:10 +0000)
committerJulian Maurice <julian.maurice@biblibre.com>
Fri, 29 Jan 2016 10:05:59 +0000 (11:05 +0100)
commite46923af8829f7da9eb3b94e89831b32e68df040
tree56424724c6397635a2636e7d166e41c56e735339
parentff73d0415fade98b79dcaa185640fff694ea80a5
 Bug 15240: Do not process issues with a date due later than today

There is no need to do this job in Perl, MySQL could do it instead.
The idea is to only retrieve the issues info which could be overdued.

To test:
1/ Run the script
2/ Apply the patch
3/ Run the script again, notice the exact same results but execution time is faster

Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Brendan A Gallagher <brendan@bywatersolutions.com>
(cherry picked from commit 0d36c27678a6968304990759657e2312338763eb)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
misc/cronjobs/overdue_notices.pl