View | Details | Raw Unified | Return to bug 29204
Collapse All | Expand All

(-)a/reports/issues_stats.pl (-3 / +4 lines)
Lines 312-318 sub calculate { Link Here
312
          ( $linesource eq 'items' )
312
          ( $linesource eq 'items' )
313
          ? " LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) "
313
          ? " LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) "
314
          : " LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) ";
314
          : " LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) ";
315
        $strsth .= " WHERE $line is not null AND $line != '' ";
315
        $strsth .= " WHERE $line IS NOT NULL ";
316
        $strsth .= " AND $line != '' " if $line ne "datetime";
316
    }
317
    }
317
318
318
    if ( $line =~ /datetime/ ) {
319
    if ( $line =~ /datetime/ ) {
Lines 400-406 sub calculate { Link Here
400
          ( $colsource eq 'items' )
401
          ( $colsource eq 'items' )
401
          ? "LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) "
402
          ? "LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) "
402
          : "LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) ";
403
          : "LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) ";
403
        $strsth2 .= " WHERE $column IS NOT NULL AND $column != '' ";
404
        $strsth .= " WHERE $column IS NOT NULL";
405
        $strsth .= " AND $column != '' " if $column ne "datetime";
404
    }
406
    }
405
407
406
    if ( $column =~ /datetime/ ) {
408
    if ( $column =~ /datetime/ ) {
407
- 

Return to bug 29204