水情预警短信逻辑修改

xieb

2024-06-21 c5a1f9f776119dc9d2727c0c9aaf36a1d05ec50e

水情预警短信逻辑修改

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

@@ -206,9 +206,15 @@
        left join YWXT.blade_dept bd on locate(bd.id,bu.dept_id)>0 and bd.is_deleted = 0
        left join YWXT.blade_role br on locate(br.id,bu.role_id)>0 and br.is_deleted = 0
        where bu.is_deleted = 0
        and br.role_alias = #{roleAlias}
        <if test="roleAlias != null and roleAlias == 'qxglywuser'">
            and (br.role_alias = #{roleAlias} or br.role_alias = 'qxswjgly')
        </if>
        <if test="roleAlias != null and roleAlias == 'sdglywuser'">
            and (br.role_alias = #{roleAlias} or br.role_alias = 'dsswjgly')
        </if>
        and bd.ad_code = #{adCode}
        limit 3
        and bu.TYPE is null order by role_name desc,name asc
        limit 1
    </select>
    <select id="getPatrolResponsiblePersonByResCdList"
            resultType="cn.gistack.sm.sjztmd.entity.PatrolResponsiblePerson">

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

@@ -160,9 +160,10 @@
        // 查询当前水库对应的市级编号和县区编号
        AttResBaseVO attResBaseVO = attResBaseService.getCityCountyCodeByResGuid(res_cd);
        if (null!= attResBaseVO) {
            // 通过编号查询对应的人员
            List<PersonVO> cityPerson = baseMapper.getCityCountyPersonListByResGuid(attResBaseVO.getCityCode(), "sdglywuser", "市州水库管理业务人员");
            // 通过编号查询对应的人员   先区县后市州
            List<PersonVO> countyPerson = baseMapper.getCityCountyPersonListByResGuid(attResBaseVO.getCountyCode(), "qxglywuser", "区县水库管理业务人员");
            List<PersonVO> cityPerson = baseMapper.getCityCountyPersonListByResGuid(attResBaseVO.getCityCode(), "sdglywuser", "市州水库管理业务人员");

            // 和
            personVOList.addAll(cityPerson);
            personVOList.addAll(countyPerson);