[Bug 5527] New: Reports: Patrons who haven't checked out misses active users from issues table
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Summary: Reports: Patrons who haven't checked out misses active users from issues table Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All URL: /cgi-bin/koha/reports/borrowers_out.pl OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Reports AssignedTo: gmcharlt@gmail.com ReportedBy: katrin.fischer@bsz-bw.de QAContact: koha-bugs@lists.koha-community.org Estimated Hours: 0.0 I compared some of my sql statements for statistics with the results from Koha's built in reports in the reports module. Currently the 'Patrons who haven't checked out' report does not consider patrons from issues. If you have a newly registered user, that has checked out his first books in the library his borrowernumber will only appear in issues. This is an active user. At the moment Koha gets a list of active borrowernumbers only from old_issues and compares that (not in) to all borrowers to get the inactive borrowers. It should also get the borrowers from issues. Currently koha asks: SELECT CONCAT( borrowers.surname , "\t",borrowers.firstname, "\t", borrowers.cardnumber) FROM borrowers WHERE 1 AND borrowers.borrowernumber not in (SELECT DISTINCT borrowernumber FROM old_issues where old_issues.timestamp> 01/01/2010 ) group by borrowers.borrowernumber I think it needs to consider issues too, perhaps something like: SELECT CONCAT( borrowers.surname , "\t",borrowers.firstname, "\t", borrowers.cardnumber) FROM borrowers WHERE 1 AND borrowers.borrowernumber not in (SELECT DISTINCT borrowernumber FROM ( select borrowernumber from old_issues where old_issues.timestamp> 01/01/2010 union select borrowernumber from issues where issues.timestamp> 01/01/2010) active_b ) group by borrowers.borrowernumber There was some discussion about that on #koha too: http://stats.workbuffer.org/irclog/koha/2010-12-20#i_567711 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2010-12-20 15:43:37 UTC --- Created attachment 2892 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=2892 screenshot of my report settings -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2010-12-20 16:35:04 UTC --- Still fighting with this report: old_issues.timestamp> 01/01/2010 is not right and brings up a lot of 2009-* dates. :( Should be: old_issues.timestamp> "2010-01-01" -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|enhancement |major -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2010-12-20 22:23:19 UTC --- I was looking at an older version of this script earlier today, but didn't realize. I still see some problems: - the date is not showing up in the query - the issues table is still not considered SELECT CONCAT( borrowers.surname , "\t",borrowers.firstname, "\t", borrowers.cardnumber) FROM borrowers WHERE 1 AND borrowers.borrowernumber not in (SELECT DISTINCT borrowernumber FROM old_issues WHERE borrowernumber IS NOT NULL ) group by borrowers.borrowernumber -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|gmcharlt@gmail.com |katrin.fischer@bsz-bw.de -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2010-12-21 07:47:24 UTC --- Created attachment 2897 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=2897 Proposed patch -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 |PATCH-Sent Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 --- Comment #5 from MJ Ray (software.coop) <mjr@ttllp.co.uk> 2011-01-11 12:57:39 UTC --- This bug is mentioned in: Bug 5527: Fix some problems in inactive borrowers report http://lists.koha-community.org/pipermail/koha-patches/2010-December/013449.... -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nengard@gmail.com Patch Status|Needs Signoff |Signed Off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz Patch Status|Signed Off |Patch Pushed --- Comment #6 from Chris Cormack <chris@bigballofwax.co.nz> 2011-03-11 19:44:00 UTC --- Pushed, please test and mark resolved -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5527 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |julian.maurice@biblibre.com Resolution| |FIXED --- Comment #7 from MJ Ray (software.coop) <mjr@ttllp.co.uk> 2011-04-04 08:10:11 UTC --- This bug is mentioned in: Bug 5527: Fix some problems in inactive borrowers report http://lists.koha-community.org/pipermail/koha-patches/2011-March/014004.htm... -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org