From 5fc9567cfa6b6beee4f52a9f835f304865d693e1 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期四, 10 四月 2025 18:13:58 +0800
Subject: [PATCH] add: 消息提醒后版本
---
app/src/main/java/com/example/firstapp/model/DailyStat.kt | 13 ++++++++-----
1 files changed, 8 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..54462ad 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,19 @@
package com.example.firstapp.model
import androidx.room.DatabaseView
+import androidx.room.ColumnInfo
@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