通信LIMS后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
value
2024-06-07 6c3b64f52182038accf1c27a2f040d64ddc4528a 
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java


@@ -1,6 +1,9 @@


package com.yuanchu.mom.service.impl;




import cn.hutool.core.bean.BeanUtil;


import cn.hutool.core.date.DateTime;


import cn.hutool.core.date.DateUtil;


import cn.hutool.core.lang.UUID;


import cn.hutool.core.util.ObjectUtil;


import cn.hutool.core.util.StrUtil;


import com.alibaba.fastjson.JSON;


@@ -14,9 +17,7 @@


import com.deepoove.poi.config.Configure;


import com.deepoove.poi.config.ConfigureBuilder;


import com.deepoove.poi.data.*;


import com.deepoove.poi.data.style.BorderStyle;


import com.deepoove.poi.data.style.Style;


import com.deepoove.poi.data.style.TableStyle;


import com.deepoove.poi.data.style.*;


import com.deepoove.poi.util.TableTools;


import com.yuanchu.mom.common.GetLook;


import com.yuanchu.mom.common.PrintChina;


@@ -26,24 +27,26 @@


import com.yuanchu.mom.exception.ErrorException;


import com.yuanchu.mom.mapper.*;


import com.yuanchu.mom.pojo.*;


import com.yuanchu.mom.service.InsOrderPlanService;


import com.yuanchu.mom.service.InsOrderService;


import com.yuanchu.mom.service.StandardTemplateService;


import com.yuanchu.mom.utils.GiveCode;


import com.yuanchu.mom.service.*;


import com.yuanchu.mom.utils.JackSonUtil;


import com.yuanchu.mom.utils.MatrixToImageWriter;


import com.yuanchu.mom.utils.QueryWrappers;


import com.yuanchu.mom.vo.InsOrderPlanTaskSwitchVo;


import com.yuanchu.mom.vo.InsOrderPlanVO;


import com.yuanchu.mom.vo.Result;


import org.apache.commons.io.IOUtils;


import org.apache.poi.xwpf.usermodel.*;


import org.springframework.beans.factory.annotation.Value;


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.web.multipart.MultipartFile;




import javax.annotation.Resource;


import java.io.*;


import java.nio.file.Files;


import java.nio.file.Paths;


import java.text.SimpleDateFormat;


import java.time.LocalDate;


import java.time.LocalDateTime;


import java.time.format.DateTimeFormatter;


import java.util.*;


@@ -56,7 +59,6 @@


 * 检验任务-业务实现层


 */


@Service


//@AllArgsConstructor


public class InsOrderPlanServiceImpl extends ServiceImpl<InsOrderMapper, InsOrder> implements InsOrderPlanService {




    @Resource


@@ -83,9 +85,6 @@


    private String twoCode;




    @Resource


    private GiveCode giveCode;




    @Resource


    private InsReportMapper insReportMapper;




    @Resource


@@ -93,6 +92,33 @@




    @Resource


    private InsProductUserMapper insProductUserMapper;




    @Resource


    private InsUnPassService insUnPassService;




    @Resource


    AuxiliaryOutputWorkingHoursMapper auxiliaryOutputWorkingHoursMapper;




    @Resource


    private InformationNotificationService informationNotificationService;




    @Resource


    private UserMapper userMapper;




    @Resource


    private CustomMapper customMapper;




    @Value("${file.path}")


    private String imgUrl;




    @Resource


    private InsBushingService insBushingService;




    @Resource


    private InsFiberMapper insFiberMapper;




    @Resource


    private InsOrderFileMapper insOrderFileMapper;




    @Override


    public Map<String, Object> selectInsOrderPlanList(Page page, InsOrderPlanDTO insOrderPlanDTO) {


@@ -104,6 +130,20 @@


            insOrderPlanDTO.setUserId(userId.longValue());


        }


        IPage<InsOrderPlanVO> insOrderPage = insSampleMapper.findInsSampleAndOrder(page, QueryWrappers.queryWrappers(insOrderPlanDTO), userId);


        map.put("body", insOrderPage);


        return map;


    }




    @Override


    public Map<String, Object> inspectionOrderDetailsTaskSwitching(Page page, InsOrderPlanDTO insOrderPlanDTO) {


        Map<String, Object> map = new HashMap<>();


        map.put("head", PrintChina.printChina(InsOrderPlanTaskSwitchVo.class));


        Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId(null);


        Integer userId = map1.get("userId");


        if (ObjectUtil.isNotEmpty(insOrderPlanDTO.getUserId())) {


            insOrderPlanDTO.setUserId(userId.longValue());


        }


        IPage<InsOrderPlanTaskSwitchVo> insOrderPage = insSampleMapper.inspectionOrderDetailsTaskSwitching(page, QueryWrappers.queryWrappers(insOrderPlanDTO), userId);


        map.put("body", insOrderPage);


        return map;


    }


