From 1097c45d8d6aa4b74a50e8d9a99dedab73f2bbad Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期五, 28 二月 2025 13:35:07 +0800
Subject: [PATCH] add: 优化首页自动同步历史短信,和实时刷新包裹列表

---
 app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt |    3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diff --git a/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt b/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
index 64e658e..a3c0bca 100644
--- a/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
+++ b/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
@@ -48,4 +48,7 @@
         ORDER BY time DESC
     """)
     fun getByKeyword(keyword: String): List<Code>
+
+    @Query("SELECT * FROM Code WHERE type = :content and code= :code and overtime = :dateString LIMIT 1")
+    fun queryByTypeAndCodeAndDate(content: String, code: String, dateString: String): Code
 }

--
Gitblit v1.9.3