区域树查询修改，新增按条件排除层级

zhongrj

2023-08-24 c4b2f5a72ad6a3a657083e1d12b9b626c1e31270

区域树查询修改，新增按条件排除层级

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttAdBaseMapper.xml

@@ -64,6 +64,9 @@
            <if test="param2.name!=null and param2.name!=''">
                and region."ad_name" like concat(concat('%', #{param2.name}),'%')
            </if>
            <if test="param2.level!=null and param2.level!=''">
                and region."ad_grad" &lt; #{param2.level}
            </if>
            and region."ad_grad" != 4
        </where>
        ORDER BY region."order_id"