From 66c61a1451a177bbe465f763afdffa3bcfe2ce56 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期四, 06 三月 2025 13:18:43 +0800 Subject: [PATCH] fix: 5 --- app/src/main/java/com/example/firstapp/model/DailyStat.kt | 11 ++++++----- 1 files changed, 6 insertions(+), 5 deletions(-) diff --git a/app/src/main/java/com/example/firstapp/model/DailyStat.kt b/app/src/main/java/com/example/firstapp/model/DailyStat.kt index dc61551..b6c7301 100644 --- a/app/src/main/java/com/example/firstapp/model/DailyStat.kt +++ b/app/src/main/java/com/example/firstapp/model/DailyStat.kt @@ -4,13 +4,14 @@ @DatabaseView( """ - SELECT date(receivedTime/1000, 'unixepoch', 'localtime') as date, + SELECT substr(createtime, 1, 10) as date, COUNT(*) as count - FROM packages - GROUP BY date(receivedTime/1000, 'unixepoch', 'localtime') + FROM code + GROUP BY substr(createtime, 1, 10) """ ) data class DailyStat( val date: String, - val count: Int -) \ No newline at end of file + val count: Int, + val weekStart: Long? = null +) \ No newline at end of file -- Gitblit v1.9.3