wanzb_v3_api/src/common/models.py

# coding=utf-8
'''
'''
from django.db import models

class UserInfo(models.Model):
    """用户表
    """
    username = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    usercode = models.CharField(u"用户代码", max_length=255, blank=True,null=True)
    password = models.CharField(u"密码", max_length=255, blank=True,null=True)
    realname = models.CharField(u"真实名称", max_length=255, blank=True, null=True)
    openid = models.CharField(u"微信openid", max_length=64, blank=True,null=True)
    avatar = models.CharField(u"手机号", max_length=64, blank=True,null=True)
    nickname = models.CharField(u"手机号", max_length=64, blank=True,null=True)

    is_bind = models.SmallIntegerField(u"是否绑定",default=0)
    utype = models.SmallIntegerField(u"是否激活可用",default=0)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "users"
        verbose_name = u"用户信息"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.username)

    def is_authenticated(self):
        return True

    def is_anonymous(self):
        return False


class Player(models.Model):
    """参数选手
    """
    user_id = models.IntegerField(u"用户id", blank=True,null=True)
    username = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    usercode = models.CharField(u"用户代码", max_length=255, blank=True,null=True)
    match_id = models.IntegerField(u"比赛id", blank=True,null=True)
    match_name = models.CharField(u"比赛名称", max_length=255,blank=True,null=True)
    match_group = models.CharField(u"比赛分组", max_length=255,blank=True,null=True)
    fund = models.FloatField(u"资金",blank=True,null=True)
    match_status = models.SmallIntegerField(u"比赛状态,退赛/暂停/比赛中-1/0/1",default=0)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "player"
        verbose_name = u"参数选手"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.username)


class PlayerRecord(models.Model):
    """参数选手数据
    """
    user_id = models.IntegerField(u"用户id", blank=True,null=True)
    player_id = models.IntegerField(u"用户id", blank=True,null=True)
    username = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    usercode = models.CharField(u"用户代码", max_length=255, blank=True,null=True)
    match_id = models.IntegerField(u"比赛id", blank=True,null=True)
    stock_date = models.CharField(u"持股日期", max_length=255,blank=True,null=True)
    match_name = models.CharField(u"比赛名称", max_length=255,blank=True,null=True)
    match_group = models.CharField(u"比赛分组", max_length=255,blank=True,null=True)
    init_fund = models.FloatField(u"初始资金",blank=True,null=True)
    yesterday_fund = models.FloatField(u"昨日资金",blank=True,null=True)
    today_fund = models.FloatField(u"今日资金",blank=True,null=True)
    yesterday_stock = models.TextField(u"昨日持股",blank=True,null=True)
    today_stock = models.TextField(u"今日持股",blank=True,null=True)
    yesterday_stock_img = models.TextField(u"昨日持股截图",blank=True,null=True)
    today_stock_img = models.TextField(u"今日持股截图",blank=True,null=True)
    today_income = models.FloatField(u"今日收益",blank=True,null=True)
    total_income = models.FloatField(u"总收益",blank=True,null=True)
    rank = models.IntegerField(u"排名", blank=True,null=True)
    is_markt = models.SmallIntegerField(u"是否开超市",default=0)
    yesterday_is_markt = models.SmallIntegerField(u"昨日是否开超市",default=0)
    auto_complete = models.SmallIntegerField(u"请假次数",default=0)
    yesterday_auto_complete = models.SmallIntegerField(u"请假次数",default=0)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "player_record"
        verbose_name = u"参数选手"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.username)


class Match(models.Model):
    """比赛数据
    """
    name = models.CharField(u"名称", max_length=255, blank=True,null=True)
    start_time = models.CharField(u"开始时间", max_length=255, blank=True,null=True)
    end_time = models.CharField(u"结束时间", max_length=255, blank=True,null=True)
    groups = models.TextField(u"结束时间", max_length=255, blank=True,null=True)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "match"
        verbose_name = u"比赛数据"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.username)


class MatchGroup(models.Model):
    """比赛分组
    """
    match_id = models.IntegerField(u"比赛id", blank=True,null=True)
    name = models.CharField(u"名称", max_length=255, blank=True,null=True)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "match_group"
        verbose_name = u"比赛分组"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.username)


class Stock(models.Model):
    """股票信息表
    """
    name = models.CharField(u"名称", max_length=255, blank=True,null=True)
    code = models.CharField(u"代码", max_length=255, blank=True,null=True)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "stock"
        verbose_name = u"股票"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.username)


class SysUserInfo(models.Model):
    # 基础属性
    name = models.CharField(u"名字", max_length=255, blank=True,null=True)
    phone = models.CharField(u"手机号", max_length=255, blank=True,null=True)
    password = models.CharField(u"密码", max_length=255, blank=True,null=True)
    realname = models.CharField(u"真实名称", max_length=255, blank=True, null=True)
    permissions = models.TextField(u"权限", blank=True,null=True)
    is_active = models.SmallIntegerField(u"是否激活可用",default=0)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)
    last_login = models.DateTimeField(u"创建时间", blank=True,null=True)

    class Meta:
        db_table = "sys_users"
        verbose_name = u"系统用户信息"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.id, self.name)

    def is_authenticated(self):
        return True

    def is_anonymous(self):
        return False


class OperationLogConfig(models.Model):
    """操作日志模板配置
    """
    op_view = models.CharField(u"操作模块", max_length=100,blank=True,null=True)
    op_action_flag = models.CharField(u"操作类型", max_length=50)
    op_module = models.CharField(u"操作模块",max_length=255,blank=True,null=True)
    op_template = models.TextField(u"操作日志模板")
    op_url = models.CharField(u"URL", max_length=255)
    op_response = models.TextField(u"URL", max_length=255, blank=True, null=True)
    order = models.IntegerField(u"排序字段",blank=True,null=True)

    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "oplog_config"
        verbose_name = u"操作日志配置"


class OperationLog(models.Model):
    """操作日志
    """
    op_user_name = models.CharField(u"操作员名称",max_length=255)
    op_user_realname = models.CharField(u"操作员姓名",max_length=255)
    op_user_id = models.IntegerField(u"操作员id")
    op_user_ip = models.CharField(u"操作员ip",max_length=100)
    op_config = models.ForeignKey(OperationLogConfig)
    op_request = models.TextField(u"request body", default="")
    is_suc = models.BooleanField(u"是否成功", default=True)
    error_msg = models.TextField(u"错误信息", max_length=255, blank=True, null=True)
    ctime = models.DateTimeField(u"创建时间", auto_now_add=True)

    class Meta:
        db_table = "oplog"
        verbose_name = u"操作日志"