from django.db import models

# Create your models here.

class branch_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    ho_branch_id        = models.IntegerField(default=0,null=True)
    bank_id             = models.IntegerField(default=0,null=True)
    established_date    = models.DateField(null=True)
    name                = models.CharField(max_length=50,null=True)
    prefix              = models.CharField(max_length=5,null=True)
    branch_code         = models.CharField(max_length=50,null=True)
    contact_person      = models.CharField(max_length=50,null=True)
    phone               = models.CharField(max_length=50,null=True)
    email               = models.CharField(max_length=50,null=True)
    password            = models.CharField(max_length=50,null=True)
    num_series          = models.CharField(max_length=5)
    address_line1       = models.CharField(max_length=50,null=True)
    address_line2       = models.CharField(max_length=50,null=True)
    city                = models.CharField(max_length=50,null=True)
    state               = models.CharField(max_length=50,null=True)
    pincode             = models.CharField(max_length=50,null=True)
    captial             = models.DecimalField(max_digits=10, decimal_places=2, default=0,null=True)
    bank_opening        = models.DecimalField(max_digits=10, decimal_places=2, default=0,null=True)
    receivable          = models.DecimalField(max_digits=10, decimal_places=2, default=0,null=True)
    payable             = models.DecimalField(max_digits=10, decimal_places=2, default=0,null=True)
    is_ho               = models.IntegerField(default=0,null=True)
    is_store            = models.IntegerField(default=0,null=True)
    is_franchise        = models.IntegerField(default=0,null=True)
    is_wholesale        = models.IntegerField(default=0,null=True)
    store_type          = models.CharField(max_length=50,null=True)
    credit_days         = models.CharField(max_length=50,null=True)  
    credit_limit        = models.CharField(max_length=50,null=True)  
    branch_incharge_id  = models.IntegerField(default=0,null=True)
    gstin               = models.CharField(max_length=50,null=True)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="branches"

    def save(self, *args, **kwargs):
        if self.name:
            self.name = self.name.strip().title()
        if self.contact_person:
            self.contact_person = self.contact_person.strip().title()
        super(branch_table, self).save(*args, **kwargs)




class branch_opening_table(models.Model): 
    company_id          = models.IntegerField(default=0,null=True)
    current_fy          = models.IntegerField(default=0,null=True)
    branch_id           = models.IntegerField(default=0,null=True)
    supply_branch_id    = models.IntegerField(default=0,null=True)
    credit              = models.FloatField(default=0,null=True)
    debit               = models.FloatField(default=0,null=True)
    is_migrated         = models.IntegerField(default=0,null=True)
    year                = models.IntegerField(default=0,null=True) 
    date                = models.DateField(null=True)
    time                = models.TimeField(null=True)
    is_active           = models.IntegerField(default=1,null=True)
    status              = models.IntegerField(default=1,null=True)
    created_on          = models.DateTimeField(null=True)
    updated_on          = models.DateTimeField(null=True)
    created_by          = models.IntegerField(null=True)
    updated_by          = models.IntegerField(null=True)
    class Meta:
        db_table="branch_ob"