[Koha-bugs] [Bug 8112] Overdues with Fines giving duplicates

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8112

wajasu <matted-34813 at mypacks.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Attachment #9628|0                           |1
        is obsolete|                            |

--- Comment #6 from wajasu <matted-34813 at mypacks.net> ---
Created attachment 11813
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11813&action=edit
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.