diff options
| author | Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com> | 2025-10-28 10:33:57 +0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-10-28 09:33:57 +0300 |
| commit | 3f714dd2fff09b6a1e96e25ea312feed83f95417 (patch) | |
| tree | 7310b7b9b70e879f667c9db8e94d9d74a1801d4b /backend | |
| parent | fix/frontend: start timeline at the start of the year (#294) (diff) | |
| download | lphub-3f714dd2fff09b6a1e96e25ea312feed83f95417.tar.gz lphub-3f714dd2fff09b6a1e96e25ea312feed83f95417.tar.bz2 lphub-3f714dd2fff09b6a1e96e25ea312feed83f95417.zip | |
fix/backend: have timeline start at the start of the year (#295)
Diffstat (limited to 'backend')
| -rw-r--r-- | backend/handlers/stats.go | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/handlers/stats.go b/backend/handlers/stats.go index 06748c3..04618cc 100644 --- a/backend/handlers/stats.go +++ b/backend/handlers/stats.go | |||
| @@ -109,7 +109,7 @@ func Timeline(c *gin.Context) { | |||
| 109 | WITH date_series AS ( | 109 | WITH date_series AS ( |
| 110 | SELECT DISTINCT record_date as date | 110 | SELECT DISTINCT record_date as date |
| 111 | FROM map_history | 111 | FROM map_history |
| 112 | WHERE category_id = 1 AND map_id <= 60 AND record_date >= '2013-01-31' | 112 | WHERE category_id = 1 AND map_id <= 60 AND record_date >= '2013-01-01' |
| 113 | ORDER BY record_date | 113 | ORDER BY record_date |
| 114 | ), | 114 | ), |
| 115 | map_best_at_date AS ( | 115 | map_best_at_date AS ( |
| @@ -136,7 +136,7 @@ func Timeline(c *gin.Context) { | |||
| 136 | WITH date_series AS ( | 136 | WITH date_series AS ( |
| 137 | SELECT DISTINCT record_date as date | 137 | SELECT DISTINCT record_date as date |
| 138 | FROM map_history | 138 | FROM map_history |
| 139 | WHERE category_id = 1 AND map_id > 60 AND record_date >= '2013-01-31' | 139 | WHERE category_id = 1 AND map_id > 60 AND record_date >= '2013-01-01' |
| 140 | ORDER BY record_date | 140 | ORDER BY record_date |
| 141 | ), | 141 | ), |
| 142 | map_best_at_date AS ( | 142 | map_best_at_date AS ( |