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

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

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

Mason James <mtj at kohaaloha.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mtj at kohaaloha.com
            Summary|Overdues with Fines giving  |Overdues with Fines report,
                   |duplicates                  |giving duplicates

--- Comment #13 from Mason James <mtj at 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.