from datetime import datetime
from django.db import models

# Create your models here.
from studyuser.models import UserInfo
from courseapp.models import Course


class UserAsk(models.Model):
    # 用户咨询
    name = models.CharField(max_length=20, verbose_name=u'姓名')
    mobile = models.CharField(max_length=11, verbose_name=u'手机号')
    course_name = models.CharField(max_length=50, verbose_name=u'课程名')
    add_time = models.DateTimeField(default=datetime.now, verbose_name=u'添加时间')

    class Meta:
        verbose_name = u'用户咨询'
        verbose_name_plural = verbose_name


class CourseComments(models.Model):
    """课程评论"""
    user = models.ForeignKey(UserInfo, verbose_name=u'用户', blank=True, null=True)
    course = models.ForeignKey(Course, verbose_name=u'课程')
    comments = models.CharField(max_length=200, verbose_name=u'评论')
    add_time = models.DateTimeField(default=datetime.now, verbose_name=u'添加时间')

    class Meta:
        verbose_name = u'课程评论'
        verbose_name_plural = verbose_name


class UserFavorite(models.Model):
    user = models.ForeignKey(UserInfo, verbose_name=u'用户')
    course = models.ForeignKey(Course, verbose_name=u'课程')
    fav_id = models.IntegerField(default=0, verbose_name=u'数据id')
    fav_type = models.IntegerField(choices=((1, '课程'), (2, '课程机构'), (3, '讲师')), default=1, verbose_name=u'收藏类型')

    class Meta:
        verbose_name = u'用户收藏'
        verbose_name_plural = verbose_name


# 用户消息，可以发给用户　发给全员的消息
class UserMessage(models.Model):
    # 接受的用户的id
    user = models.IntegerField(default=0, verbose_name=u'接受用户')
    message = models.CharField(max_length=200, verbose_name=u'消息内容')
    has_read = models.BooleanField(default=False, verbose_name=u'是否已读')
    add_time = models.DateTimeField(default=datetime.now, verbose_name=u'添加时间')

    class Meta:
        verbose_name = u'用户消息'
        verbose_name_plural = verbose_name


# 用户课程


class UserCourse(models.Model):
    user = models.ForeignKey(UserInfo, verbose_name=u'用户')
    course = models.ForeignKey(Course, verbose_name=u'课程')
    add_time = models.DateTimeField(default=datetime.now, verbose_name=u'添加时间')

    class Meta:
        verbose_name = u'用户消息'
        verbose_name_plural = verbose_name
