From ad2ec97fe0c60eee4bb7c8cdacff7c876f280ea7 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Mon, 08 Jan 2024 11:30:18 +0800
Subject: [PATCH] 公安安全监管
---
src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java | 67 ++++++++++++++++++++++++++++++++-
1 files changed, 64 insertions(+), 3 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 d8db28a..24b859a 100644
--- a/src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java
+++ b/src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java
@@ -17,8 +17,9 @@
package org.springblade.modules.place.mapper;
import org.apache.ibatis.annotations.Param;
-import org.springblade.common.node.TreeNode;
+import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.place.entity.PlaceEntity;
+import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.vo.PlaceVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -37,14 +38,74 @@
*
* @param page
* @param place
+ * @param houseCodeList
* @return
*/
- List<PlaceVO> selectPlacePage(IPage page, PlaceVO place);
+ List<PlaceVO> selectPlacePage(IPage page,
+ @Param("place") PlaceVO place,
+ @Param("houseCodeList") List<String> houseCodeList);
/**
* 查询场所集合信息
* @param userId
* @return
*/
- List<TreeNode> 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);
+
+ /**
+ * 查询所有的场所（手机号不为空）
+ * @return
+ */
+ List<PlaceVO> getPlaceNotNullPhone();
+
+ /**
+ * 查询所有的场所
+ * @return
+ */
+ List<PlaceVO> getAllHistoryPlace();
+
+ /**
+ * 更新场所信息
+ * @param place
+ */
+ int updatePlaceEntity(@Param("place") PlaceVO place);
+
+ /**
+ * 查询场所详情数据
+ * @param place
+ * @return
+ */
+ PlaceVO getDetail(@Param("place") PlaceEntity place);
+
+ /**
+ * 判断商超是否导入
+ * @param placeExcel
+ * @return
+ */
+ PlaceEntity getPlaceAndRelInfo(@Param("place") PlaceAndRelExcel placeExcel);
+
+ /**
+ * 查询出有用户id 的场所
+ * @return
+ */
+ List<PlaceEntity> getHasUserIdPlaceList();
+
+ /**
+ * 查询所有的场所数据（除去详情表已有的）
+ * @return
+ */
+ List<PlaceEntity> getPlaceListByNoExt();
+
+ /**
+ * 商超数据处理
+ * @return
+ */
+ List<PlaceEntity> placeAndRelHandle();
}
--
Gitblit v1.9.3