Effective::getCompletedCount

static function getCompletedCount(DateTime $dateFrom, DateTime $dateTo, $userId, $groupId)
{
	$query = new Query(TaskTable::getEntity());

	$query->setSelect([new EntityExpressionField('COUNT', 'COUNT(%s)', 'ID')]);

	if ($userId)
	{
		$query->registerRuntimeField('TM', new EntityReferenceField(
			'TM',
			MemberTable::getEntity(),
			Join::on('this.ID', 'ref.TASK_ID')
				->where('ref.USER_ID', $userId)
				->whereIn('ref.TYPE', ['R', 'A']),
			['join_type' => 'inner']
		));

		$query
			->where(
				Query::filter()
					->logic('or')
					->where(
						Query::filter()
							->where('TM.TYPE', 'R')
							->whereColumn('CREATED_BY', '<>', 'RESPONSIBLE_ID')
					)
					->where(
						Query::filter()
							->where('TM.TYPE', 'A')
							->where('CREATED_BY', '<>', $userId)
							->where('RESPONSIBLE_ID', '<>', $userId)
					)
			);
	}
	else
	{
		$query->whereColumn('CREATED_BY', '<>', 'RESPONSIBLE_ID');
	}

	$query
		->where('CLOSED_DATE', '>=', $dateFrom)
		->where('CLOSED_DATE', '<=', $dateTo)
		->where(($groupId? Query::filter()->where('GROUP_ID', $groupId) : []));

	$count = $query->exec()->fetch();

	return $count['COUNT'];
}