From 24c4699005da96f45562d7057d80c103b8e428a2 Mon Sep 17 00:00:00 2001
From: WangHan <wwh_work@126,com>
Date: 星期五, 03 一月 2025 10:32:34 +0800
Subject: [PATCH] 子级分类在用删除
---
consum-base/src/main/java/com/consum/base/service/impl/BaseCategoryServiceImpl.java | 140 +++++++++++++++++++++++++++++++++-------------
1 files changed, 100 insertions(+), 40 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/BaseCategoryServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/BaseCategoryServiceImpl.java
index f2face6..1af508a 100644
--- a/consum-base/src/main/java/com/consum/base/service/impl/BaseCategoryServiceImpl.java
+++ b/consum-base/src/main/java/com/consum/base/service/impl/BaseCategoryServiceImpl.java
@@ -1,9 +1,6 @@
package com.consum.base.service.impl;
-import java.util.Comparator;
-import java.util.HashMap;
-import java.util.List;
-import java.util.stream.Collectors;
+import java.util.*;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;
@@ -75,12 +72,12 @@
HashMap<String, Object> paramts = new HashMap<>();
// 鍒嗙被鍚嶇О
- sql.append(" and category_name =:category_name ");
- paramts.put("category_name", categoryName);
+ sql.append("and category_name =:categoryName ");
+ paramts.put("categoryName", categoryName);
// 鐖剁被id
- sql.append(" and father_category_id =:father_category_id ");
- paramts.put("father_category_id", fatherCategoryId);
-
+ sql.append("and father_category_id =:fatherCategoryId ");
+ paramts.put("fatherCategoryId", fatherCategoryId);
+ sql.append("and states = 1 ");
return this.get(sql.toString(), paramts, new BaseCategory());
}
@@ -118,6 +115,48 @@
}
sql.append(" ORDER BY ORDER_NUMBER,CREATE_TIME DESC ");
return selectSplit(sql.toString(), paramts, new BaseCategory());
+ }
+
+ /**
+ * 鐗╁搧鍒嗙被鍒楄〃鏌ヨ绮剧‘鏌ヨ
+ * @param param
+ * @return
+ */
+ public GenericPager<BaseCategory> queryBaseCategoryList2(BaseCategoryParam param) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_category WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+ // 鍒嗙被鍚嶇О
+ if (param.getFatherCategoryId() != null) {
+ sql.append("and father_category_id =:fatherCategoryId ");
+ paramts.put("fatherCategoryId", param.getFatherCategoryId());
+ } else {
+ sql.append("and levels =1 ");
+ }
+ // 鍒嗙被鍚嶇О
+ if (!StringUtils.isEmpty(param.getCategoryName())) {
+ sql.append(" and category_name =:category_name ");
+ paramts.put("category_name", param.getCategoryName());
+ }
+ // 绫诲埆
+ if (!StringUtils.isEmpty(param.getClassification())) {
+ sql.append(" and classification =:classification ");
+ paramts.put("classification", param.getClassification());
+ }
+ // 鐘舵��
+ if (param.getStates() != null) {
+ sql.append(" and states =:states ");
+ paramts.put("states", param.getStates());
+ } else {
+ sql.append(" and states !=3 ");
+ }
+ sql.append(" ORDER BY ORDER_NUMBER,CREATE_TIME DESC ");
+ return selectSplit(sql.toString(), paramts, new BaseCategory());
+ }
+
+ @Override
+ public List<BaseCategory> selectByFatherId(Long fatherId) {
+ StringBuilder sql = new StringBuilder("SELECT * FROM base_category WHERE FATHER_CATEGORY_ID = " + fatherId + " and STATES != 3");
+ return select(sql.toString(), new HashMap<>(), new BaseCategory());
}
/**
@@ -178,41 +217,41 @@
BaseCategory categoryParam = new BaseCategory();
categoryParam.setStates(1);
// 鏌ュ嚭鎵�鏈夊垎绫�
- List<BaseCategory> all = select(categoryParam);
- // 缁勮鎴愮埗瀛愭爲褰㈢粨鏋�
- // 1绾у垎绫�
- List<ProjectTreeResult> menus = all.stream().filter(entity -> entity.getLevels() == 1).map(entity -> {
- ProjectTreeResult projectTreeResult = new ProjectTreeResult(entity);
- if (getChildren(projectTreeResult, all).isEmpty()) {
- projectTreeResult.setChildren(null);
- } else {
- projectTreeResult.setChildren(getChildren(projectTreeResult, all));
- }
- return projectTreeResult;
- }).sorted(Comparator.comparingInt(menu -> (menu.getSort() == null ? 0 : menu.getSort())))
- .collect(Collectors.toList());
- return menus;
+ List<BaseCategory> all = this.select(categoryParam);
+ // 缁勮鎴愮埗瀛愭爲褰㈢粨鏋�
+ List<ProjectTreeResult> rootNodes = new ArrayList<>();
+ for (BaseCategory category : all) {
+ ProjectTreeResult node = new ProjectTreeResult(category);
+ Long parentId = category.getFatherCategoryId();
+ if (parentId == 0) {
+ // 娌℃湁鐖惰妭鐐癸紝灏嗗叾浣滀负鏍硅妭鐐�
+ rootNodes.add(node);
+ } else {
+ // 鏈夌埗鑺傜偣锛屽皢鍏舵坊鍔犲埌鐖惰妭鐐圭殑瀛愯妭鐐瑰垪琛ㄤ腑
+ addToParent(parentId, node, rootNodes);
+ }
+ }
+ return rootNodes;
}
- /**
- * 閫掑綊鏌ユ壘鎵�鏈夎彍鍗曠殑瀛愯彍鍗�
- */
- private List<ProjectTreeResult> getChildren(ProjectTreeResult root, List<BaseCategory> all) {
- List<ProjectTreeResult> children =
- all.stream().filter(entity -> entity.getFatherCategoryId().equals(root.getId())).map(entity -> {
-
- ProjectTreeResult projectTreeResult = new ProjectTreeResult(entity);
- // 閫氳繃閫掑綊鎵惧埌瀛愬垎绫�
- if (getChildren(projectTreeResult, all).isEmpty()) {
- projectTreeResult.setChildren(null);
- } else {
- projectTreeResult.setChildren(getChildren(projectTreeResult, all));
+ private void addToParent(Long parentId, ProjectTreeResult node, List<ProjectTreeResult> nodes) {
+ for (ProjectTreeResult parent : nodes) {
+ if (parent.getId().equals(parentId)) {
+ // 鎵惧埌浜嗙埗鑺傜偣锛屽皢鍏舵坊鍔犲埌瀛愯妭鐐瑰垪琛ㄤ腑
+ if (parent.getChildren() == null) {
+ parent.setChildren(new ArrayList<>());
}
- return projectTreeResult;
- }).sorted(Comparator.comparingInt(menu -> (menu.getSort() == null ? 0 : menu.getSort())))
- .collect(Collectors.toList());
- return children;
+ parent.getChildren().add(node);
+ break;
+ } else {
+ // 缁х画鏌ユ壘鐖惰妭鐐圭殑瀛愯妭鐐�
+ List<ProjectTreeResult> children = parent.getChildren();
+ if (children != null) {
+ addToParent(parentId, node, children);
+ }
+ }
+ }
}
/**
@@ -237,4 +276,25 @@
BaseCategory baseCategory = this.get(sql.toString(), paramts, new BaseCategory());
return baseCategory;
}
+
+ /**
+ * 鏌ヨ鍒嗙被鍚岀骇鍒殑鏈�澶ф帓搴忓彿
+ * @param id 鍒嗙被
+ * @return
+ */
+ @Override
+ public int selIndexByPid(Long id) {
+ StringBuilder sql = new StringBuilder("SELECT max(ORDER_NUMBER) maxNum FROM base_category WHERE 1 = 1 ");
+ HashMap<String, Object> paramts = new HashMap<>();
+ // 鍒嗙被鍚嶇О
+ sql.append(" and FATHER_CATEGORY_ID =:FATHER_CATEGORY_ID ");
+ paramts.put("FATHER_CATEGORY_ID", id);
+ Map getMap = this.get(sql.toString(), paramts);
+ Object obj = getMap.get("maxNum");
+ if(obj!=null){
+ return new Integer(obj.toString());
+ }
+ return 0;
+ }
+
}
--
Gitblit v1.9.1