hbwri/skjcmanager.git

			@@ -36,7 +36,7 @@

			(
			SELECT TRGI."tb_state_id",TRGI."res_guid",
			SUM(CASE WHEN trgi."hazard_rating" != '无危害' THEN 1 ELSE 0 END) AS totalLength,
			SUM(CASE WHEN trgi."hazard_rating" != '无危害' THEN trgi."investigation_length" ELSE 0 END) AS totalLength,

			SUM(CASE WHEN trgi."hazard_rating" = 'I' THEN trgi."investigation_length" ELSE 0 END) AS firstLength,
			SUM(CASE WHEN trgi."hazard_rating" = 'II' THEN trgi."investigation_length" ELSE 0 END) AS secondLength,

			@@ -88,7 +88,7 @@

			(
			SELECT tdi."tb_state_id",tdi."dyke_guid",
			SUM(CASE WHEN tdi."hazard_rating" != '无危害' THEN 1 ELSE 0 END) AS totalLength,
			SUM(CASE WHEN tdi."hazard_rating" != '无危害' THEN tdi."investigation_length" ELSE 0 END) AS totalLength,

			SUM(CASE WHEN tdi."hazard_rating" = 'I' THEN tdi."investigation_length" ELSE 0 END) AS firstLength,
			SUM(CASE WHEN tdi."hazard_rating" = 'II' THEN tdi."investigation_length" ELSE 0 END) AS secondLength,
			@@ -122,8 +122,7 @@
			)
			</if>
			<if test="vo.adCode != null and vo.adCode != '' ">
			and (aa."ad_code" = #{vo.adCode} or ab."ad_code" = #{vo.adCode} or ac."ad_code" =
			#{vo.adCode} or ad."ad_code" = #{vo.adCode})
			and (aa."ad_code" = #{vo.adCode} or ab."ad_code" = #{vo.adCode} or ac."ad_code" = #{vo.adCode} or ad."ad_code" = #{vo.adCode})
			</if>
			</select>
			</mapper>

	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml	2 ●●●●● patch \| view \| raw \| blame \| history
	skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResDykeMapper.xml	5 ●●●●● patch \| view \| raw \| blame \| history