From 8e41786892a4bd7cff2d63bde8cb0636cdb0650c Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期六, 02 十二月 2023 20:54:51 +0800 Subject: [PATCH] 分转元 --- consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java | 25 +++++++++++++++++-------- 1 files changed, 17 insertions(+), 8 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java similarity index 94% rename from consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java rename to consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java index c2edf64..d01ab23 100644 --- a/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/impl/BaseGoodsModelsServiceImpl.java @@ -1,18 +1,18 @@ -package com.consum.base.service; +package com.consum.base.service.impl; import com.consum.base.Constants; import com.consum.base.core.utils.IdUtil; import com.consum.base.core.utils.MapperUtil; +import com.consum.base.service.BaseGoodsModelsService; import com.consum.model.po.BaseGoodsModels; import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.DateUtils; import com.walker.jdbc.service.BaseServiceImpl; -import org.springframework.stereotype.Service; -import org.springframework.util.CollectionUtils; - import java.util.HashMap; import java.util.List; import java.util.Map; +import org.springframework.stereotype.Service; +import org.springframework.util.CollectionUtils; /** * @Description 鐗╁搧妯℃澘 @@ -20,13 +20,14 @@ * @Date 2023/10/23 */ @Service -public class BaseGoodsModelsServiceImpl extends BaseServiceImpl { +public class BaseGoodsModelsServiceImpl extends BaseServiceImpl implements BaseGoodsModelsService { /** * @Description 瑙勬牸鍒楄〃鏌ヨ锛堟牴鎹墿鍝乮d鏌ヨ瑙勬牸鍨嬪彿锛� * @Author 鍗㈠簡闃� * @Date 2023/10/25 */ + @Override public GenericPager<BaseGoodsModels> queryList(Long goodsTemplatesId) { StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 "); HashMap<String, Object> paramts = new HashMap<>(); @@ -44,6 +45,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/25 */ + @Override public BaseGoodsModels getByModelNameAndGoodsTemplatesId(BaseGoodsModels models) { StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 "); HashMap<String, Object> paramts = new HashMap<>(); @@ -54,7 +56,7 @@ //鐗╁搧妯℃澘id sql.append(" and GOODS_TEMPLATES_ID =:GOODS_TEMPLATES_ID "); paramts.put("GOODS_TEMPLATES_ID", models.getGoodsTemplatesId()); - if (models.getStates() != null){ + if (models.getStates() != null) { sql.append(" and STATES =:states "); paramts.put("states", models.getStates()); } @@ -67,6 +69,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/23 */ + @Override public int add(BaseGoodsModels models) { models.setId(IdUtil.generateId()); models.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis())); @@ -79,6 +82,7 @@ * @author 鍗㈠簡闃� * @date 2023/10/25 */ + @Override public int updateStatus(BaseGoodsModels models) { return this.update(models); } @@ -88,6 +92,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/25 */ + @Override public int updateById(BaseGoodsModels models) { models.setStates(Constants.STATES_DELETED); return this.update(models); @@ -99,6 +104,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/11/2 */ + @Override public List<BaseGoodsModels> selectByModelsIdList(List<Long> idList) { if (CollectionUtils.isEmpty(idList)) { log.error("鍙傛暟閿欒"); @@ -124,11 +130,15 @@ * @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"; /** * 鏍规嵁鐗╁搧鍨嬪彿id 鏌ヨ鐗╁搧淇℃伅 @@ -136,8 +146,7 @@ * @param baseGoodsModelsId * @return */ - 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"; - + @Override public List<Map<String, Object>> queryGoodsModelInfo(Long baseGoodsModelsId) { StringBuilder sql = new StringBuilder(QUERY_GOODS_MODEL_INFO); HashMap<String, Object> paramts = new HashMap<>(); -- Gitblit v1.9.1