From f20611265f7d34fd4fbcdfdaff6cb9cccd0b25fc Mon Sep 17 00:00:00 2001
From: shenyijian <1178253012@qq.com>
Date: Fri, 21 Jun 2024 11:53:21 +0800
Subject: [PATCH] 湖北水库：施工：项目查询过滤无效修复、根据角色查询用户
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.java | 48 ++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 48 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.java
index e1345bc..1f291ac 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.java
@@ -1,13 +1,17 @@
package cn.gistack.sm.sjztmd.mapper;
+import cn.gistack.sm.intelligentCall.entity.Scene;
import cn.gistack.sm.sjztmd.entity.AttResManagePerson;
import cn.gistack.sm.sjztmd.entity.PatrolResponsiblePerson;
+import cn.gistack.sm.sjztmd.vo.ChargePersonVO;
import cn.gistack.sm.sjztmd.vo.PersonVO;
+import cn.gistack.sm.sjztmd.vo.UserPersonVO;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Set;
/**
* @ClassName AttResManagePersonMapper
@@ -19,6 +23,7 @@
public interface AttResManagePersonMapper extends BaseMapper<AttResManagePerson> {
Integer updateResManagePersonByGuid(@Param("attResManagePerson")AttResManagePerson attResManagePerson);
+
Integer insertResManagePersion(@Param("attResManagePerson")AttResManagePerson attResManagePerson);
List<AttResManagePerson> attResManagePersonListByResId(List<Long> resId);
@@ -33,4 +38,47 @@
*/
@DS("zt")
List<PersonVO> getPersonListByResGuid(@Param("res_cd")String res_cd, @Param("list") List<String> personList);
+
+ List<UserPersonVO> getPersonByUserNotExists();
+
+ List<UserPersonVO> getPersonByUser();
+
+ int updateUserByPerson();
+
+ /**
+ * 通过水库代码获取巡查责任人及技术责任人手机号
+ * @param list
+ * @return
+ */
+ @DS("zt")
+ Set<String> getPersonListByWaterCodeList(@Param("list") List<String> list);
+
+ /**
+ * 根据水库编号查询市县水利部人员姓名及联系方式
+ * @param res_cd 水库编号
+ * @param roleAlias 角色别名
+ * @param type 人员类型
+ * @return
+ */
+ List<PersonVO> getCityCountyPersonListByResGuid(@Param("adCode") String res_cd,
+ @Param("roleAlias") String roleAlias,
+ @Param("type") String type);
+
+ List<PatrolResponsiblePerson> getPatrolResponsiblePersonByResCdList(@Param("ids") List<String> reservoirList);
+
+ /**
+ * 通过水库代码获取水库及巡查责任人信息
+ * @param list
+ * @return
+ */
+ @DS("zt")
+ Set<Scene> getPatrolPersonListByWaterCodeList(@Param("list") List<String> list);
+
+ String getCompetentDepart(@Param("resCd") String resCd);
+
+ List<AttResManagePerson> getPersonList(@Param("resCd") String resCd);
+
+ List<AttResManagePerson> getList(@Param("attResManagePerson") AttResManagePerson attResManagePerson);
+
+ List<ChargePersonVO> getPersonByRoleAndAd(@Param("roleAlias") String roleAlias, @Param("adCode") String adCode);
}
--
Gitblit v1.9.3