| | |
| | | @Override |
| | | public Goods findById(Integer id) { |
| | | Goods goods = goodsMapper.selectById(id); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.FILE_DIR).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.PROJECTS).getCode(); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); |
| | | goods.setPrefixUrl(prefixUrl); |
| | | Brand brand = brandMapper.selectById(goods.getBrandId()); |
| | | if(!Objects.isNull(brand)){ |
| | |
| | | Goods::getPrice,goods.getSPrice(),goods.getEPrice()); |
| | | queryWrapper.orderByDesc(Goods::getId); |
| | | List<Goods> goodsList = goodsJoinMapper.selectJoinList(Goods.class,queryWrapper); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.FILE_DIR).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.PROJECTS).getCode(); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); |
| | | goodsList.forEach(i->{ |
| | | i.setPrefixUrl(prefixUrl); |
| | | i.setMultifileList(multifileMapper.selectList(new QueryWrapper<Multifile>().eq("OBJ_ID",i.getId()).orderByAsc(" SORTNUM "))); |
| | |
| | | queryWrapper.selectAll(Goods.class); |
| | | |
| | | queryWrapper.selectAs(Category::getName, Goods::getCategoryName); |
| | | queryWrapper.selectAs(BaseGoods::getZdPrice, Goods::getBaseZdPrice); |
| | | queryWrapper.selectAs(BaseGoods::getPrice, Goods::getBasePrice); |
| | | queryWrapper.selectAs(Brand::getName, Goods::getBrandName); |
| | | queryWrapper.selectAs(Category::getAttrFirst, Goods::getAttrFirst); |
| | | queryWrapper.selectAs(Category::getAttrSecond, Goods::getAttrSecond); |
| | | queryWrapper.selectAs(BaseCategory::getPriceRate,Goods::getBasePriceRate); |
| | | queryWrapper.leftJoin(Category.class, Category::getId, Goods::getCategoryId); |
| | | queryWrapper.leftJoin(Brand.class, Brand::getId, Goods::getBrandId); |
| | | queryWrapper.leftJoin(BaseGoods.class,BaseGoods::getId,Goods::getGoodsId); |
| | | queryWrapper.leftJoin(BaseCategory.class,BaseCategory::getId,BaseGoods::getCategoryId); |
| | | |
| | | queryWrapper.eq(Goods::getIsdeleted, Constants.ZERO); |
| | | if (pageWrap.getModel().getId() != null) { |
| | |
| | | } |
| | | queryWrapper.orderByDesc(Goods::getId); |
| | | IPage<Goods> goodsIPage = goodsJoinMapper.selectJoinPage(page, Goods.class, queryWrapper); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.FILE_DIR).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.PROJECTS).getCode(); |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() |
| | | + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); |
| | | goodsIPage.getRecords().forEach(i->{ |
| | | i.setPrefixUrl(prefixUrl); |
| | | if(i.getType().equals(Constants.ONE)){ |
| | | i.setBasePrice(i.getBasePrice().multiply(i.getBasePriceRate())); |
| | | } |
| | | |
| | | }); |
| | | return PageData.from(goodsIPage); |
| | | } |