From fa81723ece156a1bf7df0652d65c61bc255c6dc0 Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期五, 25 二月 2022 13:57:23 +0800
Subject: [PATCH] 采购订单、送货单页面查询条件及影藏列调整
---
WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_PODemandPlanBillList.html | 98 ++++++++++++++++++++++++------------------------
1 files changed, 49 insertions(+), 49 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_PODemandPlanBillList.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_PODemandPlanBillList.html
index 76d28d7..ec19c1b 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_PODemandPlanBillList.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_PODemandPlanBillList.html
@@ -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;
--
Gitblit v1.9.1