一文搞懂大厂商品中心设计！

IdWorker idWorker=new IdWorker(1,1);
for(int i=0;i<10000;i++){
    long id = idWorker.nextId();
    System.out.println(id);
}

<!‐‐雪花ID生成器‐‐>
<bean id="idWorker" class="com.qingcheng.util.IdWorker">
    <constructor‐arg index="0" value="1"></constructor‐arg>
    <constructor‐arg index="1" value="1"></constructor‐arg>
</bean>

{
    "spu": {
        "name": "这个是商品名称",
        "caption": "这个是副标题",
        "brandId": 12,
        "category1Id": 558,
        "category2Id": 559,
        "category3Id": 560,
        "freightId": 10,
        "image": "http://www.qingcheng.com/image/1.jpg",
        "images": "http://www.qingcheng.com/image/1.jpg,http://www.qingcheng.com/image/2.jpg",
        "introduction": "这个是商品详情，html代码",
        "paraItems": {
            "出厂年份": "2019",
            "赠品": "充电器"
        },
        "saleService": "七天包退,闪电退货",
        "sn": "020102331",
        "specItems": {
            "颜色": [
                "红",
                "绿"
            ],
            "机身内存": [
                "64G",
                "8G"
            ]
        },
        "templateId": 42
    },
    "skuList": [
        {
            "sn": "10192010292",
            "num": 100,
            "alertNum": 20,
            "price": 900000,
            "spec": {
                "颜色": "红",
                "机身内存": "64G"
            },
            "image": "http://www.qingcheng.com/image/1.jpg",
            "images": "http://www.qingcheng.com/image/1.jpg,http://www.qingcheng.com/image/2.jpg",
            "status": "1",
            "weight": 130
        },
        {
            "sn": "10192010293",
            "num": 100,
            "alertNum": 20,
            "price": 600000,
            "spec": {
                "颜色": "绿",
                "机身内存": "8G"
            },
            "image": "http://www.qingcheng.com/image/1.jpg",
            "images": "http://www.qingcheng.com/image/1.jpg,http://www.qingcheng.com/image/2.jpg",
            "status": "1",
            "weight": 130
        }
    ]
}

/**
* 商品组合实体类 
*/
public class Goods implements Serializable {

    private Spu spu;

    private List<Sku> skuList;
}

@Autowired
private SkuMapper skuMapper;
@Autowired  
private IdWorker idWorker;
@Autowired
private CategoryMapper categoryMapper;

/**
* 保存商品
* @param goods 商品组合实体类
*/
@Transactional
public void saveGoods(Goods goods) {
    // 保存一个spu的信息
    Spu spu = goods.getSpu();
    spu.setId(idWorker.nextId()+"");
    spuMapper.insert(spu);
    
    //保存sku列表的信息
    Date date=new Date();
    //分类对象
    Category category = categoryMapper.selectByPrimaryKey(spu.getCategory3Id());
    List<Sku> skuList = goods.getSkuList();
    for (Sku sku:skuList){
        sku.setId(idWorker.nextId()+"");
        sku.setSpuId(spu.getId());

        //sku名称 =spu名称+规格值列表
        String name=spu.getName();
        //sku.getSpec() {"颜色":"红","机身内存":"64G"}
        Map<String,String> specMap = JSON.parseObject(sku.getSpec(), Map.class);
        for(String value:specMap.values()){
            name+=" "+value;
        }
        sku.setName(name);//名称
        sku.setCreateTime(date);//创建日期
        sku.setUpdateTime(date);//修改日期
        sku.setCategoryId(spu.getCategory3Id());//分类id
        sku.setCategoryName(category.getName());//分类名称
        sku.setCommentNum(0);//评论数
        sku.setSaleNum(0);//销售数量

        skuMapper.insert(sku);
    }
}

@Service(interfaceClass=SpuService.class)

@PostMapping("/save")
public Result save(@RequestBody Goods goods){
    spuService.saveGoods(goods);
    return new Result();
}

@Table(name="tb_category_brand")
@Data
public class CategoryBrand implements Serializable {
    @Id
    private Integer categoryId;
    @Id 
    private Integer brandId;
}

public interface CategoryBrandMapper extends Mapper<CategoryBrand> {
}

CategoryBrand categoryBrand =new CategoryBrand();
categoryBrand.setBrandId(spu.getBrandId());
categoryBrand.setCategoryId(spu.getCategory3Id());
int count=categoryBrandMapper.selectCount(categoryBrand);
if(count==0) {
    categoryBrandMapper.insert(categoryBrand);
}

