机构区划

linwei

2026-01-28 f75a068b1455902ba5514100b815f0f463da2533

机构区划

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdManageDeviceMapper.xml

@@ -37,10 +37,7 @@
        <where>
                and md.is_deleted = 0
            <if test="param2.deviceName != null and param2.deviceName != ''">
                and md.device_name like concat('%',#{param2.deviceName},'%')
            </if>
            <if test="param2.nickname != null and param2.nickname != ''">
                and md.nickname like concat('%',#{param2.nickname},'%')
                and md.nickname like concat('%',#{param2.deviceName},'%')
            </if>
            <if test="param2.deptId != null">
                and md.create_dept = #{param2.deptId}

 drone-service/drone-system/src/main/java/org/sxkj/system/mapper/RegionMapper.xml

@@ -148,16 +148,19 @@
                region_level = '4' THEN district_name
            WHEN
                region_level = '3' THEN city_name
            WHEN
                region_level = '2' THEN province_name
            ELSE NULL
            END AS parent_name
        FROM
            blade_region
        <where>
            city_code = '360800000000'
            <if test="param2.status!=null">
                and status = #{param1.status}
            </if>
            <if test="param2.cityCode!=null and param2.cityCode!='' ">
                and city_code like concat(concat('%', #{param2.cityCode}),'%')
                and code like concat(concat('%', #{param2.cityCode}),'%')
            </if>
            <if test="param2.districtName!=null and param2.districtName!=''">
                and district_name like concat(concat('%', #{param2.districtName}),'%')