From c1ac6d13630b04b4e11d6f383858e4f8fa64f924 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期六, 02 十二月 2023 17:24:34 +0800
Subject: [PATCH] 盘点查询返回结果修改
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java | 135 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 135 insertions(+), 0 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 4212f0d..c2edf64 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,7 +1,18 @@
package com.consum.base.service;
+import com.consum.base.Constants;
+import com.consum.base.core.utils.IdUtil;
+import com.consum.base.core.utils.MapperUtil;
+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;
/**
* @Description 鐗╁搧妯℃澘
@@ -11,4 +22,128 @@
@Service
public class BaseGoodsModelsServiceImpl extends BaseServiceImpl {
+ /**
+ * @Description 瑙勬牸鍒楄〃鏌ヨ锛堟牴鎹墿鍝乮d鏌ヨ瑙勬牸鍨嬪彿锛�
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/25
+ */
+ public GenericPager<BaseGoodsModels> queryList(Long goodsTemplatesId) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_models WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+
+ //鐗╁搧妯℃澘id
+ sql.append(" and goods_templates_id =:goods_templates_id ");
+ paramts.put("goods_templates_id", goodsTemplatesId);
+
+ sql.append(" and states !=3 ORDER BY CREATE_TIME DESC ");
+ return selectSplit(sql.toString(), paramts, new BaseGoodsModels());
+ }
+
+ /**
+ * @Description 鏍规嵁 鍨嬪彿鍚嶇О鍜岀墿鍝佹ā鏉縤d 鏌ヨ瑙勬牸鍨嬪彿
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/25
+ */
+ public BaseGoodsModels getByModelNameAndGoodsTemplatesId(BaseGoodsModels models) {
+ 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
+ sql.append(" and GOODS_TEMPLATES_ID =:GOODS_TEMPLATES_ID ");
+ paramts.put("GOODS_TEMPLATES_ID", models.getGoodsTemplatesId());
+ if (models.getStates() != null){
+ sql.append(" and STATES =:states ");
+ paramts.put("states", models.getStates());
+ }
+
+ return this.get(sql.toString(), paramts, new BaseGoodsModels());
+ }
+
+ /**
+ * @Description 鏂板
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/23
+ */
+ public int add(BaseGoodsModels models) {
+ models.setId(IdUtil.generateId());
+ models.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
+ return this.insert(models);
+ }
+
+ /**
+ * 淇敼鐘舵��
+ *
+ * @author 鍗㈠簡闃�
+ * @date 2023/10/25
+ */
+ public int updateStatus(BaseGoodsModels models) {
+ return this.update(models);
+ }
+
+ /**
+ * @Description 鏍规嵁id鍒犻櫎瑙勬牸鍨嬪彿
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/25
+ */
+ public int updateById(BaseGoodsModels models) {
+ 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);
+ }
+
+ /**
+ * 鏍规嵁鐗╁搧鍨嬪彿id 鏌ヨ鐗╁搧淇℃伅
+ *
+ * @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";
+
+ public List<Map<String, Object>> queryGoodsModelInfo(Long baseGoodsModelsId) {
+ StringBuilder sql = new StringBuilder(QUERY_GOODS_MODEL_INFO);
+ HashMap<String, Object> paramts = new HashMap<>();
+ sql.append(" where model.id=:baseGoodsModelsId");
+ paramts.put("baseGoodsModelsId", baseGoodsModelsId);
+ return select(sql.toString(), paramts, new MapperUtil());
+ }
+
}
--
Gitblit v1.9.1