| | |
| | | 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; |
| | |
| | | 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())) { |
| | |
| | | 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; |
| | | } |
| | | |
| | | } |