From 29a92fcf4fc990763d08c8d88ee4f9b1c8bf2e80 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 29 六月 2023 10:03:31 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/zymesSrmLayUi
---
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html | 30 ++++++++++++++++++++++++++++--
1 files changed, 28 insertions(+), 2 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
index 475df62..5ca3aad 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList.html
@@ -181,6 +181,7 @@
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>鐢熸垚閫佽揣鍗�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>閫�鍑�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>闅愯棌鍒楄缃�</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>瀵煎嚭</button>
</div>
</script>
</div>
@@ -229,14 +230,15 @@
base: '../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
index: 'lib/index' //涓诲叆鍙ｆā鍧�
- }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
+ }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
var $ = layui.$
, admin = layui.admin
, layer = layui.layer
, laydate = layui.laydate
, table = layui.table
, form = layui.form
- , element = layui.element;
+ , element = layui.element
+ , excel = layui.excel;
//甯歌鐢ㄦ硶
laydate.render({
elem: '#HDate1'
@@ -880,6 +882,30 @@
}
});
break;
+ case 'set_dao':
+ //鑾峰彇鍒楄〃鍒楁暟鎹簮
+ var ColName = [];
+ for (var i = 1; i < option.cols[0].length; i++) {
+ if (option.cols[0][i]["hide"] != true) {
+ ColName.push(option.cols[0][i]["field"]);
+ }
+ }
+ //缁戝畾鏁版嵁
+ var data = excel.filterExportData(option.data, ColName)
+
+ //璧嬪�间簬琛ㄥご鍒楀悕
+ var Title = [];
+ for (var i = 0; i < ColName.length; i++) {
+ Title.push("\"" + ColName[i] + "\":\"" + ColName[i] + "\"");
+ }
+ var TitleName = JSON.parse("{" + Title.toString() + "}");
+ data.unshift(TitleName);
+
+ //瀵煎嚭 sheet1 宸ヤ綔琛ㄥ悕
+ excel.exportExcel({
+ sheet1: data
+ }, '閲囪喘璁㈠崟鍒楄〃.xlsx', 'xlsx');
+ break;
};
});
});
--
Gitblit v1.9.1