From ec6193939600ca7930193b1d5942b1700baf9e06 Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期五, 21 二月 2025 09:20:15 +0800
Subject: [PATCH] 1.巡检记录列表页的实现 2.巡检记录地图展示路径的详情页。 3.处理巡检记录详情页因打开同一个网址导致的webView不显示问题。 4.实现地图页搜索后的地图跳转功能。 5.巡检记录详情页数据加载的优化，默认加载本地数据，当本地没有数据时从服务端获取数据。
---
app/src/main/java/com/dayu/pipirrapp/dao/InspectionLocationDao.java | 25 +++++++++++++++++++++++--
1 files changed, 23 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..1f87eb9 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,26 @@
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>> findBymInspectId(String mInspectId);
+
+
+ //鏌ヨ鎵�鏈夎宸℃id鐨勫潗鏍�
+ @Query("select * from InspectionLocationBean where InspectId=:inspectId ORDER BY locateTime ASC")
+ Single<List<InspectionLocationBean>> findByInspectId(String inspectId);
+
+
+
+ //鏌ヨ鎵�鏈夋湭涓婁紶鐨刴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