MES-WEB-LayUI.git

			@@ -5,12 +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/SetColumn.js"></script>
			<!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--><!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶-->
			</head>
			<body>
			<div class="layui-fluid">
			@@ -47,6 +50,8 @@
			</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>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">åè®¾ç½®</button>
			<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:10px;">
			<div class="layui-inline">
			@@ -103,7 +108,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','flow'], function () {
			//#region å¬ç¨åé
			var $ = layui.$
			, admin = layui.admin
			@@ -116,8 +122,12 @@
			, util = layui.util
			, tree = layui.tree
			, util = layui.util
			, soulTable = layui.soulTable
			, flow = layui.flow
			var sWhere = " where 1=1 ";
			var option = [];
			var ins; //ç¨äºå¯¼åºexcel
			var HModName = "ReportPODemandPlanBillList_S";
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½
			@@ -153,6 +163,18 @@
			});
			//#endregion

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

			//#region åè®¾ç½®æé®
			form.on('submit(bthHideColumn)', function (data) {
			get_HideColumnNoPageForPlan(HModName, option, get_FastQuery);
			});
			//#endregion

			//#endregion

			//#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³
			@@ -160,59 +182,106 @@
			//#region åå§åçé¢
			function set_ClearBill() {
			//åå§åæ¥æ
			$("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HENDDATE").val(Format(new Date(), "yyyy-MM-dd"));
			$("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 25), "yyyy-MM-dd"));//æææ¥æ
			var HEndDate = Format(new Date().setDate(new Date().getDate() + 25), "yyyy-MM-dd");
			$("#HENDDATE").val(HEndDate);//è³
			//çäº§ç»ç»å è½½
			Organ();
			//åå§åè¡¨æ ¼
			set_InitGrid();

			//å¿«éè¿æ»¤
			get_FastQuery(1);

			ColFilter();
			}
			//#endregion

			//#region åå§åè¡¨æ ¼æ¹æ³
			function set_InitGrid() {
			var columns = [];
			var myDate = new Date();
			var yyyy = myDate.getFullYear();
			var MM = myDate.getMonth() + 1;
			var dd = myDate.getDate();
			var SumMonth = 31; //å¨æä¸¤æä¹å·® new Date(yyyy, MM, 0).getDate()
			var MonthCount = new Date(yyyy, MM-1, 0).getDate();

			columns.push({ type: 'checkbox', fixed: 'left' });
			columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»' });
			columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°' });
			columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼' });
			columns.push({ field: 'FNAME', title: 'ä¾åºå' });
			columns.push({ field: 'FSUMQTY', title: 'åè®¡' });
			columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·' });
			columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·' });
			columns.push({ type: 'checkbox', fixed: 'left', sort: true});
			columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true });
			columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°', sort: true, filter: true });
			columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼', sort: true, filter: true });
			columns.push({ field: 'FNAME', title: 'ä¾åºå', sort: true, filter: true });
			columns.push({ field: 'FSUMQTY', title: 'åè®¡', sort: true, hide: true, filter: true });
			columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, hide: true, filter: true });
			columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true, hide: true, filter: true });
			//columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' });
			//columns.push({ field: 'HPOOrderBillNote', title: 'å¤æ³¨' });
			//columns.push({ field: 'éè´å', title: 'éè´å' });
			columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ' });
			columns.push({ field: 'è®¡éåä½åç§°', title: 'è®¡éåä½' });
			columns.push({ field: 'TQSUM', title: 'æææææ°é' });
			for (var i = 1; i <= (MonthCount - dd); i++) {
			columns.push({ field: Format(yyyy + '/' + (MM - 1) + '/' + (dd + i), 'yyyy-MM-dd'), title: Format(yyyy + '/' + (MM - 1) + '/' + (dd + i), 'MM.dd'), width: 70 })//0
			columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true, filter: true });
			columns.push({ field: 'è®¡éåä½åç§°', title: 'è®¡éåä½', sort: true, filter: true });
			columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true });
			columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true });
			columns.push({ field: 'é¾ææææ»å', title: 'é¾ææææ»å', sort: true, totalRow: true, filter: true });
			columns.push({ field: 'æææ»å', title: 'æææ»å', sort: true, totalRow: true, filter: true });
			//è·åä¸¤ä¸ªææä¹é´çç¸å·®
			var time1 = Date.parse(new Date());//å¼å§æ¶é´
			var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´
			var Days = Math.abs(parseInt((time2 - time1) / 1000 / 3600 / 24));
			//è·åå¹´
			var yyyy = new Date().getFullYear();
			//è·åæä»½
			var MM = new Date().getMonth() + 1;
			//è·åå¼å§æä»½çæå¤§å¤©æ°
			var SumMonth = new Date(yyyy, MM, 0).getDate(); //å¨æä¸¤æä¹å·®
			//è·åå¼å§æ¥æçå¤©æ°
			var HBEGINDATE = new Date(new Date()).getDate(); //è·åå¼å§æ¥æå¤©æ°

			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, totalRow: true, filter: true })
			//è·¨å¹´çè¯ ä¼ä»ä¸æä¸å·å¼å§
			if (MM == 12 && (HBEGINDATE + j) == 31) {
			yyyy += 1;
			MM = 1;
			SumMonth = new Date(yyyy, MM, 0).getDate();
			HBEGINDATE = 0;
			k += j;
			j = 0;
			} else if ((HBEGINDATE + j) == SumMonth) { //è·¨æ ææ°å ä¸ å¤©æ°ä»ä¸å¼å§
			HBEGINDATE = 0;
			MM += 1;
			SumMonth = new Date(yyyy, MM, 0).getDate();
			k += j;
			j = 0;
			}
			}
			for (var i = 1; i <= (SumMonth - MonthCount + dd); i++) {
			columns.push({ field: Format(yyyy + '/' + MM + '/' + i, 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + i, 'MM.dd'), width: 70 })//0
			}
			columns.push({ field: '', title: 'ææè®¡ååè®¡' });
			columns.push({
			field: 'ææè®¡ååè®¡', title: 'ææè®¡ååè®¡', filter: true, templet: function (d) {
			//console.log(d); // å¾å°å½åè¡æ°æ®
			//console.log(this); // å¾å°è¡¨å¤´å½ååéç½®é¡¹
			//console.log(d.LAY_NUM);
			let sum = 0;

			// éåæ°æ®å¯¹è±¡çææå±æ§
			for (let key in d) {
			// æ£æ¥ååæ¯å¦ç¬¦å isValidDate æ¡ä»¶
			if (isValidDate(key)) {
			// å° null/undefined è½¬ä¸º 0
			sum += d[key] ? parseFloat(d[key]) : 0;
			}
			}

			return sum; // ä¿çä¸¤ä½å°æ°
			}
			});

			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			//, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, limit: 1000
			, limits: [50, 500,1000, 5000, 20000]
			, totalRow: true
			, loading: false
			, cols: [columns]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			};
			}
			//#endregion
			@@ -245,11 +314,14 @@
			$.ajax({
			url: GetWEBURL() + '/JIT_Cg_PODemandPlanBill/ReportPODemandPlanBillList_S',
			type: "GET",
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() },
			success: function (result) {
			if (result.count == 1) {
			if (result.count == 1) {

			option.data = result.data;
			table.render(option);
			//åè®¾ç½®
			DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option);
			ins = table.render(option);
			layer.close(ajaxLoad);
			//layer.alert("æ¥è¯¢æå", { icon: 1 });
			} else {
			@@ -263,6 +335,23 @@
			});
			}

			//#endregion

			//#region è·åå¯¼åºæ°æ®
			function getExportData() {
			data = option.data;
			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");
			}
			//#endregion

			//#region å¿«éè¿æ»¤
			@@ -280,6 +369,10 @@
			var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå
			var HXQD = $("#HXQD").val();//éæ±åå·
			var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå·

			if (HBEGINDATE > HENDDATE) {
			return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!");
			}

			if (HORGID != "") {
			sWhere += " and a.HPURCHASEORGID= " + HORGID+" ";
			@@ -300,7 +393,8 @@
			if (HPURORDERNO) {
			sWhere += " and HPOOrderBillNo like''%" + HPURORDERNO + "%'' ";
			}

			//åå§åè¡¨æ ¼
			set_InitGrid();
			get_Display(sWhere);
			sWhere = " where 1=1 ";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			@@ -309,8 +403,8 @@
			//#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³
			function set_ClearQuery() {
			$("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç»
			$("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//æææ¥æ
			$("#HENDDATE").val(Format(new Date(), "yyyy-MM-dd"));//è³
			$("#HBEGINDATE").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æææ¥æ
			$("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), "yyyy-MM-dd"));//è³
			$("#HMATERIALID").val("");//ç©æ/äº§å
			$("#HMATERIALNAME").val("");
			$("#HSUPPLIERID").val("");//ä¾åºå
			@@ -330,7 +424,7 @@
			, area: ['90%', '90%']//å¤§å°
			, title: 'ç©æåè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../Baseset/åºç¡èµæ/Gy_MaterialList.html', 'yes']
			, content: ['../../åºç¡èµæ/å¬ç¨åºç¡èµæ/Gy_Material.html', 'yes']
			, btn: ['ç¡®å®', 'åæ¶']
			, btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè°
			var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢
			@@ -340,7 +434,7 @@
			}
			//è·åæ°æ®
			$("#HMATERIALID").val(checkStatus.data[0].HItemID);
			$("#HMATERIALNAME").val(checkStatus.data[0].HName);
			$("#HMATERIALNAME").val(checkStatus.data[0].ç©æåç§°);
			layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			, btn2: function (index, layero) { }
			@@ -355,7 +449,7 @@
			, area: ['90%', '90%']//å¤§å°
			, title: 'ä¾åºååè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../Baseset/åºç¡èµæ/Gy_SupplierList.html', 'yes']
			, content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html?Type=HSup', 'yes']
			, btn: ['ç¡®å®', 'åæ¶']
			, btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè°
			var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢
			@@ -365,16 +459,40 @@
			}
			//è·åæ°æ®
			$("#HSUPPLIERID").val(checkStatus.data[0].HItemID);
			$("#HSUPPLIERNAME").val(checkStatus.data[0].HName);
			$("#HSUPPLIERNAME").val(checkStatus.data[0].ä¾åºååç§°);
			layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			, btn2: function (index, layero) { }
			})
			}

			//åææ¾ç¤ºä¸ææ¡
			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æ¨¡å
			});
			function GetHSupNameValue(obj) {
			$("#HSUPPLIERID").val(obj[0].HItemID);
			$("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°);
			}
			function GetGyMaterial(obj) {
			$("#HMATERIALID").val(obj.HItemID);
			$("#HMATERIALNAME").val(obj.ç©æåç§°);
			}
			</script>