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.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"角色0/游客,1/普通选手,2/免费参赛选手",default=0)
    player_type = models.SmallIntegerField(u"选手类型,0/游客,1/普通选手,2/种子选手,3/开户选手",default=0)
    comment_status = models.SmallIntegerField(u"1/正常,0/拉黑",default=1)
    unionid = models.CharField(u"微信unionid", max_length=64, blank=True,null=True)
    app_openid = models.CharField(u"微信openid", max_length=64, blank=True,null=True)
    intro = models.TextField(u"用户简介", blank=True, null=True)
    forbid_status = models.SmallIntegerField(u"1/forbid,0/unforbid",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)
    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)
    opmode_group = models.CharField(u"操作模式分组", max_length=255,blank=True,null=True)
    opmode_group_name = models.CharField(u"操作模式分组名称", max_length=255,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)
    opmode_group = models.IntegerField(u"操作模式分组", blank=True,null=True)
    opmode_group_name = models.CharField(u"操作模式分组名称", max_length=255,blank=True,null=True)
    today_stock_total = models.FloatField(u"今日持仓总额",blank=True,null=True)
    today_cangwei = models.FloatField(u"今日仓位",blank=True,null=True)

    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)

    @classmethod
    def get_db_model(cls,match_id):
        table_name = "player_record_%s" % match_id
        if table_name in cls._db_model_dict:
            return cls._db_model_dict[table_name]
        class Meta:
            db_table = table_name

        attrs = {
            "__module__":cls.__module__,     
            "Meta":Meta
        }
        db_model = type(str(table_name),(cls,),attrs)
        cls._db_model_dict[table_name] = db_model
        return db_model
    _db_model_dict = {}
    
    class Meta:
        abstract = True

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)
    post_start_time = models.CharField(u"交作业开始时间", max_length=255, blank=True,null=True)
    awards_content = 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.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)
    stock_date = 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.name)


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)
    isbanner = models.SmallIntegerField(u"是否banner",default=0)
    category = models.CharField(u"类型", max_length=255, blank=True,null=True)         
    ishot = models.SmallIntegerField(u"是否精选",default=0)
                                                                                   
    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):
    """用户关注表
    """
    player_id = models.IntegerField(u"选手id", blank=True,null=True)
    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):
    """选手持股情况
    """
    user_id = models.IntegerField(u"用户id", 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_date = models.CharField(u"持股日期", max_length=255,blank=True,null=True)
    stock_name = models.CharField(u"股票名称", max_length=255,blank=True,null=True)
    fund = models.FloatField(u"持股金额",blank=True,null=True)
    match_group = models.IntegerField(u"选手分组id", blank=True,null=True)
    opmode_group = models.IntegerField(u"选手操作模式分组id", 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)

    @classmethod
    def get_db_model(cls,month):
        table_name = "user_stock_%s" % month
        if table_name in cls._db_model_dict:
            return cls._db_model_dict[table_name]
        class Meta:
            db_table = table_name

        attrs = {
            "__module__":cls.__module__,     
            "Meta":Meta
        }
        db_model = type(str(table_name),(cls,),attrs)
        cls._db_model_dict[table_name] = db_model
        return db_model
    _db_model_dict = {}
    
    class Meta:
        abstract = True


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)
    opmode_group = models.CharField(u"操作模式分组", max_length=255,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_code = models.CharField(u"用编号", max_length=255, blank=True,null=True)
    phone = 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)
    width = models.IntegerField(u"宽度",blank=True,null=True)
    height = models.IntegerField(u"高度",blank=True,null=True)

    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_code = models.CharField(u"用编号", max_length=255, blank=True,null=True)
    phone = 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)
    width = models.IntegerField(u"宽度",blank=True,null=True)
    height = models.IntegerField(u"高度",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)
    match_id = models.IntegerField(u"比赛id", blank=True,null=True)

    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"


class UserMatch(models.Model):
    """用户参赛信息
    """
    user_id = models.IntegerField(u"用户id", blank=True,null=True)
    signup_name = models.CharField(u"参赛名", max_length=255,blank=True,null=True)
    match_id = models.IntegerField(u"比赛id", blank=True,null=True)
    match_group = models.CharField(u"比赛分组", max_length=255,blank=True,null=True)
    match_status = models.SmallIntegerField(u"比赛状态,退赛/暂停/比赛中-1/0/1",default=0)
    fund = models.FloatField(u"初始资金",default=0.0)

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

    class Meta:
        db_table = "user_match"
        verbose_name = u"用户参赛信息(选手信息)"
        app_label = "common"

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


#class PlayerRecordBase(models.Model):
#    """参数选手数据
#    """
#    user_id = models.IntegerField(u"用户id", blank=True,null=True)
#    player_id = models.IntegerField(u"用户id", blank=True,null=True)
#
#    @classmethod
#    def get_db_model(cls,match_id):
#        table_name = "player_record_%s" % match_id
#        if table_name in cls._db_model_dict:
#            return cls._db_model_dict[table_name]
#        class Meta:
#            db_table = table_name
#
#        attrs = {
#            "__module__":cls.__module__,     
#            "Meta":Meta
#        }
#        db_model = type(table_name,(cls,),attrs)
#        cls._db_model_dict[table_name] = db_model
#        return db_model
#    _db_model_dict = {}
    
