greater_wms/bound/migrations/0001_initial.py

# Generated by Django 4.1.2 on 2025-04-24 23:03

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='BoundBatchModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('bound_number', models.CharField(max_length=255, unique=True, verbose_name='入库批次号')),
                ('bound_month', models.CharField(max_length=255, verbose_name='月份')),
                ('bound_batch_order', models.IntegerField(default=0, verbose_name='批次顺序')),
                ('warehouse_code', models.CharField(max_length=255, verbose_name='仓库编码')),
                ('warehouse_name', models.CharField(max_length=255, verbose_name='仓库名称')),
                ('goods_code', models.CharField(max_length=255, verbose_name='商品编码')),
                ('goods_desc', models.CharField(max_length=255, verbose_name='商品描述')),
                ('goods_std', models.CharField(default='待填写', max_length=255, verbose_name='商品标准')),
                ('goods_unit', models.CharField(default='待填写', max_length=255, verbose_name='商品单位')),
                ('goods_qty', models.BigIntegerField(default=0, verbose_name='商品数量')),
                ('goods_in_qty', models.BigIntegerField(default=0, verbose_name='入库数量')),
                ('goods_out_qty', models.BigIntegerField(default=0, verbose_name='出库数量')),
                ('status', models.IntegerField(choices=[(0, '入库申请'), (1, '入库中'), (2, '部分入库'), (3, '在库'), (4, '出库中'), (5, '部分出库'), (6, '已出库')], default=0, verbose_name='批次状态')),
                ('container_number', models.IntegerField(default=0, verbose_name='托盘数目')),
                ('goods_weight', models.FloatField(default=0, verbose_name='商品单重')),
                ('goods_total_weight', models.FloatField(default=0, verbose_name='商品总重')),
                ('note', models.CharField(default='', max_length=255, verbose_name='备注')),
                ('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, null=True, verbose_name='Update Time')),
            ],
            options={
                'verbose_name': 'Bound Batch',
                'verbose_name_plural': 'Bound Batch',
                'db_table': 'boundbatch',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='BoundListModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('bound_month', models.CharField(max_length=255, verbose_name='月份')),
                ('bound_date', models.DateField(verbose_name='单据日期')),
                ('bound_code', models.CharField(max_length=255, unique=True, verbose_name='出入库编号')),
                ('bound_code_type', models.CharField(max_length=255, verbose_name='单据类型')),
                ('bound_bs_type', models.CharField(max_length=255, verbose_name='业务类型')),
                ('bound_type', models.CharField(max_length=255, verbose_name='出入库类型')),
                ('bound_desc', models.CharField(default='', max_length=255, verbose_name='出入库描述')),
                ('bound_department', models.CharField(max_length=255, verbose_name='部门')),
                ('base_type', models.IntegerField(default=0, verbose_name='基准类型')),
                ('bound_status', models.CharField(max_length=255, verbose_name='单据状态')),
                ('note', models.CharField(default='', max_length=255, verbose_name='备注')),
                ('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, null=True, verbose_name='Update Time')),
            ],
            options={
                'verbose_name': 'Bound List',
                'verbose_name_plural': 'Bound List',
                'db_table': 'boundlist',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='OutBatchModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('out_number', models.CharField(max_length=255, verbose_name='出库批次号')),
                ('out_date', models.DateTimeField(verbose_name='出库日期')),
                ('out_type', models.IntegerField(choices=[(0, '发货出库'), (4, '其他出库')], default=4, verbose_name='出库类型')),
                ('out_note', models.CharField(default='', max_length=255, verbose_name='出库备注')),
                ('warehouse_code', models.CharField(max_length=255, verbose_name='仓库编码')),
                ('warehouse_name', models.CharField(max_length=255, verbose_name='仓库名称')),
                ('goods_code', models.CharField(max_length=255, verbose_name='商品编码')),
                ('goods_desc', models.CharField(max_length=255, verbose_name='商品描述')),
                ('goods_std', models.CharField(default='待填写', max_length=255, verbose_name='商品标准')),
                ('goods_unit', models.CharField(default='待填写', max_length=255, verbose_name='商品单位')),
                ('goods_qty', models.BigIntegerField(default=0, verbose_name='商品数量')),
                ('goods_out_qty', models.BigIntegerField(default=0, verbose_name='出库数量')),
                ('status', models.IntegerField(choices=[(0, '申请'), (1, '在途'), (2, '已出库')], default=0, verbose_name='批次状态')),
                ('container_number', models.IntegerField(default=0, verbose_name='托盘数目')),
                ('goods_weight', models.FloatField(default=0, verbose_name='商品单重')),
                ('goods_total_weight', models.FloatField(default=0, verbose_name='商品总重')),
                ('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, null=True, verbose_name='Update Time')),
                ('batch_number', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='out_batch', to='bound.boundbatchmodel', verbose_name='批次号')),
            ],
            options={
                'verbose_name': 'Out Batch',
                'verbose_name_plural': 'Out Batch',
                'db_table': 'outbatch',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='OutBoundDetailModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('status', models.IntegerField(choices=[(0, '出库申请'), (1, '出库中'), (2, '已出库'), (3, '入库中'), (4, '已入库')], default=0, verbose_name='批次状态')),
                ('detail_code', models.CharField(max_length=255, unique=True, verbose_name='明细编号')),
                ('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, null=True, verbose_name='Update Time')),
                ('bound_batch', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='out_bound_batch_detail', to='bound.outbatchmodel', verbose_name='Bound Batch')),
                ('bound_batch_number', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='out_bound_batch_number_detail', to='bound.boundbatchmodel', verbose_name='Bound Batch Number')),
                ('bound_list', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='out_bound_detail', to='bound.boundlistmodel', verbose_name='Bound List')),
            ],
            options={
                'verbose_name': 'OutBound Detail',
                'verbose_name_plural': 'OutBound Detail',
                'db_table': 'Outbounddetail',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='BoundDetailModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('status', models.IntegerField(choices=[(0, '入库申请'), (1, '入库中'), (2, '在库'), (3, '出库中'), (4, '已出库')], default=0, verbose_name='批次状态')),
                ('detail_code', models.CharField(max_length=255, unique=True, verbose_name='明细编号')),
                ('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, null=True, verbose_name='Update Time')),
                ('bound_batch', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='bound_batch_detail', to='bound.boundbatchmodel', verbose_name='Bound Batch')),
                ('bound_list', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bound_detail', to='bound.boundlistmodel', verbose_name='Bound List')),
            ],
            options={
                'verbose_name': 'Bound Detail',
                'verbose_name_plural': 'Bound Detail',
                'db_table': 'bounddetail',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='BatchLogModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('log_type', models.IntegerField(choices=[(0, '入库'), (1, '出库'), (2, '移库'), (9, '其他')], default=9, verbose_name='日志类型')),
                ('log_date', models.DateTimeField(verbose_name='日志日期')),
                ('goods_code', models.CharField(max_length=255, verbose_name='商品编码')),
                ('goods_desc', models.CharField(max_length=255, verbose_name='商品描述')),
                ('goods_qty', models.BigIntegerField(default=0, verbose_name='商品数量')),
                ('log_content', models.CharField(max_length=255, verbose_name='日志内容')),
                ('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, null=True, verbose_name='Update Time')),
                ('batch_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='batch_log', to='bound.boundbatchmodel', verbose_name='批次ID')),
            ],
            options={
                'verbose_name': 'Batch Log',
                'verbose_name_plural': 'Batch Log',
                'db_table': 'batchlog',
            },
        ),
    ]