from django.db import models

# Create your models here.

class item_scheme_table(models.Model): 
    current_fy = models.IntegerField(null=True, blank=True)
    scheme_type = models.CharField(max_length=30, null=True, blank=True)
    scheme_no = models.CharField(max_length=30, null=True, blank=True)
    date_time = models.DateTimeField(null=True, blank=True)
    from_date = models.DateField(null=True, blank=True)
    to_date = models.DateField(null=True, blank=True)
    branch_id = models.IntegerField(default=0,null=True)
    subcategory_id = models.IntegerField(default=0,null=True)
    supplier_id = models.IntegerField(default=0,null=True)
    brand_id = models.IntegerField(default=0,null=True)
    model_id = models.IntegerField(default=0,null=True)
    variant_id = models.IntegerField(default=0,null=True)
    name = models.CharField(max_length=150, null=True, blank=True)
    mop_drop = models.FloatField(null=True, blank=True)    
    mop_drop_percent = models.FloatField(null=True, blank=True)    
    mop_after_drop = models.FloatField(null=True, blank=True)    
    bop_drop = models.FloatField(null=True, blank=True)
    description = models.CharField(max_length=150, null=True, blank=True)
    is_claim = models.IntegerField(default=0,null=True)
    claim_status = models.CharField(max_length=50, null=True, blank=True, default='pending')
    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="scheme"




class price_history_table(models.Model): 
    current_fy = models.IntegerField(null=True, blank=True)
    branch_id = models.IntegerField(default=0,null=True)
    supplier_id = models.IntegerField(default=0,null=True)
    price_no = models.CharField(max_length=50, null=True, blank=True)
    date = models.DateField(null=True, blank=True)
    time = models.TimeField(null=True, blank=True)
    subcategory_id = models.IntegerField(default=0,null=True)
    brand_id = models.IntegerField(default=0,null=True)
    model_id = models.IntegerField(default=0,null=True)
    variant_id = models.IntegerField(default=0,null=True)
    from_date = models.DateField(null=True, blank=True)
    fsp = models.FloatField(default=0,null=True, blank=True)    
    wsp = models.FloatField(default=0,null=True, blank=True)
    mop = models.FloatField(null=True, blank=True)    
    bop = models.FloatField(null=True, blank=True)
    credit_note = models.FloatField(null=True, blank=True)
    debit_note = models.FloatField(null=True, blank=True)
    description = models.CharField(max_length=150, null=True, blank=True)
    is_active = models.IntegerField(default=1,null=True)
    employee_id = models.IntegerField(default=0,null=True)
    is_claim = models.IntegerField(default=0,null=True)
    claimed_on = models.DateTimeField(null=True, blank=True)
    claim_amount        = models.DecimalField(max_digits=10, decimal_places=2, default=0.00)
    claim_status = models.CharField(max_length=50, null=True, blank=True, default='pending')
    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="price_history"




class tx_price_history_table(models.Model): 
    branch_id = models.IntegerField(default=0,null=True)
    supplier_id = models.IntegerField(default=0,null=True)
    supply_branch_id = models.IntegerField(default=0,null=True)
    tm_price_id = models.IntegerField(default=0,null=True)
    store_type = models.CharField(max_length=50, null=True, blank=True)
    current_fy = models.IntegerField(null=True, blank=True)
    imei_no = models.CharField(max_length=50, null=True, blank=True)   
    fsp = models.FloatField(default=0,null=True, blank=True)
    fsp_discount = models.FloatField(default=0,null=True, blank=True)
    fsp_after_discount = models.FloatField(default=0,null=True, blank=True)    
    wsp = models.FloatField(default=0,null=True, blank=True)
    wsp_discount = models.FloatField(default=0,null=True, blank=True)
    wsp_after_discount = models.FloatField(default=0,null=True, blank=True)
    mop = models.FloatField(default=0,null=True, blank=True)      
    mop_discount = models.FloatField(default=0,null=True, blank=True)
    mop_after_discount = models.FloatField(default=0,null=True, blank=True)    
    bop = models.FloatField(default=0,null=True, blank=True)
    bop_discount = models.FloatField(default=0,null=True, blank=True)
    bop_after_discount = models.FloatField(default=0,null=True, blank=True)
    credit_fsp = models.FloatField(default=0,null=True, blank=True)
    credit_wsp = models.FloatField(default=0,null=True, blank=True)
    is_applicable = models.IntegerField(default=1,null=True)
    description = models.CharField(max_length=150, null=True, blank=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="tx_price_history"