coi/app/core/models.py

from django.db import models

# Create your models here.
from django.contrib.auth.models import User  # Assuming you're using Django's built-in User model

class Report(models.Model):
    name = models.CharField(max_length=255)  # Name of the report
    created_by = models.ForeignKey(
        User,
        on_delete=models.CASCADE,
        related_name="reports"
    )  # Reference to the user who created the report
    created_at = models.DateTimeField(auto_now_add=True)  # Automatically set when created
    updated_at = models.DateTimeField(auto_now=True)  # Automatically updated when modified
    file = models.FileField(upload_to='reports/files/', null=True, blank=True)  # File field
    
    def __str__(self):
        return self.name


class MgMasterView(models.Model):
    # ProcessControl.dbo.[Q-PRO-DATA]
    PRO0 = models.CharField(max_length=255, null=True)
    PRO1 = models.CharField(max_length=255, null=True)
    PRO1C = models.CharField(max_length=255, null=True)
    PRO2 = models.CharField(max_length=255, null=True)
    PRO5 = models.CharField(max_length=255, null=True)
    PRO8 = models.CharField(max_length=255, null=True)
    PRO9 = models.CharField(max_length=255, null=True)
    PRO10 = models.CharField(max_length=255, null=True)
    PRO11 = models.CharField(max_length=255, null=True)
    PRO12 = models.CharField(max_length=255, null=True)
    PRO13 = models.CharField(max_length=255, null=True)
    PRO14 = models.CharField(max_length=255, null=True)
    PRO15 = models.CharField(max_length=255, null=True)
    PRO16 = models.CharField(max_length=255, null=True)
    PRO17 = models.CharField(max_length=255, null=True)
    PRO18 = models.CharField(max_length=255, null=True)
    PRO21 = models.CharField(max_length=255, null=True)
    PRO25 = models.CharField(max_length=255, null=True)
    PRO27 = models.CharField(max_length=255, null=True)
    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    PRO4 = models.CharField(max_length=255, null=True)
    
    # dbo.[MG-MAS-1]
    MC11 = models.CharField(max_length=255, null=True)
    MC12 = models.CharField(max_length=255, null=True)
    MC14 = models.CharField(max_length=255, null=True)
    MC15 = models.CharField(max_length=255, null=True)
    MC16 = models.CharField(max_length=255, null=True)
    MC19 = models.CharField(max_length=255, null=True)
    MC20 = models.CharField(max_length=255, null=True)
    MC21 = models.CharField(max_length=255, null=True)
    MC22 = models.CharField(max_length=255, null=True)
    MC23 = models.CharField(max_length=255, null=True)
    MC24 = models.CharField(max_length=255, null=True)
    
    # dbo.[MG-MAS-2]
    MP45 = models.CharField(max_length=255, null=True)
    MP49 = models.CharField(max_length=255, null=True)
    
    # dbo.[MG-MAS-3]
    MI13 = models.CharField(max_length=255, null=True)
    TC = models.CharField(max_length=255, null=True)
    MI14 = models.CharField(max_length=255, null=True)
    MI15 = models.CharField(max_length=255, null=True)
    MI16 = models.CharField(max_length=255, null=True)
    MI17 = models.CharField(max_length=255, null=True)
    MI18 = models.CharField(max_length=255, null=True)
    MI19 = models.CharField(max_length=255, null=True)
    MI20 = models.CharField(max_length=255, null=True)
    MI21 = models.CharField(max_length=255, null=True)
    MI22 = models.CharField(max_length=255, null=True)
    MI23 = models.CharField(max_length=255, null=True)
    MI31 = models.CharField(max_length=255, null=True)
    MI33 = models.CharField(max_length=255, null=True)
    INSAGM = models.CharField(max_length=255, null=True)
    MARAGM = models.CharField(max_length=255, null=True)
    MI53 = models.CharField(max_length=255, null=True)
    MI55 = models.CharField(max_length=255, null=True)
    MI36 = models.CharField(max_length=255, null=True)
    MI39 = models.CharField(max_length=255, null=True)
    MI24 = models.CharField(max_length=255, null=True)
    
    # MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    
    # Conditional Fields
    AGR1 = models.CharField(max_length=255, null=True)
    AGR2 = models.CharField(max_length=255, null=True)
    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE

    class Meta:
        managed = False
        db_table = 'MgMasterView_Full_Mockup_Data'

