| | |
| | | @Override |
| | | public List<Goods> findList(Goods goods) { |
| | | QueryWrapper<Goods> wrapper = new QueryWrapper<>(goods); |
| | | wrapper.lambda() |
| | | .in(goods.getIdList() != null && goods.getIdList().size()>0, Goods::getId, goods.getIdList()) |
| | | .eq( Goods::getIsdeleted, Constants.ZERO); |
| | | return goodsMapper.selectList(wrapper); |
| | | } |
| | | |
| | |
| | | IPage<Goods> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<Goods> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | |
| | | queryWrapper.selectAll(Goods.class); |
| | | |
| | | queryWrapper.select("t1.name",Goods::getCategoryName); |
| | | queryWrapper.select("t2.name" ,Goods::getBrandName); |
| | | queryWrapper.select("t3.name" ,Goods::getParentName); |
| | |
| | | queryWrapper.eq(pageWrap.getModel().getParentCategoryId() != null, Goods::getParentCategoryId, pageWrap.getModel().getParentCategoryId()); |
| | | queryWrapper.eq(pageWrap.getModel().getBrandId() != null, Goods::getBrandId, pageWrap.getModel().getBrandId()); |
| | | queryWrapper.eq(pageWrap.getModel().getStatus() != null, Goods::getStatus, pageWrap.getModel().getStatus()); |
| | | |
| | | queryWrapper.orderByDesc(Goods::getCreateDate); |
| | | queryWrapper.in(pageWrap.getModel().getIdList() != null && pageWrap.getModel().getIdList().size()>0, Goods::getId, pageWrap.getModel().getIdList()); |
| | | queryWrapper.orderByDesc(Goods::getId); |
| | | IPage<Goods> result = goodsAdminJoinMapper.selectJoinPage(page, Goods.class, queryWrapper); |
| | | initResult(result.getRecords()); |
| | | return PageData.from(result); |