From 08f1b1f1804a8bd833d42f257908d80e88387b55 Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期五, 14 三月 2025 11:27:47 +0800 Subject: [PATCH] 3.5增加登录验证、修改密码、人员列表调整 --- flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java | 22 +++++++++++++--------- 1 files changed, 13 insertions(+), 9 deletions(-) diff --git a/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java b/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java index f26d570..d235426 100644 --- a/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java +++ b/flower_city/src/main/java/com/dg/core/service/impl/TransactionEventImpl.java @@ -161,8 +161,8 @@ } queryResults.setTransactionEventList(searchesAssociate); queryResults.setKeywordEntityList(keywordMapper.selectByName(keyWord)); - queryResults.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null)); - queryResults.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null)); + queryResults.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null,null)); + queryResults.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null,null)); return queryResults; } @@ -196,8 +196,8 @@ } recommendResult.setKeywordEntityList(keywordEntityList); List<OrganizationChartEntity> organizationChartEntities = organizationChartMapper.selectByKeyWord(keyWord); - recommendResult.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null)); - recommendResult.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null)); + recommendResult.setAutomessagePolicyDocuments(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"2",null,null)); + recommendResult.setRegulations(automessagePolicyDocumentsMapper.selectConfigList(keyWord,"1",null,null)); recommendResult.setOrganizationChartEntityList(organizationChartEntities); return recommendResult; } @@ -300,10 +300,14 @@ // 获取excel的sheet页数 int numberOfSheets = wb.getNumberOfSheets(); for (int j = 0; j < numberOfSheets; j++) { + int i = 2; //获取excel字段名称进行比较 Sheet sheetAt = wb.getSheetAt(j); if(sheetAt.getRow(2)!=null){ - Row row1 = sheetAt.getRow(2); + if (new DataFormatter().formatCellValue(sheetAt.getRow(1).getCell(1)).length()>=3){ + i--; + } + Row row1 = sheetAt.getRow(i); TransactionEvent transactionEvent = baseMapper.selectOne(new QueryWrapper<TransactionEvent>().lambda().eq(TransactionEvent::getMatterName, new DataFormatter().formatCellValue(row1.getCell(1)))); boolean isAdd = false; if (transactionEvent == null) { @@ -311,15 +315,15 @@ isAdd = true; } transactionEvent.setMatterName(new DataFormatter().formatCellValue(row1.getCell(1))); - Row row2 = sheetAt.getRow(3); + Row row2 = sheetAt.getRow(i+1); transactionEvent.setSetGist("<p>" + new DataFormatter().formatCellValue(row2.getCell(1)) + "</p>"); - Row row3 = sheetAt.getRow(4); - Row row4 = sheetAt.getRow(5); + Row row3 = sheetAt.getRow(i+2); + Row row4 = sheetAt.getRow(i+3); transactionEvent.setBasicInformation("<p> 事项名称:" + new DataFormatter().formatCellValue(row1.getCell(1)) + "<br />" + new DataFormatter().formatCellValue(row3.getCell(0)) + ":" + new DataFormatter().formatCellValue(row3.getCell(1))+ "<br />" + new DataFormatter().formatCellValue(row3.getCell(3)) + ":" + new DataFormatter().formatCellValue(row3.getCell(4)) + "<br />" + new DataFormatter().formatCellValue(row4.getCell(0)) + ":" + new DataFormatter().formatCellValue(row4.getCell(1)) + "</p>"); - int i = 7; + i = i+5; String applicationMaterial = "<p>"; while (true) { Row row = sheetAt.getRow(i); -- Gitblit v1.7.1