| | |
| | | |
| | | 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()); |
| | |
| | | IPage<Labels> result = labelsJoinMapper.selectJoinPage(page,Labels.class, queryWrapper); |
| | | /* String resourcePath=systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode();*/ |
| | | if(org.apache.commons.collections.CollectionUtils.isNotEmpty(result.getRecords())){ |
| | | String path = systemDictDataBiz.queryByCode(Constants.OSS,Constants.RESOURCE_PATH).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.OSS,Constants.LABELS_IMG).getCode(); |
| | | for(Labels model:result.getRecords()){ |
| | | if(model.getParentId()==null){ |
| | | model.setTypeLevel(0); |
| | | }else{ |
| | | model.setTypeLevel(1); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImgurl())){ |
| | | model.setImgFullurl(path + model.getImgurl()); |
| | | } |
| | | if(Constants.equalsInteger(model.getType(),Constants.LabelsType.BIG_AREA.getKey())){ |
| | | //如果是大区信息,查询所有绑定额省份信息 |
| | | model.setAreaList(areasMapper.selectList(new LambdaQueryWrapper<Areas>() |