密码验证加-

whyclxw

2025-05-28 e16302f9d475c7cc4dd18c5abf1a23cb5502e362

 src/main/java/com/whyc/service/WorkflowLinkService.java

@@ -1,29 +1,545 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.whyc.mapper.WorkflowLinkMapper;
import com.whyc.pojo.WorkflowLink;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.constant.RoleEnum;
import com.whyc.constant.WorkflowDischargePlanEnum;
import com.whyc.constant.WorkflowEnum;
import com.whyc.dto.Response;
import com.whyc.dto.WorkflowLinkDTO;
import com.whyc.mapper.*;
import com.whyc.pojo.*;
import com.whyc.util.ActionUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import javax.annotation.Resource;
import java.util.*;
import java.util.stream.Collectors;

@Service
public class WorkflowLinkService {

    @Autowired
    @Resource
    private WorkflowLinkMapper mapper;

    @Autowired
    private WorkflowMainService mainService;

    @Autowired
    private BattDischargePlanTempService battDischargePlanTempService;

    @Autowired
    private BattdischargePlanService planService;

    @Autowired(required = false)
    private Fbs9100SetParamTempMapper tmpMapper;

    @Autowired(required = false)
    private BatttestdataInfMapper testInfMapper;

    @Autowired(required = false)
    private BattInfMapper binfMapper;

    @Autowired(required = false)
    private StationInfMapper stationInfMapper;

    @Autowired(required = false)
    private WorkflowMainMapper mainMapper;

    @Autowired(required = false)
    private WorkflowLinkMapper linkMapper;

    @Autowired(required = false)
    private FaultUploadMapper faultUploadMapper;

    @Autowired(required = false)
    private BattAlarmDataVerifyMapper alarmDataVerifyMapper;

    @Autowired(required = false)
    private DevAlarmDataVerifyMapper devAlarmDataVerifyMapper;

    @Autowired(required = false)
    private PwrDevAlarmVerifyMapper pwrDevAlarmVerifyMapper;


    @Autowired(required = false)
    private AlarmManualClearMapper alarmManualClearMapper;

    @Autowired
    private FaultUploadApplicationService faultUploadApplicationService;

    public void addBatch(List<WorkflowLink> links) {
        mapper.insertBatchSomeColumn(links);
    }

    public List<WorkflowLink> getWorkflowInfo(Integer mainId) {
        QueryWrapper<WorkflowLink> wrapper = Wrappers.query();
        wrapper.eq("main_id",mainId);
        wrapper.eq("main_id", mainId);
        return mapper.selectList(wrapper);
    }


