/** * Получение количества записей в категории * * @param $category * @return int|mixed */ public static function getTotalCountElement($category) { $total = 0; if (is_int($category)) { $category = CatalogRubrics::model()->findByPk($category); } if (!empty($category)) { $branch = CatalogRubrics::getBranch($category->left_key, $category->right_key); foreach ($branch as $branchRow) { $ids[] = $branchRow->id; } if (!empty($ids)) { $total = Yii::app()->db->createCommand()->select('COUNT(*)')->from(CatalogElements::model()->tableName())->where(array('in', 'parent_id', $ids))->queryScalar(); } } return $total; }