class VMasterView(models.Model):
    # Fields from ProcessControl.dbo.[Q-PRO-DATA]
    PRO0 = models.CharField(max_length=255, null=True)
    PRO1 = models.CharField(max_length=255, null=True)
    PRO1C = models.CharField(max_length=255, null=True)
    PRO2 = models.CharField(max_length=255, null=True)
    PRO5 = models.CharField(max_length=255, null=True)
    PRO8 = models.CharField(max_length=255, null=True)
    PRO9 = models.CharField(max_length=255, null=True)
    PRO10 = models.CharField(max_length=255, null=True)
    PRO11 = models.CharField(max_length=255, null=True)
    PRO12 = models.CharField(max_length=255, null=True)
    PRO13 = models.CharField(max_length=255, null=True)
    PRO14 = models.CharField(max_length=255, null=True)
    PRO15 = models.CharField(max_length=255, null=True)
    PRO16 = models.CharField(max_length=255, null=True)
    PRO17 = models.CharField(max_length=255, null=True)
    PRO18 = models.CharField(max_length=255, null=True)
    PRO21 = models.CharField(max_length=255, null=True)
    PRO25 = models.CharField(max_length=255, null=True)
    PRO27 = models.CharField(max_length=255, null=True)
    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    PRO6 = models.CharField(max_length=255, null=True)
    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    PRO4 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[V-MAS-1]
    MC11 = models.CharField(max_length=255, null=True)
    MC12 = models.CharField(max_length=255, null=True)
    MC14 = models.CharField(max_length=255, null=True)
    MC15 = models.CharField(max_length=255, null=True)
    MC16 = models.CharField(max_length=255, null=True)
    MC19 = models.CharField(max_length=255, null=True)
    MC20 = models.CharField(max_length=255, null=True)
    MC21 = models.CharField(max_length=255, null=True)
    MC22 = models.CharField(max_length=255, null=True)
    MC23 = models.CharField(max_length=255, null=True)
    MC24 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[V-MAS-2]
    MP34 = models.CharField(max_length=255, null=True)
    MP39 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[V-MAS-3]
    MI13 = models.CharField(max_length=255, null=True)
    TC = models.CharField(max_length=255, null=True)
    MI14 = models.CharField(max_length=255, null=True)
    MI15 = models.CharField(max_length=255, null=True)
    MI16 = models.CharField(max_length=255, null=True)
    MI17 = models.CharField(max_length=255, null=True)
    MI18 = models.CharField(max_length=255, null=True)
    MI19 = models.CharField(max_length=255, null=True)
    MI20 = models.CharField(max_length=255, null=True)
    MI21 = models.CharField(max_length=255, null=True)
    MI22 = models.CharField(max_length=255, null=True)
    MI23 = models.CharField(max_length=255, null=True)
    MI31 = models.CharField(max_length=255, null=True)
    MI33 = models.CharField(max_length=255, null=True)
    INSAGM = models.CharField(max_length=255, null=True)
    MARAGM = models.CharField(max_length=255, null=True)
    MI53 = models.CharField(max_length=255, null=True)
    MI55 = models.CharField(max_length=255, null=True)
    MI36 = models.CharField(max_length=255, null=True)
    MI39 = models.CharField(max_length=255, null=True)
    MI24 = models.CharField(max_length=255, null=True)
    
    # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    
    # Conditional Fields
    AGR1 = models.CharField(max_length=255, null=True)
    AGR2 = models.CharField(max_length=255, null=True)
    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE


    class Meta:
        managed = False
        db_table = 'VMasterView_Full_Mockup_Data'


class VwRotateLog(models.Model):
    # Fields from the SQL view
    PROD_CODE = models.CharField(max_length=255, null=True)
    LOT_NO = models.CharField(max_length=255, null=True)
    SPEED_SPEC = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    SPEED_TEST = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    SPEED_NG = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    CREATED_DT = models.DateTimeField(null=True)
    LAST_UPD_DT = models.DateTimeField(null=True)
    QTY = models.IntegerField(null=True)
    STATION_NO = models.CharField(max_length=255, null=True)

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'VwRotateLog_Mockup_Data'


class VwRotateResult(models.Model):
    # Fields from the SQL view
    PROD_CODE = models.CharField(max_length=255, null=True)
    LOT_NO = models.CharField(max_length=255, null=True)
    SPEED_SPEC = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    QTY = models.IntegerField(null=True)
    STATION_NO = models.CharField(max_length=255, null=True)
    START_DT = models.DateTimeField(null=True)  # T1.TEST_DT as START_DT
    TEST_NO = models.CharField(max_length=255, null=True)
    SPEED_TEST_VAL = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    SPEED_NG_VAL = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    TEST_END_DT = models.DateTimeField(null=True)  # T2.TEST_DT as TEST_END_DT

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'VW_ROTATE_RESULT'  # Name of the database view


