From 5d89241d5148956b6166b7783841f17b3e67955d Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Mon, 6 Oct 2025 18:19:39 +0000 Subject: [PATCH] Bug 40961: Fix query for localuse --- reports/issues_stats.pl | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/reports/issues_stats.pl b/reports/issues_stats.pl index 81517b767f3..d062c8d0ac4 100755 --- a/reports/issues_stats.pl +++ b/reports/issues_stats.pl @@ -537,12 +537,12 @@ sub calculate { $strcalc .= " AND items.itemcallnumber <'" . @$filters[8] . "'" if ( @$filters[8] ); $strcalc .= " AND borrowers.sort1 LIKE '" . @$filters[9] . "'" if ( @$filters[9] ); $strcalc .= " AND borrowers.sort2 LIKE '" . @$filters[10] . "'" if ( @$filters[10] ); - $strcalc .= " AND items.homebranch LIKE '" . @$filters[11] . "'" if ( @$filters[11] ); - $strcalc .= " AND items.holdingbranch LIKE '" . @$filters[12] . "'" if ( @$filters[12] ); - $strcalc .= " AND borrowers.branchcode LIKE '" . @$filters[13] . "'" if ( @$filters[13] ); - $strcalc .= " AND dayname(datetime) LIKE '" . $daysel . "'" if ($daysel); - $strcalc .= " AND monthname(datetime) LIKE '" . $monthsel . "'" if ($monthsel); - $strcalc .= " AND statistics.type LIKE '" . $type . "'" if ($type); + $strcalc .= " AND items.homebranch LIKE '" . @$filters[11] . "'" if ( @$filters[11] && $type ne 'localuse' ); + $strcalc .= " AND items.holdingbranch LIKE '" . @$filters[12] . "'" if ( @$filters[12] ); + $strcalc .= " AND borrowers.branchcode LIKE '" . @$filters[13] . "'" if ( @$filters[13] && $type ne 'localuse' ); + $strcalc .= " AND dayname(datetime) LIKE '" . $daysel . "'" if ($daysel); + $strcalc .= " AND monthname(datetime) LIKE '" . $monthsel . "'" if ($monthsel); + $strcalc .= " AND statistics.type LIKE '" . $type . "'" if ($type); foreach ( keys %$attribute_filters ) { if ( $attribute_filters->{$_} ) { -- 2.39.5