Class DepositBankMemoAdminQueryService

Index

Constructors

constructor

new DepositBankMemoAdminQueryService(
args: { bankAdminService: BankAdminService; db: B2bDatabase },
): DepositBankMemoAdminQueryService
Parameters
- args: { bankAdminService: BankAdminService; db: B2bDatabase }
Returns DepositBankMemoAdminQueryService
- Defined in packages/bank-memo-services/src/DepositBankMemoAdminService.ts:48

Properties

`Protected` `Readonly`bankAdminService

bankAdminService: BankAdminService

`Protected` `Readonly`db

db: B2bDatabase

`Static`instance

instance: (...args: []) => DepositBankMemoAdminQueryService = ...

The process default: built from each dependency's own instance().

Methods

get

get(
    __namedParameters: {
        customerId?: string;
        includeDeleted?: boolean;
        memo: string;
        tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
    },
): Promise<
    {
        ok: true;
        value: | (DepositBankMemo & { entityId: string; customerId: string; })
        | null;
    },
>
Parameters
- __namedParameters: {
      customerId?: string;
      includeDeleted?: boolean;
      memo: string;
      tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
  }
Returns Promise<
    {
        ok: true;
        value: | (DepositBankMemo & { entityId: string; customerId: string; })
        | null;
    },
>
- Defined in packages/bank-memo-services/src/DepositBankMemoAdminService.ts:79

`Protected`resolveBanks

resolveBanks(rows: { bankId: string }[]): Promise<Map<string, Bank>>
Batch-resolve the banks referenced by rows into a Map<BankId, Bank>. One cached search({ ids }) covers all rows; throws if a row references a bank that no longer exists.
Parameters
- rows: { bankId: string }[]
Returns Promise<Map<string, Bank>>
- Defined in packages/bank-memo-services/src/DepositBankMemoAdminService.ts:58

search

search(
    __namedParameters: {
        addresses?: string[];
        createdAt?: DbTimestampCriteria;
        customerId?: string;
        entityIds?: string[];
        frequencies?: ("ONE_TIME" | "RECURRING")[];
        ids?: string[];
        includeDeleted?: boolean;
        ledgerAccountIds?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            address: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            bankAccountExternalId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            bankAccountId: PgBuildColumn<
                                "deposit_bank_memo",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            bankId: PgBuildColumn<
                                "deposit_bank_memo",
                                SetNotNull<Set$Type<(...), (...)>>,
                                {
                                    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: "deposit_bank_memo";
                                },
                            >;
                            chain: PgBuildColumn<
                                "deposit_bank_memo",
                                Set$Type<SetNotNull<(...)>, "SOLANA">,
                                {
                                    data: "SOLANA";
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            consumedAt: PgBuildColumn<
                                "deposit_bank_memo",
                                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: false;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            customerExternalId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            deletedAt: PgBuildColumn<
                                "deposit_bank_memo",
                                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: false;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            id: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            identityExternalId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            identityId: PgBuildColumn<
                                "deposit_bank_memo",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            ledgerAccountExternalId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            ledgerAccountId: PgBuildColumn<
                                "deposit_bank_memo",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            memo: PgBuildColumn<
                                "deposit_bank_memo",
                                SetHasGenerated<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: true;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            name: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            organizationExternalId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            organizationId: PgBuildColumn<
                                "deposit_bank_memo",
                                PgIntegerBuilder,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...)
                                    | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "deposit_bank_memo";
                                },
                            >;
                            productExternalId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            productId: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            sourceCurrency: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            type: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "deposit_bank_memo",
                                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: "deposit_bank_memo";
                                },
                            >;
                        };
                        dialect: "pg";
                        isAlias: false;
                        name: "deposit_bank_memo";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        productIds?: string[];
        sourceCurrencies?: string[];
        tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (DepositBankMemo & { customerId: string; entityId: string })[];
            total: number;
        };
    },
