from django.db import models

# Create your models here.


class Company(models.Model):
    name = models.CharField(max_length=50)
    color = models.CharField(max_length=50)
    url = models.CharField(max_length=256)
    connect = models.CharField(max_length=256)
    balance = models.CharField(max_length=50)
    slogan = models.CharField(max_length=256)

    def __str__(self):
        return self.name

    class Meta:
        db_table = 'company'


class Malumotlar(models.Model):
    info = models.TextField()
    calling = models.TextField()
    companyId = models.ForeignKey(Company, models.CASCADE, 'malumotlar')

    class Meta:
        db_table = 'malumotlar'


class Foydali(models.Model):
    title = models.TextField()
    calling = models.TextField()

    class Meta:
        db_table = 'foydali'


class Resource(models.Model):
    title = models.TextField()
    companyId = models.ForeignKey(Company, models.CASCADE, 'recourse')
    type = models.IntegerField()
    dataType = models.IntegerField()

    class Meta:
        db_table = 'resource'


class Shartlar(models.Model):
    infol = models.TextField()
    companyId = models.ForeignKey(Company, models.CASCADE, 'shartlar')
    shartlar = models.TextField()

    class Meta:
        db_table = 'shartlar'


class Universal(models.Model):
    title = models.TextField()
    amount = models.TextField()
    type = models.IntegerField()
    companyId = models.ForeignKey(Company, models.CASCADE, 'universal')
    dataTypeId = models.IntegerField()
    connect = models.TextField(null=True, blank=True, default="")
    allocation = models.TextField(null=True, blank=True, default="")
    bookMarks = models.IntegerField()



    class Meta:
        db_table = 'universal'


class GetData(models.Model):
    position = models.IntegerField()

    class Meta:
        db_table = 'getdata'
        
    def __str__(self):
        return str(self.position)


class RequestCounts(models.Model):
    company = models.PositiveIntegerField(default=0)
    resource = models.PositiveIntegerField(default=0)
    universal = models.PositiveIntegerField(default=0)
    malumotlar = models.PositiveIntegerField(default=0)
    foydali = models.PositiveIntegerField(default=0)
    getdata = models.PositiveIntegerField(default=0)

    date = models.DateField(unique=True)

    class Meta:
        db_table = 'request_counts'
        ordering = ('-date',)

    def __str__(self):
        return str(self.date)


# class Malumot(models.Model):
#     info = models.TextField()
#     company = models.ForeignKey(Company, models.CASCADE, related_name='malumot')
#     sortby = models.IntegerField()
#     connect = models.CharField(max_length=256)
#
#
# class Aloqa(models.Model):
#     title = models.CharField(max_length=50)
#     url = models.CharField(max_length=256)
#     icon_url = models.CharField(max_length=256)