guoshilong
2024-03-18 75b096f16c41a34aaa50f421548bf501e84f49e5
堤坝列表行政区划筛选
2 files modified
22 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResDykeMapper.xml 2 ●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java 20 ●●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResDykeMapper.xml
@@ -12,7 +12,7 @@
        LEFT JOIN YWXT."att_ad_base" aab ON aab."guid" = trd."ad_code"
        <where>
            <if test="vo.adCode != null and vo.adCode !=''">
                trd."ad_code" = #{vo.adCode}
                and trd."ad_code" LIKE #{vo.adCode}
            </if>
            <if test="vo.name != null and vo.name !=''">
                trd."name" LIKE CONCAT('%',#{vo.name},'%')
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbResDykeServiceImpl.java
@@ -23,6 +23,26 @@
    @Override
    public Object getList(IPage<TbResDykeVO> page, TbResDykeVO tbResDykeVO) {
        if (StringUtil.isNotBlank(tbResDykeVO.getAdCode())){
            //若行政区划不为空
            String adCode =tbResDykeVO.getAdCode();
            if (adCode.substring(0,4).indexOf("00") > -1) {
                //前四位包含00说明是湖北省      4200/00000000
                adCode =StringUtil.format("%{}%",adCode.substring(0,2));
            } else if (adCode.substring(0,6).indexOf("00") > -1) {
                //前六位包含00说明是市级    420100/000000
//                adCode = paramAd.substring(0,4);
                adCode =StringUtil.format("%{}%",adCode.substring(0,4));
            }else if (adCode.substring(0,8).indexOf("00") > -1){
                //前8位包含00 说明是区级     42011700/0000
//                adCode = paramAd.substring(0,6);
                adCode =StringUtil.format("%{}%",adCode.substring(0,6));
            }
            tbResDykeVO.setAdCode(adCode);
        }
        if (tbResDykeVO.getIsPage()){
            return page.setRecords(baseMapper.getPage(page,tbResDykeVO));
        }else {