Example #1
0
 /**
  * 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->mergeWith($this->getScopeCriteria());
         }
         $tags = $builder->createFindCommand($this->tagTable, $tagsCriteria)->queryAll();
         $this->cache->set('Taggable' . $this->getOwner()->tableName() . 'AllWithCount', $tags);
     }
     return $tags;
 }