<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')