from datetime import datetime
from django.db import models
from django.contrib.auth.models import AbstractUser
# Create your models here.
class UserProfile(AbstractUser):
"""
管理员
"""
name=models.CharField(max_length=30,null=True,blank=True,verbose_name='姓名')
mobile=models.CharField(max_length=11,null=True,blank=True,verbose_name='电话')
class Meta:
verbose_name='管理员'
verbose_name_plural = verbose_name
def __str__(self):
return self.username
class WxUsers(models.Model):
"""
微信用户
"""
open_id=models.CharField(max_length=64,null=True,blank=True,verbose_name='OpenId')
token=models.CharField(max_length=64,null=True,blank=True,verbose_name='token')
nickName=models.CharField(max_length=30,null=True,blank=True,verbose_name='微信名')
avatarUrl=models.CharField(max_length=200,null=True,blank=True,verbose_name='用户头像URL')
gender = models.CharField(max_length=4, choices=(('0', '未知'),('1', '男'), ('2', '女')), default='0',
verbose_name='性别')
province=models.CharField(max_length=20,null=True,blank=True,verbose_name='用户所在省')
city=models.CharField(max_length=20,null=True,blank=True,verbose_name='用户所在市')
country=models.CharField(max_length=20,null=True,blank=True,verbose_name='用户所在旗县区')
longitude=models.CharField(max_length=10,null=True,blank=True,verbose_name='经度')
latitude=models.CharField(max_length=10,null=True,blank=True,verbose_name='纬度')
last_login_time = models.DateTimeField(default=datetime.now, 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.nickName
AUTH_USER_MODEL='users.UserProfile'
python manage.py makemigrations
python manage.py migrate
from django.db import models
from users.models import WxUsers,UserProfile
from datetime import datetime
from django.utils.safestring import mark_safe
# Create your models here.
class Wish(models.Model):
"""
愿望表
"""
wxuser=models.ForeignKey(WxUsers,on_delete=models.CASCADE)
content=models.CharField(max_length=200,default='',verbose_name='愿望内容',help_text='最多200字')
status=models.CharField(max_length=8, choices=(('0', '进行中'),('1', '放弃了'), ('2', '超时了')), default='0',
verbose_name='阶段')
pv_num=models.IntegerField(default=0,verbose_name='浏览数')
up_num=models.IntegerField(default=0,verbose_name='点赞数')
share_num=models.IntegerField(default=0,verbose_name='转发数')
bb_num=models.IntegerField(default=0,verbose_name='评论数')
end_time = models.DateTimeField(default=datetime.now, 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.content
class News(models.Model):
"""
新闻表
"""
user=models.ForeignKey(UserProfile,on_delete=models.CASCADE)
banner=models.ImageField(max_length=200, upload_to='banner/',verbose_name='轮播图')
title=models.CharField(max_length=15,default='',verbose_name='新闻标题',help_text='最多15字')
content=models.CharField(max_length=800,default='',verbose_name='新闻正文',help_text='最多800字')
add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")
class Meta:
verbose_name='新闻表'
verbose_name_plural=verbose_name
def __str__(self):
return self.title
def image_url(self):
return mark_safe('<img src="/media/{0}" class="field_img">'.format(self.banner))
image_url.short_description = '轮播图'
class Images(models.Model):
"""
新闻图片
"""
image = models.ImageField(max_length=200, upload_to='images/')
news=models.ForeignKey(News, verbose_name="新闻", blank=True,null=True,on_delete=models.CASCADE)
add_time = models.DateTimeField(default=datetime.now, verbose_name='添加时间')
class Meta:
verbose_name = "新闻图片"
verbose_name_plural = verbose_name
def image_url(self):
return mark_safe('<img src="/media/{0}" class="field_img">'.format(self.image))
image_url.short_description = '图片'
pip install pillow
python manage.py makemigrations
python manage.py migrate
from django.db import models
from datetime import datetime
from users.models import WxUsers,UserProfile
from wish.models import Wish
# Create your models here.
class Message(models.Model):
"""
评论表,消息表
"""
user_send=models.ForeignKey(WxUsers,on_delete=models.CASCADE,verbose_name='发出方',related_name='send')
user_receive = models.ForeignKey(WxUsers, on_delete=models.CASCADE, verbose_name='接收方', related_name='receive')
wish=models.ForeignKey(Wish,on_delete=models.CASCADE,verbose_name='被评论的愿望')
content = models.CharField(max_length=30, default='', verbose_name='内容', help_text='最多30字')
is_read=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.content
class Pick(models.Model):
"""
点赞表
"""
user = models.ForeignKey(WxUsers, on_delete=models.CASCADE, verbose_name='点赞者')
wish = models.ForeignKey(Wish, on_delete=models.CASCADE, verbose_name='被点赞的愿望')
action=models.BooleanField(default=True,verbose_name='行为',help_text='true是点赞false是取消点赞')
add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")
class Meta:
verbose_name='点赞表'
verbose_name_plural=verbose_name
def __str__(self):
return self.user
class Share(models.Model):
"""
分享表
"""
user = models.ForeignKey(WxUsers, on_delete=models.CASCADE, verbose_name='分享者')
wish = models.ForeignKey(Wish, on_delete=models.CASCADE, 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.user
class Notice(models.Model):
"""
系统通知表(超越私信)
"""
admin=models.ForeignKey(UserProfile,on_delete=models.CASCADE)
content = models.CharField(max_length=200, default='', verbose_name='内容', help_text='最多200字')
add_time = models.DateTimeField(default=datetime.now, verbose_name="添加时间")
class Meta:
verbose_name='系统通知表'
verbose_name_plural=verbose_name
def __str__(self):
return self.content
python manage.py makemigrations
python manage.py migrate