from django.db import models # Create your models here. # 视图序列化器测试 # 广告组 # class View_tb_content_category(models.Model): # """广告内容类别""" # bom_no = models.CharField(max_length=100, verbose_name='上级BOM代号') # name = models.CharField(max_length=200, verbose_name='物料名称') # prd_no = models.CharField(max_length=100, verbose_name='物料编码') # class Meta: # managed = False # db_table = 'TF_BOM' # verbose_name = '视图广告组' # verbose_name_plural = verbose_name # 月度主排程计划 class View_ydzpcjh(models.Model): id = models.CharField(primary_key=True,max_length=50, verbose_name='id') need_dd = models.CharField(max_length=100, verbose_name='订单交货期') cus_no = models.CharField(max_length=50, verbose_name='客户代码') so_no = models.CharField(max_length=50, verbose_name='计划受订') mo_no = models.CharField(max_length=50, verbose_name='制令单号') knd = models.CharField(max_length=50, verbose_name='成品大类') scx = models.CharField(max_length=50, verbose_name='scx') mrp_no = models.CharField(max_length=50, verbose_name='货品代码') name = models.CharField(max_length=50, verbose_name='货品名称') qty = models.FloatField( verbose_name='制令数量') gzwggs = models.FloatField( verbose_name='灌装未完工数量') pmc_dd = models.CharField(max_length=100, verbose_name='计划完成日期') ymppt_dd = models.CharField(max_length=50, verbose_name='研磨品齐套时间') rqdh_dd = models.CharField(max_length=50, verbose_name='容器到货时间') bcdh_dd = models.CharField(max_length=50, verbose_name='包材到货日期') prdt1_qty = models.FloatField( verbose_name='当前库存') iebz = models.FloatField( verbose_name='IE标准') xqry = models.FloatField( verbose_name='需求人员') id_no = models.CharField(max_length=200, verbose_name='BOM代号') jhscrq = models.CharField(max_length=200, verbose_name='计划上线生产日期') class Meta: managed = False db_table = 'view_ydzpcjh' verbose_name = '月度主排产计划' verbose_name_plural = verbose_name # 月度主排程计划，递归查询bom阶梯 # class View_cst_aa(models.Model): # a_bom = models.CharField(max_length=50, verbose_name='所属母件') # bom_no = models.CharField(max_length=50, verbose_name='当前母件') # dd = models.FloatField(verbose_name='前置天数') # # class Meta: # managed = False # db_table = 'cst_aa' # verbose_name = '递归查询bom阶梯' # verbose_name_plural = verbose_name # pc月度生产计划 class View_pcydscjh(models.Model): id = models.CharField(primary_key=True, max_length=50, verbose_name='id') cus_snm = models.CharField(max_length=100, verbose_name='客户简称') need_dd = models.CharField(max_length=100, verbose_name='订单交货期') so_no = models.CharField(max_length=100, verbose_name='计划受订') mrp_no = models.CharField(max_length=100, verbose_name='成品编码') mrp_name = models.CharField(max_length=100, verbose_name='成品名称') mo_no = models.CharField(max_length=100, verbose_name='制令单号') pmc_dd = models.CharField(max_length=100, verbose_name='计划排产日期') mo_dep_name = models.CharField(max_length=100, verbose_name='生产部门') zx = models.CharField(max_length=100, verbose_name='IE组线') mo_no_no = models.CharField(max_length=100, verbose_name='制令单代号') mo_no_name = models.CharField(max_length=100, verbose_name='制令单名称') qty = models.CharField(max_length=100, verbose_name='订单数量') qty_fin = models.CharField(max_length=100, verbose_name='已缴库量') w_qty = models.CharField(max_length=100, verbose_name='未完工量') dcl = models.CharField(max_length=100, verbose_name='达成率') jhwcrq = models.CharField(max_length=100, verbose_name='计划完成日期') cn = models.CharField(max_length=100, verbose_name='产能') ddjd = models.CharField(max_length=100, verbose_name='订单完成进度') ymp = models.CharField(max_length=100, verbose_name='研磨品') rq = models.CharField(max_length=100, verbose_name='容器') bq = models.CharField(max_length=100, verbose_name='标签') bc = models.CharField(max_length=100, verbose_name='包材') class Meta: managed = False db_table = 'view_pcydscjh' verbose_name = 'PC月度生产计划' verbose_name_plural = verbose_name # 研磨品需求计划 class view_tf_pos(models.Model): id = models.CharField(primary_key=True, max_length=50, verbose_name='id') so_no = models.CharField(max_length=100, verbose_name='订单号') pmc_dd = models.CharField(max_length=100, verbose_name='pmc回复交期') bom_no = models.CharField(max_length=100, verbose_name='bom编码') est_itm = models.CharField(max_length=100, verbose_name='项次') mo_dd = models.CharField(max_length=100, verbose_name='制令日期') dl = models.CharField(max_length=100, verbose_name='成品大类') gzwwgs = models.CharField(max_length=100, verbose_name='灌装未完工数量') gzdep = models.CharField(max_length=100, verbose_name='灌装生产线') ggsxrq = models.CharField(max_length=100, verbose_name='灌装上线日') qty = models.CharField(max_length=100, verbose_name='现存量') os_wfl = models.CharField(max_length=100, verbose_name='订单需求量（未领量）') jcq = models.CharField(max_length=100, verbose_name='净需求') jkwshl = models.CharField(max_length=100, verbose_name='缴库未审量') llwsl = models.CharField(max_length=100, verbose_name='领料未审量') mrp_name = models.CharField(max_length=100, verbose_name='研磨品名称') dep = models.CharField(max_length=100, verbose_name='研磨品生产车间') wfl = models.CharField(max_length=100, verbose_name='未发量') zzl = models.CharField(max_length=100, verbose_name='在制量') mrp_no = models.CharField(max_length=100, verbose_name='研磨品代号') mo_no1 = models.CharField(max_length=100, verbose_name='单号1') mo_no2 = models.CharField(max_length=100, verbose_name='单号2') mo_no3 = models.CharField(max_length=100, verbose_name='单号3') mo_no4 = models.CharField(max_length=100, verbose_name='单号4') mo_no5 = models.CharField(max_length=100, verbose_name='单号5') mo_no6 = models.CharField(max_length=100, verbose_name='单号6') mo_no7 = models.CharField(max_length=100, verbose_name='单号7') qty1 = models.CharField(max_length=100, verbose_name='数量1') qty2 = models.CharField(max_length=100, verbose_name='数量2') qty3 = models.CharField(max_length=100, verbose_name='数量3') qty4 = models.CharField(max_length=100, verbose_name='数量4') qty5 = models.CharField(max_length=100, verbose_name='数量5') qty6 = models.CharField(max_length=100, verbose_name='数量6') qty7 = models.CharField(max_length=100, verbose_name='数量7') class Meta: managed = False db_table = 'view_tf_pos' verbose_name = '研磨品需求计划' verbose_name_plural = verbose_name