From ef20591cba97b5c18b12b6ea3d0d751a6669d9d7 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期三, 26 三月 2025 14:22:04 +0800
Subject: [PATCH] fix  修改表字段前版本

---
 app/src/main/java/com/example/firstapp/model/CourierStat.kt |    5 ++---
 1 files changed, 2 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 fe385fe..7cb6c0a 100644
--- a/app/src/main/java/com/example/firstapp/model/CourierStat.kt
+++ b/app/src/main/java/com/example/firstapp/model/CourierStat.kt
@@ -4,10 +4,9 @@
 
 @DatabaseView(
     """
-    SELECT category as courierName, COUNT(*) as count 
+    SELECT type as courierName, COUNT(*) as count 
     FROM Code 
-    WHERE substr(createtime, 1, 10) = date('now')
-    GROUP BY category
+    GROUP BY type
     """
 )
 data class CourierStat(

--
Gitblit v1.9.3