From 8f4f83af6ce2a1468042bf60678cc49daf1beb3b Mon Sep 17 00:00:00 2001
From: liuguocan <527956374@qq.com>
Date: 星期二, 28 十一月 2023 16:48:39 +0800
Subject: [PATCH] 台账查询/物品查询
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsModelsServiceImpl.java | 37 +++++++++++++++++++++++++++++--------
1 files changed, 29 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/BaseGoodsModelsServiceImpl.java
index 4558e52..285bcaf 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,19 +1,18 @@
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.base.core.utils.MapperUtil;
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 org.springframework.util.CollectionUtils;
import java.util.HashMap;
import java.util.List;
+import java.util.Map;
/**
* @Description 鐗╁搧妯℃澘
@@ -41,7 +40,7 @@
}
/**
- * @Description 鏍规嵁 鍨嬪彿鍚嶇О鍜岀墿鍝佹ā鏉縤d 鏌ヨ瑙勬牸鍨嬪彿
+ * @Description 鏍规嵁 鍨嬪彿鍚嶇О鍜岀墿鍝佹ā鏉縤d 鏌ヨ瑙勬牸鍨嬪彿
* @Author 鍗㈠簡闃�
* @Date 2023/10/25
*/
@@ -55,6 +54,10 @@
//鐗╁搧妯℃澘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());
}
@@ -72,6 +75,7 @@
/**
* 淇敼鐘舵��
+ *
* @author 鍗㈠簡闃�
* @date 2023/10/25
*/
@@ -90,10 +94,10 @@
}
/**
- * @Description 鏍规嵁瑙勬牸鍨嬪彿id鏌ヨ瑙勬牸鍨嬪彿
+ * @param idList
+ * @Description 鏍规嵁瑙勬牸鍨嬪彿id鏌ヨ瑙勬牸鍨嬪彿
* @Author 鍗㈠簡闃�
* @Date 2023/11/2
- * @param idList
*/
public List<BaseGoodsModels> selectByModelsIdList(List<Long> idList) {
if (CollectionUtils.isEmpty(idList)) {
@@ -116,7 +120,7 @@
}
/**
- * @Description 鏍规嵁鐗╁搧id鏌ヨ瑙勬牸鍨嬪彿
+ * @Description 鏍规嵁鐗╁搧id鏌ヨ瑙勬牸鍨嬪彿
* @Author 鍗㈠簡闃�
* @Date 2023/10/30
*/
@@ -125,4 +129,21 @@
baseGoodsModels.setGoodsTemplatesId(goodsTemplatesId);
return this.select(baseGoodsModels);
}
+
+ /**
+ * 鏍规嵁鐗╁搧鍨嬪彿id 鏌ヨ鐗╁搧淇℃伅
+ *
+ * @param baseGoodsModelsId
+ * @return
+ */
+ private String QUERY_GOODS_MODEL_INFO = "SELECT 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