from django.db import models

class purchase_order_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    po_date             = models.DateField(null=True)
    po_no               = models.CharField(max_length=10)
    time                = models.TimeField(null=True)
    num_series          = models.CharField(max_length=10)
    current_fy          = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    total_quantity      = models.IntegerField(null=True)
    total_amount        = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    sub_total           = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    roundoff            = models.DecimalField(max_digits=10, decimal_places=2,null=True)
    po_status           = models.CharField(max_length=10)
    remarks             = 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)
    employee_id         = models.IntegerField(null=True)
    class Meta:
        db_table="tm_po"



class child_purchase_order_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)
    supplier_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)
    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_po"




class purchase_inward_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    pu_date             = models.DateField(null=True)
    pu_no               = models.CharField(max_length=10,null=True)
    supplier_id         = models.IntegerField(null=True)    
    supplier_no         = models.CharField(max_length=10,null=True)
    supplier_date       = models.DateField(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)
    total_quantity      = models.IntegerField(null=True)
    sub_total           = models.FloatField(null=True)
    total_discount      = models.FloatField(null=True)
    bill_discount       = models.FloatField(null=True)
    total_cgst          = models.FloatField(null=True)
    total_sgst          = models.FloatField(null=True)
    total_tds           = models.FloatField(null=True)
    total_amount        = models.FloatField(null=True)
    roundoff            = models.FloatField(null=True)
    grand_total         = 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)
    is_demo             = 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="tm_purchase_inward"




class child_purchase_inward_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    batch_no            = models.CharField(max_length=10,null=True)
    imei_no             = models.CharField(max_length=50,null=True)
    ean                 = models.CharField(max_length=50,null=True)
    po_id               = models.IntegerField(null=True)
    tm_pu_id            = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    item_id             = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True,default=0)
    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)
    hsn_code            = models.CharField(max_length=10,null=True)
    net_rate            = models.FloatField(null=True)
    quantity            = models.IntegerField(null=True)
    discount_percentage = models.IntegerField(null=True)
    discount_amount     = models.FloatField(null=True)
    tax_percent         = models.FloatField(null=True)
    tax_amount          = models.FloatField(null=True)
    tax_sgst            = models.FloatField(null=True)
    tax_cgst            = models.FloatField(null=True)
    tax_igst            = models.FloatField(null=True)
    base_rate           = models.FloatField(null=True)
    amount              = models.FloatField(null=True)
    db_price            = models.FloatField(null=True)
    mrp                 = models.FloatField(null=True)
    mop                 = models.FloatField(null=True)
    bop                 = models.FloatField(null=True)
    wsp                 = models.FloatField(null=True)
    fsp                 = models.FloatField(null=True)
    remarks             = models.CharField(max_length=150)
    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_purchase_inward"



class purchase_return_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    pr_date             = models.DateField(null=True)
    pr_no               = models.CharField(max_length=10)
    num_series          = models.CharField(max_length=10)
    current_fy          = models.IntegerField(null=True)
    time                = models.TimeField(null=True)
    branch_id           = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    total_quantity      = models.IntegerField(null=True)
    sub_total           = models.FloatField(null=True)
    total_cgst          = models.FloatField(null=True)
    total_sgst          = models.FloatField(null=True)
    total_tds           = models.FloatField(null=True)
    total_amount        = models.FloatField(null=True)
    round_off            = models.FloatField(null=True)
    grand_total         = models.FloatField(null=True)
    payment_type        = models.CharField(max_length=30)
    cash                = models.FloatField(null=True)
    bank                = models.FloatField(null=True)
    balance             = models.FloatField(null=True)
    pr_status           = models.CharField(max_length=10)
    remarks             = 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)
    employee_id         = models.IntegerField(null=True)
    class Meta:
        db_table="tm_purchase_return"


class child_purchase_return_table(models.Model):    
    company_id          = models.IntegerField(null=True)
    current_fy          = models.IntegerField(null=True)
    inward_id           = models.IntegerField(null=True)
    imei_no             = models.CharField(max_length=50,null=True)
    ean                 = models.CharField(max_length=50,null=True)
    tm_return_id        = models.IntegerField(null=True)
    supplier_id         = models.IntegerField(null=True)
    branch_id           = models.IntegerField(null=True)
    subcategory_id      = models.IntegerField(null=True,default=0)
    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)
    hsn_code            = models.CharField(max_length=10,null=True)
    quantity            = models.IntegerField(null=True)
    rate                = models.FloatField(null=True)
    tax_percent         = models.FloatField(null=True)
    tax_amount          = models.FloatField(null=True)
    tax_sgst            = models.FloatField(null=True)
    tax_cgst            = models.FloatField(null=True)
    tax_igst            = models.FloatField(null=True)
    amount              = models.FloatField(null=True)
    db_price            = models.FloatField(null=True)
    mrp                 = models.FloatField(null=True)
    mop                 = models.FloatField(null=True)
    bop                 = models.FloatField(null=True)
    wsp                 = models.FloatField(null=True)
    fsp                 = models.FloatField(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_purchase_return"



# class child_purchase_return_table(models.Model):    
#     company_id          = models.IntegerField(null=True)
#     current_fy          = models.IntegerField(null=True)
#     pu_id               = models.IntegerField(null=True)
#     tm_pr_id            = models.IntegerField(null=True)
#     branch_id           = models.IntegerField(null=True)
#     supply_branch_id    = models.IntegerField(null=True)
#     supplier_id         = models.IntegerField(null=True)
#     subcategory_id      = models.IntegerField(null=True,default=0)
#     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.FloatField(null=True)
#     mrp                 = models.FloatField(null=True)
#     amount              = models.FloatField(null=True)
#     remarks             = models.CharField(max_length=150)
#     batch_no            = models.CharField(max_length=50)
#     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_purchase_return"