Django+Vue打造购物网站(一)

环境搭建

python == 3.6

Django == 2.0

创建工程

django-admin startproject MxShop

配置setting.py文件

# 数据库

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.mysql',

        'NAME': 'mxshop',        #数据库名字

        'USER': 'root',          #账号

        'PASSWORD': '123456',      #密码

        'HOST': '127.0.0.1',    #IP

        'PORT': '3306',                   #端口

        #因为后面第三方登录时，要求引擎为INNODB

        "OPTIONS":{"init_command":"SET default_storage_engine=INNODB;"}

    }

}

# 使用中文

LANGUAGE_CODE = 'zh-hans'

TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

USE_TZ = False

# 静态文件路径(须在根目录下创建static目录)

STATIC_URL = '/static/'

STATICFILES_DIRS = (

    os.path.join(BASE_DIR, 'static'),

)

安装djangorestframework

pip install djangorestframework

pip install markdown       # Markdown support for the browsable API.

pip install django-filter  # Filtering support

安装其它的插件

mysql插件地址https://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclint,自行下载

pip install mysqlclient-1.3.12-cp36-cp36m-win_amd64

pip install pillow

新建两个python package

extra_apps （扩展的源码包）
apps （放所有app）

新建两个文件夹

media （保存图片）
db_tools （数据库相关）

把extra_apps和apps添加到sys.path中

# settings.py

import sys

BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

sys.path.insert(0,BASE_DIR)

sys.path.insert(0,os.path.join(BASE_DIR, 'apps'))

sys.path.insert(0,os.path.join(BASE_DIR, 'extra_apps'))

models 设计

首先安装xadmin和DjangoUeditor

安装方法参考之前的在线教育系统

python manage.py startapp users

python manage.py startapp goods

python manage.py startapp trade

python manage.py startapp user_operation

INSTALLED_APPS = [

    'django.contrib.admin',

    'django.contrib.auth',

    'django.contrib.contenttypes',

    'django.contrib.sessions',

    'django.contrib.messages',

    'django.contrib.staticfiles',

    'rest_framework',

    'users',

    'user_operation',

    'trade',

    'goods',

    'xadmin',

    'DjangoUeditor',

    'crispy_forms',

]

users models设计

from datetime import datetime

from django.contrib.auth.models import AbstractUser

from django.db import models

# Create your models here.

class UserProfile(AbstractUser):

    """

    用户信息

    """

    GENDER_CHOICES = (

        ("male", "男"),

        ("female", "女")

    )

    # 用户用手机注册，所以姓名，生日和邮箱可以为空

    name = models.CharField(verbose_name="姓名",max_length=30, null=True, blank=True)

    birthday = models.DateField(verbose_name="出生年月",null=True, blank=True)

    gender = models.CharField(verbose_name="性别",max_length=6, choices=GENDER_CHOICES, default="female")

    mobile = models.CharField(verbose_name="电话",max_length=11)

    email = models.EmailField(verbose_name="邮箱",max_length=100, null=True, blank=True)

    class Meta:

        verbose_name = "用户信息"

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.username

class VerifyCode(models.Model):

    """

    验证码

    """

    code = models.CharField(verbose_name="验证码",max_length=10)

    mobile = models.CharField(verbose_name="电话",max_length=11)

    add_time = models.DateTimeField(verbose_name="添加时间",default=datetime.now)

    class Meta:

        verbose_name = "短信验证"

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.code

trade models设计

from datetime import datetime

from django.contrib.auth import get_user_model

from django.db import models

# Create your models here.

from goods.models import Goods

User = get_user_model()

class ShoppingCart(models.Model):

    """

    购物车

    """

    user = models.ForeignKey(User, verbose_name=u"用户", on_delete=models.CASCADE)

    goods = models.ForeignKey(Goods, verbose_name=u"商品", on_delete=models.CASCADE)

    nums = models.IntegerField(default=0, verbose_name="购买数量")

    add_time = models.DateTimeField(default=datetime.now, verbose_name=u"添加时间")

    class Meta:

        verbose_name = '购物车'

        verbose_name_plural = verbose_name

        unique_together = ("user", "goods")

    def __str__(self):

        return "%s(%d)".format(self.goods.name, self.nums)

