From 4cd71c0be46a461432989ae7c5d6d56d9e7bbbed Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期一, 17 二月 2025 13:54:31 +0800
Subject: [PATCH] 查询待办任务时，判断是否挂起状态。增加一个临时导入项目的接口
---
business/src/main/java/com/ycl/controller/ProjectInfoController.java | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git a/business/src/main/java/com/ycl/controller/ProjectInfoController.java b/business/src/main/java/com/ycl/controller/ProjectInfoController.java
index ee060f8..33bd028 100644
--- a/business/src/main/java/com/ycl/controller/ProjectInfoController.java
+++ b/business/src/main/java/com/ycl/controller/ProjectInfoController.java
@@ -1,18 +1,25 @@
package com.ycl.controller;
+import com.alibaba.excel.EasyExcel;
import com.ycl.common.base.Result;
import com.ycl.common.exception.base.BaseException;
import com.ycl.common.group.Add;
import com.ycl.common.group.Update;
import com.ycl.common.utils.ProjectCodeGenerator;
+import com.ycl.common.utils.bean.BeanUtils;
import com.ycl.common.utils.excel.OutputExcelUtils;
+import com.ycl.domain.entity.ProjectInfo;
import com.ycl.domain.excel.ProjectExcelTemplate;
+import com.ycl.domain.excel.ProjectTempImport;
import com.ycl.domain.form.DocumentInfoForm;
import com.ycl.domain.form.ProjectForm;
import com.ycl.domain.form.ProjectInfoForm;
import com.ycl.domain.query.ProjectExportQuery;
import com.ycl.domain.query.ProjectInfoQuery;
+import com.ycl.listener.excel.CurrencyDataListener;
import com.ycl.service.ProjectInfoService;
+import com.ycl.system.mapper.SysDeptMapper;
+import com.ycl.system.service.ISysDeptService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.RequiredArgsConstructor;
@@ -23,8 +30,10 @@
import javax.servlet.http.HttpServletResponse;
import javax.validation.constraints.NotEmpty;
import java.io.IOException;
+import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;
+import java.util.function.Consumer;
/**
* 椤圭洰绠＄悊鍩虹淇℃伅琛� 鍓嶇鎺у埗鍣�
@@ -40,6 +49,28 @@
public class ProjectInfoController {
private final ProjectInfoService projectInfoService;
+ private final SysDeptMapper deptMapper;
+
+ @PostMapping("/import/temp")
+ @ApiOperation(value = "涓存椂瀵煎叆", notes = "涓存椂瀵煎叆")
+// @PreAuthorize("hasAuthority('projectInfo:add')")
+ public Result importTemp(@RequestPart("file") MultipartFile file) throws IOException {
+ Consumer<List<ProjectTempImport>> consumer = (data) -> {
+ for (ProjectTempImport project : data) {
+ ProjectInfo projectInfo = new ProjectInfo();
+ BeanUtils.copyProperties(project, projectInfo);
+ projectInfo.setYearInvestAmount(project.getTzje());
+ // 澶勭悊涓氫富鍗曚綅銆佷富绠￠儴闂╥d
+ Long yzId = deptMapper.selectByName(project.getProjectOwnerUnit());
+ projectInfo.setProjectOwnerUnit(yzId);
+ Long zgId = deptMapper.selectByName(project.getCompetentDepartment());
+ projectInfo.setCompetentDepartment(zgId + "");
+ projectInfoService.save(projectInfo);
+ }
+ };
+ EasyExcel.read(file.getInputStream(), ProjectTempImport.class, new CurrencyDataListener(consumer)).headRowNumber(1).doReadAll();
+ return Result.ok();
+ }
@PostMapping
@ApiOperation(value = "娣诲姞", notes = "娣诲姞")
--
Gitblit v1.8.0