Bugzilla – Attachment 187489 Details for
Bug 40961
LocalUse Circulation Statistics offering empty results
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 40961: Fix query for localuse
Bug-40961-Fix-query-for-localuse.patch (text/plain), 2.03 KB, created by
Lucas Gass (lukeg)
on 2025-10-06 18:19:58 UTC
(
hide
)
Description:
Bug 40961: Fix query for localuse
Filename:
MIME Type:
Creator:
Lucas Gass (lukeg)
Created:
2025-10-06 18:19:58 UTC
Size:
2.03 KB
patch
obsolete
>From 5d89241d5148956b6166b7783841f17b3e67955d Mon Sep 17 00:00:00 2001 >From: Lucas Gass <lucas@bywatersolutions.com> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 40961
: 187489