src/main/java/org/springblade/modules/dispatcher/controller/DispatcherUnitController.java
@@ -229,7 +229,7 @@ * @return */ @GetMapping("getAll") public R getAll(DispatcherUnit dispatcherUnit){ public R getAll(DispatcherUnitVO dispatcherUnit){ List<DispatcherUnitVO> list = dispatcherUnitService.getAll(dispatcherUnit); return R.data(list); } src/main/java/org/springblade/modules/dispatcher/mapper/DispatcherUnitMapper.java
@@ -45,7 +45,7 @@ List<DispatcherUnitVO> selectDispatcherUnitPage(IPage page, @Param("dispatcherUnit") DispatcherUnitVO dispatcherUnit); List<DispatcherUnitVO> getAll( @Param("dispatcherUnit")DispatcherUnit dispatcherUnit); List<DispatcherUnitVO> getAll( @Param("dispatcherUnit")DispatcherUnitVO dispatcherUnit); /** * 派遣公司信息详情 src/main/java/org/springblade/modules/dispatcher/mapper/DispatcherUnitMapper.xml
@@ -16,8 +16,16 @@ sys_jurisdiction sj on sj.id = sdu.jurisdiction LEFT JOIN blade_dict_biz bdb ON bdb.dict_key = sdu.profession and bdb.is_deleted = 0 WHERE 1=1 and bdb.code = 'dispatchProfession' <if test="dispatcherUnit.profession != null and dispatcherUnit.profession !=''"> and sdu.profession in <foreach collection="dispatcherUnit.profession.split(',')" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </if> <if test="dispatcherUnit.deptName!=null and dispatcherUnit.deptName!=''"> and bt.dept_name like concat('%', #{dispatcherUnit.deptName},'%') </if> @@ -80,7 +88,7 @@ <select id="getAll" resultType="org.springblade.modules.dispatcher.vo.DispatcherUnitVO"> select sdu.*,bt.dept_name deptName,sj.dept_name jurisdictionName sdu.*,bt.dept_name deptName,sj.dept_name jurisdictionName,bdb.dict_value as professionName from sys_dispatcher_unit sdu LEFT JOIN @@ -91,8 +99,16 @@ sys_jurisdiction sj on sj.id = sdu.jurisdiction LEFT JOIN blade_dict_biz bdb ON bdb.dict_key = sdu.profession and bdb.is_deleted = 0 WHERE 1=1 and bdb.code = 'dispatchProfession' <if test="dispatcherUnit.profession != null and dispatcherUnit.profession !=''"> and sdu.profession in <foreach collection="dispatcherUnit.profession.split(',')" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </if> <if test="dispatcherUnit.deptName!=null and dispatcherUnit.deptName!=''"> and bt.dept_name like concat('%', #{dispatcherUnit.deptName},'%') </if> src/main/java/org/springblade/modules/dispatcher/service/IDispatcherUnitService.java
@@ -44,7 +44,7 @@ IPage<DispatcherUnitVO> selectDispatcherUnitPage(IPage<DispatcherUnitVO> page, DispatcherUnitVO dispatcher); List<DispatcherUnitVO> getAll(DispatcherUnit dispatcherUnit); List<DispatcherUnitVO> getAll(DispatcherUnitVO dispatcherUnit); /** * 派遣公司信息详情 src/main/java/org/springblade/modules/dispatcher/service/impl/DispatcherUnitServiceImpl.java
@@ -68,7 +68,7 @@ } @Override public List<DispatcherUnitVO> getAll(DispatcherUnit dispatcherUnit) { public List<DispatcherUnitVO> getAll(DispatcherUnitVO dispatcherUnit) { List<DispatcherUnitVO> dispatcherUnitVOS = baseMapper.getAll(dispatcherUnit); dispatcherUnitVOS.forEach(dispatcherUnitVO1 -> { //查询派遣记录条数 src/main/java/org/springblade/modules/dispatcher/vo/DispatcherUnitVO.java
@@ -67,4 +67,6 @@ * 是否到期 */ private Integer isExpire; private String professionName; } src/main/java/org/springblade/modules/system/mapper/UserMapper.xml
@@ -493,9 +493,9 @@ <if test="user.jurisdiction!=null and user.jurisdiction != ''"> and bu.jurisdiction = #{user.jurisdiction} </if> <if test="user.unitName!=null and user.unitName != ''"> and bud.unit_name like concat('%', #{user.unitName},'%') </if> <!-- <if test="user.unitName!=null and user.unitName != ''">--> <!-- and bud.unit_name like concat('%', #{user.unitName},'%')--> <!-- </if>--> <if test="user.securitynumber!=null and user.securitynumber != ''"> and bu.securitynumber = #{user.securitynumber} </if>