How to display the number of paid orders?

Question

1C-Bitrix

It is necessary for each user to display the number of paid orders (not the orders themselves, but only the total number). How can you do?

Answer 1

Use the new kernel :)

Bitrix\Main\Loader::includeModule('sale');

$orders = Bitrix\Sale\OrderTable::getList([
    'filter' => [
        'PAYED' => 'Y'
    ],
    'group' => ['USER_ID'],
    'select' => ['USER_ID', 'CNT'],
    'runtime' => [
        new Bitrix\Main\Entity\ExpressionField('CNT', 'COUNT(*)')
    ]
])->fetchAll();

Answer 2

$arFilter = array("USER_ID" => $USER->GetID(), 'PAYED' => 'Y');
$rsOrders = CSaleOrder::GetList(array('ID' => 'DESC'), $arFilter, array('PAYED', 'SUM' => 'PRICE'));
$arOrder = $rsOrder->Fetch();
echo $arOrder['CNT'];