MES-WEB-LayUI.git

New file
			@@ -0,0 +1,772 @@
			ï»¿<!DOCTYPE html>
			<html>
			<head>
			<meta charset="utf-8" />
			<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">
			<div class="layui-col-md12">
			<div class="layui-card" style="padding: 1px">
			<div class="layui-card-body" style="padding: 1px;">
			<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" style="display:none">
			<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>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">è¿ç®æ è¯</label>
			<div class="layui-input-block">
			<select name="HIDentificat" id="HIDentificat" class="ForFilteringSchemes" lay-filter="HIDentificat" style="width:190px;">
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">çäº§è½¦é´</label>
			<div class="layui-input-block">
			<select name="HWorkShopID" id="HWorkShopID" lay-verify="required" lay-search class="layui-input ForFilteringSchemes">
			<!--å¨ææ¸²æè½¦é´-->
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">éæ±è½¦é´</label>
			<div class="layui-input-block">
			<select name="HWorkShopID2" id="HWorkShopID2" lay-verify="required" lay-search class="layui-input ForFilteringSchemes">
			<!--å¨ææ¸²æè½¦é´-->
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">æ¥æé´é</label>
			<div class="layui-input-block">
			<select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">
			</select>
			</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="date" class="layui-input" lay-verify="HBEGINDATE" name="HBEGINDATE" id="HBEGINDATE" style="padding-left: 78px;">
			</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="date" class="layui-input" lay-verify="HENDDATE" name="HENDDATE" id="HENDDATE" style="padding-left: 78px;">
			</div>
			</div>
			<div class="layui-row">
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">äº§åç¼ç </label>
			<div class="layui-input-block" style="margin-left: 77px;">
			<input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label">ç©æå±æ§</label>
			<div class="layui-input-block">
			<select name="HMaterClsID" id="HMaterClsID" lay-verify="HMaterClsID">
			<option value="0" selected>å¨é¨</option>
			<option value="1">å¤è´</option>
			<option value="2">èªå¶</option>
			<option value="3">å§å¤</option>
			</select>
			</div>
			</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>

			<!--<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:10px;">
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">äº§åç¼ç </label>
			<div class="layui-input-block" style="margin-left: 77px;">
			<input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</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="HMOBILLNO" id="HMOBILLNO">
			</div>
			</div>
			</div>
			</div>-->
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			</form>
			</div>
			</div>
			</div>
			</div>
			</body>
			</html>
			<script>
			var treeCkData = { id: 0 };
			var TagId = "";
			var TagParentId = "";
			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			soulTable: '../ext/soulTable',
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util', 'soulTable', 'flow','tableSelect'], function () {
			//#region å¬ç¨åé
			var $ = layui.$
			, admin = layui.admin
			, layer = layui.layer
			, table = layui.table
			, form = layui.form
			, element = layui.element
			, laypage = layui.laypage
			, laydate = layui.laydate
			, util = layui.util
			, tree = layui.tree
			, util = layui.util
			, soulTable = layui.soulTable
			, flow = layui.flow
			, tableSelect = layui.tableSelect;
			var sWhere = "";
			var option = [];
			var ins; //ç¨äºå¯¼åºexcel
			var HModName = "JIT_MaterialLevelShorAnalysisReport";

			var HIDentificat_ValueList = [];
			var HIDentificat_TitleList = [];
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½

			//åå§åçé¢
			set_ClearBill();

			//#endregion

			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

			//#endregion è¾å¥æ¡åè½¦çå¬
			//$('input[type="text"]').on('keydown', function (event) {
			// if (event.keyCode == 13) {
			// $("#btnSearch").click();
			// }
			//});
			//#endregion

			//#region è¿ç®æ è¯ä¸æåè¡¨çå¬
			form.on('select(HIDentificat)', function (data) {
			var value = data.value;
			if ($.inArray(value, HIDentificat_ValueList)>-1) {
			var HIDentificat_Title = HIDentificat_TitleList[$.inArray(value, HIDentificat_ValueList)];
			var HBeginDate = Format(Date.parse(HIDentificat_Title), "yyyy-MM-dd");
			var HEndDate = Format(new Date(Date.parse(HIDentificat_Title) + 1000 * 60 * 60 * 24 * 50), "yyyy-MM-dd");

			$("#HBEGINDATE").val(HBeginDate);
			$("#HENDDATE").val(HEndDate);

			get_FastQuery();
			}
			});
			//#endregion

			//#region äº§åç¼ç
			form.on('submit(btnHMATERIALID)', function (data) {
			btnHMATERIALID();
			});
			//#endregion

			//#region éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			set_ClearQuery();
			});
			//#endregion

			//#region æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery();
			});
			//#endregion

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

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

			//#region åå»è¡å¼¹åºå¼¹æ¡
			table.on('rowDouble(mainTable)', function (obj) {
			var HOrgID = $("#HORGID").val();
			var HMaterID = obj.data.ç©æID;
			var HWorkShopID = obj.data.éæ±è½¦é´ID;
			var HBEGINDATE = $("#HBEGINDATE").val();//æ¬ ææ¥æ
			var HENDDATE = $("#HENDDATE").val();//è³
			window.open('../../çäº§ç®¡ç/æ¬ æè¿ç®/JIT_MaterialLevelShorAnalysisDetailReport.html?type=2&HOrgID=' + HOrgID + "&HMaterID=" + HMaterID + "&HWorkShopID=" + HWorkShopID + "&HBEGINDATE=" + HBEGINDATE + "&HENDDATE=" + HENDDATE);
			//layer.open({
			// type: 2
			// , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
			// , area: ['90%', '90%']
			// , title: 'ä¸å±ç¼ºææåµ'
			// , shift: 2//å¼¹åºå¨ç»
			// , shade: 0.6 //é®ç½©éæåº¦
			// //, maxmin: true //åè®¸å¨å±æå°å
			// , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯
			// , content: ['../../çäº§ç®¡ç/æ¬ æè¿ç®/JIT_MaterialLevelShorAnalysisDetailReport.html?type=2&HOrgID=' + HOrgID + "&HMaterID=" + HMaterID + "&HWorkShopID=" + HWorkShopID + "&HBEGINDATE=" + HBEGINDATE + "&HENDDATE=" + HENDDATE, 'yes']
			//})
			})
			//#endregion

			//#endregion

			//æ¥æé´éä¸æåè¡¨çå¬
			form.on('select(HInitTimeCycle)', function (data) {
			var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
			//è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ©
			if (HInitTimeCycle !=0) {
			//$('#HBeginDate').prop('disabled', true);
			//$('#HEndDate').prop('disabled', true);

			$("#HBEGINDATE").val(Format(new Date().setDate(new Date().getDate()), "yyyy-MM-dd"));//æ¬ ææ¥æ
			$("#HENDDATE").val(Format(new Date().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//è³

			//æ§è¡æ¥è¯¢æ¹æ³
			get_FastQuery();
			}
			else {
			$('#HBeginDate').prop('disabled', false);
			$('#HEndDate').prop('disabled', false);
			}
			});

			//#endregion

			//#region æ¬é¡µé¢è¢«è°ç¨çæææ¹æ³

			//#region åå§åçé¢
			function set_ClearBill() {
			//è¿ç®æ è¯åå§å
			getHIDentificat_init();

			//ç©æè¡¨æ ¼ä¸ææç´¢æ¡
			tableSelect.render({
			elem: '#HMATERIALNAME',
			checkedKey: 'HItemID',
			searchKey: 'ç©æä»£ç ,ç©æåç§°',
			sWhere: '',//tableæç´¢sWhereæ¡ä»¶
			table: {
			url: GetWEBURL() + 'Gy_Material/page',
			where: { user: sessionStorage["HMaker"], "Organization": sessionStorage["Organization"] } ,
			cols: [[
			{ type: 'checkbox',fixed:'left' },
			{ field: 'HItemID', title: 'HItemID' },
			{ field: 'ç©æä»£ç ', title: 'ç©æä»£ç ' },
			{ field: 'ç©æåç§°', title: 'ç©æåç§°' },
			]],
			page: true,
			limit: 5,
			limits: [5]
			},
			done: function (elem, data) {
			if (data != []) {
			//è·åæ°æ®
			/$("#HMATERIALNAME").blur();//ååæ ¼å¤±å»ç¦ç¹/
			$("#HMATERIALID").val(data.data[0].HItemID);
			$("#HMATERIALNAME").val(data.data[0].ç©æåç§°);
			get_FastQuery()
			}

			}
			})
			//åå§åæ¥æé´éãå¼å§æ¥æãç»ææ¥æ
			setSelect_HInitTimeCycle();
			//è¥æ¥æé´éä¸ä¸º ä»»æé´éï¼åç¦ç¨å¼å§æ¥æä¸ç»ææ¥æçéæ©
			var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
			if (HInitTimeCycle !=0) {
			$("#HBEGINDATE").val(Format(new Date().setDate(new Date().getDate()), "yyyy-MM-dd"));//æ¬ ææ¥æ
			$("#HENDDATE").val(Format(new Date().setDate(new Date().getDate() + HInitTimeCycle), "yyyy-MM-dd"));//è³
			}
			//çäº§ç»ç»å è½½
			Organ();
			//è½¦é´
			get_Dept();
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//è®¾ç½®é¡µç
			DisPlay_HideColumn_GetPageSize(HModName, sessionStorage["HUserName"], option)
			//å¿«éè¿æ»¤
			get_FastQuery();
			}
			//#endregion

			//#region åå§åè¡¨æ ¼æ¹æ³
			function set_InitGrid() {
			var columns = [];

			//columns.push({ type: 'checkbox', fixed: 'left', sort: true });
			//columns.push({ field: 'éæ±è½¦é´ID', title: 'éæ±è½¦é´ID', sort: true, filter: true });
			//columns.push({ field: 'éæ±è½¦é´ç¼ç ', title: 'éæ±è½¦é´ç¼ç ', sort: true, filter: true });
			//columns.push({ field: 'éæ±è½¦é´åç§°', title: 'éæ±è½¦é´åç§°', sort: true, filter: true });
			//columns.push({ field: 'ç©æID', title: 'ç©æID', 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: 'ä¾è´§è½¦é´ID', title: 'ä¾è´§è½¦é´ID', 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, templet: function (d) { return d.æ¯å¦å¹éå°è®¢å ? 'å¦' : 'æ¯'; } });
			////columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' });
			////columns.push({ field: 'HPOOrderBillNote', title: 'å¤æ³¨' });
			////columns.push({ field: 'éè´å', title: 'éè´å' });
			//columns.push({ field: 'æ¯å¦å¹éå°è¦æè®¡åä¿¡æ¯', title: 'æ¯å¦å¹éå°è¦æè®¡åä¿¡æ¯', sort: true, filter: true, templet: function (d) { return d.æ¯å¦å¹éå°è¦æè®¡åä¿¡æ¯ ? 'å¦' : 'æ¯'; } });
			// 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: 'åºåå·²å ç¨æ»æ°é', 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: 'å±çº§', 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()));//å¼å§æ¶é´
			//var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´
			//var Days = Math.abs(parseInt((time2 - time1) / 1000 / 3600 / 24));
			////è·åå¹´
			//var yyyy = new Date($("#HBEGINDATE").val()).getFullYear();
			////è·åæä»½
			//var MM = new Date($("#HBEGINDATE").val()).getMonth() + 1;
			////è·åå¼å§æä»½çæå¤§å¤©æ°
			//var SumMonth = new Date(yyyy, MM, 0).getDate(); //å¨æä¸¤æä¹å·®
			////è·åå¼å§æ¥æçå¤©æ°
			//var HBEGINDATE = new Date(new Date($("#HBEGINDATE").val())).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;
			// }
			//}
			//columns.push({ field: 'Total', title: 'æ¬ æè®¡ååè®¡', filter: true });

			option = {
			elem: '#mainTable'
			//, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, limit: 1000
			, limits: [50, 500,1000, 2000]
			, totalRow: true
			, loading: false
			, cols: [columns]
			, done: function (res, curr, count) {
			soulTable.render(this);
			for (var i in res.data) {
			var item = res.data[i];

			if (item["æªå¹éè®¢åæ°é"] > 0) {
			$("tr[data-index='" + i + "']").attr({ "style": "background:red;color:black;" });
			}

			}
			}
			};
			}
			//#endregion

			//è·åç»ç»
			function Organ() {
			//è·åç»å½é¡µç»ç»å
			var Organization = '';
			$.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>';
			}
			$("#HORGID").append(Organization);
			$("#HORGID").val(sessionStorage["OrganizationID"])
			form.render('select');
			}
			layer.closeAll("loading");
			}
			})
			}

			//çäº§è½¦é´
			function get_Dept() {
			//è·åè½¦é´å
			var HDeptID = '<option value="0" style="color:red;" selected>å¨é¨è½¦é´</option>';
			var sql = "exec h_p_Gy_GetHDeptListISWorkShop " + sessionStorage["OrganizationID"]
			$.ajax({
			type: "get",
			url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList",
			async: false,
			data: { "sWhere": sql},
			success: function (result) {
			if (result.count == 1) { // è¯´æéªè¯æåäºï¼
			var data = result.data;
			for (var i = 0; i < data.length; i++) {
			HDeptID += '<option style="color:blue;" value="' + data[i].HItemID + '" >' + data[i].HName + '</option>';
			}
			$("#HWorkShopID").append(HDeptID);
			$("#HWorkShopID2").append(HDeptID);
			if (sessionStorage["HDeptID"] != "0") {
			$("#HWorkShopID").val(sessionStorage["HDeptID"]);
			//ç¨æ·ç»å®çè½¦é´ä¸åå¨ï¼åé»è®¤æ¾ç¤ºå¨é¨è½¦é´
			if ($("#HWorkShopID").val() == null \|\| $("#HWorkShopID").val() == undefined) {
			$("#HWorkShopID").val(0);
			}
			}

			//$("#HDeptName").val("0");

			form.render('select');

			}
			layer.closeAll("loading");
			}
			})
			}

			//#region æ¥è¯¢
			function get_Display(sql) {
			var ajaxLoad = layer.load();
			var ModRightNameCheck = "";
			$.ajax({
			url: GetWEBURL() + '/CommonModel/searchMethod',
			type: "GET",
			async: false,
			data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck },
			success: function (data1) {
			if (data1.count == 1) {
			var data = [];//ååæ®µæ°æ®
			var col = [];
			var totalArray = [];
			var titleData = [];
			//ç»ç©ºçæ°ç»èµå¼
			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', totalRowText: 'åè®¡' });
			for (var i = 0; i < data.length; i++) {//éådataæ°ç»éçæ°æ®
			// if (data[i].name == 'HInterID' \|\| data[i].name == 'HBillType' \|\| data[i].name == 'hmainid') {
			if ($.inArray(data[i].name, titleData) > -1) {//æ£æ¥dataãiã.nameæ¯å¦å¨æ°ç»ä¸ //è®¡ç®å
			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, filter: true });
			} else if (data[i].name == 'æªå¹éè®¢åæ°é') {
			col.push({
			field: 'æªå¹éè®¢åæ°é', title: 'æªå¹éè®¢åæ°é', sort: true, filter: true, templet: function (d) {
			return d.æªå¹éè®¢åæ°é > 0 ? '<span style="color: black;">' + d.æªå¹éè®¢åæ°é + '</span>' : d.æªå¹éè®¢åæ°é;
			} });
			}
			else if (data[i].name == 'æªå¹éè¦æè®¡åä¿¡æ¯æ°é') {
			col.push({
			field: 'æªå¹éè¦æè®¡åä¿¡æ¯æ°é', title: 'æªå¹éè¦æè®¡åä¿¡æ¯æ°é', sort: true, filter: true, templet: function (d) {
			return d.æªå¹éè¦æè®¡åä¿¡æ¯æ°é > 0 ? '<span style="color: black;">' + d.æªå¹éè¦æè®¡åä¿¡æ¯æ°é + '</span>' : d.æªå¹éè¦æè®¡åä¿¡æ¯æ°é;
			}
			});
			} else if (isValidDate(data[i].name)) {
			col.push({
			field: data[i].name, title: Format(data[i].name, 'MM.dd'), width: 70, totalRow: true, filter: true, templet: function (d) {
			//è·åå½åä»å¤©æå¤©åå¤©ä¸å¤©çæ¥æåç¬¦ä¸²
			const dates = [];
			const today = new Date();
			for (let i = 0; i < 3; i++) {
			const date = new Date(today);
			date.setDate(today.getDate() + i);
			const dateStr = date.toISOString().slice(0, 10);
			dates.push(`${dateStr}`);
			}
			// å¦æè¡æ¥æå¨å½åæ¥æä¸å¤©åï¼ååå®¹æ çº¢
			if ((this.field == dates[0] \|\| this.field == dates[1] \|\| this.field == dates[2]) && d[this.field] != null) {
			return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
			} else {
			return d[this.field] == null ? 0 : d[this.field]
			}
			}
			})
			}
			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 == "è¡å³éæ¥æ" ? "è¡å³éäºº" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
			break;
			default:
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, filter: true, width: 200 });
			}
			}
			}
			option.cols = [col];
			option.data = data1.data;
			//åè®¾ç½®
			DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option);
			ins = table.render(option);
			layer.close(ajaxLoad);
			} else {
			layer.alert(data1.code + data1.Message, { icon: 5 });
			layer.close(ajaxLoad);
			}
			}, error: function () {
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			layer.close(ajaxLoad);
			}
			});
			}

			//#endregion

			// çéå½æ°ï¼æ£æ¥åç¬¦ä¸²æ¯å¦ç¬¦åæ ¼å¼çéæ¥æ
			function isValidDate(dateStr) {
			// æ£åè¡¨è¾¾å¼éªè¯æ ¼å¼
			const formatRegex = /^\d{4}-(0[1-9]\|1[0-2])-(0[1-9]\|[12][0-9]\|3[01])$/;
			if (!formatRegex.test(dateStr)) return false;

			// åå²å¹´ææ¥å¹¶è½¬æ¢ä¸ºæ°å¼
			const [year, month, day] = dateStr.split('-').map(Number);

			// åå»ºDateå¯¹è±¡ï¼æä»½ä»0å¼å§ï¼
			const date = new Date(year, month - 1, day);

			// æ£æ¥æ¥ææ¯å¦ææï¼ä¸è¾å¥çå¹´ææ¥ä¸è´ï¼
			return (
			date.getFullYear() === year &&
			date.getMonth() === month - 1 &&
			date.getDate() === day
			);
			}


			//#region è·åå¯¼åºæ°æ®
			function getExportData() {
			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, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			});

			table.exportFile(ins.config.id, data, "xls");
			}
			//#endregion

			//#region å¿«éè¿æ»¤
			function get_FastQuery() {
			HORGID = $("#HORGID").val();//ç»ç»
			var HBEGINDATE = $("#HBEGINDATE").val();//æ¬ ææ¥æ
			var HENDDATE = $("#HENDDATE").val();//è³
			var HMATERIALID = $("#HMATERIALID").val();//ç©æ/äº§å
			var HMATERIALNAME = $("#HMATERIALNAME").val();//ç©æåç§°
			var HWorkShopID = $("#HWorkShopID").val();//ç©æ/äº§å
			var HWorkShopID2 = $("#HWorkShopID2").val();//ç©æ/äº§åéæ±è½¦é´
			var HMaterClsID = $("#HMaterClsID").val();//ç©æå±æ§
			var HIDentificat = $("#HIDentificat").val();//è¿ç®æ è¯

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

			if (HORGID != "") {
			sWhere += " and T1.HStockORGID= " + HORGID+" ";
			}
			if (HWorkShopID != 0) {
			sWhere += " and T1.HSupplyWorkShopID= " + HWorkShopID + " ";
			}
			if (HWorkShopID2 != 0) {
			sWhere += " and T1.HWorkShopID= " + HWorkShopID2 + " ";
			}
			if (HMaterClsID != 0) {
			sWhere += " and T1.HMaterClsID=" + HMaterClsID + " ";
			}
			//if (HBEGINDATE != null && HENDDATE != null) {
			// sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' ";
			//}
			if (HMATERIALID != 0) {
			sWhere += " and T1.HMaterID= " + HMATERIALID + " ";
			} else {
			if (HMATERIALNAME != "") {
			sWhere += " and (T2.HName like ''%" + HMATERIALNAME + "%'' or T2.HNumber like ''%" + HMATERIALNAME + "%'') ";
			}
			}

			var sql = "exec h_p_JIT_MaterialLevelShorReportList_His '" + sWhere + "','" + HBEGINDATE + "','" + HENDDATE + "','" + HIDentificat + "'";
			get_Display(sql);

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

			//#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³
			function set_ClearQuery() {
			$("#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("");//ç©æ/äº§å
			$("#HMATERIALNAME").val("");
			$("#HWorkShopID").val("0");
			$("#HWorkShopID2").val("0");
			$("#HMaterClsID").val("0");
			form.render('select');
			sWhere = "";
			}
			//#endregion

			//ç©æåè¡¨
			function btnHMATERIALID() {
			layer.open({
			type: 2 //ç±»å
			, skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
			, area: ['90%', '90%']//å¤§å°
			, title: 'ç©æåè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../åºç¡èµæ/å¬ç¨åºç¡èµæ/Gy_Material.html', 'yes']
			, btn: ['ç¡®å®', 'åæ¶']
			, btn1: function (index, layero) {//æé®ãæé®ä¸ãçåè°
			var iframeWindow = window['layui-layer-iframe' + index] //è·åå¼¹æ¡é¡µé¢
			var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//è·åtableçelem:"#test"
			if (checkStatus.data.length === 0) {
			return layer.msg('è¯·éæ©æ°æ®');
			}
			//è·åæ°æ®
			$("#HMATERIALID").val(checkStatus.data[0].HItemID);
			$("#HMATERIALNAME").val(checkStatus.data[0].ç©æåç§°);
			layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			, btn2: function (index, layero) { }
			})
			}

			//#region åå§æ¥æé´é ä¸æåè¡¨
			function setSelect_HInitTimeCycle() {
			var valueList = [30, 45, 60];
			var titleList = ["è¿ä¸æ", "è¿45å¤©", "è¿60å¤©"];

			var HInitTimeCycle_ArrayList = '<option value="-1" selected="selected" >ä»»æé´é</option>';
			for (var i = 0; i < valueList.length; i++) {
			HInitTimeCycle_ArrayList += '<option style="color:blue;" value="' + valueList[i] + '">' + titleList[i] + '</option>';
			}

			$("#HInitTimeCycle").empty();
			$("#HInitTimeCycle").append(HInitTimeCycle_ArrayList);
			form.render('select');

			$("#HInitTimeCycle").val("60");
			}
			//#endregion

			//#region è¿ç®æ è¯
			function getHIDentificat_init() {
			var sql = "select HIDentificat, min(convert(varchar(100),HMakeDate,20)) HMakeDate from JIT_MOMaterLackBill where ISNULL(HIDentificat, '') <> '' group by HIDentificat order by min(convert(varchar(100),HMakeDate,20)) desc";
			var ModRightNameCheck = "";
			$.ajax({
			url: GetWEBURL() + '/CommonModel/searchMethod',
			async: false,
			type: "GET",
			data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck },
			success: function (data1) {
			if (data1.count == 1) {
			var Organization = "";
			if (data1.count == 1) {
			var data = data1.data;
			for (var i = 0; i < data.length; i++) {
			Organization += '<option style="color:blue;" value="' + data[i].HIDentificat + '">' + data[i].HMakeDate + '</option>';

			HIDentificat_ValueList.push(data[i].HIDentificat);
			HIDentificat_TitleList.push(data[i].HMakeDate);
			}
			$("#HIDentificat").append(Organization);
			if (data.length > 0) {
			$("#HIDentificat").val(data[0].HIDentificat);
			}
			form.render('select');
			}
			} else {
			layer.alert(data1.code + data1.Message, { icon: 5 });
			}
			}, error: function (e) {
			layer.alert(e + "æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}
			//#endregion


			//#endregion
			//ä»¥ä¸æ¯layuiæ¨¡å
			});
			function GetGyMaterial(obj) {
			$("#HMATERIALID").val(obj.HItemID);
			$("#HMATERIALNAME").val(obj.ç©æåç§°);
			}
			function GetHDeptNameValue(obj) //è¿åéè´é¨é¨
			{
			$("#HWorkShopID").val(obj[0].HItemID);//è½¦é´id
			$("#HWorkShopIDName").val(obj[0].é¨é¨åç§°);//è½¦é´åç§°
			}
			</script>

	WebTM/Properties/PublishProfiles/LAYUI.pubxml.user	7 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/WebTM.csproj	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/欠料运算/JIT_MaterialLevelShorAnalysisReport_His.html	772 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

			@@ -29,11 +29,11 @@
			</File>
			<File Include="bin/WebTM.dll">
			<publishTime>04/27/2021 20:31:08</publishTime>
			<publishTime>06/06/2025 13:13:09</publishTime>
			<publishTime>06/06/2025 15:00:35</publishTime>
			</File>
			<File Include="bin/WebTM.pdb">
			<publishTime>04/27/2021 20:31:08</publishTime>
			<publishTime>06/06/2025 13:13:09</publishTime>
			<publishTime>06/06/2025 15:00:35</publishTime>
			</File>
			<File Include="HtmlPage1.html">
			<publishTime>04/11/2023 16:34:42</publishTime>
			@@ -5794,6 +5794,9 @@
			<File Include="views/çäº§ç®¡ç/æ¬ æè¿ç®/JIT_MaterialLevelShorAnalysisReport.html">
			<publishTime>06/03/2025 16:35:43</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/æ¬ æè¿ç®/JIT_MaterialLevelShorAnalysisReport_His.html">
			<publishTime>06/06/2025 15:56:34</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/çæ¬¡å¼çå/Sc_ShiftsBeginInfoBillList.html">
			<publishTime>05/15/2025 14:44:59</publishTime>
			</File>

			@@ -635,6 +635,7 @@
			<Content Include="views\çäº§ç®¡ç\æ¥è®¡ååºç¡èµæ\JIT_NeedMaterPlanConfigBill_Excel.html" />
			<Content Include="views\çäº§ç®¡ç\æ¥è®¡åæ¥è¡¨\JIT_DayPlanPlatFormHistoryNoteReport.html" />
			<Content Include="views\çäº§ç®¡ç\æ¥è®¡åæ¥è¡¨\JIT_FuHeFenXiReportDetail.html" />
			<Content Include="views\çäº§ç®¡ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysisReport_His.html" />
			<Content Include="views\çäº§ç®¡ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysis.html" />
			<Content Include="views\çäº§ç®¡ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysisDetailReport.html" />
			<Content Include="views\çäº§ç®¡ç\æ¬ æè¿ç®\JIT_MaterialLevelShorAnalysisReport.html" />