@@ -130,15 +170,96 @@


            insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, id).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, LocalDateTime.now()).set(InsOrderState::getInsState, 1));


        }


        Map<String, Object> map = insOrderService.getInsOrderAndSample(id, laboratory);


        Set<Integer> set = new HashSet<>();


        Map<Integer, String> map2 = new HashMap<>();


        List<SampleProductDto> list = JSON.parseArray(JSON.toJSONString(map.get("sampleProduct")), SampleProductDto.class);


        for (SampleProductDto samples : list) {


//            Set<Integer> set = new HashSet<>();


//            Map<Integer, String> map2 = new HashMap<>();


            if (BeanUtil.isEmpty(samples.getInsProduct())) continue;


            getTemplateThing(set, map2, samples);


            samples.setBushing(insBushingService.selectBushingBySampleId(samples.getId()));


//            getTemplateThing(set, map2, samples.getInsProduct());


        }


        map.put("sampleProduct", list);


        return map;


    }




    @Override


    public List<InsProduct> getInsProduct(Integer id, Integer type, String laboratory) {


        List<InsProduct> insProducts = new ArrayList<>();


        switch (type) {


            case 0:


                insProducts = insSampleMapper.getInsProduct1(id, laboratory);


                break;


            case 1:


                insProducts = insSampleMapper.getInsProduct2(id);


                break;


            case 2:


                insProducts = insSampleMapper.getInsProduct3(id);


                break;


        }


        Set<Integer> set = new HashSet<>();


        Map<Integer, String> map2 = new HashMap<>();


        if (BeanUtil.isEmpty(insProducts)) return null;


        getTemplateThing(set, map2, insProducts);


        return insProducts;


    }




    @Override


    public List<String> checkSubmitPlan(Integer orderId, String laboratory) {


        List<String> collect = new ArrayList<>();


        List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId));


        List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList());


        List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).eq(InsProduct::getState, 1).eq(InsProduct::getInsResult, 0));


        if (insProducts.size() > 0) {


            collect = insProducts.stream().map(insProduct -> {


                return insProduct.getInspectionItem() + "-" + insProduct.getInspectionItemSubclass();


            }).collect(Collectors.toList());


        }


        return collect;


    }




    @Override


    public Map<String, Object> getFileList(Page page, InsOrderFile insOrderFile) {


        Map<String, Object> map = new HashMap<>();


        map.put("head", PrintChina.printChina(InsOrderFile.class));


        IPage<InsOrderFile> insOrderFileIPage = insOrderFileMapper.getFileList(page, QueryWrappers.queryWrappers(insOrderFile));


        map.put("body", insOrderFileIPage);


        return map;


    }




    @Override


    public int uploadFile(Integer orderId, MultipartFile file) {


        String urlString;


        String pathName;


        String path;


        String filename = file.getOriginalFilename();


        String contentType = file.getContentType();


        InsOrderFile insOrderFile = new InsOrderFile();


        insOrderFile.setInsOrderId(orderId);


        insOrderFile.setFileName(filename);


        if (contentType != null && contentType.startsWith("image/")) {


            // 是图片


            path = imgUrl;


            insOrderFile.setType(1);


        } else {


            // 是文件


            path = wordUrl;


            insOrderFile.setType(2);


        }


        try {


            File realpath = new File(path);


            if (!realpath.exists()) {


                realpath.mkdirs();


            }


            pathName = UUID.randomUUID() + "_" + file.getOriginalFilename();


            urlString = realpath + "/" + pathName;


            file.transferTo(new File(urlString));


            insOrderFile.setFileUrl(pathName);


            return insOrderFileMapper.insert(insOrderFile);


        } catch (Exception e) {


            e.printStackTrace();


            System.err.println("附件上传错误");


            return 0;


        }


    }




    @Override


