From 9ae471f00bab21ee9cc40efdc26291fb580c03bf Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 08 四月 2025 18:19:08 +0800 Subject: [PATCH] 代码初始化 --- server/src/main/java/com/doumee/service/business/impl/WorkorderServiceImpl.java | 356 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 338 insertions(+), 18 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 3d531b2..a1eea89 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 @@ -1,20 +1,36 @@ package com.doumee.service.business.impl; +import com.alibaba.fastjson.JSONObject; +import com.doumee.biz.system.SystemDictDataBiz; +import com.doumee.core.constants.Constants; +import com.doumee.core.constants.ResponseStatus; +import com.doumee.core.exception.BusinessException; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; +import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; -import com.doumee.dao.business.WorkorderMapper; -import com.doumee.dao.business.model.Workorder; +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.service.business.WorkorderService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.github.yulichang.wrapper.MPJLambdaWrapper; +import org.apache.catalina.Manager; import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; +import org.springframework.util.StringUtils; -import java.util.List; +import javax.annotation.Resource; +import java.io.Serializable; +import java.util.*; +import java.util.concurrent.TimeUnit; +import java.util.stream.Collectors; /** * 宸ュ崟淇℃伅琛⊿ervice瀹炵幇 @@ -27,11 +43,256 @@ @Autowired private WorkorderMapper workorderMapper; + @Autowired + private MultifileMapper multifileMapper; + + @Autowired + private WorkorderLogMapper workorderLogMapper; + + @Autowired + private SystemDictDataBiz systemDictDataBiz; + + @Autowired + private MemberMapper memberMapper; + + @Autowired + private ManagersMapper managersMapper; + + @Autowired + private CategoryMapper categoryMapper; + + @Resource(name="sessionRedisTemplate") + private RedisTemplate<Object, Serializable> redisTemplate; + + @Override 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.setStatus(Constants.ZERO); + workorder.setCode(this.getNextCode(workorder.getType())); + //澶勭悊浜哄憳绫讳俊鎭� + this.dealNoticeData(workorder); workorderMapper.insert(workorder); + //瀛樺偍DCA 闂璁板綍琛� + this.saveProblemData(workorder); + //瀛樺偍闄勪欢淇℃伅 + this.saveMutiFile(workorder); + //澶勭悊涓婃姤鏃ュ織 + this.saveLog(null,workorder,Constants.ZERO,workorder.getMemberId()); + //TODO 鍙戦�侀�氱煡 + return workorder.getId(); } + + + /** + * 瀛樺偍闄勪欢淇℃伅 + * @param workorder + */ + public void saveMutiFile(Workorder workorder){ + List<Multifile> multifileList = workorder.getMultifileList(); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ + for (Multifile multifile:multifileList) { + 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); + } + } + multifileMapper.insert(multifileList); + } + } + + + /** + * 澶勭悊 DCA 鎻愭姤 闂鏁版嵁 + * @param workorder + */ + public void saveProblemData(Workorder workorder){ + if(Constants.equalsInteger(workorder.getType(),Constants.TWO)){ + List<DCANoProblemDTO> dcaNoProblemDTOList = workorder.getDcaNoProblemDTOList(); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(dcaNoProblemDTOList)){ + for (DCANoProblemDTO dcaNoProblemDTO:dcaNoProblemDTOList) { + Category problem = categoryMapper.selectById(dcaNoProblemDTO.getProblemId()); + 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.setIsdeleted(Constants.ZERO); + dcaWorkOrder.setProblemTitle(problem.getName()); + dcaWorkOrder.setProblemId(problem.getId()); + dcaWorkOrder.setProblemInfo(problem.getRemark()); + dcaWorkOrder.setDcaRecordId(workorder.getId()); + workorderMapper.insert(dcaWorkOrder); + List<Multifile> multifileList = dcaNoProblemDTO.getMultifileList(); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(multifileList)){ + for (Multifile multifile:multifileList) { + multifile.setObjId(dcaWorkOrder.getId()); + multifile.setCreateDate(new Date()); + multifile.setObjType(Constants.multiFileType.dcaWorkOrder); + } + multifileMapper.insert(multifileList); + } + } + } + } + } + + + + /** + * 澶勭悊閫氱煡绫讳汉鍛樹俊鎭� + * @param workorder + */ + public void dealNoticeData(Workorder workorder){ + //SHE涓婃姤 鎻愪氦绫诲瀷涓哄悓浜� 澶勭悊鍚屼簨淇℃伅 + if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)&&Constants.equalsInteger(workorder.getMemberType(),Constants.ONE)){ + List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda().eq(Member::getIsdeleted,Constants.ZERO).in(Member::getQwId,workorder.getMemberQwids().split(","))); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(memberList)){ + workorder.setMemberNames(memberList.stream().map(i->i.getName()).collect(Collectors.joining(","))); + } + } + //璺岀粖婊戜簨浠朵笂鎶� 鏌ヨSHE璐熻矗浜� + if(Constants.equalsInteger(workorder.getType(),Constants.THREE) || Constants.equalsInteger(workorder.getType(),Constants.ONE)){ + List<Managers> managersList = managersMapper.selectJoinList(Managers.class,new MPJLambdaWrapper<Managers>().selectAll(Managers.class) + .selectAs(Member::getName,Managers::getMemberName) + .leftJoin(Member.class,Member::getId,Managers::getMemberId) + .eq(Managers::getIsdeleted,Constants.ZERO) + .eq(Managers::getType,Constants.ZERO).orderByAsc(Managers::getSortnum) + ); + if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(managersList)){ + workorder.setQwnoticeMemberIds(managersList.stream().map(i->i.getMemberId().toString()).collect(Collectors.joining(","))); + if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ + workorder.setEmialMemberIds(managersList.stream().map(i->i.getMemberId().toString()).collect(Collectors.joining(","))); + } + } + } + + + } + + + /** + * + * @param beforeJson + * @param afterWorkorder + * @param objType 鎿嶄綔绫诲瀷 0浠诲姟涓婃姤 1浠诲姟纭 2浠诲姟鍒嗛厤鐗╀笟涓荤 3浠诲姟鍏抽棴 4浠诲姟鍒嗛厤澶勭悊浜� 5浠诲姟鍌績 + * @param memberId + */ + public void saveLog(String beforeJson,Workorder afterWorkorder,Integer objType,Integer memberId){ + WorkorderLog workorderLog = new WorkorderLog(); + workorderLog.setCreateDate(new Date()); + workorderLog.setEditDate(new Date()); + workorderLog.setIsdeleted(Constants.ZERO); + workorderLog.setBeforeContent(beforeJson); + workorderLog.setAfterContent(JSONObject.toJSONString(afterWorkorder)); + workorderLog.setParam1(memberId.toString()); + workorderLog.setObjId(afterWorkorder.getId().toString()); + workorderLog.setObjType(objType); + workorderLogMapper.insert(workorderLog); + } + + + /** + * 鏁版嵁鏍¢獙 + * @param workorder + */ + public void isValidBaseParam(Workorder workorder){ + if(Objects.isNull(workorder) + || Objects.isNull(workorder.getSubmitDate()) + || Objects.isNull(workorder.getHappenTime()) + || Objects.isNull(workorder.getType()) + || Objects.isNull(workorder.getTypeId()) + || Objects.isNull(workorder.getLocaltionId()) + || !( Constants.equalsInteger(workorder.getType(),Constants.ZERO) || Constants.equalsInteger(workorder.getType(),Constants.ONE) ||Constants.equalsInteger(workorder.getType(),Constants.THREE) + )){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + //SHE 浜嬩欢涓婃姤 + if(Constants.equalsInteger(workorder.getType(),Constants.ZERO)){ + if(Objects.isNull(workorder.getMemberType()) + || Objects.isNull(workorder.getOutJiuyi()) + || (Constants.equalsInteger(workorder.getOutJiuyi(),Constants.ZERO) && Objects.isNull(workorder.getIsYiwushi())) + || (Constants.equalsInteger(workorder.getIsYiwushi(),Constants.ZERO) && Objects.isNull(workorder.getIsHurted())) + || Objects.isNull(workorder.getWorkRelated()) + || (Constants.equalsInteger(workorder.getMemberType(),Constants.TWO) && StringUtils.isEmpty(workorder.getMemberNames())) + || (Constants.equalsInteger(workorder.getMemberType(),Constants.ONE) && StringUtils.isEmpty(workorder.getMemberQwids())) + || org.apache.commons.lang3.StringUtils.isBlank(workorder.getEventInfo()) + ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + } + //璺岀粖婊� 浜嬩欢涓婃姤 + if(Constants.equalsInteger(workorder.getType(),Constants.THREE)){ + if(org.apache.commons.lang3.StringUtils.isBlank(workorder.getRiskInfo()) + ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + } + //DCA 浜嬩欢涓婃姤 + if(Constants.equalsInteger(workorder.getType(),Constants.ONE)){ + if(Objects.isNull(workorder.getDcaYesNum()) + || Objects.isNull(workorder.getDcaNoNum()) + ){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + } + + //鏁版嵁搴撴暟鎹牎楠� + Category typeCategory = categoryMapper.selectById(workorder.getTypeId()); + if(Objects.isNull(typeCategory)){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + Category locationCategory = categoryMapper.selectById(workorder.getLocaltionId()); + if(Objects.isNull(locationCategory)){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + workorder.setLocationName(locationCategory.getNamePath()); + } + + @Override + public Workorder getDetail(Integer id){ + Workorder workorder = workorderMapper.selectJoinOne(Workorder.class, + new MPJLambdaWrapper<Workorder>() + .selectAll(Workorder.class) + .selectAs(Member::getPhone,Workorder::getMemberPhone) + .selectAs(Member::getName,Workorder::getMemberName) + .selectAs(Workorder::getCompanyName,Workorder::getCompanyName) + .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(Workorder::getId,id) + .last(" limit 1 ") + ); + 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)); + 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(); + for (Multifile multifile:multifileList) { + multifile.setFileurlFull(path+multifile.getFileurl()); + } + workorder.setMultifileList(multifileList); + } + } + return workorder; + } + @Override public void deleteById(Integer id) { @@ -87,9 +348,19 @@ @Override public PageData<Workorder> findPage(PageWrap<Workorder> pageWrap) { IPage<Workorder> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); - QueryWrapper<Workorder> queryWrapper = new QueryWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); - queryWrapper.lambda() + MPJLambdaWrapper<Workorder> queryWrapper = new MPJLambdaWrapper<>(); + pageWrap.getModel().setIsdeleted(Constants.ZERO); + queryWrapper + .selectAll(Workorder.class) + .selectAs(Member::getName,Workorder::getMemberName) + .selectAs(Member::getCompanyName,Workorder::getCompanyName) + .selectAs(Member::getPhone,Workorder::getMemberPhone) + .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())) @@ -108,7 +379,7 @@ .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()) - .eq(pageWrap.getModel().getMemberNames() != null, Workorder::getMemberNames, pageWrap.getModel().getMemberNames()) + .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()) @@ -118,8 +389,7 @@ .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()) - .ge(pageWrap.getModel().getTypeId() != null, Workorder::getTypeId, Utils.Date.getStart(pageWrap.getModel().getTypeId())) - .le(pageWrap.getModel().getTypeId() != null, Workorder::getTypeId, Utils.Date.getEnd(pageWrap.getModel().getTypeId())) + .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()) @@ -137,16 +407,9 @@ .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()) - ; - for(PageWrap.SortData sortData: pageWrap.getSorts()) { - if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { - queryWrapper.orderByDesc(sortData.getProperty()); - } else { - queryWrapper.orderByAsc(sortData.getProperty()); - } - } - return PageData.from(workorderMapper.selectPage(page, queryWrapper)); + .eq(pageWrap.getModel().getDcaCsIds() != null, Workorder::getDcaCsIds, pageWrap.getModel().getDcaCsIds()) ; + queryWrapper.orderByDesc(Workorder::getCreateDate); + return PageData.from(workorderMapper.selectJoinPage(page,Workorder.class, queryWrapper)); } @Override @@ -154,4 +417,61 @@ QueryWrapper<Workorder> wrapper = new QueryWrapper<>(workorder); return workorderMapper.selectCount(wrapper); } + + public String getNextCode(Integer type){ + String date = DateUtil.getFomartDate(new Date(),"yyyyMMddHHmmss"); + String key = "S"; + if(Constants.equalsInteger(type,Constants.ONE)){ + key = "D"; + }else if(Constants.equalsInteger(type,Constants.THREE)){ + key = "A"; + } + String code = redisTemplate.opsForValue().get(key+"_CODE").toString(); + if(StringUtils.isEmpty(code)){ + code = "01"; + } + redisTemplate.opsForValue().set(key+"_CODE",Integer.valueOf(code)+1); + return key + date + org.apache.commons.lang3.StringUtils.leftPad(code,2,"0"); + } + + + + @Override + public void initializationCode(){ + redisTemplate.opsForValue().set("A_CODE",1); + redisTemplate.opsForValue().set("S_CODE",1); + redisTemplate.opsForValue().set("D_CODE",1); + } + + + + 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())){ + throw new BusinessException(ResponseStatus.BAD_REQUEST); + } + Workorder workorder = workorderMapper.selectById(closeDTO.getWorkorderId()); + 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(),"宸ュ崟鐘舵�佸凡娴佽浆鏃犳硶杩涜鎿嶄綔"); + } + + + + + + + + } + + + + + } -- Gitblit v1.9.3