基于Django的线上果蔬商城（二）：表结构设计（tinymce的使用）

骑猪看日落 2023-07-03 10:58 160阅读 0赞

# 表结构分析 #

## 用户模块和商品模块 ##

![在这里插入图片描述][20200206101408616.png]  
拓展： SKU与SPU概念  
SPU = Standard Product Unit (标准产品单位)  
SPU 是商品信息聚合的最小单位，是一组可复用、易检索的标准化信息的集合，该集合描述 了一个产品的特性。通俗点讲，属性值、特性相同的商品就可以称为一个 SPU。  
例如:iphone7 就是一个 SPU，与商家，与颜色、款式、套餐都无关。  
SKU=stock keeping unit(库存量单位)

SKU 即库存进出计量的单位， 可以是以件、盒、托盘等为单位。  
SKU 是物理上不可分割的最小存货单元。在使用时要根据不同业态，不同管理模式来处理。 在服装、鞋类商品中使用最多最普遍。  
例如:纺织品中一个 SKU 通常表示:规格、颜色、款式。

## 购物车和订单模块 ##

![在这里插入图片描述][2020020610385769.png]

注意：一条信息对应多条数据时，就应该抽出来，再建一张表，做成一对多的关系

# 搭建model #

## 抽象基类 ##

from django.db import models
    
    
    class BaseModel(models.Model):
        """模型抽象基类"""
        create_time = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')
        update_time = models.DateTimeField(auto_now=True, verbose_name='更新时间')
        is_delete = models.BooleanField(default=False, verbose_name='删除标记')
    
        class Meta:
            # 说明是一个抽象模型类
            abstract = True

## 用户模块 ##

from django.contrib.auth.models import AbstractUser
    from db.base_model import BaseModel
    
    class User(AbstractUser, BaseModel):
        """用户模型类"""
    
        class Meta:
            db_table = 'df_user'
            verbose_name = '用户'
            verbose_name_plural = verbose_name
    
    
    class Address(BaseModel):
        """地址模型类"""
        user = models.ForeignKey('User', on_delete=models.CASCADE,verbose_name='所属账户')
        receiver = models.CharField(max_length=20, verbose_name='收件人')
        addr = models.CharField(max_length=256, verbose_name='收件地址')
        zip_code = models.CharField(max_length=6, null=True, verbose_name='邮政编码')
        phone = models.CharField(max_length=11, verbose_name='联系电话')
        is_default = models.BooleanField(default=False, verbose_name='是否默认')
    
        class Meta:
            db_table = 'df_address'
            verbose_name = '地址'
            verbose_name_plural = verbose_name

## 商品模块 ##

from tinymce.models import HTMLField
    from db.base_model import BaseModel
    
    class GoodsType(BaseModel):
        """商品类型模型类"""
        name = models.CharField(max_length=20, verbose_name='种类名称')
        logo = models.CharField(max_length=20, verbose_name='标识')
        image = models.ImageField(upload_to='type', verbose_name='商品类型图片')
    
        class Meta:
            db_table = 'df_goods_type'
            verbose_name = '商品种类'
            verbose_name_plural = verbose_name
    
        def __str__(self):
            return self.name
    
    
    class GoodsSKU(BaseModel):
        """商品SKU模型类"""
        status_choices = (
            (0, '下线'),
            (1, '上线'),
        )
        type = models.ForeignKey('GoodsType', on_delete=models.CASCADE,verbose_name='商品种类')
        goods = models.ForeignKey('Goods', on_delete=models.CASCADE,verbose_name='商品SPU')
        name = models.CharField(max_length=20, verbose_name='商品名称')
        desc = models.CharField(max_length=256, verbose_name='商品简介')
        price = models.DecimalField(max_digits=10, decimal_places=2, verbose_name='商品价格')
        unite = models.CharField(max_length=20, verbose_name='商品单位')
        image = models.ImageField(upload_to='goods', verbose_name='商品图片')
        stock = models.IntegerField(default=1, verbose_name='商品库存')
        sales = models.IntegerField(default=0, verbose_name='商品销量')
        status = models.SmallIntegerField(default=1, choices=status_choices, verbose_name='商品状态')
    
        class Meta:
            db_table = 'df_goods_sku'
            verbose_name = '商品'
            verbose_name_plural = verbose_name
    
    
    class Goods(BaseModel):
        """商品SPU模型类"""
        name = models.CharField(max_length=20, verbose_name='商品SPU名称')
        # 富文本类型:带有格式的文本
        detail = HTMLField(blank=True, verbose_name='商品详情')
    
        class Meta:
            db_table = 'df_goods'
            verbose_name = '商品SPU'
            verbose_name_plural = verbose_name
    
    
    class GoodsImage(BaseModel):
        """商品图片模型类"""
        sku = models.ForeignKey('GoodsSKU', on_delete=models.CASCADE,verbose_name='商品')
        image = models.ImageField(upload_to='goods', verbose_name='图片路径')
    
        class Meta:
            db_table = 'df_goods_image'
            verbose_name = '商品图片'
            verbose_name_plural = verbose_name
    
    
    class IndexGoodsBanner(BaseModel):
        """首页轮播商品展示模型类"""
        sku = models.ForeignKey('GoodsSKU', on_delete=models.CASCADE,verbose_name='商品')
        image = models.ImageField(upload_to='banner', verbose_name='图片')
        index = models.SmallIntegerField(default=0, verbose_name='展示顺序')
    
        class Meta:
            db_table = 'df_index_banner'
            verbose_name = '首页轮播商品'
            verbose_name_plural = verbose_name
    
    
    class IndexTypeGoodsBanner(BaseModel):
        """首页分类商品展示模型类"""
        DISPLAY_TYPE_CHOICES = (
            (0, "标题"),
            (1, "图片")
        )
    
        type = models.ForeignKey('GoodsType', on_delete=models.CASCADE,verbose_name='商品类型')
        sku = models.ForeignKey('GoodsSKU', on_delete=models.CASCADE,verbose_name='商品SKU')
        display_type = models.SmallIntegerField(default=1, choices=DISPLAY_TYPE_CHOICES, verbose_name='展示类型')
        index = models.SmallIntegerField(default=0, verbose_name='展示顺序')
    
        class Meta:
            db_table = 'df_index_type_goods'
            verbose_name = "主页分类展示商品"
            verbose_name_plural = verbose_name
    
    
    class IndexPromotionBanner(BaseModel):
        """首页促销活动模型类"""
        name = models.CharField(max_length=20, verbose_name='活动名称')
        url = models.URLField(verbose_name='活动链接')
        image = models.ImageField(upload_to='banner', verbose_name='活动图片')
        index = models.SmallIntegerField(default=0, verbose_name='展示顺序')
    
        class Meta:
            db_table = 'df_index_promotion'
            verbose_name = "主页促销活动"
            verbose_name_plural = verbose_name