@@ -232,6 +353,36 @@


                insProduct.setUpdateUser(userId);


                insProductMapper.updateById(insProduct);


                insProductUserMapper.insert(new InsProductUser(null, userId, LocalDateTime.now(), insProduct.getId()));




                insProduct = insProductMapper.selectById(insProduct);




                //查询检验单信息


                InsOrder insOrder = insOrderMapper.selectById(insSampleMapper.selectById(insProduct.getInsSampleId()).getInsOrderId());


                //校验如果这个人这个检测项目已经添加过了则不需要再新增


                Long count = auxiliaryOutputWorkingHoursMapper.selectCount(Wrappers.<AuxiliaryOutputWorkingHours>lambdaQuery()


                        .eq(AuxiliaryOutputWorkingHours::getCheck, userId)


                        .eq(AuxiliaryOutputWorkingHours::getInspectProject, insProduct.getInspectionItemSubclass() + insProduct.getInspectionItem())


                        .eq(AuxiliaryOutputWorkingHours::getOrderNo, insOrder.getEntrustCode()));


                if (count == 0) {


                    //添加每个人的产量工时


                    AuxiliaryOutputWorkingHours auxiliaryOutputWorkingHours = new AuxiliaryOutputWorkingHours();


                    auxiliaryOutputWorkingHours.setInspectProject(insProduct.getInspectionItemSubclass() + insProduct.getInspectionItem());//检测项目


                    auxiliaryOutputWorkingHours.setOrderNo(insOrder.getEntrustCode());//非加班委托单号


                    auxiliaryOutputWorkingHours.setWorkTime(insProduct.getManHour());//非加班工时


                    auxiliaryOutputWorkingHours.setAmount(1);//非加班数量


                    auxiliaryOutputWorkingHours.setOutputWorkTime(insProduct.getManHour());//产量工时


                    auxiliaryOutputWorkingHours.setManHourGroup(insProduct.getManHourGroup());//工时分组


                    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");


                    DateTimeFormatter formatters = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");


                    auxiliaryOutputWorkingHours.setDateTime(LocalDateTime.now().toLocalDate().atStartOfDay().format(formatters));//日期


                    LocalDateTime localDateTime = LocalDateTime.now();


                    DateTime parse = DateUtil.parse(localDateTime.format(formatter));


                    auxiliaryOutputWorkingHours.setWeekDay(getWeek(localDateTime.format(formatters)));//星期


                    auxiliaryOutputWorkingHours.setWeek(String.valueOf(DateUtil.weekOfYear(DateUtil.offsetDay(parse, 1))));//周次


                    auxiliaryOutputWorkingHours.setCheck(userId);//检测人


                    auxiliaryOutputWorkingHoursMapper.insert(auxiliaryOutputWorkingHours);


                }




                InsSample insSample = insSampleMapper.selectById(insProductMapper.selectById(insProduct.getId()).getInsSampleId());


                insSample.setInsState(1);


                Long l = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery()


@@ -284,14 +435,42 @@


        Integer num = (type == 1 ? 5 : 4);


        LocalDateTime now = LocalDateTime.now();


        insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, orderId).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, now).set(InsOrderState::getInsState, num).set(InsOrderState::getVerifyTell, tell).set(InsOrderState::getVerifyUser, getLook.selectPowerByMethodAndUserId(null).get("userId")));


        List<InsOrderState> insOrderStates = insOrderStateMapper.selectList(Wrappers.<InsOrderState>lambdaQuery().eq(InsOrderState::getInsOrderId, orderId));


        long count = insOrderStates.stream().filter(a -> a.getInsState() == 5).count();


        if (count == insOrderStates.size() && num == 5) {


        Long count = insOrderStateMapper.selectCount(Wrappers.<InsOrderState>lambdaQuery().eq(InsOrderState::getInsOrderId, orderId).ne(InsOrderState::getInsState, 5));


        if (count == 0 && num == 5) {


            List<InsUnPass> insUnPasses = new ArrayList<>();


            /*样品下的项目只要有一个项目不合格则检验结果为0,否则为1*/


            List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId));


            for (InsSample insSample : insSamples) {


                List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getInsSampleId, insSample.getId()).eq(InsProduct::getState, 1));


                List<Integer> results = insProducts.stream().map(InsProduct::getInsResult).filter(str -> str != null).collect(Collectors.toList());


                if (results.contains(0)) {


                    insSample.setInsResult(0);


                } else {


                    insSample.setInsResult(1);


                }


                insSampleMapper.updateById(insSample);


                /*复核通过后，将不合格的项目信息添加到ins_un_pass表中*/


                for (InsProduct insProduct : insProducts) {


                    if (insProduct.getInsResult() == 0) {


                        InsUnPass insUnPass = new InsUnPass();


                        insUnPass.setModel(insSample.getModel());


                        insUnPass.setSample(insSample.getSample());


                        insUnPass.setInspectionItem(insProduct.getInspectionItem());


                        insUnPass.setInspectionItemSubclass(insProduct.getInspectionItemSubclass());


                        insUnPass.setLastValue(insProduct.getLastValue());


                        insUnPass.setEntrustCode(insOrderMapper.selectById(orderId).getEntrustCode());


                        List<Integer> userIds = insProductUserMapper.selectList(Wrappers.<InsProductUser>lambdaQuery().eq(InsProductUser::getInsProductId, insProduct.getId())).stream().map(InsProductUser::getCreateUser).distinct().collect(Collectors.toList());


                        String name = userMapper.selectBatchIds(userIds).stream().map(User::getName).collect(Collectors.joining(","));


                        insUnPass.setName(name);


                        insUnPasses.add(insUnPass);


                    }


                }


                insUnPassService.saveBatch(insUnPasses);


            }


            InsOrder insOrder = insOrderMapper.selectById(orderId);


            Map<String, String> user = insProductMapper.selectUserById(insOrder.getUserId());


            List<SampleProductDto> samples = insSampleMapper.selectSampleProductListByOrderId(orderId);


            InsReport insReport = new InsReport();


