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


@@ -14,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;


@@ -33,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;


@@ -46,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;




/**


 * 检验任务-业务实现层


@@ -187,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==null?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<>();


@@ -241,8 +243,26 @@


                }


                insSampleMapper.updateById(insSample);


            });


            return null;


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


        }).thenAccept(res -> {


            if (res != null) {


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


                InsProduct insProduct = insProductMapper.selectById(pId);


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


                int sampleId = insProductMapper.selectById(pId).getInsSampleId();


                // 通过样本id获取订单id


                int orderId = insSampleMapper.selectById(sampleId).getInsOrderId();


                // 通过订单id查找所有样本id


                List<Integer> sampleIds = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId)).stream().map(InsSample::getId).collect(Collectors.toList());


                // 通过检查每一个样本id查到属于检验项结论 is null的数量


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


                if (count == 0) {


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


                            .eq(InsOrderState::getInsOrderId, orderId)


                            .eq(InsOrderState::getLaboratory, insProduct.getSonLaboratory())


                            .set(InsOrderState::getInsState, 2));


                }


            }


        }).exceptionally(e -> {


            e.printStackTrace();


            return null;


@@ -271,7 +291,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<>();


@@ -466,6 +487,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")+""));


@@ -501,6 +525,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);


@@ -528,7 +560,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());


@@ -546,19 +581,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);


@@ -570,6 +607,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";


@@ -579,6 +620,65 @@


//                insOrder.setState(4);


                insOrder.setInsState(5);


                insOrderMapper.updateById(insOrder);


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


            }


@@ -618,7 +718,7 @@


        if (insProducts.size() > 0) {


            String str = "";


            for (InsProduct product : insProducts) {


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


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


            }


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


        }