From 4ee56e307915e4e71baab476be819e7642e78269 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期三, 08 十一月 2023 18:19:34 +0800 Subject: [PATCH] --部门物品分发与明细 --采购fix --- consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java | 50 ++++++++++++++++++++++++++++++++++++++++++++------ 1 files changed, 44 insertions(+), 6 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..cc0c2cf 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 @@ -2,16 +2,14 @@ import com.consum.base.Constants; import com.consum.base.util.IdUtil; -import com.consum.model.po.BaseCategory; 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