wzbapi/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.TextField(u"手机号", max_length=255, 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)
    zq = models.CharField(u"周期", max_length=255, blank=True, null=True)
    cw = models.CharField(u"仓位", max_length=255, blank=True, null=True)
    df = models.CharField(u"打法", max_length=255, blank=True, null=True)
    pz = models.CharField(u"品种", max_length=255, blank=True, null=True)
    account_img = models.TextField(u"账号截图", max_length=255, blank=True, null=True)
    join_time = models.CharField(u"入市时间", max_length=255, blank=True, null=True)
    badge = models.CharField(u"选手标识", max_length=255,blank=True,null=True,default=u"选手")
    phone = models.CharField(u"手机号", max_length=64, blank=True,null=True)
    role = models.SmallIntegerField(u"角色",default=0)
    player_type = models.SmallIntegerField(u"选手类型,0/游客,1/普通选手,2/种子选手,3/开户选手",default=0)
    comment_status = models.SmallIntegerField(u"1/正常,0/拉黑",default=1)

    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)
    match_group_name = models.CharField(u"比赛分组名称", max_length=255,blank=True,null=True)
    fund = models.FloatField(u"资金",default=0.0)
    match_status = models.SmallIntegerField(u"比赛状态,退赛/暂停/比赛中-1/0/1",default=0)
    badge = models.CharField(u"选手标识", max_length=255,blank=True,null=True,default=u"选手")
    role = models.SmallIntegerField(u"角色",default=0)
    player_type = models.SmallIntegerField(u"选手类型,0/游客,1/普通选手,2/种子选手,3/开户选手",default=1)
    phone = models.CharField(u"手机号", max_length=50,blank=True,null=True)

    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)
    group_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)
    wanzhu_comment = models.TextField(u"点评",blank=True,null=True)
    experience = models.TextField(u"操盘总结/今日反思",blank=True,null=True)
    zq = models.CharField(u"周期", max_length=255, blank=True, null=True)
    cw = models.CharField(u"仓位", max_length=255, blank=True, null=True)
    df = models.CharField(u"打法", max_length=255, blank=True, null=True)
    pz = models.CharField(u"品种", max_length=255, blank=True, null=True)
    badge = models.CharField(u"选手标识", max_length=255,blank=True,null=True,default=u"选手")
    zans = models.IntegerField(u"点赞数", blank=True,null=True,default=0)
    comments_count = models.IntegerField(u"点赞数", blank=True,null=True,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)
    calendar = models.TextField(u"报单日历", max_length=255, blank=True,null=True)
    valid_dates = models.TextField(u"有效报单时间", max_length=255, blank=True,null=True)
    player_price = models.FloatField(u"选手价格", blank=True,null=True)
    viewer_price = models.FloatField(u"游客价格", blank=True,null=True)
    match_status = models.SmallIntegerField(u"赛事状态1/待发布,2/开始报名,3/比赛中,4/比赛结束", blank=True,null=True,default=1)
    signup_start_time = models.CharField(u"报名开始时间", max_length=255, blank=True,null=True)
    signup_end_time = models.CharField(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.name)


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)
    is_active = models.SmallIntegerField(u"是否显示",default=1)
    order = models.IntegerField(u"排序字段",default=1)
    charge = models.IntegerField(u"是否收费1/收费0/免费",default=1)

    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)
    img = models.TextField(u"封面图",blank=True,null=True)                       
    desc = models.TextField(u"内容",blank=True,null=True)                       
    user_num = models.IntegerField(u"持股人数",blank=False,null=False,default=0)
    comments_num = models.IntegerField(u"留言条数",blank=False,null=False,default=0)
    choice_num = models.IntegerField(u"自选人数",blank=False,null=False,default=0)

    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"操作日志"


class Article(models.Model):                                                       
    # 基础属性                                                                     
    name = models.CharField(u"标题", max_length=255, blank=True,null=True)         
    type = models.CharField(u"类型", max_length=255, blank=True,null=True)         
    img = models.TextField(u"封面图",blank=True,null=True)                       
    content = models.TextField(u"内容",blank=True,null=True)                       
    status = models.SmallIntegerField(u"下线/上线/编辑中-1/2/1",default=1)
                                                                                   
    ctime = models.DateTimeField(u"创建时间",auto_now_add=True)                    
    class Meta:                                                                    
        db_table = "article"                                                       
        verbose_name = u"文章信息"                                                 
        app_label = "common"                                                                                                                                                                                                                                                  


