From 35da9191297752452f7ab60ff9bc3eed515dfeec Mon Sep 17 00:00:00 2001
From: Crunchy <3114200645@qq.com>
Date: 星期一, 13 五月 2024 16:30:06 +0800
Subject: [PATCH] 2024-5-10 绩效管理-班次-月度文件导出
---
system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java | 34 +++++++++++++++++++++++++++++++---
1 files changed, 31 insertions(+), 3 deletions(-)
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 a125d72..66c5769 100644
--- a/system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java
+++ b/system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java
@@ -1,14 +1,42 @@
package com.yuanchu.mom;
-import com.yuanchu.mom.utils.MyUtil;
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.write.style.HorizontalCellStyleStrategy;
+import com.yuanchu.mom.service.PerformanceShiftService;
+import com.yuanchu.mom.utils.StyleMonthUtils;
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 {
- @Test
- void contextLoads() {
+ @Autowired
+ private PerformanceShiftService performanceShiftService;
+ private static String fileName = "D:\\" + System.currentTimeMillis() + ".xlsx";
+
+ @Test
+ void contextLoads() throws Exception {
+ Map<Object, Object> data = performanceShiftService.exportToMonthExcel("2024-05-01 00:00:00", null, null);
+ // 璁剧疆鍗曞厓鏍兼牱寮�
+ HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(StyleMonthUtils.getHeadStyle(), StyleMonthUtils.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