| | |
|---|
| | | .selectAs(YwFloor::getName,YwWorkorder::getFloorName) |
|---|
| | | .selectAs(YwBuilding::getName,YwWorkorder::getBuildingName) |
|---|
| | | .selectAs(YwProject::getName,YwWorkorder::getProjectName) |
|---|
| | | .selectAs(YwProblem::getId,YwWorkorder::getProblemId) |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,YwWorkorder::getDealUserId) |
|---|
| | | .leftJoin(Category.class,Category::getId,YwWorkorder::getCateId) |
|---|
| | | .leftJoin(SystemUser.class,SystemUser::getId,YwWorkorder::getCreator) |
|---|
| | |
|---|
| | | .leftJoin(YwFloor.class,YwFloor::getId,YwWorkorder::getFloorId) |
|---|
| | | .leftJoin(YwBuilding.class,YwBuilding::getId,YwWorkorder::getBuildingId) |
|---|
| | | .leftJoin(YwProject.class,YwProject::getId,YwBuilding::getProjectId) |
|---|
| | | .leftJoin(YwProblem.class,YwProblem::getWorkorderId,YwWorkorder::getId) |
|---|
| | | .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().getCreator() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getCreator, pageWrap.getModel().getCreator()); |
|---|
| | | } |
|---|
| | | if (pageWrap.getModel().getOrigin() != null) { |
|---|
| | | queryWrapper.eq(YwWorkorder::getOrigin, pageWrap.getModel().getOrigin()); |
|---|
| | | } |
|---|
| | | if (pageWrap.getModel().getCreateDate() != null) { |
|---|
| | | queryWrapper.ge(YwWorkorder::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); |
|---|
| | | queryWrapper.le(YwWorkorder::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); |
|---|
