from django.db import models


class tm_material_request_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    po_date             = models.DateField(null=True)
    po_no               = models.CharField(max_length=10, null=True)
    time                = models.TimeField(null=True)
    num_series          = models.CharField(max_length=10, null=True)
    current_fy          = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    total_quantity      = models.IntegerField(null=True)
    total_amount        = models.FloatField(null=True)
    sub_total           = models.FloatField(null=True)
    roundoff            = models.FloatField(null=True)
    po_status           = models.CharField(max_length=10, null=True)
    remarks             = models.CharField(max_length=150,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="tm_material_po"



class tx_material_request_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    tm_po_id            = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    ean                 = models.CharField(max_length=50,null=True)
    hsn_code            = models.CharField(max_length=50,null=True)
    subcategory_id      = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True,default=0)
    model_id            = models.IntegerField(null=True,default=0)
    variant_id          = models.CharField(max_length=10,null=True)
    color_id            = models.IntegerField(null=True,default=0)
    quantity            = models.IntegerField(null=True)
    rate                = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    mrp                 = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    fsp                 = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    wsp                 = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    mop                 = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    bop                 = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    db_price            = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    amount              = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    remarks             = models.CharField(max_length=150, 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="tx_material_po"







class material_inward_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    transfer_date       = models.DateField(null=True)
    transfer_no         = models.CharField(max_length=10,null=True)
    time                = models.TimeField(null=True)
    num_series          = models.CharField(max_length=10)
    current_fy          = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    total_quantity      = models.IntegerField(null=True)
    sub_total           = models.FloatField(null=True)
    total_amount        = models.FloatField(null=True)
    roundoff            = models.FloatField(null=True)
    payment_type        = models.CharField(max_length=10)
    cash                = models.FloatField(null=True)
    bank                = models.FloatField(null=True)
    balance             = models.FloatField(null=True)
    pu_status           = models.CharField(max_length=10)
    remarks             = models.CharField(max_length=150,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="tm_material_in"



class child_material_inward_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    imei_no             = models.CharField(max_length=50,null=True)
    ean                 = models.CharField(max_length=50,null=True)
    hsn_code            = models.CharField(max_length=50,null=True)
    material_outward_id = models.IntegerField(null=True)
    tm_material_id      = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True,default=0)
    model_id            = models.IntegerField(null=True,default=0)
    variant_id          = models.CharField(max_length=10,null=True)
    color_id            = models.IntegerField(null=True,default=0)
    price_list_id       = models.IntegerField(null=True,default=0)
    rate                = models.FloatField(null=True)
    quantity            = models.IntegerField(null=True)
    amount              = models.FloatField(null=True)  
    db_price            = models.FloatField(null=True)
    mrp                 = models.FloatField(null=True)
    fsp                 = models.FloatField(null=True)
    wsp                 = models.FloatField(null=True)
    mop                 = models.FloatField(null=True)
    bop                 = models.FloatField(null=True)
    remarks             = models.CharField(max_length=150,null=True)
    is_active           = models.IntegerField(default=1,null=True)
    is_demo             = models.IntegerField(default=0,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_material_in"






class material_outward_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    transfer_date       = models.DateField(null=True)
    transfer_no         = models.CharField(max_length=10,null=True)
    time                = models.TimeField(null=True)
    num_series          = models.CharField(max_length=10)
    current_fy          = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    total_quantity      = models.IntegerField(null=True)
    sub_total           = models.FloatField(null=True)
    total_amount        = models.FloatField(null=True)
    roundoff            = models.FloatField(null=True)
    payment_type        = models.CharField(max_length=10)
    cash                = models.FloatField(null=True)
    bank                = models.FloatField(null=True)
    balance             = models.FloatField(null=True)
    outward_status      = models.CharField(max_length=10)
    rejected_by         = models.IntegerField(null=True, default=0)
    rejected_on         = models.DateTimeField(null=True)
    rejected_remarks    = models.CharField(max_length=150,null=True)
    remarks             = models.CharField(max_length=150,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="tm_material_out"




class child_material_outward_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    imei_no             = models.CharField(max_length=50,null=True)
    ean                 = models.CharField(max_length=50,null=True)
    hsn_code            = models.CharField(max_length=50,null=True)
    material_po_id      = models.IntegerField(null=True)
    tm_material_id      = models.IntegerField(null=True)
    supply_branch_id    = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True)
    brand_id            = models.IntegerField(null=True,default=0)
    model_id            = models.IntegerField(null=True,default=0)
    variant_id          = models.CharField(max_length=10,null=True)
    color_id            = models.IntegerField(null=True,default=0)
    price_list_id       = models.IntegerField(null=True,default=0)
    rate                = models.FloatField(null=True)
    quantity            = models.IntegerField(null=True)
    amount              = models.FloatField(null=True)
    db_price            = models.FloatField(null=True)
    fsp                 = models.FloatField(null=True)
    wsp                 = models.FloatField(null=True)
    mop                 = models.FloatField(null=True)
    bop                 = models.FloatField(null=True)
    mrp                 = models.FloatField(null=True)
    remarks             = models.CharField(max_length=150,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="tx_material_out"