| | |
|---|
| | | 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.StyleMonthUtils; |
|---|
| | | import com.alibaba.fastjson.JSONArray; |
|---|
| | | import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; |
|---|
| | | import com.yuanchu.mom.exception.ErrorException; |
|---|
| | | import com.yuanchu.mom.utils.DianLuUtils; |
|---|
| | | import org.apache.commons.lang3.ArrayUtils; |
|---|
| | | import org.apache.el.lang.ExpressionBuilder; |
|---|
| | | 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 javax.annotation.Resource; |
|---|
| | | import javax.script.ScriptEngine; |
|---|
| | | import javax.script.ScriptEngineManager; |
|---|
| | | import java.math.BigDecimal; |
|---|
| | | import java.time.LocalDate; |
|---|
| | | import java.time.LocalDateTime; |
|---|
| | | import java.time.LocalTime; |
|---|
| | | import java.time.format.DateTimeFormatter; |
|---|
| | | import java.time.temporal.TemporalAdjusters; |
|---|
| | | import java.time.temporal.WeekFields; |
|---|
| | | import java.util.ArrayList; |
|---|
| | | import java.util.Arrays; |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | import java.util.Locale; |
|---|
| | | import java.util.regex.Matcher; |
|---|
| | | import java.util.regex.Pattern; |
|---|
| | | import java.util.stream.Collectors; |
|---|
| | | |
|---|
| | | |
|---|
| | | @SpringBootTest |
|---|
| | | class SystemRunApplicationTest { |
|---|
| | | |
|---|
| | | @Autowired |
|---|
| | | private PerformanceShiftService performanceShiftService; |
|---|
| | | |
|---|
| | | private static String fileName = "D:\\" + System.currentTimeMillis() + ".xlsx"; |
|---|
| | | @Resource |
|---|
| | | DianLuUtils dianLuUtils; |
|---|
| | | |
|---|
| | | @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); |
|---|
| | | void contextLoads() { |
|---|
| | | //dianLuUtils.readDianLuFile1(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