class test(models.Model):
    """测试
    """
    name = models.CharField(u"标题", max_length=255, blank=True,null=True)         
    group_rank = models.IntegerField(u"排名",blank=True,null=True)

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

    class Meta:                                                                    
        db_table = "test"                                                       
        verbose_name = u"测试表"                                                 
        app_label = "common"                                                                                                                                                                                                                                                  

class UserFollows(models.Model):
    """用户关注表
    """
    user_id = models.IntegerField(u"选手id", blank=True,null=True)
    follow_id = models.IntegerField(u"被关注选手id", blank=True,null=True)

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

    class Meta:
        db_table = "user_follows"
        verbose_name = u"用户关注表"
        app_label = "common"

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


class UserStock(models.Model):
    """选手持股情况
    """
    player_id = models.IntegerField(u"选手id", blank=True,null=True)
    stock_id = models.IntegerField(u"股票id", blank=True,null=True)
    stock_date = models.CharField(u"持股日期", max_length=255,blank=True,null=True)
    stock_name = models.CharField(u"股票名称", max_length=255,blank=True,null=True)

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

    class Meta:
        db_table = "user_stock"
        verbose_name = u"选手持股"
        app_label = "common"

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


class WinDefendRank(models.Model):
    """胜率榜
    """
    match_id = models.IntegerField(u"选手id", blank=True,null=True)
    match_group = models.CharField(u"比赛分组", max_length=255,blank=True,null=True)
    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)
    today_fund = models.FloatField(u"资产",blank=True,null=True)
    total_income = models.FloatField(u"总收益",blank=True,null=True)
    win_rate = models.FloatField(u"胜率",blank=True,null=True)
    badest_income = models.FloatField(u"最大回撤",blank=True,null=True)
    zq = models.CharField(u"周期", max_length=255, blank=True, null=True)
    cw = models.CharField(u"仓位", max_length=255, blank=True, null=True)
    df = models.CharField(u"打法", max_length=255, blank=True, null=True)
    pz = models.CharField(u"品种", max_length=255, blank=True, null=True)
    auto_complete = models.SmallIntegerField(u"请假次数",default=0)
    match_status = models.SmallIntegerField(u"比赛状态,退赛/暂停/比赛中-1/0/1",default=1)

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

    class Meta:
        db_table = "win_defend_rank"
        verbose_name = u"胜率防守榜"
        app_label = "common"

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


class HotStockSellCount(models.Model):
    """热门清仓
    """
    stock_id = models.IntegerField(u"股票id", blank=True,null=True)
    stock_name = models.CharField(u"股票名称", blank=True,null=True,max_length=255)
    stock_date = models.CharField(u"持股日期", max_length=255,blank=True,null=True)
    seller_ids = models.TextField(u"清仓选手id",blank=True,null=True)
    count = models.IntegerField(u"清仓人数",default=1)

    class Meta:
        db_table = "hot_stock_seller"
        verbose_name = u"热门清仓"
        app_label = "common"

    def __str__(self):
        return u"{}){}".format(self.stock_id, self.stock_name)


class SignupOrder(models.Model):
    """报名订单表
    """
    user_id = models.IntegerField(u"用户id",blank=True,null=True)
    player_id = models.IntegerField(u"选手id",blank=True,null=True)
    user_name = models.CharField(u"用户名",max_length=50,blank=True,null=True)
    match_id = models.IntegerField(u"比赛id",blank=True,null=True)
    match_name = models.CharField(u"比赛名称",max_length=50,blank=True,null=True)
    total_fee = models.FloatField(u"价格",blank=True,null=True)
    out_trade_no = models.CharField(u"订单号",max_length=50,blank=True,null=True)
    order_status = models.SmallIntegerField(u"订单状态",blank=True,null=True,default=0)
    pay_status = models.SmallIntegerField(u"支付状态",blank=True,null=True,default=0)
    pay_time = models.DateTimeField(u"支付时间",blank=True,null=True)
    signup_type = models.SmallIntegerField(u"报名类型1/游客,2/选手",blank=True,null=True)
    transaction_id = models.CharField(u"交易id",max_length=50,blank=True,null=True)
    remark = models.TextField(u"备注",max_length=50,blank=True,null=True)
    phone = models.CharField(u"手机号",max_length=50,blank=True,null=True)
    match_group = models.IntegerField(u"赛事分组",blank=True,null=True)
    signup_name = models.CharField(u"参赛名",max_length=50,blank=True,null=True)

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

    class Meta:
        db_table = "signup_order"
        verbose_name = u"报名订单表"
        app_label = "common"