class BelMasterView(models.Model):
    # Fields from ProcessControl.dbo.[Q-PRO-DATA]
    PRO0 = models.CharField(max_length=255, null=True)
    PRO1 = models.CharField(max_length=255, null=True)
    PRO1C = models.CharField(max_length=255, null=True)
    PRO2 = models.CharField(max_length=255, null=True)
    PRO5 = models.CharField(max_length=255, null=True)
    PRO8 = models.CharField(max_length=255, null=True)
    PRO9 = models.CharField(max_length=255, null=True)
    PRO10 = models.CharField(max_length=255, null=True)
    PRO11 = models.CharField(max_length=255, null=True)
    PRO12 = models.CharField(max_length=255, null=True)
    PRO13 = models.CharField(max_length=255, null=True)
    PRO14 = models.CharField(max_length=255, null=True)
    PRO15 = models.CharField(max_length=255, null=True)
    PRO16 = models.CharField(max_length=255, null=True)
    PRO17 = models.CharField(max_length=255, null=True)
    PRO18 = models.CharField(max_length=255, null=True)
    PRO21 = models.CharField(max_length=255, null=True)
    PRO25 = models.CharField(max_length=255, null=True)
    PRO27 = models.CharField(max_length=255, null=True)
    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    PRO6 = models.CharField(max_length=255, null=True)
    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    PRO4 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[BEL-MAS-1]
    MC11 = models.CharField(max_length=255, null=True)
    MC12 = models.CharField(max_length=255, null=True)
    MC14 = models.CharField(max_length=255, null=True)
    MC15 = models.CharField(max_length=255, null=True)
    MC16 = models.CharField(max_length=255, null=True)
    MC19 = models.CharField(max_length=255, null=True)
    MC20 = models.CharField(max_length=255, null=True)
    MC21 = models.CharField(max_length=255, null=True)
    MC22 = models.CharField(max_length=255, null=True)
    MC23 = models.CharField(max_length=255, null=True)
    MC24 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[BEL-MAS-2]
    MP45 = models.CharField(max_length=255, null=True)
    MP49 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[BEL-MAS-3]
    MI13 = models.CharField(max_length=255, null=True)
    TC = models.CharField(max_length=255, null=True)
    MI14 = models.CharField(max_length=255, null=True)
    MI15 = models.CharField(max_length=255, null=True)
    MI16 = models.CharField(max_length=255, null=True)
    MI17 = models.CharField(max_length=255, null=True)
    MI18 = models.CharField(max_length=255, null=True)
    MI19 = models.CharField(max_length=255, null=True)
    MI20 = models.CharField(max_length=255, null=True)
    MI21 = models.CharField(max_length=255, null=True)
    MI22 = models.CharField(max_length=255, null=True)
    MI23 = models.CharField(max_length=255, null=True)
    MI31 = models.CharField(max_length=255, null=True)
    MI33 = models.CharField(max_length=255, null=True)
    INSAGM = models.CharField(max_length=255, null=True)
    MARAGM = models.CharField(max_length=255, null=True)
    MI53 = models.CharField(max_length=255, null=True)
    MI55 = models.CharField(max_length=255, null=True)
    MI36 = models.CharField(max_length=255, null=True)
    MI39 = models.CharField(max_length=255, null=True)
    MI24 = models.CharField(max_length=255, null=True)
    
    # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    
    # Conditional Fields
    AGR1 = models.CharField(max_length=255, null=True)
    AGR2 = models.CharField(max_length=255, null=True)
    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'bel_master_view'  # Name of the database view

