From 7d5f9679128b3084c502b2bf6b076453a439cefc Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期二, 25 三月 2025 10:07:01 +0800
Subject: [PATCH] 检验任务时间筛选

---
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderPlanServiceImpl.java |   17 +++++++++++++++--
 1 files changed, 15 insertions(+), 2 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 22d82a0..37fe4d5 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")){
@@ -1204,6 +1211,9 @@
                     /*鐢熸垚瀵瑰簲鐨勬楠屾姤鍛�*/
                     List<InsReportDto1> insReportDto1s=insOrderUserMapper.selectInsReportDto1(insOrder.getId());
                     createReport(insOrder.getId(),insReportDto1s);
+                    //璇ヨ鍗曢棴鐜�
+                    insOrder.setState(4);
+                    insOrderMapper.updateById(insOrder);
                     break;
             }
         }
@@ -1291,6 +1301,9 @@
                     /*鐢熸垚瀵瑰簲鐨勬楠屾姤鍛�*/
                     List<InsReportDto1> insReportDto1s=insOrderUserMapper.selectInsReportDto1(insOrder.getId());
                     createReport(insOrder.getId(),insReportDto1s);
+                    //璁㈠崟闂幆
+                    insOrder.setState(4);
+                    insOrderMapper.updateById(insOrder);
                     break;
             }
         }

--
Gitblit v1.9.3