From e3783b167f132005c7afcc4c10f9ab167806331d Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期二, 04 三月 2025 13:22:04 +0800
Subject: [PATCH] fix: 按天统计相关逻辑

---
 app/src/main/java/com/example/firstapp/model/CourierStat.kt |    7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/app/src/main/java/com/example/firstapp/model/CourierStat.kt b/app/src/main/java/com/example/firstapp/model/CourierStat.kt
index 8abab2c..fe385fe 100644
--- a/app/src/main/java/com/example/firstapp/model/CourierStat.kt
+++ b/app/src/main/java/com/example/firstapp/model/CourierStat.kt
@@ -4,12 +4,13 @@
 
 @DatabaseView(
     """
-    SELECT category, COUNT(*) as count 
+    SELECT category as courierName, COUNT(*) as count 
     FROM Code 
+    WHERE substr(createtime, 1, 10) = date('now')
     GROUP BY category
     """
 )
 data class CourierStat(
-    val category: String,
+    val courierName: String,
     val count: Int
-) 
\ No newline at end of file
+)

--
Gitblit v1.9.3