From dbd52e37e265eeb111ee26b0dacc78ae058db76f Mon Sep 17 00:00:00 2001
From: cl <1442464845@qq.com>
Date: 星期四, 26 三月 2026 20:34:50 +0800
Subject: [PATCH] execl
---
src/main/webapp/views/erpMaterialuse/materialuse.html | 83 ++++++++++++++++++++++++---
src/main/webapp/views/erpMaterialwwout/materialwwout.html | 73 ++++++++++++++++++++---
2 files changed, 134 insertions(+), 22 deletions(-)
diff --git a/src/main/webapp/views/erpMaterialuse/materialuse.html b/src/main/webapp/views/erpMaterialuse/materialuse.html
index b4d1c90..c3615fe 100644
--- a/src/main/webapp/views/erpMaterialuse/materialuse.html
+++ b/src/main/webapp/views/erpMaterialuse/materialuse.html
@@ -765,17 +765,78 @@
});
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);
+ const loading = ElementPlus.ElLoading.service({
+ lock: true,
+ text: '瀵煎嚭涓�...',
+ background: 'rgba(0, 0, 0, 0.7)',
+ });
+ $.ajax({
+ url: "http://127.0.0.1:8133/mo/materialuse/print",
+ headers: {
+ 'token': localStorage.getItem('token')
+ },
+ data: JSON.stringify({
+ icmoDTOS: JSON.stringify(selectList.value),
+ izPrint: "鍚�",
+ izRed: 0
+ }),
+ dataType: 'json',
+ contentType: 'application/json;charset=UTF-8',
+ method: 'POST',
+ success: function(res) {
+ loading.close();
+ if (res.code == 200) {
+ var tableHtml = CreateTable(res.data || []);
+ var planDate = '';
+ if (tableSearchParam.value.fplancommitdate) {
+ planDate = tableSearchParam.value.fplancommitdate.toLocaleString('zh-CN', {
+ timeZone: 'Asia/Shanghai',
+ year: 'numeric',
+ month: '2-digit',
+ day: '2-digit',
+ hour12: false
+ }).slice(0, 10);
+ }
+ var html =
+ "<html><head><meta charset='utf-8' />" +
+ "<style>" +
+ "body{font-family:SimSun,Microsoft YaHei,sans-serif;padding:16px;}" +
+ ".title{text-align:center;font-size:28px;font-weight:700;margin-bottom:12px;}" +
+ ".meta{font-size:14px;margin-bottom:10px;display:flex;justify-content:space-between;}" +
+ ".meta span{display:inline-block;min-width:260px;}" +
+ "</style></head><body>" +
+ "<div class='title'>鐢熸垚棰嗘枡鍗�</div>" +
+ "<div class='meta'><span>鐢熶骇绾匡細" + (depName.value || '') + "</span><span>璁″垝寮�宸ユ棩鏈燂細" + planDate + "</span></div>" +
+ 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);
+ ElementPlus.ElMessage({
+ message: "Excel瀵煎嚭鎴愬姛",
+ type: 'success'
+ });
+ } else {
+ ElementPlus.ElMessage({
+ message: res.msg || "瀵煎嚭澶辫触",
+ type: 'error'
+ });
+ }
+ },
+ error: function() {
+ loading.close();
+ ElementPlus.ElMessage({
+ message: "瀵煎嚭璇锋眰澶辫触锛岃绋嶅悗閲嶈瘯",
+ type: 'error'
+ });
+ }
+ });
}
diff --git a/src/main/webapp/views/erpMaterialwwout/materialwwout.html b/src/main/webapp/views/erpMaterialwwout/materialwwout.html
index 34a9898..c1fba88 100644
--- a/src/main/webapp/views/erpMaterialwwout/materialwwout.html
+++ b/src/main/webapp/views/erpMaterialwwout/materialwwout.html
@@ -833,17 +833,68 @@
});
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);
+ const loading = ElementPlus.ElLoading.service({
+ lock: true,
+ text: '瀵煎嚭涓�...',
+ background: 'rgba(0, 0, 0, 0.7)',
+ });
+ $.ajax({
+ url: "http://127.0.0.1:8133/mo/materialwwout/print",
+ headers: {
+ 'token': localStorage.getItem('token')
+ },
+ data: JSON.stringify({
+ wwRecords: JSON.stringify(selectList.value),
+ izPrint: "鍚�",
+ izRed: 0
+ }),
+ dataType: 'json',
+ contentType: 'application/json;charset=UTF-8',
+ method: 'POST',
+ success: function(res) {
+ loading.close();
+ if (res.code == 200) {
+ var tableHtml = CreateTable(res.data || []);
+ var html =
+ "<html><head><meta charset='utf-8' />" +
+ "<style>" +
+ "body{font-family:SimSun,Microsoft YaHei,sans-serif;padding:16px;}" +
+ ".title{text-align:center;font-size:28px;font-weight:700;margin-bottom:12px;}" +
+ ".meta{font-size:14px;margin-bottom:10px;display:flex;justify-content:space-between;}" +
+ ".meta span{display:inline-block;min-width:260px;}" +
+ "</style></head><body>" +
+ "<div class='title'>濮斿鍔犲伐鍑哄簱鍗�</div>" +
+ "<div class='meta'><span>渚涘簲鍟嗭細" + (depName.value || '') + "</span><span>寮�宸ユ棩鏈燂細" + dateFormat("YYYY-mm-dd", tableSearchParam.value.dateStart) + " 鍒� " + dateFormat("YYYY-mm-dd", tableSearchParam.value.dateEnd) + "</span></div>" +
+ 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);
+ ElementPlus.ElMessage({
+ message: "Excel瀵煎嚭鎴愬姛",
+ type: 'success'
+ });
+ } else {
+ ElementPlus.ElMessage({
+ message: res.msg || "瀵煎嚭澶辫触",
+ type: 'error'
+ });
+ }
+ },
+ error: function() {
+ loading.close();
+ ElementPlus.ElMessage({
+ message: "瀵煎嚭璇锋眰澶辫触锛岃绋嶅悗閲嶈瘯",
+ type: 'error'
+ });
+ }
+ });
}
--
Gitblit v1.9.1