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_EntrustOrderBillList.html | 85 ++++++++++++++++++++++--------------------
1 files changed, 45 insertions(+), 40 deletions(-)
diff --git a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_EntrustOrderBillList.html b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_EntrustOrderBillList.html
index 98f95b9..04ee82c 100644
--- a/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_EntrustOrderBillList.html
+++ b/WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_EntrustOrderBillList.html
@@ -8,6 +8,11 @@
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
<link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
<link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
+ <style type="text/css">
+ .layui-input-block {
+ width: 200px;
+ }
+ </style>
</head>
<body>
@@ -45,31 +50,31 @@
<input type="text" class="layui-input" name="HBillNo" id="HBillNo">
</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="HShortNumber" id="HShortNumber">
</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="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 class="layui-inline">
+ </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>
+ <div class="layui-inline">
<label class="layui-form-label">鍏抽棴鐘舵��</label>
<div class="layui-input-block">
<select id="HClStatus" name="HClStatus" lay-filter="">
@@ -78,19 +83,19 @@
<option value="宸插叧闂�">宸插叧闂�</option>
</select>
</div>
- </div>-->
- <!--<div class="layui-inline">
+ </div>
+ <div class="layui-inline">
<label class="layui-form-label">寮�濮嬫棩鏈�</label>
<div class="layui-input-block">
<input type="text" class="layui-input" name="HDate1" id="HDate1">
</div>
- </div>-->
- <!--<div class="layui-inline">
+ </div>
+ <div class="layui-inline">
<label class="layui-form-label">缁撴潫鏃ユ湡</label>
<div class="layui-input-block">
<input type="text" class="layui-input" name="HDate2" id="HDate2">
</div>
- </div>-->
+ </div>
<div class="layui-inline">
<label class="layui-form-label">浜よ揣鏃堕棿</label>
<div class="layui-input-block">
@@ -107,7 +112,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="HSUBORGID" name="HSUBORGID" lay-filter="">
@@ -115,8 +120,8 @@
<option value="">缁勭粐2</option>
</select>
</div>
- </div>-->
- <!--<div class="layui-inline">
+ </div>
+ <div class="layui-inline">
<label class="layui-form-label">鏄惁宸蹭笅鎺ㄩ�佽揣鍗�</label>
<div class="layui-input-block">
<select id="HISGenerate" name="HISGenerate" lay-filter="">
@@ -125,7 +130,7 @@
<option value="鍚�">鍚�</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>
@@ -548,32 +553,32 @@
sqlWhere += " and 鐘舵�� like ^^%" + $("#HStatus").val() + "%^^";
if ($("#HBillNo").val() != "")
sqlWhere += " and 鍗曟嵁鍙� like ^^%" + $("#HBillNo").val() + "%^^";
- //if ($("#HShortNumber").val() != "")
- // sqlWhere += " and 鐗╂枡缂栫爜 like ^^%" + $("#HShortNumber").val() + "%^^";
+ if ($("#HShortNumber").val() != "")
+ sqlWhere += " and 鐗╂枡缂栫爜 like ^^%" + $("#HShortNumber").val() + "%^^";
if ($("#HNumber").val() != "")
sqlWhere += " and 鐗╂枡浠ｇ爜 like ^^%" + $("#HNumber").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 ($("#HSUBORGID").val() != "")
- // sqlWhere += " and 濮斿缁勭粐 like ^^%" + $("#HSUBORGID").val() + "%^^";
- //if ($("#HDate1").val() != "") {
- // sqlWhere += " and 鏃ユ湡 >= ^^" + $("#HDate1").val() + "^^";
- //}
- //if ($("#HDate2").val() != "") {
- // sqlWhere += " and 鏃ユ湡 <= ^^" + $("#HDate2").val() + "^^";
- //}
- //if ($("#HISGenerate").val() != "") {
- // if ($("#HISGenerate").val() == "鏄�") {
- // sqlWhere += " and 鏈叧鑱旀暟閲� <= 0";
- // }
- // else if ($("#HISGenerate").val() == "鍚�") {
- // sqlWhere += " and 鏈叧鑱旀暟閲� > 0";
- // }
- //}
+ 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 ($("#HSUBORGID").val() != "")
+ sqlWhere += " and 濮斿缁勭粐 like ^^%" + $("#HSUBORGID").val() + "%^^";
+ if ($("#HDate1").val() != "") {
+ sqlWhere += " and 鏃ユ湡 >= ^^" + $("#HDate1").val() + "^^";
+ }
+ if ($("#HDate2").val() != "") {
+ sqlWhere += " and 鏃ユ湡 <= ^^" + $("#HDate2").val() + "^^";
+ }
+ if ($("#HISGenerate").val() != "") {
+ if ($("#HISGenerate").val() == "鏄�") {
+ sqlWhere += " and 鏈叧鑱旀暟閲� <= 0";
+ }
+ else if ($("#HISGenerate").val() == "鍚�") {
+ sqlWhere += " and 鏈叧鑱旀暟閲� > 0";
+ }
+ }
var Time = $("#Time").val();
if (Time > 0) {
var dd = new Date();
--
Gitblit v1.9.1