MES-WEB-LayUI.git

			@@ -34,17 +34,35 @@
			</div>
			</div>
			<!--<div class="layui-inline">
			<label class="layui-form-label">ç¶æ</label>
			<div class="layui-input-block" style="margin-left: 120px;width: 184px;">
			<select name="HState" lay-verify="HState" id="HState">
			<option value="0" selected="selected">å¨é¨</option>
			<option value="1">æªå¼å·¥</option>
			<option value="3">å·²å¥åº</option>
			</select>
			<label class="layui-form-label">ç¶æ</label>
			<div class="layui-input-block" style="margin-left: 120px;width: 184px;">
			<select name="HState" lay-verify="HState" id="HState">
			<option value="0" selected="selected">å¨é¨</option>
			<option value="1">æªå¼å·¥</option>
			<option value="3">å·²å¥åº</option>
			</select>
			</div>
			</div>-->
			<div class="layui-form layui-inline" style="position:relative;top:10px;">
			<label class="layui-form-label">æ¥æ</label>
			<div class="layui-form-item layui-inline">
			<div class="layui-inline">
			<div class="layui-input-inline">
			<input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss">
			</div>
			</div>
			</div>
			</div>-->
			<div class="layui-inline">
			<label class="layui-form-label">ä¸è¾¾æ¥æ</label>
			<div class="layui-form-item layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label">-</label>
			<div class="layui-input-inline">
			<input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss">
			</div>
			</div>
			</div>
			</div>
			<!--<div class="layui-inline">
			<label class="layui-form-label">æ¥æ</label>
			<div class="layui-input-block">
			<input type="date" class="layui-input" id="HBeginDate" style="width:190px;">
			</div>
			@@ -54,21 +72,27 @@
			<div class="layui-input-block">
			<input type="date" class="layui-input" id="HEndDate" style="width:190px;">
			</div>
			</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>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button>
			<!--<div class="layui-inline">
			<div style="padding-left: 10px;">
			<input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="æªä¸æ¨åå·²å¥åº">
			<div class="layui-inline">
			<label class="layui-form-label">åè®¡å¬æ¤æ°</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="text" class="layui-input" name="SumHMaterOutQty" id="SumHMaterOutQty" disabled="disabled">
			</div>
			</div>-->
			</div>
			<!--<div class="layui-inline">
			<div style="padding-left: 10px;">
			<input type="checkbox" name="checkWRuku" id="checkWRuku" lay-skin="primary" lay-filter="checkWRuku" title="æªä¸æ¨åå·²å¥åº">
			</div>
			</div>-->
			<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:10px;">
			<!--å¶ä»æ¡ä»¶-->
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">ç©æä»£ç </label>
			<label class="layui-form-label" style="width: 85px;">äº§åä»£ç </label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber">
			</div>
			@@ -156,6 +180,8 @@
			var sWhere = "";
			var option = [];
			var HModName = "MaterOutEntryReport_Cloth";

			var detailBar = 0; //ç¨äºæ±æ»æ¥è¡¨æ¥çæç»æ¥è¡¨ï¼å½ä¸º0æ¶æ¾ç¤ºæç»æ±æ»æ¥è¡¨å¯¹åºæç»æ¥è¡¨ã
			//#endregion

			//#region è¿å¥é¡µé¢æ¢å è½½
			@@ -187,6 +213,24 @@
			get_FastQuery();
			});

			//è¡çå¬äºä»¶-åå»
			table.on('row(mainTable)', function (obj) {
			var flag = !obj.tr.find(':checkbox:first').prop('checked');
			obj.tr.find(':checkbox').prop('checked', flag);
			if (flag) {
			obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //è®¾ç½®å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è²
			} else {
			obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è²
			}
			//mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æIDä¸æ£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤éä¸æªéä¸æ ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è²
			layui.each(table.cache.mainTable, function (i, l) {
			if (obj.tr.index() == l.LAY_TABLE_INDEX) {
			l.LAY_CHECKED = flag;
			}
			});
			});
			//#endregion

			//#region æ¤é¡µé¢ææçæ¹æ³
			@@ -194,8 +238,27 @@
			//åå§åçé¢
			function set_ClearBill() {
			//åå§åæ¶é´
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ
			var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
			var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
			laydate.render({
			elem: '#HBeginDate',
			type: 'datetime',
			fullPanel: true
			, format: 'yyyy-MM-dd HH'
			, value: HBeginDate
			});
			laydate.render({
			elem: '#HEndDate',
			type: 'datetime',
			fullPanel: true
			, format: 'yyyy-MM-dd HH'
			, value: HEndDate
			});


			////åå§åæ¶é´
			//$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ
			//$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//å è½½æ°æ®å°ç½æ ¼
			@@ -206,46 +269,163 @@

			//åå§åè¡¨æ ¼
			function set_InitGrid() {
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, cellMinWidth: 120
			, limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å¨é¨æ¾ç¤º
			, totalRow: true
			, height: 'full-70'
			, cols: [[
			{ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡' }
			, { field: 'æ¥æ', title: 'æ¥æ', width: 160 }
			, { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 160 }
			, { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 160 }
			, { field: 'äº§ååç§°', title: 'äº§ååç§°', width: 160 }
			, { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 160 }
			, { field: 'å½åå·¥åº', title: 'å½åå·¥åº', width: 160 }
			, { field: 'ä»»å¡æ°é', title: 'ä»»å¡æ°é', width: 160 }
			, { field: 'å¶åäºº', title: 'å¶åäºº', width: 200 }
			, { field: 'æµè½¬å¡æ°é', title: 'æµè½¬å¡æ°é', width: 160, totalRow: true }
			]]
			,done: function (res) {
			//var count = 0;
			//var OnlyID = -1;
			//for (var i = 0; i < res.data.length; i++) {
			// if (res.data[i]["å¯ä¸ID"] != OnlyID) {
			// count += res.data[i]["æ´æ¹"];
			// OnlyID = res.data[i]["å¯ä¸ID"];
			// }
			//}
			//var divArr = $(".layui-table-total div.layui-table-cell");
			//$.each(divArr, function (index, item) {
			// var _div = $(item);
			// var content = _div.html();
			// if (index == 9) {
			// content = count;
			// }
			// _div.html(content);
			//});
			}
			};
			var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ
			var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ç»ææ¥æ

			//var HBeginDate = $("#HBeginDate").val() + ":00:00" ;//ä¸è¾¾æ¥æ å¼å§æ¥æ
			//var HEndDate = $("#HEndDate").val()+":00:00";//ç»ææ¥æ
			var HMaterNumber = $("#HMaterNumber").val();//ç©æä»£ç
			var HBillNo = $("#HBillNo").val(); //åæ®å·
			var HProductName = $("#HProductName").val();//äº§ååç§°
			var HProductModel = $("#HProductModel").val();//äº§åè§æ ¼

			//ä»»æåæ®µæ¡ä»¶è¿æ»¤ æ¡ä»¶æå
			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").val();

			//æ¼æ¥ä»»ä¸åæ®µè¿æ»¤æ¥è¯¢æ¡ä»¶
			var com = "";
			if (ColName != 0 && Comparator != 0) {
			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;
			}
			com = " and (" + ColName + " " + com + ")";
			}

			sWhere = {
			HBeginDate: HBeginDate
			, HEndDate: HEndDate
			, HMaterNumber: HMaterNumber
			, HBillNo: HBillNo
			, HProductName: HProductName
			, HProductModel: HProductModel
			, RandomSearch: com
			}
			sWhere = JSON.stringify(sWhere);


			//å¨æå-ç¼ååè¡¨
			$.ajax({
			url: GetWEBURL() + "/MaterOutEntryReport/MaterOutEntryReport_Cloth",
			type: "GET",
			async: false,
			data: { "sWhere": sWhere },
			//async: false,
			success: function (data1) {

			if (data1.count == 1) {

			var data = [];
			var col = [];
			//ç»ç©ºçæ°ç»èµå¼
			for (var key in data1.list) {
			var width = data1.list[key].width * 23;
			if (width < 150) {
			width = 150;
			} else if (width > 300) {
			width = 300;
			}
			data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType});
			}

			//å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
			col.push({ type: 'checkbox', fixed: 'left' });
			for (var i = 0; i < data.length; i++) {
			if ($.inArray(data[i].name, "") > -1) {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
			}
			else if (data[i].ColName == 'ç½å¯åå¸') {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow:true });
			}
			else {
			switch (data[i].Type) {
			//int
			case 'DateTime':
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
			break;
			default:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
			}
			}
			}
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, cellMinWidth: 120
			, limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å¨é¨æ¾ç¤º
			, totalRow: true
			, height: 'full-70'
			, cols: [col]
			, data: data1.data
			};
			table.render(option);
			} else {
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, cellMinWidth: 120
			, limit: Number.MAX_VALUE // æ°æ®è¡¨æ ¼é»è®¤å¨é¨æ¾ç¤º
			, totalRow: true
			, height: 'full-70'
			, cols: [[
			{ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡' }
			, { field: 'æ¥æ', title: 'æ¥æ', width: 160 }
			, { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 160 }
			, { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 160 }
			, { field: 'äº§ååç§°', title: 'äº§ååç§°', width: 160 }
			, { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 160 }
			, { field: 'å½åå·¥åº', title: 'å½åå·¥åº', width: 160 }
			, { field: 'ä»»å¡æ°é', title: 'ä»»å¡æ°é', width: 160 }
			, { field: 'å¶åäºº', title: 'å¶åäºº', width: 200 }
			, { field: 'æµè½¬å¡æ°é', title: 'æµè½¬å¡æ°é', width: 160, totalRow: true }
			]]
			, done: function (res) {
			//var count = 0;
			//var OnlyID = -1;
			//for (var i = 0; i < res.data.length; i++) {
			// if (res.data[i]["å¯ä¸ID"] != OnlyID) {
			// count += res.data[i]["æ´æ¹"];
			// OnlyID = res.data[i]["å¯ä¸ID"];
			// }
			//}
			//var divArr = $(".layui-table-total div.layui-table-cell");
			//$.each(divArr, function (index, item) {
			// var _div = $(item);
			// var content = _div.html();
			// if (index == 9) {
			// content = count;
			// }
			// _div.html(content);
			//});
			}
			};
			table.render(option);
			}
			},
			error: function (err) {
			layer.msg('éè¯¯' + err, {
			icon: 5,
			time: 20000
			}, function () {
			//do something
			});
			}
			})
			}

			//åææ¾ç¤ºä¸ææ¡
			@@ -271,6 +451,14 @@
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			//è°æ´æ¥ææ ¼å¼ï¼æ¾ç¤º å¹´ææ¥ å æ¶ å
			for (var i = 0; i < data1.data.length; i++) {
			if (data1.data[i].æ¥æ != null) {
			data1.data[i].æ¥æ = data1.data[i]["æ¥æ"].split(":")[0] + ":" + data1.data[i]["æ¥æ"].split(":")[1];
			data1.data[i].æ¥æ = data1.data[i]["æ¥æ"].replace("T", " ");
			}
			}

			option.data = data1.data;
			//var num = 0;
			//for (let i = 0; i < data1.data.length; i++) {
			@@ -285,12 +473,22 @@
			// }
			//}
			table.render(option);

			//è®¡ç®åè®¡å¬æ¤æ°
			var sumHMaterOutQty = 0;
			for (var i = 0; i < data1.data.length; i++) {
			sumHMaterOutQty += data1.data[i]["ç½å¯åå¸"];
			}
			$("#SumHMaterOutQty").val(sumHMaterOutQty);

			layer.close(wait);
			} else {
			$("#SumHMaterOutQty").val("");
			layer.close(wait);
			layer.alert(data1.Message, { icon: 5 });
			}
			}, error: function () {
			$("#SumHMaterOutQty").val("");
			layer.close(wait);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			@@ -301,6 +499,20 @@
			function get_FastQuery() {
			var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ
			var HEndDate = $("#HEndDate").val();//ç»ææ¥æ

			if (HBeginDate == '') {
			HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ
			} else {
			HBeginDate = $("#HBeginDate").val() + ":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ
			}
			if (HEndDate == '') {
			HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh") + ":00:00";//ç»ææ¥æ
			} else {
			HEndDate = $("#HEndDate").val() + ":00:00";//ç»ææ¥æ
			}

			//var HBeginDate = $("#HBeginDate").val()+":00:00";//ä¸è¾¾æ¥æ å¼å§æ¥æ
			//var HEndDate = $("#HEndDate").val()+":00:00";//ç»ææ¥æ
			var HMaterNumber = $("#HMaterNumber").val();//ç©æä»£ç
			var HBillNo = $("#HBillNo").val(); //åæ®å·
			var HProductName = $("#HProductName").val();//äº§ååç§°
			@@ -310,37 +522,57 @@
			var ColName = $("#ColName").val();//å¤éæ¡
			var Comparator = $("#Comparator").val()
			var ColContent = $("#ColContent").val();

			//æ¼æ¥ä»»ä¸åæ®µè¿æ»¤æ¥è¯¢æ¡ä»¶
			var com = "";
			if (ColName != 0 && Comparator != 0) {
			var com = "";
			switch (Comparator) {
			case "7":
			com = "like'%" + ColContent + "%'";
			com = "like ''%" + ColContent + "%''";
			break;
			case "8":
			com = "like'%" + ColContent + "'";
			com = "like ''%" + ColContent + "''";
			break;
			case "9":
			com = "like'" + ColContent + "%'";
			com = "like ''" + ColContent + "%''";
			break;
			case "10":
			com = "not like'%" + ColContent + "%'";
			com = "not like ''%" + ColContent + "%''";
			break;
			default:
			com = "" + Comparator + "'" + ColContent + "'";
			com = "" + Comparator + " ''" + ColContent + "''";
			break;
			}
			sWhere += " and " + ColName + " " + com;
			com = " and (" + ColName + " " + com + ")";
			}

			var params = get_UrlVars();
			if (params[params[0]] != null && detailBar == 0) {
			//æ±æ»æ¥è¡¨ççäº§è®¢åå·
			HBillNo = params[params[0]];
			//è®¾ç½®çäº§è®¢åå·æ ç¾
			$("#HBillNo").val(HBillNo);

			//è®¾ç½®æ¶é´ä¸ºä¸ä¸ªå¾å¤§çå¼ï¼é»è®¤æç´¢æææ¶é´çæç»
			HBeginDate = "1900-01-01 00:00:00";
			HEndDate = "2200-01-01 00:00:00";

			detailBar = 1;
			} else {
			HBillNo = $("#HBillNo").val(); //åæ®å·
			}

			sWhere = {
			HBeginDate: HBeginDate
			, HEndDate: HEndDate
			,HMaterNumber: HMaterNumber
			, HMaterNumber: HMaterNumber
			, HBillNo: HBillNo
			, HProductName: HProductName
			, HProductModel: HProductModel
			, RandomSearch: com
			}

			//set_InitGrid(JSON.stringify(sWhere));
			get_Display(JSON.stringify(sWhere));
			//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			sWhere = "";
			@@ -348,8 +580,26 @@

			//éç½®è¿æ»¤æ¡ä»¶
			function set_ClearQuery() {
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ
			//åå§åæ¶é´
			var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
			var HEndDate = Format(new Date(new Date()).setHours(7, 0, 0, 0), "yyyy-MM-dd hh");
			laydate.render({
			elem: '#HBeginDate',
			type: 'datetime',
			fullPanel: true
			, format: 'yyyy-MM-dd HH'
			, value: HBeginDate
			});
			laydate.render({
			elem: '#HEndDate',
			type: 'datetime',
			fullPanel: true
			, format: 'yyyy-MM-dd HH'
			, value: HEndDate
			});

			//$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ
			//$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ
			$("#HMaterNumber").val("");
			$("#HBillNo").val("");
			$("#HProductName").val("");
			@@ -366,7 +616,7 @@
			//éèåè®¾ç½®
			function get_HideColumn() {
			var colName = "";
			for (var i = 1; i < option.cols[0].length - 1; i++) {
			for (var i = 1; i < option.cols[0].length; i++) {
			colName += option.cols[0][i]["title"] + ",";
			}

			@@ -405,7 +655,7 @@

			dataCol = data1.data[0].HGridString.split(',');

			for (var i = 0; i < option.cols[0].length - 2; i++) {
			for (var i = 0; i < option.cols[0].length - 1; i++) {
			if (dataCol[i]) {
			var dataCols = dataCol[i].split('\|');
			}