From 8b7258c9427882bb1798f1502eaa35184c6e374e Mon Sep 17 00:00:00 2001
From: linwe <872216996@qq.com>
Date: Fri, 09 Aug 2024 14:29:18 +0800
Subject: [PATCH] 短信指定楼栋发送
---
src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java | 107 ++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 89 insertions(+), 18 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 0433b77..26617b8 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.ExportPlaceExcel;
import org.springblade.modules.place.excel.NinePlaceExcel;
import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.vo.PlaceVO;
@@ -41,7 +42,6 @@
*
* @param page
* @param place
- * @param houseCodeList
* @param regionChildCodesList
* @param isAdministrator
* @return
@@ -51,6 +51,14 @@
@Param("gridCodeList") List<String> gridCodeList,
@Param("regionChildCodesList") List<String> regionChildCodesList,
@Param("isAdministrator") Integer isAdministrator);
+
+ /**
+ * 自定义分页
+ * @param page
+ * @param place
+ * @return
+ */
+ List<PlaceVO> getPlacePage(IPage page, @Param("place") PlaceVO place);
/**
* 九小场所档案
@@ -64,47 +72,53 @@
* @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);
+ @Param("place") PlaceVO place,
+ @Param("gridCodeList") List<String> gridCodeList,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator,
+ @Param("nineTypeList") List<String> nineTypeList);
/**
* 查询场所集合信息
+ *
* @param userId
* @return
*/
- List<TreeStringNode> selectPlaceNodeList(@Param("userId") String userId);
+ List<TreeStringNode> selectPlaceNodeList(@Param("userId") String userId);
/**
* 插入用户标签
+ *
* @param userId
* @param labelId
*/
- int saveUserLabel(@Param("userId") Long userId,@Param("labelId") int labelId);
+ int saveUserLabel(@Param("userId") Long userId, @Param("labelId") int labelId);
/**
* 查询所有的场所（手机号不为空）
+ *
* @return
*/
List<PlaceVO> getPlaceNotNullPhone();
/**
* 查询所有的场所
+ *
* @return
*/
List<PlaceVO> getAllHistoryPlace();
/**
* 更新场所信息
+ *
* @param place
*/
int updatePlaceEntity(@Param("place") PlaceVO place);
/**
- * 查询场所详情数据
+ * 查询场所详情数据
+ *
* @param place
* @return
*/
@@ -112,6 +126,7 @@
/**
* 判断商超是否导入
+ *
* @param placeExcel
* @return
*/
@@ -119,45 +134,51 @@
/**
* 查询出有用户id 的场所
+ *
* @return
*/
- List<PlaceEntity> getHasUserIdPlaceList();
+ List<PlaceEntity> getHasUserIdPlaceList();
/**
* 查询所有的场所数据（除去详情表已有的）
+ *
* @return
*/
List<PlaceEntity> getPlaceListByNoExt();
/**
* 商超数据处理
+ *
* @return
*/
List<PlaceEntity> placeAndRelHandle();
/**
* 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）4部分数据（三种颜色对应的+从来没有发过的）
+ *
* @param stringList
* @param tableName
* @return
*/
- List<PlaceVO> getPlaceListByParam(@Param("list") List<String> stringList,
+ 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);
+ 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();
+ List<PlaceEntity> getPlaceNotJwGridCode();
/**
* 比对两点间的距离是否在1km 范围内(和地址总表位置对比)
+ *
* @param placeVO
* @return
*/
@@ -165,6 +186,7 @@
/**
* 比对两点间的距离是否在1km 范围内 (和采集的位置对比)
+ *
* @param placeVO
* @return
*/
@@ -172,20 +194,69 @@
/**
* 查询 综治网格为空的数据
+ *
* @return
*/
List<PlaceEntity> getPlaceNotGridCode();
/**
* 查询对应未的场所 house_code_binds 为空，source = 1 的
+ *
* @return
*/
List<PlaceEntity> selectPlaceNotDoorBindList();
/**
* 查询绑定的房屋
+ *
* @param houseCodeBinds
* @return
*/
- List<Map<String,Object>> getHouseBindMap(@Param("houseCodeBinds") String houseCodeBinds);
+ List<Map<String, Object>> getHouseBindMap(@Param("houseCodeBinds") String houseCodeBinds);
+
+ /**
+ * 企业商超列表查询
+ */
+ List<PlaceVO> selectMallPage(IPage page,
+ @Param("place") PlaceVO place,
+ @Param("gridCodeList") List<String> gridCodeList,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator);
+
+ /**
+ * 查询所有场所数据
+ * @return
+ */
+ List<PlaceVO> getAllList(@Param("i") int i,@Param("size") int size);
+
+ /**
+ * 查询所有场所数据总数
+ * @return
+ */
+ int getAllListTotal();
+
+ /**
+ * 查询对应的社区编号
+ * @param id
+ * @return
+ */
+ String getCommunityCode(@Param("id") Long id);
+
+ /**
+ * 导出场所信息
+ * @param place
+ * @return
+ */
+ List<ExportPlaceExcel> exportPlaceList(@Param("place") PlaceVO place,
+ @Param("gridCodeList") List<String> gridCodeList,
+ @Param("regionChildCodesList") List<String> regionChildCodesList,
+ @Param("isAdministrator") Integer isAdministrator);
+
+ /**
+ * 查询附近场所
+ * @param lat
+ * @param lng
+ * @return
+ */
+ List<PlaceVO> getNearbyPlaceList(String lat, String lng);
}
--
Gitblit v1.9.3