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