#    class Meta:
#        abstract = True


class BaikeCategory(models.Model):                                                                                                                                                                                                                                                
    """百科分类                                                                    
    """                                                                            
    name = models.CharField(u"政府名称", max_length=255, blank=True,null=True)  
    parent_id = models.IntegerField(u"父级id",blank=True,null=True)                
    parent_name = models.CharField(u"父级名称",blank=True,null=True,max_length=255)
                                                                                   
    ctime = models.DateTimeField(u"创建时间",auto_now_add=True)                    
                                                                                   
    class Meta:                                                                    
        db_table = "baike_category"                                                     
        verbose_name = u"百科分类"                                                 
        app_label = "common"     


class BaikeDetail(models.Model):                                                                                                                                                                                                                                                
    """百科词条详情                                                                    
    """                                                                            
    category_id = models.IntegerField(u"父级id",blank=True,null=True)                
    category_name = models.CharField(u"父级名称", max_length=255, blank=True,null=True)  
    name = models.CharField(u"词条名称", max_length=255, blank=True,null=True)  
    intro = models.CharField(u"词条简介", max_length=255, blank=True,null=True)  
    content = models.TextField(u"词条详情", max_length=255, blank=True,null=True)  
    cid = models.IntegerField(u"创建人id",blank=True,null=True)                
    cname = models.CharField(u"创建人名称", max_length=255, blank=True,null=True)  
    editor = models.CharField(u"editor", max_length=255, blank=True,null=True)  
    status = models.SmallIntegerField(u"0/待发布,1/已发布",default=0)
    img = models.TextField(u"咨询图片", max_length=255, blank=True,null=True)
    istop = models.SmallIntegerField(u"1/置顶",default=0)
                                                                                   
    ctime = models.DateTimeField(u"创建时间",auto_now_add=True)                    
                                                                                   
    class Meta:                                                                    
        db_table = "baike_detail"                                                     
        verbose_name = u"百科词条详情"                                                 
        app_label = "common"     


class APPVersion(models.Model):                                                                                                                                                                                                                                                
    """APP版本管理                                                                    
    """                                                                            
    name = models.CharField(u"词条名称", max_length=255, blank=True,null=True)  
    version = models.CharField(u"词条名称", max_length=255, blank=True,null=True)  
    android_url = models.CharField(u"安装包地址", max_length=255, blank=True,null=True)  
    ios_url = models.CharField(u"安装包地址", max_length=255, blank=True,null=True)  
    force = models.SmallIntegerField(u"0/待发布,1/已发布",default=0)
    android_version = models.CharField(u"安卓版本", max_length=255, blank=True,null=True)  
                                                                                   
    ctime = models.DateTimeField(u"创建时间",auto_now_add=True)                    
                                                                                   
    class Meta:                                                                    
        db_table = "app_version"                                                     
        verbose_name = u"app版本管理"                                                 
        app_label = "common"     


class StockComments(models.Model):
    """股票评论
    """
    stock_id = models.IntegerField(u"股票id",blank=True,null=True)
    stock_name = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    stock_code = models.CharField(u"用户名", max_length=255, blank=True,null=True)
    img = models.TextField(u"咨询图片", max_length=255, blank=True,null=True)
    content = models.TextField(u"咨询内容", max_length=255, blank=True,null=True)

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

    class Meta:
        db_table = "stock_comments"
        verbose_name = u"股票点评"
        app_label = "common"


class UserArticleRelation(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)
    article_ids = models.TextField(u"文章id", max_length=255, blank=True,null=True)

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

    class Meta:
        db_table = "user_aritcle_relation"
        verbose_name = u"用户文章关联表"
        app_label = "common"


class UserBlacks(models.Model):
    """用户黑名单
    """
    user = models.ForeignKey(UserInfo,related_name="user")
    black_user = models.ForeignKey(UserInfo,related_name="black_user")

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

    class Meta:
        db_table = "user_blacks"
        verbose_name = u"用户黑名单"
        app_label = "common"


class OpModelGroup(models.Model):
    """操作模式分组
    """
    name = models.CharField(u"名称", max_length=255, blank=True,null=True)
    is_active = models.SmallIntegerField(u"是否显示",default=1)
    order = models.IntegerField(u"排序字段",default=1)

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

    class Meta:
        db_table = "opmodel_group"
        verbose_name = u"操作模式分组"
        app_label = "common"


class UserMarkScore(models.Model):
    """用户打分
    """
    user_id = models.IntegerField(u"股票id",blank=True,null=True)
    stock_date = models.CharField(u"持股日期", max_length=255,blank=True,null=True)
    score = models.IntegerField(u"分数",blank=True,null=True)

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

    class Meta:
        db_table = "user_markscore"
        verbose_name = u"用户评分"
        app_label = "common"