From f053f41a1e940592ae03835e11717e7c98afd3a5 Mon Sep 17 00:00:00 2001
From: Crunchy <3114200645@qq.com>
Date: 星期四, 23 五月 2024 17:24:15 +0800
Subject: [PATCH] 2024-5-23 导入标准明细完成
---
system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java | 30 +-----------------------------
cnas-server/src/main/java/com/yuanchu/mom/controller/StandardMethodController.java | 4 ++--
2 files changed, 3 insertions(+), 31 deletions(-)
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/StandardMethodController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/StandardMethodController.java
index d8c5d3f..cb88f6c 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/StandardMethodController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/StandardMethodController.java
@@ -60,8 +60,8 @@
@ValueClassify("瀹為獙瀹ょ殑妫�娴嬭兘鍔涙。妗�")
@ApiOperation(value = "瀵煎叆鏍囧噯鏄庣粏")
- @PostMapping("/inputFansSubmitCsv")
- public Result<?> inputExcel(@RequestPart("file") MultipartFile file) throws IOException {
+ @PostMapping("/importStandardDetails")
+ public Result<?> importStandardDetails(@RequestPart("file") MultipartFile file) throws IOException {
standardMethodService.inputExcel(file);
return Result.success();
}
diff --git a/system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java b/system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java
index 7ff4ee0..c9fa8ae 100644
--- a/system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java
+++ b/system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java
@@ -1,42 +1,14 @@
package com.yuanchu.mom;
-import com.alibaba.excel.EasyExcel;
-import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
-import com.yuanchu.mom.service.PerformanceShiftService;
-import com.yuanchu.mom.utils.StyleYearUtils;
import org.junit.jupiter.api.Test;
-import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
-
-import java.util.Collection;
-import java.util.List;
-import java.util.Map;
@SpringBootTest
class SystemRunApplicationTest {
- @Autowired
- private PerformanceShiftService performanceShiftService;
-
- private static String fileName = "D:\\" + System.currentTimeMillis() + ".xlsx";
-
@Test
void contextLoads() throws Exception {
- Map<Object, Object> data = performanceShiftService.exportToYearExcel("2024-05-01 00:00:00", null, null);
- // 璁剧疆鍗曞厓鏍兼牱寮�
- HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(StyleYearUtils.getHeadStyle(), StyleYearUtils.getContentStyle());
- EasyExcel.write(fileName)
- .head((List<List<String>>) data.get("header"))
- .registerWriteHandler(horizontalCellStyleStrategy)
- .sheet("鏈堝害")
- .doWrite((Collection<?>) data.get("data"));
-// String url = "https://qyapi.weixin.qq.com/cgi-bin/webhook/send?corpid=wwa423654b975441ac&corpsecret=J3fbMJoTn3LmrWDobvS5JpU8N0TvEbGkVl8OhvIsol0";
-// String s = HttpUtil.get(url);
-// System.out.println(s);
-// Map<String, Object> unmarshal = JSONObject.parseObject(s, Map.class);
-// String checkInRecords = "https://qyapi.weixin.qq.com/cgi-bin/checkin/getcheckindata?access_token=" + unmarshal.get("access_token");
-// String body = HttpRequest.post(checkInRecords).execute().body();
-// System.out.println(body);
+
}
}
--
Gitblit v1.9.3