from django.db import models



class AsnListModel(models.Model):
    code = models.CharField(max_length=255, verbose_name="Code")
    asn_code = models.CharField(max_length=255, verbose_name="ASN Code")
    asn_status = models.CharField(max_length=255, verbose_name="ASN Status")
    asn_type = models.CharField(max_length=255, verbose_name="ASN Type")

    goods_code = models.CharField(max_length=255, verbose_name="Goods Code")
    goods_desc = models.CharField(max_length=255, verbose_name="Goods Description")
    goods_qty = models.BigIntegerField(default=0, verbose_name="Goods QTY")
    goods_weight = models.FloatField(default=0, verbose_name="Goods Weight")
    
    creater = models.CharField(default='uesr', max_length=255, verbose_name="Who Created")
    openid = models.CharField(max_length=255, verbose_name="Openid")
    is_delete = models.BooleanField(default=False, verbose_name='Delete Label')
    create_time = models.DateTimeField(auto_now_add=True, verbose_name="Create Time")
    update_time = models.DateTimeField(auto_now=True, blank=True, null=True, verbose_name="Update Time")

    class Meta:
        db_table = 'asnlist'
        verbose_name = 'ASN List'
        verbose_name_plural = "ASN List"
        ordering = ['-id']



class AsnDetailModel(models.Model):
    asn_code = models.CharField(max_length=255, verbose_name="ASN Code")
    asn_status = models.CharField(max_length=255, verbose_name="ASN Status")
    asn_type = models.CharField(max_length=255, verbose_name="ASN Type")

    goods_code = models.CharField(max_length=255, verbose_name="Goods Code")
    goods_desc = models.CharField(max_length=255, verbose_name="Goods Description")
    goods_qty = models.BigIntegerField(default=0, verbose_name="Goods QTY")
    goods_weight = models.FloatField(default=0, verbose_name="Goods Weight")

    warehouse_code = models.CharField(default='empty_code' ,max_length=255, verbose_name="Warehouse Code")
    warehouse_name = models.CharField(default='empty_name', max_length=255, verbose_name="Warehouse Name")
    shelf_name=models.CharField(default='empty_name', max_length=255, verbose_name="Shelf Name")
    container_code = models.CharField(default='empty_code', max_length=255, verbose_name="Container Code")
    
    creater = models.CharField(default='uesr', max_length=255, verbose_name="Who Created")

    openid = models.CharField(max_length=255, verbose_name="Openid")
    is_delete = models.BooleanField(default=False, verbose_name='Delete Label')
    create_time = models.DateTimeField(auto_now_add=True, verbose_name="Create Time")
    update_time = models.DateTimeField(auto_now=True, blank=True, null=True, verbose_name="Update Time")

    class Meta:
        db_table = 'asndetail'
        verbose_name = 'ASN Detail'
        verbose_name_plural = "ASN Detail"
        ordering = ['-id']