| | |
| | | return pageData; |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public PageData<BaseGoods> findCompanyPage(PageWrap<BaseGoods> pageWrap ,Integer companyId) { |
| | | |
| | | //查询企业已经存在的商品 |
| | | List<Integer> collect = new ArrayList<>(); |
| | | if(Objects.nonNull(companyId)){ |
| | | QueryWrapper<Goods> goodsQuery = new QueryWrapper<>(); |
| | | goodsQuery.lambda().eq(Goods::getIsdeleted,Constants.ZERO) |
| | | .eq(Goods::getCompanyId,companyId) |
| | | .isNotNull(Goods::getGoodsId); |
| | | List<Goods> goods = goodsMapper.selectList(goodsQuery); |
| | | if (CollectionUtils.isEmpty(goods)){ |
| | | collect = goods.stream().map(s -> s.getGoodsId()).collect(Collectors.toList()); |
| | | } |
| | | } |
| | | |
| | | pageWrap.getModel().setIsdeleted(Constants.ZERO); |
| | | IPage<BaseGoods> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<BaseGoods> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | queryWrapper.leftJoin(Brand.class,Brand::getId,BaseGoods::getBrandId) |
| | | .leftJoin(BaseCategory.class,BaseCategory::getId,BaseGoods::getCategoryId) |
| | | .selectAll(BaseGoods.class) |
| | | .selectAs(Brand::getName,BaseGoods::getBrandName) |
| | | .selectAs(BaseCategory::getName,BaseGoods::getCategoryName) |
| | | .eq(BaseGoods::getStatus, Constants.ZERO) |
| | | .eq(BaseGoods::getIsdeleted, Constants.ZERO) |
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getName()), BaseGoods::getName,pageWrap.getModel().getName()) |
| | | .like(pageWrap.getModel().getId()!=null,BaseGoods::getId, pageWrap.getModel().getId()) |
| | | .eq(pageWrap.getModel().getCategoryId()!=null,BaseGoods::getCategoryId, pageWrap.getModel().getCategoryId()) |
| | | .eq(pageWrap.getModel().getBrandId()!=null,BaseGoods::getBrandId, pageWrap.getModel().getBrandId()) |
| | | .eq(pageWrap.getModel().getStatus()!=null,BaseGoods::getStatus, pageWrap.getModel().getStatus()) |
| | | .notIn(!CollectionUtils.isEmpty(collect),BaseGoods::getId, collect); |
| | | |
| | | queryWrapper.orderByDesc(Goods::getId); |
| | | PageData<BaseGoods> pageData =PageData.from(baseGoodsJoinMapper.selectJoinPage(page,BaseGoods.class,queryWrapper)); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); |
| | | pageData.getRecords().forEach(i->{ |
| | | i.setFullImgUrl(prefixUrl + i.getImgurl()); |
| | | }); |
| | | return pageData; |
| | | } |
| | | |
| | | @Override |
| | | public long count(BaseGoods baseGoods) { |
| | | QueryWrapper<BaseGoods> wrapper = new QueryWrapper<>(baseGoods); |