InvoiceSumStatisticsTable::synchronizeSumFields

  1. Bitrix24 API (v. 23.675.0)
  2. crm
  3. InvoiceSumStatisticsTable
  4. synchronizeSumFields
  • Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/statistics/entity/invoicesumstatistics.php
  • Класс: Bitrix\Crm\Statistics\Entity\InvoiceSumStatisticsTable
  • Вызов: InvoiceSumStatisticsTable::synchronizeSumFields
static function synchronizeSumFields($ownerID, array $data)
{
	if(!is_int($ownerID))
	{
		$ownerID = (int)$ownerID;
	}

	if($ownerID <= 0)
	{
		throw new Main\ArgumentException('Owner ID must be greater than zero.', 'ownerID');
	}

	$sumTotal = isset($data['SUM_TOTAL']) ? (double)$data['SUM_TOTAL'] : 0.0;
	$sum1 = isset($data['UF_SUM_1']) ? (double)$data['UF_SUM_1'] : 0.0;
	$sum2 = isset($data['UF_SUM_2']) ? (double)$data['UF_SUM_2'] : 0.0;
	$sum3 = isset($data['UF_SUM_3']) ? (double)$data['UF_SUM_3'] : 0.0;
	$sum4 = isset($data['UF_SUM_4']) ? (double)$data['UF_SUM_4'] : 0.0;
	$sum5 = isset($data['UF_SUM_5']) ? (double)$data['UF_SUM_5'] : 0.0;

	Main\Application::getConnection()->queryExecute(
		"UPDATE b_crm_invoice_sum_stat SET 
			SUM_TOTAL = {$sumTotal}, UF_SUM_1 = {$sum1},
			UF_SUM_2 = {$sum2}, UF_SUM_3 = {$sum3},
			UF_SUM_4 = {$sum4}, UF_SUM_5 = {$sum5}
		WHERE OWNER_ID = {$ownerID}"
	);
}

Добавить комментарий