| | |
|---|
| | | MPJLambdaWrapper<YwWorkorder> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | queryWrapper.selectAll(YwWorkorder.class ) |
|---|
| | | .selectAs(SystemUser::getRealname,YwWorkorder::getDealUserName) |
|---|
| | | .selectAs(Company::getName,YwWorkorder::getDealUserCompany) |
|---|
| | | .select("t3.realname",YwWorkorder::getCreatorName) |
|---|
| | | .select("t3.mobile",YwWorkorder::getCreatorMobile) |
|---|
| | | .select("t9.name",YwWorkorder::getCreatorCompany) |
|---|
| | | .selectAs(Category::getName,YwWorkorder::getCategoryName) |
|---|
| | | .selectAs(YwRoom::getName,YwWorkorder::getRoomName) |
|---|
| | | .selectAs(YwRoom::getRoomNum,YwWorkorder::getRoomNum) |
|---|
| | | .selectAs(YwFloor::getName,YwWorkorder::getFloorName) |
|---|
| | | .selectAs(YwBuilding::getName,YwWorkorder::getBuildingName) |
|---|
| | | .selectAs(YwProject::getName,YwWorkorder::getProjectName) |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,YwWorkorder::getDealUserId) |
|---|
| | | .leftJoin(Category.class,Category::getId,YwWorkorder::getCateId) |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,YwWorkorder::getCreator) |
|---|
| | | .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) |
|---|
| | | .leftJoin(YwRoom.class,YwRoom::getId,YwWorkorder::getRoomId) |
|---|
| | | .leftJoin(YwFloor.class,YwFloor::getId,YwWorkorder::getFloorId) |
|---|
| | | .leftJoin(YwBuilding.class,YwBuilding::getId,YwWorkorder::getBuildingId) |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) |
|---|
| | | .leftJoin(" company t9 on t9.id = t1.company_id ") |
|---|
| | | .eq(YwWorkorder::getId,id); |
|---|
| | | YwWorkorder model = ywWorkorderMapper.selectJoinOne(YwWorkorder.class,queryWrapper); |
|---|
| | | initFiles(model);//读取附件信息 |
|---|
| | |
|---|
| | | .leftJoin(YwRoom.class,YwRoom::getId,YwWorkorder::getRoomId) |
|---|
| | | .leftJoin(YwFloor.class,YwFloor::getId,YwWorkorder::getFloorId) |
|---|
| | | .leftJoin(YwBuilding.class,YwBuilding::getId,YwWorkorder::getBuildingId) |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwBuilding::getProjectId); |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwBuilding::getProjectId) |
|---|
| | | .apply(StringUtils.isNotBlank(pageWrap.getModel().getQueryStatus())," find_in_set(t.DEAL_STATUS ,'"+pageWrap.getModel().getQueryStatus()+"') "); |
|---|
| | | pageWrap.getModel().setIsdeleted(Constants.ZERO); |
|---|
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
|---|
| | | if (pageWrap.getModel().getId() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getId, pageWrap.getModel().getId()); |
|---|
| | | } |
|---|
| | | if (pageWrap.getModel().getDispatchUserId() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getDispatchUserId, pageWrap.getModel().getDispatchUserId()); |
|---|
| | | } |
|---|
| | | if(Objects.nonNull(pageWrap.getModel().getRoomName())){ |
|---|
| | | queryWrapper.and(i->i.like(YwFloor::getName,pageWrap.getModel().getRoomName()).or() |
|---|
| | | .like(YwRoom::getRoomNum,pageWrap.getModel().getRoomName()) |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (pageWrap.getModel().getCreator() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getCreator, pageWrap.getModel().getCreator()); |
|---|
| | | } |
|---|
| | |
|---|
| | | } |
|---|
| | | if (pageWrap.getModel().getDealStatus() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getDealStatus, pageWrap.getModel().getDealStatus()); |
|---|
| | | } |
|---|
| | | if (pageWrap.getModel().getDispatchUserId() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getDispatchUserId, pageWrap.getModel().getDispatchUserId()); |
|---|
| | | } |
|---|
| | | if (pageWrap.getModel().getDispatchDate() != null) { |
|---|
| | | queryWrapper.ge(YwWorkorder::getDispatchDate, Utils.Date.getStart(pageWrap.getModel().getDispatchDate())); |
|---|
