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