From d891f06d0a46d2e89df61c600e17f4892b3523c8 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期五, 11 四月 2025 11:15:27 +0800 Subject: [PATCH] 代码初始化 --- server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java | 534 ++++++++++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 450 insertions(+), 84 deletions(-) diff --git a/server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java b/server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java index a1eea89..d94a076 100644 --- a/server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java +++ b/server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java @@ -9,10 +9,15 @@ import com.doumee.core.model.PageWrap; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; +import com.doumee.core.utils.qiyeweixin.QywxUtil; +import com.doumee.core.utils.qiyeweixin.model.request.QywxSendMsgRequest; +import com.doumee.core.utils.qiyeweixin.model.request.QywxTextCardMsgRequest; import com.doumee.dao.business.*; import com.doumee.dao.business.model.*; import com.doumee.dao.web.dto.CloseDTO; import com.doumee.dao.web.dto.DCANoProblemDTO; +import com.doumee.dao.web.dto.PassOnDTO; +import com.doumee.dao.web.vo.WorkOrderDataVO; import com.doumee.service.business.WorkorderService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; @@ -23,6 +28,7 @@ import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import org.springframework.util.StringUtils; @@ -72,22 +78,101 @@ workorder.setEditDate(new Date()); workorder.setMemberId(workorder.getMemberId()); workorder.setIsdeleted(Constants.ZERO); - workorder.setStatus(Constants.ZERO); workorder.setCode(this.getNextCode(workorder.getType())); //澶勭悊浜哄憳绫讳俊鎭� this.dealNoticeData(workorder); + //澶勭悊SHE浜嬩欢鐘舵�� + Constants.WorkOrderStatus workOrderStatus = Constants.equalsInteger(workorder.getType(),Constants.ZERO)?Constants.WorkOrderStatus.close:Constants.WorkOrderStatus.waitConfirm; + workorder.setStatus(workOrderStatus.getKey()); workorderMapper.insert(workorder); //瀛樺偍DCA 闂璁板綍琛� this.saveProblemData(workorder); //瀛樺偍闄勪欢淇℃伅 this.saveMutiFile(workorder); - //澶勭悊涓婃姤鏃ュ織 - this.saveLog(null,workorder,Constants.ZERO,workorder.getMemberId()); - //TODO 鍙戦�侀�氱煡 + //瀛樺偍鏃ュ織 + this.dealLogData(workorder,workOrderStatus); + // 鍙戦�佷紒寰�氱煡 + QywxSendMsgRequest qywxSendMsgRequest = new QywxSendMsgRequest(); + qywxSendMsgRequest.setTouser(workorder.getQwnoticeMemberIds().replace(",","|")); + qywxSendMsgRequest.setMsgtype("text"); + qywxSendMsgRequest.setAgentid(null); + QywxTextCardMsgRequest textCard = new QywxTextCardMsgRequest(); + textCard.setTitle(workOrderStatus.getLogTitle()); + + qywxSendMsgRequest.setTextcard(textCard); + QywxUtil.sendMsg(systemDictDataBiz.queryByCode(Constants.QYWX,Constants.QYWX_TOKEN).getCode(), + qywxSendMsgRequest); return workorder.getId(); } + + public void sendQwMsg(Workorder workorder){ + QywxSendMsgRequest qywxSendMsgRequest = new QywxSendMsgRequest(); + QywxTextCardMsgRequest textCard = new QywxTextCardMsgRequest(); + qywxSendMsgRequest.setMsgtype("text"); + qywxSendMsgRequest.setAgentid(null); + textCard.setBtntxt("璇︽儏"); + //鏂版彁浜� + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitConfirm.getKey())){ + qywxSendMsgRequest.setTouser(workorder.getQwnoticeMemberIds().replace(",","|")); + textCard.setUrl(null); + //SHE 鎻愪氦 + if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ + Category category = categoryMapper.selectById(workorder.getType()); + textCard.setTitle("銆怱HE浜嬩欢涓婃姤銆�"); + String message = ""; + if(Constants.equalsInteger(workorder.getMemberType(),Constants.ZERO)){ + message = "鏈汉"; + }else { + message = Constants.equalsInteger(workorder.getMemberType(),Constants.ONE)?"鍚屼簨":"渚涘簲鍟�"; + } + message = message + "-" + workorder.getMemberNames() + " " + DateUtil.formatDate(new Date(),"yyyy-MM-dd HH:mm") + workorder.getLocationName() + category.getName(); + textCard.setDescription(" <div class=\"normal\">"+message+"</div>"); + }else{ + + } + } + qywxSendMsgRequest.setTextcard(textCard); + QywxUtil.sendMsg(systemDictDataBiz.queryByCode(Constants.QYWX,Constants.QYWX_TOKEN).getCode(), + qywxSendMsgRequest); + } + + +// public QywxTextCardMsgRequest dealMessageContent(Workorder workorder,Integer type){ +// QywxTextCardMsgRequest textCard = new QywxTextCardMsgRequest(); +// String message = ""; +// if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ +// Category category = categoryMapper.selectById(workorder.getType()); +// textCard.setTitle("銆怱HE浜嬩欢涓婃姤銆�"); +// if(Constants.equalsInteger(workorder.getMemberType(),Constants.ZERO)){ +// message = "鏈汉"; +// }else { +// message = Constants.equalsInteger(workorder.getMemberType(),Constants.ONE)?"鍚屼簨":"渚涘簲鍟�"; +// } +// message = message + "-" + workorder.getMemberNames() + " " + DateUtil.formatDate(new Date(),"yyyy-MM-dd HH:mm") + workorder.getLocationName() + category.getName(); +// textCard.setDescription(" <div class=\"normal\">"+message+"</div>"); +// }else{ +// textCard.setTitle(Constants.equalsInteger(workorder.getType(),Constants.ONE)?"銆怐CA涓婃姤銆�":"璺岀粖婊戦闄╀笂鎶�"); +// if(Constants.equalsInteger(workorder.getType(),Con)){ +// +// } +// +// +// +// } +// +// } + + + + public void dealLogData(Workorder workorder,Constants.WorkOrderStatus workOrderStatus){ + if (Constants.equalsInteger(workorder.getType(), Constants.THREE) || Constants.equalsInteger(workorder.getType(), Constants.TWO) ) { + //澶勭悊涓婃姤鏃ュ織 DCA宸ュ崟 鏃ュ織瀛樺偍鑷冲瓙涓氬姟 涓嶅瓨鍦ㄤ簬鐖剁骇 涓庤穼缁婃粦 + String logTitle = Constants.equalsInteger(workorder.getType(), Constants.THREE) ? "璺岀粖婊戦闄�" : "DCA"; + this.saveLog(null,workorder,Constants.ZERO,workorder.getMemberId(),workOrderStatus.getLogTitle().replace("{title}",logTitle),null); + } + } /** * 瀛樺偍闄勪欢淇℃伅 @@ -97,15 +182,10 @@ List<Multifile> multifileList = workorder.getMultifileList(); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ for (Multifile multifile:multifileList) { + multifile.setIsdeleted(Constants.ZERO); multifile.setObjId(workorder.getId()); multifile.setCreateDate(new Date()); - if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){//SHE浜嬩欢涓婃姤鍥剧墖 - multifile.setObjType(Constants.multiFileType.sheUpload); - }else if(Constants.equalsInteger(workorder.getType(),Constants.THREE)){//璺岀粖婊戜簨浠朵笂鎶ュ浘鐗� - multifile.setObjType(Constants.multiFileType.dbhUpload); - }else if(Constants.equalsInteger(workorder.getType(),Constants.ONE)){//DCA浜嬩欢涓婃姤 - multifile.setObjType(Constants.multiFileType.dcaUpload); - } + multifile.setObjType(Constants.multiFileType.upload); } multifileMapper.insert(multifileList); } @@ -122,25 +202,30 @@ if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dcaNoProblemDTOList)){ for (DCANoProblemDTO dcaNoProblemDTO:dcaNoProblemDTOList) { Category problem = categoryMapper.selectById(dcaNoProblemDTO.getProblemId()); + Constants.WorkOrderStatus workOrderStatus = Constants.WorkOrderStatus.waitConfirm; Workorder dcaWorkOrder = new Workorder(); dcaWorkOrder.setCreateDate(new Date()); dcaWorkOrder.setEditDate(new Date()); dcaWorkOrder.setMemberId(workorder.getMemberId()); dcaWorkOrder.setTypeId(dcaNoProblemDTO.getProblemId()); dcaWorkOrder.setType(Constants.TWO); - dcaWorkOrder.setStatus(Constants.ZERO); + dcaWorkOrder.setStatus(workOrderStatus.getKey()); dcaWorkOrder.setIsdeleted(Constants.ZERO); dcaWorkOrder.setProblemTitle(problem.getName()); dcaWorkOrder.setProblemId(problem.getId()); dcaWorkOrder.setProblemInfo(problem.getRemark()); dcaWorkOrder.setDcaRecordId(workorder.getId()); + dcaWorkOrder.setEventInfo(dcaNoProblemDTO.getEventInfo()); workorderMapper.insert(dcaWorkOrder); + //瀛樺偍鏃ュ織 + this.dealLogData(dcaWorkOrder,workOrderStatus); List<Multifile> multifileList = dcaNoProblemDTO.getMultifileList(); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ for (Multifile multifile:multifileList) { + multifile.setIsdeleted(Constants.ZERO); multifile.setObjId(dcaWorkOrder.getId()); multifile.setCreateDate(new Date()); - multifile.setObjType(Constants.multiFileType.dcaWorkOrder); + multifile.setObjType(Constants.multiFileType.upload); } multifileMapper.insert(multifileList); } @@ -187,10 +272,10 @@ * * @param beforeJson * @param afterWorkorder - * @param objType 鎿嶄綔绫诲瀷 0浠诲姟涓婃姤 1浠诲姟纭 2浠诲姟鍒嗛厤鐗╀笟涓荤 3浠诲姟鍏抽棴 4浠诲姟鍒嗛厤澶勭悊浜� 5浠诲姟鍌績 + * @param objType 鎿嶄綔绫诲瀷 0浠诲姟涓婃姤 1浠诲姟鍒嗛厤鐗╀笟涓荤 2浠诲姟鍒嗛厤澶勭悊浜� 3浠诲姟澶勭悊鍏抽棴 4浠诲姟鍌績 * @param memberId */ - public void saveLog(String beforeJson,Workorder afterWorkorder,Integer objType,Integer memberId){ + public Integer saveLog(String beforeJson,Workorder afterWorkorder,Integer objType,Integer memberId,String title,String content){ WorkorderLog workorderLog = new WorkorderLog(); workorderLog.setCreateDate(new Date()); workorderLog.setEditDate(new Date()); @@ -200,7 +285,10 @@ workorderLog.setParam1(memberId.toString()); workorderLog.setObjId(afterWorkorder.getId().toString()); workorderLog.setObjType(objType); + workorderLog.setTitle(title); + workorderLog.setContent(content); workorderLogMapper.insert(workorderLog); + return workorderLog.getId(); } @@ -268,7 +356,7 @@ .selectAll(Workorder.class) .selectAs(Member::getPhone,Workorder::getMemberPhone) .selectAs(Member::getName,Workorder::getMemberName) - .selectAs(Workorder::getCompanyName,Workorder::getCompanyName) + .selectAs(Member::getCompanyName,Workorder::getCompanyName) .select(" c3.name ",Workorder::getTypeName) .select(" c4.name ",Workorder::getProblemName) .leftJoin(Member.class,Member::getId,Workorder::getMemberId) @@ -280,7 +368,7 @@ if(Objects.nonNull(workorder)){ //鏌ヨ闄勪欢淇℃伅 List<Multifile> multifileList = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda().eq(Multifile::getIsdeleted,Constants.ZERO) - .eq(Multifile::getObjId,workorder).orderByAsc(Multifile::getId)); + .eq(Multifile::getObjId,workorder.getId()).orderByAsc(Multifile::getId)); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.FTP,Constants.WORKORDER_FILE_PATH).getCode(); @@ -290,8 +378,51 @@ workorder.setMultifileList(multifileList); } } + //鏌ヨ鏃ュ織淇℃伅 + workorder.setLogList(this.getLogList(workorder.getId())); + if(Constants.equalsInteger(workorder.getType(),Constants.ONE)){ + //濡傛灉鏄疍CA鎻愪氦璁板綍锛屾煡璇㈠瓙宸ュ崟闆嗗悎 + Workorder param = new Workorder(); + param.setIsdeleted(Constants.ZERO); + param.setDcaRecordId(workorder.getId()); + workorder.setDcaChildList(findList(param)); + } return workorder; } + + + public List<WorkorderLog> getLogList(Integer orderId){ + List<WorkorderLog> logList = workorderLogMapper.selectJoinList(WorkorderLog.class, + new MPJLambdaWrapper<WorkorderLog>() + .selectAll(WorkorderLog.class) + .selectAs(Member::getName,WorkorderLog::getUserName) + .selectAs(Member::getCompanyName,WorkorderLog::getCompanyName) + .leftJoin(Member.class,Member::getId,WorkorderLog::getParam1) + .eq(WorkorderLog::getObjId,orderId) + .orderByAsc(WorkorderLog::getId) + ); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(logList)){ + String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + +systemDictDataBiz.queryByCode(Constants.FTP,Constants.WORKORDER_FILE_PATH).getCode(); + for (WorkorderLog workorderLog:logList) { + //鏌ヨ闄勪欢淇℃伅 + List<Multifile> multifileList = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() + .eq(Multifile::getIsdeleted,Constants.ZERO) + .ne(Multifile::getObjType,Constants.multiFileType.upload) + .eq(Multifile::getObjId,workorderLog.getId()) + .orderByAsc(Multifile::getId)); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ + for (Multifile multifile:multifileList) { + multifile.setFileurlFull(path+multifile.getFileurl()); + } + workorderLog.setMultifileList(multifileList); + } + } + } + return logList; + + } + @Override @@ -340,75 +471,85 @@ } @Override - public List<Workorder> findList(Workorder workorder) { - QueryWrapper<Workorder> wrapper = new QueryWrapper<>(workorder); - return workorderMapper.selectList(wrapper); + public List<Workorder> findList(Workorder pageWrap) { + + return workorderMapper.selectJoinList(Workorder.class,getJoinQueryMapper(pageWrap)); } - - @Override - public PageData<Workorder> findPage(PageWrap<Workorder> pageWrap) { - IPage<Workorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); - Utils.MP.blankToNull(pageWrap.getModel()); + + private MPJLambdaWrapper<Workorder> getJoinQueryMapper(Workorder pageWrap) { MPJLambdaWrapper<Workorder> queryWrapper = new MPJLambdaWrapper<>(); - pageWrap.getModel().setIsdeleted(Constants.ZERO); + pageWrap.setIsdeleted(Constants.ZERO); queryWrapper .selectAll(Workorder.class) .selectAs(Member::getName,Workorder::getMemberName) .selectAs(Member::getCompanyName,Workorder::getCompanyName) .selectAs(Member::getPhone,Workorder::getMemberPhone) + .select(" c2.name ",Workorder::getCategoryName) .select(" c3.name ",Workorder::getTypeName) - .select(" c4.name ",Workorder::getProblemName) .leftJoin(Member.class,Member::getId,Workorder::getMemberId) .leftJoin(" category c3 on t.TYPE_ID = c3.id ") //椋庨櫓绫诲瀷 - .leftJoin(" category c4 on t.PROBLEM_ID = c4.id ") //DCA闂缂栫爜 - .eq(pageWrap.getModel().getId() != null, Workorder::getId, pageWrap.getModel().getId()) - .eq(pageWrap.getModel().getCreator() != null, Workorder::getCreator, pageWrap.getModel().getCreator()) - .ge(pageWrap.getModel().getCreateDate() != null, Workorder::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())) - .le(pageWrap.getModel().getCreateDate() != null, Workorder::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())) - .eq(pageWrap.getModel().getEditor() != null, Workorder::getEditor, pageWrap.getModel().getEditor()) - .ge(pageWrap.getModel().getEditDate() != null, Workorder::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())) - .le(pageWrap.getModel().getEditDate() != null, Workorder::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())) - .eq(pageWrap.getModel().getIsdeleted() != null, Workorder::getIsdeleted, pageWrap.getModel().getIsdeleted()) - .eq(pageWrap.getModel().getCategoryId() != null, Workorder::getCategoryId, pageWrap.getModel().getCategoryId()) - .eq(pageWrap.getModel().getRemark() != null, Workorder::getRemark, pageWrap.getModel().getRemark()) - .eq(pageWrap.getModel().getStatus() != null, Workorder::getStatus, pageWrap.getModel().getStatus()) - .eq(pageWrap.getModel().getSortnum() != null, Workorder::getSortnum, pageWrap.getModel().getSortnum()) - .eq(pageWrap.getModel().getType() != null, Workorder::getType, pageWrap.getModel().getType()) - .eq(pageWrap.getModel().getMemberId() != null, Workorder::getMemberId, pageWrap.getModel().getMemberId()) - .eq(pageWrap.getModel().getCompanyId() != null, Workorder::getCompanyId, pageWrap.getModel().getCompanyId()) - .eq(pageWrap.getModel().getSubmitDate() != null, Workorder::getSubmitDate, pageWrap.getModel().getSubmitDate()) - .eq(pageWrap.getModel().getMemberType() != null, Workorder::getMemberType, pageWrap.getModel().getMemberType()) - .eq(pageWrap.getModel().getMemberQwids() != null, Workorder::getMemberQwids, pageWrap.getModel().getMemberQwids()) - .like(pageWrap.getModel().getMemberNames() != null, Workorder::getMemberNames, pageWrap.getModel().getMemberNames()) - .eq(pageWrap.getModel().getLocaltionId() != null, Workorder::getLocaltionId, pageWrap.getModel().getLocaltionId()) - .eq(pageWrap.getModel().getOutJiuyi() != null, Workorder::getOutJiuyi, pageWrap.getModel().getOutJiuyi()) - .eq(pageWrap.getModel().getIsYiwushi() != null, Workorder::getIsYiwushi, pageWrap.getModel().getIsYiwushi()) - .eq(pageWrap.getModel().getIsHurted() != null, Workorder::getIsHurted, pageWrap.getModel().getIsHurted()) - .eq(pageWrap.getModel().getWorkRelated() != null, Workorder::getWorkRelated, pageWrap.getModel().getWorkRelated()) - .eq(pageWrap.getModel().getEventInfo() != null, Workorder::getEventInfo, pageWrap.getModel().getEventInfo()) - .eq(pageWrap.getModel().getEmialMemberIds() != null, Workorder::getEmialMemberIds, pageWrap.getModel().getEmialMemberIds()) - .eq(pageWrap.getModel().getQwnoticeMemberIds() != null, Workorder::getQwnoticeMemberIds, pageWrap.getModel().getQwnoticeMemberIds()) - .eq(pageWrap.getModel().getHappenTime() != null, Workorder::getHappenTime, pageWrap.getModel().getHappenTime()) - .eq(pageWrap.getModel().getTypeId() != null, Workorder::getTypeId, pageWrap.getModel().getTypeId()) - .eq(pageWrap.getModel().getRiskInfo() != null, Workorder::getRiskInfo, pageWrap.getModel().getRiskInfo()) - .eq(pageWrap.getModel().getManagerId() != null, Workorder::getManagerId, pageWrap.getModel().getManagerId()) - .eq(pageWrap.getModel().getDealerId() != null, Workorder::getDealerId, pageWrap.getModel().getDealerId()) - .ge(pageWrap.getModel().getDispatchTime() != null, Workorder::getDispatchTime, Utils.Date.getStart(pageWrap.getModel().getDispatchTime())) - .le(pageWrap.getModel().getDispatchTime() != null, Workorder::getDispatchTime, Utils.Date.getEnd(pageWrap.getModel().getDispatchTime())) - .eq(pageWrap.getModel().getDispatchInfo() != null, Workorder::getDispatchInfo, pageWrap.getModel().getDispatchInfo()) - .ge(pageWrap.getModel().getDealTime() != null, Workorder::getDealTime, Utils.Date.getStart(pageWrap.getModel().getDealTime())) - .le(pageWrap.getModel().getDealTime() != null, Workorder::getDealTime, Utils.Date.getEnd(pageWrap.getModel().getDealTime())) - .eq(pageWrap.getModel().getDealInfo() != null, Workorder::getDealInfo, pageWrap.getModel().getDealInfo()) - .eq(pageWrap.getModel().getProblemTitle() != null, Workorder::getProblemTitle, pageWrap.getModel().getProblemTitle()) - .eq(pageWrap.getModel().getProblemId() != null, Workorder::getProblemId, pageWrap.getModel().getProblemId()) - .eq(pageWrap.getModel().getProblemInfo() != null, Workorder::getProblemInfo, pageWrap.getModel().getProblemInfo()) - .eq(pageWrap.getModel().getLocationName() != null, Workorder::getLocationName, pageWrap.getModel().getLocationName()) - .eq(pageWrap.getModel().getCode() != null, Workorder::getCode, pageWrap.getModel().getCode()) - .eq(pageWrap.getModel().getDcaYesNum() != null, Workorder::getDcaYesNum, pageWrap.getModel().getDcaYesNum()) - .eq(pageWrap.getModel().getDcaNoNum() != null, Workorder::getDcaNoNum, pageWrap.getModel().getDcaNoNum()) - .eq(pageWrap.getModel().getDcaRecordId() != null, Workorder::getDcaRecordId, pageWrap.getModel().getDcaRecordId()) - .eq(pageWrap.getModel().getDcaCsIds() != null, Workorder::getDcaCsIds, pageWrap.getModel().getDcaCsIds()) ; - queryWrapper.orderByDesc(Workorder::getCreateDate); + .leftJoin(" category c2 on t.CATEGORY_ID = c2.id ") //DCA涓�绾ч棶棰樼紪鐮� + .eq( pageWrap.getId() != null, Workorder::getId, pageWrap.getId()) + .eq( pageWrap.getCreator() != null, Workorder::getCreator, pageWrap.getCreator()) + .ge( pageWrap.getCreateDate() != null, Workorder::getCreateDate, Utils.Date.getStart( pageWrap.getCreateDate())) + .le( pageWrap.getCreateDate() != null, Workorder::getCreateDate, Utils.Date.getEnd( pageWrap.getCreateDate())) + .eq( pageWrap.getEditor() != null, Workorder::getEditor, pageWrap.getEditor()) + .ge( pageWrap.getEditDate() != null, Workorder::getEditDate, Utils.Date.getStart( pageWrap.getEditDate())) + .le( pageWrap.getEditDate() != null, Workorder::getEditDate, Utils.Date.getEnd( pageWrap.getEditDate())) + .eq( pageWrap.getIsdeleted() != null, Workorder::getIsdeleted, pageWrap.getIsdeleted()) + .eq( pageWrap.getCategoryId() != null, Workorder::getCategoryId, pageWrap.getCategoryId()) + .eq( pageWrap.getRemark() != null, Workorder::getRemark, pageWrap.getRemark()) + .eq( pageWrap.getStatus() != null, Workorder::getStatus, pageWrap.getStatus()) + .eq( pageWrap.getSortnum() != null, Workorder::getSortnum, pageWrap.getSortnum()) + .eq( pageWrap.getType() != null, Workorder::getType, pageWrap.getType()) + .eq( pageWrap.getMemberId() != null, Workorder::getMemberId, pageWrap.getMemberId()) + .eq( pageWrap.getCompanyId() != null, Workorder::getCompanyId, pageWrap.getCompanyId()) + .eq( pageWrap.getSubmitDate() != null, Workorder::getSubmitDate, pageWrap.getSubmitDate()) + .eq( pageWrap.getMemberType() != null, Workorder::getMemberType, pageWrap.getMemberType()) + .eq( pageWrap.getMemberQwids() != null, Workorder::getMemberQwids, pageWrap.getMemberQwids()) + .like( pageWrap.getMemberNames() != null, Workorder::getMemberNames, pageWrap.getMemberNames()) + .eq( pageWrap.getLocaltionId() != null, Workorder::getLocaltionId, pageWrap.getLocaltionId()) + .eq( pageWrap.getOutJiuyi() != null, Workorder::getOutJiuyi, pageWrap.getOutJiuyi()) + .eq( pageWrap.getIsYiwushi() != null, Workorder::getIsYiwushi, pageWrap.getIsYiwushi()) + .eq( pageWrap.getIsHurted() != null, Workorder::getIsHurted, pageWrap.getIsHurted()) + .eq( pageWrap.getWorkRelated() != null, Workorder::getWorkRelated, pageWrap.getWorkRelated()) + .eq( pageWrap.getEventInfo() != null, Workorder::getEventInfo, pageWrap.getEventInfo()) + .eq( pageWrap.getEmialMemberIds() != null, Workorder::getEmialMemberIds, pageWrap.getEmialMemberIds()) + .eq( pageWrap.getQwnoticeMemberIds() != null, Workorder::getQwnoticeMemberIds, pageWrap.getQwnoticeMemberIds()) + .eq( pageWrap.getHappenTime() != null, Workorder::getHappenTime, pageWrap.getHappenTime()) + .eq( pageWrap.getTypeId() != null, Workorder::getTypeId, pageWrap.getTypeId()) + .eq( pageWrap.getRiskInfo() != null, Workorder::getRiskInfo, pageWrap.getRiskInfo()) + .eq( pageWrap.getManagerId() != null, Workorder::getManagerId, pageWrap.getManagerId()) + .eq( pageWrap.getDealerId() != null, Workorder::getDealerId, pageWrap.getDealerId()) + .ge( pageWrap.getDispatchTime() != null, Workorder::getDispatchTime, Utils.Date.getStart( pageWrap.getDispatchTime())) + .le( pageWrap.getDispatchTime() != null, Workorder::getDispatchTime, Utils.Date.getEnd( pageWrap.getDispatchTime())) + .eq( pageWrap.getDispatchInfo() != null, Workorder::getDispatchInfo, pageWrap.getDispatchInfo()) + .ge( pageWrap.getDealTime() != null, Workorder::getDealTime, Utils.Date.getStart( pageWrap.getDealTime())) + .le( pageWrap.getDealTime() != null, Workorder::getDealTime, Utils.Date.getEnd( pageWrap.getDealTime())) + .eq( pageWrap.getDealInfo() != null, Workorder::getDealInfo, pageWrap.getDealInfo()) + .eq( pageWrap.getProblemTitle() != null, Workorder::getProblemTitle, pageWrap.getProblemTitle()) + .eq( pageWrap.getProblemId() != null, Workorder::getProblemId, pageWrap.getProblemId()) + .eq( pageWrap.getProblemInfo() != null, Workorder::getProblemInfo, pageWrap.getProblemInfo()) + .eq( pageWrap.getLocationName() != null, Workorder::getLocationName, pageWrap.getLocationName()) + .like( pageWrap.getCode() != null, Workorder::getCode, pageWrap.getCode()) + .eq( pageWrap.getDcaYesNum() != null, Workorder::getDcaYesNum, pageWrap.getDcaYesNum()) + .eq( pageWrap.getDcaNoNum() != null, Workorder::getDcaNoNum, pageWrap.getDcaNoNum()) + .eq( pageWrap.getDcaRecordId() != null, Workorder::getDcaRecordId, pageWrap.getDcaRecordId()) + .eq( pageWrap.getDcaCsIds() != null, Workorder::getDcaCsIds, pageWrap.getDcaCsIds()) ; + if ( pageWrap.getMemberName() != null) { + queryWrapper.and( ms->ms.like(Member::getName, pageWrap.getMemberName()) + .or().like(Member::getPhone, pageWrap.getMemberName()) ); + } + queryWrapper.orderByDesc(Workorder::getProblemId); + return queryWrapper; + } + + @Override + public PageData<Workorder> findPage(PageWrap<Workorder> pageWrap) { + IPage<Workorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); + Utils.MP.blankToNull(pageWrap.getModel()); + pageWrap.getModel().setIsdeleted(Constants.ZERO); + MPJLambdaWrapper<Workorder> queryWrapper = getJoinQueryMapper(pageWrap.getModel()); return PageData.from(workorderMapper.selectJoinPage(page,Workorder.class, queryWrapper)); } @@ -445,29 +586,254 @@ + @Override public void closeWorkOrder(CloseDTO closeDTO){ if(Objects.isNull(closeDTO) - || Objects.isNull(closeDTO.getWorkorderId()) - || org.apache.commons.lang3.StringUtils.isBlank(closeDTO.getInfo()) - || com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(closeDTO.getMultifileList())){ + || Objects.isNull(closeDTO.getWorkorderId()) + || org.apache.commons.lang3.StringUtils.isBlank(closeDTO.getInfo()) + || com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(closeDTO.getMultifileList())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } Workorder workorder = workorderMapper.selectById(closeDTO.getWorkorderId()); + String beforeJson = JSONObject.toJSONString(workorder); if(Objects.isNull(workorder)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌宸ュ崟鏁版嵁"); } - if(!(Constants.equalsInteger(workorder.getStatus(),Constants.ZERO) - || Constants.equalsInteger(workorder.getStatus(),Constants.ONE) - || Constants.equalsInteger(workorder.getStatus(),Constants.TWO))){ - throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"宸ュ崟鐘舵�佸凡娴佽浆鏃犳硶杩涜鎿嶄綔"); + if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"SHE宸ュ崟鏃犳硶杩涜璇ユ搷浣�"); + } + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.sheClose.getKey())||Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.wtsClose.getKey())||Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.close.getKey())){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"宸ュ崟鐘舵�佸凡娴佽浆"); + } + //鎻愪氦鍚庣殑 寰呯‘璁�/寰呭垵瀹$姸鎬� 濡傛灉鍘诲叧闂� 鍙湁宸ュ崟閲岀粦瀹氱殑SHE浜哄憳鍙互鍏抽棴 + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitConfirm.getKey())){ + //鍒ゆ柇SHE浜哄憳鍐呮槸鍚︽湁褰撳墠鐧诲綍璐﹀彿 + if(workorder.getQwnoticeMemberIds().indexOf(closeDTO.getMember().getQwId())<Constants.ZERO){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝褰撳墠宸ュ崟闈炴偍鐨勫伐鍗曪紝鏃犳硶杩涜澶勭悊"); + } + workorder.setStatus(Constants.WorkOrderStatus.sheClose.getKey()); + }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey())){ + //鍒ゆ柇SHE浜哄憳鍐呮槸鍚︽湁褰撳墠鐧诲綍璐﹀彿 + if(workorder.getQwnoticeMemberIds().indexOf(closeDTO.getMember().getQwId())<Constants.ZERO && !workorder.getManagerId().equals(closeDTO.getMember().getQwId())){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝褰撳墠宸ュ崟闈炴偍鐨勫伐鍗曪紝鏃犳硶杩涜澶勭悊"); + } + workorder.setStatus(Constants.WorkOrderStatus.wtsClose.getKey()); + }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitDeal.getKey())){ + //鍒ゆ柇SHE浜哄憳鍐呮槸鍚︽湁褰撳墠鐧诲綍璐﹀彿 + if(workorder.getQwnoticeMemberIds().indexOf(closeDTO.getMember().getQwId())<Constants.ZERO && !workorder.getManagerId().equals(closeDTO.getMember().getQwId()) + && !workorder.getDealerId().equals(closeDTO.getMember().getQwId()) ){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝褰撳墠宸ュ崟闈炴偍鐨勫伐鍗曪紝鏃犳硶杩涜澶勭悊"); + } + workorder.setStatus(Constants.WorkOrderStatus.wtsClose.getKey()); + }else{ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"宸ュ崟鐘舵�佸凡娴佽浆"); + } + workorder.setEditDate(new Date()); + workorder.setDealTime(new Date()); + workorder.setDealInfo(closeDTO.getInfo()); + workorderMapper.updateById(workorder); + //澶勭悊涓婃姤鏃ュ織 + Integer logId = this.saveLog(beforeJson,workorder,Constants.THREE,workorder.getMemberId(),"浠诲姟宸插鐞�",closeDTO.getInfo()); + List<Multifile> multifileList = workorder.getMultifileList(); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ + for (Multifile multifile:multifileList) { + multifile.setObjId(logId); + multifile.setCreateDate(new Date()); + multifile.setObjType(Constants.multiFileType.deal); + } + multifileMapper.insert(multifileList); + } + } + + + @Override + public void passOn(PassOnDTO passOnDTO){ + if(Objects.isNull(passOnDTO) + || Objects.isNull(passOnDTO.getWorkorderId()) + || Objects.isNull(passOnDTO.getPassOnUserId()) + ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + Member member = memberMapper.selectById(passOnDTO.getPassOnUserId()); + if(Objects.isNull(member)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌琚浆浜や汉淇℃伅"); + } + Workorder workorder = workorderMapper.selectById(passOnDTO.getWorkorderId()); + String beforeJson = JSONObject.toJSONString(workorder); + if(Objects.isNull(workorder)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌宸ュ崟鏁版嵁"); + } + if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"SHE宸ュ崟鏃犳硶杩涜璇ユ搷浣�"); + } + if(Constants.equalsInteger(passOnDTO.getPassOnType(),Constants.ZERO)){ + if(!Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitConfirm.getKey())){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"宸ュ崟鐘舵�佸凡娴佽浆"); + } + workorder.setManagerId(member.getQwId()); + workorder.setStatus(Constants.WorkOrderStatus.waitAllocation.getKey()); + }else{ + if(!(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey()) + || Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitDeal.getKey()))){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"宸ュ崟鐘舵�佸凡娴佽浆"); + } + workorder.setDealerId(member.getQwId()); + workorder.setStatus(Constants.WorkOrderStatus.waitDeal.getKey()); + } + workorder.setEditDate(new Date()); + workorder.setUrgeDate(DateUtil.afterHoursDate(new Date(),24)); + workorderMapper.updateById(workorder); + //澶勭悊涓婃姤鏃ュ織 + Integer logId = this.saveLog(beforeJson,workorder, + Constants.equalsInteger(passOnDTO.getPassOnType(),Constants.ZERO)?Constants.ONE:Constants.TWO + ,workorder.getMemberId(),"浠诲姟鍒嗛厤",passOnDTO.getInfo()); + List<Multifile> multifileList = workorder.getMultifileList(); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ + for (Multifile multifile:multifileList) { + multifile.setObjId(logId); + multifile.setCreateDate(new Date()); + multifile.setObjType(Constants.multiFileType.passOn); + } + multifileMapper.insert(multifileList); + } + //TODO 浼佷笟寰俊閫氱煡 + } + + + + @Override + @Transactional(rollbackFor = {BusinessException.class,Exception.class}) + public void urge(Integer workorderId,Member member){ + Workorder workorder = workorderMapper.selectById(workorderId); + workorder.setEditDate(new Date()); + workorder.setUrgeDate(DateUtil.afterHoursDate(new Date(),24)); + workorderMapper.updateById(workorder); + if(Objects.isNull(workorder)){ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌宸ュ崟鏁版嵁"); + } + Member urgeUser = new Member(); + //濡傛灉宸插垎閰� wts 鍒欐槸鍌績wts + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey())){ + urgeUser = memberMapper.selectOne(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO).eq(Member::getQwId,workorder.getManagerId()).last("limit 1 ")); + }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey())){ + urgeUser = memberMapper.selectOne(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO).eq(Member::getQwId,workorder.getDealerId()).last("limit 1 ")); + }else{ + throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鐘舵�佸凡娴佽浆鏃犳硶杩涜璇ユ搷浣�"); } + this.saveLog(null,workorder, + Constants.ONE + ,member.getId(),"鍌績","宸插偓淇� "+urgeUser.getCompanyName() + "/" + urgeUser.getName()); + //TODO 鍙戦�佷紒寰�氱煡 + + } + + @Override + public void jobUrge(){ + List<Workorder> workorderList = workorderMapper.selectList(new QueryWrapper<Workorder>().lambda().eq(Workorder::getIsdeleted,Constants.ZERO) + .in(Workorder::getStatus,Constants.WorkOrderStatus.waitAllocation.getKey(),Constants.WorkOrderStatus.waitDeal.getKey()) + .apply(" urge_time > now() ") + ); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(workorderList)){ + for (Workorder workorder:workorderList) { + this.autoUrge(workorder); + workorder.setEditDate(new Date()); + workorder.setUrgeDate(DateUtil.afterHoursDate(new Date(),24)); + workorderMapper.updateById(workorder); + } + } + } + public void autoUrge(Workorder workorder){ + if(Objects.isNull(workorder)){ + return; + } + Member urgeUser = new Member(); + //濡傛灉宸插垎閰� wts 鍒欐槸鍌績wts + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey())){ + urgeUser = memberMapper.selectOne(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO).eq(Member::getQwId,workorder.getManagerId()).last("limit 1 ")); + }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey())){ + urgeUser = memberMapper.selectOne(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO).eq(Member::getQwId,workorder.getDealerId()).last("limit 1 ")); + }else{ + return; + } + //TODO 鍙戦�佷紒寰�氱煡 + } - + /** + * 鏁版嵁鎶ヨ〃 + * @param queryType 0=鎸夌収鏈堜唤锛�1=鎸夌収瀛e害锛�2=鎸夌収骞翠唤锛堟殏涓嶅鐞嗭級 + * @return + */ + @Override + public List<WorkOrderDataVO> getWorkOrderData(Integer queryType) throws Exception { + String year = DateUtil.getNowYear(); + Integer nowMonth = DateUtil.getNowMonth(); + Integer quarter = (nowMonth - 1) / 3 + 1; + List<WorkOrderDataVO> workOrderDataVOList = new ArrayList<>(); + //鏌ヨ浠婂勾鎵�鏈夌殑鏁版嵁 + List<Workorder> workorderList = workorderMapper.selectList(new QueryWrapper<Workorder>().lambda().like(Workorder::getCreateDate,year) + .eq(Workorder::getIsdeleted,Constants.ZERO)); + if(Constants.equalsInteger(queryType,Constants.ZERO)){ + for (int i = 1 ; i <= nowMonth; i++) { + WorkOrderDataVO workOrderDataVO = new WorkOrderDataVO(); + String monthDay = year + "-" + org.apache.commons.lang3.StringUtils.leftPad(nowMonth.toString(),2,"0"); + List<Workorder> dataList = workorderList.stream().filter(j->DateUtil.formatDate(j.getCreateDate(),"yyyy-MM").equals(monthDay)) + .collect(Collectors.toList()); + workOrderDataVO.setDateStr(monthDay); + workOrderDataVO.setGcsTotal(Constants.ZERO); + workOrderDataVO.setWtsTotal(Constants.ZERO); + workOrderDataVO.setSheTotal(Constants.ZERO); + workOrderDataVO.setUnCloseTotal(Constants.ZERO); + workOrderDataVO.setTotal(Constants.ZERO); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dataList)){ + workOrderDataVO.setTotal(dataList.size()); + workOrderDataVO.setGcsTotal(dataList.stream().filter(j->Constants.equalsInteger(j.getStatus(),Constants.WorkOrderStatus.close.getKey())).collect(Collectors.toList()).size()); + workOrderDataVO.setSheTotal(dataList.stream().filter(j->Constants.equalsInteger(j.getStatus(),Constants.WorkOrderStatus.sheClose.getKey())).collect(Collectors.toList()).size()); + workOrderDataVO.setWtsTotal(dataList.stream().filter(j->Constants.equalsInteger(j.getStatus(),Constants.WorkOrderStatus.wtsClose.getKey())).collect(Collectors.toList()).size()); + workOrderDataVO.setUnCloseTotal(workOrderDataVO.getTotal() - workOrderDataVO.getSheTotal() - workOrderDataVO.getWtsTotal() - workOrderDataVO.getGcsTotal()); + } + workOrderDataVOList.add(workOrderDataVO); + } + }else if(Constants.equalsInteger(queryType,Constants.ONE)){ + //鎸夌収瀛e害鏌ヨ + for (int i = 1 ; i <= quarter; i++) { + List<Workorder> dataList = new ArrayList<>(); + if(Constants.equalsInteger(i,Constants.ONE)){ + dataList = workorderList.stream().filter(j->Integer.valueOf(DateUtil.formatDate(j.getCreateDate(),"MM"))<=3 ) + .collect(Collectors.toList()); + }else if(Constants.equalsInteger(i,Constants.TWO)){ + dataList = workorderList.stream().filter(j->Integer.valueOf(DateUtil.formatDate(j.getCreateDate(),"MM"))<=6 && Integer.valueOf(DateUtil.formatDate(j.getCreateDate(),"MM"))>=4 ) + .collect(Collectors.toList()); + }else if(Constants.equalsInteger(i,Constants.THREE)){ + dataList = workorderList.stream().filter(j->Integer.valueOf(DateUtil.formatDate(j.getCreateDate(),"MM"))<=9 && Integer.valueOf(DateUtil.formatDate(j.getCreateDate(),"MM"))>=7 ) + .collect(Collectors.toList()); + }else { + dataList = workorderList.stream().filter(j-> Integer.valueOf(DateUtil.formatDate(j.getCreateDate(),"MM"))>=10 ) + .collect(Collectors.toList()); + } + WorkOrderDataVO workOrderDataVO = new WorkOrderDataVO(); + workOrderDataVO.setDateStr(i+"瀛e害"); + workOrderDataVO.setGcsTotal(Constants.ZERO); + workOrderDataVO.setWtsTotal(Constants.ZERO); + workOrderDataVO.setSheTotal(Constants.ZERO); + workOrderDataVO.setUnCloseTotal(Constants.ZERO); + workOrderDataVO.setTotal(Constants.ZERO); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dataList)){ + workOrderDataVO.setTotal(dataList.size()); + workOrderDataVO.setGcsTotal(dataList.stream().filter(j->Constants.equalsInteger(j.getStatus(),Constants.WorkOrderStatus.close.getKey())).collect(Collectors.toList()).size()); + workOrderDataVO.setSheTotal(dataList.stream().filter(j->Constants.equalsInteger(j.getStatus(),Constants.WorkOrderStatus.sheClose.getKey())).collect(Collectors.toList()).size()); + workOrderDataVO.setWtsTotal(dataList.stream().filter(j->Constants.equalsInteger(j.getStatus(),Constants.WorkOrderStatus.wtsClose.getKey())).collect(Collectors.toList()).size()); + workOrderDataVO.setUnCloseTotal(workOrderDataVO.getTotal() - workOrderDataVO.getSheTotal() - workOrderDataVO.getWtsTotal() - workOrderDataVO.getGcsTotal()); + } + workOrderDataVOList.add(workOrderDataVO); + + } + } + return workOrderDataVOList; } -- Gitblit v1.9.3