[Koha-bugs] [Bug 16703] New: Home > Reports > Circulation statistics showing no circulation

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

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

            Bug ID: 16703
           Summary: Home > Reports > Circulation statistics showing no
                    circulation
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: gmcharlt at gmail.com
          Reporter: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

koha/reports/issues_stats.pl is giving incorrect results.

Here are the parameters added:

Period
  From: 01/01/2016
  To  : 06/07/2016
Type: Checkout
group by: None
Library: Takoma Park Maryland Library
Home Library: Takoma Park Maryland Library
Holding Library: Takoma Park Maryland Library

The output is:

Circulation statistics
Filtered on:
Period From 01/01/2016
Period To 06/07/2016
Library = TPML
Home library = TPML
Holding library = TPML
Event issue
/       TOTAL
TOTAL   0

Here are the actual circulation statistics:

select count(*) from statistics where type = 'issue' and branch='TPML' and
date(datetime) between '2016-01-01' 
and '2016-06-07';                                                               
+----------+
| count(*) |
+----------+
|    33891 |
+----------+

To re-create:

1/ Choose a koha instance that has circulation
2/ Go to Home > Reports > Circulation statistics
3/ Select the following:
    Period
      From: <Your start date>
      To  : <Your end date>
    Type: Checkout
    group by: None
    Library: <BRANCH>
    Home Library: <BRANCH>
    Holding Library: <BRANCH>
    Cell Value: Count total items
    Output: To screen into the browser
4/ Click submit

    You will see

    Event      issue
    /          TOTAL
    TOTAL      0

5/ select count(*) from statistics where type = 'issue' and branch='BRANCH' and
date(datetime) between '<Your start date>' and '<Your end date>'
  (Replace BRANCH and dates with values corresponding to the report above).

Assuming that your date range contains checkouts, the output from
issues_stats.pl is clearly incorrect.

-- 
You are receiving this mail because:
You are watching all bug changes.