From b8aa11a7b447fb8048115bdd156c2aa9e3b16a07 Mon Sep 17 00:00:00 2001
From: tj <1378534974@qq.com>
Date: 星期二, 15 四月 2025 16:40:08 +0800
Subject: [PATCH] 1.3
---
app/src/main/java/com/example/firstapp/model/DailyStat.kt | 14 +++++++++-----
1 files changed, 9 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..1ff696f 100644
--- a/app/src/main/java/com/example/firstapp/model/DailyStat.kt
+++ b/app/src/main/java/com/example/firstapp/model/DailyStat.kt
@@ -1,16 +1,20 @@
package com.example.firstapp.model
import androidx.room.DatabaseView
+import androidx.room.ColumnInfo
+import androidx.room.Ignore
@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,
+ @ColumnInfo(name = "weekStart")
+ val weekStart: String? = null
+)
\ No newline at end of file
--
Gitblit v1.9.3