From 19871e8ac9606710b1009f5f86366fb445a7ace8 Mon Sep 17 00:00:00 2001
From: heheng <475597332@qq.com>
Date: Wed, 09 Jul 2025 16:06:20 +0800
Subject: [PATCH] 优化改造sql
---
multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java | 49 ++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 42 insertions(+), 7 deletions(-)
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java
index 27065f4..f41451a 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java
@@ -4,15 +4,13 @@
import com.gkhy.exam.common.api.CommonPage;
import com.gkhy.exam.common.api.CommonResult;
import com.gkhy.exam.common.utils.SecurityUtils;
-import com.gkhy.exam.system.domain.Catalogue;
-import com.gkhy.exam.system.domain.CatalogueData;
-import com.gkhy.exam.system.domain.CatalogueDataFile;
-import com.gkhy.exam.system.domain.SysCompany;
+import com.gkhy.exam.system.domain.*;
import com.gkhy.exam.system.domain.req.CatalogueDataReq;
import com.gkhy.exam.system.domain.req.CatalogueReq;
import com.gkhy.exam.system.domain.vo.CatalogueDataVo;
import com.gkhy.exam.system.domain.vo.CatalogueVo;
import com.gkhy.exam.system.mapper.CatalogueMapper;
+import com.gkhy.exam.system.mapper.CompanyIndustryTemplateMapper;
import com.gkhy.exam.system.mapper.SysCompanyMapper;
import com.gkhy.exam.system.service.CatalogueService;
import com.gkhy.exam.system.service.SysCompanyService;
@@ -32,6 +30,8 @@
private CatalogueMapper catalogueMapper;
@Autowired
private SysCompanyMapper sysCompanyMapper;
+ @Autowired
+ private CompanyIndustryTemplateMapper companyIndustryTemplateMapper;
/**
* 目录管理
@@ -124,12 +124,16 @@
@Override
public CommonResult insertCatalogueData(CatalogueDataReq catalogue) {
- List<CatalogueData> catalogueData1 = catalogueMapper.selectByCompanyId(catalogue.getCompanyId());
+ //校验
+ List<CatalogueData> catalogueData1 = catalogueMapper.selectByCompanyId(catalogue.getCompanyId(),catalogue.getCatalogueId());
if (catalogueData1.size()>0){
return CommonResult.failed("当前企业已有数据，请勿重复添加");
}
CatalogueData catalogueData = new CatalogueData();
BeanUtils.copyProperties(catalogue,catalogueData);
+ catalogueData.setCreateBy(SecurityUtils.getUsername());
+ catalogueData.setCreateTime(LocalDate.now());
+ //新增数据
Integer i = catalogueMapper.insertCatalogueData(catalogueData);
// List<CatalogueDataFile> files = catalogue.getFiles();
if (i>0){
@@ -159,13 +163,23 @@
@Override
public CommonResult deletedCatalogueData(Integer catalogueDataId) {
+ //删除数据所属文件
+ CatalogueData catalogue = catalogueMapper.selectCatalogueDataById(catalogueDataId);
+ CatalogueDataFile catalogueDataFile = new CatalogueDataFile();
+ catalogueDataFile.setCompanyId(catalogue.getCompanyId());
+ catalogueDataFile.setCatalogueId(catalogue.getCatalogueId());
+ catalogueDataFile.setDelFlag(2);
+ catalogueDataFile.setUpdateTime(LocalDate.now());
+ catalogueDataFile.setUpdateBy(SecurityUtils.getUsername());
+ catalogueMapper.updateCatalogueDataFileByCompanyId(catalogueDataFile);
+ //删除数据
CatalogueData catalogueData = new CatalogueData();
catalogueData.setId(catalogueDataId);
catalogueData.setDelFlag(2);
catalogueData.setUpdateBy(SecurityUtils.getUsername());
catalogueData.setUpdateTime(LocalDate.now());
Integer i = catalogueMapper.updateCatalogueData(catalogueData);
- if (i>9){
+ if (i>0){
return CommonResult.success();
}
return CommonResult.failed();
@@ -173,6 +187,11 @@
@Override
public CommonResult insertCatalogueDataFile(CatalogueDataFile catalogueDataFile) {
+ CompanyIndustryTemplate companyIndustryTemplate = companyIndustryTemplateMapper.selectCompanyIndustryTemplate(catalogueDataFile.getName());
+ if (companyIndustryTemplate!=null){
+ catalogueDataFile.setFilePath(companyIndustryTemplate.getFilePath());
+ catalogueDataFile.setFileName(companyIndustryTemplate.getFileName());
+ }
catalogueDataFile.setCreateTime(LocalDate.now());
catalogueDataFile.setCreateBy(SecurityUtils.getUsername());
catalogueMapper.insertCatalogueDataFile(catalogueDataFile);
@@ -181,9 +200,20 @@
@Override
public CommonResult updateCatalogueDataFile(CatalogueDataFile catalogueDataFile) {
+ CompanyIndustryTemplate companyIndustryTemplate = companyIndustryTemplateMapper.selectCompanyIndustryTemplate(catalogueDataFile.getName());
+ if (companyIndustryTemplate!=null){
+ catalogueDataFile.setFilePath(companyIndustryTemplate.getFilePath());
+ catalogueDataFile.setFileName(companyIndustryTemplate.getFileName());
+ }else {
+ catalogueDataFile.setFileName(null);
+ catalogueDataFile.setFilePath(null);
+ }
+ catalogueDataFile.setCreateBy(SecurityUtils.getUsername());
+ catalogueDataFile.setCreateTime(LocalDate.now());
catalogueDataFile.setUpdateBy(SecurityUtils.getUsername());
catalogueDataFile.setUpdateTime(LocalDate.now());
- catalogueMapper.updateCatalogueDataFile(catalogueDataFile);
+ catalogueMapper.deleteByCatalogueDataFileId(catalogueDataFile.getId());
+ catalogueMapper.insertCatalogueDataFile(catalogueDataFile);
return CommonResult.success();
}
@@ -197,4 +227,9 @@
catalogueMapper.updateCatalogueDataFile(catalogueDataFile);
return CommonResult.success();
}
+
+ @Override
+ public CommonResult selectCatalogueDataFileList(CatalogueReq catalogueReq) {
+ return CommonResult.success(catalogueMapper.selectCatalogueDataFile(catalogueReq.getCompanyId(),catalogueReq.getCatalogueId()));
+ }
}
--
Gitblit v1.9.2