From 85d11d6cd12abdd1e1f5f7516a7fb53a4826633f Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期二, 15 四月 2025 09:17:18 +0800
Subject: [PATCH] add: 消息提醒
---
app/src/main/java/com/example/firstapp/model/DailyStat.kt | 12 ++++++++----
1 files changed, 8 insertions(+), 4 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 5cd26c6..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(createtime/1000, 'unixepoch', 'localtime') as date,
+ SELECT substr(createTime, 1, 10) as date,
COUNT(*) as count
FROM code
- GROUP BY date(createtime/1000, 'unixepoch', 'localtime')
+ 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