MES-WEB-LayUI.git

			@@ -5,13 +5,15 @@
			<title>ç¼ºæåææ¥è¡¨</title>
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
			<link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.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/soulTable.slim.js"></script>-->
			<script src="../../../layuiadmin/SetColumn.js"></script>
			</head>
			<body>
			<div class="layui-fluid">
			@@ -48,10 +50,93 @@
			</div>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">æ¥è¯¢</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">éç½®</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">å¯¼åº</button>
			<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:10px;">

			</div>
			<!--<div class="layui-row" style="margin-top:10px;">
			<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
			<option value="0" selected="selected"></option>
			<option value="=">=</option>
			<option value=">=">>=</option>
			<option value=">">></option>
			<option value="<="><=</option>
			<option value="<"><</option>
			<option value="<>"><></option>
			<option value="7">åå«</option>
			<option value="8">å·¦åå«</option>
			<option value="9">å³åå«</option>
			<option value="10">ä¸åå«</option>
			</select>
			</div>
			<div class="layui-inline">
			<input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
			</div>
			</div>

			<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;">
			<option value="0" selected="selected"></option>
			<option value="=">=</option>
			<option value=">=">>=</option>
			<option value=">">></option>
			<option value="<="><=</option>
			<option value="<"><</option>
			<option value="<>"><></option>
			<option value="7">åå«</option>
			<option value="8">å·¦åå«</option>
			<option value="9">å³åå«</option>
			<option value="10">ä¸åå«</option>
			</select>
			</div>
			<div class="layui-inline">
			<input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
			</div>
			</div>

			<div class="layui-row" style=" margin-top: 10px; margin-left: 70px;">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;">
			<option value="0" selected="selected"></option>
			<option value="=">=</option>
			<option value=">=">>=</option>
			<option value=">">></option>
			<option value="<="><=</option>
			<option value="<"><</option>
			<option value="<>"><></option>
			<option value="7">åå«</option>
			<option value="8">å·¦åå«</option>
			<option value="9">å³åå«</option>
			<option value="10">ä¸åå«</option>
			</select>
			</div>
			<div class="layui-inline">
			<input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
			</div>
			</div>
			</div>-->
			</div>
			</div>
			</div>
			@@ -76,7 +161,8 @@
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util'], function () {
			soulTable: '../ext/soulTable'
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable'], function () {
			//#region å¬ç¨åé
			var $ = layui.$
			, admin = layui.admin
			@@ -89,9 +175,11 @@
			, util = layui.util
			, tree = layui.tree
			, util = layui.util
			, soulTable = layui.soulTable
			var sWhere = "";
			var option = [];
			var HModName = "MaterialShorAnalysisReport";
			var ins; //ç¨äºå¯¼åºexcel
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½
			@@ -108,7 +196,7 @@
			switch (obj.event) {
			//éèåè®¾ç½®
			case 'HideColumn':
			get_HideColumn();
			get_HideColumnNoPageForPlan(HModName, option, get_FastQuery);
			break;
			};
			});
			@@ -123,6 +211,12 @@
			//#region æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery(2);
			});
			//#endregion

			//#region å¯¼åºæé®
			form.on('submit(btnExport)', function (data) {
			getExportData();
			});
			//#endregion

			@@ -142,11 +236,13 @@
			$("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), 'yyyy-MM-dd'));
			//çäº§ç»ç»å è½½
			Organ();
			//åå§åè¡¨æ ¼
			set_InitGrid();
			////åå§åè¡¨æ ¼
			//set_InitGrid();
			//å¿«éè¿æ»¤
			get_FastQuery(1);
			DisPlay_HideColumn();
			//ColFilter();
			}
			//#endregion

			@@ -154,13 +250,13 @@
			function set_InitGrid() {
			var columns = [];

			columns.push({ type: 'checkbox', fixed: 'left' });
			columns.push({ field: 'HOrgName', title: 'éè´ç»ç»' });
			columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ' });
			columns.push({ field: 'HMaterName', title: 'ç©æåç§°' });
			columns.push({ field: 'HMaterModel', title: 'ç©æè§æ ¼' });
			columns.push({ field: 'CountHQty', title: 'åè®¡' });
			columns.push({ field: 'FBASEQTY', title: 'å³æ¶åºåæ°é' });
			columns.push({ field: 'HOrgName', title: 'éè´ç»ç»', sort: false, filter: true });
			columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: false, filter: true });
			columns.push({ field: 'HMaterName', title: 'ç©æåç§°', sort: false, filter: true });
			columns.push({ field: 'HMaterModel', title: 'ç©æè§æ ¼', sort: false, filter: true });
			columns.push({ field: 'å¨éæ°é', title: 'å¨éæ°é', totalRow: true, filter: true });
			columns.push({ field: 'CountHQty', title: 'åè®¡', sort: false, filter: true });
			columns.push({ field: 'FBASEQTY', title: 'å³æ¶åºåæ°é', sort: false, totalRow: true, filter: true});
			//è·åä¸¤ä¸ªææä¹é´çç¸å·®
			var time1 = Date.parse(new Date($("#HBEGINDATE").val()));//å¼å§æ¶é´
			var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´
			@@ -176,7 +272,7 @@

			var k = 0;//æ¶éå¾ªç¯æ¬¡æ°
			for (var j = 0; j <= (Days - k); j++) {
			columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70 })
			columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true })
			//è·¨å¹´çè¯ ä¼ä»ä¸æä¸å·å¼å§
			if (MM == 12 && (HBEGINDATE + j) == 31) {
			yyyy += 1;
			@@ -199,11 +295,13 @@
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, totalRow: true
			, limit: 1000
			, limits: [50, 500,1000, 5000, 20000]
			, loading: false
			, cols: [columns]
			, done: function (res, page, count) {
			soulTable.render(this);
			var that = this.elem.next();
			res.data.forEach(function (item, index) {
			var NumCount = item.FBASEQTY;//è·åæ»åºåæ°é
			@@ -211,11 +309,16 @@
			var dateNowTime = Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + i), 'yyyy-MM-dd');
			if (item[dateNowTime] != null) {
			if (NumCount > parseFloat(item[dateNowTime])) {
			//åºåæ°é>éæ±æ°éï¼å©ä½å¯ç¨åºåæ°é=åºåæ°é-éæ±æ°é
			NumCount -= parseFloat(item[dateNowTime]);
			} else {
			var num = 6;//å³æ¶åºåä¸æ¥ææ¨ç ä»å³æ¶åºåå¼å§ç®
			//åºåæ°é<éæ±æ°éï¼å©ä½å¯ç¨åºåæ°é=0
			NumCount = 0;

			var num = 7;//å³æ¶åºåä¸æ¥ææ¨ç ä»å³æ¶åºåå¼å§ç®
			tr = that.find(".layui-table-box tbody tr[data-index='" + index + "']");
			rq = tr.children()[num + 1 + i];
			//rq = tr.children()[num + 1 + i];
			rq = tr.children()[num + i];
			rq.style.color = '#f66161';//ç¶ååè²
			rq = tr.children()[num];
			rq.style.color = '#f66161';//ç¶ååè²
			@@ -277,6 +380,8 @@
			success: function (result) {
			if (result.count == 1) {
			option.data = result.data;
			//åè®¾ç½®
			DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option);
			table.render(option);
			layer.close(ajaxLoad);
			//layer.alert("æ¥è¯¢æå", { icon: 1 });
			@@ -291,6 +396,79 @@
			});
			}

			//#endregion

			//#region è·åå¯¼åºæ°æ®
			function getExportData() {
			var data;//å¯¼åºçæ°æ®
			var ajaxLoad = layer.load();
			var HORGID = $("#HORGID").val();//ç»ç»
			var HBEGINDATE = $("#HBEGINDATE").val();//æææ¥æ
			var HENDDATE = $("#HENDDATE").val();//è³
			//var HMATERIALID = $("#HMATERIALID").val();//ç©æ/äº§å
			//var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå
			//var HXQD = $("#HXQD").val();//éæ±åå·
			//var HPURORDERNO = $("#HPURORDERNO").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 (HBEGINDATE > HENDDATE) {
			return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!");
			}

			sWhere = {
			HORGID: HORGID
			, HBEGINDATE: HBEGINDATE
			, HENDDATE: HENDDATE
			//, HMATERIALID: HMATERIALID
			//, HSUPPLIERID: HSUPPLIERID
			//, HXQD: HXQD
			//, HPURORDERNO: HPURORDERNO
			}

			$.ajax({
			url: GetWEBURL() + '/JIT_DayPlanPlatFormBill/MaterialShorAnalysisReport',
			type: "GET",
			data: { "sWhere": JSON.stringify(sWhere) },//, "user": sessionStorage["HUserName"]
			success: function (result) {
			if (result.count == 1) {
			data = result.data;

			option.data = data;
			ins = table.render(option);

			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().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			});

			table.exportFile(ins.config.id, data, "xls");

			layer.close(ajaxLoad);
			} else {
			layer.close(ajaxLoad);
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});

			sWhere = "";
			}
			//#endregion

			//#region å¿«éè¿æ»¤
			@@ -308,7 +486,80 @@
			//var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå
			//var HXQD = $("#HXQD").val();//éæ±åå·
			//var HPURORDERNO = $("#HPURORDERNO").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 > HENDDATE) {
			return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!");
			}
			@@ -322,8 +573,7 @@
			//, HXQD: HXQD
			//, HPURORDERNO: HPURORDERNO
			}
			//åå§åè¡¨æ ¼
			set_InitGrid();

			get_Display(JSON.stringify(sWhere));
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			@@ -340,6 +590,15 @@
			//$("#HSUPPLIERNAME").val("");
			//$("#HXQD").val("");//éæ±åå·
			//$("#HPURORDERNO").val("");//éè´è®¢åå·
			$("#ColContent").val("");
			$("#ColName").val("0");
			$("#Comparator").val("0");
			$("#ColContent1").val("");
			$("#ColName1").val("0");
			$("#Comparator1").val("0");
			$("#ColContent2").val("");
			$("#ColName2").val("0");
			$("#Comparator2").val("0");
			form.render('select');
			sWhere = "";
			}
			@@ -499,6 +758,23 @@
			}
			})
			}
			//åææ¾ç¤ºä¸ææ¡
			function ColFilter() {
			var Organization = '<option value="0" selected="selected" ></option>';
			for (var i = 1; i < option.cols[0].length; i++) {
			if (option.cols[0][i].hide != true) {
			Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
			}
			}
			$("#ColName").empty();
			$("#ColName").append(Organization);
			$("#ColName1").empty();
			$("#ColName1").append(Organization);
			$("#ColName2").empty();
			$("#ColName2").append(Organization);

			form.render('select');
			}

			//#endregion
			//ä»¥ä¸æ¯layuiæ¨¡å