From a7a6b5d7ed7b6e5b96866b24fd1cb7ba3dcc19d1 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期三, 22 十一月 2023 14:24:47 +0800 Subject: [PATCH] feat: 物品统计前后端 --- consum-base/src/main/java/com/consum/base/service/LWhWarningServiceImpl.java | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/LWhWarningServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhWarningServiceImpl.java index 667e46a..446e11e 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhWarningServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhWarningServiceImpl.java @@ -25,7 +25,7 @@ public GenericPager<Map<String, Object>> getListWithPage(WhWarningQry param) { StringBuilder sql = new StringBuilder(GET_LIST_WITH_PAGE); HashMap<String, Object> paramts = new HashMap<>(); - if (param.getStates() != null){ + if (param.getStates() != null) { sql.append(" AND wareWarn.states = :states"); paramts.put("states", param.getStates()); } @@ -49,6 +49,9 @@ sql.append(" AND goodsTemp.GOODS_NAME like :goodsTemplateName"); paramts.put("goodsTemplateName", StringUtils.CHAR_PERCENT + param.getGoodsTemplateName() + StringUtils.CHAR_PERCENT); } + if (param.getGoodsTemplateId() != null) { + sql.append(" AND goodsTemp.id=:goodsTemplateId"); + paramts.put("goodsTemplateId", param.getGoodsTemplateId()); } //鍒嗙被 if (param.getCategoryId() != null) { sql.append(" AND cate.id=:categoryId"); -- Gitblit v1.9.1