from django.db import models
import django.utils.timezone as timezone


# Create your models here.
class PlatSimInfo(models.Model):
    OPERATORS_CHOICE = [
        (1, "合宙"),
        (2, "SIMBoss"),  # 企朋和SIMBOSS是同一单位
        (3, "未知")
    ]
    TYPE_CHOICE = [
        (1, "机器录入"),
        (2, "人工录入")
    ]
    PLATFORM_CHOICE = [
        (1, "四情平台"),
        (2, "大数据平台")
    ]
    simId = models.CharField(u'物联网卡号', max_length=20)
    sim_operators = models.IntegerField(u"物联网卡供应商", choices=OPERATORS_CHOICE, default=1)
    input_type = models.IntegerField(u"录入类型", choices=TYPE_CHOICE, default=1)
    deviceId = models.CharField(u'设备号', max_length=32)
    device_type = models.CharField(u'设备类型', max_length=50, default="")
    platform = models.IntegerField(u'设备所在平台', choices=PLATFORM_CHOICE, default=1)
    account_status = models.CharField(u'卡状态', max_length=20, default="")
    active_date = models.CharField(u'激活日期', max_length=20, default="")
    data_plan = models.CharField(u'套餐大小', max_length=20, default="")
    data_usage = models.CharField(u'当月用量', max_length=20, default="")
    data_balance = models.CharField(u'剩余流量', max_length=20, default="")
    expiry_date = models.CharField(u'到期时间', max_length=20, default="")
    upl_time = models.DateTimeField(u'更新时间', default=timezone.now)

    class Meta:
        db_table = "plat_sim_info"