class OrderInfo(models.Model):

    """

    订单

    """

    ORDER_STATUS = (

        ("TRADE_SUCCESS", "成功"),

        ("TRADE_CLOSED", "超时关闭"),

        ("WAIT_BUYER_PAY", "交易创建"),

        ("TRADE_FINISHED", "交易结束"),

        ("paying", "待支付"),

    )

    user = models.ForeignKey(User, verbose_name="用户", on_delete=models.CASCADE)

    order_sn = models.CharField(max_length=30, null=True, blank=True, unique=True, verbose_name="订单号")

    trade_no = models.CharField(max_length=100, unique=True, null=True, blank=True, verbose_name=u"交易号")

    pay_status = models.CharField(choices=ORDER_STATUS, default="paying", max_length=30, verbose_name="订单状态")

    post_script = models.CharField(max_length=200, verbose_name="订单留言")

    order_mount = models.FloatField(default=0.0, verbose_name="订单金额")

    pay_time = models.DateTimeField(null=True, blank=True, verbose_name="支付时间")

    # 用户信息

    address = models.CharField(max_length=100, default="", verbose_name="收货地址")

    signer_name = models.CharField(max_length=20, default="", verbose_name="签收人")

    singer_mobile = models.CharField(max_length=11, verbose_name="联系电话")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = u"订单"

        verbose_name_plural = verbose_name

    def __str__(self):

        return str(self.order_sn)

class OrderGoods(models.Model):

    """

    订单的商品详情

    """

    order = models.ForeignKey(OrderInfo, verbose_name="订单信息", related_name="goods", on_delete=models.CASCADE)

    goods = models.ForeignKey(Goods, verbose_name="商品", on_delete=models.CASCADE)

    goods_num = models.IntegerField(default=0, verbose_name="商品数量")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = "订单商品"

        verbose_name_plural = verbose_name

    def __str__(self):

        return str(self.order.order_sn)

goods models 设计

from datetime import datetime

from django.db import models

# Create your models here.

class GoodsCategory(models.Model):

    """

    商品类别

    """

    CATEGORY_TYPE = (

        (1, "一级类目"),

        (2, "二级类目"),

        (3, "三级类目"),

    )

    name = models.CharField(default="", max_length=30, verbose_name="类别名", help_text="类别名")

    code = models.CharField(default="", max_length=30, verbose_name="类别code", help_text="类别code")

    desc = models.TextField(default="", verbose_name="类别描述", help_text="类别描述")

    category_type = models.IntegerField(choices=CATEGORY_TYPE, verbose_name="类目级别", help_text="类目级别")

    parent_category = models.ForeignKey("self", null=True, blank=True, verbose_name="父类目级别", help_text="父目录",

                                        related_name="sub_cat",on_delete=models.CASCADE )

    is_tab = models.BooleanField(default=False, verbose_name="是否导航", help_text="是否导航")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = "商品类别"

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.name

class GoodsCategoryBrand(models.Model):

    """

    品牌名

    """

    category = models.ForeignKey(GoodsCategory, related_name='brands', null=True, blank=True, verbose_name="商品类目", on_delete=models.CASCADE)

    name = models.CharField(default="", max_length=30, verbose_name="品牌名", help_text="品牌名")

    desc = models.TextField(default="", max_length=200, verbose_name="品牌描述", help_text="品牌描述")

    image = models.ImageField(max_length=200, upload_to="brands/")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = "品牌"

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.name

class Goods(models.Model):

    """

    商品

    """

    category = models.ForeignKey(GoodsCategory, verbose_name="商品类目", on_delete=models.CASCADE)

    goods_sn = models.CharField(max_length=50, default="", verbose_name="商品唯一货号")

    name = models.CharField(max_length=100, verbose_name="商品名")

    click_num = models.IntegerField(default=0, verbose_name="点击数")

    sold_num = models.IntegerField(default=0, verbose_name="商品销售量")

    fav_num = models.IntegerField(default=0, verbose_name="收藏数")

    goods_num = models.IntegerField(default=0, verbose_name="库存数")

    market_price = models.FloatField(default=0, verbose_name="市场价格")

    shop_price = models.FloatField(default=0, verbose_name="本店价格")

    goods_brief = models.TextField(max_length=500, verbose_name="商品简短描述")

    goods_desc = UEditorField(verbose_name=u"内容", imagePath="goods/images/", width=1000, height=300,

                              filePath="goods/files/", default='')

    ship_free = models.BooleanField(default=True, verbose_name="是否承担运费")

    goods_front_image = models.ImageField(upload_to="goods/images/", null=True, blank=True, verbose_name="封面图")

    is_new = models.BooleanField(default=False, verbose_name="是否新品")

    is_hot = models.BooleanField(default=False, verbose_name="是否热销")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = '商品'

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.name

