yifengapi/src/common/models.py

# coding=utf-8
'''
'''
import utils.constant as uconst
from django.db import models


# ---------------- 用户部分 ------------------
class Department(models.Model):
    name = models.CharField(u"组织名称",max_length=256,blank=True)
    pid = models.CharField(u"父节点ID",max_length=16,blank=True)
    permissions = models.TextField(u"权限",blank=True,null=True)
    status = models.SmallIntegerField(u"状态(0删除)",default=1)

    cid = models.IntegerField(u"创建人ID",blank=True)
    cperson = models.CharField(u"创建人",max_length=255,blank=True)
    ctime = models.DateTimeField(u"创建时间",auto_now_add=True)

    class Meta:
        db_table = "department"
        verbose_name = u"部门"
        app_label = "common"


class UserInfo(models.Model):
    # 基础属性
    name = models.CharField(u"名字", max_length=255, blank=True)
    password = models.CharField(u"密码", max_length=255, blank=True)
    realname = models.CharField(u"真实名称", max_length=255, blank=True, null=True)
    email = models.CharField(u"邮箱", max_length=255, blank=True)
    phone = models.CharField(u"手机号", max_length=64, blank=True)
    remark = models.TextField(u"备注", blank=True,null=True)
    avatar = models.CharField(u"手机号", max_length=64, blank=True,null=True)
    vcard = models.TextField(u"电子名片", blank=True,null=True)
    utype = models.SmallIntegerField(u"用户类型", blank=True,null=True,default=1)
    status = models.SmallIntegerField(u"状态(0删除)",default=1)

    last_login = models.CharField(u"上次登录时间", max_length=128, blank=True,null=True,db_column='last_login_time')
    last_login_ip = models.CharField(u"上次登录IP", max_length=128, blank=True,null=True)
    is_active = models.CharField(u"是否激活可用", max_length=4, default="1")
    # 功能权限及数据权限
    department = models.ForeignKey("Department", verbose_name=u"所属部门", blank=True, null=True)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u"创建人", max_length=255, blank=True,null=True)
    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.email)

    def is_authenticated(self):
        return True

    def is_anonymous(self):
        return False


class Permission(models.Model):
    """权限
    """
    name = models.CharField(u"权限名称", max_length=50, blank=True)
    codename = models.CharField(u"权限代码", max_length=255, blank=True)
    remark = models.CharField(u"备注", max_length=255, blank=True, null=True, default="")
    order = models.IntegerField(u"排序字段", default=1, blank=True, null=True)
    pid = models.CharField(u"父节点ID",max_length=16,blank=True,null=True)

    class Meta:
        db_table = "permission"
        app_label = "common"


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 EmailNotice(models.Model):
    """邮件通知
    """
    receiver = models.TextField(u"接收人集合", blank=True)
    receiver_name = models.CharField(u'接收人id', max_length=256, blank=True)
    subject = models.CharField(u'邮件主题', blank=True, max_length=128)
    content = models.TextField(u"邮件内容", max_length=32, blank=True)
    is_suc = models.BooleanField(u"是否成功", default=False)
    error_msg = models.TextField(u'报错信息', blank=True,null=True)
    send_type = models.CharField(u"发送方式（手动、自动）", max_length=12, blank=True)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "email_notice"
        verbose_name = u"邮件发送记录"

class MsgNotice(models.Model):
    """短信通知
    """
    receiver = models.TextField(u"接收人集合", blank=True)
    receiver_name = models.CharField(u'接收人id', max_length=256, blank=True)
    template = models.CharField(u'模板id', blank=True, max_length=128)
    content = models.TextField(u"邮件内容", max_length=32, blank=True)
    is_suc = models.BooleanField(u"是否成功", default=False)
    error_msg = models.TextField(u'报错信息', blank=True,null=True)
    send_type = models.CharField(u"发送方式（手动、自动）", max_length=12, blank=True)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "msg_notice"
        verbose_name = u"短信通知"


