# Create your models here.
class Plan(models.Model):

    #make random char
    def randomString (length=6):
        letters = string.ascii_letters
        return ''.join(random.choice(letters) for i in range(length))

    id_plan = models.CharField(max_length = 6, default = randomString(), primary_key = True)
    username = models.ForeignKey('doa_register.Auth',on_delete = models.CASCADE,related_name='plan')
    title_plan = models.CharField(max_length = 50)
    sector = models.CharField(max_length = 50)
    subsector = models.CharField(max_length = 50)
    start_date = models.DateTimeField()
    finish_date = models.DateTimeField()
    reminder = models.CharField(max_length = 5)
    reminder_date = models.DateTimeField()
    reminder_time = models.DateTimeField()
    repeat = models.CharField(max_length = 5)

    def __str__(self):
        return self.id_plan

class Business(models.Model):

    #make random char
    def randomString (length=6):
        letters = string.ascii_letters
        return ''.join(random.choice(letters) for i in range(length))

    id_business = models.CharField(max_length = 6, default = randomString(), primary_key = True)
    id_plan = models.ForeignKey('Plan', on_delete = models.CASCADE, related_name='business')
    structure = models.CharField(max_length = 30)
    key_personal = models.CharField(max_length = 30)
    key_resources = models.CharField(max_length = 30)

    def __str__(self):
        return self.id_business

class Market(models.Model):

    #make random char
    def randomString (length=6):
        letters = string.ascii_letters
        return ''.join(random.choice(letters) for i in range(length))

    id_market = models.CharField(max_length = 6, default = randomString(), primary_key = True)
    id_plan = models.ForeignKey('Plan', on_delete = models.CASCADE, related_name='market')
    product = models.CharField(max_length = 30)
    target_customer = models.CharField(max_length = 50)
    geografic_market = models.CharField(max_length = 50)
    competitive_adventage = models.CharField(max_length = 150)
    key_competitive = models.CharField(max_length = 25)

    def __str__(self):
        return self.id_market

class Strategy(models.Model):

    #make random char
    def randomString (length=6):
        letters = string.ascii_letters
        return ''.join(random.choice(letters) for i in range(length))

    id_strategy = models.CharField(max_length = 6, default = randomString(), primary_key = True)
    id_plan = models.ForeignKey('Plan', on_delete = models.CASCADE, related_name = 'strategy')
    year_objective = models.CharField(max_length = 10)
    strategy_opportunities = models.CharField(max_length = 25)
    step_strategy = models.CharField(max_length = 25)

    def __str__(self):
        return self.id_strategy

class Finance(models.Model):

    #make random char
    def randomString (length=6):
        letters = string.ascii_letters
        return ''.join(random.choice(letters) for i in range(length))

    id_finance = models.CharField(max_length = 6, default = randomString(), primary_key = True)
    id_plan = models.ForeignKey('Plan', on_delete = models.CASCADE, related_name= 'finance')
    currency = models.CharField(max_length = 5)
    start_year_plan = models.CharField(max_length = 5)
    cash_invested = models.DecimalField(max_digits=12, decimal_places=2)
    sales_year = models.DecimalField(max_digits=12, decimal_places=2)
    sales_growth = models.DecimalField(max_digits=12, decimal_places=2)
    cash_of_sales = models.DecimalField(max_digits=12, decimal_places=2)
    expanses_first_year = models.DecimalField(max_digits=12, decimal_places=2)
    expanses_growth_year = models.DecimalField(max_digits=12, decimal_places=2)
    customer_day_credit = models.CharField(max_length = 3)
    supplier_day_credit = models.CharField(max_length = 3)