Class BankTransactionQueryService

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

get(
    args: {
        id: string;
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
    },
): Promise<{ ok: true; value: BankTransaction | null }>

search(
    __namedParameters: {
        accountNumber?: string;
        amount?: string;
        bankIds?: string[];
        bankTransactionIds?: string[];
        createdAt?: DbTimestampCriteria;
        id?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            accountNumber: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            amount: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            bankId: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<SetNotNull<(...)>, string>,
                                {
                                    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: "bank_transaction";
                                },
                            >;
                            bankStatus: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<SetNotNull<(...)>, "POSTED">,
                                {
                                    data: "POSTED";
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            bankTransactionId: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            data: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<
                                    SetHasDefault<(...)>,
                                    { isManual?: ...; methodData: ...; reconciliation: ... },
                                >,
                                {
                                    data: { isManual?: ...; methodData: ...; reconciliation: ... };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            description: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            id: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            postedAt: PgBuildColumn<
                                "bank_transaction",
                                SetNotNull<PgTimestampBuilder>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            routingNumber: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            statementDescription: PgBuildColumn<
                                "bank_transaction",
                                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: "bank_transaction";
                                },
                            >;
                            type: PgBuildColumn<
                                "bank_transaction",
                                Set$Type<SetNotNull<(...)>, (...) | (...)>,
                                {
                                    data: (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "bank_transaction";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "bank_transaction",
                                SetHasDefault<SetHasDefault<(...)>>,
                                {
                                    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: "bank_transaction";
                                },
                            >;
                        };
                        dialect: "pg";
                        name: "bank_transaction";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        q?: string;
        routingNumber?: string;
        status?: "POSTED" | "RECONCILED";
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
        type?: "CREDIT" | "DEBIT";
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: { hasNext: boolean; items: BankTransaction[]; total: number };
    },
>

stat(
    args: {
        accountNumber: string;
        includeManual?: boolean;
        routingNumber: string;
        tx?: PgAsyncTransaction<
            PostgresJsQueryResultHKT,
            __module,
            EmptyRelations,
            ExtractTablesWithRelations<__module>,
        >;
    },
): Promise<{ ok: true; value: { txCount: number } }>