sku与spu

<el-option

v-for="item in spus_list"

:key="item.id"

:label="item.name"

:value="item.id">

</el-option>

:key 用来标识虚拟daomo

spu模型类创建

商品类的总称  如"商品SPU，如小米手机10；苹果13"

# SPU
# id   pk
#name  varchar(20)  'spu'
#brand    外键 "品牌"
#category1     外键  related_name="cate1_spu"  '一级类别'
#category2   
#category3
#comment_num  int  default 0    "评论量"
#sales  int  defult 0   "销量"
#desc_detail  text   "详细描述"
#desc_pack   text  "包装信息"
#desc_service text   '售后服务'
class SPU(models.Model):
    "商品SPU，如小米手机10；苹果13"
    name = models.CharField(max_length=20, verbose_name="spu")
    brand = models.ForeignKey(Brand, on_delete=models.PROTECT, verbose_name='品牌')
    category1 = models.ForeignKey(Cate, on_delete=models.PROTECT, related_name='cate1_spu', verbose_name='一级类别')
    category2 = models.ForeignKey(Cate, on_delete=models.PROTECT, related_name='cate2_spu', verbose_name='二级类别')
    category3 = models.ForeignKey(Cate, on_delete=models.PROTECT, related_name='cate3_spu', verbose_name='三级类别')
    comment_num = models.IntegerField(verbose_name="评论量",default=0)
    sales = models.IntegerField(verbose_name="销量",default=0)
    desc_detail = models.TextField(default='', verbose_name='详细介绍')
    desc_pack = models.TextField(default='', verbose_name='包装信息')
    desc_service = models.TextField(default='', verbose_name='售后服务')

on_delete=models.PROTECT(保护机制) 与on_delete=models.CASCADE(级联删除类似)
related_name='cate1_spu'  设置反向查询时的表名 以cate1_spu进行反向查询

sku模型类创建

商品具体信息 如 名称、描述、价格、库存、商品详情、商品默认图片、分类( 华为P30 黑色 8G 256G 大气的外观，超大容量，润泽流光，全景绽放 等)

# 商品表
# name   varchar(100)
# describe varchar(500)
#price  8,2
#stock int default=0
#sales int default =0
#detail text
#image_default  varchar(300)
#is_selling boolean  True
#cate 外键
#spu 外键
class Good(models.Model):
    """
    商品表
        名称、描述、价格、库存、商品详情、商品默认图片、分类
    """
    name = models.CharField(max_length=100)
    describe = models.CharField(max_length=500)
    price = models.DecimalField(max_digits=8, decimal_places=2)
    stock = models.IntegerField(default=0)
    detail = models.TextField()
    image_default = models.CharField(verbose_name="默认图片的地址",max_length=300)
    
    is_selling = models.BooleanField(default=True)
    sales = models.IntegerField(verbose_name="销量",default=0)
    # 一级分类
    cate = models.ForeignKey(Cate, on_delete=models.CASCADE)
    spu = models.ForeignKey(SPU,on_delete=models.CASCADE, verbose_name='商品SPU')