class SysNotice(models.Model):
    """系统通知
    """
    title = models.CharField(u'标题', max_length=256, blank=True)
    content = models.TextField(u"内容", max_length=32, blank=True)
    viewer = models.TextField(u"查看人", max_length=32, blank=True,null=True)
    to = models.TextField(u"接收人", max_length=32, blank=True,null=True)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "sys_notice"
        verbose_name = u"系统通知"


class EnterPrise(models.Model):
    """企业信息
    """
    mark = models.IntegerField(u'评分',null=True,blank=True)
    entno = models.CharField(u'企业编号', max_length=50)
    name = models.CharField(u'企业名称', max_length=256)
    regno = models.CharField(u'注册号', max_length=50)
    licenceorg = models.CharField(u"发证机关",max_length=255)
    enttype = models.CharField(u"企业类型",max_length=50)
    address = models.CharField(u"实际办公地址",max_length=255)
    legalperson = models.CharField(u"法人",max_length=50)
    entcontact = models.CharField(u"公司电话,法人电话",max_length=50)
    industry = models.CharField(u"所属行业",max_length=50)
    taxtype = models.CharField(u"税务类型",max_length=50)
    subindustry = models.CharField(u"细分行业",max_length=50,blank=True,null=True)
    profit = models.IntegerField(u"利润",blank=True,null=True)
    turnover = models.IntegerField(u"营业额",blank=True,null=True)
    entscale = models.CharField(u"公司规模",max_length=50,blank=True,null=True)
    regdate = models.CharField(u"注册时间",max_length=50,blank=True,null=True)
    busscope = models.TextField(u"公司经营范围",blank=True,null=True)
    principals = models.TextField(u"主要负责人",blank=True,null=True)
    finacial = models.CharField(u"财务情况",max_length=50,blank=True,null=True)
    funding = models.CharField(u"融资情况",max_length=50,blank=True,null=True)
    legalstate = models.CharField(u"法务情况",max_length=50,blank=True,null=True)
    remark = models.TextField(u"备注",blank=True,null=True)
    status = models.SmallIntegerField(u"状态(0删除)",default=1)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "enterprise"
        verbose_name = u"企业信息"


class Product(models.Model):
    """产品
    """
    name = models.CharField(u'产品名称',max_length=128)
    ptype = models.CharField(u'产品类型',max_length=128)
    intro = models.TextField(u'产品简介',max_length=128)
    content = models.TextField(u'产品详情')
    status = models.SmallIntegerField(u"状态(0删除)",default=1)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "product"
        verbose_name = u"产品信息"


class Transaction(models.Model):
    """交易
    """
    enterprise = models.ForeignKey("EnterPrise",verbose_name="企业",related_name="enttrans")
    product = models.ForeignKey("Product",verbose_name="成交产品",related_name="enttrans_pro")
    price = models.FloatField(u"价格")
    service_period = models.CharField(u"服务周期",max_length=100)
    remark = models.TextField(u"备注",blank=True,null=True)
    status = models.SmallIntegerField(u"状态(0删除)",default=1)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "transaction"
        verbose_name = u"企业交易"


class BankCard(models.Model):
    """
    """
    user_id = models.IntegerField(u"用户id")
    name = models.CharField(u'名称',max_length=128)
    cardno = models.CharField(u'银行账户',max_length=128)
    status = models.SmallIntegerField(u"状态(0删除)",default=1)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "bankcard"
        verbose_name = u"银行卡"


class CashRecord(models.Model):
    """
    """
    bankcard_id = models.IntegerField(u'银行卡')
    cardname = models.CharField(u'名称',max_length=128,blank=True,null=True)
    cardno = models.CharField(u'银行账户',max_length=128,blank=True,null=True)
    cashtype = models.CharField(u'提现方式',max_length=128)
    cashamount = models.FloatField(u'提现金额')
    cash_status = models.SmallIntegerField(u"提现状态(0待处理)",default=0)

    cid = models.IntegerField(u"创建人ID",blank=True,null=True)
    cperson = models.CharField(u'邮件主题', blank=True, max_length=128,null=True)
    ctime = models.DateTimeField(u"创建时间(发送时间)", auto_now_add=True)

    class Meta:
        db_table = "cashrecord"
        verbose_name = u"提现记录"