wnserver/obj/apps/erp/models.py

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