From d6db3fa707f470fd8a6160c6daf6bcea75b8a6ce Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 06 六月 2024 15:18:45 +0800
Subject: [PATCH] 上下模单优化
---
WebTM/views/应收管理/报表分析/Xs_CusBalanceReport.html | 62 +++++++++++++++++++++++++++++-
1 files changed, 59 insertions(+), 3 deletions(-)
diff --git "a/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_CusBalanceReport.html" "b/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_CusBalanceReport.html"
index a396aae..c02a277 100644
--- "a/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_CusBalanceReport.html"
+++ "b/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_CusBalanceReport.html"
@@ -86,6 +86,7 @@
<script type="text/html" id="toolbarDemo">
<div class="layui-btn-container">
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>鍒锋柊</button>
+ <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>瀵煎嚭</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>鍒楄缃�</button>
<button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>鎸夐挳璁剧疆</button>
@@ -115,7 +116,9 @@
var sWhere = "";
var HModName = "Xs_CusBalanceReport";
//涓嶉渶瑕佹樉绀虹殑瀛楁 鍙墿灞�
- var titleData = ["瀹㈡埛鍐呯爜","甯佸埆鍐呯爜","缁勭粐鍐呯爜"];
+ var titleData = ["瀹㈡埛鍐呯爜", "甯佸埆鍐呯爜", "缁勭粐鍐呯爜"];
+
+ var ins; //鐢ㄤ簬瀵煎嚭excel
//#endregion
//#region 杩涘叆椤甸潰鍗冲姞杞�
@@ -131,6 +134,10 @@
switch (obj.event) {
//鍒锋柊
case 'get_Refresh': get_Refresh();
+ break;
+ //瀵煎嚭excel
+ case 'get_export':
+ get_Export();
break;
//閫�鍑烘寜閽�
case 'get_Exit': Pub_Close(2);
@@ -270,7 +277,7 @@
col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //闅愯棌id鍒�
}
else if ($.inArray(data[i].name, totalArray) > -1) {
- col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
+ col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120,templet: "<div>{{d." + data[i].name + " ==null ?'':fixed(d." + data[i].name + ")}}</div>" });
}
else {
switch (data[i].Type) {
@@ -286,7 +293,7 @@
option.cols = [col];
option.data = data1.data;
- table.render(option);
+ ins = table.render(option);
//鍒锋柊鎸夐挳鏄剧ず
var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
@@ -388,6 +395,28 @@
//#region 鍒锋柊
function get_Refresh() {
$("#btnSearch").trigger('click');
+ }
+ //#endregion
+
+ //#region 瀵煎嚭Execel
+ function get_Export() {
+ var ModRightNameCheck = "Xs_CusBalanceReport_ExportExcel";
+
+ //閫昏緫瀹℃牳鏂规硶
+ $.ajax({
+ type: "GET",
+ url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //鏂规硶鎵�鍦ㄩ〉闈㈠拰鏂规硶鍚�
+ data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
+ success: function (result) {
+ if (result.count == 1) {
+ table.exportFile(ins.config.id, option.data, "xls");
+ } else {
+ layer.alert("褰撳墠妯″潡娌℃湁瀵煎嚭鏉冮檺!", { icon: 5 });
+ }
+ }, error: function () {
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
}
//#endregion
@@ -545,6 +574,7 @@
});
res = res.replace("HCusID", "瀹㈡埛鍐呯爜");
+ res = res.replaceAll("'", "''");
return res;
}
@@ -553,6 +583,32 @@
//#endregion
+ //#region 灏嗘暟鎹鍔犲崈鍒嗕綅
+ function fixed(str) {
+ if (str !== '' && str != null) {
+ if (str === 0) { //褰撲负0鏃讹紝涓嶇敤澶勭悊
+ return 0;
+ } else {
+ var str1 = str + "";
+ var real = str1.split('.')[0]; //鏁存暟閮ㄥ垎
+ var realQty = real.length;
+ var dotQty = str1.length - realQty - 1;
+
+ if (dotQty > 0) {
+ return str.toFixed(dotQty).replace(/(\d)(?=(\d{3})+\.)/g, '$1,');
+ } else {
+ var temp = str.toFixed(1).replace(/(\d)(?=(\d{3})+\.)/g, '$1,') + "";
+ temp = temp.split('.')[0];
+ return temp;
+ }
+ }
+ } else {
+ return '';
+ }
+ return str;
+ }
+ //#endregion
+
//浠ヤ笂鏄痩ayui妯″潡
</script>
--
Gitblit v1.9.1