新增责任人查询接口，新增区域人员查询接口

zhongrj

2023-06-01 2328ef6fe7a640dd43f4b1f21647312c805b0423

新增责任人查询接口，新增区域人员查询接口

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.java

@@ -1,10 +1,12 @@
package cn.gistack.sm.sjztmd.mapper;

import cn.gistack.common.node.TreeNode;
import cn.gistack.sm.notice.vo.PersonVO;
import cn.gistack.sm.sjztmd.entity.AttAdBase;
import cn.gistack.sm.sjztmd.vo.AttAdBaseVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;
@@ -29,4 +31,10 @@
    @MapKey("id")
    Map<String, TreeNode> selectAttAdBaseTree(String parentCode, Map<String, Object> param);

    /**
     * 根据水库编号查询除责任人之外的人员信息
     * @param res_cd
     * @return
     */
    List<PersonVO> getPersonListByResGuid(@Param("res_cd")String res_cd);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml

@@ -86,4 +86,16 @@
        ORDER BY region."ad_code"
    </select>

    <!--根据水库编号查询除责任人之外的人员信息-->
    <select id="getPersonListByResGuid" resultType="cn.gistack.sm.notice.vo.PersonVO">
        select bu.real_name,bu.phone,bd.ad_code from YWXT.blade_user bu left  join YWXT.blade_dept bd on instr(bu.dept_id,bd.id)>0 and bd.is_deleted = 0
        where bu.is_deleted = 0
        and bd.ad_code in (
        select "ad_code" from SJZT_MD."att_ad_base"
                start with "ad_code" = (select "interior_ad_guid" from SJZT_MD."att_res_base" where "guid" = #{res_cd} )
                CONNECT BY PRIOR "p_ad_code"  =  "ad_code"
        )
        and bu.phone is not null and bu.phone!=''
    </select>

</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.java

@@ -1,7 +1,9 @@
package cn.gistack.sm.sjztmd.mapper;

import cn.gistack.sm.notice.vo.PersonVO;
import cn.gistack.sm.sjztmd.entity.AttResManagePerson;
import cn.gistack.sm.sjztmd.entity.PatrolResponsiblePerson;
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

@@ -23,4 +25,12 @@

    List<PatrolResponsiblePerson> getPatrolResponsiblePersonAll();

    /**
     * 根据水库编号及责任人类型查询相关责任人信息
     * @param res_cd
     * @param personList
     * @return
     */
    @DS("zt")
    List<PersonVO> getPersonListByResGuid(@Param("res_cd")String res_cd,@Param("list") List<String> personList);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResManagePersonMapper.xml

@@ -69,6 +69,22 @@
                #{attResManagePerson.sysResource})
    </insert>


    <!--根据水库编号及责任人类型查询相关责任人信息-->
    <select id="getPersonListByResGuid" resultType="cn.gistack.sm.notice.vo.PersonVO">
        select "user_name" as name,"user_phone" as phone
        from "SJZT_MD"."att_res_manage_person"
        where "res_guid" = #{res_cd}
        <choose>
            <when test="list!=null and list.size()>0">
                and "type" in
                <foreach collection="list" item="type" separator ="," open="("  close=")">
                    #{type}
                </foreach>
            </when>
            <otherwise>
                and "type" in ('')
            </otherwise>
        </choose>
    </select>

</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttAdBaseService.java

@@ -1,5 +1,6 @@
package cn.gistack.sm.sjztmd.service;

import cn.gistack.sm.notice.vo.PersonVO;
import cn.gistack.sm.sjztmd.entity.AttAdBase;
import cn.gistack.sm.sjztmd.vo.AttAdBaseVO;
import com.baomidou.mybatisplus.extension.service.IService;
@@ -27,4 +28,11 @@
     * @return
     */
    Object selectAttAdBaseTree(String parentCode, Map<String, Object> obj);

    /**
     * 根据水库编号查询除责任人之外的人员信息
     * @param res_cd
     * @return
     */
    List<PersonVO> getPersonListByResGuid(String res_cd);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/IAttResManagePersonService.java

@@ -1,5 +1,6 @@
package cn.gistack.sm.sjztmd.service;

import cn.gistack.sm.notice.vo.PersonVO;
import cn.gistack.sm.sjztmd.entity.AttResManagePerson;
import cn.gistack.sm.sjztmd.entity.PatrolResponsiblePerson;
import com.baomidou.mybatisplus.extension.service.IService;
@@ -33,4 +34,11 @@
     */
    List<PatrolResponsiblePerson> getPatrolResponsiblePersonAll();

    /**
     * 根据水库编号及责任人类型查询相关责任人信息
     * @param res_cd
     * @param personList
     * @return
     */
    List<PersonVO> getPersonListByResGuid(String res_cd, List<String> personList);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttAdBaseServiceImpl.java

@@ -2,6 +2,7 @@

import cn.gistack.common.node.TreeNode;
import cn.gistack.common.utils.NodeTreeUtil;
import cn.gistack.sm.notice.vo.PersonVO;
import cn.gistack.sm.sjztmd.entity.AttAdBase;
import cn.gistack.sm.sjztmd.mapper.AttAdBaseMapper;
import cn.gistack.sm.sjztmd.service.IAttAdBaseService;
@@ -68,4 +69,14 @@
        }
        return nodeTree;
    }

    /**
     * 根据水库编号查询除责任人之外的人员信息
     * @param res_cd
     * @return
     */
    @Override
    public List<PersonVO> getPersonListByResGuid(String res_cd) {
        return baseMapper.getPersonListByResGuid(res_cd);
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResManagePersonServiceImpl.java

@@ -1,5 +1,6 @@
package cn.gistack.sm.sjztmd.service.impl;

import cn.gistack.sm.notice.vo.PersonVO;
import cn.gistack.sm.sjztmd.entity.AttResManagePerson;
import cn.gistack.sm.sjztmd.entity.PatrolResponsiblePerson;
import cn.gistack.sm.sjztmd.mapper.AttResManagePersonMapper;
@@ -66,4 +67,16 @@
    public List<PatrolResponsiblePerson> getPatrolResponsiblePersonAll() {
        return baseMapper.getPatrolResponsiblePersonAll();
    }

    /**
     * 根据水库编号及责任人类型查询相关责任人信息
     * @param res_cd
     * @param personList
     * @return
     */
    @Override
    @DS("zt")
    public List<PersonVO> getPersonListByResGuid(String res_cd, List<String> personList) {
        return baseMapper.getPersonListByResGuid(res_cd,personList);
    }
}