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


@@ -6,7 +6,6 @@


import com.alibaba.fastjson.JSON;


import com.alibaba.fastjson.JSONArray;


import com.alibaba.fastjson.JSONObject;


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;


import com.baomidou.mybatisplus.core.metadata.IPage;


import com.baomidou.mybatisplus.core.toolkit.Wrappers;


import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


@@ -15,16 +14,18 @@


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.util.TableTools;


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.exception.ErrorException;


import com.yuanchu.mom.mapper.*;


import com.yuanchu.mom.pojo.*;


import com.yuanchu.mom.exception.ErrorException;


import com.yuanchu.mom.service.InsOrderPlanService;


import com.yuanchu.mom.service.InsOrderService;


import com.yuanchu.mom.service.StandardTemplateService;


@@ -34,8 +35,7 @@


import com.yuanchu.mom.utils.QueryWrappers;


import com.yuanchu.mom.vo.InsOrderPlanVO;


import org.apache.commons.io.IOUtils;


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


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


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


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


import org.springframework.stereotype.Service;


import org.springframework.transaction.annotation.Transactional;


@@ -47,10 +47,10 @@


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;


import java.util.concurrent.atomic.AtomicReference;


import java.util.stream.Collectors;




/**


 * 检验任务-业务实现层


@@ -188,9 +188,10 @@


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


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


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


                        insProduct.setLastValue(o.equals("")?null:(o + ""));


                        insProduct.setLastValue(o.equals("") ? null : (o.toString()));


                    }


                }catch (Exception e){}


                } catch (Exception e) {


                }


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


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


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


@@ -244,7 +245,7 @@


            });


            return insContext.keySet().stream().findFirst().orElse(null);


        }).thenAccept(res -> {


            if(res!=null){


            if (res != null) {


                int pId = Integer.parseInt(res.replaceAll("\\D+", ""));


                InsProduct insProduct = insProductMapper.selectById(pId);


                // 通过pId 获取当前样本id


@@ -257,10 +258,6 @@


                Long count = insProductMapper.selectCount(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, sampleIds).isNull(InsProduct::getInsResult).eq(InsProduct::getSonLaboratory, insProduct.getSonLaboratory()));


                // is null的数量为0是将订单状态表的状态改为已检验


                List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, sampleIds).isNull(InsProduct::getInsResult).eq(InsProduct::getSonLaboratory, insProduct.getSonLaboratory()));


                insProducts.forEach(insProduct1 -> {


                    System.out.println(insProduct1.getInsResult());


                    System.out.println(insProduct1.getId());


                });


                if (count == 0) {


                    insOrderStateMapper.update(new InsOrderState(), Wrappers.<InsOrderState>lambdaUpdate()


                            .eq(InsOrderState::getInsOrderId, orderId)


@@ -296,7 +293,8 @@


            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(giveCode.giveCode("JCZX/TX-", "ins_report", "-", "yyMMdd"));


            insReport.setCode(insOrder.getEntrustCode());


            insReport.setInsOrderId(orderId);


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


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


@@ -406,7 +404,6 @@


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


                        }


                    }


                    // TODO: 2024/5/5 下列循环缺少word合并单元格的操作


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


                        JSONObject jo1 = temp.get(i);


                        TextRenderData textRenderData = new TextRenderData();


@@ -492,6 +489,9 @@


                        } else {


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


                        }


                        if (jo1.get("mc") != null) {


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


@@ -527,6 +527,14 @@


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


                    tableStyle.setAlign(TableRowAlign.CENTER);


                    tableStyle.setWidth(XWPFTable.DEFAULT_PERCENTAGE_WIDTH);


                    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("table", tableRenderData);


@@ -554,7 +562,10 @@


            tables.forEach(table -> {


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


            });


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


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


            if(deviceSet.size()!=0){


                deviceList = insOrderMapper.selectDeviceList(deviceSet);


            }


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


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


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


@@ -572,19 +583,21 @@


                modelStr += "," + model;


            }


            String finalModelStr = modelStr;


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


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


            ConfigureBuilder builder = Configure.builder();


            builder.useSpringEL(true);


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


            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("sampleSize", samples.size() + samples.get(0).getUnit());


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


                        put("tables", tables);


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


                        put("standardMethod", standardMethod2);


                        put("deviceList", deviceList);


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


                        put("deviceList", finalDeviceList);


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


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


                        put("productSize", productSize);


@@ -596,6 +609,10 @@


                        put("insUrl", null);


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


                    }});


            try {


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


@@ -608,6 +625,65 @@


            } catch (IOException e) {


                throw new RuntimeException(e);


            }


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


            try {


                FileInputStream stream = new FileInputStream(path);


                XWPFDocument document = new XWPFDocument(stream);


                List<XWPFTable> xwpfTables = document.getTables();


                for (int i = 1; i < xwpfTables.size() - (deviceList==null?1:2); i++) {


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


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


                    for (int j = 0; j < xwpfTables.get(i).getRows().size(); j++) {


                        for (int k = 0; k < xwpfTables.get(i).getRows().get(j).getTableCells().size(); k++) {


                            if (xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().indexOf("∑") > -1) {


                                String[] split = xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().split("∑");


                                if (set1.add(split[1])) {


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


                                    map.put("sr", j);


                                    map.put("sc", k);


                                    map.put("er", j + 0);


                                    map.put("ec", k + 0);


                                    maps.put(split[1], map);


                                } else {


                                    Map<String, Integer> map1 = maps.get(split[1]);


                                    if (j == map1.get("sr")) {


                                        map1.put("ec", map1.get("ec") + 1);


                                    } else if (k == map1.get("sc")) {


                                        map1.put("er", map1.get("er") + 1);


                                    }


                                }


                                String str = xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getText().split("∑")[0];


                                xwpfTables.get(i).getRows().get(j).getTableCells().get(k).removeParagraph(0);


                                xwpfTables.get(i).getRows().get(j).getTableCells().get(k).setText(str);


                                xwpfTables.get(i).getRows().get(j).getTableCells().get(k).setVerticalAlignment(XWPFTableCell.XWPFVertAlign.CENTER);


                                xwpfTables.get(i).getRows().get(j).getTableCells().get(k).getParagraphArray(0).setAlignment(ParagraphAlignment.CENTER);


                            }


                        }


                    }


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


                    });


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


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


                        list.add(s);


                    }


                    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("er")>v.get("sr")){


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


                        }


                    }


                }


                FileOutputStream fileOutputStream = new FileOutputStream(path);


                document.write(fileOutputStream);


                fileOutputStream.close();


            } catch (FileNotFoundException e) {


                throw new RuntimeException(e);


            } catch (IOException e) {


                throw new RuntimeException(e);


            }


        }


        return 1;


    }