>
Parameters
- __namedParameters: {
      addresses?: string[];
      createdAt?: DbTimestampCriteria;
      customerId?: string;
      entityIds?: string[];
      frequencies?: ("ONE_TIME" | "RECURRING")[];
      ids?: string[];
      includeDeleted?: boolean;
      ledgerAccountIds?: string[];
      orderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          address: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          bankAccountExternalId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          bankAccountId: PgBuildColumn<
                              "deposit_bank_memo",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          bankId: PgBuildColumn<
                              "deposit_bank_memo",
                              SetNotNull<Set$Type<(...), (...)>>,
                              {
                                  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: "deposit_bank_memo";
                              },
                          >;
                          chain: PgBuildColumn<
                              "deposit_bank_memo",
                              Set$Type<SetNotNull<(...)>, "SOLANA">,
                              {
                                  data: "SOLANA";
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          consumedAt: PgBuildColumn<
                              "deposit_bank_memo",
                              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: false;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          customerExternalId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          customerId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          deletedAt: PgBuildColumn<
                              "deposit_bank_memo",
                              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: false;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          id: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          identityExternalId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          identityId: PgBuildColumn<
                              "deposit_bank_memo",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          ledgerAccountExternalId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          ledgerAccountId: PgBuildColumn<
                              "deposit_bank_memo",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          memo: PgBuildColumn<
                              "deposit_bank_memo",
                              SetHasGenerated<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: true;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          name: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          organizationExternalId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          organizationId: PgBuildColumn<
                              "deposit_bank_memo",
                              PgIntegerBuilder,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...)
                                  | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "deposit_bank_memo";
                              },
                          >;
                          productExternalId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          productId: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          sourceCurrency: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          type: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "deposit_bank_memo",
                              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: "deposit_bank_memo";
                              },
                          >;
                      };
                      dialect: "pg";
                      isAlias: false;
                      name: "deposit_bank_memo";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[];
      page?: number;
      pageSize?: number;
      productIds?: string[];
      sourceCurrencies?: string[];
      tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>;
      updatedAt?: DbTimestampCriteria;
  }
  - Optionaladdresses?: string[]
  - OptionalcreatedAt?: DbTimestampCriteria
  - OptionalcustomerId?: string
  - OptionalentityIds?: string[]
  - Optionalfrequencies?: ("ONE_TIME" | "RECURRING")[]
  - Optionalids?: string[]
  - OptionalincludeDeleted?: boolean
  - OptionalledgerAccountIds?: string[]
  - OptionalorderBy?: DbOrderByCriterion<
        Omit<
            PgTableWithColumns<
                {
                    columns: {
                        address: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        bankAccountExternalId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        bankAccountId: PgBuildColumn<
                            "deposit_bank_memo",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        bankId: PgBuildColumn<
                            "deposit_bank_memo",
                            SetNotNull<Set$Type<(...), (...)>>,
                            {
                                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: "deposit_bank_memo";
                            },
                        >;
                        chain: PgBuildColumn<
                            "deposit_bank_memo",
                            Set$Type<SetNotNull<(...)>, "SOLANA">,
                            {
                                data: "SOLANA";
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        consumedAt: PgBuildColumn<
                            "deposit_bank_memo",
                            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: false;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        createdAt: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        customerExternalId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        customerId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        deletedAt: PgBuildColumn<
                            "deposit_bank_memo",
                            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: false;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        id: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        identityExternalId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        identityId: PgBuildColumn<
                            "deposit_bank_memo",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        ledgerAccountExternalId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        ledgerAccountId: PgBuildColumn<
                            "deposit_bank_memo",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        memo: PgBuildColumn<
                            "deposit_bank_memo",
                            SetHasGenerated<SetNotNull<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: true;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        name: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        organizationExternalId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        organizationId: PgBuildColumn<
                            "deposit_bank_memo",
                            PgIntegerBuilder,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...)
                                | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "deposit_bank_memo";
                            },
                        >;
                        productExternalId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        productId: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        sourceCurrency: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        type: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                        updatedAt: PgBuildColumn<
                            "deposit_bank_memo",
                            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: "deposit_bank_memo";
                            },
                        >;
                    };
                    dialect: "pg";
                    isAlias: false;
                    name: "deposit_bank_memo";
                    schema: "b2b";
                },
            >,
            "enableRLS",
        >,
        "createdAt"
        | "updatedAt",
    >[]
  - Optionalpage?: number
    
    Defaults to 1
  - OptionalpageSize?: number
    
    Defaults to 10
  - OptionalproductIds?: string[]
  - OptionalsourceCurrencies?: string[]
  - Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>
  - OptionalupdatedAt?: DbTimestampCriteria
