From 2e8fcbe103ae892d8eb9b77d8165220ac555985d Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期一, 05 七月 2021 11:03:53 +0800
Subject: [PATCH] 1.日入库明细查询增加生产单号的查询条件
---
src/main/resources/mapper/ViewWorkInMapper.xml | 3 +++
src/main/webapp/views/report/viewWorkIn.html | 5 +++++
2 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/mapper/ViewWorkInMapper.xml b/src/main/resources/mapper/ViewWorkInMapper.xml
index b8c0865..da01a65 100644
--- a/src/main/resources/mapper/ViewWorkInMapper.xml
+++ b/src/main/resources/mapper/ViewWorkInMapper.xml
@@ -26,6 +26,9 @@
or bname like '%' + #{maktx} + '%'
)
</if>
+ <if test="mnemonic!=null and mnemonic != ''">
+ and mnemonic like '%' + #{mnemonic} + '%'
+ </if>
<if test="begin_date!=null and begin_date!='' ">
<![CDATA[
and io_time >= #{begin_date}
diff --git a/src/main/webapp/views/report/viewWorkIn.html b/src/main/webapp/views/report/viewWorkIn.html
index 020c173..add81b7 100644
--- a/src/main/webapp/views/report/viewWorkIn.html
+++ b/src/main/webapp/views/report/viewWorkIn.html
@@ -29,6 +29,11 @@
<input class="layui-input" type="text" name="matnr" placeholder="鐗╂枡缂栫爜" autocomplete="off">
</div>
</div>
+ <div class="layui-inline">
+ <div class="layui-input-inline">
+ <input class="layui-input" type="text" name="mnemonic" placeholder="鐢熶骇鍗曞彿" autocomplete="off">
+ </div>
+ </div>
<div class="layui-inline" style="width: 300px">
<div class="layui-input-inline">
<input class="layui-input layui-laydate-range" name="query_date" type="text" placeholder="鍏ュ簱璧峰鏃堕棿 - 鍏ュ簱缁堟鏃堕棿" autocomplete="off" style="width: 300px">
--
Gitblit v1.9.1