greater_wms/erp/migrations/0006_outboundbill_outmaterialdetail.py

# Generated by Django 4.1.2 on 2025-05-04 18:40

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


class Migration(migrations.Migration):

    dependencies = [
        ('erp', '0005_alter_inboundbill_options'),
    ]

    operations = [
        migrations.CreateModel(
            name='OutboundBill',
            fields=[
                ('billId', models.IntegerField(primary_key=True, serialize=False, verbose_name='原始单据ID')),
                ('number', models.CharField(max_length=50, unique=True, verbose_name='单据编号')),
                ('type', models.IntegerField(choices=[(1, '订单'), (2, '其他')], verbose_name='绑定类型')),
                ('date', models.CharField(max_length=10, verbose_name='出库时间')),
                ('department', models.CharField(max_length=10, null=True, verbose_name='部门')),
                ('warehouse', models.CharField(default='W01', max_length=10, verbose_name='仓库')),
                ('creater', models.CharField(max_length=50, null=True, verbose_name='创建人')),
                ('note', models.TextField(blank=True, null=True, verbose_name='备注说明')),
                ('totalCount', models.IntegerField(verbose_name='总条目数')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('bound_status', models.IntegerField(default=0, verbose_name='状态')),
                ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
            ],
            options={
                'verbose_name': '出库单',
                'verbose_name_plural': '出库单',
                'ordering': ['bound_status', '-create_time', '-update_time'],
            },
        ),
        migrations.CreateModel(
            name='OutMaterialDetail',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('entryIds', models.IntegerField(verbose_name='分录ID')),
                ('production_batch', models.CharField(max_length=50, verbose_name='生产批次')),
                ('goods_code', models.CharField(max_length=20, verbose_name='商品编码')),
                ('goods_name', models.CharField(max_length=100, verbose_name='商品名称')),
                ('goods_weight', models.DecimalField(decimal_places=2, default=1, max_digits=10, verbose_name='单件重量')),
                ('goods_out_qty', models.IntegerField(verbose_name='计划数量')),
                ('goods_total_weight', models.DecimalField(decimal_places=2, max_digits=10, null=True, verbose_name='总重量')),
                ('goods_unit', models.CharField(max_length=20, verbose_name='计量单位')),
                ('note', models.TextField(blank=True, 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='是否删除')),
                ('Material_entryIds', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='entry_Ids', to='erp.materialdetail', verbose_name='所属入库单详细')),
                ('bound_billId', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bill_id', to='erp.outboundbill', verbose_name='所属出库单')),
            ],
            options={
                'verbose_name': '出库物料明细',
                'verbose_name_plural': '出库物料明细',
                'ordering': ['-update_time', '-create_time'],
            },
        ),
    ]