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


@@ -13,6 +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.deepoove.poi.render.Render;


import com.deepoove.poi.xwpf.XWPFHighlightColor;


import com.spire.doc.Table;


import com.yuanchu.mom.common.GetLook;


import com.yuanchu.mom.common.PrintChina;


import com.yuanchu.mom.dto.InsOrderPlanDTO;


@@ -27,6 +33,11 @@


import com.yuanchu.mom.utils.QueryWrappers;


import com.yuanchu.mom.vo.InsOrderPlanVO;


import lombok.AllArgsConstructor;


import org.apache.commons.lang3.ArrayUtils;


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


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


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


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


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


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


@@ -36,6 +47,8 @@


import java.io.FileNotFoundException;


import java.io.FileOutputStream;


import java.io.IOException;


import java.nio.file.Files;


import java.nio.file.Paths;


import java.time.LocalDateTime;


import java.time.format.DateTimeFormatter;


import java.util.*;


@@ -76,9 +89,8 @@


    @Resource


    private InsReportMapper insReportMapper;




    @Resource


    private InsProductResultMapper insProductResultMapper;




    private InsProductMapper insProductMapper;




    @Override


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


@@ -122,50 +134,7 @@


        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;


@@ -192,9 +161,9 @@


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


                    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 {


                    } else {


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


                    }


                    iv.add(map);


@@ -214,7 +183,7 @@


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


                try {


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


                }catch (Exception ignored){


                } catch (Exception ignored) {


                    result.setEquipValue(null);


                }


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


@@ -230,7 +199,7 @@


                }


                insProduct.setUpdateUser(userId);


                insProductMapper.updateById(insProduct);


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


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


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


                    insSample.setInsState(1);


                    count.addAndGet(1);


@@ -264,16 +233,99 @@


            InsOrder insOrder = insOrderMapper.selectById(orderId);


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


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


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


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


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


            List<TableRenderData> tables = new ArrayList<>();


            samples.forEach(a -> {


                getTemplateThing(set, map2, a);


                a.getInsProduct().forEach(b -> {


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


                        return;


                    }


//                    System.out.println(b.getTemplate());


//                    System.out.println(b.getStyle());


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


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


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


                    RowRenderData rowRenderData;


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


                    for (JSONObject jo1 : b.getTemplate()) {


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


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


//                            System.out.println(v);


                            if("检验值".equals(JSON.parseObject(JSON.toJSONString(v.get("ps"))).get("value")+"")){


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


                            }


                        }


                    }


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


                        JSONObject jo1 = b.getTemplate().get(i);


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


                            continue;


                        }


                        TextRenderData textRenderData = new TextRenderData();


                        if (set2.add(Integer.parseInt(jo1.get("r") + "")) || i == b.getTemplate().size()-1) {


                            if(text.size() > 0){


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


                                rowRenderData = Rows.of(text2).create();


                                rows.add(rowRenderData);


                                text = new ArrayList<>();


                            }


                        }


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


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


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


                        /*String align;


                        switch (v.get("ht")+""){


                            case "0":


                                align = "center";


                                break;


                            case "2":


                                align = "right";


                                break;


                            default:


                                align = "left";


                                break;


                        }*/


                        textRenderData.setStyle(style);


                        text.add(textRenderData);


                    }


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


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


                    tables.add(tableRenderData);


                });


            });


            InsReport insReport = new InsReport();


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


            insReport.setInsOrderId(orderId);


            String url;


            try {


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


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


            } catch (FileNotFoundException e) {


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


            }




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


                    new HashMap<String, Object>() {{


                        put("order", insOrder);


@@ -281,17 +333,64 @@


                        put("user", user);


                        put("samples", samples);


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


                        put("tables", tables.get(0));


                    }});


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


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


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


                insReportMapper.insert(insReport);


            } catch (IOException e) {


                throw new RuntimeException(e);


            }


        }


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


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


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


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


            }


        }


    }




    @Override


@@ -305,4 +404,8 @@


        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;


    }


}