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 | 235 ++++++++++++++++++++++++++++++++++++++++------------------ 1 files changed, 162 insertions(+), 73 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 659e1f3..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 @@ -10,6 +10,8 @@ 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; @@ -80,28 +82,95 @@ //澶勭悊浜哄憳绫讳俊鎭� this.dealNoticeData(workorder); //澶勭悊SHE浜嬩欢鐘舵�� - workorder.setStatus(Constants.equalsInteger(workorder.getType(),Constants.ZERO)?Constants.WorkOrderStatus.close.getKey():Constants.WorkOrderStatus.waitConfirm.getKey()); + 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.dealLogData(workorder); - //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 dealLogData(Workorder workorder){ - //澶勭悊涓婃姤鏃ュ織 DCA宸ュ崟 鏃ュ織瀛樺偍鑷冲瓙涓氬姟 涓嶅瓨鍦ㄤ簬鐖剁骇 - if(!Constants.equalsInteger(workorder.getType(),Constants.ONE)){ - String logTitle = "宸ュ崟鎻愭姤"; - if(!Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ - logTitle = Constants.equalsInteger(workorder.getType(),Constants.ONE)?"璺岀粖婊戦闄╂彁鎶�":"DCA涓婃姤"; + 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{ + } - this.saveLog(null,workorder,Constants.ZERO,workorder.getMemberId(),logTitle,null); + } + 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); } } @@ -113,6 +182,7 @@ 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()); multifile.setObjType(Constants.multiFileType.upload); @@ -132,13 +202,14 @@ 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()); @@ -147,10 +218,11 @@ dcaWorkOrder.setEventInfo(dcaNoProblemDTO.getEventInfo()); workorderMapper.insert(dcaWorkOrder); //瀛樺偍鏃ュ織 - this.dealLogData(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.upload); @@ -284,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) @@ -296,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(); @@ -308,6 +380,13 @@ } //鏌ヨ鏃ュ織淇℃伅 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; } @@ -392,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)); } -- Gitblit v1.9.3