From 65d05e5e4332a23af2f0eaf7019b38f085b1688b Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 11 九月 2024 10:29:59 +0800
Subject: [PATCH] 销售订单条码出入库详情报表：第一个任意字段过滤报错
---
WebTM/views/应收管理/报表分析/Xs_SeOrderBarCodeInAndOutStockDetailReport.html | 35 +++++++++++++++++++++++++----------
1 files changed, 25 insertions(+), 10 deletions(-)
diff --git "a/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_SeOrderBarCodeInAndOutStockDetailReport.html" "b/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_SeOrderBarCodeInAndOutStockDetailReport.html"
index 9f32624..a190d44 100644
--- "a/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_SeOrderBarCodeInAndOutStockDetailReport.html"
+++ "b/WebTM/views/\345\272\224\346\224\266\347\256\241\347\220\206/\346\212\245\350\241\250\345\210\206\346\236\220/Xs_SeOrderBarCodeInAndOutStockDetailReport.html"
@@ -35,9 +35,19 @@
</div>
<div class="layui-inline">
<label class="layui-form-label" style="width: 85px;">閿�鍞鍗曞彿</label>
- <div class="layui-input-block" style="margin-left: 120px;">
+ <div class="layui-input-block" style="margin-left: 120px;width:130px;">
<input type="text" class="layui-input ForFilteringSchemes" name="HSeOrderBillNo" id="HSeOrderBillNo">
</div>
+ </div>
+ <div class="layui-inline">
+ <label class="layui-form-label" style="width: 85px;">鏄惁鍑哄簱</label>
+ </div>
+ <div class="layui-inline">
+ <select name="HIsOutStock" id="HIsOutStock" class="ForFilteringSchemes" lay-filter="HIsOutStock">
+ <option value="" selected="selected" style="width:10px;"></option>
+ <option value="鏄�" style="width:10px;">鏄�</option>
+ <option value="鍚�" style="width:10px;">鍚�</option>
+ </select>
</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>
@@ -45,25 +55,25 @@
<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">閲嶇疆</button>
<div class="layui-inline">
<label class="layui-form-label">鍏ュ簱浠舵暟</label>
- <div class="layui-input-block" style="margin-left: 120px;">
+ <div class="layui-input-block" style="margin-left: 120px;width:60px;">
<input type="text" class="layui-input" name="SumHPieceQty_inStock" id="SumHPieceQty_inStock" disabled="disabled">
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">鍏ュ簱绫虫暟鍚堣</label>
- <div class="layui-input-block" style="margin-left: 120px;">
+ <label class="layui-form-label">鍏ュ簱绫虫暟</label>
+ <div class="layui-input-block" style="margin-left: 120px; width: 100px;">
<input type="text" class="layui-input" name="SumHQty_inStock" id="SumHQty_inStock" disabled="disabled">
</div>
</div>
<div class="layui-inline">
<label class="layui-form-label">鍑哄簱浠舵暟</label>
- <div class="layui-input-block" style="margin-left: 120px;">
+ <div class="layui-input-block" style="margin-left: 120px; width: 60px;">
<input type="text" class="layui-input" name="SumHPieceQty_outStock" id="SumHPieceQty_outStock" disabled="disabled">
</div>
</div>
<div class="layui-inline">
- <label class="layui-form-label">鍑哄簱绫虫暟鍚堣</label>
- <div class="layui-input-block" style="margin-left: 120px;">
+ <label class="layui-form-label">鍑哄簱绫虫暟</label>
+ <div class="layui-input-block" style="margin-left: 120px; width: 100px;">
<input type="text" class="layui-input" name="SumHQty_outStock" id="SumHQty_outStock" disabled="disabled">
</div>
</div>
@@ -372,7 +382,7 @@
switch (data[i].Type) {
//int
case 'DateTime':
- col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
+ 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>" });
break;
default:
col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
@@ -420,9 +430,14 @@
//蹇�熻繃婊�
function get_FastQuery() {
var HSeOrderBillNo = $("#HSeOrderBillNo").val(); //閿�鍞鍗曞崟鎹彿
+ var HIsOutStock = $("#HIsOutStock").val(); //鏄惁鍑哄簱
if (HSeOrderBillNo != "") {
- sWhere += " and 閿�鍞鍗曞彿='" + HSeOrderBillNo + "' ";
+ sWhere += " and 閿�鍞鍗曞彿 like '%" + HSeOrderBillNo + "%' ";
+ }
+
+ if (HIsOutStock != "") {
+ sWhere += " and 鏄惁鍑哄簱 like '%" + HIsOutStock + "%' ";
}
//浠绘剰瀛楁鏉′欢杩囨护 鏉′欢鎻愬彇
@@ -455,7 +470,7 @@
com = "not like '%" + ColContent + "%' ";
break;
default:
- com = "" + Comparator + " ''" + ColContent + "'' ";
+ com = "" + Comparator + " '" + ColContent + "' ";
break;
}
sWhere += " and " + ColName + " " + com;
--
Gitblit v1.9.1