[Koha-bugs] [Bug 27444] New: Allow reports to use the calendar to count open/closed days based on the calendar
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jan 15 19:39:27 CET 2021
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27444
Bug ID: 27444
Summary: Allow reports to use the calendar to count open/closed
days based on the calendar
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Reports
Assignee: koha-bugs at lists.koha-community.org
Reporter: andrew at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
When writing reports related to fines or overdue notices, one runs into
difficulties based on how Koha holidays are stored. There's no good way for SQL
to calculate out how many days within a given span were open days. So if you're
using the calendar to calculate when to send overdue notices at 10 open days
past the due date, there's no way to get SQL to tell you which items should
have gotten an overdue notice today.
This becomes more of an issue as we use the patron emailer more, since the
patron emailer relies upon a report. If one wanted to use the patron emailer to
send a fourth overdue notice, one would not be able to calculate when to send
that notice using the Koha calendar.
I'm not sure what the solution is here. Maybe some syntax one could use in a
report to ask Koha to generate a value? So you could say something like:
WHERE timestampdiff(days,date_due,curdate()) = <<opendays:date_due,curdate()>>
?
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list