namespace MMDAL.Query.ItemReason
{
    // TITEMREASON is a polymorphic reason-breakdown table (OBJECTHEADERTYPEID/OBJECTHEADERID +
    // OBJECTTYPEID/OBJECTID via MENTITY) reused across modules — see
    // GB5Shared/GB5Constant/Constant.cs EntityConstant.OBJECTPRODUCTION / OBJECTPRODUCTIONDETAIL
    // for the sentinel IDs Production uses here. No STATUS/VERSION/TENANTID columns exist on this
    // table — it is a lean child row always written/deleted as part of its parent document's
    // transaction, matching TPRODUCTIONSTOPPAGE's shape.
    public static class ItemReasonQB
    {
        public const string SAVE_ITEM_REASON_SQL = @"INSERT INTO TITEMREASON
                                                        (
                                                            ITEMREASONID,
                                                            OBJECTHEADERTYPEID,
                                                            OBJECTHEADERID,
                                                            OBJECTTYPEID,
                                                            OBJECTID,
                                                            BIZTRANSACTIONTYPEID,
                                                            ITEMID,
                                                            SKUID,
                                                            DOCUMENTDATE,
                                                            SLNO,
                                                            REASONID,
                                                            GOODQUANTITY,
                                                            REJECTEDQUANTITY,
                                                            REWORKQUANTITY,
                                                            OTHERQUANTITY,
                                                            REMARKS,
                                                            LOTID
                                                        )
                                                        VALUES
                                                        (
                                                            @ItemReasonId,
                                                            @ObjectHeaderTypeId,
                                                            @ObjectHeaderId,
                                                            @ObjectTypeId,
                                                            @ObjectId,
                                                            @BizTransactionTypeId,
                                                            @ItemId,
                                                            @SkuId,
                                                            @DocumentDate,
                                                            @SlNo,
                                                            @ReasonId,
                                                            @GoodQuantity,
                                                            @RejectedQuantity,
                                                            @ReworkQuantity,
                                                            @OtherQuantity,
                                                            @Remarks,
                                                            @LotId
                                                        );";

        public const string SAVE_ITEM_REASON_PG = @"INSERT INTO TITEMREASON
                                                        (
                                                            ITEMREASONID,
                                                            OBJECTHEADERTYPEID,
                                                            OBJECTHEADERID,
                                                            OBJECTTYPEID,
                                                            OBJECTID,
                                                            BIZTRANSACTIONTYPEID,
                                                            ITEMID,
                                                            SKUID,
                                                            DOCUMENTDATE,
                                                            SLNO,
                                                            REASONID,
                                                            GOODQUANTITY,
                                                            REJECTEDQUANTITY,
                                                            REWORKQUANTITY,
                                                            OTHERQUANTITY,
                                                            REMARKS,
                                                            LOTID
                                                        )
                                                        VALUES
                                                        (
                                                            :ItemReasonId,
                                                            :ObjectHeaderTypeId,
                                                            :ObjectHeaderId,
                                                            :ObjectTypeId,
                                                            :ObjectId,
                                                            :BizTransactionTypeId,
                                                            :ItemId,
                                                            :SkuId,
                                                            :DocumentDate,
                                                            :SlNo,
                                                            :ReasonId,
                                                            :GoodQuantity,
                                                            :RejectedQuantity,
                                                            :ReworkQuantity,
                                                            :OtherQuantity,
                                                            :Remarks,
                                                            :LotId
                                                        );";

        // Deletes every reason row for one document header (all its detail lines at once) —
        // used by ProductionDAL.DeleteProductionChildren before a full-replace update.
        public const string DELETE_ITEM_REASON_BY_HEADER_SQL = @"
            DELETE FROM TITEMREASON
            WHERE  OBJECTHEADERTYPEID = @ObjectHeaderTypeId
            AND    OBJECTHEADERID     = @ObjectHeaderId;";

        public const string DELETE_ITEM_REASON_BY_HEADER_PG = @"
            DELETE FROM TITEMREASON
            WHERE  OBJECTHEADERTYPEID = :ObjectHeaderTypeId
            AND    OBJECTHEADERID     = :ObjectHeaderId;";
    }
}