from django.db import models

# Create your models here.


class stock_log_table(models.Model):    
    company_id      = models.IntegerField(null=True)
    branch_id       = models.IntegerField(null=True)
    current_fy      = models.IntegerField(null=True)
    uploaded_by     = models.IntegerField(null=True)
    uploaded_on     = models.DateTimeField(null=True)
    excel_file      = models.FileField(upload_to='stock_excel/', 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)    
    item_type       = models.CharField(max_length=30)
    class Meta:
        db_table="stock_log"



class opening_stock_table(models.Model):    
    company_id      = models.IntegerField(null=True)
    date            = models.DateField(null=True)
    time            = models.TimeField(null=True)
    branch_id       = models.IntegerField(null=True)
    stock_no        = models.CharField(max_length=30)
    ean             = models.CharField(max_length=30)
    hsn_code        = models.CharField(max_length=30)
    current_fy      = models.IntegerField(null=True)
    subcategory_id  = models.IntegerField(null=True)
    quantity        = models.IntegerField(null=True)
    brand_id        = models.IntegerField(null=True)
    model_id        = models.IntegerField(null=True)
    variant_id      = models.IntegerField(null=True)
    color_id        = models.IntegerField(null=True)
    imei_no         = models.CharField(max_length=30)
    employee_id     = models.IntegerField(null=True)
    db_price        = models.FloatField(default=0,null=True)
    mrp             = models.FloatField(default=0,null=True)
    fsp             = models.FloatField(default=0,null=True)
    wsp             = models.FloatField(default=0,null=True)
    mop             = models.FloatField(default=0,null=True)
    bop             = models.FloatField(default=0,null=True)
    stock_log_id    = models.IntegerField(null=True)    
    status          = models.IntegerField(default=1,null=True)
    is_active       = models.IntegerField(default=1,null=True)
    is_demo         = models.IntegerField(default=0,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="opening_stock"