class Consult(models.Model):
    """顽主咨询
    """
    user_id = models.IntegerField(u"用户id",blank=True,null=True)
    user_name = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    user_avatar = models.TextField(u"头像", max_length=255, blank=True,null=True)
    content = models.TextField(u"咨询内容", max_length=255, blank=True,null=True)
    reply_content = models.TextField(u"回复内容", max_length=255, blank=True,null=True)
    reply_status = models.SmallIntegerField(u"0/未回复,1/已回复",blank=True,null=True,default=0)
    view_status = models.SmallIntegerField(u"0/未读,1/已读",blank=True,null=True,default=0)

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


    class Meta:
        db_table = "consult"
        verbose_name = u"顽主咨询"
        app_label = "common"


class WanzhuConsult(models.Model):
    """顽主咨询
    """
    user_id = models.IntegerField(u"用户id",blank=True,null=True)
    user_name = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    user_avatar = models.TextField(u"头像", max_length=255, blank=True,null=True)
    player_id = models.IntegerField(u"选手id",blank=True,null=True)
    content = models.TextField(u"咨询内容", max_length=255, blank=True,null=True)
    reply_content = models.TextField(u"回复内容", max_length=255, blank=True,null=True)
    reply_status = models.SmallIntegerField(u"0/未回复,1/已回复",blank=True,null=True,default=0)
    pid = models.IntegerField(u"上级id",blank=True,null=True)
    reply_user_id = models.IntegerField(u"回复用户id",blank=True,null=True)

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


    class Meta:
        db_table = "wanzhu_consult"
        verbose_name = u"顽主咨询"
        app_label = "common"


class Comments(models.Model):
    """作业评论
    """
    user_id = models.IntegerField(u"用户id",blank=True,null=True)
    user_name = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    user_avatar = models.TextField(u"头像", max_length=255, blank=True,null=True)
    player_id = models.IntegerField(u"选手id",blank=True,null=True)
    content = models.TextField(u"咨询内容", max_length=255, blank=True,null=True)
    record_id = models.IntegerField(u"作业id",blank=True,null=True)
    pid = models.IntegerField(u"上级id",blank=True,null=True)
    ip = models.CharField(u"ip地址", max_length=255, blank=True,null=True)
    location = models.CharField(u"地理位置", max_length=255, blank=True,null=True)
    stock_id = models.IntegerField(u"作业id",blank=True,null=True)
    stock_name = models.CharField(u"股票名称", max_length=255, blank=True,null=True)
    rank = models.IntegerField(u"排序",blank=True,null=True,default=1)
    istop = models.IntegerField(u"置顶",blank=True,null=True,default=0)

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

    class Meta:
        db_table = "comments"
        verbose_name = u"评论"
        app_label = "common"


class UserChoice(models.Model):
    """跟踪/自选
    """
    user_id = models.IntegerField(u"用户id",blank=True,null=True)
    user_name = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    user_avatar = models.TextField(u"头像", max_length=255, blank=True,null=True)
    player_id = models.IntegerField(u"选手id",blank=True,null=True)
    stock_id = models.IntegerField(u"股票id",blank=True,null=True)
    stock_name = models.CharField(u"股票名称", max_length=255,blank=True,null=True)

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

    class Meta:
        db_table = "user_choice"
        verbose_name = u"跟踪/自选"
        app_label = "common"


class FundInOut(models.Model):
    """资金出入
    """
    user_id = models.IntegerField(u"用户id",blank=True,null=True)
    fundin = models.FloatField(u"资金入",default=0.0)
    fundout = models.FloatField(u"资金出",default=0.0)
    stock_date = models.CharField(u"持股日期", max_length=255,blank=True,null=True)
    account_img = models.TextField(u"账号截图", max_length=255, blank=True, null=True)

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

    class Meta:
        db_table = "fund_inout"
        verbose_name = u"资金出入"
        app_label = "common"