namespace QMSDAL.DTO
{
    // ─────────────────────────────────────────────────────────────────────────
    // TMATRIXOUTPUT  — Traceability Output Lines (SET / FGSerial / MixOutputLot)
    //
    // SQL columns (QMS.sql Section 3):
    //   MATRIXOUTPUTID, MATRIXID, SLNO,
    //   OUTPUTLEVEL, ITEMID, SKUID,
    //   LOTID, LOTQUANTITY, TENANTID
    //
    // New FK columns to be added via ALTER:
    //   BOMLINEID   → MBOMDETAIL.BOMLINEID   (for QtyPer and BOM traceability)
    //   LOTDETAILID → TLOTDETAIL.LOTDETAILID (populated after output posting)
    //
    // SetNumber rule:
    //   The set number for each output row is stored in TLOT (new column SETNUMBER
    //   on TLOT), NOT in TMATRIXOUTPUT.  Read via TLOT join on LOTID.
    // ─────────────────────────────────────────────────────────────────────────
    public class MatrixOutputDTO
    {
        // ====================================================================
        // PRIMARY / LINKING KEYS
        // ====================================================================

        public int MatrixOutputId { get; set; }

        /// <summary>FK → TMATRIX.MATRIXID</summary>
        public int MatrixId { get; set; }

        public short SlNo { get; set; }

        // ====================================================================
        // OUTPUT CLASSIFICATION  (TMATRIXOUTPUT.OUTPUTLEVEL)
        // ====================================================================

        /// <summary>0=Set | 1=FGSerial | 2=MixOutputLot</summary>
        public byte OutputLevel { get; set; }

        public string? OutputLevelName { get; set; }

        // ====================================================================
        // ITEM / SKU  (TMATRIXOUTPUT.ITEMID / SKUID)
        // ====================================================================

        /// <summary>FK → MITEM.ITEMID</summary>
        public int ItemId { get; set; }

        public string? ItemCode { get; set; }

        public string? ItemName { get; set; }

        /// <summary>FK → MSKU.SKUID</summary>
        public int SkuId { get; set; }

        public string? SkuCode { get; set; }

        public string? SkuName { get; set; }

        // ====================================================================
        // BOM DETAIL LINK  — new column BOMLINEID added to TMATRIXOUTPUT
        // ====================================================================

        /// <summary>FK → MBOMDETAIL.BOMLINEID; -1 when not BOM-linked</summary>
        public int BomLineId { get; set; } = -1;

        // Display fields joined from MBOMDETAIL / MBOM

        /// <summary>FK → MBOM.BOMID — parent BOM header</summary>
        public int BomId { get; set; } = -1;

        public string? BomCode { get; set; }

        public string? BomName { get; set; }

        /// <summary>
        /// Quantity per production unit — MBOMDETAIL.QUANTITY
        /// Used to derive the planned output qty for each SET
        /// </summary>
        public decimal QtyPer { get; set; }

        /// <summary>MBOMDETAIL.WASTEPERCENTAGE</summary>
        public decimal WastePercentage { get; set; }

        /// <summary>FK → MUOM.UOMID — from MBOMDETAIL.UOMID</summary>
        public int UomId { get; set; } = -1;

        public string? UomName { get; set; }

        // ====================================================================
        // LOT  (TMATRIXOUTPUT.LOTID  →  TLOT)
        // Represents SET lot / FGSerial lot / MixOutputLot
        // ====================================================================

        /// <summary>FK → TLOT.LOTID</summary>
        public int LotId { get; set; } = -1;

        // Display fields joined from TLOT
        public string? LotNumber { get; set; }

        /// <summary>TLOT.LOTDATE</summary>
        public DateTime? LotDate { get; set; }

        /// <summary>TLOT.LOTEXPIRYDATE</summary>
        public DateTime? LotExpiryDate { get; set; }

        /// <summary>TLOT.LOTTYPEID</summary>
        public int LotTypeId { get; set; } = -1;

