greater_wms/reportcenter/files.py

from rest_framework_csv.renderers import CSVStreamingRenderer


def file_headers_list():
    return [
            'document_date', 
            'document_number',
            'document_type',
            'business_type', 
            'iout_type', 
            'department', 
            'warehouse_name', 
            'goods_code', 
            'goods_desc', 
            'goods_std', 
            'goods_batch', 
            'in_batch', 
            'out_batch', 
            'goods_in', 
            'goods_out', 
            'goods_notes', 
            'creator'
    ]



def cn_data_header_list():
    return dict([
        ('document_date', '单据日期'),
        ('document_number', '单据编号'),
        ('document_type', '单据类型'),
        ('business_type', '业务类型'),
        ('iout_type', '出入库类型'),
        ('department', '部门'),
        ('warehouse_code', '仓库编码'),
        ('warehouse_name', '仓库名称'),
        ('goods_code', '商品编码'),
        ('goods_desc', '商品描述'),
        ('goods_std', '商品标准'),
        ('goods_batch', '商品批次'),
        ('in_batch', '入库批次'),
        ('out_batch', '出库批次'),
        ('goods_in', '入库数量'),
        ('goods_out', '出库数量'),
        ('goods_notes', '备注'),
        ('creator', '创建人')
    ])

class FileFlowListRenderCN(CSVStreamingRenderer):
    header = file_headers_list()
    labels = cn_data_header_list()

"""

class MaterialChangeHistory(models.Model):

    material_stats = models.ForeignKey(
        MaterialStatistics,
        on_delete=models.CASCADE,
        related_name='history_records',
        verbose_name="关联物料"
    )
    
    # 与批次日志建立多对一关系
    batch_log = models.ForeignKey(batchLogModel,on_delete=models.CASCADE, related_name='material_history', verbose_name="关联批次日志",primary_key=False)

    goods_code = models.CharField(max_length=50, verbose_name='货品编码')
    goods_desc = models.CharField(max_length=100, verbose_name='货品描述')
    goods_std = models.CharField(max_length=50, verbose_name='货品规格', null=True, blank=True)
    goods_unit = models.CharField(max_length=50, verbose_name='货品单位', null=True, blank=True)
    # 时间戳记录（使用批次日志的时间）
    change_time = models.DateTimeField(
        verbose_name="变动时间"
    )
    
    # 库存变动情况
    in_quantity = models.DecimalField(
        max_digits=10, decimal_places=3,
        default=Decimal('0'),
        verbose_name="入库数量"
    )
    
    out_quantity = models.DecimalField(
        max_digits=10, decimal_places=3,
        default=Decimal('0'),
        verbose_name="出库数量"
    )
    
    # 变更类型（从批次日志获取）
    change_type = models.CharField(
        max_length=20,
        verbose_name="变动类型"
    )
    
    # 变更时的库存快照
    opening_quantity = models.DecimalField(
        max_digits=10, decimal_places=3,
        default=Decimal('0'),
        verbose_name="期初数量"
    )
    
    closing_quantity = models.DecimalField(
        max_digits=10, decimal_places=3,
        default=Decimal('0'),
        verbose_name="期末数量"
    
class batchLogModel(models.Model):

    LOG_TYPES = (
        ('create', '创建'),
        ('update', '更新'),
        ('delete', '删除'),
        ('out', '出库'),
        ('cancel_out', '取消出库'),
        ('status_change', '状态变更'),
    )
    bound = models.ForeignKey(BoundListModel, on_delete=models.CASCADE, related_name='logs', null=True, blank=True)
    batch = models.ForeignKey(BoundBatchModel, on_delete=models.CASCADE, related_name='logs')
    log_type = models.CharField(max_length=20, choices=LOG_TYPES, verbose_name='日志类型')
    goods_code = models.CharField(max_length=50, verbose_name='货品编码')
    goods_desc = models.CharField(max_length=100, verbose_name='货品描述')
    goods_std = models.CharField(max_length=50, verbose_name='货品规格', null=True, blank=True)
    goods_unit = models.CharField(max_length=50, verbose_name='货品单位', null=True, blank=True)
    goods_in_qty = models.DecimalField(max_digits=10, decimal_places=3, default=Decimal('0'),verbose_name='新入数量', null=True, blank=True)
    goods_out_qty = models.DecimalField(max_digits=10, decimal_places=3, default=Decimal('0'),verbose_name='新出数量', null=True, blank=True)
    detail_logs = models.ManyToManyField(
        ContainerDetailLogModel,
        related_name='batch_logs',
        verbose_name='关联托盘日志'
    )
    create_time = models.DateTimeField(auto_now_add=True, verbose_name='创建时间')   

    
class ContainerDetailLogModel(models.Model):
 
    LOG_TYPES = (
        ('create', '创建'),
        ('update', '更新'),
        ('delete', '删除'),
        ('out', '出库'),
        ('cancel_out', '取消出库'),
        ('status_change', '状态变更'),
    )
    
    # 关联的托盘明细
    container_detail = models.ForeignKey(
        ContainerDetailModel, 
        on_delete=models.CASCADE,
        related_name='logs'
    )
    
    # 日志类型
    log_type = models.CharField(
        max_length=20,
        choices=LOG_TYPES,
        verbose_name='日志类型'
    )
    
    # 原值
    old_goods_qty = models.DecimalField(max_digits=10, decimal_places=3, default=Decimal('0'),verbose_name='原数量', null=True, blank=True)
    old_goods_out_qty = models.DecimalField(max_digits=10, decimal_places=3, default=Decimal('0'),verbose_name='原出库数量', null=True, blank=True)
    old_status = models.IntegerField(
        choices=ContainerDetailModel.BATCH_STATUS,
        null=True,
        blank=True,
        verbose_name='原状态'
    )
    
    # 新值
    new_goods_qty = models.DecimalField(max_digits=10, decimal_places=3, default=Decimal('0'),verbose_name='新数量', null=True, blank=True)
    new_goods_out_qty = models.DecimalField(max_digits=10, decimal_places=3, default=Decimal('0'),verbose_name='新出库数量', null=True, blank=True)
    new_status = models.IntegerField(
        choices=ContainerDetailModel.BATCH_STATUS,
        null=True,
        blank=True,
        verbose_name='新状态'
    )
    
    # 元信息
    creater = models.CharField(max_length=50, verbose_name='操作人')
    create_time = models.DateTimeField(auto_now_add=True, verbose_name='操作时间')
    tobatchlog = models.BooleanField(default=False, verbose_name='是否转移到批次日志')

"""
def  MaterialChangeHistory_file_headers_list():
    return [
        'id',
        'batch_log',
        'goods_code',
        'goods_desc',
        'goods_std',
        'goods_unit',
        'change_time',
        'in_quantity',
        'out_quantity',
        'change_type',
        'opening_quantity',
        'closing_quantity'
    ]

