EmailAttachment::countEntityWithFile

public function countEntityWithFile()
{
	$count = -1;

	$query = $this->prepareQuery();

	if ($this->prepareFilter($query))
	{
		$count = 0;

		$query
			//->where('TYPE_ID', '=', \CCrmActivityType::Email)
			->registerRuntimeField(new ORM\Fields\ExpressionField('CNT', 'COUNT(%s)', 'ID'))
			->registerRuntimeField(new ORM\Fields\ExpressionField('CNTFL', 'IFNULL(%s,0) + IFNULL(%s,0)', ['FILE.FILE_COUNT', 'DISK_FILE.DISK_COUNT']))
			->addSelect('CNT')
			->addFilter('>CNTFL', 0);

		$res = $query->exec();
		if ($row = $res->fetch())
		{
			$count = $row['CNT'];
		}
	}

	return $count;
}