//            insReport.setCode(giveCode.giveCode("JCZX/TX-", "ins_report", "-", "yyMMdd"));


            insReport.setCode(insOrder.getEntrustCode());


            insReport.setInsOrderId(orderId);


            Set<Integer> set = new HashSet<>();


@@ -302,13 +481,16 @@


            Set<String> models = new HashSet<>();


            AtomicReference<Integer> productSize = new AtomicReference<>(0);


            String[] monthNames = {"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"};


            AtomicReference<String> resultCh = new AtomicReference<>("");


            AtomicReference<String> resultEn = new AtomicReference<>("");


            samples.forEach(a -> {


                Long productCount = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getInsSampleId, a.getId()));


                productSize.set(productSize.get() + Integer.parseInt(productCount + ""));


                models.add(a.getModel());


                standardMethod.add(baseMapper.getStandardMethodCode(a.getStandardMethodListId()));


                Set<String> templateSet = new HashSet<>();


                getTemplateThing(set, map2, a);


                getTemplateThing(set, map2, a.getInsProduct());


                for (InsProduct b : a.getInsProduct()) {


                    standardMethod.add(b.getMethodS());


                    productSize.set(productSize.get() + 1);


                    if (b.getInsProductResult() != null) {


                        List<JSONObject> jsonObjects = JSON.parseArray(b.getInsProductResult().getEquipValue(), JSONObject.class);


                        for (JSONObject jsonObject : jsonObjects) {


@@ -317,13 +499,16 @@


                            }


                        }


                    }


                    if (b.getTemplate() == null) {


                        continue;


                    }


                    if (b.getTemplate().size() == 0) {


                        continue;


                    }


                    templateSet.add(JSON.toJSONString(b.getTemplate()));


                }


                AtomicInteger index = new AtomicInteger();


                templateSet.forEach(tem -> {


                    AtomicInteger index = new AtomicInteger();


                    Set<Integer> set2 = new HashSet<>();


                    List<RowRenderData> rows = new ArrayList<>();


                    List<TextRenderData> text = new ArrayList<>();


@@ -359,12 +544,19 @@


                    List<JSONObject> temp = JSON.parseArray(JSON.toJSONString(excelDtos), JSONObject.class);


                    Map<String, InsProduct> pMap = new HashMap<>();


                    Set<String> delRSet = new HashSet<>();


                    delRSet.add("0");


                    delRSet.add("1");


                    for (JSONObject jo1 : temp) {


                        JSONObject v = JSON.parseObject(JSON.toJSONString(jo1.get("v")));


                        if (Integer.parseInt(jo1.get("c") + "") > 9) {


                            delSet.add(jo1.get("c") + "");


                            continue;


                        }


                        if (v.get("ps") != null) {


                            int count3 = 0;


                            String str = "";


                            if ("检验值".equals(JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + "") || "设备名称".equals(JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + "") || "设备编码".equals(JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + "")) {


                            String s = JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value") + "";


                            if ("检验值".equals(s) || "设备名称".equals(s) || "设备编码".equals(s) || "试验方法".equals(s) || "检测方法".equals(s)) {


                                delSet.add(jo1.get("c") + "");


                                continue;


                            }


@@ -398,8 +590,6 @@


                                    delRSet.add(jo1.get("r") + "");


                                }


                            }


                        } else {


                            if ("参数".equals(v.get("v"))) delSet.add(jo1.get("c") + "");


                        }


                    }


                    for (int i = 0; i < temp.size(); i++) {


@@ -433,6 +623,8 @@


                                        textRenderData.setText("√");


                                        break;


                                    case 0:


                                        resultCh.set(resultCh.get() + "、" + p.getInspectionItem() + (Objects.equals(p.getInspectionItemSubclass(), "") ? "" : " " + p.getInspectionItemSubclass()));


                                        resultEn.set(resultEn.get() + "、" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "") || Objects.equals(p.getInspectionItemSubclassEn(), null)) ? "" : " " + p.getInspectionItemSubclassEn()));


                                        textRenderData.setText("×");


                                        break;


                                    default:


@@ -469,6 +661,8 @@


                                        textRenderData.setText("✔");


                                        break;


                                    case 0:


                                        resultCh.set(resultCh.get() + "、" + p.getInspectionItem() + (p.getInspectionItemSubclass().equals("") ? "" : " " + p.getInspectionItemSubclass()));


                                        resultEn.set(resultEn.get() + "、" + p.getInspectionItemEn() + ((Objects.equals(p.getInspectionItemSubclassEn(), "") || Objects.equals(p.getInspectionItemSubclassEn(), null)) ? "" : " " + p.getInspectionItemSubclassEn()));


                                        textRenderData.setText("✖");


                                        break;


                                    default:


