From 85a2d7f51a32cd747e27ab68bc8699a54419b6c7 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期一, 03 三月 2025 10:02:04 +0800
Subject: [PATCH] fix :包裹列表
---
app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt | 10 ++++++++++
1 files changed, 10 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..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
@@ -41,4 +41,14 @@
@Query("SELECT * FROM Code order by time desc")
abstract fun getAllCodesDesc(): List<Code>
+
+ @Query("""
+ SELECT * FROM Code
+ WHERE type LIKE '%' || :keyword || '%'
+ 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