namespace QMSDAL.DTO
{
    // ─────────────────────────────────────────────────────────────────────────
    // TMATRIX  — Traceability Matrix Planning Header
    //
    // SQL columns (QMS.sql Section 2):
    //   MATRIXID, MATRIXCODE, MATRIXMODE, BATCHASSIGNMODE,
    //   ALLOCATIONID, MMDETAILID, ALLOCATIONSLNO,
    //   SETFROM, SETTO, FGITEMID, FGSKUID, PROCESSID, PROCESSGROUPID,
    //   OUTPUTLOTID, PROCESSLOTQTY, MATRIXSTATUS, SUPERSEDEDBYID,
    //   ACTIVATEDON, REMARKS, VERSION, STATUS, SORTORDER,
    //   CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON,
    //   SOURCETYPE, TENANTID
    //
    // New FK columns to be added via ALTER:
    //   BOMID  → MBOM.BOMID
    // ─────────────────────────────────────────────────────────────────────────
    public class MatrixDTO
    {
        // ====================================================================
        // PRIMARY KEY
        // ====================================================================
        public int MatrixId { get; set; }

        // ====================================================================
        // BUSINESS COLUMNS  (TMATRIX)
        // ====================================================================

        public string MatrixCode { get; set; } = string.Empty;

        /// <summary>0=Product | 1=FGItem | 2=OpenMix</summary>
        public byte MatrixMode { get; set; }

        public string? MatrixModeName { get; set; }

        /// <summary>0=Item | 1=Stage | 2=SKU</summary>
        public byte BatchAssignMode { get; set; }

        public string? BatchAssignModeName { get; set; }

        /// <summary>FK → MALLOCATION.ALLOCATIONID</summary>
        public int AllocationId { get; set; }

        public string? AllocationName { get; set; }

        /// <summary>
        /// FK → TMMDETAIL.DOCUMENTDETAILID
        /// -1 when forecast-based (no SO yet)
        /// </summary>
        public int MmDetailId { get; set; } = -1;

        public string? SoNumber { get; set; }

        /// <summary>Sequential matrix number per allocation — UNIQUE (ALLOCATIONID, ALLOCATIONSLNO)</summary>
        public short AllocationSlNo { get; set; } = 1;

        /// <summary>First set number in range (0 for OpenMix mode)</summary>
        public short SetFrom { get; set; } = 1;

        /// <summary>Last set number in range (0 for OpenMix mode)</summary>
        public short SetTo { get; set; } = 1;

        /// <summary>FK → MITEM.ITEMID  — FGItem mode only; -1 otherwise</summary>
        public int FgItemId { get; set; } = -1;

        public string? FgItemCode { get; set; }

        public string? FgItemName { get; set; }

        /// <summary>FK → MSKU.SKUID  — FGItem mode only; -1 otherwise</summary>
        public int FgSkuId { get; set; } = -1;

        public string? FgSkuCode { get; set; }

        public string? FgSkuName { get; set; }

        /// <summary>FK → MPROCESS.PROCESSID</summary>
        public int ProcessId { get; set; } = -1;

        public string? ProcessCode { get; set; }

        public string? ProcessName { get; set; }

        /// <summary>FK → MPROCESSGROUP.PROCESSGROUPID  — OpenMix mode only; -1 otherwise</summary>
        public int ProcessGroupId { get; set; } = -1;

        public string? ProcessGroupCode { get; set; }

        public string? ProcessGroupName { get; set; }

        /// <summary>
        /// FK → TLOT.LOTID  — OpenMix output lot
        /// -1 until post-production
        /// </summary>
        public int OutputLotId { get; set; } = -1;

        public string? OutputLotNumber { get; set; }

        /// <summary>Planned output quantity for OpenMix mode</summary>
        public decimal ProcessLotQty { get; set; }

        /// <summary>0=Draft | 1=Active | 2=Superseded | 3=Deleted</summary>
        public byte MatrixStatus { get; set; }