class EMasterView(models.Model):
    # Fields from ProcessControl.dbo.[Q-PRO-DATA]
    PRO0 = models.CharField(max_length=255, null=True)
    PRO1 = models.CharField(max_length=255, null=True)
    PRO1C = models.CharField(max_length=255, null=True)
    PRO2 = models.CharField(max_length=255, null=True)
    PRO5 = models.CharField(max_length=255, null=True)
    PRO8 = models.CharField(max_length=255, null=True)
    PRO9 = models.CharField(max_length=255, null=True)
    PRO10 = models.CharField(max_length=255, null=True)
    PRO11 = models.CharField(max_length=255, null=True)
    PRO12 = models.CharField(max_length=255, null=True)
    PRO13 = models.CharField(max_length=255, null=True)
    PRO14 = models.CharField(max_length=255, null=True)
    PRO15 = models.CharField(max_length=255, null=True)
    PRO16 = models.CharField(max_length=255, null=True)
    PRO17 = models.CharField(max_length=255, null=True)
    PRO18 = models.CharField(max_length=255, null=True)
    PRO21 = models.CharField(max_length=255, null=True)
    PRO25 = models.CharField(max_length=255, null=True)
    PRO27 = models.CharField(max_length=255, null=True)
    P2 = models.CharField(max_length=255, null=True)  # PRO-P2
    PRO6 = models.CharField(max_length=255, null=True)
    SPEED = models.CharField(max_length=255, null=True)  # PRO-SPEED
    PRO_TOOL = models.CharField(max_length=255, null=True)  # PRO-TOOL
    PRO4 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[E-MAS-1]
    MC11 = models.CharField(max_length=255, null=True)
    MC12 = models.CharField(max_length=255, null=True)
    MC14 = models.CharField(max_length=255, null=True)
    MC15 = models.CharField(max_length=255, null=True)
    MC16 = models.CharField(max_length=255, null=True)
    MC19 = models.CharField(max_length=255, null=True)
    MC20 = models.CharField(max_length=255, null=True)
    MC21 = models.CharField(max_length=255, null=True)
    MC22 = models.CharField(max_length=255, null=True)
    MC23 = models.CharField(max_length=255, null=True)
    MC24 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[E-MAS-2]
    MP45 = models.CharField(max_length=255, null=True)
    MP49 = models.CharField(max_length=255, null=True)
    
    # Fields from dbo.[E-MAS-3]
    MI13 = models.CharField(max_length=255, null=True)
    TC = models.CharField(max_length=255, null=True)
    MI14 = models.CharField(max_length=255, null=True)
    MI15 = models.CharField(max_length=255, null=True)
    MI16 = models.CharField(max_length=255, null=True)
    MI17 = models.CharField(max_length=255, null=True)
    MI18 = models.CharField(max_length=255, null=True)
    MI19 = models.CharField(max_length=255, null=True)
    MI20 = models.CharField(max_length=255, null=True)
    MI21 = models.CharField(max_length=255, null=True)
    MI22 = models.CharField(max_length=255, null=True)
    MI23 = models.CharField(max_length=255, null=True)
    MI31 = models.CharField(max_length=255, null=True)
    MI33 = models.CharField(max_length=255, null=True)
    INSAGM = models.CharField(max_length=255, null=True)
    MARAGM = models.CharField(max_length=255, null=True)
    MI53 = models.CharField(max_length=255, null=True)
    MI55 = models.CharField(max_length=255, null=True)
    MI36 = models.CharField(max_length=255, null=True)
    MI39 = models.CharField(max_length=255, null=True)
    MI24 = models.CharField(max_length=255, null=True)
    
    # Fields from MGT_Config.dbo.[TABLE_TI-T1], [TABLE_TI-T5], [TABLE_TI-T6]
    Ind1 = models.CharField(max_length=255, null=True)  # TIT1NE
    Ind2 = models.CharField(max_length=255, null=True)  # TIT5NE
    Ind3 = models.CharField(max_length=255, null=True)  # TIT6NE
    
    # Conditional Fields
    AGR1 = models.CharField(max_length=255, null=True)
    AGR2 = models.CharField(max_length=255, null=True)
    ob_Condition = models.CharField(max_length=255, null=True)  # TIT4NE

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'e_master_view'  # Name of the database view

class AllProductAverageObMinMaxView(models.Model):
    ProductCode = models.CharField(max_length=255, null=True)  # RE01
    out_min = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Minimum of [OB-O]
    out_max = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Maximum of [OB-O]
    in_min = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Minimum of [OB-I]
    in_max = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Maximum of [OB-I]

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'AllProduct_Average_OB_MIN_MAX_view'  # Name of the database view

class AllProductDimensionForInsProcess(models.Model):
    ProdType = models.CharField(max_length=255, null=True)  # Product type (e.g., 'V', 'E', 'BEL', 'MG')
    ProductCode = models.CharField(max_length=255, null=True)  # Product code
    Size_Id = models.CharField(max_length=255, null=True)  # Size ID (e.g., '001', '002')
    Size_Name = models.CharField(max_length=255, null=True)  # Size name (e.g., 'D', 'T', 'H')
    Std = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Standard value
    TolUn = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Tolerance lower limit
    TolUp = models.DecimalField(max_digits=10, decimal_places=2, null=True)  # Tolerance upper limit

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'AllProduct_Dimension_ForInsProcess'  # Name of the database view

class AllProductPressPositionPressWeight(models.Model):
    ProductCode = models.CharField(max_length=255, null=True)
    Lot_No = models.CharField(max_length=255, null=True)
    PO_Qty = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    UWeight = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Current_ProNo = models.CharField(max_length=255, null=True)
    Press_Time = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    PressType_1 = models.CharField(max_length=255, null=True)
    PressWeight_1 = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    PressType_2 = models.CharField(max_length=255, null=True)
    PressWeight_2 = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Press_Ton = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Press_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Press_T_Tol = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Mold_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Mold_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    SegMold_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    SegMold_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Center_D = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    Center_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    LowerPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    StudPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    UpperPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    PinPlate_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    TopConcave_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    BottomConcave_T = models.DecimalField(max_digits=10, decimal_places=2, null=True)

    class Meta:
        managed = False  # This model corresponds to a database view
        db_table = 'AllProduct_PressPosition_PressWeight'  # Name of the database view