From e5a090685df3d5e96a37b141d9a1d002d36f16f2 Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期五, 14 二月 2025 16:53:43 +0800
Subject: [PATCH] 1.web地图添加管网显示。 2.安卓原生添加管网信息的获取。 3.安卓原生添加管网信息的本地持久化（SQLite数据库）。 4.实现图例用户的选择状态按钮的持久化。 5.实现自定义搜索按钮的实现。 6.实现搜索后弹出界面的相关功能开发。
---
app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java | 17 ++++++++++++++++-
1 files changed, 16 insertions(+), 1 deletions(-)
diff --git a/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java b/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java
index aad77d8..464f24b 100644
--- a/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java
+++ b/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java
@@ -9,14 +9,16 @@
import com.dayu.pipirrapp.bean.db.DivideBean;
import com.dayu.pipirrapp.bean.db.MarkerBean;
+import com.dayu.pipirrapp.bean.db.SearchResultBean;
import java.util.List;
import io.reactivex.rxjava3.core.Completable;
import io.reactivex.rxjava3.core.Single;
+import io.reactivex.rxjava3.core.Maybe;
/**
- * DivideDao -
+ * DivideDao -鍒嗘按鎴�
*
* @author zuoxiao
* @version 1.0
@@ -50,4 +52,17 @@
@Query("select * from DivideBean")
Single<List<DivideBean>> findAllToSingle();
+
+ @Query("SELECT * FROM DivideBean")
+ Maybe<List<DivideBean>> getAll(); // 鏀逛负杩斿洖Maybe<List<DivideBean>>
+
+ @Query("SELECT * FROM DivideBean WHERE divideName LIKE '%' || :name || '%'")
+ Single<List<DivideBean>> findByDivideNameLike(String name);
+
+ @Query("SELECT divideName as name, 'divide' as type, lat, lng, address, divideId as id FROM DivideBean " +
+ "WHERE divideName LIKE '%' || :keyword || '%' " +
+ "UNION " +
+ "SELECT name, 'marker' as type, lat, lng, address, id FROM MarkerBean " +
+ "WHERE name LIKE '%' || :keyword || '%'")
+ Single<List<SearchResultBean>> searchAllByKeyword(String keyword);
}
--
Gitblit v1.8.0