commit 79043ceef1a6dd29b261ef2dbce1e65fae632873
parent d56591f42be3acdbba809a4af629655a35712e9f
Author: René Wagner <rwagner@rw-net.de>
Date: Fri, 14 Aug 2020 08:54:59 +0200
fix grouping by week/month
Diffstat:
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/phosta.pl b/phosta.pl
@@ -86,12 +86,12 @@ sub get_sql
my $grouplist = '';
given ($grouping)
{
- when ('week')
+ when ('month')
{
$fieldlist = "strftime('%Y/%m', datetimeoriginal) as month,";
$grouplist = "strftime('%Y/%m', datetimeoriginal)";
}
- when ('month')
+ when ('week')
{
$fieldlist = "strftime('%Y/%W', datetimeoriginal) as week_of_year,";
$grouplist = "strftime('%Y/%W', datetimeoriginal)";