[Bug 15675] Add issue_id column to accountlines and use it for updating fines
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15675 --- Comment #18 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Katrin Fischer from comment #16)
I was wondering as this is no 1:1 but a 1:n if the calcuation will be correct. If it will still add another separate line in accountlines if an item goes overdue - renew - overdue - renew... etc. If the due date is removed from the description or no longer used, this information will get lost etc.
You are right, it is a one to many join from issues to accountlines. One item may go overdue multiple times. However, there should only ever be one *accruing* fine for a given issue at a time, so it shouldn't be a problem. The current query already deals with that in that the FU fine will be the first selected and matched by issue_id. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org