MES-WEB-LayUI.git

			@@ -3,15 +3,18 @@
			<head>
			<meta charset="utf-8" />
			<title>ææè®¡åæ¥è¡¨(éè´è®¢åç»´åº¦)</title>
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			<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>
			<script src="../../../layuiadmin/xm-select.js"></script>
			</head>
			<body>
			<div class="layui-fluid">
			@@ -29,9 +32,12 @@
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">ç»ç»</label>
			<div class="layui-input-block" style="margin-left: 120px; width: 185px;">
			<select name="HORGID" id="HORGID" lay-verify="HORGID">
			<!--<select name="HORGID" id="HORGID" lay-verify="HORGID">-->
			<!--å¨ææ¸²æç»ç»-->
			</select>
			<!--</select>-->
			<div id="demo1">

			</div>
			</div>
			</div>
			<div class="layui-inline">
			@@ -85,6 +91,8 @@
			</div>
			</div>
			</div>

			<hr />
			</div>
			</div>
			</div>
			@@ -92,6 +100,7 @@
			<script type="text/html" id="toolbarDemo">
			<div class="layui-btn-container">
			<button type="button" class="layui-btn layui-btn-sm" lay-event="HideColumn"><i class="layui-icon layui-icon-form"></i>éèåè®¾ç½®</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>å¯¼åº</button>
			</div>
			</script>
			</form>
			@@ -109,7 +118,7 @@
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util'], function () {
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable'], function () {
			//#region å¬ç¨åé
			var $ = layui.$
			, admin = layui.admin
			@@ -122,9 +131,11 @@
			, util = layui.util
			, tree = layui.tree
			, util = layui.util
			, soulTable = layui.soulTable
			var sWhere = "";
			var option = [];
			var HModName = "ReportPODemandPlanBillList";
			var ins = [];
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½
			@@ -141,7 +152,11 @@
			switch (obj.event) {
			//éèåè®¾ç½®
			case 'HideColumn':
			get_HideColumn();
			get_HideColumnNoPageForPlan(HModName, option, get_FastQuery);
			break;
			//å¯¼åºexcel
			case 'get_export':
			get_Export();
			break;
			};
			});
			@@ -185,7 +200,8 @@
			//set_InitGrid();
			//å¿«éè¿æ»¤
			get_FastQuery(1);
			DisPlay_HideColumn();

			ColFilter();
			}
			//#endregion

			@@ -193,20 +209,21 @@
			function set_InitGrid() {
			var columns = [];

			columns.push({ type: 'checkbox', fixed: 'left' });
			columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»' });
			columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°' });
			columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼' });
			columns.push({ field: 'ä¾åºå', title: 'ä¾åºå' });
			columns.push({ field: 'FSUMQTY', title: 'åè®¡' });
			columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·' });
			columns.push({ field: 'HSeOrderBillNo', title: 'éå®è®¢åå·' });
			columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' });
			columns.push({ field: 'HPOOrderBillNote', title: 'å¤æ³¨' });
			columns.push({ field: 'éè´å', title: 'éè´å' });
			columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ' });
			columns.push({ field: 'è®¡éåä½åç§°', title: 'è®¡éåä½' });
			columns.push({ field: 'TQSUM', title: 'æææææ°é' });
			columns.push({ type: 'checkbox', fixed: 'left', sort: true, filter: true});
			columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true});
			columns.push({ field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true, filter: true});
			columns.push({ field: 'è§æ ¼åå·', title: 'ç©æè§æ ¼', sort: true, filter: true});
			columns.push({ field: 'ä¾åºå', title: 'ä¾åºå', sort: true, filter: true});
			columns.push({ field: 'FSUMQTY', title: 'åè®¡', sort: true, filter: true });
			columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, filter: true });
			columns.push({ field: 'å®¢æ·è®¢åå·', title: 'å®¢æ·è®¢åå·', sort: true, filter: true });
			columns.push({ field: 'HSeOrderBillNo', title: 'éå®è®¢åå·', sort: true, filter: true});
			columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦', sort: true, filter: true });
			columns.push({ field: 'HPOOrderBillNote', title: 'å¤æ³¨', sort: true, filter: true});
			columns.push({ field: 'éè´å', title: 'éè´å', sort: true, filter: true});
			columns.push({ field: 'ç©æä»£ç ', title: 'ç©æç¼ç ', sort: true, filter: true});
			columns.push({ field: 'è®¡éåä½åç§°', title: 'è®¡éåä½', sort: true, filter: true});
			columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true});

			//è·åä¸¤ä¸ªææä¹é´çç¸å·®
			var time1 = Date.parse(new Date($("#HBEGINDATE").val()));//å¼å§æ¶é´
			@@ -223,7 +240,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;
			@@ -241,18 +258,24 @@
			}
			}

			columns.push({ field: '', title: 'ææè®¡ååè®¡' });
			columns.push({
			field: 'PLANSUM', title: 'ææè®¡ååè®¡', filter: true });

			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, title: "ææè®¡åæ¥è¡¨ï¼éè´è®¢åï¼"
			, page: true
			, cellMinWidth: 90
			, totalRow: true
			, limit: 50
			, limits: [50, 500, 5000, 20000]
			, loading: false
			, cols: [columns]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			};
			}
			//#endregion
			@@ -262,17 +285,27 @@
			function Organ() {
			//è·åç»å½é¡µç»ç»å
			var Organization = '';
			var selectDataList = [];
			$.ajax({
			type: "get",
			url: GetWEBURL() + "/Web/GetOrganizations",
			async: false,
			success: function (result) {
			if (result.count == 1) { // è¯´æéªè¯æåäºï¼
			var data = result.data;
			for (var i = 0; i < data.length; i++) {
			Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
			/Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';/
			var selectData = { name: data[i].Name, value: data[i].ID };
			selectDataList.push(selectData);
			}
			$("#HORGID").append(Organization);
			$("#HORGID").val(sessionStorage["OrganizationID"])
			//$("#HORGID").append(Organization);
			//$("#HORGID").val(sessionStorage["OrganizationID"])
			var demo1 = xmSelect.render({
			el: '#demo1',
			language: 'zn',
			/initValue: [sessionStorage["OrganizationID"]],///é»è®¤éé¡¹
			data: selectDataList
			})
			form.render('select');
			}
			layer.closeAll("loading");
			@@ -290,7 +323,9 @@
			success: function (result) {
			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 {
			@@ -309,11 +344,19 @@
			//#region å¿«éè¿æ»¤
			function get_FastQuery(number) {
			var HORGID = "";
			if (number == 1) {
			HORGID = sessionStorage["OrganizationID"];
			}
			else {
			HORGID = $("#HORGID").val();//ç»ç»
			set_InitGrid()//æ¯æ¬¡æ¥è¯¢åè®¾ç½®é¡µé¢
			//if (number == 1) {
			// HORGID = sessionStorage["OrganizationID"];
			//}
			//else {
			// HORGID = $("#HORGID").val();//ç»ç»
			//}
			var xmList = xmSelect.get('#demo1', true);//è·åéæ©æ¡å®ä¾
			var xmValueStr = xmList.getValue("valueStr")//è·åå¼åç¬¦ä¸²
			if (xmValueStr == "") {
			HORGID = "'0'"
			} else {
			HORGID = "'" + xmValueStr + "'"
			}
			var HBEGINDATE = $("#HBEGINDATE").val();//æææ¥æ
			var HENDDATE = $("#HENDDATE").val();//è³
			@@ -321,7 +364,6 @@
			var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå
			var HXQD = $("#HXQD").val();//éæ±åå·
			var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå·

			if (HBEGINDATE > HENDDATE) {
			return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!");
			}
			@@ -335,8 +377,6 @@
			, HXQD: HXQD
			, HPURORDERNO: HPURORDERNO
			}
			//åå§åè¡¨æ ¼
			set_InitGrid();
			get_Display(JSON.stringify(sWhere));
			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			@@ -347,9 +387,9 @@
			$("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç»
			$("#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("");//ç©æ/äº§å
			$("#HMATERIALID").val("0");//ç©æ/äº§å
			$("#HMATERIALNAME").val("");
			$("#HSUPPLIERID").val("");//ä¾åºå
			$("#HSUPPLIERID").val("0");//ä¾åºå
			$("#HSUPPLIERNAME").val("");
			$("#HXQD").val("");//éæ±åå·
			$("#HPURORDERNO").val("");//éè´è®¢åå·
			@@ -366,7 +406,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] //è·åå¼¹æ¡é¡µé¢
			@@ -376,7 +416,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) { }
			@@ -391,7 +431,7 @@
			, area: ['90%', '90%']//å¤§å°
			, title: 'ä¾åºååè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html', 'yes']
			, content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html?Type=HSup', 'yes']
			, btn: ['ç¡®å®', 'åæ¶']
			, btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè°
			var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢
			@@ -408,112 +448,74 @@
			})
			}

			//éèåè®¾ç½®
			function get_HideColumn() {
			var colName = "";
			for (var i = 1; i < option.cols[0].length; i++) {
			colName += option.cols[0][i]["title"] + ",";
			}

			colName = encodeURI(colName.substring(0, colName.length - 1));//å¯¹ URI è¿è¡ç¼ç
			layer.open({
			type: 2
			, skin: "layui-layer-rim" //å ä¸è¾¹æ¡
			, title: "éèåè®¾ç½®" //æ é¢
			, closeBtn: 1 //çªä½å³ä¸è§å³é ç æ ·å¼
			, shift: 2 //å¼¹åºå¨ç»
			, area: ["50%", "90%"] //çªä½å¤§å°
			, maxmin: true //è®¾ç½®æå¤§æå°æé®æ¯å¦æ¾ç¤º
			, content: ['../../åºç¡èµæ/éèåè®¾ç½®/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
			, btn: ["ç¡®å®", "åæ¶"]
			, btn1: function (index, laero) {
			//å·æ°è¡¨æ ¼æ°æ®
			DisPlay_HideColumn();
			//æ´æ°è¡¨æ ¼ç¼åçæ°æ®
			layer.close(index);//å³éå¼¹çª
			function get_Export() {
			var 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, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			item[itemobj] = item[itemobj].toString().replace(/[,]+/g, 'ï¼'); // å°æ¢åå·æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			})
			});
			table.exportFile(ins.config.id, data, "xls");
			}

			//æ¾ç¤ºåæ°æ®
			function DisPlay_HideColumn() {
			$.ajax({
			url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
			type: "GET",
			data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
			success: function (data1) {
			if (data1.data.length != 0) {

			var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ®
			var titleData = [];//ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±

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

			for (var i = 0; i < option.cols[0].length - 1; i++) {
			if (dataCol[i]) {
			var dataCols = dataCol[i].split('\|');
			}
			//éèå
			if (dataCols[1] == 1) {
			option.cols[0][i + 1]["hide"] = true;
			}
			//è®¾ç½®åå®¹åä½å¤§å°
			if (data1.data[0].HFontSize != 0) {
			option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
			} else {
			option.cols[0][i + 1]["style"] = "font-size:100%";
			}
			//è®¾ç½®åå®½
			if (dataCols[3] > 0) {
			option.cols[0][i + 1]["width"] = dataCols[3];
			}
			//æ¾ç¤ºå
			if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
			option.cols[0][i + 1]["hide"] = false;
			}
			//åä½æå¨ä½ç½®(å·¦ å±ä¸ å³)
			switch (dataCols[2]) {
			case "L":
			option.cols[0][i + 1]["align"] = "left";
			break;
			case "M":
			option.cols[0][i + 1]["align"] = "center";
			break;
			case "R":
			option.cols[0][i + 1]["align"] = "right";
			break;
			}
			}

			//åæ¶å»ç»å
			for (var i = 1; i < option.cols[0].length - 1; i++) {
			if (option.cols[0][i]["fixed"] != null) {
			option.cols[0][i]["fixed"] = null;
			}
			else {
			break;
			}
			}
			//å»ç»å
			if (data1.data[0].HFixCols != 0) {
			for (var i = 0; i < data1.data[0].HFixCols; i++) {
			if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
			data1.data[0].HFixCols += 1;
			}
			option.cols[0][i + 1]["fixed"] = "left";
			}
			}
			table.render(option);
			} else {
			table.render(option);
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			//åææ¾ç¤ºä¸ææ¡
			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');
			}
			function addTotalField(arr) {
			return arr.map(obj => {
			// åå»ºæ°å¯¹è±¡ï¼é¿åä¿®æ¹åå¯¹è±¡
			const newObj = { ...obj };

			// è®¡ç®ç¬¦åæ¥ææ ¼å¼çåæ®µå¼çåè®¡
			let total = 0;
			for (const [key, value] of Object.entries(obj)) {
			if (isValidDate(key)) {
			// ç¡®ä¿å¼æ¯æ°åç±»å
			const numValue = Number(value);
			if (!isNaN(numValue)) {
			total += numValue;
			}
			}
			}
			// å¤çæµ®ç¹æ°ç²¾åº¦é®é¢
			const roundedTotal = parseFloat(total.toFixed(2));

			// æ·»å ææè®¡ååè®¡åæ®µ
			newObj['ææè®¡ååè®¡'] = roundedTotal;

			return newObj;
			});
			}

			//#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>