| | |
| | | |
| | | @Override |
| | | public List<Labels> findList(Labels labels) { |
| | | |
| | | |
| | | MPJLambdaWrapper<Labels> query = new MPJLambdaWrapper<>(); |
| | | |
| | | if(labels!=null&&labels.getParentId()!=null){ |
| | | query.eq(Labels::getParentId,labels.getParentId()); |
| | | }else{ |
| | |
| | | } |
| | | query.eq(Labels::getIsdeleted,Constants.ZERO); |
| | | query.eq(labels.getType()!=null,Labels::getType,labels.getType()); |
| | | query.orderByAsc(Labels::getSortnum); |
| | | List<Labels> list= labelsJoinMapper.selectList(query); |
| | | List<Labels> childList= null; |
| | | if(Constants.equalsInteger(labels.getType(),Constants.LabelsType.APPLICABLE_BRAND.getKey())){ |
| | | childList= labelsJoinMapper.selectList(new QueryWrapper<Labels>().lambda() |
| | | .eq(Labels::getIsdeleted,Constants.ZERO) |
| | | .eq(Labels::getType,Constants.LabelsType.SERIES_BRAND.getKey()) |
| | | .orderByAsc(Labels::getSortnum)); |
| | | } |
| | | for(Labels model:list){ |
| | | if(Constants.equalsInteger(model.getType(),Constants.LabelsType.BIG_AREA.getKey())){ |
| | | //如果是大区信息,查询所有绑定额省份信息 |
| | |
| | | .eq(Areas::getIsdeleted,Constants.ZERO) |
| | | .eq(Areas::getBigAreaId,model.getId()))); |
| | | } |
| | | if(Constants.equalsInteger(labels.getType(),Constants.LabelsType.APPLICABLE_BRAND.getKey()) |
| | | &&Constants.equalsInteger(model.getType(),Constants.LabelsType.APPLICABLE_BRAND.getKey())){ |
| | | //如果是适应品牌,则查询下级系列 |
| | | model.setChildList(getChildListbyParentId(childList,model.getId())); |
| | | } |
| | | } |
| | | return list; |
| | | } |
| | | |
| | | private List<Labels> getChildListbyParentId(List<Labels> childList, Integer id) { |
| | | List<Labels> list = new ArrayList<>(); |
| | | if(childList!=null && childList.size()>0){ |
| | | for(Labels labels : childList){ |
| | | if(Constants.equalsInteger(labels.getParentId(),id)){ |
| | | list.add(labels); |
| | | } |
| | | } |
| | | |
| | | } |
| | | return list; |
| | | } |
| | |
| | | |
| | | queryWrapper.selectAll(Labels.class); |
| | | queryWrapper.select("(select name from labels where id=t.PARENT_ID) as parentName"); |
| | | if(Constants.equalsInteger(pageWrap.getModel().getType(),Constants.LabelsType.HOMEZHUANQU.getKey())){ |
| | | queryWrapper.select("(select count(g.id) from goods g where g.isdeleted=0 and g.ZHUANQU_IDS like concat('%[',t.id,']%') ) as goodsNum"); |
| | | } |
| | | if(Constants.equalsInteger(pageWrap.getModel().getType(),Constants.LabelsType.APPLICABLE_BRAND.getKey())){ |
| | | queryWrapper.select("(select count(g.id) from goods g where g.isdeleted=0 and g.BRAND_IDS like concat('%[',t.id,']%') ) as goodsNum"); |
| | | } |
| | | if(Constants.equalsInteger(pageWrap.getModel().getType(),Constants.LabelsType.SERIES_BRAND.getKey())){ |
| | | queryWrapper.select("(select count(g.id) from goods g where g.isdeleted=0 and g.SERIAL_IDS like concat('%[',t.id,']%') ) as goodsNum"); |
| | | } |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Labels::getName,pageWrap.getModel().getName()); |
| | | queryWrapper.eq(pageWrap.getModel().getParentId()!=null,Labels::getParentId,pageWrap.getModel().getParentId()); |
| | | queryWrapper.eq(pageWrap.getModel().getType()!=null,Labels::getType,pageWrap.getModel().getType()); |