diff options
Diffstat (limited to 'app/Models/StatsDAOSQLite.php')
| -rw-r--r-- | app/Models/StatsDAOSQLite.php | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/app/Models/StatsDAOSQLite.php b/app/Models/StatsDAOSQLite.php index 4e51615fc..50b12d2c7 100644 --- a/app/Models/StatsDAOSQLite.php +++ b/app/Models/StatsDAOSQLite.php @@ -4,6 +4,17 @@ declare(strict_types=1); class FreshRSS_StatsDAOSQLite extends FreshRSS_StatsDAO { #[\Override] + protected function sqlDateToIsoGranularity(string $field, int $precision, string $granularity): string { + $offset = $this->getTimezoneOffset(); + return match ($granularity) { + 'day' => "strftime('%Y-%m-%d', ($field / $precision) + $offset, 'unixepoch')", + 'month' => "strftime('%Y-%m', ($field / $precision) + $offset, 'unixepoch')", + 'year' => "strftime('%Y', ($field / $precision) + $offset, 'unixepoch')", + default => throw new InvalidArgumentException('Invalid date granularity'), + }; + } + + #[\Override] protected function sqlFloor(string $s): string { return "CAST(($s) AS INT)"; } @@ -18,8 +29,9 @@ class FreshRSS_StatsDAOSQLite extends FreshRSS_StatsDAO { } else { $restrict = ''; } + $offset = $this->getTimezoneOffset(); $sql = <<<SQL -SELECT strftime('{$period}', e.date, 'unixepoch') AS period +SELECT strftime('{$period}', e.date + {$offset}, 'unixepoch') AS period , COUNT(1) AS count FROM `_entry` AS e {$restrict} |