| skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml | ●●●●● patch | view | raw | blame | history |
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbDykeInvestigationMapper.xml
@@ -263,7 +263,7 @@ <if test="params.tbYear!=null and params.tbYear!=''"> AND tdi."tb_year" = #{params.tbYear} </if> and tdi."investigation_variety" = '白蚁' -- and tdi."investigation_variety" = '白蚁' group by tdi."tb_state_id",tdi."dyke_guid",tdi."unit" )TEMP1 ) tdi on tdi."tb_state_id" = tdis."guid"