进度统计列表新增累计完成资金支付、累计到达资金统计

xieb

2024-09-28 e622d467a99da0199928b0945e37f3b65efe1e8f

进度统计列表新增累计完成资金支付、累计到达资金统计

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

@@ -313,6 +313,11 @@
                tb."local_fund"
                from sjzt_md."tb_project" tb
                LEFT JOIN YWXT."att_ad_base" province ON province."ad_code" = tb."city_code"
                <where>
                    <if test="params.tbYear != null and params.tbYear !=''">
                        AND tb."tb_year" = #{params.tbYear}
                    </if>
                </where>
            )tb on ((tb.countyCode = aab."guid") or (tb.cityCode = aab."guid") or (tb.provinceCode = aab."guid"))
            group by aab."guid",aab."ad_name"
        ) project on project."guid" = aab."guid"