From 8a36bbee40f5e1069b15a98b1e64ac9719ee8a46 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 23 四月 2024 17:17:13 +0800
Subject: [PATCH] 1.销售出库单 增加 反写源单 销售订单和发货通知单 超出 关联数量 关闭源单 2.应收单 增加 反写源单 销售出库单 和 销售订单 超出关联数量 关闭源单 3.动态获取源单增加参数 Num 0蓝单 1红单 2全部 4.销售流程的测试并完善功能； 销售订单-》发货通知单-》销售出库单-》应收单 （注意： 源单类型的下拉框 需要 根据数据库 表动态加载， 关联数量 要准确 ， 审核 且 未关闭 未行关闭的行 才能下推 ，关联数量超额后，要 反写 关闭 源单 ）
---
WebTM/views/销售管理/销售订单/Xs_SeOrderBillList.html | 414 +++++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 361 insertions(+), 53 deletions(-)
diff --git "a/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\224\200\345\224\256\350\256\242\345\215\225/Xs_SeOrderBillList.html" "b/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\224\200\345\224\256\350\256\242\345\215\225/Xs_SeOrderBillList.html"
index b2b3111..f82cbef 100644
--- "a/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\224\200\345\224\256\350\256\242\345\215\225/Xs_SeOrderBillList.html"
+++ "b/WebTM/views/\351\224\200\345\224\256\347\256\241\347\220\206/\351\224\200\345\224\256\350\256\242\345\215\225/Xs_SeOrderBillList.html"
@@ -10,13 +10,11 @@
<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
<!--<script src="../../../layuiadmin/layui/layui.js"></script>-->
<script src="../../../layuiadmin/layui/layui.js"></script>
- <script src="../../../layuiadmin/layui/layui.js"></script>
<script src="../../../layuiadmin/Scripts/json2.js"></script>
<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
<script src="../../../layuiadmin/PubCustom.js"></script>
<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
-
<script src="../../../layuiadmin/soulTable.slim.js"></script>
<script src="../../../layuiadmin/HideButton.js"></script>
<script src="../../../layuiadmin/PageTitle.js"></script>
@@ -86,15 +84,15 @@
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">閮ㄩ棬</label>
+ <label class="layui-form-label">鐗╂枡浠ｇ爜</label>
<div class="layui-input-block">
- <input type="text" class="layui-input ForFilteringSchemes" name="HDeptID" id="HDeptID" style="width:190px;">
+ <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber" style="width:190px;">
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">涓荤</label>
+ <label class="layui-form-label">鐗╂枡鍚嶇О</label>
<div class="layui-input-block">
- <input type="text" class="layui-input ForFilteringSchemes" name="HMangerID" id="HMangerID" style="width:190px;">
+ <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName" style="width:190px;">
</div>
</div>
</div>
@@ -143,6 +141,7 @@
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushReceivableBills" id="btn-PushReceivableBills"><i class="layui-icon layui-icon-delete"></i>澶氳涓嬫帹(搴旀敹鍗�)</button>
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" 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" style="display:none;" lay-event="get_LookDown" id="get_LookDown"><i class="layui-icon layui-icon-refresh-3"></i>涓嬫煡</button>
+ <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_needClose" id="get_needClose"><i class="layui-icon layui-icon-refresh-3"></i>寰呭叧闂」</button>
<!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-print" id="btn-print"><i class="layui-icon layui-icon-print"></i>鎵撳嵃</button>-->
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>瀹℃牳</button>
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>鍙嶅鏍�</button>
@@ -153,10 +152,12 @@
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_Drop" id="set_Drop"><i class="layui-icon layui-icon-radio"></i>浣滃簾</button>
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_DeDrop" id="set_DeDrop"><i class="layui-icon layui-icon-radio"></i>鍙嶄綔搴�</button>
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="btn-print" lay-event="btn-print"><i class="layui-icon layui-icon-form"></i>鎵撳嵃</button>
+ <button type="button" class="layui-btn layui-btn-sm" style="display:none;" 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" style="display:none;" lay-event="HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>闅愯棌鍒楄缃�</button>
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>鎸夐挳璁剧疆</button>
- <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>淇濆瓨鏂规</button>
- <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>璇诲彇鏂规</button>
+ <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>淇濆瓨鏂规</button>
+ <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>璇诲彇鏂规</button>
+ <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_QueryCondition" id="set_QueryCondition"><i class="layui-icon layui-icon-set"></i>楂樼骇杩囨护</button>-->
<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>閫�鍑�</button>
</div>
</script>
@@ -170,6 +171,7 @@
<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
<script src="../../../layuiadmin/Scripts/webConfig.js"></script>-->
<script>
+ var GetDataCols = "";
layui.config({
base: '../../../layuiadmin/' //闈欐�佽祫婧愭墍鍦ㄨ矾寰�
}).extend({
@@ -191,6 +193,12 @@
var option = [];
var HModName = "Xs_SeOrderBill";
var HBillType = "1401";
+
+
+ var ins; //鐢ㄤ簬瀵煎嚭excel
+ //璁板綍杩囨护鏉′欢鐢ㄤ簬鎺掑簭鏃惰幏鍙栨暟鎹�
+ var sWhere_Bak = "";
+ var get_needClose_Bar = 0;
//#region 銆愬姩鎬佽幏鍙栨ā鍧楀悕绉般��
var HModuleType = "1401";
@@ -221,6 +229,8 @@
//#region 鐩戝惉浜嬩欢
//#region 鏌ヨ鎸夐挳
form.on('submit(btnSearch)', function (data) {
+ //鏍囪褰撳墠鏁版嵁涓� 鏌ヨ鏁版嵁
+ get_needClose_Bar = 0;
get_FastQuery(table, option);
});
//#endregion
@@ -286,6 +296,10 @@
case 'get_LookDown':
set_LookDown();
break;
+ //寰呭叧闂」
+ case 'get_needClose':
+ get_needClose();
+ break;
//鍒锋柊
case 'get_Refresh': get_Refresh();
break;
@@ -319,6 +333,10 @@
//鎵撳嵃
case 'btn-print': get_PrintReport();
break;
+ //瀵煎嚭excel
+ case 'get_export':
+ get_Export();
+ break;
//闅愯棌鍒楄缃�
case 'HideColumn':
get_HideColumn();
@@ -334,7 +352,53 @@
//璇诲彇鏂规
case 'set_ReadScheme': set_ReadScheme();
break;
+ //楂樼骇杩囨护
+ case 'set_QueryCondition':
+ set_QueryCondition();
+ break;
};
+ });
+ //#endregion
+
+ //#region 鐩戝惉鎺掑簭浜嬩欢
+ table.on('sort(mainTable)', function (obj) {
+ // 鑾峰彇鎺掑簭瀛楁鍜岀被鍨�
+ var field = obj.field;
+ var type = obj.type;
+ //璁板綍杩囨护鏉′欢
+ var temp = sWhere_Bak;
+
+ //涓鸿繃婊ゆ潯浠跺鍔犳帓搴�
+ sWhere_Bak += " order by " + field + " " + (type == "null" ? "" : type) + " ";
+
+ //鑾峰彇鎺掑簭鍚庣殑鏁版嵁骞堕噸鏂版覆鏌�
+ var ajaxLoad = layer.load();
+ $.ajax({
+ url: GetWEBURL() + '/Xs_SeOrderBill/sortList',
+ async: false,
+ type: "GET",
+ data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"] },
+ success: function (data1) {
+ if (data1.count == 1) {
+
+ option.data = data1.data;
+ table.render(option);
+ layer.close(ajaxLoad);
+
+ if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
+ ColFilter();
+ }
+ } else {
+ layer.close(ajaxLoad);
+ layer.alert(data1.code + data1.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.close(ajaxLoad);
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+
+ sWhere_Bak = temp;
});
//#endregion
@@ -455,6 +519,7 @@
, { field: '閲戦', title: '閲戦', sort: true, totalRow: true }
, { field: '浠风◣鍚堣', title: '浠风◣鍚堣', sort: true, totalRow: true }
, { field: '琛ㄥご澶囨敞', title: '琛ㄥご澶囨敞', sort: true }
+ , { field: '鍓╀綑璁㈤噾', title: '鍓╀綑璁㈤噾', sort: true, totalRow: true }
, { field: '鍏宠仈鏁伴噺', title: '閿�鍞嚭搴撳叧鑱旀暟閲�', sort: true, totalRow: true }
, { field: '鏈叧鑱旀暟閲�', title: '閿�鍞嚭搴撴湭鍏宠仈鏁伴噺', sort: true, totalRow: true }
, { field: '鐢熶骇鍏宠仈鏁伴噺', title: '鐢熶骇鍏宠仈鏁伴噺', sort: true, totalRow: true }
@@ -497,12 +562,25 @@
//, { field: '璁″垝璺熻釜鍙�', title: '璁″垝璺熻釜鍙�', sort: true }
//, { field: '琛ㄤ綋澶囨敞', title: '琛ㄤ綋澶囨敞', sort: true }
]]
- , done: function () {
+ , done: function (res, curr, count) {
soulTable.render(this);
//鍒锋柊鎸夐挳鏄剧ず
var btns = document.getElementsByTagName("button"); //鑾峰彇鏈〉鎵�鏈夋寜閽璞�
Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
+
+ //寰幆琛ㄦ暟鎹牴鎹甪lag鐘舵�佺粰琛屼笂鑹�
+ //$.each(res['data'], function (i, j) {
+ // var HIsUsingMoney = j['鍓╀綑璁㈤噾'] * 1;
+ // var HRowCloseMan = j['琛屽叧闂汉'];
+ // var HCloseMan = j['鍏抽棴浜�'];
+ // if ((HIsUsingMoney <= 500 && HIsUsingMoney > 0) && HRowCloseMan == "" && HCloseMan == "") {
+ // Layui_SetDataTableRowColor('table', i + 1, 'red');
+ // } else {
+ // Layui_SetDataTableRowColor('table', i + 1, 'black');
+ // }
+
+ //});
}
};
}
@@ -544,7 +622,7 @@
option.data = result;
- table.render(option);
+ ins = table.render(option);
layer.close(ajaxLoad);
//鍒锋柊鎸夐挳鏄剧ず
@@ -573,7 +651,8 @@
var HDate1 = $("#HEndDate").val();//缁撴潫鏃ユ湡
var HBillNo = $("#HBillNo").val();//鍗曟嵁鍙�
var HCusID = $("#HCusID").val();
- var HDeptID = $("#HDeptID").val();
+ var HMaterNumber = $("#HMaterNumber").val();
+ var HMaterName = $("#HMaterName").val();
var HMangerID = $("#HMangerID").val();
var ColName = $("#ColName").val();//澶嶉�夋
var Comparator = $("#Comparator").val()
@@ -612,11 +691,14 @@
if (HCusID) {
sWhere += " and 瀹㈡埛 like '%" + HCusID + "%'";
}
- if (HDeptID) {
- sWhere += " and 閮ㄩ棬 like '%" + HDeptID + "%'";
+ if (HMaterNumber) {
+ sWhere += " and 鐗╂枡浠ｇ爜 like '%" + HMaterNumber + "%'";
}
- if (HMangerID) {
- sWhere += " and 涓荤 like '%" + HMangerID + "%'";
+ if (HMaterName) {
+ sWhere += " and 鐗╂枡鍚嶇О like '%" + HMaterName + "%'";
+ }
+ if (GetDataCols != "") {
+ sWhere += GetDataCols;
}
sWhere += addSWhereByOpenType();
@@ -624,8 +706,11 @@
//鏍规嵁鐢ㄦ埛杩囨护鐢ㄦ埛鍏宠仈瀹㈡埛鐨勮褰�
sWhere += getSWhereByHUser();
+ sWhere_Bak = sWhere;
+
get_Display(sWhere);
sWhere = "";//璋冪敤鎺ュ彛鍚庢竻绌簊Where缂撳瓨
+ GetDataCols = "";
}
//#endregion
@@ -635,8 +720,8 @@
$("#HDate1").val("");//缁撴潫鏃ユ湡
$("#HBillNo").val("");//
$("#HCusID").val("");
- $("#HDeptID").val("");
- $("#HMangerID").val("");
+ $("#HMaterNumber").val("");
+ $("#HMaterName").val("");
$("#ColContent").val("");
$("#ColName").val("0");
$("#Comparator").val("0");
@@ -687,8 +772,12 @@
maxmin: true,
content: '../../閿�鍞鐞�/閿�鍞鍗�/Add_Edit_Xs_SeOrderBillList.html?OperationType=1&linterid=0&HSouceBillType=0&closeType=1',
end: function () {
- //鍒锋柊椤甸潰,
- $("#btnSearch").trigger('click');
+ //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
},
success: function (layero, index) {
@@ -714,8 +803,12 @@
, content: '../../閿�鍞鐞�/閿�鍞鍗�/Add_Edit_Xs_SeOrderBillList.html?OperationType=2&linterid=' + hID + '&HSouceBillType=0&closeType=1'
, resize: false,
end: function () {
- //鍒锋柊椤甸潰,
- $("#btnSearch").trigger('click');
+ //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
}
, cancel: function () {
@@ -745,8 +838,12 @@
, content: '../../閿�鍞鐞�/閿�鍞鍗�/Add_Edit_Xs_SeOrderBillList.html?OperationType=3&linterid=' + hID + '&HSouceBillType=0&closeType=1'
, resize: false,
end: function () {
- //鍒锋柊椤甸潰,
- $("#btnSearch").trigger('click');
+ //淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
}
, cancel: function () {
@@ -778,8 +875,12 @@
var index = layer.getFrameIndex(window.name);
//鍏抽棴褰撳墠frame
layer.close(index);
- //淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
});
} else {
@@ -821,8 +922,12 @@
, content: '../../閿�鍞鐞�/閿�鍞鍗曞彉鏇村崟/Xs_SeOrderChangeBill.html?OperationType=4&linterid=' + hID + '&HSouceBillType=1401&closeType=1'
, resize: false,
end: function () {
- //鍒锋柊椤甸潰,
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
, cancel: function () {
@@ -859,8 +964,12 @@
, content: '../../閿�鍞鐞�/鐗规壒鐢宠鍗�/Xs_ExceptiveCheckRequestBill.html?OperationType=4&linterid=' + hID + '&HSouceBillType=1401&closeType=1'
, resize: false,
end: function () {
- //鍒锋柊椤甸潰,
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
, cancel: function () {
@@ -898,8 +1007,12 @@
, content: '../../鐢熶骇绠＄悊/鐢熶骇浠诲姟鍗�/Sc_ICMOBillEdit_NoTable.html?OperationType=4&linterid=' + hID + '&hsubid=' + hsubid
, resize: false,
end: function () {
- //鍒锋柊椤甸潰,
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
, cancel: function () {
@@ -964,8 +1077,12 @@
, btn: [],
// 鎸夐挳1 鐨勫洖璋�
end: function (index, layero, that) {
- //鍒锋柊椤甸潰
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
})
} else {
@@ -990,16 +1107,16 @@
, "HSourceBillType": "1401"
}
dataArray.push(temp);
- if (data[i].鐘舵�� != "宸插鏍�") {
- var err = "涓嬫帹澶辫触!鍗曟嵁銆�" + data[i].鍗曟嵁鍙� + "銆戠殑鐘舵�佷负鈥�" + data[0].鐘舵�� + "鈥�,涓嶅厑璁镐笅鎺紒";
- layer.alert(err, { icon: 5 });
- return;
- }
+ //if (data[i].鐘舵�� != "宸插鏍�") {
+ // var err = "涓嬫帹澶辫触!鍗曟嵁銆�" + data[i].鍗曟嵁鍙� + "銆戠殑鐘舵�佷负鈥�" + data[0].鐘舵�� + "鈥�,涓嶅厑璁镐笅鎺紒";
+ // layer.alert(err, { icon: 5 });
+ // return;
+ //}
- if (data[i].琛岀姸鎬� == "宸插叧闂�") {
- layer.msg("涓嬫帹澶辫触!鍗曟嵁鍙枫��" + data[i].鍗曟嵁鍙� + "銆戜笅閫変腑鐨勮褰曚腑瀛樺湪宸插叧闂姸鎬佺殑璁板綍!");
- return;
- }
+ //if (data[i].琛岀姸鎬� == "宸插叧闂�") {
+ // layer.msg("涓嬫帹澶辫触!鍗曟嵁鍙枫��" + data[i].鍗曟嵁鍙� + "銆戜笅閫変腑鐨勮褰曚腑瀛樺湪宸插叧闂姸鎬佺殑璁板綍!");
+ // return;
+ //}
if (data[i].瀹㈡埛 != HCusName) {
layer.msg("涓嬫帹澶辫触!宸茬粡閫変腑鐨勮褰曚腑瀛樺湪涓嶅悓瀹㈡埛!");
@@ -1026,8 +1143,12 @@
, btn: ['纭畾'],
// 鎸夐挳1 鐨勫洖璋�
end: function (index, layero, that) {
- //鍒锋柊椤甸潰
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
})
} else {
@@ -1088,8 +1209,12 @@
, btn: ['纭畾'],
// 鎸夐挳1 鐨勫洖璋�
end: function (index, layero, that) {
- //鍒锋柊椤甸潰
- $("#btnSearch").trigger('click');
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
})
} else {
@@ -1115,8 +1240,12 @@
, content: '../../閿�鍞鐞�/閿�鍞鍗�/Xs_SeOrderBill_LookDown.html?linterid=' + hID + '&HSouceBillType=1401&closeType=1'
, resize: false,
end: function () {
- //鍒锋柊椤甸潰,
- /* $("#btnSearch").trigger('click');*/
+ ////淇敼涓哄姛鍚庡埛鏂扮晫闈�
+ //if (get_needClose_Bar == 0) {
+ // $("#btnSearch").trigger('click');
+ //} else if (get_needClose_Bar == 1) {
+ // $("#get_needClose").trigger('click');
+ //}
}
, cancel: function () {
@@ -1125,6 +1254,70 @@
} else {
layer.msg('璇烽�夋嫨涓�琛屾暟鎹紪杈戯紒');
}
+ }
+ //#endregion
+
+ //#region 寰呭叧闂」
+ function get_needClose() {
+ //璁板綍杩囨护鏉′欢
+ var temp = sWhere_Bak;
+ //鏍囪褰撳墠鏁版嵁涓� 寰呭叧闂」
+ get_needClose_Bar = 1;
+
+ //涓鸿繃婊ゆ潯浠跺鍔犳帓搴�
+ sWhere_Bak += " and 鍓╀綑璁㈤噾>0 and 鍓╀綑璁㈤噾<=500 and 鍏抽棴浜�='' and 琛屽叧闂汉='' and 鐘舵�� = '宸插鏍�' order by 鍗曟嵁鍙� desc";
+
+ //鑾峰彇鎺掑簭鍚庣殑鏁版嵁骞堕噸鏂版覆鏌�
+ var ajaxLoad = layer.load();
+ $.ajax({
+ url: GetWEBURL() + '/Xs_SeOrderBill/sortList',
+ async: false,
+ type: "GET",
+ data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"] },
+ success: function (data1) {
+ if (data1.count == 1) {
+
+ //璁剧疆鍒楄〃鍚屼竴涓崟鎹彧鏈夌涓�鏉℃暟鎹樉绀轰富琛ㄤ俊鎭紝鍏跺畠璁板綍鍙樉绀哄瓙琛ㄤ俊鎭�
+ //鑾峰彇瀛愯〃鍒楁暟鎹�
+ var colList = [];
+ for (var i = 0; i < option.cols[0].length; i++) {
+ colList.push(option.cols[0][i].field);
+ }
+ //璁剧疆鏁版嵁
+ var result = data1.data;
+ var temp = "";
+ for (var i = 0; i < result.length; i++) {
+ if (temp != result[i]["hmainid"]) {
+ temp = result[i]["hmainid"];
+ } else {
+ var initIndex = $.inArray("hmainid", colList);
+ var lastIndex = $.inArray("hsubid", colList);
+ for (var j = initIndex + 1; j < lastIndex; j++) {
+ var fieldName = colList[j];
+ result[i][fieldName] = "";
+ }
+ }
+ }
+
+
+ option.data = result;
+ table.render(option);
+ layer.close(ajaxLoad);
+
+ if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
+ ColFilter();
+ }
+ } else {
+ layer.close(ajaxLoad);
+ layer.alert(data1.code + data1.Message, { icon: 5 });
+ }
+ }, error: function () {
+ layer.close(ajaxLoad);
+ layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
+ }
+ });
+
+ sWhere_Bak = temp;
}
//#endregion
@@ -1153,7 +1346,11 @@
//鍏抽棴褰撳墠frame
layer.close(index);
//淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
});
} else {
@@ -1189,7 +1386,11 @@
//鍏抽棴褰撳墠frame
layer.close(index);
//淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
});
} else {
@@ -1226,7 +1427,11 @@
//鍏抽棴褰撳墠frame
layer.close(index);
//淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
});
} else {
@@ -1262,7 +1467,11 @@
//鍏抽棴褰撳墠frame
layer.close(index);
//淇敼涓哄姛鍚庡埛鏂扮晫闈�
- $("#btnSearch").trigger('click');
+ if (get_needClose_Bar == 0) {
+ $("#btnSearch").trigger('click');
+ } else if (get_needClose_Bar == 1) {
+ $("#get_needClose").trigger('click');
+ }
});
} else {
@@ -1304,6 +1513,28 @@
else {
layer.msg('璇烽�夋嫨涓�琛屾暟鎹墦鍗帮紒');
}
+ }
+ //#endregion
+
+ //#region 瀵煎嚭Execel
+ function get_Export() {
+ var ModRightNameCheck = "Xs_SeOrderBillList_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
@@ -1416,6 +1647,24 @@
layer.alert("鎺ュ彛璇锋眰澶辫触!", { icon: 5 });
}
})
+ }
+ //#endregion
+
+ //#region 缁檛able琛屼笂鑹�
+ function Layui_SetDataTableRowColor(TabDivId, RowIndex, ColorString) {
+ try {
+ var div = $("[lay-id='mainTable'] tr:eq(" + RowIndex + ")");
+ if (div != null) //鎵惧埌瀵硅薄浜�
+ {
+ // console.log(div);
+ div.css("color", ColorString);
+
+ } else {
+ console.log('娌℃湁鎵惧埌瀵硅薄');
+ }
+ } catch (e) {
+ console.log(e.message);
+ }
}
//#endregion
@@ -1627,6 +1876,63 @@
//#endregion
+ //楂樼骇杩囨护
+ function set_QueryCondition() {
+ var colName = "";
+ var contentUrl = "";
+ for (var i = 0; i < option.cols[0].length; i++) {
+ if (option.cols[0][i]["field"] != undefined && option.cols[0][i]["hide"] != true) {
+ colName += option.cols[0][i]["title"] + ",";
+ }
+ }
+ var urlStr = window.document.location.pathname;//鑾峰彇鏂囦欢璺緞
+ var urlLen = urlStr.split('/');
+ for (var i = 0; i < urlLen.length - 4; i++) {
+ contentUrl += "../";
+ }
+ colName = encodeURI(colName.substring(0, colName.length - 1));//瀵� URI 杩涜缂栫爜
+
+ var HModBillName = "h_v_IF_SeOrderBillList";//绛変簬璇ュ垪琛ㄧ殑瑙嗗浘
+
+ contentUrl += '鍩虹璧勬枡/闅愯棌鍒楄缃�/Gy_QueryCondition.html?HModName=' + HModBillName + '&colName=' + colName;
+
+ layer.open({
+ type: 2
+ , skin: "layui-layer-rim" //鍔犱笂杈规
+ , title: "楂樼骇杩囨护" //鏍囬
+ , closeBtn: 1 //绐椾綋鍙充笂瑙掑叧闂� 鐨� 鏍峰紡
+ , shift: 2 //寮瑰嚭鍔ㄧ敾
+ , area: ["50%", "80%"] //绐椾綋澶у皬
+ , maxmin: true //璁剧疆鏈�澶ф渶灏忔寜閽槸鍚︽樉绀�
+ , content: [contentUrl, "yes"]
+ , btn: ["纭畾", "鍙栨秷"]
+ , btn1: function (index, laero) {
+ var iframeWindow = window["layui-layer-iframe" + index];//鑾峰彇寮规椤甸潰
+ var checkStatus = iframeWindow.layui.table.cache["mainTable"];//鑾峰彇閫変腑鐨勬暟鎹�
+ if (checkStatus.length == 0) {
+ return layer.msg("璇疯緭鍏ヨ繃婊ゆ潯浠�!");
+ }
+ var myIframe = window[laero.find('iframe')[0]['name']];
+ GetDataCols += "and (";
+ for (var i = 0; i < checkStatus.length; i++) {
+ GetDataCols += myIframe.get_FastQuery(checkStatus[i]) ; //get_FastQuery()涓哄瓙椤甸潰鐨勬柟娉�
+ if ((i + 1) < checkStatus.length) {
+ GetDataCols += " " + checkStatus[i]["HRelationCol"]+" ";
+ }
+ }
+ GetDataCols += ")";
+ //鏇存柊琛ㄦ牸缂撳瓨鐨勬暟鎹�
+ layer.close(index);//鍏抽棴寮圭獥
+ }
+ , end: function () {
+ if (GetDataCols != "") {
+ get_FastQuery();
+ }
+ }
+ })
+ }
+
+
//#region 鍒楁槑鏄剧ず涓嬫媺妗�
function ColFilter() {
var Organization = '<option value="0" selected="selected" ></option>';
@@ -1735,7 +2041,9 @@
});
}
//#endregion
-
+ function GetDataCol(data) {
+ GetDataCols = data;
+ }
</script>
--
Gitblit v1.9.1