| | |
| | | .selectAll(DuSolution.class) |
| | | .selectAs(Solutions::getName,DuSolution::getSolutionName) |
| | | .leftJoin(Solutions.class,Solutions::getId,DuSolution::getSolutionId) |
| | | .leftJoin(CompanySolution.class,CompanySolution::getSolutionId,Solutions::getId) |
| | | .eq(DuSolution::getDispatchUnitId,dispatchUnit.getId()) |
| | | .eq(CompanySolution::getCompanyId,dispatchUnit.getCompanyId()) |
| | | .orderByAsc(DuSolution::getSortnum) |
| | | ); |
| | | if(CollectionUtils.isNotEmpty(duSolutionList)){ |
| | |
| | | .eq(DispatchUnit::getStatus,Constants.ZERO) |
| | | .select("(select b.id from du_solution b where b.isdeleted=0 and b.dispatch_unit_id=t.id and b.solution_id="+dispatchUnitQueryDTO.getSolutionId()+" order by b.CHECK_DATE desc limit 1) as du_solution_id" ) |
| | | .eq(loginUserInfo.getType().equals(Constants.ONE),DispatchUnit::getCompanyId,loginUserInfo.getCompanyId()) |
| | | .eq(Objects.nonNull(dispatchUnitQueryDTO.getCompanyId()),DispatchUnit::getCompanyId,dispatchUnitQueryDTO.getCompanyId()) |
| | | .eq(Objects.isNull(dispatchUnitQueryDTO.getDataType()),DispatchUnit::getDataType,Constants.TWO) |
| | | .eq(!Objects.isNull(dispatchUnitQueryDTO.getDataType()),DispatchUnit::getDataType,dispatchUnitQueryDTO.getDataType()) |
| | | .exists(!Objects.isNull(dispatchUnitQueryDTO.getSolutionId()), |