From 26ac1c8712346522ea1c3fb59be34f4d96544310 Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Wed, 28 Feb 2024 12:02:42 +0800
Subject: [PATCH] 议事管理-物业服务人员数据未过滤有问题
---
src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java | 57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 56 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java b/src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java
index 4069571..e49f20e 100644
--- a/src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java
+++ b/src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java
@@ -19,6 +19,7 @@
import org.apache.ibatis.annotations.Param;
import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.place.entity.PlaceEntity;
+import org.springblade.modules.place.excel.NinePlaceExcel;
import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.vo.PlaceVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -33,19 +34,41 @@
*/
public interface PlaceMapper extends BaseMapper<PlaceEntity> {
+
/**
* 自定义分页
*
* @param page
* @param place
* @param houseCodeList
+ * @param regionChildCodesList
+ * @param isAdministrator
* @return
*/
List<PlaceVO> selectPlacePage(IPage page,
@Param("place") PlaceVO place,
- @Param("houseCodeList") List<String> houseCodeList,
+ @Param("gridCodeList") List<String> gridCodeList,
@Param("regionChildCodesList") List<String> regionChildCodesList,
@Param("isAdministrator") Integer isAdministrator);
+
+ /**
+ * 九小场所档案
+ *
+ * @param page
+ * @param place
+ * @param gridCodeList
+ * @param regionChildCodesList
+ * @param isAdministrator
+ * @param isAdministrator
+ * @return
+ */
+ List<PlaceVO> selectNinePlacePage(IPage page,
+ @Param("place") PlaceVO place,
+ @Param("gridCodeList") List<String> gridCodeList,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("nineTypeList") List<String> nineTypeList);
+
/**
* 查询场所集合信息
@@ -119,4 +142,36 @@
*/
List<PlaceVO> getPlaceListByParam(@Param("list") List<String> stringList,
@Param("tableName") String tableName);
+
+ List<NinePlaceExcel> export( @Param("place") PlaceVO place,
+ @Param("houseCodeList") List<String> houseCodeList,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("nineTypeList") List<String> nineTypeList);
+
+ /**
+ * 查询 警务网格为空的数据
+ * @return
+ */
+ List<PlaceEntity> getPlaceNotJwGridCode();
+
+ /**
+ * 比对两点间的距离是否在1km 范围内(和地址总表位置对比)
+ * @param placeVO
+ * @return
+ */
+ Integer comparisonPosition(@Param("place") PlaceVO placeVO);
+
+ /**
+ * 比对两点间的距离是否在1km 范围内 (和采集的位置对比)
+ * @param placeVO
+ * @return
+ */
+ Boolean comparisonPositionNotHouseCode(@Param("place") PlaceVO placeVO);
+
+ /**
+ * 查询 综治网格为空的数据
+ * @return
+ */
+ List<PlaceEntity> getPlaceNotGridCode();
}
--
Gitblit v1.9.3