From b92fd92933fce8e97fef05207596217bb746cd4d Mon Sep 17 00:00:00 2001
From: 1821349743@qq.com <1821349743@qq.com>
Date: 星期一, 17 四月 2023 12:06:33 +0800
Subject: [PATCH] update export excel
---
src/main/java/com/product/module/data/controller/SystemDataExportController.java | 106 +++++++++++++++++++++--------------------------------
1 files changed, 42 insertions(+), 64 deletions(-)
diff --git a/src/main/java/com/product/module/data/controller/SystemDataExportController.java b/src/main/java/com/product/module/data/controller/SystemDataExportController.java
index 9f009d2..db6e1cc 100644
--- a/src/main/java/com/product/module/data/controller/SystemDataExportController.java
+++ b/src/main/java/com/product/module/data/controller/SystemDataExportController.java
@@ -32,71 +32,49 @@
public class SystemDataExportController extends AbstractBaseController {
- @Autowired
- SystemDataExportService systemDataExportService;
+ @Autowired
+ SystemDataExportService systemDataExportService;
- @PostMapping("general-list/{version}")
- @ApiVersion(1)
- public String generalListDataExport(HttpServletRequest request){
- try{
- FieldSetEntity fse = null;
- Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
- if (bean != null) {
- RequestParameterEntity reqp = (RequestParameterEntity) bean;
- fse = reqp.getFormData();
- }
- if (bean == null || fse == null) {
- SpringMVCContextHolder.getSystemLogger().error(CmnCode.SYSTEM_FORM_NODATA.getValue(), CmnCode.SYSTEM_FORM_NODATA.getText());
- return this.error(CmnCode.SYSTEM_FORM_NODATA.getValue(), CmnCode.SYSTEM_FORM_NODATA.getText());
- }
- // 鍒ゆ柇鍙傛暟鏄惁姝ｅ父
- if (StringUtils.isEmpty(fse.getString(CmnConst.FILE_NAME))) {
- SpringMVCContextHolder.getSystemLogger().error(CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getValue(), CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getText());
- return this.error(CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getValue(), CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getText());
- }
- if (StringUtils.isEmpty(fse.getString(CmnConst.UPLOAD_API_URL))) {
- SpringMVCContextHolder.getSystemLogger().error(CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getValue(), CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getText());
- return this.error(CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getValue(), CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getText());
- }
- if(BaseUtil.dataTableIsEmpty(fse.getSubDataTable(CmnConst.EXPORT_PARAM))){
- SpringMVCContextHolder.getSystemLogger().error(CmnCode.EXPORT_PARAMS_NOT_EMPTY.getValue(), CmnCode.EXPORT_PARAMS_NOT_EMPTY.getText());
- return this.error(CmnCode.EXPORT_PARAMS_NOT_EMPTY.getValue(), CmnCode.EXPORT_PARAMS_NOT_EMPTY.getText());
- }
- systemDataExportService.generalListDataExport(fse.clones());
- return OK();
- }catch (BaseException e){
- e.printStackTrace();
- SpringMVCContextHolder.getSystemLogger().error(e);
- return error(e);
- }
- catch (Exception e){
- e.printStackTrace();
- SpringMVCContextHolder.getSystemLogger().error(e);
- return error(CmnCode.EXPORT_GENERAL_LIST_DATA_IMPORT_FIAL.getValue(),CmnCode.EXPORT_GENERAL_LIST_DATA_IMPORT_FIAL.getText()+e.getMessage());
- }
- }
- @PostMapping("report/{version}")
- @ApiVersion(1)
- public String reportDataExport(HttpServletRequest request){
- try{
- FieldSetEntity fse = null;
- Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
- if (bean != null) {
- RequestParameterEntity reqp = (RequestParameterEntity) bean;
- return OK_Add(systemDataExportService.reportDataExport(reqp));
- }
- return OK();
- }catch (BaseException e){
- e.printStackTrace();
- SpringMVCContextHolder.getSystemLogger().error(e);
- return error(e);
- }
- catch (Exception e){
- e.printStackTrace();
- SpringMVCContextHolder.getSystemLogger().error(e);
- return error(CmnCode.EXPORT_GENERAL_LIST_DATA_IMPORT_FIAL.getValue(),CmnCode.EXPORT_GENERAL_LIST_DATA_IMPORT_FIAL.getText()+e.getMessage());
- }
- }
+ @PostMapping("general-list/{version}")
+ @ApiVersion(1)
+ public String generalListDataExport(HttpServletRequest request) {
+ try {
+ FieldSetEntity fse = null;
+ Object bean = request.getAttribute(CoreConst.API_POST_REQUEST_DATA);
+ if (bean != null) {
+ RequestParameterEntity reqp = (RequestParameterEntity) bean;
+ fse = reqp.getFormData();
+ }
+ if (bean == null || fse == null) {
+ SpringMVCContextHolder.getSystemLogger().error(CmnCode.SYSTEM_FORM_NODATA.getValue(), CmnCode.SYSTEM_FORM_NODATA.getText());
+ return this.error(CmnCode.SYSTEM_FORM_NODATA.getValue(), CmnCode.SYSTEM_FORM_NODATA.getText());
+ }
+ // 鍒ゆ柇鍙傛暟鏄惁姝ｅ父
+ if (StringUtils.isEmpty(fse.getString(CmnConst.FILE_NAME))) {
+ SpringMVCContextHolder.getSystemLogger().error(CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getValue(), CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getText());
+ return this.error(CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getValue(), CmnCode.EXPORT_FILE_NAME_NOT_EMPTY.getText());
+ }
+ if (StringUtils.isEmpty(fse.getString(CmnConst.UPLOAD_API_URL))) {
+ SpringMVCContextHolder.getSystemLogger().error(CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getValue(), CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getText());
+ return this.error(CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getValue(), CmnCode.EXPORT_UPLOAD_URL_NOT_EMPTY.getText());
+ }
+ if (BaseUtil.dataTableIsEmpty(fse.getSubDataTable(CmnConst.EXPORT_PARAM))) {
+ SpringMVCContextHolder.getSystemLogger().error(CmnCode.EXPORT_PARAMS_NOT_EMPTY.getValue(), CmnCode.EXPORT_PARAMS_NOT_EMPTY.getText());
+ return this.error(CmnCode.EXPORT_PARAMS_NOT_EMPTY.getValue(), CmnCode.EXPORT_PARAMS_NOT_EMPTY.getText());
+ }
+ systemDataExportService.generalListDataExport(fse.clones());
+ return OK();
+ } catch (BaseException e) {
+ e.printStackTrace();
+ SpringMVCContextHolder.getSystemLogger().error(e);
+ return error(e);
+ } catch (Exception e) {
+ e.printStackTrace();
+ SpringMVCContextHolder.getSystemLogger().error(e);
+ return error(CmnCode.EXPORT_GENERAL_LIST_DATA_IMPORT_FIAL.getValue(), CmnCode.EXPORT_GENERAL_LIST_DATA_IMPORT_FIAL.getText() + e.getMessage());
+ }
+ }
+
}
--
Gitblit v1.9.2