        public string? MatrixStatusName { get; set; }

        /// <summary>FK → TMATRIX.MATRIXID (self-ref); -1 when not superseded</summary>
        public int SupersededById { get; set; } = -1;

        public string? SupersededByMatrixCode { get; set; }

        /// <summary>Set when MatrixStatus transitions to Active</summary>
        public DateTime? ActivatedOn { get; set; }

        public string? Remarks { get; set; }

        // ====================================================================
        // VOUCHER NUMBER
        // ====================================================================

        /// <summary>
        /// FK → MBIZTRANSACTIONTYPE.BIZTRANSACTIONTYPEID
        /// Drives MatrixCode auto-generation via VoucherNumberService.
        /// Pass 0 to use a manually supplied MatrixCode.
        /// </summary>
        public int BizTransactionTypeId { get; set; }

        // ====================================================================
        // BOM LINK  — new column BOMID added to TMATRIX via ALTER
        // ====================================================================

        /// <summary>FK → MBOM.BOMID  — BOM used to explode this matrix; -1 when not linked</summary>
        public int BomId { get; set; } = -1;

        // Display fields joined from MBOM
        public string? BomCode { get; set; }

        public string? BomName { get; set; }

        /// <summary>MBOM.BOMTYPE</summary>
        public byte? BomType { get; set; }

        /// <summary>MBOM.VERSIONNAME</summary>
        public string? BomVersionName { get; set; }

        /// <summary>MBOM.ISDEFAULTVERSION</summary>
        public bool? BomIsDefaultVersion { get; set; }

        /// <summary>Reference production qty — MBOM.PRODUCTIONQTY</summary>
        public decimal BomProductionQty { get; set; }

        /// <summary>FK → MROUTING.ROUTINGID — from MBOM.ROUTINGID</summary>
        public int RoutingId { get; set; } = -1;

        /// <summary>MBOM.FROMDATE</summary>
        public DateTime? BomFromDate { get; set; }

        /// <summary>MBOM.TODATE</summary>
        public DateTime? BomToDate { get; set; }

        // ====================================================================
        // STANDARD FIELDS
        // ====================================================================

        public short Version { get; set; } = 1;

        public byte Status { get; set; } = 1;

        public short SortOrder { get; set; } = 9999;

        public byte SourceType { get; set; } = 5;

        public int TenantId { get; set; }

        // ====================================================================
        // AUDIT FIELDS
        // ====================================================================

        public int CreatedById { get; set; }

        public string? CreatedByName { get; set; }

        public DateTime CreatedOn { get; set; }

        public int ModifiedById { get; set; }

        public string? ModifiedByName { get; set; }

        public DateTime ModifiedOn { get; set; }

        // ====================================================================
        // CHILD COLLECTIONS
        // ====================================================================

        /// <summary>TMATRIXINPUT child rows</summary>
        public List<MatrixInputDTO> Inputs { get; set; } = new();

        /// <summary>TMATRIXOUTPUT child rows</summary>
        public List<MatrixOutputDTO> Outputs { get; set; } = new();

        // ====================================================================
        // COMPUTED / VIEW FIELDS
        // ====================================================================

        /// <summary>Total generated SET lots</summary>
        public int SetsCount { get; set; }

        /// <summary>Total generated FG serial lots</summary>
        public int SerialsCount { get; set; }
    }

    public class MatrixPicklistDTO
    {
        public int MatrixId { get; set; }

        public string MatrixCode { get; set; } = string.Empty;

        /// <summary>0=Product | 1=FGItem | 2=OpenMix</summary>
        public byte MatrixMode { get; set; }

        /// <summary>0=Item | 1=Stage | 2=SKU</summary>
        public byte BatchAssignMode { get; set; }

        /// <summary>0=Draft | 1=Active | 2=Superseded | 3=Deleted</summary>
        public byte MatrixStatus { get; set; }

        public string? Remarks { get; set; }
    }
}