MngGetCashierTransactionsByFilter

Returns Cashier transactions using the standard BackOffice table filter format.

The response contains structure, rows, and count.

Access

SESSION_MANAGER, SESSION_ADMIN, SESSION_DEALER, SESSION_CRM_MANAGER, SESSION_CRM_ADMIN.

Request Parameters

Name	Type	Required	Description
limit	int	No	Page size, 1..50000
offset	int	No	Pagination offset
where	array	No	AND filters
whereNot	array	No	Negative filters
whereIn	array	No	Include-by-list filters
whereNotIn	array	No	Exclude-by-list filters
whereBetween	array	No	Range filters
whereNotBetween	array	No	Negative range filters
orderBy	array	No	Sort expression

Supported Filter Fields

Field	Type
id	int
customer_id	int
login	int
type	int
status	int
provider	string
method	string
currency	string
provider_payment_id	string
created_time	int64

Response Structure

Rows follow this structure order:

[
  "id",
  "customer_id",
  "login",
  "type",
  "provider",
  "method",
  "provider_payment_id",
  "amount",
  "currency",
  "status",
  "failure_reason",
  "created_time",
  "updated_time"
]

Request Example

{
  "command": "MngGetCashierTransactionsByFilter",
  "extID": "1",
  "data": {
    "limit": 50,
    "offset": 0,
    "where": [
      ["status", "=", 1],
      ["provider", "=", "stripe"]
    ],
    "orderBy": [
      ["created_time", "desc"]
    ]
  }
}

Response Example

{
  "structure": [
    "id",
    "customer_id",
    "login",
    "type",
    "provider",
    "method",
    "provider_payment_id",
    "amount",
    "currency",
    "status",
    "failure_reason",
    "created_time",
    "updated_time"
  ],
  "rows": [
    [
      15,
      5,
      2000009,
      0,
      "stripe",
      "card",
      "pi_123",
      250.0,
      "USD",
      1,
      "",
      1779270000,
      1779270000
    ]
  ],
  "count": 1
}