from django.db import models


# Create your models here.

class AgentCustomerInfo(models.Model):
    id = models.AutoField(primary_key=True)
    user_id = models.CharField(db_index=True, max_length=32, verbose_name='用户id')
    company_name = models.CharField(max_length=32, verbose_name='公司名称')
    status = models.SmallIntegerField(default=1, verbose_name='0:无效,1:有效')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    created_by = models.CharField(blank=True, max_length=32, verbose_name='创建人')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')
    updated_by = models.CharField(blank=True, max_length=32, verbose_name='修改人')

    class Meta:
        db_table = 'a_customer_info'
        verbose_name = '代理客户信息'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'


class AgentCustomerCard(models.Model):
    id = models.AutoField(primary_key=True)
    ac_id = models.IntegerField(null=True, default=None, verbose_name='代理客户ID')
    name = models.CharField(max_length=32, verbose_name='姓名')
    card_no = models.CharField(max_length=32, verbose_name='卡号')
    status = models.SmallIntegerField(default=1, verbose_name='0:无效,1:有效')
    card_address = models.CharField(max_length=128, verbose_name='开户行')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    created_by = models.CharField(blank=True, max_length=32, verbose_name='创建人')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')
    updated_by = models.CharField(blank=True, max_length=32, verbose_name='修改人')

    class Meta:
        db_table = 'a_customer_card'
        verbose_name = '代理客户卡信息'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'


class AgentDevice(models.Model):
    id = models.AutoField(primary_key=True)
    ac_id = models.IntegerField(null=True, default=None, verbose_name='代理客户ID')
    serial_number = models.CharField(db_index=True, max_length=32, verbose_name='设备9位序列号')
    type = models.IntegerField(default=0, verbose_name='设备类型')
    status = models.SmallIntegerField(default=1, verbose_name='0:未激活,1:激活')
    at_time = models.IntegerField(default=0, verbose_name='激活时间')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    created_by = models.CharField(blank=True, max_length=32, verbose_name='创建人')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')
    updated_by = models.CharField(blank=True, max_length=32, verbose_name='修改人')

    class Meta:
        db_table = 'a_device'
        verbose_name = '代理设备'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'


class AgentCloudServicePackage(models.Model):
    id = models.AutoField(primary_key=True)
    service_name = models.CharField(max_length=64, verbose_name='代理服务名称')
    package_id = models.IntegerField(null=True, default=None, verbose_name='套餐id')
    type = models.IntegerField(default=1, verbose_name='1:云存,2:4G')
    profit_type = models.SmallIntegerField(default=1, verbose_name='1:固定值,2:百分比')
    cost = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name=u'成本')
    profit = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name=u'利润值')
    status = models.SmallIntegerField(default=1, verbose_name='0:无效,1:有效')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    created_by = models.CharField(blank=True, max_length=32, verbose_name='创建人')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')
    updated_by = models.CharField(blank=True, max_length=32, verbose_name='修改人')

    class Meta:
        db_table = 'a_cloud_service_package'
        verbose_name = '代理云服务套餐'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'


class AgentCustomerPackage(models.Model):
    id = models.AutoField(primary_key=True)
    ac_id = models.IntegerField(null=True, default=None, verbose_name='代理客户ID')
    cs_id = models.IntegerField(null=True, default=None, verbose_name='代理服务套餐id')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    created_by = models.CharField(blank=True, max_length=32, verbose_name='创建人')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')
    updated_by = models.CharField(blank=True, max_length=32, verbose_name='修改人')

    class Meta:
        db_table = 'a_customer_package'
        verbose_name = '代理客户关联云服务套餐'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'


class AgentAccount(models.Model):
    id = models.AutoField(primary_key=True)
    ac_id = models.IntegerField(null=True, default=None, verbose_name='代理客户ID')
    transaction_type = models.SmallIntegerField(default=1, verbose_name='交易类型 1：收入，2：支持')
    amount = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name='余额')
    frozen_amount = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name='冻结金额')
    status = models.SmallIntegerField(default=1, verbose_name='0:无效,1:有效')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')

    class Meta:
        db_table = 'a_account'
        verbose_name = '代理账户'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'


class AgentDeviceOrder(models.Model):
    id = models.AutoField(primary_key=True)
    ac_id = models.IntegerField(null=True, default=None, verbose_name='代理客户ID')
    serial_number = models.CharField(db_index=True, blank=True, default=None, max_length=32, verbose_name='设备9位序列号')
    order_id = models.CharField(blank=True, default=None, max_length=32, verbose_name='关联订单表')
    status = models.SmallIntegerField(default=1, verbose_name='0:结算失败,1:待结算,1:已结算,2:订单已退款')
    profit_amount = models.DecimalField(default=0, max_digits=10, decimal_places=2, verbose_name='营业额')
    is_del = models.BooleanField(blank=True, default=False, verbose_name=u'是否删除')
    created_time = models.IntegerField(default=0, verbose_name='创建时间')
    updated_time = models.IntegerField(default=0, verbose_name='修改时间')

    class Meta:
        db_table = 'a_device_order'
        verbose_name = '代理设备订单结算信息'
        verbose_name_plural = verbose_name
        app_label = 'AgentModel'