namespace QMSDAL.DTO
{
    // ─────────────────────────────────────────────────────────────────────────
    // TMATRIXINPUT  — Traceability Input Lines (RM / BO Consumption)
    //
    // SQL columns (QMS.sql Section 4):
    //   MATRIXINPUTID, MATRIXID, SLNO,
    //   ITEMID, SKUID, ITEMCATEGORY,
    //   LOTID, PLANNEDQTY, ALLOCATEDQTY, CONSUMEDQTY,
    //   MIXPROPORTION, LINESTATUS, TENANTID
    //
    // New FK columns to be added via ALTER:
    //   BOMLINEID   → MBOMDETAIL.BOMLINEID
    //   LOTDETAILID → TLOTDETAIL.LOTDETAILID   (populated after consumption posting)
    // ─────────────────────────────────────────────────────────────────────────
    public class MatrixInputDTO
    {
        // ====================================================================
        // PRIMARY / LINKING KEYS
        // ====================================================================

        public int MatrixInputId { get; set; }

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

        public short SlNo { get; set; }

        // ====================================================================
        // ITEM DETAILS  (TMATRIXINPUT.ITEMID / SKUID)
        // ====================================================================

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

        public string? ItemCode { get; set; }

        public string? ItemName { get; set; }

        /// <summary>MITEM.ITEMSHORTNAME</summary>
        public string? ItemShortName { get; set; }

        /// <summary>FK → MUOM.UOMID — MITEM.STOCKUOMID (base stocking unit of the component)</summary>
        public int StockUomId { get; set; } = -1;

        /// <summary>MITEM.ISBATCHSTOCK — whether this component requires batch/lot tracking</summary>
        public bool IsBatchStock { get; set; }

        /// <summary>MITEM.ISSKUTRACKINGAPPLICABLE</summary>
        public bool IsSkuTrackingApplicable { get; set; }

        /// <summary>MITEM.CATEGORYID</summary>
        public int CategoryId { get; set; } = -1;

        /// <summary>MITEM.SUBCATEGORYID</summary>
        public int SubCategoryId { get; set; } = -1;

        /// <summary>MITEM.ITEMGROUPID</summary>
        public int ItemGroupId { get; set; } = -1;

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

        public string? SkuCode { get; set; }

        public string? SkuName { get; set; }

        // ====================================================================
        // CLASSIFICATION  (TMATRIXINPUT.ITEMCATEGORY)
        // ====================================================================

        /// <summary>0=RM | 1=BO_Qty | 2=BO_Serial</summary>
        public byte ItemCategory { get; set; }

        public string? ItemCategoryName { get; set; }

        // ====================================================================
        // BOM DETAIL LINK  (MBOMDETAIL columns)
        // ====================================================================

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

        /// <summary>MBOMDETAIL.SLNO — sequence within the BOM</summary>
        public short BomSlNo { get; set; }

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

        public string? BomCode { get; set; }

        /// <summary>MBOM.PRODUCTIONQTY — reference output qty the BOM was designed for</summary>
        public decimal BomProductionQty { get; set; }

        /// <summary>MBOMDETAIL.BOMLEVEL — depth in BOM tree (0=root excluded by query)</summary>
        public byte BomLevel { get; set; }

        /// <summary>MBOMDETAIL.PRODUCTIONSTAGE</summary>
        public string? ProductionStage { get; set; }

        /// <summary>MBOMDETAIL.MATERIALTYPE</summary>
        public byte? MaterialType { get; set; }

        /// <summary>MBOMDETAIL.IOTYPE — 1=Input / 2=Output indicator on BOM line</summary>
        public byte? IoType { get; set; }

        /// <summary>MBOMDETAIL.CALCULATIONTYPE</summary>
        public byte? CalculationType { get; set; }

        /// <summary>FK → MUOM.UOMID — MBOMDETAIL.UOMID (BOM component unit)</summary>
        public int UomId { get; set; } = -1;

        public string? UomName { get; set; }

        /// <summary>MBOMDETAIL.QUANTITY — raw qty per BOM reference production qty</summary>
        public decimal QtyPer { get; set; }

        /// <summary>MBOMDETAIL.PERCENTAGE — formula-based percentage</summary>
        public decimal BomPercentage { get; set; }

        /// <summary>MBOMDETAIL.PERPRODUCTIONQUANTITY — per-unit exploded quantity before waste</summary>
        public decimal PerProductionQuantity { get; set; }

        /// <summary>MBOMDETAIL.REQUIREDPRODUCTIONQUANTITY — scaled required quantity</summary>
        public decimal RequiredProductionQuantity { get; set; }

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

        /// <summary>MBOMDETAIL.NETQUANTITY — qty after waste % applied</summary>
        public decimal NetQuantity { get; set; }

        /// <summary>MBOMDETAIL.FINALQUANTITY — net qty after waste + manual adjustment</summary>
        public decimal FinalQuantity { get; set; }

        // ====================================================================
        // LOT / BATCH  (TMATRIXINPUT.LOTID  →  TLOT)
        // ====================================================================

        /// <summary>
        /// FK → TLOT.LOTID — assigned RM batch
        /// -1 for BO_Qty and BO_Serial items (not yet allocated)
        /// </summary>
        public int LotId { get; set; } = -1;

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

        public string? BatchNo { 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;

        // ====================================================================
        // LOT DETAIL LINK  — new column LOTDETAILID added to TMATRIXINPUT
        // Populated after the consumption issue is posted to TLOTDETAIL
        // ====================================================================

        /// <summary>FK → TLOTDETAIL.LOTDETAILID; -1 before consumption 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.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; }

        // ====================================================================
        // QUANTITIES  (TMATRIXINPUT)
        // ====================================================================

        /// <summary>BOM-exploded total — planning snapshot (same as RequiredQty)</summary>
        public decimal PlannedQty { get; set; }

        /// <summary>Total required quantity for the set range — MBOMDETAIL.FINALQUANTITY × 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; }

        /// <summary>Confirmed qty reserved from this batch</summary>
        public decimal AllocatedQty { get; set; }

        /// <summary>Running total maintained from actual issues</summary>
        public decimal ConsumedQty { get; set; }

        /// <summary>
        /// Available stock from stock engine
        /// Populated by CHECK_STOCK_POSITION only
        /// </summary>
        public decimal FreeQty { get; set; }

        /// <summary>
        /// AllocatedQty - FreeQty
        /// Populated by CHECK_STOCK_POSITION only
        /// </summary>
        public decimal ShortageQty { get; set; }

        // ====================================================================
        // MIX / TRACEABILITY CONTROL  (TMATRIXINPUT)
        // ====================================================================

        /// <summary>Blend % for OpenMix mode; 0 for Product / FGItem modes</summary>
        public decimal MixProportion { get; set; }

        // ====================================================================
        // STATUS  (TMATRIXINPUT.LINESTATUS)
        // ====================================================================

        /// <summary>0=Open | 1=Partial | 2=Consumed | 3=Cancelled</summary>
        public byte LineStatus { get; set; }

        public string? LineStatusName { get; set; }

        // ====================================================================
        // RESERVATION FLAG
        // ====================================================================

        /// <summary>
        /// True when a TRESERVATION row already exists for this input line.
        /// Populated on GET from a LEFT JOIN to TRESERVATION
        /// (FOROBJECTID = MatrixInputId, FOROBJECTTYPEID = ENTITY_TMATRIXINPUT).
        /// On Save: BLL skips reservation creation when this is true.
        /// </summary>
        public bool IsReservation { get; set; }

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

        public int TenantId { get; set; }

        public DateTime? CreatedOn { get; set; }

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