http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8112 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtj@kohaaloha.com Summary|Overdues with Fines giving |Overdues with Fines report, |duplicates |giving duplicates --- Comment #13 from Mason James <mtj@kohaaloha.com> --- (In reply to comment #6)
Created attachment 11813 [details] 0001-SIGNED-OFF-Bug-8112-Overdues-with-Fines-giving-dupli
This patch deals with fixing the overdues with fines report only.
Handling of reconciling those dups must be addressed somewhere else.
I only tested the behavior of the report with the above two patches.
Test: 1) configured a patron with overdue items with fines. 2) i ran the overdue with fines report i saw two rows, one for each patron ( normal scenario) 3) to emulate a dupe FU fine update in accountlines, I insert the row refer to attachment above ... circulation_overdues_report_createdupefine_same_item.png for mysql work 4) i ran the overdue with fines report I saw three rows, but two for the same patron and same item (multiple FU case) refer to attachment above ... circulation_overdues_report_dupefine.png 5) applied 0001 and 0002 patches, and ran report gain I saw only two rows, even tough dups exist in the database. refer to circulation_overdues_report_dupefine1_nodupeshowing.png
This reports behaviour will work wether dups exist or not. But when in place, it hides the dups.
Note: Folks on IRC mentioned this was the result of an upgrade from 3.6.x to 3.8.x In leiu of performing an upgrade, I took this route.
wajasu
-- You are receiving this mail because: You are watching all bug changes.