| drone-service/drone-system/src/main/java/org/sxkj/system/mapper/RegionMapper.xml | ●●●●● patch | view | raw | blame | history |
drone-service/drone-system/src/main/java/org/sxkj/system/mapper/RegionMapper.xml
@@ -150,7 +150,7 @@ type, sort, remark, "status", status, CASE WHEN region_level = '5' THEN town_name @@ -168,7 +168,7 @@ city_code = '360800000000' and region_level > '2' <if test="param2.status!=null"> and status = #{param1.status} and status = #{param2.status} </if> <if test="param2.cityCode!=null and param2.cityCode!='' "> and code like concat(concat('%', #{param2.cityCode}),'%')