Lines 537-548
sub calculate {
Link Here
|
537 |
$strcalc .= " AND items.itemcallnumber <'" . @$filters[8] . "'" if ( @$filters[8] ); |
537 |
$strcalc .= " AND items.itemcallnumber <'" . @$filters[8] . "'" if ( @$filters[8] ); |
538 |
$strcalc .= " AND borrowers.sort1 LIKE '" . @$filters[9] . "'" if ( @$filters[9] ); |
538 |
$strcalc .= " AND borrowers.sort1 LIKE '" . @$filters[9] . "'" if ( @$filters[9] ); |
539 |
$strcalc .= " AND borrowers.sort2 LIKE '" . @$filters[10] . "'" if ( @$filters[10] ); |
539 |
$strcalc .= " AND borrowers.sort2 LIKE '" . @$filters[10] . "'" if ( @$filters[10] ); |
540 |
$strcalc .= " AND items.homebranch LIKE '" . @$filters[11] . "'" if ( @$filters[11] ); |
540 |
$strcalc .= " AND items.homebranch LIKE '" . @$filters[11] . "'" if ( @$filters[11] && $type ne 'localuse' ); |
541 |
$strcalc .= " AND items.holdingbranch LIKE '" . @$filters[12] . "'" if ( @$filters[12] ); |
541 |
$strcalc .= " AND items.holdingbranch LIKE '" . @$filters[12] . "'" if ( @$filters[12] ); |
542 |
$strcalc .= " AND borrowers.branchcode LIKE '" . @$filters[13] . "'" if ( @$filters[13] ); |
542 |
$strcalc .= " AND borrowers.branchcode LIKE '" . @$filters[13] . "'" if ( @$filters[13] && $type ne 'localuse' ); |
543 |
$strcalc .= " AND dayname(datetime) LIKE '" . $daysel . "'" if ($daysel); |
543 |
$strcalc .= " AND dayname(datetime) LIKE '" . $daysel . "'" if ($daysel); |
544 |
$strcalc .= " AND monthname(datetime) LIKE '" . $monthsel . "'" if ($monthsel); |
544 |
$strcalc .= " AND monthname(datetime) LIKE '" . $monthsel . "'" if ($monthsel); |
545 |
$strcalc .= " AND statistics.type LIKE '" . $type . "'" if ($type); |
545 |
$strcalc .= " AND statistics.type LIKE '" . $type . "'" if ($type); |
546 |
|
546 |
|
547 |
foreach ( keys %$attribute_filters ) { |
547 |
foreach ( keys %$attribute_filters ) { |
548 |
if ( $attribute_filters->{$_} ) { |
548 |
if ( $attribute_filters->{$_} ) { |
549 |
- |
|
|