From c2c902a3bf998632ffffa9c1508aceba7b5a7b45 Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期五, 10 一月 2025 11:14:09 +0800
Subject: [PATCH] 1.添加网络视频的显示功能相关
---
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