Class EscrowTransferAdminQueryService

Read-only admin queries for escrow transfers. No customerId arg — callers (workflows, internal tooling) operate cross-customer.

See

EscrowTransferService for the customer-scoped surface.

Hierarchy (View Summary)

EscrowTransferAdminQueryService
- EscrowTransferAdminService

Index

Constructors

constructor

Properties

Methods

get search

Constructors

constructor

new EscrowTransferAdminQueryService(
__namedParameters: { db: B2bDatabase },
): EscrowTransferAdminQueryService
Parameters
- __namedParameters: { db: B2bDatabase }
Returns EscrowTransferAdminQueryService
- Defined in packages/escrow-transfer-services/src/EscrowTransferAdminService.ts:109

Properties

`Protected` `Readonly`db

db: B2bDatabase

Methods

get

get(__namedParameters: { id: string }): Promise<EscrowTransfer | null>
Look up a single escrow transfer by id across all customers. Returns null when no row matches — per the repo "get returns T | null" rule, a missing row is not a ServiceError.
Parameters
- __namedParameters: { id: string }
Returns Promise<EscrowTransfer | null>
- Defined in packages/escrow-transfer-services/src/EscrowTransferAdminService.ts:118

search

search(
    __namedParameters?: {
        createdAt?: DbTimestampCriteria;
        customerIds?: string[];
        expiresAt?: DbTimestampCriteria;
        ids?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            amount: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            claimShortUrlId: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            claimSmsSentAt: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            claimUrl: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            escrowStateAccount: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            expiresAt: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            history: PgBuildColumn<
                                "escrow_transfer",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: (...)[];
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "escrow_transfer";
                                },
                            >;
                            id: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            legacyTransactionId: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            message: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            metadata: PgBuildColumn<
                                "escrow_transfer",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: EscrowTransferMetadata;
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "escrow_transfer";
                                },
                            >;
                            nonce: PgBuildColumn<
                                "escrow_transfer",
                                SetNotNull<PgBigInt64Builder>,
                                {
                                    data: bigint;
                                    dataType: "bigint int64";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "escrow_transfer";
                                },
                            >;
                            recipientExternalId: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            recipientPhone: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            recipientWallet: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            senderExternalId: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            senderWallet: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            status: PgBuildColumn<
                                "escrow_transfer",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: EscrowTransferStatus;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "escrow_transfer";
                                },
                            >;
                            terminalSmsSentAt: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            tokenSymbol: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "escrow_transfer",
                                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: "escrow_transfer";
                                },
                            >;
                        };
                        dialect: "pg";
                        name: "escrow_transfer";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        page?: number;
        pageSize?: number;
        recipientId?: string;
        recipientPhone?: string;
        senderId?: string;
        statuses?: EscrowTransferStatus[];
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: { hasNext: boolean; items: EscrowTransfer[]; total: number };
    },
