From 010eb7b8cdcaaba77ec272234352f15aa028ca82 Mon Sep 17 00:00:00 2001 From: Crunchy <3114200645@qq.com> Date: 星期二, 23 七月 2024 09:52:05 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- system-run/src/test/java/com/yuanchu/mom/SystemRunApplicationTest.java | 60 +++++++++++++++++++++++++++++++----------------------------- 1 files changed, 31 insertions(+), 29 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 7ff4ee0..4e345ea 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,44 @@ 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; +import java.time.LocalDate; +import java.time.LocalDateTime; +import java.time.LocalTime; +import java.time.temporal.TemporalAdjusters; +import java.time.temporal.WeekFields; +import java.util.Locale; @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); + void contextLoads() { + // 鑾峰彇褰撳墠鏃ユ湡 + LocalDate today = LocalDate.now(); + + // 鑾峰彇鏈湀鐨勭涓�澶╁拰鏈�鍚庝竴澶� + LocalDate firstDayOfMonth = today.with(TemporalAdjusters.firstDayOfMonth()); + LocalDate lastDayOfMonth = today.with(TemporalAdjusters.lastDayOfMonth()); + + // 鑾峰彇鍛ㄥ瓧娈典俊鎭紙鏍规嵁鍖哄煙璁剧疆锛� + WeekFields weekFields = WeekFields.of(Locale.getDefault()); + + // 鑾峰彇鏈湀绗竴澶╃殑鍛ㄤ竴 + LocalDate startOfWeek = firstDayOfMonth.with(TemporalAdjusters.previousOrSame(weekFields.getFirstDayOfWeek())); + + // 閬嶅巻鏈湀鎵�鏈夊ぉ鏁帮紝鎵惧嚭姣忓懆鐨勭涓�澶╁拰鏈�鍚庝竴澶� + LocalDate endOfWeek; + while (startOfWeek.isBefore(firstDayOfMonth.plusMonths(1))) { + endOfWeek = startOfWeek.plusDays(6); + LocalDateTime startDateTime = LocalDateTime.of(startOfWeek, LocalTime.MIDNIGHT); + LocalDateTime endDateTime = LocalDateTime.of(endOfWeek, LocalTime.MIDNIGHT); + + System.out.println("Week starts on " + startDateTime + " and ends on " + endDateTime); + + startOfWeek = startOfWeek.plusWeeks(1); + } } } -- Gitblit v1.9.3