from django.db import models

# Create your models here.

class supplier_table(models.Model): 
    company_id = models.IntegerField(default=0,null=True)
    branch_id = models.IntegerField(default=0,null=True)
    brand_id = models.CharField(max_length=50, blank=True, null=True)
    name = models.CharField(max_length=50)
    email = models.CharField(max_length=50)
    address_line1 = models.CharField(max_length=150)
    address_line2 = models.CharField(max_length=150)
    city = models.CharField(max_length=50)
    state = models.CharField(max_length=50)
    pincode = models.CharField(max_length=50)
    statecode = models.CharField(max_length=50)
    cin_number = models.CharField(max_length=100)
    gstin = models.CharField(max_length=100)
    credit_days = models.IntegerField(default=0,null=True)
    phone = models.CharField(max_length=50)
    mobile = models.CharField(max_length=50)
    contact_person_name = models.CharField(max_length=50)
    contact_person_phone = models.CharField(max_length=50)
    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)
    remarks = models.CharField(max_length=50)
    is_global = models.IntegerField(default=0,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="supplier"

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



class supplier_opening_table(models.Model): 
    company_id = models.IntegerField(default=0,null=True)
    branch_id = models.IntegerField(default=0,null=True)
    current_fy = models.IntegerField(default=0,null=True)
    supplier_id = models.IntegerField(default=0,null=True)
    year = models.IntegerField(default=0,null=True)
    date = models.DateField(default=0,null=True)
    time = models.TimeField(default=0,null=True)
    credit = models.FloatField(default=0,null=True)    
    debit = models.FloatField(default=0,null=True)    
    remarks = models.CharField(max_length=50,null=True)    
    ob_no = models.CharField(max_length=50,null=True)    
    is_migrated = models.IntegerField(default=1,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="supplier_ob"