一、完成接口
1.获取分类关联的品牌:/product/categorybrandrelation/brands/list
2.获取分类下所有分组&关联属性:/product/attrgroup/{catelogId}/withattr
3.保存新增商品:/product/spuinfo/save
4.spu检索:/product/spuinfo/list
5.sku检索:/product/skuinfo/list
二、获取分类关联的品牌
1、controller类
/**
* 1.Controller:处理请求,接受和校验数据
* 2.Service接受controller传来的数据,进行业务处理
* 3.Controller接受Service处理完的数据,封装页面的指定的vo
*
*
*
*/
@GetMapping("/brands/list")
public R relationBrandsList(@RequestParam(value = "catId",required = true) Long catId){
List<BrandEntity> vos = categoryBrandRelationService.getBrandsByCatId(catId);
List<BrandVo> collect = vos.stream().map(item -> {
BrandVo brandVo = new BrandVo();
brandVo.setBrandId(item.getBrandId());
brandVo.setBrandName(item.getName());
return brandVo;
}).collect(Collectors.toList());
return R.ok().put("data", collect);
}
2、service类
List<BrandEntity> getBrandsByCatId(Long catId);
3、Impl类
@Override
public List<BrandEntity> getBrandsByCatId(Long catId) {
List<CategoryBrandRelationEntity> catelogId = relationDao.selectList(new QueryWrapper<CategoryBrandRelationEntity>().eq("catelog_id", catId));
List<BrandEntity> collect = catelogId.stream().map(item -> {
Long brandId = item.getBrandId();
BrandEntity byId = brandService.getById(brandId);
return byId;
}).collect(Collectors.toList());
return collect;
}
4、测试
三、获取分类下所有分组&关联属性
1、controller类
@GetMapping("/{catelogId}/withattr")
public R getAttrGroupWithAttrs(@PathVariable("catelogId") Long catelogId){
//1. 查出当前分类下的所有属性分组
//2. 查出每个属性分组的所有属性
List<AttrGroupWithAttrsVo> vos = attrGroupService.getAttrGroupWithAttrsByCatelogId(catelogId);
return R.ok().put("data",vos);
}
2、service类
List<AttrGroupWithAttrsVo> getAttrGroupWithAttrsByCatelogId(Long catelogId);
3、Impl类
// 根据分类id查出所有分组以及这些组里面的属性
@Override
public List<AttrGroupWithAttrsVo> getAttrGroupWithAttrsByCatelogId(Long catelogId) {
List<AttrGroupEntity> attrGroupEntities = this.list(new QueryWrapper<AttrGroupEntity>().eq("catelog_Id", catelogId));
//查询所有苏醒
List<AttrGroupWithAttrsVo> collect = attrGroupEntities.stream().map(group->{
AttrGroupWithAttrsVo attrsVo = new AttrGroupWithAttrsVo();
BeanUtils.copyProperties(group, attrsVo);
List<AttrEntity> attrs = attrService.getRelationAttr(attrsVo.getAttrGroupId());
attrsVo.setAttrs(attrs);
return attrsVo;
}).collect(Collectors.toList());
return collect;
}
4、测试
四、保存功能
新增商品:/product/spuinfo/save
这里的保存功能设计很多张表,保存的数据很多很多,很复杂
1、product-vo下各vo类
从资料代码中导入各vo类
2、common-vo下各vo类
3、开启coupon远程调用(openfeign)
因为这里设计到另一张表数据的保存sms表会员信息的保存,所以需要开启远程功能
1 启动类
启动类,加注解开启远程调用,并指定文件
2 product-feign下CouponFeignService
创建远程调用coupon的接口
创建两个之后要用的方法:保存数据
package com.atguigu.gulimall.product.feign;
import com.atguigu.common.to.SkuReductionTo;
import com.atguigu.common.to.SpuBoundTo;
import com.atguigu.common.utils.R;
import org.springframework.cloud.openfeign.FeignClient;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
@FeignClient("gulimall-coupon")
public interface CouponFeignService {
/**
* 1.couponFeignService.saveSpuBounds
* 1.@RequesBody将这个对象转为json
* 2.找到gulimall-coupon中的服务,给/coupon/spubouds/save发送请求
* 将上一步转为json放在请求体位置,发送请求
* 3.对方服务收到请求,请求体里有json数据
*
* @param spuBoundTo
* @return
*/
@PostMapping("/coupon/spubounds/save")
R saveSpuBounds(@RequestBody SpuBoundTo spuBoundTo);
@PostMapping("/coupon/skufullreduction/saveinfo")
R saveSkuReduction(@RequestBody SkuReductionTo skuReductionTo);
}
4、product-SpuInfoContoller
修改save方法
/**
* 保存
*/
@RequestMapping("/save")
//@RequiresPermissions("product:spuinfo:save")
public R save(@RequestBody SpuSaveVo vo){
spuInfoService.saveSpuInfo(vo);
return R.ok();
}
5、product-SkuInfoService
创建servcie方法
void saveSkuInfo(SkuInfoEntity skuInfoEntity);
6、product-SkuInfoImpl
@Service("spuInfoService")
public class SpuInfoServiceImpl extends ServiceImpl<SpuInfoDao, SpuInfoEntity> implements SpuInfoService {
@Autowired
SpuInfoDescService spuInfoDescService;
@Autowired
SpuImagesService imagesService;
@Autowired
AttrService attrService;
@Autowired
ProductAttrValueService attrValueService;
@Autowired
SkuInfoService skuInfoService;
@Autowired
SkuImagesService skuImagesService;
@Autowired
SkuSaleAttrValueService skuSaleAttrValueService;
@Autowired
CouponFeignService couponFeignService;
@Override
public PageUtils queryPage(Map<String, Object> params) {
IPage<SpuInfoEntity> page = this.page(
new Query<SpuInfoEntity>().getPage(params),
new QueryWrapper<SpuInfoEntity>()
);
return new PageUtils(page);
}
@Transactional
@Override
public void saveSpuInfo(SpuSaveVo vo) {
//1.spu的基本信息 pms_spu_info
SpuInfoEntity infoEntity = new SpuInfoEntity();
BeanUtils.copyProperties(vo,infoEntity);
infoEntity.setCreateTime(new Date());
infoEntity.setUpdateTime(new Date());
this.saveBaseSpuInfo(infoEntity);
//2.spu的描述图片 pms_spu_info_desc
List<String> decript = vo.getDecript();
SpuInfoDescEntity descEntity = new SpuInfoDescEntity();
descEntity.setSpuId(infoEntity.getId());
descEntity.setDecript(String.join(",",decript));
spuInfoDescService.saveSpuInfoDesc(descEntity);
//3.spu的图片集 pms_spu_images
List<String> images = vo.getImages();
imagesService.saveImages(infoEntity.getId(),images);
//4.spu的规格参数 pms_product_attr_value
List<BaseAttrs> baseAttrs = vo.getBaseAttrs();
List<ProductAttrValueEntity> collect = baseAttrs.stream().map(attr -> {
ProductAttrValueEntity valueEntity = new ProductAttrValueEntity();
valueEntity.setAttrId(attr.getAttrId());
AttrEntity id = attrService.getById(attr.getAttrId());
valueEntity.setAttrName(id.getAttrName());
valueEntity.setAttrValue(attr.getAttrValues());
valueEntity.setQuickShow(attr.getShowDesc());
valueEntity.setSpuId(infoEntity.getId());
return valueEntity;
}).collect(Collectors.toList());
attrValueService.saveProductAttr(collect);
//5.spu的积分信息:gulimall_sms ->sms_spu_bouds
Bounds bounds = vo.getBounds();
SpuBoundTo spuBoundTo = new SpuBoundTo();
BeanUtils.copyProperties(bounds,spuBoundTo);
spuBoundTo.setSpuId(infoEntity.getId());
R r = couponFeignService.saveSpuBounds(spuBoundTo);
if(r.getCode() != 0){
log.error("远程保存spu积分信息失败");
}
//6.当前spu对应的sku信息;
List<Skus> skus = vo.getSkus();
if(skus != null && skus.size()>0){
skus.forEach(item ->{
String defaultImg = "";
for (Images image : item.getImages()){
if(image.getDefaultImg() == 1){
defaultImg = image.getImgUrl();
}
}
SkuInfoEntity skuInfoEntity = new SkuInfoEntity();
BeanUtils.copyProperties(item,skuInfoEntity);
skuInfoEntity.setBrandId(infoEntity.getBrandId());
skuInfoEntity.setCatalogId(infoEntity.getCatalogId());
skuInfoEntity.setSaleCount(0L);
skuInfoEntity.setSpuId(infoEntity.getId());
skuInfoEntity.setSkuDefaultImg(defaultImg);
//6.1 sku的基本图片:pms_sku_info
skuInfoService.saveSkuInfo(skuInfoEntity);
Long skuId = skuInfoEntity.getSkuId();
//6.2 sku的图片信息:pms_sku_images
List<SkuImagesEntity> imagesEntities = item.getImages().stream().map(img -> {
SkuImagesEntity skuImagesEntity = new SkuImagesEntity();
skuImagesEntity.setSkuId(skuId);
skuImagesEntity.setImgUrl(img.getImgUrl());
skuImagesEntity.setDefaultImg(img.getDefaultImg());
return skuImagesEntity;
}).filter(entity -> {
//返回true就是需要 false就是剔除
return StringUtils.hasLength(entity.getImgUrl());
}).collect(Collectors.toList());
skuImagesService.saveBatch(imagesEntities);
//6.3 sku的销售属性信息:pms_sku_sale_attr_value
List<Attr> attr = item.getAttr();
List<SkuSaleAttrValueEntity> skuSaleAttrValueEntities = attr.stream().map(a->{
SkuSaleAttrValueEntity attrValueEntity = new SkuSaleAttrValueEntity();
BeanUtils.copyProperties(a, attrValueEntity);
attrValueEntity.setSkuId(skuId);
return attrValueEntity;
}).collect(Collectors.toList());
skuSaleAttrValueService.saveBatch(skuSaleAttrValueEntities);
//6.4 sku的优惠,满减信息:gulimall_sms -> sms_sku_ladder\sms_sku_full_reduction
SkuReductionTo skuReductionTo = new SkuReductionTo();
BeanUtils.copyProperties(item,skuReductionTo);
skuReductionTo.setSkuId(skuId);
if(skuReductionTo.getFullCount() >0 || skuReductionTo.getFullPrice().compareTo(new BigDecimal("0")) == 1){
R r1 = couponFeignService.saveSkuReduction(skuReductionTo);
if(r1.getCode() != 0){
log.error("远程保存sku积分信息失败");
}
}
});
}
}
@Override
public void saveBaseSpuInfo(SpuInfoEntity infoEntity) {
this.baseMapper.insert(infoEntity);
}
}
7、coupon-SpuBoundsController
修改远程调用的coupon下的save方法
/**
* 保存
*/
@RequestMapping("/save")
//@RequiresPermissions("coupon:spubounds:save")
public R save(@RequestBody SpuBoundsEntity spuBounds){
spuBoundsService.save(spuBounds);
return R.ok();
}
8、coupon-SkuFullReductionController
新增远程调用的saveinfo方法
@PostMapping("/saveinfo")
public R saveInfo(@RequestBody SkuReductionTo reductionTo){
skuFullReductionService.saveSkuReduction(reductionTo);
return R.ok();
}
9、coupon-SkuFullReductionImpl
@Service("skuFullReductionService")
public class SkuFullReductionServiceImpl extends ServiceImpl<SkuFullReductionDao, SkuFullReductionEntity> implements SkuFullReductionService {
@Autowired
SkuLadderService skuLadderService;
@Autowired
MemberPriceService memberPriceService;
@Override
public PageUtils queryPage(Map<String, Object> params) {
IPage<SkuFullReductionEntity> page = this.page(
new Query<SkuFullReductionEntity>().getPage(params),
new QueryWrapper<SkuFullReductionEntity>()
);
return new PageUtils(page);
}
@Override
public void saveSkuReduction(SkuReductionTo reductionTo) {
//1.保存满减打折 会员价
//6.4 sku的优惠,满减信息:gulimall_sms -> sms_sku_ladder\
SkuLadderEntity skuLadderEntity = new SkuLadderEntity();
skuLadderEntity.setSkuId(reductionTo.getSkuId());
skuLadderEntity.setFullCount(reductionTo.getFullCount());
skuLadderEntity.setDiscount(reductionTo.getDiscount());
skuLadderEntity.setAddOther(reductionTo.getCountStatus());
if(reductionTo.getFullCount() > 0){
skuLadderService.save(skuLadderEntity);
}
//sms_sku_full_reduction
SkuFullReductionEntity reductionEntity = new SkuFullReductionEntity();
BeanUtils.copyProperties(reductionTo,reductionEntity);
if(reductionEntity.getFullPrice().compareTo(new BigDecimal("0")) == 1){
this.save(reductionEntity);
}
//sms_member_price
List<MemberPrice> memberPrice = reductionTo.getMemberPrices();
if(reductionTo.getMemberPrices() != null){
List<MemberPriceEntity> collect = memberPrice.stream().map(item -> {
MemberPriceEntity priceEntity = new MemberPriceEntity();
priceEntity.setSkuId(reductionTo.getSkuId());
priceEntity.setMemberLevelId(item.getId());
priceEntity.setMemberLevelName(item.getName());
priceEntity.setMemberPrice(item.getPrice());
priceEntity.setAddOther(1);
return priceEntity;
}).filter(item -> {
return item.getMemberPrice().compareTo(new BigDecimal("0")) == 1;
}).collect(Collectors.toList());
memberPriceService.saveBatch(collect);
}
}
}
10、测试
测试太难搞了,要输入一堆数据,一点保存还要返回重新输入!!!忘记截图了呜呜呜呜呜
主要会出现的问题都在下面!
五、spu sku检索
两个功能就是修改相应的查询list功能,需要都一样,放在一起一起做了,修改各自的list功能
/product/skuinfo/list
/product/spuinfo/list
1、controller类
spu:spuInfoController
/**
* 列表
*/
@RequestMapping("/list")
//@RequiresPermissions("product:spuinfo:list")
public R list(@RequestParam Map<String, Object> params){
PageUtils page = spuInfoService.queryPageByCondition(params);
return R.ok().put("page", page);
}
sku:skuInfoController
@RequestMapping("/list")
//@RequiresPermissions("product:skuinfo:list")
public R list(@RequestParam Map<String, Object> params){
PageUtils page = skuInfoService.queryPageByCondition(params);
return R.ok().put("page", page);
}
2、service类
spu:SpuInfoService
PageUtils queryPageByCondition(Map<String, Object> params);
sku:SkuInfoService
PageUtils queryPageByCondition(Map<String, Object> params);
3、Impl类
spu:SpuInfoServiceImpl
@Override
public PageUtils queryPageByCondition(Map<String, Object> params) {
QueryWrapper<SpuInfoEntity> wrapper = new QueryWrapper<>();
String key = (String) params.get("key");
if(StringUtils.hasLength(key)){
wrapper.and((w) -> {
// 拼接内嵌条件 意思就是这里的返回加了()
w.eq("id",key).or().like("spu_name",key);
});
}
// status = 1 and (id = 1 or spu_name like xxx)
String status = (String) params.get("status");
if(StringUtils.hasLength(status)){
wrapper.eq("publish_status",status);
}
String brandId = (String) params.get("brandId");
if(StringUtils.hasLength(brandId)&& !"0".equalsIgnoreCase(brandId)){
wrapper.eq("brand_id", brandId);
}
String catelogId = (String) params.get("catelogId");
if(StringUtils.hasLength(catelogId)&& !"0".equalsIgnoreCase(catelogId)){
wrapper.eq("catalog_id",catelogId);
}
IPage<SpuInfoEntity> page = this.page(
new Query<SpuInfoEntity>().getPage(params),
wrapper
);
return new PageUtils(page);
}
sku:SkuInfoServiceImpl
@Override
public PageUtils queryPageByCondition(Map<String, Object> params) {
QueryWrapper<SkuInfoEntity> queryWrapper = new QueryWrapper<>();
String key = (String) params.get("key");
if(!StringUtils.isEmpty(key)){
queryWrapper.and((wrapper) ->{
wrapper.eq("sku_id",key).or().like("sku_name", key);
});
}
String catelogId = (String) params.get("catelogId");
if(!StringUtils.isEmpty(catelogId)&& !"0".equalsIgnoreCase(catelogId)){
queryWrapper.eq("catalog_id", catelogId);
}
String brandId = (String) params.get("brandId");
if(!StringUtils.isEmpty(brandId) && !"0".equalsIgnoreCase(brandId)){
queryWrapper.eq("brand_id", brandId);
}
String max = (String) params.get("max");
if(!StringUtils.isEmpty(max)){
try {
BigDecimal bigDecimal = new BigDecimal(max);
if(bigDecimal.compareTo(new BigDecimal("0"))==1){
queryWrapper.le("price",max);
}
}catch (Exception e){
}
}
String min = (String) params.get("min");
if(!StringUtils.isEmpty(min)){
queryWrapper.ge("price",min);
}
IPage<SkuInfoEntity> page = this.page(
new Query<SkuInfoEntity>().getPage(params),
queryWrapper
);
return new PageUtils(page);
}
4、测试
六、主要问题
1、循环依赖
怎么说了,视频老师是这样写的,但这肯定是不对,我这里也就是关闭了循环检查来解决问题,
如果有能力的同学可以自己写写研究,怎么不循环
2、前端publish未定义错误
引入下载pubsub.js中的PubSub,然后删除common两个页面的this
npm install --save pubsub-js
3、数据库更新后新加字段
这张参数表,新增加了value——type字段
在对应的实体类下Entity加字段
和mapper文件中加字段索引就解决了
vo类也要加上
4、最后保存时,coupon报空指针 和 远程调用500错误
自己先检查一下远程调用接口是不是写了@RequestBody;写了那就是数据有问题了
通过前后断点测试,就可以看到这里的问题了,这个BeanUtils.copyProperties高版本的spring boot无法复制拷贝数组
所以导致了这里的memberPrice为空
解决方法就是降低到和老师一样的2.1几版本,但这里也可以自己在拷贝完后,自己写赋值代码!