From 798128053bb17ed293aa8d5424db3b5ed007d375 Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期一, 23 十二月 2024 10:20:57 +0800
Subject: [PATCH] 1.优化订单列表框架，升级为viewPager2，提升性能。 2.添加收到新工单后的红点提醒。 3.修复查询数据为空时报错。 4.优化修改经纬度的流程。 5.修复mqtt的CLIENT_ID一致导致的连接错误。 6.修复收到新工单后点击消息通知栏跳转详情时不更新数据的bug。
---
app/src/main/java/com/dayu/pipirrapp/dao/InspectionLocationDao.java | 18 ++++++++++++++++--
1 files changed, 16 insertions(+), 2 deletions(-)
diff --git a/app/src/main/java/com/dayu/pipirrapp/dao/InspectionLocationDao.java b/app/src/main/java/com/dayu/pipirrapp/dao/InspectionLocationDao.java
index 68b69ec..efb9a3a 100644
--- a/app/src/main/java/com/dayu/pipirrapp/dao/InspectionLocationDao.java
+++ b/app/src/main/java/com/dayu/pipirrapp/dao/InspectionLocationDao.java
@@ -12,6 +12,7 @@
import java.util.List;
import io.reactivex.rxjava3.core.Completable;
+import io.reactivex.rxjava3.core.Single;
@Dao
public interface InspectionLocationDao {
@@ -31,6 +32,19 @@
InspectionLocationBean findFirst();
//鏌ヨ鎵�鏈夋病鏈変笂浼犵殑鍧愭爣
- @Query("select * from InspectionLocationBean where isPost=false")
- List<InspectionLocationBean> findByNoPost();
+ @Query("select * from InspectionLocationBean where isPost=false AND mInspectId=:mInspectId ORDER BY locateTime ASC")
+ Single<List<InspectionLocationBean>> findByNoPostAndInspectId(String mInspectId);
+
+
+ //鏌ヨ鎵�鏈夎宸℃id鐨勫潗鏍�
+ @Query("select * from InspectionLocationBean where mInspectId=:mInspectId ORDER BY locateTime ASC")
+ Single<List<InspectionLocationBean>> findByInspectId(String mInspectId);
+
+ //鏌ヨ鎵�鏈夋湭涓婁紶鐨刴InspectId
+ @Query("SELECT DISTINCT mInspectId FROM InspectionLocationBean WHERE isPost = false")
+ Single<List<String>> getUnpostedMInspectIds();
+
+ //鏇存柊鎵�鏈塵InspectId涓嬬殑宸蹭笂浼犵姸鎬�
+ @Query("UPDATE InspectionLocationBean SET isPost = true WHERE mInspectId = :mInspectId")
+ Completable updataByInspectIdSetIsPost(String mInspectId);
}
--
Gitblit v1.8.0