MES-WEB-LayUI.git

			@@ -164,9 +164,15 @@
			<div class="layui-btn-container">
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></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>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_export_normal" id="get_export_normal"><i class="layui-icon layui-icon-export"></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>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button>
			</div>
			</script>
			<script type="text/html" id="toolbarDemo1">
			<div class="layui-btn-container">
			<button type="button" class="layui-btn layui-btn-sm" lay-event="get_export_normal" id="get_export_normal"><i class="layui-icon layui-icon-export"></i>å¯¼åº(å¸¸è§)</button>
			</div>
			</script>
			</form>
			@@ -201,6 +207,10 @@
			var option_Bak = {};
			var option1_Bak = {};
			var sWhere_Bak = "";


			var ins1;
			var ins2;
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½
			@@ -224,6 +234,10 @@
			case 'get_export':
			get_Export();
			break;
			//å¯¼åºexcel
			case 'get_export_normal':
			get_Export_Normal();
			break;
			//åè®¾ç½®
			case 'set_HideColumn': get_HideColumn();
			break;
			@@ -232,6 +246,17 @@
			var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡
			var HBillType = "Kf_SellOutEntryReport";
			get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
			break;
			};
			});
			//#endregion

			//#region å¤´å·¥å·æ äºä»¶
			table.on('toolbar(mainTable1)', function (obj) {
			switch (obj.event) {
			//å¯¼åºexcel
			case 'get_export_normal':
			get_Export1_Normal();
			break;
			};
			});
			@@ -319,7 +344,7 @@

			option1 = {
			elem: '#mainTable1'
			//, toolbar: '#toolbarDemo'
			, toolbar: '#toolbarDemo1'
			, height: 'full-50'
			, page: true
			, totalRow: true
			@@ -470,22 +495,24 @@
			option1.data = result1;

			//æ¸²æè¡¨1ãè¡¨2
			table.render(option);
			table.render(option1);
			ins1 = table.render(option);
			ins2 = table.render(option1);
			DisPlay_HideColumn();

			HPieceQtyTotalSum = HPieceQtySum + HPieceQtySum_YM;
			HQtyTotalSum = HQtySum + HQtySum_YM;
			HMoneyTotalSum = HMoneySum + HMoneySum_YM;
			$("#HPieceQtySum").val(fixed(HPieceQtySum*1));
			$("#HQtySum").val(fixed(HQtySum.toFixed(2)*1));
			$("#HMoneySum").val(fixed(HMoneySum.toFixed(2)*1));
			$("#HQtySum").val(fixed(HQtySum.toFixed(6)*1));
			$("#HMoneySum").val(fixed(HMoneySum.toFixed(6)*1));
			$("#HPieceQtySum_YM").val(fixed(HPieceQtySum_YM*1));
			$("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(2)*1));
			$("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(2)*1));
			$("#HQtySum_YM").val(fixed(HQtySum_YM.toFixed(6)*1));
			$("#HMoneySum_YM").val(fixed(HMoneySum_YM.toFixed(6)*1));
			$("#HPieceQtyTotalSum").val(fixed(HPieceQtyTotalSum*1));
			$("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(2)*1));
			$("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(2)*1));
			$("#HQtyTotalSum").val(fixed(HQtyTotalSum.toFixed(6)*1));
			$("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6)*1));



			//å·æ°æé®æ¾ç¤º
			var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡
			@@ -566,7 +593,7 @@
			sWhere += " and CONVERT(varchar(100),æ¥æ, 120) <= ''" + HDate1 + "''";
			}
			if (HCusName) {
			sWhere += " and å®¢æ· like ''%" + HCusName + "%''";
			sWhere += " and è´è´§åä½ like ''%" + HCusName + "%''";
			}
			if (HEmpName) {
			sWhere += " and ä¸å¡å like ''%" + HEmpName + "%''";
			@@ -634,6 +661,50 @@
			success: function (result) {
			if (result.count == 1) {
			exportAll();
			} else {
			layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#endregion

			//#region å¸¸è§å¯¼åºExecel
			function get_Export_Normal() {
			var ModRightNameCheck = "Kf_SellOutEntryReport_ExportExcel";

			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			table.exportFile(ins1.config.id, option.data, "xls");
			} else {
			layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#endregion

			//#region å¸¸è§å¯¼åºExecel
			function get_Export1_Normal() {
			var ModRightNameCheck = "Kf_SellOutEntryReport_ExportExcel";

			//é»è¾å®¡æ ¸æ¹æ³
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å
			data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			table.exportFile(ins2.config.id, option1.data, "xls");
			} else {
			layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
			}
			@@ -825,14 +896,22 @@

			//è·åè¡æ°æ®
			var listData = []; //è·åè¡æ°æ®
			var HPieceQtyTotalSum = 0;
			var HQtyTotalSum = 0;
			var HTaxMoneyTotalSum = 0;
			if (option.data.length > 0) {
			var HEmpID = option.data[0]["HEmpID"]; //ç¨äºåºåä¸åå®¢æ·
			var HEmpID = option.data[0]["HEmpID"]; //ç¨äºåºåä¸åä¸å¡å
			var HCusID = option.data[0]["HCusID"]; //ç¨äºåºåä¸åå®¢æ·
			var HPieceQtySum = 0; //ä»¶æ°åè®¡
			var HQtySum = 0; //æ°éåè®¡
			var HTaxMoneySum = 0; //éé¢åè®¡
			for (var i = 0; i < option.data.length; i++) {
			if (HEmpID != option.data[i]["HEmpID"]) {
			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": HPieceQtySum, "ç±³æ°": HQtySum, "åä»·": "", "éé¢": HTaxMoneySum, "ä¸å¡å": "" };
			if (HEmpID != option.data[i]["HEmpID"] \|\| HCusID != option.data[i]["HCusID"]) {
			HPieceQtyTotalSum += HPieceQtySum;
			HQtyTotalSum += HQtySum;
			HTaxMoneyTotalSum += HTaxMoneySum;

			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": fixed(HPieceQtySum * 1) + "ä»¶", "ç±³æ°": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "åä»·": "", "éé¢": fixed(HTaxMoneySum.toFixed(6) * 1), "ä¸å¡å": "" };
			var emptyTemp = { "è´è´§åä½": "", "äº§ååç§°": "", "ä»¶æ°": "", "ç±³æ°": "", "åä»·": "", "éé¢": "", "ä¸å¡å": "" };
			var titleTemp = { "è´è´§åä½": "è´è´§åä½", "äº§ååç§°": "äº§ååç§°", "ä»¶æ°": "ä»¶æ°", "ç±³æ°": "ç±³æ°", "åä»·": "åä»·", "éé¢": "éé¢", "ä¸å¡å": "ä¸å¡å" };
			listData.push(sumTemp);
			@@ -842,6 +921,7 @@

			//è®°å½æ°å®¢æ·çåç
			HEmpID = option.data[i]["HEmpID"];
			HCusID = option.data[i]["HCusID"];

			//åå§åä»¶æ°åè®¡ãæ°éåè®¡ãéé¢åè®¡
			HPieceQtySum = 0;
			@@ -855,8 +935,20 @@
			HTaxMoneySum += option.data[i]["éé¢"] * 1;

			if (i == option.data.length - 1) {
			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": HPieceQtySum, "ç±³æ°": HQtySum, "åä»·": "", "éé¢": HTaxMoneySum, "ä¸å¡å": "" };
			HPieceQtyTotalSum += HPieceQtySum;
			HQtyTotalSum += HQtySum;
			HTaxMoneyTotalSum += HTaxMoneySum;
			HPieceQtyTotalSum = fixed(HPieceQtyTotalSum * 1);
			HQtyTotalSum = fixed(HQtyTotalSum.toFixed(6) * 1);
			HTaxMoneyTotalSum = fixed(HTaxMoneyTotalSum.toFixed(6) * 1);

			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": fixed(HPieceQtySum * 1) + "ä»¶", "ç±³æ°": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "åä»·": "", "éé¢": fixed(HTaxMoneySum.toFixed(6) * 1), "ä¸å¡å": "" };
			var emptyTemp = { "è´è´§åä½": "", "äº§ååç§°": "", "ä»¶æ°": "", "ç±³æ°": "", "åä»·": "", "éé¢": "", "ä¸å¡å": "" };
			var totalTemp = { "è´è´§åä½": "æ»åè®¡", "äº§ååç§°": "", "ä»¶æ°": HPieceQtyTotalSum + "ä»¶", "ç±³æ°": HQtyTotalSum + "ç±³", "åä»·": "", "éé¢": HTaxMoneyTotalSum, "ä¸å¡å": "" };
			listData.push(sumTemp);
			listData.push(emptyTemp);
			listData.push(emptyTemp);
			listData.push(totalTemp);
			}
			}
			}
			@@ -891,14 +983,22 @@

			//è·åè¡æ°æ®
			var listData = []; //è·åè¡æ°æ®
			var HPieceQtyTotalSum = 0;
			var HQtyTotalSum = 0;
			var HTaxMoneyTotalSum = 0;
			if (option.data.length > 0) {
			var HEmpID = option.data[0]["HEmpID"]; //ç¨äºåºåä¸åå®¢æ·
			var HEmpID = option.data[0]["HEmpID"]; //ç¨äºåºåä¸åä¸å¡å
			var HCusID = option.data[0]["HCusID"]; //ç¨äºåºåä¸åå®¢æ·
			var HPieceQtySum = 0; //ä»¶æ°åè®¡
			var HQtySum = 0; //æ°éåè®¡
			var HTaxMoneySum = 0; //éé¢åè®¡
			for (var i = 0; i < option.data.length; i++) {
			if (HEmpID != option.data[i]["HEmpID"]) {
			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": HPieceQtySum, "ç±³æ°": HQtySum, "åä»·": "", "éé¢": HTaxMoneySum, "ä¸å¡å": "" };
			if (HEmpID != option.data[i]["HEmpID"] \|\| HCusID != option.data[i]["HCusID"]) {
			HPieceQtyTotalSum += HPieceQtySum;
			HQtyTotalSum += HQtySum;
			HTaxMoneyTotalSum += HTaxMoneySum;

			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": fixed(HPieceQtySum * 1) + "ä»¶", "ç±³æ°": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "åä»·": "", "éé¢": fixed(HTaxMoneySum.toFixed(6) * 1), "ä¸å¡å": "" };
			var emptyTemp = { "è´è´§åä½": "", "äº§ååç§°": "", "ä»¶æ°": "", "ç±³æ°": "", "åä»·": "", "éé¢": "", "ä¸å¡å": "" };
			var titleTemp = { "è´è´§åä½": "è´è´§åä½", "äº§ååç§°": "äº§ååç§°", "ä»¶æ°": "ä»¶æ°", "ç±³æ°": "ç±³æ°", "åä»·": "åä»·", "éé¢": "éé¢", "ä¸å¡å": "ä¸å¡å" };
			listData.push(sumTemp);
			@@ -908,6 +1008,7 @@

			//è®°å½æ°å®¢æ·çåç
			HEmpID = option.data[i]["HEmpID"];
			HCusID = option.data[i]["HCusID"];

			//åå§åä»¶æ°åè®¡ãæ°éåè®¡ãéé¢åè®¡
			HPieceQtySum = 0;
			@@ -921,8 +1022,20 @@
			HTaxMoneySum += option.data[i]["éé¢"] * 1;

			if (i == option.data.length - 1) {
			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": HPieceQtySum, "ç±³æ°": HQtySum, "åä»·": "", "éé¢": HTaxMoneySum, "ä¸å¡å": "" };
			HPieceQtyTotalSum += HPieceQtySum;
			HQtyTotalSum += HQtySum;
			HTaxMoneyTotalSum += HTaxMoneySum;
			HPieceQtyTotalSum = fixed(HPieceQtyTotalSum * 1);
			HQtyTotalSum = fixed(HQtyTotalSum.toFixed(6) * 1);
			HTaxMoneyTotalSum = fixed(HTaxMoneyTotalSum.toFixed(6) * 1);

			var sumTemp = { "è´è´§åä½": "åè®¡", "äº§ååç§°": "", "ä»¶æ°": fixed(HPieceQtySum * 1) + "ä»¶", "ç±³æ°": fixed(HQtySum.toFixed(6) * 1) + "ç±³", "åä»·": "", "éé¢": fixed(HTaxMoneySum.toFixed(6) * 1), "ä¸å¡å": "" };
			var emptyTemp = { "è´è´§åä½": "", "äº§ååç§°": "", "ä»¶æ°": "", "ç±³æ°": "", "åä»·": "", "éé¢": "", "ä¸å¡å": "" };
			var totalTemp = { "è´è´§åä½": "æ»åè®¡", "äº§ååç§°": "", "ä»¶æ°": HPieceQtyTotalSum + "ä»¶", "ç±³æ°": HQtyTotalSum + "ç±³", "åä»·": "", "éé¢": HTaxMoneyTotalSum, "ä¸å¡å": "" };
			listData.push(sumTemp);
			listData.push(emptyTemp);
			listData.push(emptyTemp);
			listData.push(totalTemp);
			}
			}
			}
			@@ -990,7 +1103,7 @@

			//åå»ºexcelææ¡£
			const wb = XLSX.utils.book_new();
			XLSX.utils.book_append_sheet(wb, sheet1, "æ¶¤çº¶");
			XLSX.utils.book_append_sheet(wb, sheet1, "FDY");
			XLSX.utils.book_append_sheet(wb, sheet2, "ç¾æ¯");
			const workbookBlob = workbook2blob(wb);