Description and parameters

 array arOrder = array(),
 array arFilter = array(),
 array arGroupBy = false,
 array arNavStartParams = false,
 array arSelectFields = array()

Method returns a selection of entries from payment system handlers according to its parameters. Non-static method.

Call parameters

arOrder Array, according to which resulting parameters are sorted. Array looks as follows:
"field_name1" => "sort_direction1",
"field_name2" => "sort_direction2",
. . .
Any field can be inserted as the "field_nameN" for payment system handlers. And "sort_directionX" can have values "ASC" (by ascension) and "DESC" (by descension).

In case the sort array have several elements, the resulting set is sorted by each element (i. e. first sorts by the first element and then result is sorted by the second element, etc.). 

Default value - empty array(), in indicating that result won't be sorted.
arFilter Array, according to which the payment system entries are filtered. Array looks as follows:
"[modifier1][operator1]field_name1" => "value1",
"[modifier2][operator2]field_name2" => "value2",
. . .
Entries that satisfy the filter are returned in the result and entries that do not satisfy the filter conditions are ignored.

The following modifiers are permissible:
  • ! - negation;
  • + - null, 0 and empty string values also satisfy the filter conditions.
The following operators are permitted:
  • >= - field value is higher or equal to value passed to filter;
  • > - field value is strict higher that value passed to filter;
  • <= - field value is lesser or equal to value passed to filter;
  • < - field value is strictly less than value passed to filter;
  • @ - field value is located in the comma-separated list with values passed to filter;
  • ~ - field value is checked for match to the value passed to template filter;
  • % - field value is checked for match to string passed to filter according to query language.
"field_name" can have any field for orders.

Filter example:
array("!PERSON_TYPE_ID" => 5)
This filter indicates "select all entries with PERSON_TYPE_ID values (payer type code) is not equal to 5".

Default value - empty array() - indicates that result won't be filtered.
arGroupBy Array with fields used to group entries of payment system handlers. Looks as follows:
      "group_function1" => " field_name2", ...)
"field_nameN" can contain any field for payment system handlers. Group function can have:
  • COUNT - count;
  • AVG - calculation of average value;
  • MIN - calculation of minimum value;
  • MAX - calculation of maximum value;
  • SUM - calculation of total.
This filter indicates "select all records with the field value LID (system site) is not en".

Default value - false - no grouping of results.
arNavStartParams Array with selection parameters. Can contain the following keys:
  • "nTopCount" - limits the number of entries/records, returned by the method;
  • any key, received by the method CDBResult::NavQuery as the third parameter.
Default value - false - indicates empty selection parameters.
arSelectFields Array with fields to be returned by the method. Can contain only the required fields. In case the array has the value for "*", returns all available fields.

Default value - array is empty array() - returns all fields of query main table.

Returned values

Returns CDBResult class object, containing associative arrays with payment system handler parameters with the following keys:

Key Description
ID Payment system handler code.
PAY_SYSTEM_ID Payment system code.
PERSON_TYPE_ID Payer type code.
NAME Payment system name.
ACTION_FILE Payment system script.
RESULT_FILE Result retrieval script.
NEW_WINDOW Flag (Y/N) to open payment system script in a new window.
PARAMS Handler call parameters.
HAVE_PAYMENT Available handler option for processing after order checkout.
HAVE_ACTION Available handler option for instant money transfer.
HAVE_RESULT Available result retrieving script.
HAVE_PREPAY Available handler option for processing order checkout.
PS_LID Payment system site.
PS_CURRENCY Payment system currency.
PS_NAME Payment system name.
PS_ACTIVE Payment system activity.
PS_SORT Payment system sort index.
PS_DESCRIPTION Payment system description.
PT_LID Payer type site.
PT_NAME Payer type name.
PT_SORT Payer type sort index.

In case empty array is passed as arGroupBy parameter, the method returns the number of entries, satisfying the filter.

© «Bitrix24», 2001-2023