From a40e6a45b2207a9b172b7687ce6e4fe7da8b9ac6 Mon Sep 17 00:00:00 2001 From: liukangdong <898885815@qq.com> Date: 星期二, 03 十二月 2024 16:46:49 +0800 Subject: [PATCH] Merge branch 'master' of http://139.186.142.91:10010/r/productDev/funingyunwei --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwWorkorderServiceImpl.java | 68 +++++++++++++++++++++++++++------ 1 files changed, 55 insertions(+), 13 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwWorkorderServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwWorkorderServiceImpl.java index f4c95e9..81d8e1e 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwWorkorderServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/YwWorkorderServiceImpl.java @@ -79,11 +79,12 @@ if(StringUtils.isBlank(multifile.getFileurl())){ continue; } - multifile.setCreateDate(new Date()); + multifile.setCreateDate(model.getCreateDate()); + multifile.setEditDate(model.getCreateDate()); multifile.setCreator(model.getEditor()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjId(model.getId()); - multifile.setCreator(model.getCreator()); + multifile.setEditor(model.getCreator()); multifile.setObjType(Constants.MultiFile.YW_WORKORDER_PROBLEM.getKey()); multifile.setSortnum(i+1); fileList.add(multifile); @@ -169,7 +170,9 @@ if(model ==null || Constants.equalsInteger(model.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝宸ュ崟淇℃伅涓嶅瓨鍦紒"); } - if(!Constants.equalsInteger(model.getDealStatus(),Constants.ZERO) && !Constants.equalsInteger(model.getDealStatus(),Constants.ONE)){ + if(!Constants.equalsInteger(model.getDealStatus(),Constants.ZERO) +// && !Constants.equalsInteger(model.getDealStatus(),Constants.ONE) + ){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝宸ュ崟鐘舵�佸凡娴佽浆锛屼笉鏀寔褰撳墠鎿嶄綔锛�"); } @@ -200,10 +203,10 @@ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝宸ュ崟鐘舵�佸凡娴佽浆锛屼笉鏀寔褰撳墠鎿嶄綔锛�"); } - SystemUser user = systemUserMapper.selectById(ywWorkorder.getDealUserId()); - if(user ==null || (user.getDeleted()!=null&& user.getDeleted() )){ - throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅涓嶅瓨鍦紒"); - } +// SystemUser user = systemUserMapper.selectById(ywWorkorder.getDealUserId()); +// if(user ==null || (user.getDeleted()!=null&& user.getDeleted() )){ +// throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"瀵逛笉璧凤紝鍛樺伐淇℃伅涓嶅瓨鍦紒"); +// } YwWorkorder update = new YwWorkorder(); update.setId(model.getId()); update.setEditDate(new Date()); @@ -211,8 +214,30 @@ update.setDealStatus(Constants.TWO); update.setDealUserId(update.getEditor()); update.setDealDate(update.getEditDate()); - update.setDealInfo(ywWorkorder.getDispatchInfo()); + update.setDealInfo(ywWorkorder.getDealInfo()); ywWorkorderMapper.updateById(update); + + List<Multifile> fileList = new ArrayList<>(); + if(ywWorkorder.getDealFileList()!=null && ywWorkorder.getDealFileList().size()>0){ + for (int i = 0; i < ywWorkorder.getDealFileList().size(); i++) { + Multifile multifile = ywWorkorder.getDealFileList().get(i); + if(StringUtils.isBlank(multifile.getFileurl())){ + continue; + } + multifile.setCreateDate(update.getEditDate()); + multifile.setCreator(update.getEditor()); + multifile.setEditDate(update.getEditDate()); + multifile.setIsdeleted(Constants.ZERO); + multifile.setObjId(model.getId()); + multifile.setEditor(update.getEditor()); + multifile.setObjType(Constants.MultiFile.YW_WORKORDER_DEAL.getKey()); + multifile.setSortnum(i+1); + fileList.add(multifile); + } + } + if(fileList.size()>0){ + multifileMapper.insert(fileList); + } dealLogBiz(model,Constants.YwLogType.WORKORDER_DEAL,ywWorkorder.getLoginUserInfo().getRealname(),null);//璁板綍鏂板缓鏃ュ織 } @Override @@ -298,18 +323,25 @@ 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);//璇诲彇闄勪欢淇℃伅 @@ -350,17 +382,29 @@ .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(YwRoom.class,YwRoom::getId,YwWorkorder::getRoomId) .leftJoin(YwFloor.class,YwFloor::getId,YwWorkorder::getFloorId) - .leftJoin(YwBuilding.class,YwBuilding::getId,YwWorkorder::getBuildingId); + .leftJoin(YwBuilding.class,YwBuilding::getId,YwWorkorder::getBuildingId) + .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()); } @@ -385,7 +429,8 @@ queryWrapper.eq(YwWorkorder::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getStatus() != null) { - queryWrapper.eq(YwWorkorder::getStatus, pageWrap.getModel().getStatus()); + queryWrapper.eq(!Constants.equalsInteger(pageWrap.getModel().getStatus(),-1),YwWorkorder::getStatus, pageWrap.getModel().getStatus()); + queryWrapper.in(Constants.equalsInteger(pageWrap.getModel().getStatus(),-1),YwWorkorder::getStatus, Constants.ZERO,Constants.ONE); } if (pageWrap.getModel().getSortnum() != null) { queryWrapper.eq(YwWorkorder::getSortnum, pageWrap.getModel().getSortnum()); @@ -427,9 +472,6 @@ } 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())); -- Gitblit v1.9.3