From 21b96d6a4e042df7e45dce85b3f501c142a38247 Mon Sep 17 00:00:00 2001
From: tjx <t2856754968@163.com>
Date: 星期三, 12 十一月 2025 20:07:16 +0800
Subject: [PATCH] 更新钉钉配置
---
src/main/java/com/gs/xky/service/Impl/VwCjScSjTsBbServiceImpl.java | 199 ++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 187 insertions(+), 12 deletions(-)
diff --git a/src/main/java/com/gs/xky/service/Impl/VwCjScSjTsBbServiceImpl.java b/src/main/java/com/gs/xky/service/Impl/VwCjScSjTsBbServiceImpl.java
index 54e862f..a0e39fd 100644
--- a/src/main/java/com/gs/xky/service/Impl/VwCjScSjTsBbServiceImpl.java
+++ b/src/main/java/com/gs/xky/service/Impl/VwCjScSjTsBbServiceImpl.java
@@ -1,20 +1,195 @@
-package generator.service.impl;
+package com.gs.xky.service.Impl;
+import cn.hutool.core.io.FileUtil;
+import cn.hutool.poi.excel.ExcelUtil;
+import cn.hutool.poi.excel.ExcelWriter;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import generator.domain.VwCjScSjTsBb;
-import generator.service.VwCjScSjTsBbService;
-import generator.mapper.VwCjScSjTsBbMapper;
+import com.gs.xky.entity.VwCjScSjTsBb;
+import com.gs.xky.entity.VwCjScSjTsBbMonth;
+import com.gs.xky.mapper.VwCjScSjTsBbMapper;
+import com.gs.xky.service.DingtalkInfoService;
+import com.gs.xky.service.VwCjScSjTsBbMonthService;
+import com.gs.xky.service.VwCjScSjTsBbService;
+import lombok.RequiredArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
-/**
-* @author Administrator
-* @description 閽堝琛ㄣ�怴W_CJ_SC_SJ_TS_BB銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇
-* @createDate 2025-11-12 19:44:46
-*/
-@Service
-public class VwCjScSjTsBbServiceImpl extends ServiceImpl<VwCjScSjTsBbMapper, VwCjScSjTsBb>
- implements VwCjScSjTsBbService{
+import java.text.SimpleDateFormat;
+import java.time.LocalDate;
+import java.time.format.DateTimeFormatter;
+import java.util.Date;
+import java.util.List;
+/**
+ * @author Administrator
+ * @description 閽堝琛ㄣ�怴W_CJ_SC_SJ_TS_BB銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇
+ * @createDate 2025-11-12 16:42:06
+ */
+@Service
+@Slf4j
+@RequiredArgsConstructor
+public class VwCjScSjTsBbServiceImpl extends ServiceImpl<VwCjScSjTsBbMapper, VwCjScSjTsBb>
+ implements VwCjScSjTsBbService {
+
+ private final DingtalkInfoService dingtalkInfoService;
+ private final VwCjScSjTsBbMonthService vwCjScSjTsBbMonthService;
+
+ @Override
+ public boolean exportAndSendToDingtalk() throws Exception {
+ String exportFilePath = null;
+ try {
+
+ // 2. 鍑嗗瀵煎嚭鏂囦欢璺緞
+ String timestamp = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());
+ String fileName = "鐢熶骇鏁版嵁鎶ヨ〃_" + timestamp + ".xlsx";
+ exportFilePath = "D:\\BIFile\\" + fileName;
+
+ // 纭繚鐩綍瀛樺湪
+ FileUtil.mkdir("D:\\BIFile");
+
+ // 3. 瀵煎嚭鍒癊xcel
+ log.info("寮�濮嬪鍑篍xcel鏂囦欢: {}", exportFilePath);
+ exportToExcel(exportFilePath);
+ log.info("Excel鏂囦欢瀵煎嚭鎴愬姛");
+
+ // 4. 鍙戦�侀拤閽夋秷鎭�
+ log.info("寮�濮嬪彂閫侀拤閽夋枃浠舵秷鎭�...");
+ boolean sendResult = dingtalkInfoService.sendFileMessage(exportFilePath);
+
+ if (sendResult) {
+ log.info("閽夐拤鏂囦欢娑堟伅鍙戦�佹垚鍔�");
+ } else {
+ log.warn("閽夐拤鏂囦欢娑堟伅鍙戦�佸け璐�");
+ }
+
+ return sendResult;
+
+ } catch (Exception e) {
+ log.error("瀵煎嚭骞跺彂閫佸け璐�", e);
+ throw e;
+ } finally {
+ // 鍙�夛細鍙戦�佸悗鍒犻櫎涓存椂鏂囦欢
+ // if (exportFilePath != null && FileUtil.exist(exportFilePath)) {
+ // FileUtil.del(exportFilePath);
+ // log.info("涓存椂鏂囦欢宸插垹闄�: {}", exportFilePath);
+ // }
+ }
+ }
+
+ /**
+ * 瀵煎嚭鏁版嵁鍒癊xcel锛堜袱涓猻heet椤碉級
+ *
+ * @param filePath 鏂囦欢璺緞
+ */
+ private void exportToExcel(String filePath) {
+ // 璁＄畻鏄ㄥぉ鐨勬棩鏈�
+ LocalDate yesterday = LocalDate.now().minusDays(1);
+ String yesterdayStr = yesterday.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
+
+ // 璁＄畻鏈湀鐨勮捣姝㈡棩鏈�
+ LocalDate today = LocalDate.now();
+ LocalDate firstDayOfMonth = today.withDayOfMonth(1);
+ LocalDate lastDayOfMonth = today.withDayOfMonth(today.lengthOfMonth());
+ String firstDayStr = firstDayOfMonth.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
+ String lastDayStr = lastDayOfMonth.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
+
+ log.info("鏄ㄥぉ鏃ユ湡: {}", yesterdayStr);
+ log.info("鏈湀鑼冨洿: {} 鑷� {}", firstDayStr, lastDayStr);
+
+ // 杩囨护鏁版嵁锛氶璁″紑宸ュ湪鏄ㄥぉ鐨勬暟鎹�
+ List<VwCjScSjTsBb> yesterdayData = list();
+
+ // 杩囨护鏁版嵁锛氶璁″紑宸ュ湪鏈湀鐨勬暟鎹�
+ List<VwCjScSjTsBbMonth> thisMonthData = vwCjScSjTsBbMonthService.list();
+
+ log.info("鏄ㄥぉ鏁版嵁: {} 鏉�", yesterdayData.size());
+ log.info("鏈湀鏁版嵁: {} 鏉�", thisMonthData.size());
+
+ // 鍒涘缓Excel鍐欏叆鍣紙绗竴涓猻heet锛�
+ ExcelWriter writer = ExcelUtil.getWriter(filePath, "鏄ㄥぉ鍏ュ簱宸ュ崟鐢宠");
+
+ // 鍐欏叆绗竴涓猻heet锛氭槰澶╅璁″紑宸ョ殑鏁版嵁
+ writeSheetData(writer, "鏄ㄥぉ鍏ュ簱宸ュ崟鐢宠鏁版嵁锛�" + yesterdayStr + "锛�", yesterdayData);
+
+ // 鍒涘缓绗簩涓猻heet
+ writer.setSheet("鏈湀鍏ュ簱宸ュ崟鐢宠");
+
+ // 鍐欏叆绗簩涓猻heet锛氭湰鏈堥璁″紑宸ョ殑鏁版嵁
+ writeSheetData(writer, thisMonthData, "鏈湀鍏ュ簱宸ュ崟鐢宠鏁版嵁锛�" + firstDayStr + " 鑷� " + lastDayStr + "锛�");
+
+ // 鍏抽棴writer锛岄噴鏀惧唴瀛�
+ writer.close();
+ }
+
+ /**
+ * 鍐欏叆鍗曚釜sheet鐨勬暟鎹�
+ *
+ * @param writer Excel鍐欏叆鍣�
+ * @param dataList 鏁版嵁鍒楄〃
+ * @param title 鏍囬
+ */
+ private void writeSheetData(ExcelWriter writer, String title, List<VwCjScSjTsBb> dataList) {
+ // 娓呯┖涔嬪墠鐨勫埆鍚嶈缃�
+ writer.clearHeaderAlias();
+
+ // 璁剧疆琛ㄥご鍒悕锛堜腑鏂囧垪鍚嶏級
+ writer.addHeaderAlias("daa001", "宸ュ崟鍙�");
+ writer.addHeaderAlias("itemNo", "鐗╂枡缂栫爜");
+ writer.addHeaderAlias("itemName", "鐗╂枡鍚嶇О");
+ writer.addHeaderAlias("departmentname", "杞﹂棿鍚嶇О");
+ writer.addHeaderAlias("lineName", "绾夸綋鍚嶇О");
+ writer.addHeaderAlias("departmentcode", "杞﹂棿缂栫爜");
+ writer.addHeaderAlias("lineNo", "绾夸綋缂栫爜");
+ writer.addHeaderAlias("daa008", "宸ュ崟鏁伴噺");
+ writer.addHeaderAlias("yjkg", "棰勮寮�宸�");
+ writer.addHeaderAlias("sjkg", "瀹為檯寮�宸�");
+ writer.addHeaderAlias("sq", "鐢宠鍏ュ簱鏁�");
+ writer.addHeaderAlias("rk", "鍏ュ簱鏁�");
+ writer.addHeaderAlias("sqwwg", "鐢宠鏈畬宸ユ暟");
+ writer.addHeaderAlias("rkwwg", "鍏ュ簱鏈畬宸�");
+ writer.addHeaderAlias("sqwrk", "鐢宠鏈叆搴�");
+
+ // 鍚堝苟鍗曞厓鏍间綔涓烘爣棰樿
+ writer.merge(14, title);
+
+ // 鍐欏叆鏁版嵁锛岄粯璁や細浣跨敤鍒悕浣滀负琛ㄥご
+ writer.write(dataList, true);
+
+ // 璁剧疆鍒楀鑷�傚簲
+ writer.autoSizeColumnAll();
+ }
+
+
+ private void writeSheetData(ExcelWriter writer, List<VwCjScSjTsBbMonth> dataList, String title) {
+ // 娓呯┖涔嬪墠鐨勫埆鍚嶈缃�
+ writer.clearHeaderAlias();
+
+ // 璁剧疆琛ㄥご鍒悕锛堜腑鏂囧垪鍚嶏級
+ writer.addHeaderAlias("daa001", "宸ュ崟鍙�");
+ writer.addHeaderAlias("itemNo", "鐗╂枡缂栫爜");
+ writer.addHeaderAlias("itemName", "鐗╂枡鍚嶇О");
+ writer.addHeaderAlias("departmentname", "杞﹂棿鍚嶇О");
+ writer.addHeaderAlias("lineName", "绾夸綋鍚嶇О");
+ writer.addHeaderAlias("departmentcode", "杞﹂棿缂栫爜");
+ writer.addHeaderAlias("lineNo", "绾夸綋缂栫爜");
+ writer.addHeaderAlias("daa008", "宸ュ崟鏁伴噺");
+ writer.addHeaderAlias("yjkg", "棰勮寮�宸�");
+ writer.addHeaderAlias("sjkg", "瀹為檯寮�宸�");
+ writer.addHeaderAlias("sq", "鐢宠鍏ュ簱鏁�");
+ writer.addHeaderAlias("rk", "鍏ュ簱鏁�");
+ writer.addHeaderAlias("sqwwg", "鐢宠鏈畬宸ユ暟");
+ writer.addHeaderAlias("rkwwg", "鍏ュ簱鏈畬宸�");
+ writer.addHeaderAlias("sqwrk", "鐢宠鏈叆搴�");
+
+ // 鍚堝苟鍗曞厓鏍间綔涓烘爣棰樿
+ writer.merge(14, title);
+
+ // 鍐欏叆鏁版嵁锛岄粯璁や細浣跨敤鍒悕浣滀负琛ㄥご
+ writer.write(dataList, true);
+
+ // 璁剧疆鍒楀鑷�傚簲
+ writer.autoSizeColumnAll();
+ }
}
--
Gitblit v1.9.3