using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PayRollDAL.Query.PaySlipIssue
{
    // Indexes recommended:
    //   TPAYPROCESS: IX_TPAYPROCESS_BIZTRANSACTIONTYPEID (BIZTRANSACTIONTYPEID)
    public static class PaySlipIssueQB
    {
        // ── Picklist (dual dialect) ──────────────────────────────────────────
        // GB4 parity: PaySlipIssueDAL.GetSelectListPaySlipIssuePaymentNumber →
        // PayTaxTypeQueryBuilder.PICKLIST_TPAYPROCESSPAYMENTNUMBER, filtered by BizTransactionTypeId + PaymentNumber

        public const string GET_SELECTLIST_PAYMENTNUMBER_SQL = @"
            SELECT DISTINCT
                   P.PAYMENTID     AS PaymentId,
                   P.PAYMENTNUMBER AS PaymentNumber
            FROM   TPAYPROCESS P
            WHERE  P.PAYMENTID <> -1
            AND    (@biztransactiontypeid = -1 OR P.BIZTRANSACTIONTYPEID = @biztransactiontypeid)
            AND    (@paymentnumber IS NULL OR P.PAYMENTNUMBER LIKE @paymentnumber)
            ORDER BY P.PAYMENTNUMBER;";

        public const string GET_SELECTLIST_PAYMENTNUMBER_PG = @"
            SELECT DISTINCT
                   P.""PAYMENTID""     AS ""PaymentId"",
                   P.""PAYMENTNUMBER"" AS ""PaymentNumber""
            FROM   ""TPAYPROCESS"" P
            WHERE  P.""PAYMENTID"" <> -1
            AND    (:biztransactiontypeid = -1 OR P.""BIZTRANSACTIONTYPEID"" = :biztransactiontypeid)
            AND    (:paymentnumber IS NULL OR P.""PAYMENTNUMBER"" LIKE :paymentnumber)
            ORDER BY P.""PAYMENTNUMBER"";";
    }
}