From 4cb9946eff3626389ae93feef4250dd3d45fb694 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期一, 03 三月 2025 16:00:50 +0800
Subject: [PATCH] fix: 取件相关逻辑
---
app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt | 8 ++++++++
1 files changed, 8 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..b27f1dd 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
@@ -45,7 +45,15 @@
@Query("""
SELECT * FROM Code
WHERE type LIKE '%' || :keyword || '%'
+ AND pickup = '0'
ORDER BY time DESC
""")
fun getByKeyword(keyword: String): List<Code>
+
+ @Query("SELECT * FROM Code WHERE type = :content and code= :code and createtime = :dateString LIMIT 1")
+ fun queryByTypeAndCodeAndDate(content: String, code: String, dateString: String): Code
+
+
+ @Query("update Code set pickup = '1' where id=:id")
+ fun pickup(id: Long)
}
--
Gitblit v1.9.3