skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml
@@ -11,10 +11,10 @@ SELECT COUNT(*) totalNum, SUM(CASE WHEN (tdis."check_state" = 1 or tdis."check_state" = 2) THEN 1 ELSE 0 END) as finishNum SUM(CASE WHEN (tdis."check_state" = 3) THEN 1 ELSE 0 END) as finishNum from SJZT_MD."tb_res_dyke" trd LEFT JOIN SJZT_MD."tb_dyke_investigation_state" tdis ON tdis."dyke_guid" = trd."guid" AND (tdis."check_state" = 1 or tdis."check_state" = 2) LEFT JOIN SJZT_MD."tb_dyke_investigation_state" tdis ON tdis."dyke_guid" = trd."guid" AND (tdis."check_state" = 3) <if test="params.tbYear != null and params.tbYear !=''"> AND tdis."tb_year" = #{params.tbYear} </if> skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml
@@ -95,10 +95,10 @@ FROM( SELECT COUNT(*) totalNum, SUM(CASE WHEN (trgis."check_state" = 1 or trgis."check_state" = 2) THEN 1 ELSE 0 END) as finishNum SUM(CASE WHEN (trgis."check_state" = 3) THEN 1 ELSE 0 END) as finishNum from <include refid="resBase"/> LEFT JOIN SJZT_MD."tb_res_general_investigation_state" trgis ON trgis."res_guid" = arb."code" AND (trgis."check_state" = 1 or trgis."check_state" = 2) LEFT JOIN SJZT_MD."tb_res_general_investigation_state" trgis ON trgis."res_guid" = arb."code" AND (trgis."check_state" = 3) <if test="params.tbYear != null and params.tbYear !=''"> AND trgis."tb_year" = #{params.tbYear} </if>
