from django.db import models

class expense_master_table(models.Model):    
    name = models.CharField(max_length=50)
    description = models.CharField(max_length=150)
    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="expense_type"

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





class expense_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)
    expense_id = models.IntegerField(default=1,null=True)
    date = models.DateField(null=True)
    time = models.TimeField(null=True)
    name = models.CharField(max_length=50)
    description = models.CharField(max_length=150)
    amount = models.FloatField(null=True)
    cash = models.FloatField(null=True)
    bank = models.FloatField(null=True)
    bank_id = models.IntegerField(default=0,null=True)
    is_wholesale = 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)
    employee_id = models.IntegerField(null=True)
    class Meta:
        db_table="expenses"

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