from django.db import models

class ListModel(models.Model):
    warehouse_code = models.CharField(max_length=255, verbose_name="Warehouse Code")
    warehouse_name = models.CharField(max_length=255, verbose_name="Warehouse Name")
    warehouse_city = models.CharField(max_length=255, verbose_name="Warehouse City")
    warehouse_address = models.CharField(max_length=255, verbose_name="Warehouse Address")
    warehouse_contact = models.CharField(max_length=255, verbose_name="Warehouse Contact")
    warehouse_manager = models.CharField(max_length=255, verbose_name="Warehouse Manager")
    creater = models.CharField(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 = 'warehouse'
        verbose_name = 'Warehouse'
        verbose_name_plural = "Warehouse"
        ordering = ['-id']

class DepartmentListModel(models.Model):
    department_code = models.CharField(max_length=255, verbose_name="Department Code")
    department_name = models.CharField(max_length=255, verbose_name="Department Name")
    department_contact = models.CharField(max_length=255, verbose_name="Department Contact")
    department_manager = models.CharField(max_length=255, verbose_name="Department Manager")
    creater = models.CharField(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 = 'department'
        verbose_name = 'Department'
        verbose_name_plural = "Department"  
        ordering = ['-id']

class BoundTypeListModel(models.Model):
    bound_type_code = models.CharField(max_length=255, verbose_name="Bound Type Code")
    bound_type_name = models.CharField(max_length=255, verbose_name="Bound Type Name")

    creater = models.CharField(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 = 'bound_type'
        verbose_name = 'Bound Type'
        verbose_name_plural = "Bound Type"  
        ordering = ['-id']

class BoundBSListModel(models.Model):
    bound_bs_code = models.CharField(max_length=255, verbose_name="Bound Business Code")
    bound_bs_name = models.CharField(max_length=255, verbose_name="Bound  Business Name")

    creater = models.CharField(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 = 'bound_business'
        verbose_name = 'Bound Business'
        verbose_name_plural = "Bound Business"  
        ordering = ['-id']

class BoundCodeTypeListModel(models.Model):
    bound_code_type_code = models.CharField(max_length=255, verbose_name="Bound Code Type Code")
    bound_code_type_name = models.CharField(max_length=255, verbose_name="Bound Code Type Name")

    creater = models.CharField(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 = 'bound_code_type'
        verbose_name = 'Bound Code Type'
        verbose_name_plural = "Bound Code Type"  
        ordering = ['-id']

class BoundStatusListModel(models.Model):
    bound_status_code = models.IntegerField(default=0, verbose_name="Bound Status Code")
    bound_status_name = models.CharField(max_length=255, verbose_name="Bound Status Name")

    creater = models.CharField(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 = 'bound_status'
        verbose_name = 'Bound Status'
        verbose_name_plural = "Bound Status"  
        ordering = ['-id']

class ProductListModel(models.Model):
    product_code = models.CharField(max_length=255, verbose_name="Product Code"  )
    product_name = models.CharField(max_length=255, verbose_name="Product Name")
    product_std = models.CharField(max_length=255, verbose_name="Product Description", blank=True, null=True)
    product_unit = models.CharField(default='KG', max_length=255, verbose_name="Product Unit", blank=True, null=True)
    product_package = models.CharField(default='箱', max_length=255, verbose_name="Product Package", blank=True, null=True)
    
    creater = models.CharField(default='first', max_length=255, verbose_name="Who Created")
    is_delete = models.BooleanField(default=False, verbose_name='Delete Label')


    class Meta: 
        db_table = 'product'
        verbose_name = 'Product'
        verbose_name_plural = "Product"  
        ordering = ['-id']


# 基本设置参数()
class baseset(models.Model):
    set_name = models.CharField(max_length=255, verbose_name="Set Name")
    set_value = models.CharField(max_length=9999, verbose_name="Set Value")
    set_desc = models.CharField(max_length=255, verbose_name="Set Description", blank=True, null=True)
    is_delete = models.BooleanField(default=False, verbose_name='Delete Label')
    
    class Meta:
        db_table = 'baseset'
        verbose_name = 'Base Set'
        verbose_name_plural = "Base Set"  
        ordering = ['-id']