Lines 401-408
sub calculate {
Link Here
|
401 |
( $colsource eq 'items' ) |
401 |
( $colsource eq 'items' ) |
402 |
? "LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) " |
402 |
? "LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) " |
403 |
: "LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) "; |
403 |
: "LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) "; |
404 |
$strsth .= " WHERE $column IS NOT NULL"; |
404 |
$strsth2 .= " WHERE $column IS NOT NULL"; |
405 |
$strsth .= " AND $column != '' " if $column ne "datetime"; |
405 |
$strsth2 .= " AND $column != '' " if $column ne "datetime"; |
406 |
} |
406 |
} |
407 |
|
407 |
|
408 |
if ( $column =~ /datetime/ ) { |
408 |
if ( $column =~ /datetime/ ) { |
409 |
- |
|
|