From 0796eebe3520fafb0ac5d36ee584af81506d7e9c Mon Sep 17 00:00:00 2001
From: riku <risaku@163.com>
Date: 星期六, 20 九月 2025 14:05:52 +0800
Subject: [PATCH] 2025.9.20 数据产品（待完成）
---
src/utils/time-util.js | 46 +++++++++++++++++++++++++++++++---------------
1 files changed, 31 insertions(+), 15 deletions(-)
diff --git a/src/utils/time-util.js b/src/utils/time-util.js
index 951116b..e126941 100644
--- a/src/utils/time-util.js
+++ b/src/utils/time-util.js
@@ -1,39 +1,55 @@
-import dayjs from "dayjs";
+import dayjs from 'dayjs';
export default {
format(date, template) {
- return dayjs(date).format(template)
+ return dayjs(date).format(template);
},
- formatH(date){
+ formatH(date) {
if (date) {
- return this.format(date, 'HH:mm:ss')
+ return this.format(date, 'HH:mm:ss');
} else {
- return '--:--:--'
+ return '--:--:--';
}
},
- formatYM(date){
+ formatYM(date) {
if (date) {
- return this.format(date, 'YYYY-MM')
+ return this.format(date, 'YYYY-MM');
} else {
- return '----/--'
+ return '----/--';
}
},
- formatYMD(date){
+ formatYMD(date) {
if (date) {
- return this.format(date, 'YYYY-MM-DD')
+ return this.format(date, 'YYYY-MM-DD');
} else {
- return '----/--/--'
+ return '----/--/--';
}
},
- formatYMDH(date){
+ formatYMDH(date) {
if (date) {
- return this.format(date, 'YYYY-MM-DD HH:mm:ss')
+ return this.format(date, 'YYYY-MM-DD HH:mm:ss');
} else {
- return '----/--/-- --:--:--'
+ return '----/--/-- --:--:--';
}
},
-}
\ No newline at end of file
+
+ formatDateFromExcel(num, format) {
+ const old = num - 1;
+ const t = Math.round((old - Math.floor(old)) * 24 * 60 * 60);
+ const time = new Date(1900, 0, old, 0, 0, t);
+ const year = time.getFullYear();
+ const month = time.getMonth() + 1;
+ const date = time.getDate();
+ return dayjs(
+ year +
+ format +
+ (month < 10 ? '0' + month : month) +
+ format +
+ (date < 10 ? '0' + date : date)
+ );
+ }
+};
--
Gitblit v1.9.3