通信LIMS后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
Crunchy
2024-04-25 cfdaaae8690e188f6971057259873aa408ebc9e3 
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java


@@ -13,8 +13,12 @@


import com.deepoove.poi.XWPFTemplate;


import com.deepoove.poi.config.Configure;


import com.deepoove.poi.config.ConfigureBuilder;


import com.deepoove.poi.data.*;


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


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


import com.yuanchu.mom.common.GetLook;


import com.yuanchu.mom.common.PrintChina;


import com.yuanchu.mom.dto.ExcelDto;


import com.yuanchu.mom.dto.InsOrderPlanDTO;


import com.yuanchu.mom.dto.SampleProductDto;


import com.yuanchu.mom.mapper.*;


@@ -24,21 +28,25 @@


import com.yuanchu.mom.service.InsOrderService;


import com.yuanchu.mom.service.StandardTemplateService;


import com.yuanchu.mom.utils.GiveCode;


import com.yuanchu.mom.utils.JackSonUtil;


import com.yuanchu.mom.utils.MatrixToImageWriter;


import com.yuanchu.mom.utils.QueryWrappers;


import com.yuanchu.mom.vo.InsOrderPlanVO;


import lombok.AllArgsConstructor;


import org.apache.commons.io.IOUtils;


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


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


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


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.util.ResourceUtils;




import javax.annotation.Resource;


import java.io.FileNotFoundException;


import java.io.FileOutputStream;


import java.io.IOException;


import java.io.*;


import java.nio.file.Files;


import java.nio.file.Paths;


import java.time.LocalDateTime;


import java.time.format.DateTimeFormatter;


import java.util.*;


import java.util.concurrent.atomic.AtomicReference;


import java.util.stream.Collectors;


import java.util.concurrent.CompletableFuture;


import java.util.concurrent.atomic.AtomicInteger;


@@ -70,15 +78,20 @@


    @Value("${wordUrl}")


    private String wordUrl;




    @Value("${twoCode}")


    private String twoCode;




    @Resource


    private GiveCode giveCode;




    @Resource


    private InsReportMapper insReportMapper;




    @Resource


    private InsProductResultMapper insProductResultMapper;




    private InsProductMapper insProductMapper;


    @Resource


    private InsProductUserMapper insProductUserMapper;




    @Override


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


@@ -109,63 +122,19 @@


    public Map<String, Object> doInsOrder(Integer id, String laboratory) {


        InsOrder insOrder = new InsOrder();


        insOrder.setId(id);


        insOrder.setInsState(1);


        InsOrder order = insOrderMapper.selectById(id);


        if (BeanUtil.isEmpty(order.getInsTime())) {


            insOrder.setInsTime(LocalDateTime.now());


            insOrderMapper.updateById(insOrder);


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


        }


        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) {


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


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


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


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


                    continue;


                }


                if (set.add(product.getTemplateId())) {


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


                }


                String 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")));


                    List<JSONObject> cellData = JSON.parseArray(JSON.toJSONString(sheet.get("celldata")), JSONObject.class);


                    List<JSONObject> tableData = new ArrayList<>();


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


//                    style.put("borderInfo", config.get("borderInfo"));


                    style.put("rowlen", config.get("rowlen"));


                    style.put("columnlen", config.get("columnlen"));


                    int r = -1;


                    if (BeanUtil.isNotEmpty(cellData)) {


                        for (JSONObject o : cellData) {


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


                            if (BeanUtil.isNotEmpty(v.get("ps"))) {


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


                                if (ps.get("value").equals("检验项") && v.get("v").equals(product.getInspectionItem())) {


                                    tableData.add(o);


                                    r = Integer.parseInt(o.get("r") + "");


                                    continue;


                                }


                            }


                            if (tableData.size() > 0) {


                                if ((Integer.parseInt(o.get("r") + "") == r + 1 || Integer.parseInt(o.get("r") + "") == r) && !(o.get("v") + "").equals("{\"ht\":\"0\"}")) {


                                    r = Integer.parseInt(o.get("r") + "");


                                    tableData.add(o);


                                } else {


                                    break;


                                }


                            }


                        }


                    }


                    product.setTemplate(tableData);


                    product.setStyle(style);


                }


            }


            getTemplateThing(set, map2, samples);


        }


        map.put("sampleProduct", list);


        return map;


