From a6e044780082d6a6507f64edb9a5242b779fb6ee Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Mon, 25 Mar 2024 14:38:32 +0800
Subject: [PATCH] 项目填报导入接口
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbProjectController.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbProjectController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbProjectController.java
index dd4fb74..c532eeb 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbProjectController.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbProjectController.java
@@ -1,19 +1,26 @@
package cn.gistack.sm.sjztmd.controller;
import cn.gistack.sm.sjztmd.dto.TbProjectDTO;
+import cn.gistack.sm.sjztmd.excel.TbProjectExcel;
+import cn.gistack.sm.sjztmd.excel.TbProjectImporter;
import cn.gistack.sm.sjztmd.service.ITbProjectService;
import cn.gistack.sm.sjztmd.statisticsVO.StatisticsParams;
import cn.gistack.sm.sjztmd.statisticsVO.StatisticsTableProject;
import cn.gistack.sm.sjztmd.vo.TbProjectVO;
import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.boot.ctrl.BladeController;
+import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletResponse;
+import java.util.ArrayList;
import java.util.List;
@Slf4j
@@ -47,6 +54,23 @@
return R.data(list);
}
+ /**
+ * 导入模板
+ */
+ @GetMapping("export-template")
+ public void exportUser(HttpServletResponse response) {
+ List<TbProjectExcel> list = new ArrayList<>();
+ ExcelUtil.export(response, "用户数据模板", "用户数据表", list, TbProjectExcel.class);
+ }
+ /**
+ * 导入用户
+ */
+ @PostMapping("import-tb-project")
+ public R importUser(MultipartFile file, Integer isCovered) {
+ TbProjectImporter userImporter = new TbProjectImporter(tbProjectService, isCovered == 1);
+ ExcelUtil.save(file, userImporter, TbProjectExcel.class);
+ return R.success("操作成功");
+ }
}
--
Gitblit v1.9.3