>
Admin search across all customers. Mirrors the customer-scoped EscrowTransferService.search shape with a plural customerIds filter.
Parameters
- __namedParameters: {
      createdAt?: DbTimestampCriteria;
      customerIds?: string[];
      expiresAt?: DbTimestampCriteria;
      ids?: string[];
      orderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          amount: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          claimShortUrlId: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          claimSmsSentAt: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          claimUrl: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          customerId: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          escrowStateAccount: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          expiresAt: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          history: PgBuildColumn<
                              "escrow_transfer",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: (...)[];
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "escrow_transfer";
                              },
                          >;
                          id: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          legacyTransactionId: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          message: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          metadata: PgBuildColumn<
                              "escrow_transfer",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: EscrowTransferMetadata;
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "escrow_transfer";
                              },
                          >;
                          nonce: PgBuildColumn<
                              "escrow_transfer",
                              SetNotNull<PgBigInt64Builder>,
                              {
                                  data: bigint;
                                  dataType: "bigint int64";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "escrow_transfer";
                              },
                          >;
                          recipientExternalId: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          recipientPhone: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          recipientWallet: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          senderExternalId: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          senderWallet: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          status: PgBuildColumn<
                              "escrow_transfer",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: EscrowTransferStatus;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "escrow_transfer";
                              },
                          >;
                          terminalSmsSentAt: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          tokenSymbol: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "escrow_transfer",
                              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: "escrow_transfer";
                              },
                          >;
                      };
                      dialect: "pg";
                      name: "escrow_transfer";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[];
      page?: number;
      pageSize?: number;
      recipientId?: string;
      recipientPhone?: string;
      senderId?: string;
      statuses?: EscrowTransferStatus[];
      updatedAt?: DbTimestampCriteria;
  } = {}
  - OptionalcreatedAt?: DbTimestampCriteria
  - OptionalcustomerIds?: string[]
  - OptionalexpiresAt?: DbTimestampCriteria
  - Optionalids?: string[]
  - OptionalorderBy?: DbOrderByCriterion<
        Omit<
            PgTableWithColumns<
                {
                    columns: {
                        amount: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        claimShortUrlId: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        claimSmsSentAt: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        claimUrl: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        createdAt: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        customerId: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        escrowStateAccount: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        expiresAt: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        externalId: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        history: PgBuildColumn<
                            "escrow_transfer",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                data: (...)[];
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "escrow_transfer";
                            },
                        >;
                        id: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        legacyTransactionId: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        message: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        metadata: PgBuildColumn<
                            "escrow_transfer",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                data: EscrowTransferMetadata;
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "escrow_transfer";
                            },
                        >;
                        nonce: PgBuildColumn<
                            "escrow_transfer",
                            SetNotNull<PgBigInt64Builder>,
                            {
                                data: bigint;
                                dataType: "bigint int64";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "escrow_transfer";
                            },
                        >;
                        recipientExternalId: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        recipientPhone: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        recipientWallet: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        senderExternalId: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        senderWallet: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        status: PgBuildColumn<
                            "escrow_transfer",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                data: EscrowTransferStatus;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "escrow_transfer";
                            },
                        >;
                        terminalSmsSentAt: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        tokenSymbol: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                        updatedAt: PgBuildColumn<
                            "escrow_transfer",
                            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: "escrow_transfer";
                            },
                        >;
                    };
                    dialect: "pg";
                    name: "escrow_transfer";
                    schema: "b2b";
                },
            >,
            "enableRLS",
        >,
        "createdAt"
        | "updatedAt",
    >[]
  - Optionalpage?: number
    Defaults to 1
  - OptionalpageSize?: number
    Defaults to 50
  - OptionalrecipientId?: string
  - OptionalrecipientPhone?: string
  - OptionalsenderId?: string
  - Optionalstatuses?: EscrowTransferStatus[]
  - OptionalupdatedAt?: DbTimestampCriteria
Returns Promise<
    {
        ok: true;
        value: { hasNext: boolean; items: EscrowTransfer[]; total: number };
    },
>
- Defined in packages/escrow-transfer-services/src/EscrowTransferAdminService.ts:131

Class EscrowTransferAdminQueryService

See

Hierarchy (View Summary)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns EscrowTransferAdminQueryService

Properties

`Protected` `Readonly`db

Methods

get

Parameters

Returns Promise<EscrowTransfer | null>

search

Parameters

`Optional`createdAt?: DbTimestampCriteria

`Optional`customerIds?: string[]

`Optional`expiresAt?: DbTimestampCriteria

`Optional`ids?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`recipientId?: string

`Optional`recipientPhone?: string

`Optional`senderId?: string

`Optional`statuses?: EscrowTransferStatus[]

`Optional`updatedAt?: DbTimestampCriteria

Returns Promise<
    {
        ok: true;
        value: { hasNext: boolean; items: EscrowTransfer[]; total: number };
    },
>

Settings

On This Page

Class EscrowTransferAdminQueryService

See

Hierarchy (View Summary)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns EscrowTransferAdminQueryService

Properties

Protected Readonlydb

Methods

get

Parameters

Returns Promise<EscrowTransfer | null>

search

Parameters

OptionalcreatedAt?: DbTimestampCriteria

OptionalcustomerIds?: string[]

OptionalexpiresAt?: DbTimestampCriteria

Optionalids?: string[]

Optionalpage?: number

OptionalpageSize?: number

OptionalrecipientId?: string

OptionalrecipientPhone?: string

OptionalsenderId?: string

Optionalstatuses?: EscrowTransferStatus[]

OptionalupdatedAt?: DbTimestampCriteria

Returns Promise< { ok: true; value: { hasNext: boolean; items: EscrowTransfer[]; total: number }; },>

Settings

On This Page

`Protected` `Readonly`db

`Optional`createdAt?: DbTimestampCriteria

`Optional`customerIds?: string[]

`Optional`expiresAt?: DbTimestampCriteria

`Optional`ids?: string[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`recipientId?: string

`Optional`recipientPhone?: string

`Optional`senderId?: string

`Optional`statuses?: EscrowTransferStatus[]

`Optional`updatedAt?: DbTimestampCriteria

Returns Promise<
{
ok: true;
value: { hasNext: boolean; items: EscrowTransfer[]; total: number };
},
>