新增可忽略的维修时间

xyc

2025-02-21 664db98c9e8595ce4dd636a27f480e3a08b81ff5

 modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java

@@ -34,6 +34,7 @@
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.util.*;
import java.util.stream.Collectors;


/**
@@ -102,24 +103,32 @@
                    productList = baseDao.selectList(new QueryWrapper<XhProductModel>().eq(Constant.TableColumn.IS_DELETE,
                            Constant.Bool.NO).lt("product_type", 5).ne("product_type", 1).and(wrapper -> wrapper.eq("ship_id", productId).or().eq("id", productId)).orderByAsc(Constant.TableColumn.SORT));
                } else if (ztShow == 5) {
                    List<XhProductModel> dbList = baseDao.getProductListByShip(productId,2,5);
                    List<XhProductModel> dbList = baseDao.getProductListByShip(productId, 2, 5);
                    for (XhProductModel row : dbList) {
                        if (row.getSameSbNum()!=null && row.getSameSbNum() > 1) {
                            for (int i = 1; i <= row.getSameSbNum(); i++) {
                                try {
                                    XhProductModel newRow = row.clone();
                                    newRow.setDeviceNo(i);
                                    newRow.setName(row.getName() + "-" + i);
                                    newRow.setDataId(row.getId().toString() + "-" + i);
                                    productList.add(newRow);
                                } catch (CloneNotSupportedException e) {
                                    e.printStackTrace();
                        int sameNum = row.getSameSbNum() == null ? 1 : row.getSameSbNum();
                        for (int i = 1; i <= sameNum; i++) {
                            try {
                                XhProductModel newRow = null;
                                if (sameNum > 1) {
                                    newRow = row.clone();
                                }
                                else
                                    newRow = row;
                                if ("5".equals(newRow.getProductType())){
                                    newRow.setDeviceNo(i);
                                    newRow.setDataId(row.getId().toString() + "-" + i);
                                    if (i>1){
                                        newRow.setName(row.getName() + "-" + i);
                                    }
                                }
                                else{
                                    newRow.setDeviceNo(0);
                                    newRow.setDataId(row.getId().toString());
                                }
                                productList.add(newRow);
                            } catch (CloneNotSupportedException e) {
                                e.printStackTrace();
                            }
                        } else {
                            row.setDeviceNo(0);
                            row.setDataId(row.getId().toString());
                            productList.add(row);
                        }
                    }
                    productList.sort(Comparator.comparing(XhProductModel::getSort, Comparator.naturalOrder())
@@ -137,8 +146,8 @@
        return baseDao.getNo(pid, productType);
    }

    public List<XhProductModel> getProductList() {
        List<XhProductModel> ProductList = baseDao.getProductList();
    public List<XhProductModel> getProductList(Long shipId, Integer type) {
        List<XhProductModel> ProductList = baseDao.getProductList(shipId, type);
        return TreeUtils.build(ProductList);
    }

@@ -153,6 +162,7 @@
    }

    public List<Map<String, Object>> importProductExcel(MultipartFile mutFile, String progressId, Long shipId) {
        Map<Long, XhProductModel> imgMap = new HashMap<>();
        Date beginDate = new Date();
        List<Map<String, Object>> list = new ArrayList<>();//存储所有的导入状态
        Map<String, Object> map;//存储每一行的状态
@@ -163,8 +173,8 @@
        Map<String, Object> errMap = new HashMap<>();
        Map<String, Integer> reliabType = new HashMap<>();
        reliabType.put("指数分布", 1);
        reliabType.put("二项分布", 3);
        reliabType.put("威布尔分布", 2);
        reliabType.put("二项分布", 3);
        Map<String, Integer> repairType = new HashMap<>();
        repairType.put("指数分布", 1);
        repairType.put("威布尔分布", 2);
@@ -239,6 +249,7 @@
                    String repairMttcrStr = com.zt.core.shiro.ImportUtil.getCellValue(row, 18, pattern); //mttcr
                    String repairMttcrOtherParams2Str = com.zt.core.shiro.ImportUtil.getCellValue(row, 19, pattern); //mttcr其他参数2
                    String repairMttcrOtherParams3Str = com.zt.core.shiro.ImportUtil.getCellValue(row, 20, pattern); //mttcr其他参数3
                    String negligibleRepairTimeStr = com.zt.core.shiro.ImportUtil.getCellValue(row, 21, pattern); //可忽略的维修时间

                    Integer sameSbNum = StringUtils.isNotBlank(sameSbNumStr) ? Integer.parseInt(sameSbNumStr) : 1;
                    Double basicMtbfRegulate = StringUtils.isNotBlank(basicMtbfRegulateStr) ? Double.valueOf(basicMtbfRegulateStr) : null;
@@ -252,6 +263,7 @@
                    Double repairMttcr = StringUtils.isNotBlank(repairMttcrStr) ? Double.parseDouble(repairMttcrStr) : null;
                    Double repairMttcrOtherParams2 = StringUtils.isNotBlank(repairMttcrOtherParams2Str) ? Double.parseDouble(repairMttcrOtherParams2Str) : null;
                    Double repairMttcrOtherParams3 = StringUtils.isNotBlank(repairMttcrOtherParams3Str) ? Double.parseDouble(repairMttcrOtherParams3Str) : null;
                    Double negligibleRepairTime = StringUtils.isNotBlank(negligibleRepairTimeStr) ? Double.parseDouble(negligibleRepairTimeStr) : null;


                    if (StringUtils.isBlank(sb))
@@ -319,6 +331,8 @@
                        xhProductModel.setOperatImg(defultImg);
                        xhProductModel.setNamePath(curXtName);
                        this.insert(xhProductModel);
                        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
                        imgMap.put(xhProductModel.getId(), xhProductModel);

                        //导入预计参数
                        ParamData itemEntity = new ParamData();
@@ -339,6 +353,8 @@
                        xhProductModel.setOperatImg(defultImg);
                        xhProductModel.setNamePath(fxtPath);
                        this.insert(xhProductModel);
                        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
                        imgMap.put(xhProductModel.getId(), xhProductModel);

                        //导入预计参数
                        ParamData itemEntity = new ParamData();
@@ -360,8 +376,12 @@
                    xhProductModel.setNamePath(sbPath);
                    if (insertSb) {
                        this.insert(xhProductModel);
                        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
                        imgMap.put(xhProductModel.getId(), xhProductModel);
                    } else {
                        this.update(xhProductModel);
                        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
                        imgMap.put(xhProductModel.getId(), xhProductModel);
                    }

                    //导入预计参数
@@ -385,6 +405,7 @@
                    itemEntity.setRepairMttcr(repairMttcr);
                    itemEntity.setRepairMttcrOtherParams2(repairMttcrOtherParams2);
                    itemEntity.setRepairMttcrOtherParams3(repairMttcrOtherParams3);
                    itemEntity.setNegligibleRepairTime(negligibleRepairTime);

                    if (modelMap.get(sbPath) == null) {
                        paramDataService.insert(itemEntity);
@@ -451,117 +472,124 @@
            Workbook workbook = new XSSFWorkbook(inputStream);
            // 获取第一个工作表
            Sheet sheet = workbook.getSheetAt(0);
            List.sort((o1, o2) -> {
                String[] parentList1 = o1.getNamePath().split(",");
                String[] parentList2 = o2.getNamePath().split(",");
                String xt1 = parentList1.length > 0 ? parentList1[0] : "";
                String xt2 = parentList2.length > 0 ? parentList2[0] : "";

                // 首先比较xt值
                int xtCompare = xt1.compareTo(xt2);
                if (xtCompare != 0) {
                    return xtCompare;
                }

                // 如果xt相同，比较parentList的长度，确保parentList.length = 2的数据排在前面
                return Integer.compare(parentList1.length, parentList2.length);
            });
            int num = 0;
            String xt = "";
            String fxt = "";
            String sb = "";
            for (int i = 0; i < List.size(); i++) {
                if (List.get(i).getProductType() == 5) {
                    num = num + 1;
                    String[] parentList = List.get(i).getNamePath().split(",");
                    Row row = sheet.createRow(sheet.getLastRowNum() + 1); // 创建新行
                    Cell cell = row.createCell(0);
                    cell.setCellValue(num);
                    if (parentList.length > 2) {
                        if (!xt.equals(parentList[0])) {
                            xt = parentList[0];
                            cell = row.createCell(1);
                            cell.setCellValue(xt);
                        }
                        if (!fxt.equals(parentList[1])) {
                            fxt = parentList[1];
                            cell = row.createCell(2);
                            cell.setCellValue(fxt);
                        }
                        if (!sb.equals(parentList[2])) {
                            sb = parentList[2];
                            cell = row.createCell(3);
                            cell.setCellValue(sb);
                        }
                    } else {
                        if (!xt.equals(parentList[0])) {
                            xt = parentList[0];
                            cell = row.createCell(1);
                            cell.setCellValue(xt);
                        }

                        if (!sb.equals(parentList[1])) {
                            sb = parentList[1];
                            cell = row.createCell(3);
                            cell.setCellValue(sb);
                        }
                num = num + 1;
                String[] parentList = List.get(i).getNamePath().split(",");
                Row row = sheet.createRow(sheet.getLastRowNum() + 1); // 创建新行
                Cell cell = row.createCell(0);
                cell.setCellValue(num);
                if (!xt.equals(parentList[0])) {
                    xt = parentList[0];
                    cell = row.createCell(1);
                    cell.setCellValue(xt);
                }
                if (parentList.length > 2) {
                    if (!fxt.equals(parentList[1])) {
                        fxt = parentList[1];
                        cell = row.createCell(2);
                        cell.setCellValue(fxt);
                    }
                    cell = row.createCell(4);
                    cell.setCellValue(List.get(i).getSameSbNum());

                    cell = row.createCell(5);
                    if (StringUtils.isNotBlank(List.get(i).getEquipType())) {
                        cell.setCellValue(List.get(i).getEquipType());
                    if (!sb.equals(parentList[2])) {
                        sb = parentList[2];
                        cell = row.createCell(3);
                        cell.setCellValue(sb);
                    }
                    cell = row.createCell(6);
                    String type = reliabType.get(List.get(i).getReliabDistribType());
                    cell.setCellValue(type);
                    cell = row.createCell(7);
                    String isNot = isOrNot.get(List.get(i).getBasicJoinCompute());
                } else {
                    if (!sb.equals(parentList[1])) {
                        sb = parentList[1];
                        cell = row.createCell(3);
                        cell.setCellValue(sb);
                    }
                }
                cell = row.createCell(4);
                cell.setCellValue(List.get(i).getSameSbNum());

                cell = row.createCell(5);
                if (StringUtils.isNotBlank(List.get(i).getEquipType())) {
                    cell.setCellValue(List.get(i).getEquipType());
                }
                cell = row.createCell(6);
                String type = reliabType.get(List.get(i).getReliabDistribType());
                cell.setCellValue(type);
                cell = row.createCell(7);
                String isNot = isOrNot.get(List.get(i).getBasicJoinCompute());
                cell.setCellValue(isNot);
                cell = row.createCell(8);
                if (List.get(i).getBasicMtbfRegulate() != null) {
                    cell.setCellValue(List.get(i).getBasicMtbfRegulate());
                }
                cell = row.createCell(9);
                if (List.get(i).getBasicMtbfRegulSuccRate() != null) {
                    cell.setCellValue(List.get(i).getBasicMtbfRegulSuccRate());
                }
                cell = row.createCell(10);
                if (List.get(i).getBasicMtbfOperatingRatio() != null) {
                    cell.setCellValue(List.get(i).getBasicMtbfOperatingRatio());
                } else {
                    cell.setCellValue(1.0);
                }
                cell = row.createCell(11);
                if (List.get(i).getTaskMtbcfRegulate() != null) {
                    cell.setCellValue(List.get(i).getTaskMtbcfRegulate());
                }
                cell = row.createCell(12);
                if (List.get(i).getTaskMtbcfOtherParams2() != null) {
                    cell.setCellValue(List.get(i).getTaskMtbcfOtherParams2());
                }
                cell = row.createCell(13);
                if (List.get(i).getTaskMtbcfOtherParams3() != null) {
                    cell.setCellValue(List.get(i).getTaskMtbcfOtherParams3());
                }
                cell = row.createCell(14);
                if (List.get(i).getTaskMtbcfRegulSuccRate() != null) {
                    cell.setCellValue(List.get(i).getTaskMtbcfRegulSuccRate());
                }
                cell = row.createCell(15);
                if (List.get(i).getTaskMtbcfOperatingRatio() != null) {
                    cell.setCellValue(List.get(i).getTaskMtbcfOperatingRatio());
                } else {
                    cell.setCellValue(1.0);
                }
                cell = row.createCell(16);
                if (List.get(i).getRepairable() != null) {
                    isNot = isOrNot.get(List.get(i).getRepairable());
                    cell.setCellValue(isNot);
                    cell = row.createCell(8);
                    if (List.get(i).getBasicMtbfRegulate() != null) {
                        cell.setCellValue(List.get(i).getBasicMtbfRegulate());
                    }
                    cell = row.createCell(9);
                    if (List.get(i).getBasicMtbfRegulSuccRate() != null) {
                        cell.setCellValue(List.get(i).getBasicMtbfRegulSuccRate());
                    }
                    cell = row.createCell(10);
                    if (List.get(i).getBasicMtbfOperatingRatio() != null) {
                        cell.setCellValue(List.get(i).getBasicMtbfOperatingRatio());
                    } else {
                        cell.setCellValue(1.0);
                    }
                    cell = row.createCell(11);
                    if (List.get(i).getTaskMtbcfRegulate() != null) {
                        cell.setCellValue(List.get(i).getTaskMtbcfRegulate());
                    }
                    cell = row.createCell(12);
                    if (List.get(i).getTaskMtbcfOtherParams2() != null) {
                        cell.setCellValue(List.get(i).getTaskMtbcfOtherParams2());
                    }
                    cell = row.createCell(13);
                    if (List.get(i).getTaskMtbcfOtherParams3() != null) {
                        cell.setCellValue(List.get(i).getTaskMtbcfOtherParams3());
                    }
                    cell = row.createCell(14);
                    if (List.get(i).getTaskMtbcfRegulSuccRate() != null) {
                        cell.setCellValue(List.get(i).getTaskMtbcfRegulSuccRate());
                    }
                    cell = row.createCell(15);
                    if (List.get(i).getTaskMtbcfOperatingRatio() != null) {
                        cell.setCellValue(List.get(i).getTaskMtbcfOperatingRatio());
                    } else {
                        cell.setCellValue(1.0);
                    }
                    cell = row.createCell(16);
                    if (List.get(i).getRepairable() != null) {
                        isNot = isOrNot.get(List.get(i).getRepairable());
                        cell.setCellValue(isNot);
                    }
                    cell = row.createCell(17);
                    if (List.get(i).getRepairDistribType() != null) {
                        type = repairType.get(List.get(i).getRepairDistribType());
                        cell.setCellValue(type);
                    }
                    cell = row.createCell(18);
                    if (List.get(i).getRepairMttcr() != null) {
                        cell.setCellValue(List.get(i).getRepairMttcr());
                    }
                    cell = row.createCell(19);
                    if (List.get(i).getRepairMttcrOtherParams2() != null) {
                        cell.setCellValue(List.get(i).getRepairMttcrOtherParams2());
                    }
                    cell = row.createCell(20);
                    if (List.get(i).getRepairMttcrOtherParams3() != null) {
                        cell.setCellValue(List.get(i).getRepairMttcrOtherParams3());
                    }
                }
                cell = row.createCell(17);
                if (List.get(i).getRepairDistribType() != null) {
                    type = repairType.get(List.get(i).getRepairDistribType());
                    cell.setCellValue(type);
                }
                cell = row.createCell(18);
                if (List.get(i).getRepairMttcr() != null) {
                    cell.setCellValue(List.get(i).getRepairMttcr());
                }
                cell = row.createCell(19);
                if (List.get(i).getRepairMttcrOtherParams2() != null) {
                    cell.setCellValue(List.get(i).getRepairMttcrOtherParams2());
                }
                cell = row.createCell(20);
                if (List.get(i).getRepairMttcrOtherParams3() != null) {
                    cell.setCellValue(List.get(i).getRepairMttcrOtherParams3());
                }
            }
            response.setContentType("application/octet-stream;charset=UTF-8");
@@ -582,4 +610,67 @@
            writeList(dto.getChildren(), List);
        }
    }

    public void refreshCache() {
        List<XhProductModel> productList = baseDao.getProductListAll();
        Map<Long, XhProductModel> imgMap = new HashMap<>();
        for (XhProductModel product : productList) {
            imgMap.put(product.getId(), product);
        }
        CacheUtils.put("sysImgCache", "sysImgCache", imgMap);
    }

    public void getImg(HttpServletResponse response, Long id) {
        Map<Long, XhProductModel> imgMap = new HashMap<>();
        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
        XhProductModel product = imgMap.get(id);
        sysPictureBaseService.getSvgImage(response, product.getOperatImg());
    }

    public void insertProduct(XhProductModel xhProductModel) {
        Integer no = this.getNo(xhProductModel.getPid(), xhProductModel.getProductType());
        if (xhProductModel.getSort() == null || xhProductModel.getSort() < no) {
            xhProductModel.setSort(no + 1);
        }
        if (xhProductModel.getProductType().equals("2")) {
            Long id = UUIDUtil.generateId();
            xhProductModel.setId(id);
            xhProductModel.setShipId(id);
            this.insert(xhProductModel);

            ParamData data = new ParamData();
            data.setShipId(id);
            data.setProductId(id);

            paramDataService.insert(data);
        } else {
            xhProductModel.setNamePath(xhProductModel.getNamePath() + "," + xhProductModel.getName());
            this.insert(xhProductModel);
            ParamData data = new ParamData();
            data.setShipId(xhProductModel.getShipId());
            data.setProductId(xhProductModel.getId());
            paramDataService.insert(data);
        }
        Map<Long, XhProductModel> imgMap = new HashMap<>();
        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
        imgMap.put(xhProductModel.getId(), xhProductModel);
    }

    public void updateProduct(XhProductModel xhProductModel) {
        XhProductModel oldXh = this.get(xhProductModel.getId());
        if (oldXh != null) {
            if (!oldXh.getPid().equals(xhProductModel.getPid())) {
                XhProductModel parentXh = this.get(xhProductModel.getPid());
                if (parentXh.getProductType().equals("3")) {
                    xhProductModel.setNamePath(parentXh.getName() + "," + xhProductModel.getName());
                } else if (parentXh.getProductType().equals("4")) {
                    xhProductModel.setNamePath(parentXh.getNamePath() + "," + xhProductModel.getName());
                }
            }
        }
        this.update(xhProductModel);
        Map<Long, XhProductModel> imgMap = new HashMap<>();
        imgMap = (Map<Long, XhProductModel>) CacheUtils.get("sysImgCache", "sysImgCache");
        imgMap.put(xhProductModel.getId(), xhProductModel);
    }
}