From f67cf3b81a00f732ca743431258ae6b78f5f40ab Mon Sep 17 00:00:00 2001
From: tj <1378534974@qq.com>
Date: 星期四, 17 四月 2025 15:05:28 +0800
Subject: [PATCH] 11、我的	切换头像  点击切换头像没有显示允许存储权限的窗口,华为的手机目前有 49、首页	实时刷新  点击全部取件或其他分类后,回到上一层,内容没有刷新(5个分类) 52、数据统计	数据统计  1.周月年的柱状图统计逻辑需要修改为只统计快递类的数据  2.按年的图形统计,右下方加上图示说明 53、首页	首页登录  点击用户协议、隐私政策无反应

---
 app/src/main/java/com/example/firstapp/database/dao/ReminderDao.kt |   19 ++++++++++++++-----
 1 files changed, 14 insertions(+), 5 deletions(-)

diff --git a/app/src/main/java/com/example/firstapp/database/dao/ReminderDao.kt b/app/src/main/java/com/example/firstapp/database/dao/ReminderDao.kt
index 8c9b629..8179240 100644
--- a/app/src/main/java/com/example/firstapp/database/dao/ReminderDao.kt
+++ b/app/src/main/java/com/example/firstapp/database/dao/ReminderDao.kt
@@ -1,17 +1,26 @@
 package com.example.firstapp.database.dao
+
 import androidx.room.*
 import com.example.firstapp.database.entity.Reminder
 import kotlinx.coroutines.flow.Flow
 
 @Dao
 interface ReminderDao {
-
-    @Query("SELECT * FROM reminders ORDER BY type")
+    @Query("SELECT * FROM reminders ORDER BY createdAt DESC")
     fun getAllReminders(): Flow<List<Reminder>>
 
-    @Insert
-     fun insert(reminder: Reminder)
+    @Insert(onConflict = OnConflictStrategy.REPLACE)
+    suspend fun insertReminder(reminder: Reminder)
 
     @Delete
-     fun delete(reminder: Reminder)
+    suspend fun deleteReminder(reminder: Reminder)
+
+    @Query("DELETE FROM reminders WHERE categoryId = :categoryId")
+    suspend fun deleteReminderByCategoryId(categoryId: Int)
+
+    @Query("SELECT * FROM reminders WHERE categoryId = :categoryId")
+    suspend fun getReminderByCategoryId(categoryId: Int): Reminder?
+
+    @Query("DELETE FROM reminders")
+    suspend fun deleteAllReminders()
 }
\ No newline at end of file

--
Gitblit v1.9.3