class IndexAd(models.Model):

    category = models.ForeignKey(GoodsCategory, related_name='category',verbose_name="商品类目", on_delete=models.CASCADE)

    goods =models.ForeignKey(Goods, related_name='goods', on_delete=models.CASCADE)

    class Meta:

        verbose_name = '首页商品类别广告'

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.goods.name

class GoodsImage(models.Model):

    """

    商品轮播图

    """

    goods = models.ForeignKey(Goods, verbose_name="商品", related_name="images", on_delete=models.CASCADE)

    image = models.ImageField(upload_to="", verbose_name="图片", null=True, blank=True)

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = '商品图片'

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.goods.name

class Banner(models.Model):

    """

    轮播的商品

    """

    goods = models.ForeignKey(Goods, verbose_name="商品", on_delete=models.CASCADE)

    image = models.ImageField(upload_to='banner', verbose_name="轮播图片")

    index = models.IntegerField(default=0, verbose_name="轮播顺序")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = '轮播商品'

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.goods.name

class HotSearchWords(models.Model):

    """

    热搜词

    """

    keywords = models.CharField(default="", max_length=20, verbose_name="热搜词")

    index = models.IntegerField(default=0, verbose_name="排序")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = '热搜词'

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.keywords

user_operation models设计

from datetime import datetime

from django.contrib.auth import get_user_model

from django.db import models

# Create your models here.

from goods.models import Goods

User = get_user_model()

class UserFav(models.Model):

    """

    用户收藏

    """

    user = models.ForeignKey(User, verbose_name="用户", on_delete=models.CASCADE)

    goods = models.ForeignKey(Goods, verbose_name="商品", help_text="商品id", on_delete=models.CASCADE)

    add_time = models.DateTimeField(default=datetime.now, verbose_name=u"添加时间")

    class Meta:

        verbose_name = '用户收藏'

        verbose_name_plural = verbose_name

        unique_together = ("user", "goods")

    def __str__(self):

        return self.user.username

class UserLeavingMessage(models.Model):

    """

    用户留言

    """

    MESSAGE_CHOICES = (

        (1, "留言"),

        (2, "投诉"),

        (3, "询问"),

        (4, "售后"),

        (5, "求购")

    )

    user = models.ForeignKey(User, verbose_name="用户", on_delete=models.CASCADE)

    message_type = models.IntegerField(default=1, choices=MESSAGE_CHOICES, verbose_name="留言类型",

                                       help_text=u"留言类型: 1(留言),2(投诉),3(询问),4(售后),5(求购)")

    subject = models.CharField(max_length=100, default="", verbose_name="主题")

    message = models.TextField(default="", verbose_name="留言内容", help_text="留言内容")

    file = models.FileField(upload_to="message/images/", verbose_name="上传的文件", help_text="上传的文件")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = "用户留言"

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.subject

class UserAddress(models.Model):

    """

    用户收货地址

    """

    user = models.ForeignKey(User, verbose_name="用户", on_delete=models.CASCADE)

    province = models.CharField(max_length=100, default="", verbose_name="省份")

    city = models.CharField(max_length=100, default="", verbose_name="城市")

    district = models.CharField(max_length=100, default="", verbose_name="区域")

    address = models.CharField(max_length=100, default="", verbose_name="详细地址")

    signer_name = models.CharField(max_length=100, default="", verbose_name="签收人")

    signer_mobile = models.CharField(max_length=11, default="", verbose_name="电话")

    add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")

    class Meta:

        verbose_name = "收货地址"

        verbose_name_plural = verbose_name

    def __str__(self):

        return self.address

将models映射到数据库中

python manage.py makemigrations

python manage.py migrate

巴特西

Django+Vue打造购物网站(一)

环境搭建

models 设计

users models设计

trade models设计

goods models 设计

user_operation models设计

将models映射到数据库中

最新文章

热门文章