MES-WEB-LayUI.git

			@@ -56,6 +56,18 @@
			<input type="text" class="layui-input ForFilteringSchemes" name="HBillNo" id="HBillNo">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">çç»</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input ForFilteringSchemes" name="HGroupName" id="HGroupName">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">èå</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input ForFilteringSchemes" name="HEmpName" id="HEmpName">
			</div>
			</div>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			@@ -226,6 +238,53 @@

			//#endregion

			//#region åè½¦æ¥è¯¢

			//åæ®å·åè½¦æ¹æ³
			$('#HBillNo').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//çç»åè½¦æ¹æ³
			$('#HGroupName').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//èååè½¦æ¹æ³
			$('#HEmpName').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//èªå®ä¹è¿æ»¤åè½¦æ¹æ³
			$('#ColContent').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//èªå®ä¹è¿æ»¤åè½¦æ¹æ³
			$('#ColContent1').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//èªå®ä¹è¿æ»¤åè½¦æ¹æ³
			$('#ColContent2').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//#endregion


			//#region è¿å¥é¡µé¢å³å è½½

			//#region åå§åçé¢
			@@ -253,7 +312,7 @@
			, height: 'full-50'
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]

			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			@@ -262,7 +321,7 @@
			elem: 'page', //æ³¨æï¼è¿éç page æ¯ IDï¼ä¸ç¨å # å·
			count: 10000, //æ°æ®æ»æ°ï¼ä»æå¡ç«¯å¾å°
			limit: 50,
			limits: [50, 500, 5000, 50000],
			limits: [50, 500, 1000, 2000],
			layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
			jump: function (obj, first) {
			//console.log(obj)
			@@ -565,7 +624,135 @@

			//#region å¯¼åºExecel
			function btn_Export() {
			table.exportFile(ins.config.id, option.data, "xls");
			var data;
			//è®¾ç½®sWhere
			var ajaxLoad = layer.load();
			var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ
			var HEndDate = $("#HEndDate").val();//ç»ææ¥æ
			var HBillNo = $("#HBillNo").val();//åæ®å·
			var HGroupName = $("#HGroupName").val();//çç»
			var HEmpName = $("#HEmpName").val();//èå
			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").val();

			var ColName1 = $("#ColName1").val();//å¤éæ¡
			var Comparator1 = $("#Comparator1").val()
			var ColContent1 = $("#ColContent1").val();
			var ColName2 = $("#ColName2").val();//å¤éæ¡
			var Comparator2 = $("#Comparator2").val()
			var ColContent2 = $("#ColContent2").val();

			if (ColName != 0 && Comparator != 0) {
			var com = "";
			switch (Comparator) {
			case "7":
			com = "like'%" + ColContent + "%'";
			break;
			case "8":
			com = "like'%" + ColContent + "'";
			break;
			case "9":
			com = "like'" + ColContent + "%'";
			break;
			case "10":
			com = "not like'%" + ColContent + "%'";
			break;
			default:
			com = "" + Comparator + "'" + ColContent + "'";
			break;
			}
			sWhere += " and " + ColName + " " + com;
			}
			if (ColName1 != 0 && Comparator1 != 0) {
			var com1 = "";
			switch (Comparator1) {
			case "7":
			com1 = "like'%" + ColContent1 + "%'";
			break;
			case "8":
			com1 = "like'%" + ColContent1 + "'";
			break;
			case "9":
			com1 = "like'" + ColContent1 + "%'";
			break;
			case "10":
			com1 = "not like'%" + ColContent1 + "%'";
			break;
			default:
			com1 = "" + Comparator1 + "'" + ColContent1 + "'";
			break;
			}
			sWhere += " and " + ColName1 + " " + com1;
			}
			if (ColName2 != 0 && Comparator2 != 0) {
			var com2 = "";
			switch (Comparator2) {
			case "7":
			com2 = "like'%" + ColContent2 + "%'";
			break;
			case "8":
			com2 = "like'%" + ColContent2 + "'";
			break;
			case "9":
			com2 = "like'" + ColContent2 + "%'";
			break;
			case "10":
			com2 = "not like'%" + ColContent2 + "%'";
			break;
			default:
			com2 = "" + Comparator + "'" + ColContent + "'";
			break;
			}
			sWhere += " and " + ColName2 + " " + com2;
			}
			if (HBeginDate) {
			sWhere += " and æ¥æ >= '" + HBeginDate + "'";
			}
			if (HEndDate) {
			sWhere += " and æ¥æ <= '" + HEndDate + "'";
			}
			if (HBillNo) {
			sWhere += " and åæ®å· like '%" + HBillNo + "%'";
			}
			if (HGroupName) {
			sWhere += " and çç» like '%" + HGroupName + "%'";
			}
			if (HEmpName) {
			sWhere += " and èååç§° like '%" + HEmpName + "%'";
			}
			$.ajax({
			type: "GET",
			url: GetWEBURL() + '/Pay_SingleBalBillController/GetPay_SingleBalBillList_Json',
			async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
			data: { "sWhere": sWhere, "HMaker": HMaker },
			success: function (data1) {
			if (data1.count == 1) {
			data = data1.data
			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(data1.Message, { icon: 5 });
			}
			},
			error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			sWhere = "";
			data.forEach((item) => {
			for (let itemobj in item) {
			if (item[itemobj] == null) {
			item[itemobj] = "";
			}
			if (item[itemobj].length > 0) { // åè®¾åæ®µåä¸ºfield
			item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			});

			table.exportFile(ins.config.id, data, "xls");
			}
			//#endregion

			@@ -725,42 +912,99 @@
			}
			//#endregion

			////#region æ¹éå®¡æ ¸ï¼num=1ï¼/åå®¡æ ¸ï¼num=2ï¼
			//function set_CheckBillAll(num) {
			// var checkStatus = table.checkStatus('mainTable')
			// , data = checkStatus.data;
			// if (checkStatus.data.length != 0) {
			// var uniqueIds = [...new Set(data.map(obj => obj.hmainid))];//å°å¯¹è±¡æ°ç»idæåå»é
			// var queryString =uniqueIds.join(",");//å°idsåææ°ç»
			// $.ajax({
			// type: "GET",
			// url: GetWEBURL() + "/Pay_SingleBalBillController/CheckAll",
			// async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
			// data: { "ids": queryString, "Type": num, "HMaker": HMaker },
			// success: function (result) {
			// if (result.count == 1) {
			// layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			// // å¾å°frameç´¢å¼
			// var index = layer.getFrameIndex(window.name);
			// //å³éå½åframe
			// layer.close(index);
			// //ä¿®æ¹ä¸ºååå·æ°çé¢
			// $("#btnSearch").trigger('click');
			// });
			// } else {
			// layer.msg(result.Message, { icon: 2, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			// }
			// }, error: function () {
			// layer.msg('éè¯¯' + err, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			// }
			// });
			// }
			// else {
			// layer.msg('è¯·éæ©æ°æ®å®¡æ ¸ï¼');

			// }
			//}
			////#endregion

			//#region æ¹éå®¡æ ¸ï¼num=1ï¼/åå®¡æ ¸ï¼num=2ï¼
			function set_CheckBillAll(num) {
			var checkStatus = table.checkStatus('mainTable')
			, data = checkStatus.data;
			if (checkStatus.data.length != 0) {
			var uniqueIds = [...new Set(data.map(obj => obj.hmainid))];//å°å¯¹è±¡æ°ç»idæåå»é
			var queryString =uniqueIds.join(",");//å°idsåææ°ç»
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/Pay_SingleBalBillController/CheckAll",
			async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
			data: { "ids": queryString, "Type": num, "HMaker": HMaker },
			success: function (result) {
			if (result.count == 1) {
			layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
			// å¾å°frameç´¢å¼
			var index = layer.getFrameIndex(window.name);
			layer.open({
			type: 2
			, area: ['70%', '45%']
			, title: 'åæ®æ¹éå®¡æ ¸æ¡ä»¶'
			, closeBtn: 1
			, shade: 0.6 //é®ç½©éæåº¦
			, maxmin: true //åè®¸å¨å±æå°å
			, anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯
			, content: '../../å·¥èµç®¡ç/å·¥èµç»ç®å(ä¸ªäºº)/Pay_BatchCheck.html'
			, resize: false
			, btn: ['ç¡®å®', 'åæ¶']
			, btn1: function (index, layero) {
			var body = layer.getChildFrame('body', index);
			var HYear = $(body).find("#HYear").val();
			var HPeriod = $(body).find("#HPeriod").val();
			var HGroupID = $(body).find("#HGroupID").val();
			var sWhere = "" + HYear + "," + HPeriod + "," + HGroupID + "," + num + ",'" + HMaker + "' "
			$.ajax({
			url: GetWEBURL() + '/Pay_SingleBalBillController/CheckAllByTimeAndGroup',
			async: false,
			type: "GET",
			dataType: "json",
			data: { "sWhere": sWhere, "HMaker": HMaker },
			success: function (data1) {
			if (data1.count == 1) {
			//å³éå½åframe
			layer.close(index);
			layer.msg("å®¡æ ¸æå", { time: 3 * 1000, icon: 1 });
			//ä¿®æ¹ä¸ºååå·æ°çé¢
			$("#btnSearch").trigger('click');
			});
			} else {
			layer.msg(result.Message, { icon: 2, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			} else {
			layer.close(index);
			layer.alert(data1.Message, { icon: 5 });
			}
			}, error: function (e) {
			layer.close(index);
			layer.alert(e.statusText, { icon: 5 });
			}
			}, error: function () {
			layer.msg('éè¯¯' + err, { icon: 5, btn: ['ç¡®è®¤'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "æ¸©é¦¨æç¤º" });
			}
			});
			}
			else {
			layer.msg('è¯·éæ©æ°æ®å®¡æ ¸ï¼');

			}
			});
			}
			, btn2: function (index, layero) {
			//æé®ãæé®äºãçåè°
			//return false å¼å¯è¯¥ä»£ç å¯ç¦æ¢ç¹å»è¯¥æé®å³é
			},
			end: function () {

			}
			, cancel: function () {

			}
			})
			}
			//#endregion


			//#region å³éï¼num=1ï¼/åå³éï¼num=2ï¼
			function set_CloseBill(num) {
			@@ -885,6 +1129,11 @@
			form.on('submit(btnReSearch)', function (data) {
			//æ¸ç©ºè¿æ»¤æ¡ä»¶
			set_ClearQuery();
			if (page != 1) {
			$("#page a:eq(1)").get(0).click();//ç¹å»åé¡µæ ç¬¬ä¸é¡µ
			} else {
			get_FastQuery();
			}
			});

			//éç½®è¿æ»¤æ¡ä»¶
			@@ -892,6 +1141,8 @@
			$("#HBeginDate").val(Pub_Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ
			$("#HEndDate").val(Pub_Format(new Date(), "yyyy-MM-dd"));;//ç»ææ¥æ
			$("#HBillNo").val("");//åæ®å·
			$("#HGroupName").val("");
			$("#HEmpName").val("");
			$("#ColContent").val("");
			$("#ColName").val("0");
			$("#Comparator").val("0");
			@@ -921,6 +1172,8 @@
			var HBeginDate = $("#HBeginDate").val();//å¼å§æ¥æ
			var HEndDate = $("#HEndDate").val();//ç»ææ¥æ
			var HBillNo = $("#HBillNo").val();//åæ®å·
			var HGroupName = $("#HGroupName").val();//çç»
			var HEmpName = $("#HEmpName").val();//èå
			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").val();
			@@ -1004,6 +1257,12 @@
			if (HBillNo) {
			sWhere += " and åæ®å· like '%" + HBillNo + "%'";
			}
			if (HGroupName) {
			sWhere += " and çç» like '%" + HGroupName + "%'";
			}
			if (HEmpName) {
			sWhere += " and èååç§° like '%" + HEmpName + "%'";
			}
			get_DisplayPage(sWhere);
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}