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 | 15 +++++++++++++++
1 files changed, 15 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 8df5a2b..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
@@ -41,4 +41,19 @@
@Query("SELECT * FROM Code order by time desc")
abstract fun getAllCodesDesc(): List<Code>
+
+ @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