From 11ee30d2a10edb462a492e8836458172caeeea4c Mon Sep 17 00:00:00 2001 From: jeremy breuillard Date: Wed, 24 Nov 2021 16:56:09 +0100 Subject: [PATCH] MT 34887: Statistic assistant - Circulation By default statistic assistant filter is set on the existing items and doesn't mind about deleted items. The patch corrects this. Items belong to the same library. Test plan: 1)Make sure to have at least 1 or more item(s) in deleteditems database table 2)Home > Reports > Circulation statistics 3)Fill up 'Issuing library', 'Home library' and 'Holding library' 4)Submit 5)Notice that only statistics for active items are shown 6)Apply patch and repeat from 2) to 5) 7)Now active items and deleted items are shown https://bugs.koha-community.org/show_bug.cgi?id=21982 --- reports/issues_stats.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/reports/issues_stats.pl b/reports/issues_stats.pl index 3eb27fb3e2..995604d633 100755 --- a/reports/issues_stats.pl +++ b/reports/issues_stats.pl @@ -504,7 +504,7 @@ sub calculate { $strcalc .= " LEFT JOIN borrower_attributes AS attribute_$_ ON (statistics.borrowernumber = attribute_$_.borrowernumber AND attribute_$_.code = '$_') "; } } - $strcalc .= "LEFT JOIN items ON statistics.itemnumber=items.itemnumber " + $strcalc .= "LEFT JOIN (SELECT * FROM items UNION SELECT * FROM deleteditems) items ON statistics.itemnumber=items.itemnumber " if ( $linefield =~ /^items\./ or $colfield =~ /^items\./ or $process == 5 -- 2.17.1