TemplateProvider::getCount

public function getCount($includeSubTemplates = false, array $arParams = []): int
{
	$this->configure([], [], [], $arParams, []);

	$tableName = DependencyTable::getTableName();
	$parentIdColumnName = DependencyTable::getPARENTIDColumnName();

	if (!$this->userId)
	{
		return 0;
	}

	$this->strSqlSelect = 'COUNT(DISTINCT TT.ID) AS CNT';
	$this->strFrom 		= 'FROM b_tasks_template TT';

	if (!$includeSubTemplates)
	{
		$this->strFrom .= "nLEFT JOIN " . $tableName . " TDD ON TT.ID = TDD.TEMPLATE_ID AND TDD.DIRECT = 1";
		$this->arSqlSearch[] = "TDD." . $parentIdColumnName . " IS NULL";
	}

	$this->makeAccessSql();
	$this->makeWhere();

	$query = $this->buildQuery();

	if ($dbRes = $this->db->Query($query, false, "File: ".__FILE__."
Line: ".__LINE__))
	{
		if ($arRes = $dbRes->Fetch())
		{
			return (int) $arRes["CNT"];
		}
	}

	return 0;
}