def  MaterialChangeHistory_cn_data_header_list():
    return dict([
        ('id', '序号'),
        ('batch_log', '批次日志'),
        ('goods_code', '货品编码'),
        ('goods_desc', '货品描述'),
        ('goods_std', '货品规格'),
        ('goods_unit', '货品单位'),
        ('change_time', '变动时间'),
        ('in_quantity', '入库数量'),
        ('out_quantity', '出库数量'),
        ('change_type', '变动类型'),
        ('opening_quantity', '期初数量'),
        ('closing_quantity', '期末数量')
    ])
    

class MaterialChangeHistoryRenderCN(CSVStreamingRenderer):
    header = MaterialChangeHistory_file_headers_list()
    labels = MaterialChangeHistory_cn_data_header_list()
    
def batchLog_file_headers_list():
    return [
        'id',
        'log_type',
        'batch_code',
        'goods_code',
        'goods_desc',
        'goods_std',
        'goods_in_qty',
        'goods_out_qty',
        'goods_unit',
        'check_status',
        'create_time',
        'detail_logs',
    ]

def batchLog_cn_data_header_list():    
    return dict([
        ('id', '序号'),
        ('bound', '绑定'),
        ('batch', '批次'),
        ('log_type', '日志类型'),
        ('goods_code', '货品编码'),
        ('goods_desc', '货品描述'),
        ('goods_std', '货品规格'),
        ('goods_unit', '货品单位'),
        ('goods_in_qty', '新入数量'),
        ('goods_out_qty', '新出数量'),
        ('detail_logs', '托盘日志'),
        ('create_time', '创建时间'),
        ('check_status', '质检状态（0：未质检，1：已质检，2：质检不合格）')
    ])

class batchLogRenderCN(CSVStreamingRenderer):
    header = batchLog_file_headers_list()
    labels = batchLog_cn_data_header_list()
    
def ContainerDetailLog_file_headers_list():
    return [
        'id',
        'batch',
        'container_code',
        'goods_code',
        'goods_desc',
        'detail_goods_qty',
        'goods_qty',
        'goods_out_qty',
        'batch_goods_qty',
        'batch_goods_in_qty',
        'batch_goods_in_location_qty',
        'batch_goods_out_qty',
        'create_time',
        'log_type',
        'old_goods_qty',
        'old_goods_out_qty',
        'old_status',
        'new_goods_qty',
        'new_goods_out_qty',
        'new_status',
        'creater',
        'tobatchlog',
        'container_detail'
    ]

def ContainerDetailLog_cn_data_header_list():
    return dict([
        ('id', '序号'),
        ('batch', '批次'),
        ('container_code', '托盘编码'),
        ('goods_code', '货品编码'),
        ('goods_desc', '货品描述'),
        ('detail_goods_qty', '托盘货品数量'),
        ('goods_qty', '货品数量'),
        ('goods_out_qty', '出库数量'),
        ('batch_goods_qty', '批次货品数量'),
        ('batch_goods_in_qty', '批次入库数量'),
        ('batch_goods_in_location_qty', '批次入库库位数量'),
        ('batch_goods_out_qty', '批次出库数量'),
        ('create_time', '创建时间'),
        ('log_type', '日志类型'),
        ('old_goods_qty', '原数量'),
        ('old_goods_out_qty', '原出库数量'),
        ('old_status', '原状态'),
        ('new_goods_qty', '新数量'),
        ('new_goods_out_qty', '新出库数量'),
        ('new_status', '新状态'),
        ('creater', '操作人'),
        ('tobatchlog', '是否转移到批次日志'),
        ('container_detail', '托盘明细')
    ])

class ContainerDetailLogRenderCN(CSVStreamingRenderer):
    header = ContainerDetailLog_file_headers_list()
    labels = ContainerDetailLog_cn_data_header_list()