src/main/java/org/springblade/modules/house/mapper/HouseRentalMapper.xml
@@ -104,7 +104,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> src/main/java/org/springblade/modules/place/mapper/PlaceCheckMapper.xml
@@ -375,7 +375,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> src/main/java/org/springblade/modules/place/mapper/PlaceExtMapper.xml
@@ -71,7 +71,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> @@ -169,7 +169,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> src/main/java/org/springblade/modules/place/mapper/PlaceMapper.xml
@@ -266,7 +266,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> @@ -644,7 +644,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> src/main/java/org/springblade/modules/police/mapper/PoliceAlarmRecordsMapper.java
@@ -45,7 +45,7 @@ @Param("vo") PoliceAlarmRecordsVO policeAlarmRecords, @Param("isAdministrator") Integer isAdministrator, @Param("regionChildCodesList") List<String> regionChildCodesList, @Param("vo") List<String> gridCodeList); @Param("gridCodeList") List<String> gridCodeList); } src/main/java/org/springblade/modules/police/mapper/PoliceAlarmRecordsMapper.xml
@@ -13,7 +13,7 @@ LEFT JOIN jczz_police_affairs_grid jpag on jpar.jw_grid_code= jpag.jw_grid_code and jpag.is_deleted = 0 LEFT JOIN blade_region br on br.code = jpag.community_code <where> <if test="vo.status != null "> <if test="vo.status != null"> and jpar.status = #{vo.status} </if> <if test="vo.alarmDescribe != null and vo.alarmDescribe != ''"> @@ -71,14 +71,14 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> </otherwise> </choose> </if> and is_deleted = 0 and jpar.is_deleted = 0 </where> </select>
@@ -331,7 +331,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose> @@ -601,7 +601,7 @@ <otherwise> and ( jg.grid_code in ('') or jpag.community_code in in ('') jg.grid_code in ('') or jpag.community_code in ('') ) </otherwise> </choose>