[配置Django-tinymce富文本编辑器][Django-tinymce]

## 订单模块 ##

from db.base_model import BaseModel
    
    
    class OrderInfo(BaseModel):
        '''订单模型类'''
        PAY_METHOD_CHOICES = (
            (1, '货到付款'),
            (2, '微信支付'),
            (3, '支付宝'),
            (4, '银联支付')
        )
    
        ORDER_STATUS_CHOICES = (
            (1, '待支付'),
            (2, '待发货'),
            (3, '待收货'),
            (4, '待评价'),
            (5, '已完成')
        )
    
        order_id = models.CharField(max_length=128, primary_key=True, verbose_name='订单id')
        user = models.ForeignKey('user.User', on_delete=models.CASCADE,verbose_name='用户')
        addr = models.ForeignKey('user.Address', on_delete=models.CASCADE,verbose_name='地址')
        pay_method = models.SmallIntegerField(choices=PAY_METHOD_CHOICES, default=3, verbose_name='支付方式')
        total_count = models.IntegerField(default=1, verbose_name='商品数量')
        total_price = models.DecimalField(max_digits=10, decimal_places=2, verbose_name='商品总价')
        transit_price = models.DecimalField(max_digits=10, decimal_places=2,verbose_name='订单运费')
        order_status = models.SmallIntegerField(choices=ORDER_STATUS_CHOICES, default=1, verbose_name='订单状态')
        trade_no = models.CharField(max_length=128, verbose_name='支付编号')
    
        class Meta:
            db_table = 'df_order_info'
            verbose_name = '订单'
            verbose_name_plural = verbose_name
    
    
    class OrderGoods(BaseModel):
        '''订单商品模型类'''
        order = models.ForeignKey('OrderInfo', on_delete=models.CASCADE,verbose_name='订单')
        sku = models.ForeignKey('goods.GoodsSKU',on_delete=models.CASCADE, verbose_name='商品SKU')
        count = models.IntegerField(default=1, verbose_name='商品数目')
        price = models.DecimalField(max_digits=10, decimal_places=2, verbose_name='商品价格')
        comment = models.CharField(max_length=256, verbose_name='评论')
    
        class Meta:
            db_table = 'df_order_goods'
            verbose_name = '订单商品'
            verbose_name_plural = verbose_name

## 购车车模块 ##

使用Redis进行设置，后面再说

# 其他配置 #

路由分发

urlpatterns = [
        re_path(r'^admin/', admin.site.urls),
        re_path(r'^tinymce/', include('tinymce.urls')), # 富文本编辑器
        re_path(r'^user/', include(('user.urls','user'), namespace='user')), # 用户模块
        re_path(r'^cart/', include(('cart.urls','cart'), namespace='cart')), # 购物车模块
        re_path(r'^order/', include(('order.urls','order'), namespace='order')), # 订单模块
        re_path(r'^', include(('goods.urls','goods'), namespace='goods')), # 商品模块
    ]

使用Django自带的认证系统

# django认证系统使用的模型类
    AUTH_USER_MODEL='user.User'

应用注册

sys.path.insert(0,os.path.join(BASE_DIR,'apps'))
    
    INSTALLED_APPS = (
        'user', # 用户模块
        'goods', # 商品模块
        'cart', # 购物车模块
        'order', # 订单模块
    )

把各个模块整合到apps中  
![在这里插入图片描述][20200207110637124.png]  
完成表的迁移（makemigrations）和提交（migrate）![在这里插入图片描述][20200207110057487.png]

[20200206101408616.png]: https://img-blog.csdnimg.cn/20200206101408616.png
[2020020610385769.png]: https://img-blog.csdnimg.cn/2020020610385769.png
[Django-tinymce]: https://pypi.org/project/django-tinymce/
[20200207110637124.png]: https://img-blog.csdnimg.cn/20200207110637124.png
[20200207110057487.png]: https://img-blog.csdnimg.cn/20200207110057487.png