{
    "spu": {
        "brandId": 0,
        "caption": "111",
        "category1Id": 558,
        "category2Id": 559,
        "category3Id": 560,
        "commentNum": null,
        "freightId": null,
        "id": 149187842867993,
        "image": null,
        "images": null,
        "introduction": null,
        "isDelete": null,
        "isEnableSpec": "0",
        "isMarketable": "1",
        "name": "黑马智能手机",
        "paraItems": null,
        "saleNum": null,
        "saleService": null,
        "sn": null,
        "specItems": null,
        "status": null,
        "templateId": 42
    },
    "skuList": [
        {
            "alertNum": null,
            "brandName": "金立（Gionee）",
            "categoryId": 560,
            "categoryName": "手机",
            "commentNum": null,
            "createTime": "2018‐11‐06 10:17:08",
            "id": 1369324,
            "image": null,
            "images": "blob:http://localhost:8080/ec04d1a5‐d865‐4e7f‐a313‐2e9a76cfb3f8",
            "name": "黑马智能手机",
            "num": 100,
            "price": 900000,
            "saleNum": null,
            "sn": "",
            "spec": null,
            "spuId": 149187842867993,
            "status": "1",
            "updateTime": "2018‐11‐06 10:17:08",
            "weight": null
        },
        {
            "alertNum": null,
            "brandName": "金立（Gionee）",
            "categoryId": 560,
            "categoryName": "手机",
            "commentNum": null,
            "createTime": "2018‐11‐06 10:17:08",
            "id": 1369325,
            "image": null,
            "images": "blob:http://localhost:8080/ec04d1a5‐d865‐4e7f‐a313‐2e9a76cfb3f8",
            "name": "黑马智能手机",
            "num": 100,
            "price": 900000,
            "saleNum": null,
            "sn": "",
            "spec": null,
            "spuId": 149187842867993,
            "status": "1",
            "updateTime": "2018‐11‐06 10:17:08",
            "weight": null
        }
    ]
}

/**
* 根据ID查询商品
* @param id 
* @return
*/
public Goods findGoodsById(String id){
    //查询spu
    Spu spu = spuMapper.selectByPrimaryKey(id);
    
    //查询SKU 列表
    Example example=new Example(Sku.class);
    Example.Criteria criteria = example.createCriteria();
    criteria.andEqualTo("spuId",id);
    List<Sku> skuList = skuMapper.selectByExample(example);
    
    //封装，返回
    Goods goods=new Goods();
    goods.setSpu(spu);
    goods.setSkuList(skuList);
    return goods;
}

@GetMapping("/findGoodsById")
public Goods findGoodsById(Long id){
    return spuService.findGoodsById(id);
}

/**
* 保存商品
* @param goods
*/
@Transactional
public void saveGoods(Goods goods) {
    //保存一个spu的信息
    Spu spu = goods.getSpu();
    if(spu.getId()==null){//新增商品
        spu.setId(idWorker.nextId()+"");
        spuMapper.insert(spu);
    }else{ //修改
        //删除原来的sku列表
        Example example=new Example(Sku.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("spuId",spu.getId());
        skuMapper.deleteByExample(example);

        //执行spu的修改
        spuMapper.updateByPrimaryKeySelective(spu);
    }

    //保存sku列表的信息
    List<Sku> skuList = goods.getSkuList();
    for (Sku sku:skuList){
        if(sku.getId()==null){//新增
            sku.setId(idWorker.nextId()+"");
            sku.setCreateTime(date);//创建日期
        }
        //添加sku
    }

//建立分类和品牌的关联
}

// 构建SKU名称，采用SPU+规格值组装
if(sku.getSpec()==null || "".equals(sku.getSpec())){
    sku.setSpec("{}");
}

/**
* 商品审核
* @param id
* @param status
* @param message
*/
@Transactional
public void audit(String id, String status, String message) {
    //1.修改状态 审核状态和上架状态
    Spu spu = new Spu();
    spu.setId(id);
    spu.setStatus(status);
    if("1".equals(status)){//审核通过
        spu.setIsMarketable("1");//自动上架
    }
    spuMapper.updateByPrimaryKeySelective(spu);
    
    //2.记录商品审核记录
    
    //3.记录商品日志
}

@GetMapping("/audit")
public Result audit(Long id){
    spuService.audit(id);
    return new Result();
}

/**
* 下架商品
* @param id
*/
public void pull(String id) {
    Spu spu = spuMapper.selectByPrimaryKey(id);
    spu.setIsMarketable("0");//下架状态
    spuMapper.updateByPrimaryKeySelective(spu);
}

@GetMapping("/pull")
public Result pull(String id){
    spuService.pull(id);
    return new Result();
}

/**
* 商品上架
* @param id
*/
public void put(String id) {
    //1.修改状态
    Spu spu = spuMapper.selectByPrimaryKey(id);
    if(!"1".equals(spu.getStatus())){
        throw new RuntimeException("此商品未通过审核");
    }
    spu.setIsMarketable("1");
    spuMapper.updateByPrimaryKeySelective(spu);
    
    //2.记录商品日志
}

@GetMapping("/put")
public Result put(String id){
    spuService.put(id);
    return new Result();
}

/**
* 批量上架商品
* @param ids
*/
public int putMany(Long[] ids) {
    Spu spu=new Spu();
    spu.setIsMarketable("1");//上架
    
    //批量修改
    Example example=new Example(Spu.class);
    Example.Criteria criteria = example.createCriteria();
    criteria.andIn("id", Arrays.asList(ids));//id
    criteria.andEqualTo("isMarketable","0");//下架
    criteria.andEqualTo("status","1");//审核通过的
    criteria.andEqualTo("isDelete","0");//非删除的
    return spuMapper.updateByExampleSelective(spu, example);
}

@GetMapping("/putMany")
public Result putMany(Long[] ids){
    int count = spuService.putMany(ids);
    return new Result(0,"上架"+count+"个商品");
}