| | |
| | | <!--派遣公司分页信息--> |
| | | <select id="selectDispatcherUnitPage" resultType="org.springblade.modules.dispatcher.vo.DispatcherUnitVO"> |
| | | select |
| | | sdu.*,bt.dept_name tenantName |
| | | sdu.*,bt.dept_name deptName |
| | | from |
| | | sys_dispatcher_unit sdu |
| | | LEFT JOIN |
| | |
| | | sdu.dept_id = bt.id |
| | | WHERE |
| | | 1=1 |
| | | <if test="dispatcherUnit.tenantName!=null and dispatcherUnit.tenantName!=''"> |
| | | and bt.dept_name like concat('%', #{dispatcherUnit.tenantName},'%') |
| | | <if test="dispatcherUnit.deptName!=null and dispatcherUnit.deptName!=''"> |
| | | and bt.dept_name like concat('%', #{dispatcherUnit.deptName},'%') |
| | | </if> |
| | | <if test="dispatcherUnit.name!=null and dispatcherUnit.name!=''"> |
| | | and sdu.name like concat('%', #{dispatcherUnit.name},'%') |
| | |
| | | sdu.dept_id = bt.id |
| | | WHERE |
| | | 1=1 |
| | | <if test="dispatcherUnit.tenantName!=null and dispatcherUnit.tenantName!=''"> |
| | | and bt.dept_name like concat('%', #{dispatcherUnit.tenantName},'%') |
| | | <if test="dispatcherUnit.deptName!=null and dispatcherUnit.deptName!=''"> |
| | | and bt.dept_name like concat('%', #{dispatcherUnit.deptName},'%') |
| | | </if> |
| | | <if test="dispatcherUnit.name!=null and dispatcherUnit.name!=''"> |
| | | and sdu.name like concat('%', #{dispatcherUnit.name},'%') |
| | |
| | | <!--派遣公司详细信息--> |
| | | <select id="selectDispatcherUnitInfo" resultType="org.springblade.modules.dispatcher.vo.DispatcherUnitVO"> |
| | | select |
| | | sdu.*,bt.dept_name tenantName |
| | | sdu.*,bt.dept_name deptName |
| | | from |
| | | sys_dispatcher_unit sdu |
| | | LEFT JOIN |