首页总览待办展示特征水位异常水库接口

guoshilong

2024-04-03 0c1a71e274892b409617a7be937f8a26851b5fde

首页总览待办展示特征水位异常水库接口

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/controller/QualityManageController.java

@@ -120,4 +120,9 @@
        ExcelUtil.export(response, "水库数据质量管理数据" + DateUtil.time(), "水库数据质量管理数据表", list, QualityManageExcel.class);
    }

    @GetMapping("getList")
    public R getList(QualityManageVO qualityManageVO){
        List<QualityManageVO> list = qualityManageService.getList(qualityManageVO);
        return R.data(list);
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/mapper/QualityManageMapper.java

@@ -23,4 +23,6 @@
    Integer addQualityManage(@Param("ruleId") Long ruleId, @Param("varStr") String varStr, @Param("whereStr") String whereStr);

    List<QualityManageExcel> exportData(@Param("vo") QualityManageVO qualityManageVO);

    List<QualityManageVO> getList(@Param("vo") QualityManageVO qualityManageVO);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/mapper/QualityManageMapper.xml

@@ -163,6 +163,71 @@


    </select>
    <select id="getList" resultType="cn.gistack.sm.resDataCheck.vo.QualityManageVO">


        SELECT
        arb."guid" AS resGuid,
        arb."name" AS resName,
        arb."res_loc" AS resLoc,
        case when town."ad_grad" = 4 THEN town."ad_code" ELSE NULL END AS townCode,
        case when town."ad_grad" = 4 THEN town."ad_name" ELSE NULL END AS townName,
        case when town."ad_grad" = 3 THEN town."ad_code"
        when county."ad_grad" = 3 THEN county."ad_code" END AS countyCode,
        case when town."ad_grad" = 3 THEN town."ad_name"
        when county."ad_grad" = 3 THEN county."ad_name" END AS countyName,
        case when town."ad_grad" = 2 THEN town."ad_code"
        when county."ad_grad" = 2 THEN county."ad_code"
        ELSE city."ad_code" END AS cityCode,
        case when town."ad_grad" = 2 THEN town."ad_name"
        when county."ad_grad" = 2 THEN county."ad_name"
        ELSE city."ad_name" END AS cityName,
        case when town."ad_grad" = 1 THEN town."ad_code"
        when county."ad_grad" = 1 THEN county."ad_code"
        when city."ad_grad" = 1 THEN city."ad_code"
        ELSE province."ad_code" END AS provinceCode,
        case when town."ad_grad" = 1 THEN town."ad_name"
        when county."ad_grad" = 1 THEN county."ad_name"
        when city."ad_grad" = 1 THEN city."ad_name"
        ELSE province."ad_name" END AS provinceName,

        qm.val,
        qm.create_time
        FROM (
        select * from  SM_RES_DATA_QUALITY_MANAGE qm
        WHERE qm.is_deleted = 0
        <if test="vo.startTime !=null and vo.startTime !=''">
            AND qm.create_time &gt;= #{vo.startTime}
        </if>
        <if test="vo.endTime !=null and vo.endTime !=''">
            AND qm.create_time &lt;= #{vo.endTime}
        </if>
        ) as qm

        LEFT JOIN SJZT_MD."att_res_base" arb ON arb."guid" = qm.res_id
        LEFT JOIN SM_RES_DATA_CHECK_RULES rule ON rule.id = qm.rule_id

        left join "SJZT_MD"."att_ad_base" town on town."guid" = arb."interior_ad_guid"
        left join "SJZT_MD"."att_ad_base" county on county."ad_code" = town."p_ad_code"
        left join "SJZT_MD"."att_ad_base" city on city."ad_code" = county."p_ad_code"
        left join "SJZT_MD"."att_ad_base" province on province."ad_code" = city."p_ad_code"
        where qm.is_deleted = 0
          and qm.rule_id ='1775403351266652162'
            <if test="vo.resName !=null and vo.resName !='' ">
                AND arb."name" LIKE CONCAT('%',#{vo.resName},'%')
            </if>
            <if test="vo.engScal !=null and vo.engScal !='' ">
                AND arb."eng_scal"  = #{vo.engScal}
            </if>
            <if test="vo.ruleName !=null and vo.ruleName !='' ">
                AND rule.name LIKE CONCAT('%',#{vo.ruleName},'%')
            </if>
            <if test="vo.adCode != null and vo.adCode != '' ">
                and concat(province."ad_code",city."ad_code",county."ad_code",town."ad_code") like CONCAT('%',#{vo.adCode},'%')
            </if>

        order by qm.create_time desc
    </select>


</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/service/IQualityManageService.java

@@ -17,4 +17,6 @@
    Integer addQualityManage(Long ruleId, String varStr, String whereStr);

    List<QualityManageExcel> exportData(QualityManageVO qualityManageVO);

    List<QualityManageVO> getList(QualityManageVO qualityManageVO);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/service/impl/QualityManageServiceImpl.java

@@ -50,4 +50,9 @@
        List<QualityManageExcel> list = baseMapper.exportData(qualityManageVO);
        return list;
    }

    @Override
    public List<QualityManageVO> getList(QualityManageVO qualityManageVO) {
        return baseMapper.getList(qualityManageVO);
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/vo/QualityManageVO.java

@@ -69,4 +69,13 @@

    private String isExport;

    private String provinceCode;
    private String provinceName;
    private String cityCode;
    private String cityName;
    private String countyCode;
    private String countyName;
    private String townCode;
    private String townName;

}