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

(-)a/reports/issues_stats.pl (-7 / +6 lines)
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
- 

Return to bug 40961