[Koha-bugs] [Bug 15675] Add issue_id column to accountlines and use it for updating fines

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15675

--- Comment #18 from Kyle M Hall <kyle at 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.