| | |
|---|
| | | } |
|---|
| | | if(newWorktypes!=null &&newWorktypes.size()>0){ |
|---|
| | | //批量查询工种关联记录 |
|---|
| | | duWorktypeMapper.insertBatchSomeColumn(newWorktypes); |
|---|
| | | duWorktypeMapper.insert(newWorktypes); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | .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()), |
|---|
