From 38a872daa5c9f9571cc7672313a4ef165857cf60 Mon Sep 17 00:00:00 2001 From: whycq <10027870+whycq@user.noreply.gitee.com> Date: 星期一, 27 三月 2023 13:17:08 +0800 Subject: [PATCH] # --- 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 e63997b..015ed17 100644 --- a/src/main/resources/mapper/ViewWorkInMapper.xml +++ b/src/main/resources/mapper/ViewWorkInMapper.xml @@ -11,6 +11,9 @@ <if test="matnr!=null and matnr!='' "> and matnr like '%' + #{matnr} + '%' </if> + <if test="specs!=null and specs!='' "> + and specs like '%' + #{specs} + '%' + </if> <if test="maktx!=null and maktx!='' "> and (maktx like '%' + #{maktx} + '%' or matnr like '%' + #{maktx} + '%' diff --git a/src/main/webapp/views/report/viewWorkIn.html b/src/main/webapp/views/report/viewWorkIn.html index dca05aa..d7bebaa 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="specs" 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