@@ -176,7 +145,6 @@


    public void saveInsContext(Map<String, Object> insContext) {


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


        CompletableFuture.supplyAsync(() -> {


            AtomicInteger count = new AtomicInteger();


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


                JSONObject jo = JSON.parseObject(JSON.toJSONString(v));


                InsProduct insProduct = new InsProduct();


@@ -186,39 +154,68 @@


                    result = new InsProductResult();


                }


                result.setInsProductId(Integer.parseInt(k));


                JSONArray jsonArray = JSON.parseArray(JSON.toJSONString(jo.get("insValue")));


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


                for (Object o : jsonArray) {


                    JSONObject insValue = JSON.parseObject(JSON.toJSONString(o));


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


                    map.put("v", JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v"));


                    if (insValue.get("u") == null && StrUtil.isNotEmpty(JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v").toString())) {


                        map.put("u", userId);


                    }else {


                        map.put("u", insValue.get("u"));


                if (jo.get("insValue") != null) {


                    JSONArray jsonArray = JSON.parseArray(JSON.toJSONString(jo.get("insValue")));


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


                    for (Object o : jsonArray) {


                        JSONObject insValue = JSON.parseObject(JSON.toJSONString(o));


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


                        map.put("v", JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v"));


                        try {


                            if ((insValue.get("u") == null || insValue.get("u").equals("")) && StrUtil.isNotEmpty(JSON.parseObject(JSON.toJSONString(insValue.get("v"))).get("v").toString())) {


                                map.put("u", userId + "");


                            } else {


                                map.put("u", insValue.get("u"));


                            }


                            iv.add(map);


                        } catch (Exception e) {


                        }


                    }


                    iv.add(map);


                    result.setInsValue(JSON.toJSONString(iv));


                }


                result.setInsValue(JSON.toJSONString(iv));


                JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("comValue")));


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


                for (Object o : jsonArray2) {


                    JSONObject comValue = JSON.parseObject(JSON.toJSONString(o));


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


                    map.put("v", JSON.parseObject(JSON.toJSONString(comValue.get("v"))).get("v"));


                    cv.add(map);


                if (jo.get("comValue") != null) {


                    JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("comValue")));


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


                    for (Object o : jsonArray2) {


                        JSONObject comValue = JSON.parseObject(JSON.toJSONString(o));


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


                        map.put("v", JSON.parseObject(JSON.toJSONString(comValue.get("v"))).get("v"));


                        cv.add(map);


                    }


                    result.setComValue(JSON.toJSONString(cv));


                }


                result.setComValue(JSON.toJSONString(cv));


                JSONObject resValue = JSON.parseObject(JSON.toJSONString(jo.get("resValue")));


                insProduct.setLastValue(JSON.parseObject(JSON.toJSONString(resValue.get("v"))).get("v") + "");


                JSONObject equipValue = JSON.parseObject(JSON.toJSONString(jo.get("equipValue")));


                try {


                    result.setEquipValue(JSON.parseObject(JSON.toJSONString(equipValue.get("v"))).get("v") + "");


                }catch (Exception ignored){


                    result.setEquipValue(null);


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


                    insProduct.setLastValue(JSON.parseObject(JSON.toJSONString(resValue.get("v"))).get("v") + "");


                }


                JSONObject insResult = JSON.parseObject(JSON.toJSONString(jo.get("insResult")));


                insProduct.setInsResult(Integer.parseInt(JSON.parseObject(JSON.toJSONString(insResult.get("v"))).get("v") + ""));


                if (jo.get("equipValue") != null) {


                    JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("equipValue")));


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


                    for (Object o : jsonArray2) {


                        JSONObject equipValue = JSON.parseObject(JSON.toJSONString(o));


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


                        map.put("v", JSON.parseObject(JSON.toJSONString(equipValue.get("v"))).get("v"));


                        ev.add(map);


                    }


                    result.setEquipValue(JSON.toJSONString(ev));


                }


                if (jo.get("equipName") != null) {


                    JSONArray jsonArray2 = JSON.parseArray(JSON.toJSONString(jo.get("equipName")));


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


                    for (Object o : jsonArray2) {


                        JSONObject equipValue = JSON.parseObject(JSON.toJSONString(o));


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


                        map.put("v", JSON.parseObject(JSON.toJSONString(equipValue.get("v"))).get("v"));


                        ev.add(map);


                    }


                    result.setEquipName(JSON.toJSONString(ev));


                }


                try {


                    JSONObject insResult = JSON.parseObject(JSON.toJSONString(jo.get("insResult")));


                    String ir = JSON.parseObject(JSON.toJSONString(insResult.get("v"))).get("v") + "";


                    insProduct.setInsResult(Integer.parseInt(ir));


                } catch (Exception e) {


                }


                if (BeanUtil.isEmpty(result.getId())) {


                    result.setCreateUser(userId);


                    result.setUpdateUser(userId);


@@ -230,11 +227,17 @@


                }


                insProduct.setUpdateUser(userId);


                insProductMapper.updateById(insProduct);


                if(count.get() == 0){


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


                    insSample.setInsState(1);


                    count.addAndGet(1);


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


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


                insSample.setInsState(1);


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


                        .eq(InsProduct::getInsSampleId, insSample.getId()));


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


                        .eq(InsProduct::getInsSampleId, insSample.getId()).isNotNull(InsProduct::getInsResult));


                if (l == l1) {


                    insSample.setInsState(2);


                }


                insSampleMapper.updateById(insSample);


            });


            return null;


        }).thenAccept(res -> {


@@ -257,36 +260,324 @@


    @Transactional(rollbackFor = Exception.class)


    public int verifyPlan(Integer orderId, String laboratory, Integer type, String tell) {


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


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


        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) {


            InsOrder insOrder = insOrderMapper.selectById(orderId);


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


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


            samples.forEach(System.out::println);


            InsReport insReport = new InsReport();


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


            insReport.setInsOrderId(orderId);


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


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


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


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


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


            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"};


            samples.forEach(a -> {


                models.add(a.getModel());


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


                getTemplateThing(set, map2, a);


                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) {


                            if (!"".equals(jsonObject.get("v") + "")) {


                                deviceSet.add(jsonObject.get("v") + "");


                            }


                        }


                    }


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


                        continue;


                    }


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


                }


                AtomicInteger index = new AtomicInteger();


                templateSet.forEach(tem -> {


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


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


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


                    RowRenderData rowRenderData;


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


                    List<ExcelDto> excelDtos = JSON.parseArray(tem, ExcelDto.class);


                    List<ExcelDto> mcList = new ArrayList<>();


                    excelDtos.forEach(b -> {


                        if (b.getV().getMc() != null && b.getV().getMc().getCs() != null && b.getV().getMc().getRs() != null) {


                            mcList.add(b);


                        }


                    });


                    int count5 = 0;


                    for (ExcelDto b : mcList) {


                        for (ExcelDto excelDto : excelDtos) {


                            for (int i = 0; i < b.getV().getMc().getCs(); i++) {


                                for (int i2 = 0; i2 < b.getV().getMc().getRs(); i2++) {


                                    if (excelDto.getC() == b.getC() + i && excelDto.getR() == b.getR() + i2) {


                                        ExcelDto bb = JSON.parseObject(JSON.toJSONString(b), ExcelDto.class);


                                        excelDto.getV().setV(bb.getV().getV());


                                        excelDto.getV().setPs(bb.getV().getPs());


                                        excelDto.getV().setFc(bb.getV().getFc());


                                        excelDto.getV().setFs(bb.getV().getFs());


                                        excelDto.getV().setHt(bb.getV().getHt());


                                        excelDto.setMc(count5);


                                        break;


                                    }


                                }


                            }


                        }


                        count5++;


                    }


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


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


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


                    for (JSONObject jo1 : temp) {


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


                        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") + "")) {


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


                                continue;


                            }


                            for (JSONObject jo2 : temp) {


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


                                if (jo1.get("r").equals(jo2.get("r"))) {


                                    if (v2.get("ps") != null && JSON.parseObject(JSON.toJSONString(v2.get("ps"))).get("value").equals("检验项")) {


                                        if (count3 == 0) {


                                            str += v2.get("v");


                                            count3 += 1;


                                        }


                                    } else if (v2.get("ps") != null && JSON.parseObject(JSON.toJSONString(v2.get("ps"))).get("value").equals("检验子项")) {


                                        if (count3 == 1) {


                                            str += v2.get("v");


                                            count3 += 1;


                                        }


                                    }


                                }


                            }


                            if (!str.equals("")) {


                                int count2 = 0;


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


                                    if ((product.getInspectionItem() + product.getInspectionItemSubclass()).equals(str)) {


                                        pMap.put(jo1.get("r") + "", product);


                                        break;


                                    } else {


                                        count2++;


                                    }


                                }


                                if (count2 == a.getInsProduct().size()) {


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


                                }


                            }


                        } else {


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


                        }


                    }


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


                        JSONObject jo1 = temp.get(i);


                        TextRenderData textRenderData = new TextRenderData();


                        if (set2.add(Integer.parseInt(jo1.get("r") + ""))) {


                            if (text.size() > 0) {


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


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


                                rows.add(rowRenderData);


                                text = new ArrayList<>();


                            }


                        }


                        if (delRSet.stream().anyMatch(e -> e.equals(jo1.get("r") + ""))) {


                            continue;


                        }


                        if (delSet.stream().anyMatch(e -> e.equals(jo1.get("c") + ""))) {


                            continue;


                        }


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


                        InsProduct p = pMap.get(jo1.get("r") + "");


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


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


                            if (value.equals("要求值")) {


                                textRenderData.setText(p.getAsk());


                            } else if (value.equals("单位")) {


                                textRenderData.setText(p.getUnit());


                            } else if (value.equals("结论")) {


                                switch (p.getInsResult()) {


                                    case 1:


                                        textRenderData.setText("√");


                                        break;


                                    case 0:


                                        textRenderData.setText("×");


                                        break;


                                    default:


                                        textRenderData.setText("-");


                                        break;


                                }


                            } else if (value.equals("序号")) {


                                index.getAndIncrement();


                                textRenderData.setText(index + "");


                            } else if (value.equals("计算值")) {


                                JSONArray jsonArray = JSON.parseArray(p.getInsProductResult().getComValue());


                                textRenderData.setText((JSON.parseObject(JSON.toJSONString(jsonArray.get(0))).get("v") + "").equals("") ? "/" : JSON.parseObject(JSON.toJSONString(jsonArray.get(0))).get("v") + "");


                            } else if (value.equals("最终值")) {


                                textRenderData.setText(p.getLastValue());


                            } else if (value.equals("样品编号")) {


                                textRenderData.setText(a.getSampleCode());


                            } else if (value.equals("样品型号")) {


                                textRenderData.setText(a.getModel());


                            } else if (value.equals("样品名称")) {


                                textRenderData.setText(a.getSample());


                            } else if (value.equals("试验方法")) {


                                textRenderData.setText(p.getMethodS());


                            } else {


                                textRenderData.setText(v.get("v") == null ? "" : v.get("v") + "");


                            }


                        } else if (p == null && v.get("ps") != null) {


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


                            p = pMap.get(pMap.keySet().iterator().next());


                            if (value.equals("最终值")) {


                                textRenderData.setText(p.getLastValue());


                            } else if (value.equals("结论")) {


                                switch (p.getInsResult()) {


                                    case 1:


                                        textRenderData.setText("✔");


                                        break;


                                    case 0:


                                        textRenderData.setText("✖");


                                        break;


                                    default:


                                        textRenderData.setText("-");


                                        break;


                                }


                            } else if (value.equals("样品编号")) {


                                textRenderData.setText(a.getSampleCode());


                            } else if (value.equals("样品型号")) {


                                textRenderData.setText(a.getModel());


                            } else if (value.equals("样品名称")) {


                                textRenderData.setText(a.getSample());


                            } else {


                                textRenderData.setText(v.get("v") == null ? "" : v.get("v") + "");


                            }


                        } else {


                            textRenderData.setText(v.get("v") == null ? "" : v.get("v") + "");


                        }


                        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")+""));


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


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


                        } else {


                            style.setColor("000000");


                        }


                        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<>();


                        }


                    }


                    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));


                        }


                    }*/


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


                    tableStyle.setAlign(TableRowAlign.CENTER);


                    tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);


                    tableRenderData.setTableStyle(tableStyle);


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


                    table.put("table", tableRenderData);


                    table.put("report", insReport);


                    tables.add(table);


                });


            });


            String url;


            try {


                url = ResourceUtils.getURL("classpath:static/report-template.docx").getPath();


                InputStream inputStream = this.getClass().getResourceAsStream("/static/report-template.docx");


                File file = File.createTempFile("temp", ".tmp");


                OutputStream outputStream = new FileOutputStream(file);


                IOUtils.copy(inputStream, outputStream);


                url = file.getAbsolutePath();


            } catch (FileNotFoundException e) {


                throw new ErrorException("找不到模板文件");


            } catch (IOException e) {


                throw new RuntimeException(e);


            }


            XWPFTemplate template = XWPFTemplate.compile(url).render(


            StringBuilder standardMethod2 = new StringBuilder();


            for (String s : standardMethod) {


                standardMethod2.append("、").append(s);


            }


            standardMethod2.replace(0, 1, "");


            tables.forEach(table -> {


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


            });


//            List<Map<String, String>> deviceList = insOrderMapper.selectDeviceList(deviceSet);


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


            Map<String, String> codeStr = new HashMap<>();


            codeStr.put("报告编号", insReport.getCode());


            codeStr.put("样品名称", insOrder.getSample());


            codeStr.put("规格型号", samples.get(0).getModel());


            codeStr.put("发放日期", now.format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));


            String codePath;


            try {


                codePath = new MatrixToImageWriter().code(JackSonUtil.marshal(codeStr).replaceAll("\\{", "")


                        .replaceAll("}", "").replaceAll(",", "").replaceAll("\"", ""), twoCode);


            } catch (Exception e) {


                throw new RuntimeException(e);


            }


            String modelStr = "";


            for (String model : models) {


                modelStr += "," + model;


            }


            String finalModelStr = modelStr;


            ConfigureBuilder builder = Configure.builder();


            builder.useSpringEL(true);


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


                    new HashMap<String, Object>() {{


                        put("order", insOrder);


                        put("report", insReport);


                        put("user", user);


                        put("samples", samples);


//                        put("samples", samples);


                        put("sampleSize", samples.size() + samples.get(0).getUnit());


                        put("tables", tables);


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


                        put("standardMethod", standardMethod2);


                        put("deviceList", deviceList);


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


                        put("models", finalModelStr.replace(",", ""));


                        put("productSize", productSize);


                        put("createTime", now.format(DateTimeFormatter.ofPattern("yyyy年MM月dd日")));


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


                        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("examineUrl", null);


                        put("ratifyUrl", null);


                    }});


            try {


                String name = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yy_MM_dd_HH_mm_ss")) + ".docx";


                template.writeAndClose(new FileOutputStream(wordUrl + "/" + name));


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


                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) {


                throw new RuntimeException(e);


            }


@@ -294,15 +585,46 @@


        return 1;


    }




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


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


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


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


                continue;


            }


            if (set.add(product.getTemplateId())) {


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


            }


            String 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")));


                List<JSONObject> cellData = JSON.parseArray(JSON.toJSONString(sheet.get("celldata")), JSONObject.class);


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


                style.put("rowlen", config.get("rowlen"));


                style.put("columnlen", config.get("columnlen"));


                product.setTemplate(cellData);


                product.setStyle(style);


            }


        }


    }




    @Override


    public int submitPlan(Integer orderId, String laboratory) {


        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).isNotNull(InsProduct::getInsResult));


        if (insProducts.size() == 0) {


            return 0;


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


        if (insProducts.size() > 0) {


            String str = "";


            for (InsProduct product : insProducts) {


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


            }


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


        }


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


        return 1;


    }




    public int pxToCm(int px) {


        return px / 9;


    }


}