From d2048c247c446be08598abf8e1bc11a4ea77be32 Mon Sep 17 00:00:00 2001
From: luqingyang <lqy5492@163.com>
Date: 星期三, 25 十月 2023 16:41:49 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java | 32 +++++++++++++++++++++++++++-----
1 files changed, 27 insertions(+), 5 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 e1e7a75..6e44892 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
@@ -20,6 +20,7 @@
import java.util.HashMap;
import java.util.List;
+import java.util.Map;
/**
* @Description 鐗╁搧妯℃澘
@@ -109,7 +110,7 @@
}
/**
- * @Description 鐗╁搧妯℃澘鍒楄〃鏌ヨ
+ * @Description 鐗╁搧妯℃澘鍒楄〃鏌ヨ
* @Author 鍗㈠簡闃�
* @Date 2023/10/24
*/
@@ -146,8 +147,6 @@
if (param.getStates() != null) {
sql.append(" and states =:states ");
paramts.put("states", param.getStates());
- } else {
- sql.append(" and states !=3 ");
}
sql.append(" ORDER BY CREATE_DATE DESC ");
@@ -156,6 +155,7 @@
/**
* 鏍规嵁鐗╁搧id鏌ヨ鐗╁搧璇︽儏
+ *
* @author 鍗㈠簡闃�
* @date 2023/9/26
*/
@@ -173,7 +173,7 @@
//3.灏佽
BaseGoodsTemplateVo vo = new BaseGoodsTemplateVo();
if (goodsTemplate != null) {
- BeanUtils.copyProperties(goodsTemplate,vo);
+ BeanUtils.copyProperties(goodsTemplate, vo);
}
if (!CollectionUtils.isEmpty(modelsList)) {
vo.setModels(modelsList);
@@ -203,7 +203,7 @@
}
/**
- * @Description 鏍规嵁鐗╁搧鍚嶇О鍜屽垎绫籭d鏌ヨ鐗╁搧
+ * @Description 鏍规嵁鐗╁搧鍚嶇О鍜屽垎绫籭d鏌ヨ鐗╁搧
* @Author 鍗㈠簡闃�
* @Date 2023/10/24
*/
@@ -222,6 +222,28 @@
}
/**
+ * 鏍规嵁鍨嬪彿ID鏌ヨ鐗╁搧淇℃伅
+ *
+ * @param modelId
+ * @return
+ */
+ 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 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);
+ }
+ List<Map<String, Object>> tempGoodsInfo = this.select(sqlStr.toString(), params);
+ if (CollectionUtils.isEmpty(tempGoodsInfo)) {
+ return null;
+ }
+ return tempGoodsInfo.get(0);
+ }
+
+ /**
* 淇敼鐘舵��
* @author 鍗㈠簡闃�
* @date 2023/10/25
--
Gitblit v1.9.1