From 4983186bfdb078aa22ff1ba656f022eef43eec7b Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期三, 25 十月 2023 15:31:18 +0800
Subject: [PATCH] feat: 采购入库
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
index f268ab2..6221a8c 100644
--- a/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
@@ -227,15 +227,19 @@
* @param modelId
* @return
*/
- private static String QUERY_GOODSINFO_BY_MODELID = "SELECT model.MODEL_NAME,model.UNIT,temp.GOODS_CODE,temp.GOODS_NAME,temp.CLASSIFICATION FROM BASE_GOODS_MODELS model LEFT JOIN BASE_GOODS_TEMPLATE temp ON model.GOODS_TEMPLATES_ID=temp.id WHERE 1=1 ";
+ private static String QUERY_GOODSINFO_BY_MODELID = "SELECT model.MODEL_NAME modelName,model.UNIT,temp.id goodsId, temp.GOODS_CODE goodsCode,temp.GOODS_NAME goodsName,temp.CLASSIFICATION classification FROM BASE_GOODS_MODELS model LEFT JOIN BASE_GOODS_TEMPLATE temp ON model.GOODS_TEMPLATES_ID=temp.id WHERE 1=1 ";
- public List<Map<String, Object>> queryGoodsInfoByModelId(Long modelId) {
+ public Map<String, Object> queryGoodsInfoByModelId(Long modelId) {
StringBuilder sqlStr = new StringBuilder(QUERY_GOODSINFO_BY_MODELID);
Map<String, Object> params = new HashMap<>();
if (modelId != null) {
sqlStr.append(" AND model.id=:modelId");
params.put("modelId", modelId);
}
- return this.select(sqlStr.toString(), params);
+ List<Map<String, Object>> tempGoodsInfo = this.select(sqlStr.toString(), params);
+ if (CollectionUtils.isEmpty(tempGoodsInfo)) {
+ return null;
+ }
+ return tempGoodsInfo.get(0);
}
}
--
Gitblit v1.9.1