[Koha-bugs] [Bug 7021] patron category in the statistics table

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Jul 16 12:12:02 CEST 2021


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

Emmi Takkinen <emmi.takkinen at koha-suomi.fi> changed:

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

--- Comment #30 from Emmi Takkinen <emmi.takkinen at koha-suomi.fi> ---
Created attachment 122883
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122883&action=edit
Bug 7021: patron category in the statistics table

This patch populates the koha.statistics.usercode with borrowers.categorycode
where it is easily available.
Currently for statistics.type 'issue' OR 'localuse' OR 'renew'.

Supplied a script to UPDATE the old statistics records.

Have fun!

To test:
1. Add loan for patron.
2. Check statistics table
=> 'usercode' column for this issue should now contain patrons categorycode

To test add_statistics_borrowers_categorycode.pl:
1. Run add_statistics_borrowers_categorycode.pl
2. Check statistics table
=> all statistics which are type 'issue' OR 'localuse' OR 'renew'
should now contain patrons categorycode in 'usercode' column

Also prove that tests in t/db_dependent/Circulation.t still pass.

Rebased-by: Emmi Takkinen <emmi.takkinen at koha-suomi.fi>

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the QA Contact for the bug.


More information about the Koha-bugs mailing list