派遣单位，派遣记录查询新增辖区筛选

Administrator

2021-09-28 9b2926bb808101f86d3657c2bcb8672849d53d61

派遣单位，派遣记录查询新增辖区筛选

 src/main/java/org/springblade/modules/dispatcher/mapper/DispatcherMapper.xml

@@ -26,7 +26,14 @@
            blade_user bu
        on
            bu.id = sd.user_ids
        left join
            sys_jurisdiction sj
        on
            sj.id = sdu.jurisdiction
        where 1=1
        <if test="dispatcher.jurisdiction!=null  and dispatcher.jurisdiction!=''">
            and (sj.id = #{dispatcher.jurisdiction} or sj.parent_id = #{dispatcher.jurisdiction})
        </if>
        <if test="dispatcher.dispatcherUnitId!=null">
            and sd.dispatcher_unit_id = #{dispatcher.dispatcherUnitId}
        </if>

 src/main/java/org/springblade/modules/dispatcher/mapper/DispatcherUnitMapper.xml

@@ -37,7 +37,7 @@
            and sdu.city = #{dispatcherUnit.city}
        </if>
        <if test="dispatcherUnit.jurisdiction!=null">
            and sdu.jurisdiction = #{dispatcherUnit.jurisdiction}
            and (sj.id = #{dispatcherUnit.jurisdiction} or sj.parent_id = #{dispatcherUnit.jurisdiction})
        </if>
        <if test="dispatcherUnit.deptId!=null and dispatcherUnit.deptId!=''">
            and sdu.dept_id = #{dispatcherUnit.deptId}