SRM-LAYUI.git - Gitblit

			@@ -57,19 +57,19 @@
			<input type="text" class="layui-input" name="HNumber" id="HNumber">
			</div>
			</div>
			<!--<div class="layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label">产品名称</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HName" id="HName">
			</div>
			</div>-->
			</div>
			<!--<div class="layui-inline">
			<label class="layui-form-label">规格型号</label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HModel" id="HModel">
			</div>
			</div>-->
			<!--<div class="layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label">关闭状态</label>
			<div class="layui-input-block">
			<select id="HClStatus" name="HClStatus" lay-filter="">
			@@ -78,7 +78,7 @@
			<option value="已关闭">已关闭</option>
			</select>
			</div>
			</div>-->
			</div>
			<!--<div class="layui-inline">
			<label class="layui-form-label">开始日期</label>
			<div class="layui-input-block">
			@@ -91,7 +91,7 @@
			<input type="text" class="layui-input" name="HDate2" id="HDate2">
			</div>
			</div>-->
			<div class="layui-inline">
			<!--<div class="layui-inline">
			<label class="layui-form-label">交货时间</label>
			<div class="layui-input-block">
			<select id="Time" name="Time" lay-filter="">
			@@ -105,7 +105,7 @@
			<option value="8" selected="">长期交货</option>
			</select>
			</div>
			</div>
			</div>-->

			<!--<div class="layui-inline">
			<label class="layui-form-label">采购组织</label>
			@@ -125,7 +125,7 @@
			</select>
			</div>
			</div>-->
			<!--<div class="layui-inline">
			<div class="layui-inline">
			<label class="layui-form-label">是否已下推送货单</label>
			<div class="layui-input-block">
			<select id="HISGenerate" name="HISGenerate" lay-filter="">
			@@ -134,7 +134,7 @@
			<option value="否" selected="">否</option>
			</select>
			</div>
			</div>-->
			</div>
			<div class="layui-inline">
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			@@ -257,7 +257,7 @@
			, { field: '状态', title: '状态', sort: true, fixed: true }
			, { field: '单据号', title: '单据号', width: 180, sort: true, fixed: 'left' }
			, { field: '日期', title: '日期', width: 180, sort: true, fixed: 'left' }
			, { field: '供应商', title: '供应商', width: 180, sort: true, fixed: 'left' }
			, { field: '供应商', title: '供应商', width: 180, sort: true, fixed: 'left', hide: true }

			, { field: '物料代码', title: '物料代码', width: 180, sort: true }
			, { field: '物料名称', title: '物料名称', width: 180, sort: true }
			@@ -494,12 +494,12 @@
			sqlWhere += " and 单据号 like ^^%" + $("#HBillNo").val() + "%^^";
			if ($("#HNumber").val() != "")
			sqlWhere += " and 物料代码 like ^^%" + $("#HNumber").val() + "%^^";
			//if ($("#HName").val() != "")
			// sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^";
			if ($("#HName").val() != "")
			sqlWhere += " and 物料名称 like ^^%" + $("#HName").val() + "%^^";
			//if ($("#HModel").val() != "")
			// sqlWhere += " and 规格型号 like ^^%" + $("#HModel").val() + "%^^";
			//if ($("#HClStatus").val() != "")
			// sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^";
			if ($("#HClStatus").val() != "")
			sqlWhere += " and 关闭状态 like ^^%" + $("#HClStatus").val() + "%^^";
			//if ($("#HPURCHASEORGID").val() != "")
			// sqlWhere += " and 采购组织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
			//if ($("#HDate1").val() != "") {
			@@ -508,43 +508,43 @@
			//if ($("#HDate2").val() != "") {
			// sqlWhere += " and 日期 <= ^^" + $("#HDate2").val() + "^^";
			//}
			//if ($("#HISGenerate").val() != "") {
			// if ($("#HISGenerate").val() == "是") {
			// sqlWhere += " and 未关联数量 <= 0";
			// }
			// else if ($("#HISGenerate").val() == "否") {
			// sqlWhere += " and 未关联数量 > 0";
			// }
			if ($("#HISGenerate").val() != "") {
			if ($("#HISGenerate").val() == "是") {
			sqlWhere += " and 未关联数量 <= 0";
			}
			else if ($("#HISGenerate").val() == "否") {
			sqlWhere += " and 未关联数量 > 0";
			}
			}
			//var Time = $("#Time").val();
			//var dd = new Date();
			//var dt;
			//switch (Time) {
			// case 1: dd = new Date(dd.setDate(dd.getDate() + 7));
			// case 2: dd = new Date(dd.setDate(dd.getDate() + 14));
			// case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1));
			// case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2));
			// case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3));
			// case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6));
			// case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12));
			// default: dd = new Date(dd.setDate(dd.getDate()));
			//}
			var Time = $("#Time").val();
			var dd = new Date();
			var dt;
			switch (Time) {
			case 1: dd = new Date(dd.setDate(dd.getDate() + 7));
			case 2: dd = new Date(dd.setDate(dd.getDate() + 14));
			case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1));
			case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2));
			case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3));
			case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6));
			case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12));
			default: dd = new Date(dd.setDate(dd.getDate()));
			}
			dt = dd.getFullYear().toString();
			if (dd.getMonth() + 1 < 10) {
			dt = dt + "-0" + (dd.getMonth() + 1).toString();
			}
			else {
			dt = dt + "-0" + (dd.getMonth() + 1).toString();
			}
			if (dd.getDate() < 10) {
			dt = dt + "-0" + dd.getDate().toString();
			}
			else {
			dt = dt + "-" + dd.getDate().toString();
			}
			if (Time != 8) {
			sqlWhere += " and 交货日期 <= ^^" + dt + "^^";
			}
			//dt = dd.getFullYear().toString();
			//if (dd.getMonth() + 1 < 10) {
			// dt = dt + "-0" + (dd.getMonth() + 1).toString();
			//}
			//else {
			// dt = dt + "-0" + (dd.getMonth() + 1).toString();
			//}
			//if (dd.getDate() < 10) {
			// dt = dt + "-0" + dd.getDate().toString();
			//}
			//else {
			// dt = dt + "-" + dd.getDate().toString();
			//}
			//if (Time != 8) {
			// sqlWhere += " and 交货日期 <= ^^" + dt + "^^";
			//}
			sql = sqlWhere;
			//从第一页开始
			_cur_page = 1;