package com.consum.base.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
|
import com.consum.base.Constants;
|
import com.consum.base.core.utils.IdUtil;
|
import com.consum.base.pojo.BaseCategoryParam;
|
import com.consum.base.pojo.ProjectTreeResult;
|
import com.consum.base.service.BaseCategoryService;
|
import com.consum.model.po.BaseCategory;
|
import com.iplatform.model.po.S_user_core;
|
import com.walker.db.page.GenericPager;
|
import com.walker.infrastructure.utils.DateUtils;
|
import com.walker.infrastructure.utils.StringUtils;
|
import com.walker.jdbc.service.BaseServiceImpl;
|
|
/**
|
* @Description 物品分类
|
* @Author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
@Service
|
public class BaseCategoryServiceImpl extends BaseServiceImpl implements BaseCategoryService {
|
|
private static final String QUERY_TREE_ALL =
|
"select * from base_category where states = 1 order by FATHER_CATEGORY_ID, LEVELS ASC";
|
|
/**
|
* @Description 新增分类
|
* @Author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
public int add(BaseCategoryParam param, S_user_core currentUser) {
|
BaseCategory baseCategory = new BaseCategory();
|
BeanUtils.copyProperties(param, baseCategory);
|
baseCategory.setId(IdUtil.generateId());
|
// 层级
|
if (baseCategory.getFatherCategoryId() == null) {
|
// 一级分类
|
baseCategory.setFatherCategoryId(0L);
|
baseCategory.setLevels(Constants.LEVELS_ONE);
|
} else {
|
// 根据父类id查询上级分类信息
|
BaseCategory category = this.get(new BaseCategory(baseCategory.getFatherCategoryId()));
|
if (category.getFatherCategoryId() == 0L) { // 二级分类
|
baseCategory.setLevels(Constants.LEVELS_TWO);
|
} else { // 三级分类
|
baseCategory.setLevels(Constants.LEVELS_THREE);
|
}
|
}
|
// 创建人id和创建人姓名
|
baseCategory.setCreateUserId(currentUser.getId());
|
baseCategory.setCreateUserName(currentUser.getUser_name());
|
// 创建时间
|
baseCategory.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
|
|
return this.insert(baseCategory);
|
}
|
|
/**
|
* @param categoryName
|
* @param fatherCategoryId
|
* @Description 根据分类名称和父类id查询分类
|
* @Author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
public BaseCategory getByCategoryNameAndFatherCategoryId(String categoryName, Long fatherCategoryId) {
|
StringBuilder sql = new StringBuilder("SELECT * FROM base_category WHERE 1 = 1 ");
|
HashMap<String, Object> paramts = new HashMap<>();
|
|
// 分类名称
|
sql.append("and category_name =:categoryName ");
|
paramts.put("categoryName", categoryName);
|
// 父类id
|
sql.append("and father_category_id =:fatherCategoryId ");
|
paramts.put("fatherCategoryId", fatherCategoryId);
|
sql.append("and states = 1 ");
|
return this.get(sql.toString(), paramts, new BaseCategory());
|
}
|
|
/**
|
* @Description 物品分类列表查询
|
* @Author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
public GenericPager<BaseCategory> queryBaseCategoryList(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 like:category_name ");
|
paramts.put("category_name", StringUtils.CHAR_PERCENT + param.getCategoryName() + StringUtils.CHAR_PERCENT);
|
}
|
// 类别
|
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());
|
}
|
|
/**
|
* 物品分类列表查询精确查询
|
* @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());
|
}
|
|
/**
|
* @Description 编辑
|
* @Author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
public int updateBaseCategory(BaseCategory baseCategory) {
|
return this.update(baseCategory);
|
}
|
|
/**
|
* 修改状态
|
*
|
* @author 卢庆阳
|
* @date 2023/9/27
|
*/
|
public int updateStatus(BaseCategory baseCategory) {
|
return this.update(baseCategory);
|
}
|
|
/**
|
* @Description 根据id删除物品分类
|
* @Author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
public int updateById(BaseCategory baseCategory, S_user_core currentUser) {
|
baseCategory.setStates(Constants.STATES_DELETED);
|
// 删除时间
|
baseCategory.setDTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
|
// 删除人id和删除人姓名
|
baseCategory.setDUserId(currentUser.getId());
|
baseCategory.setDUserName(currentUser.getUser_name());
|
return this.update(baseCategory);
|
}
|
|
/**
|
* 根据节点id查询节点详情
|
*
|
* @author 卢庆阳
|
* @Date 2023/10/23
|
*/
|
public BaseCategory getById(Long id) {
|
return this.get(new BaseCategory(id));
|
}
|
|
/**
|
* @Description
|
* @Author 卢庆阳
|
* @Date 2023/10/30
|
*/
|
public List<BaseCategory> queryForTree() {
|
// 展示全部节点
|
return this.select(QUERY_TREE_ALL, new Object[] {}, new BaseCategory());
|
}
|
|
public List<ProjectTreeResult> tree() {
|
BaseCategory categoryParam = new BaseCategory();
|
categoryParam.setStates(1);
|
// 查出所有分类
|
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 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<>());
|
}
|
parent.getChildren().add(node);
|
break;
|
} else {
|
// 继续查找父节点的子节点
|
List<ProjectTreeResult> children = parent.getChildren();
|
if (children != null) {
|
addToParent(parentId, node, children);
|
}
|
}
|
}
|
}
|
|
/**
|
* @return
|
* @Description 三级分类列表查询
|
* @Author 卢庆阳
|
* @Date 2023/10/30
|
*/
|
public List<BaseCategory> queryForLv3Tree() {
|
StringBuilder sql = new StringBuilder(
|
"SELECT * FROM base_category WHERE states = 1 and levels = 3 order by ORDER_NUMBER,CREATE_TIME desc");
|
return this.select(sql.toString(), new Object[] {}, new BaseCategory());
|
}
|
|
@Override
|
public BaseCategory getByCategoryByName(String categoryName) {
|
StringBuilder sql = new StringBuilder("SELECT * FROM base_category WHERE 1 = 1 ");
|
HashMap<String, Object> paramts = new HashMap<>();
|
// 分类名称
|
sql.append(" and category_name =:category_name ");
|
paramts.put("category_name", categoryName);
|
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;
|
}
|
|
}
|
