DealInvoiceStatistics::prepareEntityListFilter

  1. Bitrix24 API (v. 23.675.0)
  2. crm
  3. DealInvoiceStatistics
  4. prepareEntityListFilter
  • Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/widget/data/dealinvoicestatistics.php
  • Класс: Bitrix\Crm\Widget\Data\DealInvoiceStatistics
  • Вызов: DealInvoiceStatistics::prepareEntityListFilter
public function prepareEntityListFilter(array $filterParams)
{
	$filter = self::internalizeFilter($filterParams);

	$query = new Query(DealInvoiceStatisticsTable::getEntity());
	$query->addSelect('OWNER_ID');
	$query->setTableAliasPostfix('_s2');

	$subQuery = new Query(DealInvoiceStatisticsTable::getEntity());
	$subQuery->setTableAliasPostfix('_s1');
	$subQuery->addSelect('OWNER_ID');

	$period = $filter->getPeriod();
	$periodStartDate = $period['START'];
	$periodEndDate = $period['END'];

	$subQuery->addFilter('>=END_DATE', $periodStartDate);
	$subQuery->addFilter('<=START_DATE', $periodEndDate);

	$responsibleIDs = $filter->getResponsibleIDs();
	if(!empty($responsibleIDs))
	{
		$subQuery->addFilter('@RESPONSIBLE_ID', $responsibleIDs);
	}

	$semanticID = $filter->getExtraParam('semanticID', PhaseSemantics::UNDEFINED);
	if($semanticID !== PhaseSemantics::UNDEFINED)
	{
		$subQuery->addFilter('=STAGE_SEMANTIC_ID', $semanticID);
	}

	$categoryID = (int)$filter->getExtraParam('dealCategoryID', -1);
	if($categoryID >= 0)
	{
		//HACK: use SqlExpression to avoid filter sql like (CATEGORY_ID IS NULL OR CATEGORY_ID = 0), that cause the filesort.
		$subQuery->addFilter('=CATEGORY_ID', new Main\DB\SqlExpression('?i', $categoryID));
	}

	$subQuery->addGroup('OWNER_ID');
	$subQuery->addSelect('MAX_CREATED_DATE');
	$subQuery->registerRuntimeField('', new ExpressionField('MAX_CREATED_DATE', 'MAX(CREATED_DATE)'));

	$query->registerRuntimeField('',
		new ReferenceField('M',
			Base::getInstanceByQuery($subQuery),
			array('=this.OWNER_ID' => 'ref.OWNER_ID', '=this.CREATED_DATE' => 'ref.MAX_CREATED_DATE'),
			array('join_type' => 'INNER')
		)
	);

	$field = isset($filterParams['FIELD']) ? $filterParams['FIELD'] : '';
	if($field === 'TOTAL_INVOICE_SUM' || $field === 'TOTAL_OWED')
	{
		//$query->addFilter("!={$field}", 0);
		$query->addFilter("!={$field}", new Main\DB\SqlExpression('?i', 0));
	}

	return array(
		'__JOINS' => array(
			array(
				'TYPE' => 'INNER',
				'SQL' => 'INNER JOIN('.$query->getQuery().') DS ON DS.OWNER_ID = L.ID'
			)
		)
	);
}

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