Returns Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (DepositBankMemo & { customerId: string; entityId: string })[];
            total: number;
        };
    },
>
- Defined in packages/bank-memo-services/src/DepositBankMemoAdminService.ts:113

Class DepositBankMemoAdminQueryService

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns DepositBankMemoAdminQueryService

Properties

`Protected` `Readonly`bankAdminService

`Protected` `Readonly`db

`Static`instance

Methods

get

Parameters

Returns Promise<
    {
        ok: true;
        value: | (DepositBankMemo & { entityId: string; customerId: string; })
        | null;
    },
>

`Protected`resolveBanks

Parameters

Returns Promise<Map<string, Bank>>

search

Parameters

`Optional`addresses?: string[]

`Optional`createdAt?: DbTimestampCriteria

`Optional`customerId?: string

`Optional`entityIds?: string[]

`Optional`frequencies?: ("ONE_TIME" | "RECURRING")[]

`Optional`ids?: string[]

`Optional`includeDeleted?: boolean

`Optional`ledgerAccountIds?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`productIds?: string[]

`Optional`sourceCurrencies?: string[]

`Optional`tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

`Optional`updatedAt?: DbTimestampCriteria

Returns Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (DepositBankMemo & { customerId: string; entityId: string })[];
            total: number;
        };
    },
>

Settings

On This Page

Class DepositBankMemoAdminQueryService

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns DepositBankMemoAdminQueryService

Properties

Protected ReadonlybankAdminService

Protected Readonlydb

Staticinstance

Methods

get

Parameters

Returns Promise< { ok: true; value: | (DepositBankMemo & { entityId: string; customerId: string; }) | null; },>

ProtectedresolveBanks

Parameters

Returns Promise<Map<string, Bank>>

search

Parameters

Optionaladdresses?: string[]

OptionalcreatedAt?: DbTimestampCriteria

OptionalcustomerId?: string

OptionalentityIds?: string[]

Optionalfrequencies?: ("ONE_TIME" | "RECURRING")[]

Optionalids?: string[]

OptionalincludeDeleted?: boolean

OptionalledgerAccountIds?: string[]

Optionalpage?: number

OptionalpageSize?: number

OptionalproductIds?: string[]

OptionalsourceCurrencies?: string[]

Optionaltx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

OptionalupdatedAt?: DbTimestampCriteria

Returns Promise< { ok: true; value: { hasNext: boolean; items: (DepositBankMemo & { customerId: string; entityId: string })[]; total: number; }; },>

Settings

On This Page

`Protected` `Readonly`bankAdminService

`Protected` `Readonly`db

`Static`instance

Returns Promise<
{
ok: true;
value: | (DepositBankMemo & { entityId: string; customerId: string; })
| null;
},
>

`Protected`resolveBanks

`Optional`addresses?: string[]

`Optional`createdAt?: DbTimestampCriteria

`Optional`customerId?: string

`Optional`entityIds?: string[]

`Optional`frequencies?: ("ONE_TIME" | "RECURRING")[]

`Optional`ids?: string[]

`Optional`includeDeleted?: boolean

`Optional`ledgerAccountIds?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`productIds?: string[]

`Optional`sourceCurrencies?: string[]

`Optional`tx?: PgAsyncTransaction<NodePgQueryResultHKT, EmptyRelations>

`Optional`updatedAt?: DbTimestampCriteria

Returns Promise<
{
ok: true;
value: {
hasNext: boolean;
items: (DepositBankMemo & { customerId: string; entityId: string })[];
total: number;
};
},
>