[Bug 16255] New: When exemptfine, removes the first fine found
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16255 Bug ID: 16255 Summary: When exemptfine, removes the first fine found Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: luresalo@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com If one item has more than one "FU" or "O" fine for user, returns the first/old one and not the latest one. Solved by adding to the _FixOverduesOnReturn, from this: "SELECT * FROM accountlines WHERE (borrowernumber = ?) AND (itemnumber = ?) AND (accounttype='FU' OR accounttype='O')" to this: "SELECT * FROM accountlines WHERE (borrowernumber = ?) AND (itemnumber = ?) AND (accounttype='FU' OR accounttype='O') ORDER BY timestamp DESC" -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16255 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Can you please add a test plan on how to reproduce this issue? What does O translate to? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16255 --- Comment #2 from René Salas <luresalo@gmail.com> --- According to https://wiki.koha-community.org/wiki/Hard_Coded_Values O is for Overdue. Test plan 1.- Let one issue overdue and return it normally, this should record a fine for the overdue. 2.- Issue the item again letting the loan overdue and get a different fine from the previous one. 3.- Return the issue with the exempt fine selected though returns.pl 4.- Note that the oldest fine was FFOR and not the one related to the actual loan. 5.- Apply the change proposed. 5.- Repeat steps 1-3 6.- Now the FFOR apply for the more recent (accountlines_id) loan. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16255 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hm, I am not sure if O is set by the system currently, but that's not the problem here. I think there should be no 2 FU at the same time, it's a known bug - see bug 14390. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16255 René Salas <luresalo@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #4 from René Salas <luresalo@gmail.com> --- *** This bug has been marked as a duplicate of bug 14390 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org