| | |
| | | WHERE |
| | | 1 = 1 |
| | | <!-- AND userR.is_his = 0 --> |
| | | <if test="dto.projectName != null and dto.projectName != ''"> |
| | | and report.PROGRAM_NAME like CONCAT(CONCAT('%',#{dto.projectName}),'%') |
| | | </if> |
| | | <if test="dto.deviceName != null and dto.deviceName != ''"> |
| | | and de.device_name like CONCAT(CONCAT('%', #{dto.deviceName}), '%') |
| | | </if> |
| | | <if test="dto.userId != null and dto.userId != ''"> |
| | | and userR.user_id = #{dto.userId} |
| | | </if> |
| | |
| | | SgDeviceDO sgDeviceDO = sgDeviceMapper.selectById(gxDeviceId); |
| | | String deviceType = sgDeviceDO.getDeviceType(); |
| | | List<SgGxConfigDO> sgGxConfigDOS = new LambdaQueryChainWrapper<>(sgGxConfigMapper) |
| | | .eq(SgGxConfigDO::getGxDeviceType, deviceType).eq(SgGxConfigDO::getGxStepId, gxStepId).list(); |
| | | .eq(SgGxConfigDO::getGxDeviceType, deviceType).eq(SgGxConfigDO::getGxStepId, gxStepId).orderByAsc(SgGxConfigDO::getSgOrder).list(); |
| | | List<String> roIds = sgGxConfigDOS.stream().map(SgGxConfigDO::getRoleId).collect(Collectors.toList()); |
| | | if (CollectionUtils.isEmpty(roIds)){ |
| | | throw new ServiceException("请完成工序角色配置!"); |