From 9f1c4e5ef6f82e111400fe2f292453583aa2155e Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期二, 25 三月 2025 12:12:47 +0800
Subject: [PATCH] 报告分页查询新增委托编号和样品编号

---
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java |   16 ++++++++++++----
 1 files changed, 12 insertions(+), 4 deletions(-)

diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java
index 5497fbe..87074d2 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java
@@ -366,7 +366,7 @@
                 return pathName;
             }
             // 闇囧姩doc鏂囦欢瑙f瀽
-            if(filename.contains(".doc") && sonLaboratory.equals("鎸姩")){
+            if(filename.toLowerCase().contains(".doc") && sonLaboratory.equals("鎸姩")){
                 return docAnalysis(urlString,orderId,sampleId,file.getOriginalFilename());
             }
         } catch (Exception e) {
@@ -425,6 +425,7 @@
             if (orderState.getInsState() == 6) {
                 orderState.setInsState(0);
                 orderState.setNum(orderState.getNum() + 1);//閫掑
+                orderState.setCreateTime(LocalDateTime.now());
                 insOrderStateMapper.updateById(orderState);
             }
         } else {
@@ -940,6 +941,9 @@
                 if(tableIndex == 0){
                     Table table = tableList.get(0);
                     for (int i = 0; i < table.numRows(); i++) {
+                        if(table.getRow(i).numCells() < 2){
+                            continue;
+                        }
                         String columnText = ObjectUtils.isEmpty(table.getRow(i).getCell(0))? "" : table.getRow(i).getCell(0).text();
                         String columnValue = ObjectUtils.isEmpty(table.getRow(i).getCell(1))? "" : table.getRow(i).getCell(1).text();
                         if(columnValue.contains("\u0007")){
@@ -962,7 +966,7 @@
                 //鍙栫涓�涓〃鍗曡緭鍏ラ�氶亾鍙傛暟绗竴鏉℃暟鎹�
                 if(tableIndex == 1){
                     Table table = tableList.get(1);
-                    if(ObjectUtils.isNotEmpty(table)&& table.numRows() > 0){
+                    if(ObjectUtils.isNotEmpty(table) && table.numRows() > 1 && table.getRow(1).numCells() >= 3){
                         String columnValue = ObjectUtils.isEmpty(table.getRow(1).getCell(2))? "" : table.getRow(1).getCell(2).text();
                         if(columnValue.contains("\u0007")){
                             columnValue = columnValue.replace("\u0007","");
@@ -974,6 +978,9 @@
                 if(tableIndex == tableList.size() - 1){
                     Table table = tableList.get(tableIndex);
                     for (int i = 0; i < table.numRows(); i++) {
+                        if(table.getRow(i).numCells() < 2){
+                            continue;
+                        }
                         String columnText = ObjectUtils.isEmpty(table.getRow(i).getCell(0))? "" : table.getRow(i).getCell(0).text();
                         String columnValue = ObjectUtils.isEmpty(table.getRow(i).getCell(1))? "" : table.getRow(i).getCell(1).text();
                         if(columnValue.contains("\u0007")){
@@ -1192,8 +1199,9 @@
                             .set(InsOrderState::getInsState, 5)
                             .set(InsOrderState::getVerifyTell, tell)
                             .set(InsOrderState::getVerifyUser, userId));
-                    //濡傛灉璁㈠崟绫诲瀷鏄師鐞嗘牱鏈�,鍒欒璁㈠崟鐩存帴闂幆
-                    List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, insSample.getInsOrderId()));
+                    //缁撴潫涔嬪悗灏嗚璁㈠崟鐨勬墍鏈夋牱鍝佸叏閮ㄥ嚭搴�
+                    List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery()
+                            .eq(InsSample::getInsOrderId, insSample.getInsOrderId()));
                     for (InsSample sample : insSamples) {
                         try{
                             outInsOrderState(laboratory, sample.getSampleCode(), insOrder.getEntrustCode());

--
Gitblit v1.9.3