        /// <summary>TLOT.STATUS</summary>
        public byte LotStatus { get; set; }

        /// <summary>TLOT.MRPRATE</summary>
        public decimal MrpRate { get; set; }

        /// <summary>TLOT.ITEMPOSTEDCOST</summary>
        public decimal ItemPostedCost { get; set; }

        /// <summary>
        /// Set number stored in TLOT.SETNUMBER (new column on TLOT).
        /// Sequential within the matrix (SETFROM … SETTO range).
        /// 0 for FGSerial and MixOutputLot rows.
        /// </summary>
        public int SetNumber { get; set; }

        // ====================================================================
        // QUANTITY  (TMATRIXOUTPUT.LOTQUANTITY)
        // ====================================================================

        /// <summary>1 for FGSerial | N for Set | actual qty for MixOutputLot</summary>
        public decimal LotQuantity { get; set; } = 1;

        /// <summary>Total required output quantity for the set range — same as LotQuantity × SetCount</summary>
        public decimal RequiredQty { get; set; }

        /// <summary>Quantity per production unit — MBOMDETAIL.QUANTITY</summary>
        public decimal QuantityPer { get; set; }

        /// <summary>Unit of measure code — MUOM.UOMCODE via MITEM.STOCKUOMID</summary>
        public string? UomCode { get; set; }

        // ====================================================================
        // LOT DETAIL LINK  — new column LOTDETAILID added to TMATRIXOUTPUT
        // Populated after the output lot is posted to TLOTDETAIL
        // ====================================================================

        /// <summary>FK → TLOTDETAIL.LOTDETAILID; -1 before output is posted</summary>
        public int LotDetailId { get; set; } = -1;

        // Display fields joined from TLOTDETAIL

        /// <summary>TLOTDETAIL.OUID</summary>
        public int OuId { get; set; } = -1;

        /// <summary>TLOTDETAIL.STOREID</summary>
        public int StoreId { get; set; } = -1;

        public string? StoreName { get; set; }

        /// <summary>TLOTDETAIL.BINID</summary>
        public int BinId { get; set; } = -1;

        public string? BinName { get; set; }

        /// <summary>TLOTDETAIL.LOCATIONTYPE</summary>
        public byte? LocationType { get; set; }

        /// <summary>TLOTDETAIL.PARTYBRANCHID</summary>
        public int PartyBranchId { get; set; } = -1;

        /// <summary>TLOTDETAIL.GOODQUANTITY</summary>
        public decimal GoodQuantity { get; set; }

        /// <summary>TLOTDETAIL.REJECTEDQUANTITY</summary>
        public decimal RejectedQuantity { get; set; }

        /// <summary>TLOTDETAIL.REWORKQUANTITY</summary>
        public decimal ReworkQuantity { get; set; }

        /// <summary>TLOTDETAIL.OTHERQUANTITY</summary>
        public decimal OtherQuantity { get; set; }

        /// <summary>TLOTDETAIL.PLANNEDQUANTITY</summary>
        public decimal PlannedQuantity { get; set; }

        /// <summary>TLOTDETAIL.REFERENCENUMBER</summary>
        public string? ReferenceNumber { get; set; }

        /// <summary>TLOTDETAIL.REFERENCEDATE</summary>
        public DateTime? ReferenceDate { get; set; }

        /// <summary>TLOTDETAIL.STOCKLEDGERNUMBER</summary>
        public string? StockLedgerNumber { get; set; }

        /// <summary>TLOTDETAIL.STOCKLEDGERDATE</summary>
        public DateTime? StockLedgerDate { get; set; }

        /// <summary>TLOTDETAIL.STOCKPOSTTYPE</summary>
        public byte? StockPostType { get; set; }

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

        public int TenantId { get; set; }

        public DateTime? CreatedOn { get; set; }

        public DateTime? ModifiedOn { get; set; }
    }
}