四个责任人sql修改

xieb

2023-07-03 2287dcd88e9e934ecb64da875445474fe2fe42f4

四个责任人sql修改

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

@@ -28,13 +28,12 @@
    /**
     * 获取水库对应责任人分页数据
     * @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("p_ad_code") String p_ad_code,
                                                  @Param("params") Map<String, Object> params);

    /**

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

@@ -35,6 +35,9 @@
        trmp5."user_unit" patrolUnitName,trmp5."user_name" patrolUsername,trmp5."user_phone" patrolPhone,trmp5."position" patrolPosition,trmp5."guid" patrolUserGuid
        from SJZT_MD."att_res_base" arb
        left join "SJZT_MD"."att_ad_base" aab on aab."guid" = arb."interior_ad_guid"
        left join "SJZT_MD"."att_ad_base" aa on aab."p_ad_code" = aa."ad_code"
        left join "SJZT_MD"."att_ad_base" ab on aa."p_ad_code" = ab."ad_code"
        left join "SJZT_MD"."att_ad_base" ac on ab."p_ad_code" = ac."ad_code"
        left join (
        select "res_guid",WM_Concat("guid") "guid",WM_Concat("user_unit") "user_unit",WM_Concat("user_name") "user_name",WM_Concat("user_phone") "user_phone",WM_Concat("position") "position"
        from "SJZT_MD"."att_res_manage_person" where  "type"=1 GROUP BY "res_guid"
@@ -97,11 +100,9 @@
                )
            )
        </if>
        <if test="p_ad_code != null and p_ad_code !='' ">
            and aab."p_ad_code" like CONCAT(#{p_ad_code},'%')
        </if>
        <if test="ad_code != null and ad_code !='' ">
            and aab."ad_code" = #{ad_code}

        <if test="params.adCode != null and params.adCode != '' ">
            and (aab."ad_code" = #{params.adCode} or aa."ad_code" = #{params.adCode} or ab."ad_code" = #{params.adCode} or ac."ad_code" = #{params.adCode})
        </if>
    </select>


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

@@ -57,27 +57,12 @@
    @Override
    public Object getAttResBaseUserPage(IPage<AttResBaseUserDTO> page,Map<String, Object> params) {

        Object adCode = params.get("adCode");
        Object adGrad = params.get("adGrad");
        String ad_code = "";
        String p_ad_code = "";
        String code = adCode.toString();
        if (adGrad.toString().equals("1")) {
            p_ad_code = code.substring(0,2);
        } else if (adGrad.toString().equals("2")) {
            p_ad_code = code.substring(0,4);
        } else if (adGrad.toString().equals("3")) {
            p_ad_code = code.substring(0,7);
        } else {
            ad_code = code;
        }

        Object isExport = params.get("isExport");
        // 判断是否导出，导出不分页
        if (null != isExport && !isExport.equals("")) {
            return baseMapper.getAttResBaseUserPage(null,ad_code,p_ad_code,params);
            return baseMapper.getAttResBaseUserPage(null,params);
        }
        List<AttResBaseUserDTO> attResBaseUserDTOList = baseMapper.getAttResBaseUserPage(page,ad_code,p_ad_code,params);
        List<AttResBaseUserDTO> attResBaseUserDTOList = baseMapper.getAttResBaseUserPage(page,params);
        // 返回数据
        return page.setRecords(attResBaseUserDTOList);
    }