From 9fa82e0217d54a38dd1546094d8d15cb43e827b0 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 22 四月 2025 11:22:47 +0800 Subject: [PATCH] 代码初始化 --- server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java | 298 ++++++++++++++++++++++++++++++++++++++++++++++------------- 1 files changed, 233 insertions(+), 65 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 915964c..1a32444 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 @@ -14,6 +14,7 @@ import com.doumee.core.utils.qiyeweixin.model.request.QywxTextCardMsgRequest; import com.doumee.dao.business.*; import com.doumee.dao.business.model.*; +import com.doumee.dao.business.vo.WorkorderIndexNumVO; import com.doumee.dao.web.dto.*; import com.doumee.dao.web.vo.WorkOrderDataVO; import com.doumee.service.business.WorkorderService; @@ -23,6 +24,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.doumee.service.common.EmailService; import com.github.yulichang.wrapper.MPJLambdaWrapper; +import com.sun.corba.se.spi.orbutil.threadpool.Work; import lombok.extern.slf4j.Slf4j; import org.apache.catalina.Manager; import org.springframework.beans.factory.annotation.Autowired; @@ -81,12 +83,12 @@ @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer create(Workorder workorder) { this.isValidBaseParam(workorder); - workorder.setCreateDate(new Date()); workorder.setEditDate(new Date()); workorder.setMemberId(workorder.getMemberId()); workorder.setIsdeleted(Constants.ZERO); workorder.setCode(this.getNextCode(workorder.getType())); workorder.setEmailStatus(Constants.ZERO); + workorder.setCreateDate(new Date()); //澶勭悊浜哄憳绫讳俊鎭� this.dealNoticeData(workorder); //澶勭悊SHE浜嬩欢鐘舵�� @@ -122,6 +124,9 @@ * @param csInfo 鎶勯�佷俊鎭� */ public void sendQwMsg(Workorder workorder,String qwIds,Member member,String categoryName,Integer contentType,String csInfo){ + if(Constants.equalsInteger(workorder.getType(),Constants.TWO)){ + workorder = workorderMapper.selectById(workorder.getDcaRecordId()); + } if(StringUtils.isEmpty(qwIds)){ return; } @@ -142,10 +147,13 @@ qywxSendMsgRequest.setTextcard(textCard); QywxUtil.sendMsg(systemDictDataBiz.queryByCode(Constants.QYWX,Constants.QYWX_TOKEN).getCode(), qywxSendMsgRequest); + + + //https://open.weixin.qq.com/connect/oauth2/authorize?appid=${corpId}&redirect_uri=https://dmtest.ahapp.net/lianhelihua_web/&response_type=code&scope=snsapi_base&state={status}#wechat_redirect } + private static final String jumpUrl = "https://open.weixin.qq.com/connect/oauth2/authorize?appid={corpId}&redirect_uri={ourUrl}"; - private static final String [] qwDetailUrls = {"/pages/details_she/details_she","/pages/workOrder_dca/workOrder_dca","","/pages/workOrder_she/workOrder_she"}; /** * 閫氱煡鏂囨鏁寸悊 @@ -159,7 +167,11 @@ public QywxTextCardMsgRequest dealMessageContent(Workorder workorder,String userName ,String categoryName,Integer contentType,String csInfo){ QywxTextCardMsgRequest textCard = new QywxTextCardMsgRequest(); String message = ""; - textCard.setUrl(qwDetailUrls[workorder.getType()]+"?id="+workorder.getId()); + String url = jumpUrl.replace("{corpId}",systemDictDataBiz.queryByCode(Constants.QYWX,Constants.QYWX_CORPID).getCode()); + String jumpOurUrl = systemDictDataBiz.queryByCode(Constants.QYWX,Constants.JUMP_OUT_URL).getCode().replace("{status}", + workorder.getType()+"_"+workorder.getId()); + textCard.setUrl(url.replace("{ourUrl}",jumpOurUrl)); + log.error("浼佸井閾炬帴鍦板潃"+url); if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ textCard.setTitle("銆怱HE浜嬩欢涓婃姤銆�"); if(Constants.equalsInteger(workorder.getMemberType(),Constants.ZERO)){ @@ -167,19 +179,20 @@ }else { message = Constants.equalsInteger(workorder.getMemberType(),Constants.ONE)?"鍚屼簨":"渚涘簲鍟�"; } - message = message + "-" + workorder.getMemberNames() + " " + DateUtil.formatDate(new Date(),"yyyy-MM-dd HH:mm") + workorder.getLocationName() + categoryName; - textCard.setDescription(" <div class=\"normal\">"+message+"</div>"); + message = message + "-" + workorder.getMemberNames() + " " + DateUtil.formatDate(new Date(),"yyyy-MM-dd HH:mm") + "/" +workorder.getLocationName() + "/" + categoryName; + textCard.setDescription("<div class=\"normal\">"+message+"</div>"); + }else{ textCard.setTitle(Constants.equalsInteger(workorder.getType(),Constants.ONE)?"銆怐CA涓婃姤銆�":"銆愯穼缁婃粦椋庨櫓涓婃姤銆�"); if(Constants.equalsInteger(workorder.getType(),Constants.THREE)){ message = message + " <div class=\"normal\">"+ (org.apache.commons.lang3.StringUtils.isNotBlank(userName)?userName:"绯荤粺") + (Constants.equalsInteger(contentType,Constants.ZERO)?"浠诲姟鍒嗛厤缁欎綘":(Constants.equalsInteger(contentType,Constants.ONE)?"瀵硅宸ュ崟杩涜浜嗗偓淇冿紝璇峰敖蹇鐞�":"浠诲姟宸插鐞�")) +"</div>"; message = message + " <div class=\"normal\">"+ DateUtil.formatDate(new Date(),"yyyy-MM-dd HH:mm") +"/"+ workorder.getLocationName() +"/"+ categoryName+"</div>"; }else{ - message = message + " <div class=\"normal\">"+ (org.apache.commons.lang3.StringUtils.isNotBlank(userName)?userName:"绯荤粺") + (Constants.equalsInteger(contentType,Constants.ZERO)?"浠诲姟鍒嗛厤缁欎綘":(Constants.equalsInteger(contentType,Constants.ONE)?"瀵硅宸ュ崟杩涜浜嗗偓淇冿紝璇峰敖蹇鐞�":((Constants.equalsInteger(contentType,Constants.TWO)?"鎶勯�佺粰浣�":"宸插鐞嗕竴椤�")))) +"</div>"; - message = message + " <div class=\"normal\">瑙傚療涓婚"+ categoryName +"</div>"; - message = message + " <div class=\"normal\">绗﹀悎锛�"+ workorder.getDcaYesNum() +" 涓嶇鍚堬細"+workorder.getDcaNoNum()+"</div>"; + message = message + " <div class=\"normal\">"+ (org.apache.commons.lang3.StringUtils.isNotBlank(userName)?userName:"绯荤粺") + (Constants.equalsInteger(contentType,Constants.ZERO)?"浠诲姟鍒嗛厤缁欎綘":(Constants.equalsInteger(contentType,Constants.ONE)?"瀵硅宸ュ崟杩涜浜嗗偓淇冿紝璇峰敖蹇鐞�":((Constants.equalsInteger(contentType,Constants.TWO)?"鎶勯�佺粰浣�":"宸插鐞嗕竴椤�")))) +"</div>"; + message = message + " <div class=\"normal\">瑙傚療涓婚 "+ categoryName +"</div>"; + message = message + " <div class=\"normal\">绗﹀悎锛�"+ workorder.getDcaYesNum() +" 涓嶇鍚堬細"+workorder.getDcaNoNum()+"</div>"; if(Constants.equalsInteger(contentType,Constants.TWO)){ - message = message + " <div class=\"normal\">璇存槑锛�"+ csInfo +"</div>"; + message = message + " <div class=\"normal\">璇存槑 "+ csInfo +"</div>"; } } textCard.setDescription(message); @@ -193,6 +206,7 @@ if (Constants.equalsInteger(workorder.getType(), Constants.THREE) || Constants.equalsInteger(workorder.getType(), Constants.TWO) ) { //澶勭悊涓婃姤鏃ュ織 DCA宸ュ崟 鏃ュ織瀛樺偍鑷冲瓙涓氬姟 涓嶅瓨鍦ㄤ簬鐖剁骇 涓庤穼缁婃粦 String logTitle = Constants.equalsInteger(workorder.getType(), Constants.THREE) ? "璺岀粖婊戦闄�" : "DCA"; + workorder.setCreateDate(workorder.getSubmitDate()); this.saveLog(null,workorder,Constants.ZERO,workorder.getMemberId(),workOrderStatus.getLogTitle().replace("{title}",logTitle),null,null); } } @@ -212,8 +226,8 @@ multifile.setObjId(workorder.getId()); multifile.setCreateDate(new Date()); multifile.setObjType(Constants.multiFileType.upload); + multifileMapper.insert(multifile); } - multifileMapper.insert(multifileList); } } @@ -258,6 +272,10 @@ workorderMapper.insert(dcaWorkOrder); //瀛樺偍鏃ュ織 this.dealLogData(dcaWorkOrder,workOrderStatus); + + //瀛樺偍寰呭姙浜哄憳淇℃伅 + this.saveNotice(Arrays.asList(dcaWorkOrder.getQwnoticeMemberIds().split(",")),dcaWorkOrder.getId(),Constants.ZERO,Constants.ZERO); + List<Multifile> multifileList = dcaNoProblemDTO.getMultifileList(); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ for (Multifile multifile:multifileList) { @@ -269,6 +287,9 @@ multifileMapper.insert(multifileList); } } + }else{ + workorder.setStatus(Constants.WorkOrderStatus.sheClose.getKey()); + workorderMapper.updateById(workorder); } //鏌ヨ涓婚涓嬬殑鎵�鏈夎瀵熼」 @@ -277,13 +298,16 @@ //瀛樺偍DCA宸ュ崟璇︽儏 Map<String,Object> detail = new HashMap<>(); detail.put("title","瑙傚療涓婚锛�"+type.getName()); - List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda().eq(Category::getType,4).eq(Category::getParentId,workorder.getTypeId())); + List<Category> categoryList = categoryMapper.selectList(new QueryWrapper<Category>().lambda().eq(Category::getType,4) + .eq(Category::getIsdeleted,Constants.ZERO) + .eq(Category::getParentId,workorder.getTypeId())); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(categoryList)){ List<Map<String,Object>> childMapList = new ArrayList<>(); for (Category category:categoryList) { Map<String,Object> childMap = new HashMap<>(); childMap.put("childTitle",category.getName()); List<Category> problemList = categoryMapper.selectList(new QueryWrapper<Category>().lambda() + .eq(Category::getIsdeleted,Constants.ZERO) .eq(Category::getType,6).eq(Category::getParentId,category.getId())); List<Map<String,Object>> problemMapList = new ArrayList<>(); Integer index = Constants.ONE; @@ -378,12 +402,12 @@ * @param afterWorkorder * @param objType 鎿嶄綔绫诲瀷 0浠诲姟涓婃姤 1浠诲姟鍒嗛厤鐗╀笟涓荤 2浠诲姟鍒嗛厤澶勭悊浜� 3浠诲姟澶勭悊鍏抽棴 4浠诲姟鍌績 * @param memberId - * @param paramr2 澶勭悊浜� + * @param paramr2 杞氦缁欑殑澶勭悊浜� */ public Integer saveLog(String beforeJson,Workorder afterWorkorder,Integer objType,Integer memberId,String title,String content,String paramr2){ WorkorderLog workorderLog = new WorkorderLog(); - workorderLog.setCreateDate(new Date()); - workorderLog.setEditDate(new Date()); + workorderLog.setCreateDate(afterWorkorder.getEditDate()); + workorderLog.setEditDate(afterWorkorder.getEditDate()); workorderLog.setIsdeleted(Constants.ZERO); workorderLog.setBeforeContent(beforeJson); workorderLog.setAfterContent(JSONObject.toJSONString(afterWorkorder)); @@ -476,6 +500,7 @@ if(Objects.isNull(workorder)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } + this.dealButton(workorder,member); //鏌ヨ闄勪欢淇℃伅 List<Multifile> multifileList = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda().eq(Multifile::getIsdeleted,Constants.ZERO) @@ -490,15 +515,21 @@ } workorder.setMultifileList(multifileList); } - //鏌ヨ鏃ュ織淇℃伅 - workorder.setLogList(this.getLogList(workorder)); + workorder.setLogList(this.getLogList(workorder,member)); if(Constants.equalsInteger(workorder.getType(),Constants.ONE)){ //濡傛灉鏄疍CA鎻愪氦璁板綍锛屾煡璇㈠瓙宸ュ崟闆嗗悎 Workorder param = new Workorder(); param.setIsdeleted(Constants.ZERO); param.setDcaRecordId(workorder.getId()); - workorder.setDcaChildList(findList(param)); + List<Workorder> dcaChildList = findList(param); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dcaChildList)){ + for (Workorder dcaChild:dcaChildList) { + this.dealButton(dcaChild,member); + } + workorder.setManagerId(dcaChildList.stream().filter(i->Objects.nonNull(i.getManagerId())).map(i->i.getManagerId()).collect(Collectors.joining(","))); + } + workorder.setDcaChildList(dcaChildList); } return workorder; } @@ -526,10 +557,13 @@ } List<String> passOnUserList = new ArrayList<>(); //寰呭垎閰嶇姸鎬� 澶勭悊杞氦鎸夐挳 - if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitConfirm.getKey())&&Constants.equalsInteger(workorder.getStatus(),Constants.ZERO)){ + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitConfirm.getKey()) + ){ passOnUserList.addAll(Arrays.asList(workorder.getQwnoticeMemberIds().split(","))); - }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey())&&(Constants.equalsInteger(workorder.getStatus(),Constants.ONE) - || Constants.equalsInteger(workorder.getStatus(),Constants.TWO))){ + } + if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitAllocation.getKey()) + || Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitDeal.getKey()) + ){ passOnUserList.add(workorder.getManagerId()); } if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(passOnUserList)){ @@ -540,7 +574,7 @@ } - public List<WorkorderLog> getLogList(Workorder workorder){ + public List<WorkorderLog> getLogList(Workorder workorder,Member loginMember){ List<WorkorderLog> logList = workorderLogMapper.selectJoinList(WorkorderLog.class, new MPJLambdaWrapper<WorkorderLog>() .selectAll(WorkorderLog.class) @@ -551,30 +585,35 @@ .orderByDesc(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_LOG_FILE_PATH).getCode(); Boolean canOpenUrgeButton = true; for (WorkorderLog workorderLog:logList) { workorderLog.setUrgeButton(Constants.ZERO); - //鐗╀笟涓荤澶勭悊涓� - if(Constants.equalsInteger(workorder.getStatus(),Constants.ONE)){ - Member member = memberMapper.selectById(workorderLog.getParam1()); - if(Objects.nonNull(member) && org.apache.commons.lang3.StringUtils.isNotBlank(member.getQwId()) - && member.getQwId().equals(workorder.getManagerId()) ){ - workorderLog.setUrgeButton(Constants.ONE); + if(Constants.equalsInteger(workorderLog.getObjType(),Constants.TWO)||Constants.equalsInteger(workorderLog.getObjType(),Constants.ONE)){ + //鐗╀笟涓荤澶勭悊涓� + if(Constants.equalsInteger(workorder.getStatus(),Constants.ONE)){ + Member member = memberMapper.selectById(workorderLog.getParam1()); + if(Objects.nonNull(member) && org.apache.commons.lang3.StringUtils.isNotBlank(member.getQwId()) + && Objects.nonNull(loginMember) && Constants.equalsInteger(member.getId(),loginMember.getId()) + && workorder.getQwnoticeMemberIds().indexOf(member.getQwId())>=Constants.ZERO){ + workorderLog.setUrgeButton(Constants.ONE); + } + } + //宸ョ▼甯堝鐞嗕腑 + if(Constants.equalsInteger(workorder.getStatus(),Constants.TWO)){ + Member member = memberMapper.selectById(workorderLog.getParam1()); + if(Objects.nonNull(member) && org.apache.commons.lang3.StringUtils.isNotBlank(member.getQwId()) + && canOpenUrgeButton + && (workorder.getQwnoticeMemberIds().indexOf(member.getQwId()) >= Constants.ZERO || member.getQwId().equals(workorder.getManagerId()) ) + ){ + workorderLog.setUrgeButton(Constants.ONE); + canOpenUrgeButton = false; + } } } - //宸ョ▼甯堝鐞嗕腑 - if(Constants.equalsInteger(workorder.getStatus(),Constants.TWO)){ - Member member = memberMapper.selectById(workorderLog.getParam1()); - if(Objects.nonNull(member) && org.apache.commons.lang3.StringUtils.isNotBlank(member.getQwId()) - && member.getQwId().equals(workorder.getDealerId()) && canOpenUrgeButton){ - workorderLog.setUrgeButton(Constants.ONE); - canOpenUrgeButton = false; - } - } + //鏌ヨ闄勪欢淇℃伅 List<Multifile> multifileList = multifileMapper.selectList(new QueryWrapper<Multifile>().lambda() .eq(Multifile::getIsdeleted,Constants.ZERO) @@ -717,12 +756,13 @@ .eq( pageWrap.getDcaYesNum() != null, Workorder::getDcaYesNum, pageWrap.getDcaYesNum()) .eq( pageWrap.getDcaNoNum() != null, Workorder::getDcaNoNum, pageWrap.getDcaNoNum()) .eq( pageWrap.getDcaRecordId() != null, Workorder::getDcaRecordId, pageWrap.getDcaRecordId()) + .likeRight( pageWrap.getTypeIdPath() != null,"c3.id_path", pageWrap.getTypeIdPath()) .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); + queryWrapper.orderByDesc(Workorder::getId); return queryWrapper; } @@ -806,7 +846,7 @@ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝褰撳墠宸ュ崟闈炴偍鐨勫伐鍗曪紝鏃犳硶杩涜澶勭悊"); } workorder.setStatus(Constants.WorkOrderStatus.wtsClose.getKey()); - qwIds = Arrays.asList(workorder.getQwnoticeMemberIds()); + qwIds.addAll(Arrays.asList(workorder.getQwnoticeMemberIds().split(","))); qwIds.add(workorder.getManagerId()); qwIds.remove(closeDTO.getMember().getQwId()); }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitDeal.getKey())){ @@ -816,8 +856,8 @@ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀵逛笉璧凤紝褰撳墠宸ュ崟闈炴偍鐨勫伐鍗曪紝鏃犳硶杩涜澶勭悊"); } workorder.setStatus(Constants.WorkOrderStatus.wtsClose.getKey()); - qwIds = Arrays.asList(workorder.getQwnoticeMemberIds()); - qwIds.add(workorder.getDealerId()); + qwIds.addAll(Arrays.asList(workorder.getQwnoticeMemberIds().split(","))); + qwIds.add(workorder.getManagerId()); qwIds.remove(closeDTO.getMember().getQwId()); }else{ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"宸ュ崟鐘舵�佸凡娴佽浆"); @@ -827,7 +867,7 @@ workorder.setDealInfo(closeDTO.getInfo()); workorderMapper.updateById(workorder); //澶勭悊涓婃姤鏃ュ織 - Integer logId = this.saveLog(beforeJson,workorder,Constants.THREE,workorder.getMemberId(),"浠诲姟宸插鐞�",closeDTO.getInfo(),null); + Integer logId = this.saveLog(beforeJson,workorder,Constants.THREE,closeDTO.getMember().getId(),"浠诲姟宸插鐞�",closeDTO.getInfo(),null); List<Multifile> multifileList = closeDTO.getMultifileList(); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ for (Multifile multifile:multifileList) { @@ -856,11 +896,11 @@ public void passOn(PassOnDTO passOnDTO){ if(Objects.isNull(passOnDTO) || Objects.isNull(passOnDTO.getWorkorderId()) - || Objects.isNull(passOnDTO.getPassOnUserId()) + || org.apache.commons.lang3.StringUtils.isBlank(passOnDTO.getPassOnUserId()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } - Member member = memberMapper.selectById(passOnDTO.getPassOnUserId()); + Member member = memberMapper.selectOne(new QueryWrapper<Member>().lambda().eq(Member::getQwId,passOnDTO.getPassOnUserId())); if(Objects.isNull(member)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌琚浆浜や汉淇℃伅"); } @@ -887,14 +927,14 @@ workorder.setStatus(Constants.WorkOrderStatus.waitDeal.getKey()); } workorder.setEditDate(new Date()); - workorder.setUrgeDate(DateUtil.afterHoursDate(new Date(),24)); + workorder.setUrgeDate(DateUtil.afterMinutesDate(new Date(),10)); workorderMapper.updateById(workorder); String paramr2 = member.getCompanyName()+"/"+member.getName(); //澶勭悊涓婃姤鏃ュ織 Integer logId = this.saveLog(beforeJson,workorder, Constants.equalsInteger(passOnDTO.getPassOnType(),Constants.ZERO)?Constants.ONE:Constants.TWO - ,workorder.getMemberId(),"浠诲姟鍒嗛厤",passOnDTO.getInfo(),paramr2); - List<Multifile> multifileList = workorder.getMultifileList(); + ,passOnDTO.getMember().getId(),"浠诲姟鍒嗛厤",passOnDTO.getInfo(),paramr2); + List<Multifile> multifileList = passOnDTO.getMultifileList(); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ for (Multifile multifile:multifileList) { multifile.setObjId(logId); @@ -908,10 +948,12 @@ Category category = categoryMapper.selectById(workorder.getTypeId()); if(Objects.nonNull(passOnDTO.getMember())&&Objects.nonNull(category)){ // 鍙戦�佷紒寰�氱煡 - this.sendQwMsg(workorder,member.getQwId(),passOnDTO.getMember(),category.getName(),Constants.ZERO,null); + this.sendQwMsg(workorder,passOnDTO.getPassOnUserId(),passOnDTO.getMember(),category.getName(),Constants.ZERO,null); } //瀛樺偍寰呭姙浜哄憳淇℃伅 - this.saveNotice(Arrays.asList(passOnDTO.getMember().getQwId().split(",")),workorder.getId(),Constants.ZERO,Constants.TWO); + this.saveNotice(Arrays.asList(passOnDTO.getPassOnUserId().split(",")), + Constants.equalsInteger(workorder.getType(),Constants.TWO)?workorder.getDcaRecordId():workorder.getId(),Constants.ZERO,Constants.TWO); + } @@ -928,16 +970,16 @@ } List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted, Constants.ZERO) .isNotNull(Member::getQwId) - .in(Member::getId, sendCopyDTO.getUserIds().split(","))); + .in(Member::getQwId, sendCopyDTO.getUserIds().split(","))); if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(memberList)) { List<String> qwIdList = memberList.stream().map(i -> i.getQwId()).collect(Collectors.toList()); Category category = categoryMapper.selectById(workorder.getTypeId()); if (Objects.nonNull(category)) { // 鍙戦�佷紒寰�氱煡 - this.sendQwMsg(workorder, String.join(",", qwIdList), sendCopyDTO.getMember(), category.getName(), Constants.ONE, null); + this.sendQwMsg(workorder, String.join(",", qwIdList), sendCopyDTO.getMember(), category.getName(), Constants.TWO, sendCopyDTO.getInfo()); } //瀛樺偍寰呭姙淇℃伅 - this.saveNotice(qwIdList, workorder.getId(), Constants.ONE, Constants.ONE); + this.saveNotice(qwIdList, Constants.equalsInteger(workorder.getType(),Constants.TWO)?workorder.getDcaRecordId():workorder.getId(), Constants.ONE, Constants.ONE); } } @@ -1091,7 +1133,7 @@ public void urge(Integer workorderId,Member member){ Workorder workorder = workorderMapper.selectById(workorderId); workorder.setEditDate(new Date()); - workorder.setUrgeDate(DateUtil.afterHoursDate(new Date(),24)); + workorder.setUrgeDate(DateUtil.afterMinutesDate(new Date(),10)); workorderMapper.updateById(workorder); if(Objects.isNull(workorder)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"鏈煡璇㈠埌宸ュ崟鏁版嵁"); @@ -1100,20 +1142,20 @@ //濡傛灉宸插垎閰� 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())){ + }else if(Constants.equalsInteger(workorder.getStatus(),Constants.WorkOrderStatus.waitDeal.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 + Constants.FOUR ,member.getId(),"鍌績","宸插偓淇� "+urgeUser.getCompanyName() + "/" + urgeUser.getName(),null); //鍙戦�佷紒寰�氱煡 Category category = categoryMapper.selectById(workorder.getTypeId()); if(Objects.nonNull(category)){ // 鍙戦�佷紒寰�氱煡 - this.sendQwMsg(workorder,urgeUser.getQwId(),null,category.getName(),Constants.ONE,null); + this.sendQwMsg(workorder,urgeUser.getQwId(),member,category.getName(),Constants.ONE,null); } } @@ -1122,13 +1164,13 @@ 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() ") + .apply(" URGE_DATE < 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)); + workorder.setUrgeDate(DateUtil.afterMinutesDate(new Date(),10));//DateUtil.afterHoursDate(new Date(),24)); workorderMapper.updateById(workorder); } } @@ -1158,7 +1200,7 @@ } - public void saveNotice(List<String> qwIdList ,Integer workorderId,Integer isSendCopy,Integer type){ + public void saveNotice(List<String> qwIdList , Integer workorderId, Integer isSendCopy, Integer type){ List<Notices> noticesList = new ArrayList<>(); for (String qwId:qwIdList) { //瀛樺偍鎶勯�佽褰� @@ -1186,13 +1228,15 @@ * @throws Exception */ @Override - public List<WorkOrderDataVO> getWorkOrderData(OrderDataDTO orderDataDTO) throws Exception { + public List<WorkOrderDataVO> getWorkOrderData(OrderDataDTO orderDataDTO) { if (Objects.isNull(orderDataDTO.getQueryType())||Objects.isNull(orderDataDTO.getOrderType())) { throw new BusinessException(ResponseStatus.BAD_REQUEST); } String year = DateUtil.getNowYear(); - Integer nowMonth = DateUtil.getNowMonth(); - Integer quarter = (nowMonth - 1) / 3 + 1; +// Integer nowMonth = DateUtil.getNowMonth(); + Integer nowMonth = 12; +// Integer quarter = (nowMonth - 1) / 3 + 1; + Integer quarter =4; List<WorkOrderDataVO> workOrderDataVOList = new ArrayList<>(); //鏌ヨ浠婂勾鎵�鏈夌殑鏁版嵁 List<Workorder> workorderList = workorderMapper.selectJoinList(Workorder.class,new MPJLambdaWrapper<Workorder>() @@ -1207,17 +1251,25 @@ if(Constants.equalsInteger(orderDataDTO.getQueryType(),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"); + String monthDay = year + "-" + org.apache.commons.lang3.StringUtils.leftPad(i+"",2,"0"); List<Workorder> dataList = workorderList.stream().filter(j->DateUtil.formatDate(j.getCreateDate(),"yyyy-MM").equals(monthDay)) .collect(Collectors.toList()); - workOrderDataVO.setDateStr(monthDay); + workOrderDataVO.setDateStr(i+"鏈�"); workOrderDataVO.setGcsTotal(Constants.ZERO); workOrderDataVO.setWtsTotal(Constants.ZERO); workOrderDataVO.setSheTotal(Constants.ZERO); + workOrderDataVO.setDcaNoTotal(Constants.ZERO); + workOrderDataVO.setDcaYesTotal(Constants.ZERO); workOrderDataVO.setUnCloseTotal(Constants.ZERO); workOrderDataVO.setTotal(Constants.ZERO); if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dataList)){ workOrderDataVO.setTotal(dataList.size()); + for(Workorder e :dataList){ + if(Constants.equalsInteger(e.getType(),Constants.ONE)){ + workOrderDataVO.setDcaYesTotal(workOrderDataVO.getDcaYesTotal()+Constants.formatIntegerNum(e.getDcaYesNum()));//DCA绗﹀悎椤� + workOrderDataVO.setDcaNoTotal(workOrderDataVO.getDcaNoTotal()+Constants.formatIntegerNum(e.getDcaNoNum()));//DCA涓嶇鍚堥」 + } + } 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()); @@ -1249,7 +1301,16 @@ workOrderDataVO.setSheTotal(Constants.ZERO); workOrderDataVO.setUnCloseTotal(Constants.ZERO); workOrderDataVO.setTotal(Constants.ZERO); + workOrderDataVO.setDcaNoTotal(Constants.ZERO); + workOrderDataVO.setDcaYesTotal(Constants.ZERO); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dataList)){ + for(Workorder e :dataList){ + if(Constants.equalsInteger(e.getType(),Constants.ONE)){ + workOrderDataVO.setDcaYesTotal(workOrderDataVO.getDcaYesTotal()+Constants.formatIntegerNum(e.getDcaYesNum()));//DCA绗﹀悎椤� + workOrderDataVO.setDcaNoTotal(workOrderDataVO.getDcaNoTotal()+Constants.formatIntegerNum(e.getDcaNoNum()));//DCA涓嶇鍚堥」 + } + } 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()); @@ -1257,14 +1318,121 @@ workOrderDataVO.setUnCloseTotal(workOrderDataVO.getTotal() - workOrderDataVO.getSheTotal() - workOrderDataVO.getWtsTotal() - workOrderDataVO.getGcsTotal()); } workOrderDataVOList.add(workOrderDataVO); - } } return workOrderDataVOList; } + /** + * SHE / 璺岀粖婊戞姤琛� + * @return + * @throws Exception + */ + @Override + public WorkorderIndexNumVO getIndexData(Workorder workorder) { + WorkorderIndexNumVO model = new WorkorderIndexNumVO(); + Date startdate = getStartDateByType(workorder.getTimeType()); + //鏌ヨ浠婂勾鎵�鏈夌殑鏁版嵁 + List<Workorder> list = workorderMapper.selectJoinList(Workorder.class,new MPJLambdaWrapper<Workorder>() + .select("type,count(id) as num") + .eq(Workorder::getIsdeleted,Constants.ZERO) + .ge(startdate!=null,Workorder::getCreateDate,startdate) +// .lt(endDate!=null,Workorder::getCreateDate,endDate) + .groupBy(Workorder::getType )); + if(list !=null){ + for(Workorder w : list){ + if(Constants.equalsInteger(w.getType(),Constants.ZERO)){ + //SHE + model.setSheNum(Constants.formatLongNum(w.getNum())); + }else if(Constants.equalsInteger(w.getType(),Constants.ONE)){ + //DCA鎻愪氦鏁� + model.setDcaNum(Constants.formatLongNum(w.getNum())); + }else if(Constants.equalsInteger(w.getType(),Constants.TWO)){ + //DCA瀛愬伐鍗� + model.setDcaChildNum(Constants.formatLongNum(w.getNum())); + }else if(Constants.equalsInteger(w.getType(),Constants.THREE)){ + //璺岀粖婊� + model.setDbhNum(Constants.formatLongNum(w.getNum())); + } + } + } + List<Workorder> yeslist = workorderMapper.selectJoinList(Workorder.class,new MPJLambdaWrapper<Workorder>() + .select("type,count(id) as num") + .eq(Workorder::getIsdeleted,Constants.ZERO) + .in(Workorder::getStatus,Constants.THREE,Constants.FOUR,Constants.FIVE) + .in(Workorder::getType,Constants.THREE,Constants.TWO) + .ge(startdate!=null,Workorder::getCreateDate,startdate) + .groupBy(Workorder::getType )); + if(yeslist !=null){ + for(Workorder w : yeslist){ + if(Constants.equalsInteger(w.getType(),Constants.TWO)){ + //DCA瀛愬伐鍗曞凡瑙e喅鍜屾湭瑙e喅 + model.setDcaChildYesNum(Constants.formatLongNum(w.getNum())); + model.setDcaChildNoNum(Constants.formatLongNum(model.getDcaChildNum()) -model.getDcaChildYesNum()); + }else if(Constants.equalsInteger(w.getType(),Constants.THREE)){ + //璺岀粖婊戝凡瑙e喅鍜屾湭瑙e喅 + model.setDbhYesNum(Constants.formatLongNum(w.getNum())); + model.setDbhNoNum(Constants.formatLongNum(model.getDbhNum()) -model.getDbhYesNum()); + } + } + } + if(workorder.getTimeType() == null){ + List<Workorder> todays = workorderMapper.selectJoinList(Workorder.class,new MPJLambdaWrapper<Workorder>() + .select("type,count(id) as num") + .eq(Workorder::getIsdeleted,Constants.ZERO) + .apply("to_days(create_date)=to_days(now())") + .groupBy(Workorder::getType )); + if(todays !=null){ + for(Workorder w : todays){ + if(Constants.equalsInteger(w.getType(),Constants.ZERO)){ + //SHE + model.setTodaySheNum(Constants.formatLongNum(w.getNum())); + }else if(Constants.equalsInteger(w.getType(),Constants.ONE)){ + //DCA鎻愪氦鏁� + model.setTodayDcaNum(Constants.formatLongNum(w.getNum())); + }else if(Constants.equalsInteger(w.getType(),Constants.TWO)){ + //DCA瀛愬伐鍗� + model.setTodayDcaChildNum(Constants.formatLongNum(w.getNum())); + }else if(Constants.equalsInteger(w.getType(),Constants.THREE)){ + //璺岀粖婊� + model.setTodayDbhNum(Constants.formatLongNum(w.getNum())); + } + } + } + Workorder dcaList = workorderMapper.selectJoinOne(Workorder.class,new MPJLambdaWrapper<Workorder>() + .select("sum(dca_yes_num) as dcaYesNum,sum(dca_no_num) as dcaNoNum") + .eq(Workorder::getIsdeleted,Constants.ZERO) + .eq(Workorder::getType,Constants.ONE) ); + if(dcaList !=null){ + //DCA绗﹀悎椤瑰拰涓嶇鍚堥」缁熻 + model.setDcaYesNum((long)Constants.formatIntegerNum(dcaList.getDcaYesNum())); + model.setDcaNoNum((long)Constants.formatIntegerNum(dcaList.getDcaNoNum())); + } + } + return model; + } + private Date getStartDateByType(Integer timeType) { + Date date = null; + if(timeType == null){ + return null; + } else if (timeType == 0) { + //鏈懆 + date = DateUtil.getBeginDayOfWeek(0); + }else if (timeType == 1) { + //鏈湀 + date = DateUtil.getBeginDayOfMonth(0); + }else if (timeType == 2) { + //鏈搴� + date = DateUtil.getBeginDayOfSeason(0); + }else if (timeType == 3) { + //鏈勾 + date = DateUtil.getBeginDayOfYear(0); + } + + return date; + } } -- Gitblit v1.9.3