|
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 |
- |
|
|