Class RedemptionAdminQueryService

new RedemptionAdminQueryService(
    args: { db: B2bDatabase },
): RedemptionAdminQueryService

get(
    args: Pick<
        {
            achBatchId?: string;
            amount: string;
            commitId?: string;
            commitTxId?: string;
            createdAt: Date;
            id: string;
            idempotencyKey: string;
            initiateTxId?: string;
            ledgerAccountId: string;
            status: "PENDING"
            | "FAILED"
            | "VOIDED"
            | "COMMITTED";
            updatedAt: Date;
            voidTxId?: string;
            withdrawalId?: string;
        },
        "id",
    > & {
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
    },
): Promise<
    {
        ok: true;
        value: | {
            achBatchId?: string;
            amount: string;
            commitId?: string;
            commitTxId?: string;
            createdAt: Date;
            id: string;
            idempotencyKey: string;
            initiateTxId?: string;
            ledgerAccountId: string;
            status: "PENDING"
            | "FAILED"
            | "VOIDED"
            | "COMMITTED";
            updatedAt: Date;
            voidTxId?: string;
            withdrawalId?: string;
        } & { customerId: string; customerName: string }
        | null;
    },
>

search(
    __namedParameters: {
        achBatchId?: string;
        amount?: string;
        createdAt?: DbTimestampCriteria;
        customerId?: string;
        idempotencyKey?: string;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            amount: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgNumericBuilder>,
                                {
                                    data: string;
                                    dataType: "string numeric";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            commitExternalId: PgBuildColumn<
                                "redemption",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "redemption";
                                },
                            >;
                            commitTxId: PgBuildColumn<
                                "redemption",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "redemption";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "redemption",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "redemption",
                                SetHasRuntimeDefault<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            id: PgBuildColumn<
                                "redemption",
                                HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            idempotencyKey: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            initiateTxId: PgBuildColumn<
                                "redemption",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "redemption";
                                },
                            >;
                            ledgerAccountId: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            redemptionData: PgBuildColumn<
                                "redemption",
                                SetNotNull<PgJsonbBuilder>,
                                {
                                    data: unknown;
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            status: PgBuildColumn<
                                "redemption",
                                SetNotNull<Set$Type<(...), (...)>>,
                                {
                                    data: (...) | (...) | (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "redemption",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "redemption";
                                },
                            >;
                            voidTxId: PgBuildColumn<
                                "redemption",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "redemption";
                                },
                            >;
                        };
                        dialect: "pg";
                        name: "redemption";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        status?: "PENDING" | "FAILED" | "VOIDED" | "COMMITTED";
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
        updatedAt?: DbTimestampCriteria;
        withdrawalId?: string;
        withdrawalIds?: (string | undefined)[];
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (
                {
                    achBatchId?: string;
                    amount: string;
                    commitId?: string;
                    commitTxId?: string;
                    createdAt: Date;
                    id: string;
                    idempotencyKey: string;
                    initiateTxId?: string;
                    ledgerAccountId: string;
                    status: "PENDING"
                    | "FAILED"
                    | "VOIDED"
                    | "COMMITTED";
                    updatedAt: Date;
                    voidTxId?: string;
                    withdrawalId?: string;
                } & { customerId: string; customerName: string }
            )[];
        };
    },
>