From 494fbb222f0ec270f764f84f13987984fad09b82 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期三, 13 十二月 2023 11:22:08 +0800
Subject: [PATCH] 规格型号管理
---
consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java | 34 ++++++++++++----------------------
1 files changed, 12 insertions(+), 22 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java
index d01ab23..8b34c8a 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java
@@ -1,5 +1,12 @@
package com.consum.base.service.impl;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+import org.springframework.stereotype.Service;
+import org.springframework.util.CollectionUtils;
+
import com.consum.base.Constants;
import com.consum.base.core.utils.IdUtil;
import com.consum.base.core.utils.MapperUtil;
@@ -8,11 +15,6 @@
import com.walker.db.page.GenericPager;
import com.walker.infrastructure.utils.DateUtils;
import com.walker.jdbc.service.BaseServiceImpl;
-import java.util.HashMap;
-import java.util.List;
-import java.util.Map;
-import org.springframework.stereotype.Service;
-import org.springframework.util.CollectionUtils;
/**
* @Description 鐗╁搧妯℃澘
@@ -32,7 +34,7 @@
StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 ");
HashMap<String, Object> paramts = new HashMap<>();
- //鐗╁搧妯℃澘id
+ // 鐗╁搧妯℃澘id
sql.append(" and goods_templates_id =:goods_templates_id ");
paramts.put("goods_templates_id", goodsTemplatesId);
@@ -50,10 +52,10 @@
StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 ");
HashMap<String, Object> paramts = new HashMap<>();
- //瑙勬牸鍨嬪彿鍚嶇О
+ // 瑙勬牸鍨嬪彿鍚嶇О
sql.append(" and MODEL_NAME =:MODEL_NAME ");
paramts.put("MODEL_NAME", models.getModelName());
- //鐗╁搧妯℃澘id
+ // 鐗╁搧妯℃澘id
sql.append(" and GOODS_TEMPLATES_ID =:GOODS_TEMPLATES_ID ");
paramts.put("GOODS_TEMPLATES_ID", models.getGoodsTemplatesId());
if (models.getStates() != null) {
@@ -125,20 +127,8 @@
return this.select(sql.toString(), paramts, new BaseGoodsModels());
}
- /**
- * @Description 鏍规嵁鐗╁搧id鏌ヨ瑙勬牸鍨嬪彿
- * @Author 鍗㈠簡闃�
- * @Date 2023/10/30
- */
- @Override
- public List<BaseGoodsModels> queryByGoodsTemplatesId(Long goodsTemplatesId) {
- BaseGoodsModels baseGoodsModels = new BaseGoodsModels();
- baseGoodsModels.setGoodsTemplatesId(goodsTemplatesId);
- return this.select(baseGoodsModels);
- }
-
-
- private String QUERY_GOODS_MODEL_INFO = "SELECT CLASSIFICATION type, goodsTemp.CATEGORY_ID,goodsTemp.CATEGORY_NAME,goodsTemp.id goods_Id,goodsTemp.GOODS_NAME,model.MODEL_NAME,model.id base_Goods_Models_Id,model.UNIT FROM BASE_GOODS_MODELS model LEFT JOIN BASE_GOODS_TEMPLATE goodsTemp ON model.GOODS_TEMPLATES_ID=goodsTemp.id";
+ private String QUERY_GOODS_MODEL_INFO =
+ "SELECT CLASSIFICATION type, goodsTemp.CATEGORY_ID,goodsTemp.CATEGORY_NAME,goodsTemp.id goods_Id,goodsTemp.GOODS_NAME,model.MODEL_NAME,model.id base_Goods_Models_Id,model.UNIT FROM BASE_GOODS_MODELS model LEFT JOIN BASE_GOODS_TEMPLATE goodsTemp ON model.GOODS_TEMPLATES_ID=goodsTemp.id";
/**
* 鏍规嵁鐗╁搧鍨嬪彿id 鏌ヨ鐗╁搧淇℃伅
--
Gitblit v1.9.1