返回父级

guoshilong

2024-03-23 918d4a89f7f3f441e46330f1bbe4534933f1c12b

返回父级

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

@@ -388,11 +388,11 @@
    </select>
    <select id="getStatisticsTable" resultType="cn.gistack.sm.sjztmd.statisticsVO.StatisticsTable">



        SELECT
        aab."guid" adCode,
        aab."ad_name" adName,
        paab."guid" padCode,
        paab."ad_name" padName,
        (
        SELECT COUNT(*)
        from(
@@ -481,6 +481,7 @@
        and tdis."check_state" = 2
        )checkDykeNum
        FROM YWXT."att_ad_base" aab
        LEFT JOIN YWXT."att_ad_base" paab ON paab."guid" = aab."p_ad_code"
        where
        <if test="params.adCode != null and params.adCode != null">
            aab."p_ad_code" = #{params.adCode}

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

@@ -5,6 +5,9 @@
@Data
public class StatisticsTable {

        private String padCode;
        private String padName;

        private String adCode;
        private String adName;