| | |
|---|
| | | LambdaQueryWrapper<SysUser> queryWrapper = new LambdaQueryWrapper<>(); |
|---|
| | | queryWrapper.eq(SysUser::getPost, positionCode); |
|---|
| | | if(StringUtils.isNotBlank(equipmentCode)) { |
|---|
| | | queryWrapper.isNull(SysUser::getEquipmentIds); |
|---|
| | | queryWrapper.or().eq(SysUser::getEquipmentIds, ""); |
|---|
| | | queryWrapper.or().like(SysUser::getEquipmentIds, equipmentCode); |
|---|
| | | queryWrapper.and(q -> q.isNull(SysUser::getEquipmentIds).or().eq(SysUser::getEquipmentIds, "").or().like(SysUser::getEquipmentIds, equipmentCode)); |
|---|
| | | } |
|---|
| | | if(StringUtils.isNotBlank(productionId)) { |
|---|
| | | queryWrapper.exists("select 1 from mdc_user_production t where t.user_id=id and t.pro_id={0}", productionId); |
|---|
| | | queryWrapper.exists("select 1 from mdc_user_production t where t.user_id=sys_user.id and t.pro_id={0}", productionId); |
|---|
| | | } |
|---|
| | | queryWrapper.eq(SysUser::getDelFlag, CommonConstant.DEL_FLAG_0); |
|---|
| | | queryWrapper.eq(SysUser::getStatus, CommonConstant.DEL_FLAG_1); |
|---|
