From dfafaeba878012f8cecb2cf620ca3183e7d23c0b Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期四, 26 三月 2026 20:24:16 +0800
Subject: [PATCH] execl
---
src/main/webapp/views/erpMaterialuse/materialuse.html | 44 ++++++++++++++++++++++
src/main/webapp/views/erpMaterialwwout/materialwwout.html | 25 ++++++++++++
2 files changed, 69 insertions(+), 0 deletions(-)
diff --git a/src/main/webapp/views/erpMaterialuse/materialuse.html b/src/main/webapp/views/erpMaterialuse/materialuse.html
index 41595c6..b4d1c90 100644
--- a/src/main/webapp/views/erpMaterialuse/materialuse.html
+++ b/src/main/webapp/views/erpMaterialuse/materialuse.html
@@ -60,6 +60,9 @@
<el-button type="primary" @click="fnPrint('鏄�')">鎵撳嵃</el-button>
</el-form-item>
<el-form-item label="">
+ <el-button type="success" @click="exportExcel">Excel瀵煎嚭</el-button>
+ </el-form-item>
+ <el-form-item label="">
<el-button type="primary" @click="fnCanelPrint()">鎾ら攢鐢熸垚</el-button>
</el-form-item>
<el-form-item label="">
@@ -735,6 +738,46 @@
}
+ function dateFormat(fmt, date) {
+ let ret;
+ const opt = {
+ "Y+": date.getFullYear().toString(),
+ "m+": (date.getMonth() + 1).toString(),
+ "d+": date.getDate().toString(),
+ "H+": date.getHours().toString(),
+ "M+": date.getMinutes().toString(),
+ "S+": date.getSeconds().toString()
+ };
+ for (let k in opt) {
+ ret = new RegExp("(" + k + ")").exec(fmt);
+ if (ret) {
+ fmt = fmt.replace(ret[1], (ret[1].length == 1) ? (opt[k]) : (opt[k].padStart(ret[1].length, "0")))
+ }
+ }
+ return fmt;
+ }
+
+ function exportExcel() {
+ if (selectList.value.length === 0) {
+ ElementPlus.ElMessage({
+ message: "璇峰厛閫夋嫨瑕佸鍑虹殑鏁版嵁",
+ type: 'error'
+ });
+ return;
+ }
+ var tableHtml = CreateTable(selectList.value);
+ var html = "<html><head><meta charset='utf-8' /></head><body>" + tableHtml + "</body></html>";
+ var blob = new Blob(['\ufeff' + html], { type: 'application/vnd.ms-excel;charset=utf-8;' });
+ var link = document.createElement('a');
+ var url = URL.createObjectURL(blob);
+ link.href = url;
+ link.download = "鐢熶骇棰嗘枡鍗昣" + dateFormat("YYYYmmddHHMMSS", new Date()) + ".xls";
+ document.body.appendChild(link);
+ link.click();
+ document.body.removeChild(link);
+ URL.revokeObjectURL(url);
+ }
+
function handleSizeChange(val) {
@@ -774,6 +817,7 @@
page,
fnPrint,
fnPrintView,
+ exportExcel,
fnCanelPrint,
fnCanelPrintRed,
fnPrintRed,
diff --git a/src/main/webapp/views/erpMaterialwwout/materialwwout.html b/src/main/webapp/views/erpMaterialwwout/materialwwout.html
index e202a77..34a9898 100644
--- a/src/main/webapp/views/erpMaterialwwout/materialwwout.html
+++ b/src/main/webapp/views/erpMaterialwwout/materialwwout.html
@@ -79,6 +79,9 @@
<el-button type="primary" @click="fnPrint('鏄�')">鎵撳嵃</el-button>
</el-form-item>
<el-form-item label="">
+ <el-button type="success" @click="exportExcel">Excel瀵煎嚭</el-button>
+ </el-form-item>
+ <el-form-item label="">
<el-button type="primary" @click="fnTongBu()">鐢熸垚濮斿鍑哄簱鍗�</el-button>
</el-form-item>
<el-form-item label="">
@@ -822,6 +825,27 @@
}
+ function exportExcel() {
+ if (selectList.value.length === 0) {
+ ElementPlus.ElMessage({
+ message: "璇峰厛閫夋嫨瑕佸鍑虹殑鏁版嵁",
+ type: 'error'
+ });
+ return;
+ }
+ var tableHtml = CreateTable(selectList.value);
+ var html = "<html><head><meta charset='utf-8' /></head><body>" + tableHtml + "</body></html>";
+ var blob = new Blob(['\ufeff' + html], { type: 'application/vnd.ms-excel;charset=utf-8;' });
+ var link = document.createElement('a');
+ var url = URL.createObjectURL(blob);
+ link.href = url;
+ link.download = "濮斿鍔犲伐鍑哄簱鍗昣" + dateFormat("YYYYmmddHHMMSS", new Date()) + ".xls";
+ document.body.appendChild(link);
+ link.click();
+ document.body.removeChild(link);
+ URL.revokeObjectURL(url);
+ }
+
function handleSizeChange(val) {
@@ -868,6 +892,7 @@
dialogPage,
fnPrint,
fnPrintView,
+ exportExcel,
fnCanelPrint,
fnTongBu,
fnCanelTongBu,
--
Gitblit v1.9.1