MngGetCashierCustomerProviderOverridesByFilter

Returns customer-level payment provider overrides in table format.

Overrides are used by CRM to explicitly allow or deny a payment provider for a specific customer, independently from the default country/currency eligibility rules. Hard checks still apply at runtime: provider module loaded, provider config enabled, brand match, account ownership, and account enabled.

Access

SESSION_MANAGER, SESSION_ADMIN, SESSION_DEALER, SESSION_CRM_MANAGER, SESSION_CRM_ADMIN.

Request Parameters

Supports the standard table filter object:

Name	Type	Required	Description
limit	int	No	Max rows, 1..50000
offset	int	No	Pagination offset
where	array	No	Filter expressions
whereNot	array	No	Negative filter expressions
whereIn	array	No	Inclusion filters
whereNotIn	array	No	Exclusion filters
whereBetween	array	No	Range filters
whereNotBetween	array	No	Negative range filters
orderBy	array	No	Sorting rules

Common filter fields: id, customer_id, provider_config_id, brand, provider, method, mode, enabled.

Request Example

{
  "command": "MngGetCashierCustomerProviderOverridesByFilter",
  "extID": "1",
  "data": {
    "where": [
      ["customer_id", "=", 5],
      ["brand", "=", "ion4"]
    ],
    "orderBy": [["id", "desc"]],
    "limit": 50,
    "offset": 0
  }
}

Response Fields

Name	Type	Description
rows	array	Override rows
count	int	Total matching rows

rows[]

Name	Type	Description
id	int	Override id
customer_id	int	Target customer id
brand	string	Brand scope
provider_config_id	int	Optional provider config id
provider	string	Provider code
method	string	Provider method marker
mode	int	0 allow, 1 deny
min_amount	double	Optional override minimum amount
max_amount	double	Optional override maximum amount
enabled	int	1 enabled, 0 disabled
reason	string	Internal reason code
comment	string	Manager comment
expires_time	int64	Optional expiration timestamp
created_time	int64	Creation timestamp
updated_time	int64	Last update timestamp

Response Example

{
  "rows": [
    {
      "id": 3,
      "customer_id": 5,
      "brand": "ion4",
      "provider_config_id": 1,
      "provider": "stripe",
      "method": "card",
      "mode": 0,
      "min_amount": 0.0,
      "max_amount": 0.0,
      "enabled": 1,
      "reason": "VIP_ALLOW",
      "comment": "Manual CRM allow",
      "expires_time": 0,
      "created_time": 1779270000,
      "updated_time": 1779270000
    }
  ],
  "count": 1
}