• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/widget/data/invoiceinwork.php
  • Класс: Bitrix\Crm\Widget\Data\InvoiceInWork
  • Вызов: InvoiceInWork::prepareEntityListFilter
public function prepareEntityListFilter(array $filterParams)
{
	$filter = self::internalizeFilter($filterParams);
	$period = $filter->getPeriod();
	$periodStartDate = $period['START'];
	$periodEndDate = $period['END'];
	$responsibleIDs = $filter->getResponsibleIDs();

	$semanticID = PhaseSemantics::UNDEFINED;
	$fieldName = isset($filterParams['FIELD']) ? $filterParams['FIELD'] : '';
	if($fieldName === 'COUNT_OWED' || $fieldName === 'SUM_OWED_TOTAL')
	{
		$semanticID = PhaseSemantics::PROCESS;
		//Start period is not used in OWED category - we look backward to start
		$periodStartDate = null;
	}

	$query = self::prepareHistoryQuery($periodStartDate, $periodEndDate, $responsibleIDs, $semanticID);
	$query->addSelect('OWNER_ID');

	$sqlQuery = $query->getQuery();
	return array('__CONDITIONS' => array(array('SQL' => 'crm_invoice_internals_invoice.ID IN('.$sqlQuery.')')));
}