[Bug 42839] New: SIP: Record SIP account/device identifier for circulation reporting
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42839 Bug ID: 42839 Summary: SIP: Record SIP account/device identifier for circulation reporting Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs@lists.koha-community.org Reporter: Laura.escamilla@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: lisette@bywatersolutions.com Target Milestone: --- Currently SIP checkouts set the interface to 'sip', allowing reports to distinguish SIP circulation from staff client circulation. However, there is no way to distinguish between individual SIP accounts/devices used to perform those transactions. The issues.issuer_id field is not populated for SIP transactions because AddIssue only records issuer_id from the logged-in user session (C4::Context->userenv), and SIP transactions do not create a staff user session. Libraries with multiple self-check machines may wish to report on circulation activity by individual SIP account/device rather than only by branch or interface. This enhancement would provide a mechanism to record the SIP account/device identifier associated with a SIP transaction for reporting purposes. Possible implementation approaches include: - Recording the SIP account identifier in statistics. - Adding a dedicated SIP account/device field for circulation reporting. - Another implementation determined by the development community. The goal is to allow reporting by individual SIP account/device without repurposing issues.issuer_id, which is intended to reference a borrower record. -- 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=42839 Anneli Österman <anneli.osterman@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |anneli.osterman@koha-suomi. | |fi --- Comment #1 from Anneli Österman <anneli.osterman@koha-suomi.fi> --- The SIP accounts are recorded in action_logs table and we have used this kind of report to check how many checkouts and returns have been down by certain SIP account: SELECT CONCAT(HOUR(timestamp), ':00-', HOUR(timestamp)+1, ':00') AS 'Hours', sum(IF(action = 'ISSUE', 1, 0)) AS 'Checkouts', sum(IF(action = 'RETURN', 1, 0)) AS 'Returns' FROM action_logs WHERE module = 'CIRCULATION' AND user = <<SIP account's borrowernumber>> AND timestamp BETWEEN <<Starting from|date>> AND <<Ending to|date>> AND action IN ('ISSUE','RETURN') GROUP BY HOUR(timestamp) Nevertheless, I'm all in for improvements. :) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org