From 0cfb74382e44ef538c0bab5f3014363769ecdb2f Mon Sep 17 00:00:00 2001 From: bluejay <253316343@qq.com> Date: 星期三, 09 四月 2025 16:48:02 +0800 Subject: [PATCH] 调整导入和导出接口,进行数据字典的转义 --- aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java | 76 +++++++++++++++++++++++-------------- 1 files changed, 47 insertions(+), 29 deletions(-) diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java b/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java index 7bb607d..54805ba 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java +++ b/aps-modules/aps-core/src/main/java/com/aps/core/controller/ApsPlatePlanController.java @@ -1,36 +1,25 @@ package com.aps.core.controller; -import java.util.List; -import java.io.IOException; - -import com.aps.common.core.domain.R; -import com.aps.common.core.utils.file.FileUtils; -import com.aps.common.core.utils.uuid.IdUtils; -import com.aps.common.security.utils.DictUtils; -import com.aps.core.domain.ApsPartPlanTemp; -import com.aps.core.domain.ApsPlatePlanTemp; -import com.aps.system.api.domain.SysDictData; -import com.aps.system.api.domain.SysFile; -import jakarta.servlet.http.HttpServletResponse; -import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.web.bind.annotation.GetMapping; -import org.springframework.web.bind.annotation.PostMapping; -import org.springframework.web.bind.annotation.PutMapping; -import org.springframework.web.bind.annotation.DeleteMapping; -import org.springframework.web.bind.annotation.PathVariable; -import org.springframework.web.bind.annotation.RequestBody; -import org.springframework.web.bind.annotation.RequestMapping; -import org.springframework.web.bind.annotation.RestController; +import com.aps.common.core.utils.poi.ExcelUtil; +import com.aps.common.core.web.controller.BaseController; +import com.aps.common.core.web.domain.AjaxResult; +import com.aps.common.core.web.page.TableDataInfo; import com.aps.common.log.annotation.Log; import com.aps.common.log.enums.BusinessType; import com.aps.common.security.annotation.RequiresPermissions; -import com.aps.core.domain.ApsPlatePlan; -import com.aps.core.service.IApsPlatePlanService; -import com.aps.common.core.web.controller.BaseController; -import com.aps.common.core.web.domain.AjaxResult; -import com.aps.common.core.utils.poi.ExcelUtil; -import com.aps.common.core.web.page.TableDataInfo; +import com.aps.common.security.utils.DictUtils; +import com.aps.core.domain.ApsGasPipingPlan; +import com.aps.core.domain.ApsPlatePlan; +import com.aps.core.domain.ApsPlatePlanTemp; +import com.aps.core.service.IApsPlatePlanService; +import com.aps.system.api.domain.SysDictData; +import jakarta.servlet.http.HttpServletResponse; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; + +import java.util.List; +import java.util.Optional; /** * 閽i噾璁″垝绠$悊Controller @@ -62,9 +51,38 @@ @Log(title = "閽i噾璁″垝绠$悊", businessType = BusinessType.EXPORT) @PostMapping("/export") public void export(HttpServletResponse response, ApsPlatePlan apsPlatePlan) { - List<ApsPlatePlan> list = apsPlatePlanService.selectApsPlatePlanList(apsPlatePlan); + List<ApsPlatePlan> planList = apsPlatePlanService.selectApsPlatePlanList(apsPlatePlan); + + List<SysDictData> suspendedDic = DictUtils.getDictCache("aps_is_suspended"); + List<SysDictData> businessTypeDic = DictUtils.getDictCache("aps_business_type"); + List<SysDictData> documentStatusDic = DictUtils.getDictCache("aps_document_status"); + List<SysDictData> accountDic = DictUtils.getDictCache("aps_account"); + + for (int i = 0; i < planList.size(); i++) { + ApsPlatePlan plan=planList.get(i); + String isSuspendedTxt = plan.getIsSuspended().trim(); + String businessType = plan.getBusinessType().trim(); + String documentStatusText = plan.getDocumentStatus().trim(); + String account = plan.getAccount().trim(); + + Optional<SysDictData> documentStatusFirst = documentStatusDic.stream().filter(x -> x.getDictValue().equals(documentStatusText)).findFirst(); + documentStatusFirst.ifPresent(sysDictData -> plan.setDocumentStatus(sysDictData.getDictLabel())); + + Optional<SysDictData> accountFirst = accountDic.stream().filter(x -> x.getDictValue().equals(account)).findFirst(); + accountFirst.ifPresent(sysDictData -> plan.setAccount(sysDictData.getDictLabel())); + + Optional<SysDictData> businessTypeFirst = businessTypeDic.stream().filter(x -> x.getDictValue().equals(businessType)).findFirst(); + businessTypeFirst.ifPresent(sysDictData -> plan.setBusinessType(sysDictData.getDictLabel())); + + + Optional<SysDictData> isSuspendedFirst = suspendedDic.stream().filter(x -> x.getDictValue().equals(isSuspendedTxt)).findFirst(); + isSuspendedFirst.ifPresent(sysDictData -> plan.setIsSuspended(sysDictData.getDictLabel())); + + + } + ExcelUtil<ApsPlatePlan> util = new ExcelUtil<ApsPlatePlan>(ApsPlatePlan.class); - util.exportExcel(response, list, "閽i噾璁″垝绠$悊鏁版嵁"); + util.exportExcel(response, planList, "閽i噾璁″垝绠$悊鏁版嵁"); } /** -- Gitblit v1.9.3