@@ -491,8 +685,8 @@


                            textRenderData.setText(textRenderData.getText() + "∑" + jo1.get("mc"));


                        }


                        Style style = new Style();


                        style.setFontFamily(v.get("ff") == null ? "微软雅黑" : v.get("ff") + "");


//                        style.setFontSize(v.get("fs")==null?14:Integer.parseInt(v.get("fs")+""));


//                        style.setFontFamily(v.get("ff") == null ? "宋体" : v.get("ff") + "");


                        style.setFontFamily("宋体");


                        if (!((v.get("fc") + "").indexOf("rgb") > -1)) {


                            style.setColor(v.get("fc") == null ? "000000" : (v.get("fc") + "").replace("#", ""));


                        } else {


@@ -500,31 +694,28 @@


                        }


                        textRenderData.setStyle(style);


                        text.add(textRenderData);


                        if (i == temp.size() - 1) {


                            TextRenderData[] text2 = text.toArray(new TextRenderData[0]);


                            rowRenderData = Rows.of(text2).rowAtleastHeight(1).center().create();


                            rows.add(rowRenderData);


                            text = new ArrayList<>();


                        }


                    }


                    TextRenderData[] text2 = text.toArray(new TextRenderData[0]);


                    rowRenderData = Rows.of(text2).rowAtleastHeight(1).center().create();


                    if (rowRenderData.getCells().size() != 0) {


                        rows.add(rowRenderData);


                    }


                    TableRenderData tableRenderData = new TableRenderData();


                    tableRenderData.setRows(rows);


                    TableStyle tableStyle = new TableStyle();


                    /*JSONObject styleJo = JSON.parseObject(JSON.toJSONString(b.getStyle().get("columnlen")));


                    List<Integer> colLen = new ArrayList<>();


                    int colSize = rows.get(0).getCells().size();


                    int colOne = Integer.parseInt(b.getTemplate().get(0).get("r") + "");


                    for (int i = colOne; i < colSize + colOne; i++) {


                        if (styleJo.get(i + "") == null) {


                            colLen.add(pxToCm(100));


                        } else {


                            int i1 = Integer.parseInt(styleJo.get(i + "") + "");


                            colLen.add(pxToCm(i1));


                    int countSize = tableRenderData.getRows().get(0).getCells().size();


                    for (RowRenderData row : tableRenderData.getRows()) {


                        for (CellRenderData cell : row.getCells()) {


                            System.out.print(cell.getParagraphs().get(0).getContents());


                        }


                    }*/


//                    tableStyle.setColWidths(ArrayUtils.toPrimitive(colLen.toArray(new Integer[0])));


                        System.out.println("");


                        if (row.getCells().size() != countSize) {


                            throw new ErrorException("每行单元格不相等");


                        }


                    }


                    TableStyle tableStyle = new TableStyle();


                    tableStyle.setColWidths(new int[]{650, 1600, 2000, 750, 2800, 1100, 1100});


                    tableStyle.setWidth("10000");


                    tableStyle.setAlign(TableRowAlign.CENTER);


                    tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);


                    BorderStyle borderStyle = new BorderStyle();


                    borderStyle.setColor("000000");


                    borderStyle.setType(XWPFTable.XWPFBorderType.THICK);