    public void update(WorkflowLink link) {
    /**传入id,mainId,processLevel,status,dealReason或者dealRejectReason
     * @param linkDTO 节点数据传输类
     * */
    public Response updateLinkOfDischargePlanTemp(WorkflowLinkDTO linkDTO) {
        WorkflowLink link = linkDTO.getLink();
        List<BattDischargePlanTemp> tempList = linkDTO.getTempList();
        String processLevel = link.getProcessLevel();
        Date now = new Date();
        int userId = ActionUtil.getUser().getUId().intValue();
        switch (processLevel){
            case "P0":{ //当前节点过程0-专员审核
                link.setDealUserId(userId);
                if(link.getStatus() == WorkflowEnum.STATUS_REJECT.getValue().intValue()){ //驳回
                    updateLinkFieldAndFinish(link);
                }else{ //通过
                    updateLinkField(link);
                    //新建下一节点-管理层
                    WorkflowLink linkNew = new WorkflowLink();
                    linkNew.setMainId(link.getMainId());
                    linkNew.setParentId(link.getId());
                    linkNew.setProcessLevel(WorkflowDischargePlanEnum.PROCESS_MANAGER1SIGN.getProcessLevel());
                    linkNew.setProcessLevelName(WorkflowDischargePlanEnum.PROCESS_MANAGER1SIGN.getProcessLevelName());
                    linkNew.setCreateTime(now);
                    linkNew.setDealRoleId(RoleEnum.ADMIN.getId());
                    linkNew.setDealType(WorkflowEnum.TYPE_TRANSFER_DISPATCH.getValue());
                    String dealUserName = ActionUtil.getUser().getUName();
                    linkNew.setDealDesc(dealUserName+"审核完成");
                    linkNew.setStatus(WorkflowEnum.STATUS_TAKING.getValue());
                    mapper.insert(linkNew);
                }
                break;
            }
            case "P1"://当前节点为过程1-会签,本场景没有拒绝选项
            {
                battDischargePlanTempService.updateList(tempList);
                updateLinkField(link);
                //判断会签是否完成,完成则新建下一步的节点
                int leftAssignNum = getLeftAssignNum(link.getMainId(),link.getProcessLevel());
                if(leftAssignNum == 0){ //剩余会签数量为0,说明会签已经完成
                    WorkflowLink linkNew = new WorkflowLink();
                    linkNew.setMainId(link.getMainId());
                    linkNew.setParentId(link.getId());
                    linkNew.setProcessLevel(WorkflowDischargePlanEnum.PROCESS_MANAGER1SIGN.getProcessLevel());
                    linkNew.setProcessLevelName(WorkflowDischargePlanEnum.PROCESS_MANAGER1SIGN.getProcessLevelName());
                    linkNew.setCreateTime(now);
                    linkNew.setDealRoleId(RoleEnum.ADMIN.getId());
                    linkNew.setDealType(WorkflowEnum.TYPE_TRANSFER_DISPATCH.getValue());
                    linkNew.setDealDesc("班组会签完成");
                    linkNew.setStatus(WorkflowEnum.STATUS_TAKING.getValue());
                    mapper.insert(linkNew);
                }
                break;
            }
            case "P2"://当前节点为过程2-管理专责审核
            {
                link.setDealUserId(userId);
                if(link.getStatus() == WorkflowEnum.STATUS_REJECT.getValue().intValue()){ //驳回
                    updateLinkFieldAndFinish(link);
                }else{ //通过
                    updateLinkField(link);
                    //新建下一节点-领导层
                    WorkflowLink linkNew = new WorkflowLink();
                    linkNew.setMainId(link.getMainId());
                    linkNew.setParentId(link.getId());
                    linkNew.setProcessLevel(WorkflowDischargePlanEnum.PROCESS_MANAGER2SIGN.getProcessLevel());
                    linkNew.setProcessLevelName(WorkflowDischargePlanEnum.PROCESS_MANAGER2SIGN.getProcessLevelName());
                    linkNew.setCreateTime(now);
                    linkNew.setDealRoleId(RoleEnum.LEADER.getId());
                    linkNew.setDealType(WorkflowEnum.TYPE_TRANSFER_DISPATCH.getValue());
                    String dealUserName = ActionUtil.getUser().getUName();
                    linkNew.setDealDesc(dealUserName+"审核完成");
                    linkNew.setStatus(WorkflowEnum.STATUS_TAKING.getValue());
                    mapper.insert(linkNew);
                }
                break;
            }
            case "P3"://当前节点为过程3-领导审批
            {
                link.setDealUserId(userId);
                updateLinkFieldAndFinish(link);
                if(link.getStatus().intValue() == WorkflowEnum.STATUS_FINISH.getValue()) {
                    Integer mainId = link.getMainId();
                    WorkflowMain main = mainService.getOne(mainId);
                    if (main.getType() == 1) { //将计划转移到正式表
                        List<BattDischargePlanTemp> tempListByMain = battDischargePlanTempService.getListByMainId(mainId);
                        planService.insertConfirmDischargePlan(tempListByMain);
                    }
                }
                break;
            }
        }
        return new Response().setII(1,"更新完成");
    }

    public Response updateLink(WorkflowLinkDTO linkDTO) {
        int userId = ActionUtil.getUser().getUId().intValue();
        if(linkDTO.getType().intValue() == WorkflowEnum.MAIN_TYPE_FAULT_UPLOAD.getValue()) { //故障隐患流程
            updateLinkOfFaultUpload(linkDTO, userId);
        }
        return new Response().setII(1,"更新完成");
    }

    private void updateLinkOfFaultUpload(WorkflowLinkDTO linkDTO, int userId) {
        Date now = new Date();
        WorkflowLink link = linkDTO.getLink();
        String processLevel = link.getProcessLevel();
        FaultUpload faultUpload = linkDTO.getFaultUpload();
        switch (processLevel){
            case "P2"://当前节点为过程1-管理层审核
            {
                link.setDealUserId(userId);
                if(link.getStatus() == WorkflowEnum.STATUS_REJECT.getValue().intValue()){ //驳回
                    updateLinkFieldAndFinish(link);
                }else{ //通过
                    //主表更新层级
                    mainService.updateProcessLevel("P3",link.getMainId());
                    updateLinkField(link);
                    //新建下一节点-领导层
                    WorkflowLink linkNew = new WorkflowLink();
                    linkNew.setMainId(link.getMainId());
                    linkNew.setParentId(link.getId());
                    linkNew.setProcessLevel(WorkflowDischargePlanEnum.PROCESS_MANAGER2SIGN.getProcessLevel());
                    linkNew.setProcessLevelName(WorkflowDischargePlanEnum.PROCESS_MANAGER2SIGN.getProcessLevelName());
                    linkNew.setCreateTime(now);
                    linkNew.setDealRoleId(RoleEnum.LEADER.getId());
                    linkNew.setDealType(WorkflowEnum.TYPE_TRANSFER_DISPATCH.getValue());
                    String dealUserName = ActionUtil.getUser().getUName();
                    linkNew.setDealDesc(dealUserName+"审核完成");
                    linkNew.setStatus(WorkflowEnum.STATUS_TAKING.getValue());
                    mapper.insert(linkNew);

                    //管理层提出申报,生成申报库内的记录
                    FaultUploadApplication application = new FaultUploadApplication();
                    application.setAlarmNum(faultUpload.getAlarmNum());
                    application.setAlarmType(faultUpload.getAlarmType());
                    application.setStationId(faultUpload.getStationId());
                    application.setType(faultUpload.getType());
                    application.setDescription(faultUpload.getDescription());
                    application.setUploadUserId(userId);
                    application.setCreateTime(now);
                    application.setMainId(link.getMainId());
                    faultUploadApplicationService.add(application);

                }
                break;
            }
            case "P3"://当前节点为过程3-领导层审批
            {
                link.setDealUserId(userId);
                updateLinkFieldAndFinish(link);
                break;
            }
        }
    }

    /**
     *
     * @param mainId 特定的单据
     * @param processLevel 特定的过程
     * @return 特定单据,特定过程,未完成的会签的数量
     */
    private int getLeftAssignNum(Integer mainId, String processLevel) {
        QueryWrapper<WorkflowLink> query = Wrappers.query();
        query.select("count(*) as id").eq("main_id",mainId).eq("process_level",processLevel).ne("status",WorkflowEnum.STATUS_FINISH.getValue());
        return mapper.selectOne(query).getId();
    }

    /**
     * 更新节点,主节点不完结
     * @param link 参数id,status,dealReason或者dealRejectReason
     */
    private void updateLinkField(WorkflowLink link) {
        Date now = new Date();
        link.setDealTime(now);
        mapper.updateById(link);
    }

    /**
     * 更新节点,主节点完结,单据完结
     * @param link 参数id,mainId,status,dealReason或者dealRejectReason
     */
    private void updateLinkFieldAndFinish(WorkflowLink link) {
        updateLinkField(link);
        Date now = link.getDealTime();
        if(link.getStatus() == WorkflowEnum.STATUS_FINISH.getValue().intValue()){ //通过
            mainService.updateStatus(link.getMainId(),WorkflowEnum.MAIN_STATUS_END_PASS.getValue(),link.getDealReason(),now);
        }else{ //驳回
            mainService.updateStatus(link.getMainId(),WorkflowEnum.MAIN_STATUS_END_REJECT.getValue(),link.getDealRejectReason(),now);
        }
    }

    public Map<Integer, Integer> getReceivedStatistics(int type, UserInf user) {
        Map<Integer,Integer> statistics = new HashMap<>();
        statistics.put(1,0);
        statistics.put(6,0);
        statistics.put(58,0);
        List<WorkflowLink> links = mapper.getReceivedList(type,user);
        Map<Integer, List<WorkflowLink>> receivedListMap = links.stream().collect(Collectors.groupingBy(WorkflowLink::getStatus));
        Set<Integer> statusSet = receivedListMap.keySet();
        for (Integer status : statusSet) {
            if (status == 5 || status == 8) {
                statistics.put(58, statistics.get(58) + receivedListMap.get(status).size());
            } else {
                statistics.put(status, receivedListMap.get(status).size());
            }
        }
        return statistics;
    }

    /**
     *
     * 二次核容和隐患故障的统计
     *
     * 增加了全部 0
     * 0:全部
     * 1:审批中
     * 2:通过
     * 3:驳回
     *
     * status含义:1-待接单,6-待审核,58-已审核
     * @param type
     * @param user
     * @return
     */
    public Response getReceivedStatistics2(int type, UserInf user) {
        Map<Integer,Integer> statistics = new HashMap<>();
        statistics.put(0,0);
        statistics.put(1,0);
        statistics.put(2,0);
        statistics.put(3,0);
        List<WorkflowLink> links = mapper.getReceivedList2(type,user);
        Map<Integer, List<WorkflowLink>> receivedListMap = links.stream().collect(Collectors.groupingBy(WorkflowLink::getStatus));
        Set<Integer> statusSet = receivedListMap.keySet();
        int sum = 0;
        for (Integer status : statusSet) {
            int size = receivedListMap.get(status).size();
            if (status == 1 || status == 6) { //审批中
                statistics.put(1, statistics.get(1) + size);
            } else if(status == 5){ //通过
                statistics.put(2, size);
            }else if(status == 8){ //驳回
                statistics.put(3,size);
            }
            sum+=size;
        }
        statistics.put(0,sum);
        return new Response().set(1,statistics);
    }


    public void add(WorkflowLink link) {
        mapper.insert(link);
    }

    //更新节点(除放电计划之外的)
    public Response linkOfTemp(WorkflowLink link) {
        Date now = new Date();
        int userId = ActionUtil.getUser().getUId().intValue();
        int roleId = ActionUtil.getUser().getURole();
        switch (roleId) {
            case 0://当前节点为过程0-管理员审批
            {
                link.setDealUserId(userId);
                link.setDealDesc("管理员处理通过");
                if (link.getStatus() == WorkflowEnum.STATUS_REJECT.getValue().intValue()) { //驳回
                    link.setDealDesc("管理员驳回");
                    updateLinkFieldAndFinish(link);
                } else { //通过
                    updateLinkField(link);
                    //新建下一节点-领导层
                    WorkflowLink linkNew = new WorkflowLink();
                    linkNew.setMainId(link.getMainId());
                    linkNew.setProcessLevel("P3");
                    linkNew.setProcessLevelName("领导审批");
                    linkNew.setParentId(link.getId());
                    linkNew.setCreateTime(now);
                    linkNew.setDealRoleId(RoleEnum.LEADER.getId());
                    linkNew.setDealType(WorkflowEnum.TYPE_TRANSFER_DISPATCH.getValue());
                    linkNew.setDealDesc("领导层处理中");
                    linkNew.setStatus(WorkflowEnum.STATUS_TAKING.getValue());
                    mapper.insert(linkNew);
                    //修改主表的流程
                    mainService.updateProcessLevel("P3", link.getMainId());
                }
                break;
            }
            case 10://当前节点为过程10-领导层审批
            {
                link.setDealUserId(userId);
                if (link.getStatus() == WorkflowEnum.STATUS_REJECT.getValue().intValue()) { //驳回
                    link.setDealDesc("领导层驳回");
                } else {
                    link.setDealDesc("领导层审批通过");
                }
                updateLinkFieldAndFinish(link);
            }
        }
        return new Response().set(1, true);
    }

    //查询节点(除放电计划之外的)
    public Response searchTmp(int uId, int uRole, int type, int status, int pageNum, int pageSize) {
        //查询自己需要处理或者审批的
        PageHelper.startPage(pageNum, pageSize);
        List<WorkflowLink> list = mapper.searchTmp(uId, uRole, type, status);
        PageInfo pageInfo = new PageInfo(list);
        //追加机房信息
        if(type !=1) { //1为查询放电计划,不追加机房信息
            List<Integer> mainIdList = list.stream().map(WorkflowLink::getMainId).collect(Collectors.toList());
            //从二次核容查询
            List<StationInf> stationInfList = tmpMapper.getStationInfWithSpecificMainId(mainIdList);
            //从故障隐患查询
            List<StationInf> stationInfList2 = faultUploadApplicationService.getStationInfWithSpecificMainId(mainIdList);

            list.forEach(link -> {
                if(link.getWorkflowMain().getType().intValue() == WorkflowEnum.MAIN_TYPE_DISCHARGE_DIST.getValue()){
                    for (StationInf stationInf : stationInfList) {
                        if(stationInf.getTogetherFlag() == link.getMainId()){
                            link.setStationInf(stationInf);
                            break;
                        }
                    }
                }
                else if(link.getWorkflowMain().getType().intValue() == WorkflowEnum.MAIN_TYPE_FAULT_UPLOAD.getValue()){
                    for (StationInf stationInf : stationInfList2) {
                        if(stationInf.getTogetherFlag() == link.getMainId()){
                            link.setStationInf(stationInf);
                            break;
                        }
                    }
                }
            });
        }



        return new Response().setII(1, list == null ? false : true, pageInfo, "查询节点(除放电计划之外的)");
    }

    //节点为二次放电时查询二次放电参数和本年上一次有效核容数据
    public Response searchLastHrById(int mid) {
        Map<String, Object> map = searchHrByMId(mid);
        return new Response().setII(1, true, map, "节点为二次放电时查询二次放电参数和本年上一次有效核容数据");
    }

    //节点为故障隐患
    public Response searcFaultById(int mid) {
        Map<String, Object> map = searchFaultByMId(mid);
        return new Response().setII(1, true, map, "节点为二次放电时查询二次放电参数和本年上一次有效核容数据");
    }

    //查询自己申请的工单(去除放电计划)
    public Response getFlowMainByUid(int uId, int type, int status, int pageNum, int pageSize) {
        //查询自己需要处理或者审批的
        PageHelper.startPage(pageNum, pageSize);
        List<WorkflowMain> list = mapper.getFlowMainByUid(uId, type, status);
        if (list != null && list.size() > 0) {
            for (WorkflowMain main : list) {
                if (main.getType() == 2) {
                    Map<String, Object> map = searchHrByMId(main.getId());
                    main.setHrMap(map);
                }
                if (main.getType() == 3) {
                    Map<String, Object> map = searchFaultByMId(main.getId());
                    main.setFaultMap(map);
                }
            }
        }
        PageInfo pageInfo = new PageInfo(list);
        return new Response().setII(1, list == null ? false : true, pageInfo, "查询自己申请的工单(去除放电计划)");
    }

    //节点为二次放电时查询二次放电参数和本年上一次有效核容数据
    public Map searchHrByMId(int mid) {
        Map<String, Object> map = new HashMap<>();
        //查询二次放电参数
        QueryWrapper tmpWrapper = Wrappers.query();
        tmpWrapper.eq("main_id", mid);
        tmpWrapper.last("limit 1");
        Fbs9100SetParamTemp tmp = tmpMapper.selectOne(tmpWrapper);
        map.put("paramTmp", tmp);
        //main表单信息
        QueryWrapper mainWrapper = Wrappers.query();
        mainWrapper.eq("id", mid);
        mainWrapper.last("limit 1");
        WorkflowMain main = mainMapper.selectOne(mainWrapper);
        map.put("main", main);
        //link表单信息
        QueryWrapper linkWrapper = Wrappers.query();
        linkWrapper.eq("main_id", mid);
        linkWrapper.orderByAsc("parent_id");
        List<WorkflowLink> linkList = linkMapper.selectList(linkWrapper);
        map.put("linkList", linkList);
        //本年上一次有效核容数据
        if (tmp != null) {
            BatttestdataInf tinf = testInfMapper.searchHrYear(tmp.getBattGroupId());
            map.put("testInf", tinf);
            QueryWrapper infWrapper = new QueryWrapper();
            infWrapper.eq("battGroupId", tmp.getBattGroupId());
            infWrapper.last("limit 1");
            Battinf binf = binfMapper.selectOne(infWrapper);
            map.put("binf", binf);
        }
        return map;
    }

    //节点为故障隐患时
    public Map searchFaultByMId(int mid) {
        Map<String, Object> map = new HashMap<>();
        //查询故障隐患申请表
        QueryWrapper faultWrapper = Wrappers.query();
        faultWrapper.eq("main_id", mid);
        faultWrapper.last("limit 1");
        FaultUpload faultUpload = faultUploadMapper.selectOne(faultWrapper);
        map.put("faultUpload", faultUpload);
        if (faultUpload != null) {
            QueryWrapper infWrapper = new QueryWrapper();
            infWrapper.eq("stationid", faultUpload.getStationId());
            infWrapper.last("limit 1");
            StationInf sinf = stationInfMapper.selectOne(infWrapper);
            map.put("sinf", sinf);
            QueryWrapper almWrapper = new QueryWrapper();
            almWrapper.eq("alm_solekey", faultUpload.getAlarmNum());
            almWrapper.last("limit 1");
            if (faultUpload.getAlarmType() == 1) {//电池告警
                BattAlarmDataVerify battAlm = alarmDataVerifyMapper.selectOne(almWrapper);
                map.put("alarm", battAlm);
            } else if (faultUpload.getAlarmType() == 2) {//设备告警
                DevAlarmDataVerify devAlm = devAlarmDataVerifyMapper.selectOne(almWrapper);
                map.put("alarm", devAlm);
            } else if (faultUpload.getAlarmType() == 3) {//电源告警
                PwrDevAlarmVerify pwrAlm = pwrDevAlarmVerifyMapper.selectOne(almWrapper);
                map.put("alarm", pwrAlm);
            }
        }
        //查询是否解决
        //查询故障隐患申请表
        QueryWrapper clearWrapper = Wrappers.query();
        clearWrapper.eq("main_id", mid);
        clearWrapper.last("limit 1");
        AlarmManualClear alarmManualClear = alarmManualClearMapper.selectOne(clearWrapper);
        if (alarmManualClear != null) {
            map.put("clearFlag", true);
        } else {
            map.put("clearFlag", false);
        }
        //main表单信息
        QueryWrapper mainWrapper = Wrappers.query();
        mainWrapper.eq("id", mid);
        mainWrapper.last("limit 1");
        WorkflowMain main = mainMapper.selectOne(mainWrapper);
        map.put("main", main);
        //link表单信息
        QueryWrapper linkWrapper = Wrappers.query();
        linkWrapper.eq("main_id", mid);
        linkWrapper.orderByAsc("parent_id");
        List<WorkflowLink> linkList = linkMapper.selectList(linkWrapper);
        map.put("linkList", linkList);
        return map;
    }
}