greater_wms/container/migrations/0001_initial.py

# Generated by Django 4.1.2 on 2025-04-16 22:09

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('bound', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='ContainerDetailModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('month', models.IntegerField(verbose_name='月份')),
                ('goods_code', models.CharField(max_length=50, verbose_name='货品编码')),
                ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
                ('goods_qty', models.IntegerField(verbose_name='数量')),
                ('goods_weight', models.DecimalField(decimal_places=3, max_digits=10, verbose_name='重量')),
                ('status', models.IntegerField(choices=[(0, '空盘'), (1, '组盘'), (2, '已出库')], default=0, verbose_name='状态')),
                ('creater', models.CharField(max_length=50, verbose_name='创建人')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
                ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.boundbatchmodel', verbose_name='批次')),
            ],
            options={
                'verbose_name': 'ContainerDetail',
                'verbose_name_plural': 'ContainerDetail',
                'db_table': 'container_detail',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ContainerListModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('container_code', models.IntegerField(verbose_name='托盘编号')),
                ('current_location', models.CharField(default='N/A', max_length=50, verbose_name='当前库位')),
                ('target_location', models.CharField(default='N/A', max_length=50, verbose_name='目标库位')),
                ('status', models.IntegerField(choices=[(0, '空置'), (1, '入库中'), (2, '在库'), (3, '出库中'), (4, '已出库')], default=0, verbose_name='托盘状态')),
                ('last_operation', models.DateTimeField(auto_now=True, verbose_name='最后操作时间')),
            ],
            options={
                'verbose_name': 'ContainerList',
                'verbose_name_plural': 'ContainerList',
                'db_table': 'container_list',
                'ordering': ['-container_code'],
            },
        ),
        migrations.CreateModel(
            name='ContainerWCSModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('taskid', models.CharField(max_length=50, verbose_name='任务ID')),
                ('month', models.IntegerField(verbose_name='月份')),
                ('tasktype', models.CharField(max_length=50, verbose_name='任务类型')),
                ('tasknumber', models.IntegerField(verbose_name='任务号')),
                ('container', models.CharField(max_length=50, verbose_name='托盘号')),
                ('current_location', models.CharField(max_length=50, verbose_name='当前库位')),
                ('target_location', models.CharField(max_length=50, verbose_name='目标库位')),
                ('message', models.TextField(verbose_name='消息')),
                ('status', models.IntegerField(verbose_name='状态')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
            ],
            options={
                'verbose_name': 'ContainerWCS',
                'verbose_name_plural': 'ContainerWCS',
                'db_table': 'container_wcs',
                'ordering': ['-create_time'],
            },
        ),
        migrations.CreateModel(
            name='TaskModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('batch_detail', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.bounddetailmodel', verbose_name='批次详情')),
                ('container_detail', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='container.containerdetailmodel', verbose_name='托盘明细')),
                ('task_wcs', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='container.containerwcsmodel')),
            ],
            options={
                'verbose_name': 'Task',
                'verbose_name_plural': 'Task',
                'db_table': 'task',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ContainerOperationModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('month', models.IntegerField(verbose_name='月份')),
                ('operation_type', models.CharField(choices=[('container', '组盘'), ('inbound', '入库'), ('outbound', '出库'), ('adjust', '调整')], max_length=20, verbose_name='操作类型')),
                ('goods_code', models.CharField(max_length=50, verbose_name='货品编码')),
                ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
                ('goods_qty', models.IntegerField(verbose_name='数量')),
                ('goods_weight', models.DecimalField(decimal_places=3, max_digits=10, verbose_name='重量')),
                ('operator', models.CharField(max_length=50, verbose_name='操作人')),
                ('timestamp', models.DateTimeField(auto_now_add=True, verbose_name='操作时间')),
                ('from_location', models.CharField(max_length=50, null=True, verbose_name='原库位')),
                ('to_location', models.CharField(max_length=50, null=True, verbose_name='目标库位')),
                ('memo', models.TextField(null=True, verbose_name='备注')),
                ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
                ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.boundbatchmodel', verbose_name='批次')),
                ('container', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='operations', to='container.containerlistmodel')),
            ],
            options={
                'verbose_name': 'ContainerOperation',
                'verbose_name_plural': 'ContainerOperation',
                'db_table': 'container_operation',
                'ordering': ['-timestamp'],
            },
        ),
        migrations.AddField(
            model_name='containerdetailmodel',
            name='container',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='details', to='container.containerlistmodel'),
        ),
    ]