From 8259f8e03a2ad296b2a6ec8454ceb2f8979bbaf7 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Tue, 02 Apr 2024 15:23:17 +0800
Subject: [PATCH] 高程基准面修改，责任人列表添加姓名和手机号查询条件，增加后端导出接口
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java | 52 ++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 50 insertions(+), 2 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
index caf020e..ee515a5 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java
@@ -1,12 +1,18 @@
package cn.gistack.sm.sjztmd.mapper;
import cn.gistack.sm.sjztmd.dto.AttResBaseUserDTO;
+import cn.gistack.sm.sjztmd.entity.AttAdBase;
import cn.gistack.sm.sjztmd.entity.AttResBase;
+import cn.gistack.sm.sjztmd.excel.AttResBaseUserExcel;
+import cn.gistack.sm.sjztmd.vo.AttResAdVO;
+import cn.gistack.sm.sjztmd.vo.AttResBaseGeneralInvestigationVO;
+import cn.gistack.sm.sjztmd.vo.AttResBaseVO;
import cn.gistack.sm.sjztmd.vo.ManagePersonVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
+import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -20,6 +26,8 @@
List<AttResBase> selectAttResBasePage(IPage<AttResBase> page, @Param("attResBase") AttResBase attResBase);
+ List<AttResBaseGeneralInvestigationVO> selectAttResBaseGeneralInvestigation(IPage<AttResBaseGeneralInvestigationVO> page, @Param("attResBase") AttResBaseGeneralInvestigationVO attResBase);
+
List<AttResBase> getListByRegion(IPage<AttResBase> page,@Param("obj") Map<String, Object> obj);
AttResBase getDetailByCode(@Param("code") String code);
@@ -27,13 +35,16 @@
/**
* 获取水库对应责任人分页数据
* @param params 条件查询参数对象
- * @param ad_code 行政区like条件
+// * @param ad_code 行政区like条件
+// * @param adGrad 级别
* @param page 分页查询参数对象
* @return
*/
List<AttResBaseUserDTO> getAttResBaseUserPage(IPage<AttResBaseUserDTO> page,
- @Param("ad_code") String ad_code,
@Param("params") Map<String, Object> params);
+
+
+ List<AttResBaseUserExcel> getAttResBaseUserExcel(@Param("params") Map<String, Object> params);
/**
* 查询各类型责任人
@@ -44,4 +55,41 @@
Boolean updateResBaseByGuid(@Param("attResBase") AttResBase attResBase);
+ /**
+ * 查询当前水库对应的市级编号和县区编号
+ * @param res_cd
+ * @return
+ */
+ AttResBaseVO getCityCountyCodeByResGuid(@Param("guid") String res_cd);
+
+ /**
+ * 根据水库编码获取行政区数据
+ * @param guid
+ * @return
+ */
+ AttResAdVO getWaterRegionInfoByResGuid(@Param("guid") String guid);
+
+ /**
+ * 获取水库基本信息表DimResInfo总数
+ * @return
+ */
+ int getDimResInfoACount();
+
+ Boolean updateIsShowStatus(@Param("ids") String ids, @Param("isShow") Integer status);
+
+ /**
+ * 根据水库名称、所在区域查询改水库的数量
+ * @param resName 水库名称
+ * @param countyCode 区县编号
+ * @return
+ */
+ Integer getWaterCountByResNameAndCountyName(@Param("resName") String resName,@Param("countyCode") String countyCode);
+
+ AttResAdVO getResAd(@Param("resId") String resId);
+
+ AttAdBase getYwxtResInfo(@Param("cityName") String cityName,@Param("countyName") String countyName);
+
+ Boolean updateRsvr(@Param("attResBase") AttResBase attResBase);
+
+
}
--
Gitblit v1.9.3