From b0841619e23dd01b8fba9561ad9036c7c3d6aa08 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期二, 14 十一月 2023 14:05:20 +0800 Subject: [PATCH] 出库单管理 --- consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java | 52 +++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 45 insertions(+), 7 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/BaseGoodsModelsServiceImpl.java index d0513ee..88d68c3 100644 --- a/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java @@ -1,17 +1,15 @@ package com.consum.base.service; import com.consum.base.Constants; -import com.consum.base.util.IdUtil; -import com.consum.model.po.BaseCategory; +import com.consum.base.core.utils.IdUtil; import com.consum.model.po.BaseGoodsModels; -import com.consum.model.po.BaseGoodsTemplate; import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.DateUtils; -import com.walker.infrastructure.utils.StringUtils; import com.walker.jdbc.service.BaseServiceImpl; -import org.springframework.stereotype.Service; - import java.util.HashMap; +import java.util.List; +import org.springframework.stereotype.Service; +import org.springframework.util.CollectionUtils; /** * @Description 鐗╁搧妯℃澘 @@ -39,7 +37,7 @@ } /** - * @Description 鏍规嵁 鍨嬪彿鍚嶇О鍜岀墿鍝佹ā鏉縤d 鏌ヨ瑙勬牸鍨嬪彿 + * @Description 鏍规嵁 鍨嬪彿鍚嶇О鍜岀墿鍝佹ā鏉縤d 鏌ヨ瑙勬牸鍨嬪彿 * @Author 鍗㈠簡闃� * @Date 2023/10/25 */ @@ -70,6 +68,7 @@ /** * 淇敼鐘舵�� + * * @author 鍗㈠簡闃� * @date 2023/10/25 */ @@ -86,4 +85,43 @@ models.setStates(Constants.STATES_DELETED); return this.update(models); } + + /** + * @param idList + * @Description 鏍规嵁瑙勬牸鍨嬪彿id鏌ヨ瑙勬牸鍨嬪彿 + * @Author 鍗㈠簡闃� + * @Date 2023/11/2 + */ + public List<BaseGoodsModels> selectByModelsIdList(List<Long> idList) { + if (CollectionUtils.isEmpty(idList)) { + log.error("鍙傛暟閿欒"); + return null; + } + StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 "); + HashMap<String, Object> paramts = new HashMap<>(); + + sql.append(" and id in ( "); + for (int i = 0; i < idList.size(); i++) { + sql.append(idList.get(i)); + if (i < idList.size() - 1) { + sql.append(","); + } + } + sql.append(" ) "); + + return this.select(sql.toString(), paramts, new BaseGoodsModels()); + } + + /** + * @Description 鏍规嵁鐗╁搧id鏌ヨ瑙勬牸鍨嬪彿 + * @Author 鍗㈠簡闃� + * @Date 2023/10/30 + */ + public List<BaseGoodsModels> queryByGoodsTemplatesId(Long goodsTemplatesId) { + BaseGoodsModels baseGoodsModels = new BaseGoodsModels(); + baseGoodsModels.setGoodsTemplatesId(goodsTemplatesId); + return this.select(baseGoodsModels); + } + + } -- Gitblit v1.9.1