/**
* Get all possible tags with models count for each for this model class.
*
* @param CDbCriteria $criteria
* @return array
*/
public function getAllTagsWithModelsCount($criteria = null)
{
if (!($tags = $this->cache->get('Taggable' . $this->getOwner()->tableName() . 'AllWithCount'))) {
// getting associated tags
$builder = $this->getOwner()->getCommandBuilder();
$tagsCriteria = new CDbCriteria();
if ($this->tagTableCount !== null) {
$tagsCriteria->select = sprintf("t.%s as `name`, %s as `count`", $this->tagTableName, $this->tagTableCount);
} else {
$tagsCriteria->select = sprintf("t.%s as `name`, count(*) as `count`", $this->tagTableName);
$tagsCriteria->join = sprintf("JOIN `%s` et ON t.{$this->tagTablePk} = et.%s", $this->getTagBindingTableName(), $this->tagBindingTableTagId);
$tagsCriteria->group = 't.' . $this->tagTablePk;
}
if ($criteria !== null) {
$tagsCriteria->mergeWith($criteria);
}
if ($this->getScopeCriteria()) {
$tagsCriteria->wergeWith($this->getScopeCriteria());
}
$tags = $builder->createFindCommand($this->tagTable, $tagsCriteria)->queryAll();
$this->cache->set('Taggable' . $this->getOwner()->tableName() . 'AllWithCount', $tags);
}
return $tags;
}