From 5f30ef778bbdf59d2835ddbf86d2edc6c6e279b5 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期二, 25 三月 2025 15:20:43 +0800
Subject: [PATCH] 获取两个时间内，除去周末周日以及法定节假日的 小时总数。
---
common/src/main/java/com/ycl/common/utils/excel/OutputExcelUtils.java | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/common/src/main/java/com/ycl/common/utils/excel/OutputExcelUtils.java b/common/src/main/java/com/ycl/common/utils/excel/OutputExcelUtils.java
index 68d0bac..cc41e66 100644
--- a/common/src/main/java/com/ycl/common/utils/excel/OutputExcelUtils.java
+++ b/common/src/main/java/com/ycl/common/utils/excel/OutputExcelUtils.java
@@ -5,6 +5,7 @@
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.ZipUtil;
import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.write.builder.ExcelWriterSheetBuilder;
import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
import com.ycl.common.utils.excel.convert.ExcelBigNumberConvert;
@@ -21,6 +22,7 @@
import java.lang.reflect.Field;
import java.net.URLEncoder;
import java.nio.file.Files;
+import java.util.Arrays;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
@@ -118,7 +120,7 @@
}
}
- private static void deleteDirectoryOrFile(File file) {
+ public static void deleteDirectoryOrFile(File file) {
if (ObjectUtil.isNull(file)) {
return;
}
@@ -155,8 +157,10 @@
public static <T> @NotNull Set<Integer> getSelectFields(List<String> fieldNames, Class<T> clazz) {
Set<Integer> selectedIndexes = new HashSet<>();
if (CollUtil.isNotEmpty(fieldNames)) {
- // 鍙嶅皠鑾峰彇瀛楁灞炴��
- Field[] declaredFields = clazz.getDeclaredFields();
+ // 鍙嶅皠鑾峰彇瀛楁灞炴��,杩欓噷鍙幏鍙杄asyExcel娉ㄨВ鐨勫瓧娈�
+ Field[] declaredFields = Arrays.stream(clazz.getDeclaredFields())
+ .filter(field -> field.isAnnotationPresent(ExcelProperty.class))
+ .toArray(Field[]::new);
// // 鍖归厤闇�瑕佸鍏ョ殑瀛楁
for (int i = 0; i < declaredFields.length; i++) {
if (fieldNames.contains(declaredFields[i].getName())) {
--
Gitblit v1.8.0