From be63b5c4b3fd231a5d25ce5434cc24c9a8e285b7 Mon Sep 17 00:00:00 2001
From: luqingyang <lqy5492@163.com>
Date: 星期一, 23 十月 2023 16:28:53 +0800
Subject: [PATCH] fix:物品分类 代码完善
---
consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java | 37 +++++++++++++++++++++++++++++++++++++
1 files changed, 37 insertions(+), 0 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
new file mode 100644
index 0000000..8b383bc
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/BaseGoodsTemplateServiceImpl.java
@@ -0,0 +1,37 @@
+package com.consum.base.service;
+
+import com.consum.model.po.BaseCategory;
+import com.walker.jdbc.service.BaseServiceImpl;
+import org.springframework.stereotype.Service;
+
+import java.util.HashMap;
+import java.util.List;
+
+/**
+ * @Description 鐗╁搧妯℃澘
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/23
+ */
+@Service
+public class BaseGoodsTemplateServiceImpl extends BaseServiceImpl {
+
+ /**
+ * @Description 鏍规嵁鍒嗙被id鍜岀姸鎬佹煡璇㈢墿鍝佹ā鐗�
+ * @Author 鍗㈠簡闃�
+ * @Date 2023/10/23
+ * @return
+ */
+ public List<BaseCategory> getByCategoryId(Long categoryId) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_goods_template WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+
+ //鍒嗙被id
+ if (categoryId != null) {
+ sql.append(" and category_id =:category_id ");
+ paramts.put("category_id", categoryId);
+ }
+ sql.append(" and states =1 ");
+
+ return this.select(sql.toString(), paramts, new BaseCategory());
+ }
+}
--
Gitblit v1.9.1