From 3c32000216972a73cef885933ddb3e5ccc888749 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期二, 13 五月 2025 14:26:13 +0800
Subject: [PATCH] 大屏样式修改，色块个数查询限制为当天
---
UI-Project/src/views/largescreendisplay/statistics.vue | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/UI-Project/src/views/largescreendisplay/statistics.vue b/UI-Project/src/views/largescreendisplay/statistics.vue
index 8dcf943..430287d 100644
--- a/UI-Project/src/views/largescreendisplay/statistics.vue
+++ b/UI-Project/src/views/largescreendisplay/statistics.vue
@@ -7,6 +7,7 @@
</el-date-picker>
<el-button type="primary" style="margin-left: 10px;margin-bottom: 10px;" @click="sethistorical()">{{
$t('reportmanage.inquire') }}</el-button>
+ <el-button type="primary" @click="exportToExcel">{{$t('large.ExporttoExcel')}}</el-button>
</div>
<el-table ref="table" style="margin-top: 20px;height: 580px;width: 1770px;" :data="tableDatax"
:header-cell-style="{ background: '#F2F3F5 ', color: '#1D2129' }">
@@ -223,5 +224,50 @@
parseAndSetTime();
historical();
});
+
+import * as XLSX from 'xlsx';
+import { saveAs } from 'file-saver';
+
+const exportToExcel = () => {
+ // 琛ㄦ牸鏁版嵁锛堟繁鎷疯礉闃叉姹℃煋锛�
+ const data = JSON.parse(JSON.stringify(tableDatax.value));
+
+ // 琛ㄥご杞崲涓轰腑鏂囨垨鍥介檯鍖栨枃鏈�
+ const headerMap = {
+ date: t('large.date'),
+ countOutOne: t('large.countOutOne'),
+ totalAreaOutOne: t('large.totalAreaOutOne'),
+ countOutTwo: t('large.countOutTwo'),
+ totalAreaOutTwo: t('large.totalAreaOutTwo'),
+ countIn: t('large.countIn'),
+ totalAreaIn: t('large.totalAreaIn'),
+ countOut: t('large.countOut'),
+ totalAreaOut: t('large.totalAreaOut'),
+ hollowCountOutOne: t('large.hollowCountOutOne'),
+ hollowTotalAreaOutOne: t('large.hollowTotalAreaOutOne'),
+ hollowCountOutTwo: t('large.hollowCountOutTwo'),
+ hollowTotalAreaOutTwo: t('large.hollowTotalAreaOutTwo')
+ };
+
+ // 灏嗘暟鎹腑鐨� key 鏇挎崲涓轰腑鏂囪〃澶�
+ const exportData = data.map(row => {
+ const newRow = {};
+ for (const key in headerMap) {
+ newRow[headerMap[key]] = row[key];
+ }
+ return newRow;
+ });
+
+ // 杞崲涓哄伐浣滆〃
+ const worksheet = XLSX.utils.json_to_sheet(exportData);
+ const workbook = XLSX.utils.book_new();
+ XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
+
+ // 瀵煎嚭涓烘枃浠�
+ const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
+ const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });
+ saveAs(blob, '鐢熶骇鎯呭喌瀵煎嚭.xlsx');
+};
+
</script>
<style scoped></style>
\ No newline at end of file
--
Gitblit v1.8.0