MES-WEB-LayUI.git

			@@ -3,7 +3,7 @@
			<head>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
			<title>éå®åºåºæç»æ¥è¡¨</title>
			<meta name="renderer" content="webkit">
			<meta name="renderer" content="webkit" charset="UTF-8">
			<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
			<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
			<link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
			@@ -15,6 +15,8 @@
			<script src="../../../layuiadmin/PubCustom.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<script src="../../../layuiadmin/HideButton.js"></script>
			<!--<script src="../../../layuiadmin/xlsx.full.min.js"></script>-->
			<script src="https://cdn.bootcdn.net/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
			</head>
			<body>
			<div class="layui-fluid">
			@@ -24,60 +26,153 @@
			<form class="layui-form" action="" lay-filter="component-form-group">
			<div class="layui-collapse">
			<div class="layui-colla-item">
			<div class="layui-colla-title layui-inline">
			<div class="layui-inline">
			<span>æ´å¤</span>
			</div>
			</div>
			<div class="layui-inline">
			<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="HCusName" id="HCusName">
			</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-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:5px">
			<div class="layui-row">
			<div class="layui-colla-title layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
			</select>
			<span>æ´å¤</span>
			</div>
			</div>
			<div class="layui-form layui-inline" style="width:200px;">
			<label class="layui-form-label" style="width:35px;">æ¥æ</label>
			<div class="layui-input-block" style="position:relative; left:-45px;">
			<input type="text" class="layui-input" id="HBeginDate" placeholder="yyyy-MM-dd HH:mm:ss" style="width:140px;">
			</div>
			</div>
			<div class="layui-inline" style="width:200px;">
			<label class="layui-form-label" style="width:5px;">-</label>
			<div class="layui-input-block" style="position:relative; left:-70px;">
			<input type="text" class="layui-input" id="HEndDate" placeholder="yyyy-MM-dd HH:mm:ss" style="width:140px;">
			</div>
			</div>
			<div class="layui-inline">
			<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="HCusName" id="HCusName">
			</div>
			</div>
			<div class="layui-inline">
			<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="HEmpName" id="HEmpName">
			</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-row" style="position:relative; left:30px;">
			<div class="layui-inline" style="width:450px;">
			<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="HPieceQtyTotalSum" id="HPieceQtyTotalSum" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			<span>ä»¶</span>
			<div class="layui-inline">
			<select name="Comparator" id="Comparator" 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>
			<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="HQtyTotalSum" id="HQtyTotalSum" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			<span>ç±³</span>
			<div class="layui-inline">
			<input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
			<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="HMoneyTotalSum" id="HMoneyTotalSum" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			</div>
			<div class="layui-row" style="position:relative; left:30px;">
			<div class="layui-inline" style="width:450px;">
			<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="HPieceQtySum" id="HPieceQtySum" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			<span>ä»¶</span>
			<div class="layui-inline">
			<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="HQtySum" id="HQtySum" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			<span>ç±³</span>
			<div class="layui-inline">
			<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="HMoneySum" id="HMoneySum" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			</div>
			<div class="layui-row" style="position:relative; left:30px;">
			<div class="layui-inline" style="width:450px;">
			<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="HPieceQtySum_YM" id="HPieceQtySum_YM" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			<span>ä»¶</span>
			<div class="layui-inline">
			<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="HQtySum_YM" id="HQtySum_YM" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			<span>ç±³</span>
			<div class="layui-inline">
			<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="HMoneySum_YM" id="HMoneySum_YM" style="background-color:#efefef4d;" readonly>
			</div>
			</div>
			</div>
			<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:5px">
			<div class="layui-inline">
			<label class="layui-form-label">è¿æ»¤</label>
			<div class="layui-input-block">
			<select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<select name="Comparator" id="Comparator" 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" value="" name="ColContent" id="ColContent">
			</div>
			</div>
			</div>
			</div>
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			<table class="" id="mainTable1" lay-filter="mainTable1"></table>
			<script type="text/html" id="toolbarDemo">
			<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>
			@@ -101,12 +196,21 @@
			, laypage = layui.laypage
			, laydate = layui.laydate
			, excel = layui.excel;
			var option = [];
			var option = {};
			var option1 = {};
			var sWhere = "";
			var ins; //ç¨äºå¯¼åºexcel
			var HModName = "Kf_SellOutEntryReport";
			//ä¸éè¦æ¾ç¤ºçåæ®µ å¯æ©å±
			var titleData = ["æ¥æ","HCusID","HMaterID","HEmpID"];
			var titleData = ["æ¥æ", "HCusID", "HMaterID", "HEmpID", "hmainid", "hsubid"];

			//å¯¼åºåè½è·åæ°æ®
			var option_Bak = {};
			var option1_Bak = {};
			var sWhere_Bak = "";


			var ins1;
			var ins2;
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½
			@@ -130,6 +234,10 @@
			case 'get_export':
			get_Export();
			break;
			//å¯¼åºexcel
			case 'get_export_normal':
			get_Export_Normal();
			break;
			//åè®¾ç½®
			case 'set_HideColumn': get_HideColumn();
			break;
			@@ -138,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;
			};
			});
			@@ -182,11 +301,31 @@

			//#region åå§åçé¢
			function set_ClearBill() {
			//åå§åæ¶é´
			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
			});

			//åå§åè¡¨æ ¼
			set_InitGrid();
			//æ¥è¯¢
			get_FastQuery(1);
			//Organ();

			DisPlay_HideColumn();

			}
			//#endregion

			@@ -195,6 +334,39 @@
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, totalRow: true
			//, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 50000]
			};

			option1 = {
			elem: '#mainTable1'
			, toolbar: '#toolbarDemo1'
			, height: 'full-50'
			, page: true
			, totalRow: true
			//, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 50000]
			};

			option_Bak = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, totalRow: true
			//, cellMinWidth: 90
			, limit: 50
			, limits: [50, 500, 5000, 50000]
			};

			option1_Bak = {
			elem: '#mainTable1'
			//, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, totalRow: true
			@@ -215,7 +387,7 @@
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "userid": sessionStorage["Czybm"]},
			success: function (data1) {
			if (data1.count == 1) {
			var totalArray = ["ä»¶æ°", "æ°é","éé¢"];
			var totalArray = ["ä»¶æ°", "ç±³æ°","éé¢"];
			var data = [];
			var col = [];
			//ç»ç©ºçæ°ç»èµå¼
			@@ -244,9 +416,103 @@
			}
			}

			//è®¾ç½®è¡¨1æ°æ®
			option.cols = [col];
			option.data = data1.data;
			ins = table.render(option);
			option.data = data1.data[0];

			//è·åè¡¨2æ°æ®
			option1.cols = [col];
			option1.data = data1.data[1];

			//è®¾ç½®è¡¨1ï¼åè¡¨åä¸ä¸ªåæ®åªæç¬¬ä¸æ¡æ°æ®æ¾ç¤ºä¸»è¡¨ä¿¡æ¯ï¼å¶å®è®°å½åªæ¾ç¤ºåè¡¨ä¿¡æ¯ï¼åè®¡æ°æ®
			//è®¾ç½®æ°æ®ï¼å£°æè®¡ç®åè®¡çåé
			var HPieceQtyTotalSum = 0;
			var HQtyTotalSum = 0;
			var HMoneyTotalSum = 0;
			var HPieceQtySum = 0;
			var HQtySum = 0;
			var HMoneySum = 0;
			var HPieceQtySum_YM = 0;
			var HQtySum_YM= 0;
			var HMoneySum_YM = 0;
			//è·ååè¡¨åæ°æ®
			var colList = [];
			for (var i = 0; i < option.cols[0].length; i++) {
			colList.push(option.cols[0][i].field);
			}
			//è®¾ç½®æ°æ®
			var result = data1.data[0];
			var temp = "";
			for (var i = 0; i < result.length; i++) {
			//è®¡ç®è¡¨1çåè®¡æ°æ®
			HPieceQtySum += result[i]["ä»¶æ°"] * 1;
			HQtySum += result[i]["ç±³æ°"] * 1;
			HMoneySum += result[i]["éé¢"] * 1;

			//è®¾ç½®åªæ¾ç¤ºåæ®çç¬¬ä¸è¡ä¸»è¡¨ä¿¡æ¯ï¼å¶ä»è¡åªæ¾ç¤ºåè¡¨ä¿¡æ¯
			if (temp != result[i]["hmainid"]) {
			temp = result[i]["hmainid"];
			} else {
			var initIndex = $.inArray("hmainid", colList);
			var lastIndex = $.inArray("hsubid", colList);
			for (var j = initIndex + 1; j < lastIndex; j++) {
			var fieldName = colList[j];
			result[i][fieldName] = "";
			}
			}
			}

			//è®¾ç½®è¡¨1ï¼åè¡¨åä¸ä¸ªåæ®åªæç¬¬ä¸æ¡æ°æ®æ¾ç¤ºä¸»è¡¨ä¿¡æ¯ï¼å¶å®è®°å½åªæ¾ç¤ºåè¡¨ä¿¡æ¯
			//è·ååè¡¨åæ°æ®
			var colList1 = [];
			for (var i = 0; i < option1.cols[0].length; i++) {
			colList1.push(option1.cols[0][i].field);
			}
			//è®¾ç½®æ°æ®
			var result1 = data1.data[1];
			var temp1 = "";
			for (var i = 0; i < result1.length; i++) {
			//è®¡ç®è¡¨2çåè®¡æ°æ®
			HPieceQtySum_YM += result1[i]["ä»¶æ°"] * 1;
			HQtySum_YM += result1[i]["ç±³æ°"] * 1;
			HMoneySum_YM += result1[i]["éé¢"] * 1;

			//è®¾ç½®åªæ¾ç¤ºåæ®çç¬¬ä¸è¡ä¸»è¡¨ä¿¡æ¯ï¼å¶ä»è¡åªæ¾ç¤ºåè¡¨ä¿¡æ¯
			if (temp1 != result1[i]["hmainid"]) {
			temp1 = result1[i]["hmainid"];
			} else {
			var initIndex = $.inArray("hmainid", colList1);
			var lastIndex = $.inArray("hsubid", colList1);
			for (var j = initIndex + 1; j < lastIndex; j++) {
			var fieldName = colList1[j];
			result1[i][fieldName] = "";
			}
			}
			}

			//è®¾ç½®è¡¨1ãè¡¨2å¤çåçæ°æ®
			option.data = result;
			option1.data = result1;

			//æ¸²æè¡¨1ãè¡¨2
			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(6)*1));
			$("#HMoneySum").val(fixed(HMoneySum.toFixed(6)*1));
			$("#HPieceQtySum_YM").val(fixed(HPieceQtySum_YM*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(6)*1));
			$("#HMoneyTotalSum").val(fixed(HMoneyTotalSum.toFixed(6)*1));



			//å·æ°æé®æ¾ç¤º
			var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡
			@@ -278,7 +544,21 @@

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

			var HCusName = $("#HCusName").val();//å®¢æ·åç§°
			var HEmpName = $("#HEmpName").val();//å®¢æ·åç§°

			//ä»»æåæ®µè¿æ»¤
			var ColName = $("#ColName").val();//å¤éæ¡
			@@ -306,9 +586,17 @@
			}
			sWhere += " and " + ColName + " " + com;
			}

			if (HDate) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 120) >= ''" + HDate + "''";
			}
			if (HDate1) {
			sWhere += " and CONVERT(varchar(100),æ¥æ, 120) <= ''" + HDate1 + "''";
			}
			if (HCusName) {
			sWhere += " and å®¢æ· like ''%" + HCusName + "%''";
			sWhere += " and è´è´§åä½ like ''%" + HCusName + "%''";
			}
			if (HEmpName) {
			sWhere += " and ä¸å¡å like ''%" + HEmpName + "%''";
			}

			/* sWhere += " and ç»ç»åç = " + sessionStorage["OrganizationID"];*/
			@@ -317,13 +605,34 @@
			sWhere += getSWhereByHUser();

			get_Display(sWhere);

			sWhere_Bak = sWhere;

			sWhere = "";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			//#endregion

			//#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³
			function set_ClearQuery() {
			//åå§åæ¶é´
			var HBeginDate = Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 1).setHours(8, 0, 0, 0), "yyyy-MM-dd hh");
			var HEndDate = Format(new Date(new Date()).setHours(8, 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
			});
			$("#HCusName").val("");
			$("#HEmpName").val("");

			$("#ColContent").val("");
			$("#ColName").val("0");
			@@ -351,31 +660,51 @@
			data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
			success: function (result) {
			if (result.count == 1) {
			var dataArray = [];
			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 (HCusID != option.data[i]["HCusID"]) {
			dataArray.push({ "æ¥æ": "", "HCusID": "", "å®¢æ·": "åè®¡", "HMaterID": "", "ç©æåç§°": "", "ä»¶æ°": HPieceQtySum, "æ°é": HQtySum, "åä»·": "", "éé¢": HTaxMoneySum, "HEmpID": "", "ä¸å¡å": "" });
			dataArray.push({ "æ¥æ": "", "HCusID": "", "å®¢æ·": "", "HMaterID": "", "ç©æåç§°": "", "ä»¶æ°": "", "æ°é": "", "åä»·": "", "éé¢": "", "HEmpID": "", "ä¸å¡å": "" });
			dataArray.push({ "æ¥æ": "", "HCusID": "", "å®¢æ·": "", "HMaterID": "", "ç©æåç§°": "", "ä»¶æ°": "", "æ°é": "", "åä»·": "", "éé¢": "", "HEmpID": "", "ä¸å¡å": "" });
			dataArray.push({ "æ¥æ": "", "HCusID": "", "å®¢æ·": "", "HMaterID": "", "ç©æåç§°": "", "ä»¶æ°": "", "æ°é": "", "åä»·": "", "éé¢": "", "HEmpID": "", "ä¸å¡å": "" });
			dataArray.push({ "æ¥æ": "", "HCusID": "", "å®¢æ·": "å®¢æ·", "HMaterID": "", "ç©æåç§°": "ç©æåç§°", "ä»¶æ°": "ä»¶æ°", "æ°é": "æ°é", "åä»·": "åä»·", "éé¢": "éé¢", "HEmpID": "", "ä¸å¡å": "ä¸å¡å" });
			HCusID = option.data[i]["HCusID"];
			HPieceQtySum = 0;
			HQtySum = 0;
			HTaxMoneySum = 0;
			}
			dataArray.push(option.data[i]);
			exportAll();
			} else {
			layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#endregion

			HPieceQtySum += option.data[i]["ä»¶æ°"] * 1;
			HQtySum += option.data[i]["æ°é"] * 1;
			HTaxMoneySum += option.data[i]["éé¢"] * 1;
			}
			//#region å¸¸è§å¯¼åºExecel
			function get_Export_Normal() {
			var ModRightNameCheck = "Kf_SellOutEntryReport_ExportExcel";

			table.exportFile(ins.config.id, dataArray, "xls");
			//é»è¾å®¡æ ¸æ¹æ³
			$.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 });
			}
			@@ -494,8 +823,12 @@
			}
			}
			table.render(option);
			option1.cols[0] = option.cols[0];
			table.render(option1);
			} else {
			table.render(option);
			option1.cols[0] = option.cols[0];
			table.render(option1);
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			@@ -544,6 +877,309 @@
			return res;
			}
			//#endregion

			//#region å¯¼åº
			function oneTable(option) {
			var exportCols = ["è´è´§åä½", "äº§ååç§°", "ä»¶æ°", "ç±³æ°", "åä»·", "éé¢", "ä¸å¡å"];

			//è·ååæ°æ®ï¼æ ¹æ®exportColsæ°ç»ä¸åçé¡ºåºå¯¼åº
			var colsList = [];
			for (var i = 0; i < exportCols.length; i++) {
			colsList.push(exportCols[i]);
			}
			for (var i = 1; i < option.cols[0].length; i++) {
			if ($.inArray(option.cols[0][i].title, exportCols) > -1) {
			var index = $.inArray(option.cols[0][i].title, exportCols);
			colsList[index] = option.cols[0][i];
			}
			}

			//è·åè¡æ°æ®
			var listData = []; //è·åè¡æ°æ®
			var HPieceQtyTotalSum = 0;
			var HQtyTotalSum = 0;
			var HTaxMoneyTotalSum = 0;
			if (option.data.length > 0) {
			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"] \|\| 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);
			listData.push(emptyTemp);
			listData.push(emptyTemp);
			listData.push(titleTemp);

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

			//åå§åä»¶æ°åè®¡ãæ°éåè®¡ãéé¢åè®¡
			HPieceQtySum = 0;
			HQtySum = 0;
			HTaxMoneySum = 0;
			}
			listData.push(option.data[i]);

			HPieceQtySum += option.data[i]["ä»¶æ°"] * 1;
			HQtySum += option.data[i]["ç±³æ°"] * 1;
			HTaxMoneySum += option.data[i]["éé¢"] * 1;

			if (i == option.data.length - 1) {
			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);
			}
			}
			}

			//è®¾ç½®sheetä¸çæ°æ®
			let news = [[]];
			for (var i = 0; i < colsList.length; i++) {
			news[0].push(colsList[i].title);
			}
			for (var i = 0; i < listData.length; i++) {
			news.push([listData[i][exportCols[0]], listData[i][exportCols[1]], listData[i][exportCols[2]], listData[i][exportCols[3]], listData[i][exportCols[4]], listData[i][exportCols[5]], listData[i][exportCols[6]] ]);
			}

			//åå»ºsheet
			const sheet = XLSX.utils.aoa_to_sheet(news);
			return sheet;
			}
			function twoTable(option) {
			var exportCols = ["è´è´§åä½", "äº§ååç§°", "ä»¶æ°", "ç±³æ°", "åä»·", "éé¢", "ä¸å¡å"];

			//è·ååæ°æ®ï¼æ ¹æ®exportColsæ°ç»ä¸åçé¡ºåºå¯¼åº
			var colsList = [];
			for (var i = 0; i < exportCols.length; i++) {
			colsList.push(exportCols[i]);
			}
			for (var i = 1; i < option.cols[0].length; i++) {
			if ($.inArray(option.cols[0][i].title, exportCols) > -1) {
			var index = $.inArray(option.cols[0][i].title, exportCols);
			colsList[index] = option.cols[0][i];
			}
			}

			//è·åè¡æ°æ®
			var listData = []; //è·åè¡æ°æ®
			var HPieceQtyTotalSum = 0;
			var HQtyTotalSum = 0;
			var HTaxMoneyTotalSum = 0;
			if (option.data.length > 0) {
			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"] \|\| 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);
			listData.push(emptyTemp);
			listData.push(emptyTemp);
			listData.push(titleTemp);

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

			//åå§åä»¶æ°åè®¡ãæ°éåè®¡ãéé¢åè®¡
			HPieceQtySum = 0;
			HQtySum = 0;
			HTaxMoneySum = 0;
			}
			listData.push(option.data[i]);

			HPieceQtySum += option.data[i]["ä»¶æ°"] * 1;
			HQtySum += option.data[i]["ç±³æ°"] * 1;
			HTaxMoneySum += option.data[i]["éé¢"] * 1;

			if (i == option.data.length - 1) {
			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);
			}
			}
			}

			//è®¾ç½®sheetä¸çæ°æ®
			let news = [[]];
			for (var i = 0; i < colsList.length; i++) {
			news[0].push(colsList[i].title);
			}
			for (var i = 0; i < listData.length; i++) {
			news.push([listData[i][exportCols[0]], listData[i][exportCols[1]], listData[i][exportCols[2]], listData[i][exportCols[3]], listData[i][exportCols[4]], listData[i][exportCols[5]], listData[i][exportCols[6]]]);
			}

			//åå»ºsheet
			const sheet = XLSX.utils.aoa_to_sheet(news);
			return sheet;
			}
			function exportAll() {
			$.ajax({
			url: GetWEBURL() + '/Kf_SellOutEntryReport/list',
			type: "GET",
			data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"], "userid": sessionStorage["Czybm"] },
			success: function (data1) {
			if (data1.count == 1) {
			var totalArray = ["ä»¶æ°", "ç±³æ°", "éé¢"];
			var data = [];
			var col = [];
			//ç»ç©ºçæ°ç»èµå¼
			for (var key in data1.list) {
			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 (data[i].name == 'HInterID' \|\| data[i].name == 'HBillType' \|\| data[i].name == 'hmainid') {
			if ($.inArray(data[i].name, titleData) > -1) {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
			}
			else if ($.inArray(data[i].name, totalArray) > -1) {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120, templet: "<div>{{d." + data[i].name + " ==null ?'':fixed(d." + data[i].name + ")}}</div>" });
			}
			else {
			switch (data[i].Type) {
			//int
			case 'DateTime':
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
			break;
			default:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 });
			}
			}
			}

			//è®¾ç½®è¡¨1å¯¼åºæ°æ®
			option_Bak.cols = [col];
			option_Bak.data = data1.data[0];

			//è·åè¡¨2å¯¼åºæ°æ®
			option1_Bak.cols = [col];
			option1_Bak.data = data1.data[1];

			//è·åsheet
			let sheet1 = oneTable(option_Bak);
			let sheet2 = twoTable(option1_Bak);

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

			// å¯¼åºæåçæ»è¡¨
			var ExcelName = "éå®åºåºæç»æ¥è¡¨" + Format(new Date(), "yyyy-MM-dd") + ".xlsx";
			openDownloadDialog(workbookBlob, ExcelName);
			} else {
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#region è®¾ç½®å¯¼åºåæ°
			function workbook2blob(workbook) {
			// çæexcelçéç½®é¡¹
			var wopts = {
			// è¦çæçæä»¶ç±»å
			bookType: "xlsx",
			// æ¯å¦çæShared String Table, å®æ¹è§£éæ¯, å¦æå¼å¯çæéåº¦ä¼ä¸é, ä½å¨ä½çæ¬IOSè®¾å¤ä¸ææ´å¥½çå¼å®¹æ§
			bookSST: false,
			type: "binary"
			};
			var wbout = XLSX.write(workbook, wopts);
			// å°åç¬¦ä¸²è½¬ArrayBuffer
			function s2ab(s) {
			var buf = new ArrayBuffer(s.length);
			var view = new Uint8Array(buf);
			for (var i = 0; i !== s.length; ++i) view[i] = s.charCodeAt(i) & 0xff;
			return buf;
			}
			let buf = s2ab(wbout);
			var blob = new Blob([buf], {
			type: "application/octet-stream"
			});
			return blob;
			}
			//#endregion
			//#region
			function openDownloadDialog(blob, fileName) {
			if (typeof blob === "object" && blob instanceof Blob) {
			blob = URL.createObjectURL(blob); // åå»ºblobå°å
			}
			var aLink = document.createElement("a");
			aLink.href = blob;
			// HTML5addçå±æ§, æå®ä¿åæä»¶å, å¯ä»¥ä¸è¦åç¼, æ³¨æ, ææ¶å
			aLink.download = fileName \|\| "";
			var event;
			if (window.MouseEvent) event = new MouseEvent("click");
			// ç§»å¨ç«¯
			else {
			event = document.createEvent("MouseEvents");
			event.initMouseEvent(
			"click",
			true,
			false,
			window,
			0,
			0,
			0,
			0,
			0,
			false,
			false,
			false,
			false,
			0,
			null
			);
			}
			aLink.dispatchEvent(event);
			}
			//#endregion
			//#endregion

			});

			//#endregion