@@ -583,17 +774,217 @@


            String finalModelStr = modelStr;


            String sampleEn = insSampleMapper.getSampleEn(insOrder.getSample());


            String orderType = insOrderMapper.getEnumLabelByValue(insOrder.getOrderType());


            String formType = insOrderMapper.getEnumLabelByValue(insOrder.getFormType());


            ConfigureBuilder builder = Configure.builder();


            builder.useSpringEL(true);


            List<Map<String, String>> finalDeviceList = deviceList;


            Integer userId = insSampleUserMapper.selectOne(Wrappers.<InsSampleUser>lambdaQuery().eq(InsSampleUser::getInsSampleId, orderId).orderByDesc(InsSampleUser::getCreateTime).last("limit 1")).getUserId();


            String signatureUrl;


            try {


                signatureUrl = userMapper.selectById(userId).getSignatureUrl();


            } catch (Exception e) {


                throw new ErrorException("找不到检验人的签名");


            }


            Custom custom = customMapper.selectById(user.get("company"));


            if (!resultCh.get().equals("")) {


                resultCh.set("依据委托要求，" + resultCh.get().replaceFirst("、", "") + "等所检项目不符合要求，其余所检项目均符合要求。");


                resultEn.set("According to commissioned requirements," + resultEn.get().replaceFirst("、", "") + " these inspected items do not meet the requirements, all other inspected items meet the requirements.");


            } else {


                resultCh.set("依据委托要求，所检项目均符合要求。");


                resultEn.set("According to commissioned requirements, all the tested items meet the requirements.");


            }


            /*光纤的检验报告*/


            //先判断是否有光纤配置


            List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().eq(InsProduct::getState, 1).in(InsProduct::getInsSampleId, insSamples.stream().map(InsSample::getId).distinct().collect(Collectors.toList())));


            List<Integer> collect = insProducts.stream().map(InsProduct::getInsFiberId).filter(str -> str != null).collect(Collectors.toList());


            List<Map<String, Object>> tables2 = new ArrayList<>();


            if (collect.size() > 0) {


                samples.forEach(sample -> {


                    List<InsProduct> insProducts1 = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery()


                            .eq(InsProduct::getState, 1)


                            .eq(InsProduct::getInsSampleId, sample.getId())


                            .isNotNull(InsProduct::getInsFiberId));


                    long size = insProducts1.size();


                    long size2 = insProducts1.stream().map(InsProduct::getInsFiberId).distinct().count();


                    List<RowRenderData> rows = new ArrayList<>();


                    //判断检验项目是否有父子关系


                    Boolean state = true;


                    for (InsProduct insProduct : insProducts1) {


                        if (!insProduct.getInspectionItemSubclass().equals("") && insProduct.getInspectionItemSubclass() != null) {


                            state = false;


                        }


                    }


                    int a = 1;


                    if (!state) {


                        a = 2;


                    }


                    //表格的行数


                    for (long i = 0; i < size2 + a; i++) {


                        RowRenderData rowRenderData = new RowRenderData();




                        RowStyle rowStyle = new RowStyle();


                        rowStyle.setHeight(40);


                        rowRenderData.setRowStyle(rowStyle);


                        List<CellRenderData> cells = new ArrayList<>();


                        //表格的列数


                        for (long j = 0; j < size + 2; j++) {


                            CellRenderData cellRenderData = new CellRenderData();


                            CellStyle cellStyle = new CellStyle();


                            cellStyle.setVertAlign(XWPFTableCell.XWPFVertAlign.CENTER);


                            cellRenderData.setCellStyle(cellStyle);


                            List<ParagraphRenderData> paragraphRenderDataList = new ArrayList<>();


                            ParagraphRenderData paragraphRenderData = new ParagraphRenderData();


                            ParagraphStyle paragraphStyle = new ParagraphStyle();


                            paragraphStyle.setAlign(ParagraphAlignment.CENTER);


                            paragraphRenderData.setParagraphStyle(paragraphStyle);


                            List<RenderData> renderData = new ArrayList<>();


                            TextRenderData textRenderData = new TextRenderData();


                            Style style = new Style();


                            style.setFontFamily("宋体");


                            style.setColor("000000");


                            textRenderData.setStyle(style);


                            if (i == 0) {


                                //第一行


                                if (j == 0) {


                                    //第一列


                                    textRenderData.setText("管色标\nPipe∑100");


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                } else if (j == 1) {


                                    //第二列


                                    textRenderData.setText("光纤色标\nScanning Number∑101");


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                } else {


                                    //项目信息


                                    textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItem() + "\n" + insProducts1.get((int) (j - 2)).getInspectionItemEn()+"∑"+(j+101));


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                }


                            } else if (a == 2 && i == 1) {


                                //有父子项目关系的第三行


                                if (j == 0) {


                                    //第一列


                                    textRenderData.setText("管色标\nPipe∑100");


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                } else if (j == 1) {


                                    //第二列


                                    textRenderData.setText("光纤色标\tScanning Number∑101");


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                } else {


                                    //项目信息


                                    //判断是否有项目子类


                                    if (insProducts1.get((int) (j - 2)).getInspectionItemSubclass().equals("") || insProducts1.get((int) (j - 2)).getInspectionItemSubclass() == null) {


                                        textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItem() + "\n" + insProducts1.get((int) (j - 2)).getInspectionItemEn()+"∑"+(j+101));


                                    } else {


                                        textRenderData.setText(insProducts1.get((int) (j - 2)).getInspectionItemSubclass() + "\n" + insProducts1.get((int) (j - 2)).getInspectionItemSubclassEn());


                                    }


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                }


                            } else {


                                int aa = 0;


                                if (a == 2) {


                                    aa = (int) i - 2;


                                } else aa = (int) i - 1;


                                InsFiber insFiber = insFiberMapper.selectById(insProducts1.get(aa).getInsFiberId());


                                //填值


                                if (j == 0) {


                                    //第一列


                                    textRenderData.setText(insFiber.getBushColor());


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                } else if (j == 1) {


                                    //第二列


                                    textRenderData.setText(insFiber.getColor());


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                } else {


                                    //项目信息


                                    textRenderData.setText(insProducts1.get((int) (j - 2)).getLastValue());


                                    renderData.add(textRenderData);


                                    paragraphRenderData.setContents(renderData);


                                    paragraphRenderDataList.add(paragraphRenderData);


                                    cellRenderData.setParagraphs(paragraphRenderDataList);


                                    cells.add(cellRenderData);


                                }


                            }


                        }


                        rowRenderData.setCells(cells);


                        if (rowRenderData.getCells().size() != 0) {


                            rows.add(rowRenderData);


                        }


                    }


                    TableRenderData tableRenderData = new TableRenderData();


                    tableRenderData.setRows(rows);


                    int countSize = tableRenderData.getRows().get(0).getCells().size();


                    for (RowRenderData row : tableRenderData.getRows()) {


                        for (CellRenderData cell : row.getCells()) {


                            System.out.print(cell.getParagraphs().get(0).getContents());


                        }


                        System.out.println("");


                        if (row.getCells().size() != countSize) {


                            throw new ErrorException("每行单元格不相等");


                        }


                    }


                    TableStyle tableStyle = new TableStyle();


                    tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);


                    tableStyle.setAlign(TableRowAlign.CENTER);


                    BorderStyle borderStyle = new BorderStyle();


                    borderStyle.setColor("000000");


                    borderStyle.setType(XWPFTable.XWPFBorderType.THICK);


                    borderStyle.setSize(14);


                    tableStyle.setLeftBorder(borderStyle);


                    tableStyle.setTopBorder(borderStyle);


                    tableStyle.setRightBorder(borderStyle);


                    tableStyle.setBottomBorder(borderStyle);


                    tableRenderData.setTableStyle(tableStyle);


                    Map<String, Object> table = new HashMap<>();


                    table.put("table2", tableRenderData);


                    table.put("report", insReport);


                    table.put("sample_number",sample.getSampleCode() );


                    table.put("type", sample.getModel());


                    tables2.add(table);


                });


            }






            XWPFTemplate template = XWPFTemplate.compile(url, builder.build()).render(


                    new HashMap<String, Object>() {{


                        put("order", insOrder);


                        put("report", insReport);


                        put("user", user);


                        put("custom", custom);


                        put("sampleSize", samples.size());


                        put("tables", tables);


                        put("tableSize", tables.size() + 1);


                        put("tables2", tables2);


                        put("standardMethod", (standardMethod2.toString().equals("null") ? "" : standardMethod2));


                        put("deviceList", finalDeviceList);


                        put("twoCode", Pictures.ofLocal(codePath).create());


@@ -604,20 +995,25 @@


                        put("insTime", insOrder.getInsTime().format(DateTimeFormatter.ofPattern("yyyy年MM月dd日")));


                        put("insTimeEn", monthNames[insOrder.getInsTime().getMonthValue() - 1] + " " + now.getDayOfMonth() + ", " + now.getYear());


                        put("writeUrl", null);


                        put("insUrl", null);


                        put("insUrl", Pictures.ofLocal(imgUrl + "/" + signatureUrl).create());


                        put("examineUrl", null);


                        put("ratifyUrl", null);


                        put("sampleEn", sampleEn);


                        put("orderType", orderType);


                        put("getTime", insOrder.getExamineTime().format(DateTimeFormatter.ofPattern("yyyy年MM月dd日")));


                        put("getTimeEn", monthNames[insOrder.getExamineTime().getMonthValue() - 1] + " " + insOrder.getExamineTime().getDayOfMonth() + ", " + insOrder.getExamineTime().getYear());


                        put("seal1", null);


                        put("seal2", null);


                        put("formTypeCh", formType);


                        put("formTypeEn", insOrder.getFormType());


                        put("resultCh", resultCh.get());


                        put("resultEn", resultEn.get());


                    }});


            try {


                String name = insReport.getCode().replace("/", "") + ".docx";


                template.writeAndClose(Files.newOutputStream(Paths.get(wordUrl + "/" + name)));


                insReport.setUrl("/word/" + name);


                insReportMapper.insert(insReport);


//                insOrder.setState(4);


                insOrder.setInsState(5);


                insOrderMapper.updateById(insOrder);


            } catch (IOException e) {


@@ -658,8 +1054,6 @@


                            }


                        }


                    }


                    maps.forEach((k, v) -> {


                    });


                    List<String> list = new ArrayList<>();


                    for (String s : maps.keySet()) {


                        list.add(s);


@@ -667,7 +1061,9 @@


                    for (int a = list.size() - 1; a >= 0; a--) {


                        Map<String, Integer> v = maps.get(list.get(a));


                        for (int j = 0; j < v.get("er") - v.get("sr") + 1; j++) {


                            TableTools.mergeCellsHorizonal(xwpfTables.get(i), v.get("sr") + j, v.get("sc"), v.get("ec"));


                            if (v.get("ec") > v.get("sc")) {


                                TableTools.mergeCellsHorizonal(xwpfTables.get(i), v.get("sr") + j, v.get("sc"), v.get("ec"));


                            }


                        }


                        if (v.get("er") > v.get("sr")) {


                            TableTools.mergeCellsVertically(xwpfTables.get(i), v.get("sc"), v.get("sr"), v.get("er"));


@@ -686,16 +1082,18 @@


        return 1;


    }




    private void getTemplateThing(Set<Integer> set, Map<Integer, String> map2, SampleProductDto a) {


        for (InsProduct product : a.getInsProduct()) {


    private void getTemplateThing(Set<Integer> set, Map<Integer, String> map2, List<InsProduct> insProducts) {


        for (InsProduct product : insProducts) {


            if (product.getTemplateId() == null) {


                product.setTemplate(new ArrayList<>());


                continue;


            }


            String thing = null;


            if (product.getTemplateId() != null && set.add(product.getTemplateId())) {


                map2.put(product.getTemplateId(), standardTemplateService.getStandTempThingById(product.getTemplateId()) + "");


                thing = map2.get(product.getTemplateId());


            }


            String thing = map2.get(product.getTemplateId());


//            thing = map2.get(product.getTemplateId());


            if (StrUtil.isNotEmpty(thing)) {


                JSONObject sheet = JSON.parseObject(JSON.toJSONString(JSON.parseArray(JSON.toJSONString(JSON.parseObject(thing).get("data"))).get(0)));


                JSONObject config = JSON.parseObject(JSON.toJSONString(sheet.get("config")));


@@ -711,22 +1109,86 @@


    }




    @Override


    public int submitPlan(Integer orderId, String laboratory) {


    public int submitPlan(Integer orderId, String laboratory, Integer verifyUser) {


        List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId));


        List<Integer> ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList());


        List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).eq(InsProduct::getState, 1).isNull(InsProduct::getInsResult));


        List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getSonLaboratory, laboratory).eq(InsProduct::getState, 1).isNull(InsProduct::getInsResult).isNull(InsProduct::getInsFiberId).isNull(InsProduct::getInsFibersId));


        insProducts.addAll(insProductMapper.selectFiberInsProduct(ids, laboratory));


        if (insProducts.size() > 0) {


            String str = "";


            int count = 0;


            for (InsProduct product : insProducts) {


                str += product.getInspectionItem() + " " + product.getInspectionItemSubclass() + "；";


                count++;


                str += "<br/>" + count + "：" + product.getInspectionItem() + " " + product.getInspectionItemSubclass() + "<br/>";


            }


            throw new ErrorException("以下是未检验的项目：" + str);


            throw new ErrorException("<strong>存在待检验的项目：</strong><br/>" + str);


        }


        insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, orderId).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, LocalDateTime.now()).set(InsOrderState::getInsState, 3));


        insOrderStateMapper.update(null, Wrappers.<InsOrderState>lambdaUpdate().eq(InsOrderState::getInsOrderId, orderId).eq(InsOrderState::getLaboratory, laboratory).set(InsOrderState::getInsTime, LocalDateTime.now()).set(InsOrderState::getInsState, 3).set(InsOrderState::getVerifyUser, verifyUser));


        Integer userId = getLook.selectPowerByMethodAndUserId(null).get("userId");


        InformationNotification info = new InformationNotification();


        info.setCreateUser(insProductMapper.selectUserById(userId).get("name"));


        info.setMessageType("2");


        info.setTheme("复核通知");


        info.setContent("您有一条检验任务待复核消息");


        info.setSenderId(userId);


        info.setConsigneeId(verifyUser);


        info.setViewStatus(false);


        info.setJumpPath("b1-inspect-order-plan");


        informationNotificationService.addInformationNotification(info);


        upPlanUser(verifyUser, orderId);


        return 1;


    }




    public int pxToCm(int px) {


        return px / 9;


    }




    // 获取两个localDateTime的每一天


    public static List<LocalDateTime> getLocalDateTimesBetween(LocalDateTime start, LocalDateTime end) {


        List<LocalDateTime> localDateTimes = new ArrayList<>();


        LocalDate currentDate = start.toLocalDate();


        LocalDateTime currentLocalDateTime = start;


        while (!currentDate.isAfter(end.toLocalDate())) {


            localDateTimes.add(currentLocalDateTime);


            currentLocalDateTime = currentLocalDateTime.plusDays(1);


            currentDate = currentDate.plusDays(1);


        }


        return localDateTimes;


    }




    public static String getWeek(String dayStr) {


        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


        try {


            Date date = sdf.parse(dayStr);


            Calendar calendar = Calendar.getInstance();


            calendar.setTime(date);


            int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);


            int day = calendar.get(Calendar.DAY_OF_MONTH);


            return day + " " + getWeekDay(dayOfWeek);


        } catch (Exception e) {


            e.printStackTrace();


        }


        return null;


    }




    public static String getWeekDay(int dayOfWeek) {


        switch (dayOfWeek) {


            case Calendar.MONDAY:


                return "周一";


            case Calendar.TUESDAY:


                return "周二";


            case Calendar.WEDNESDAY:


                return "周三";


            case Calendar.THURSDAY:


                return "周四";


            case Calendar.FRIDAY:


                return "周五";


            case Calendar.SATURDAY:


                return "周六";


            case Calendar.SUNDAY:


                return "周日";


            default:


                return "未知";


        }


    }


}