Пример #1
0
 public function actionIndex()
 {
     $artistLists = array();
     $criteria = new CDbCriteria();
     $criteria->addCondition('`on` = 1');
     $criteria->order = 'view desc';
     $artistLists = ShowArtist::model()->findAll($criteria);
     $this->render('index');
 }
Пример #2
0
 public function actionList()
 {
     $artistLists = $category_info = $category_resource_info = array();
     $category_id = Yii::app()->request->getParam('category_id', 0);
     if ($category_id) {
         $category_info = ShowCategory::model()->find('id =:id', array(':id' => $category_id));
         $category_resource_info = ShowResource::model()->find('id =:id', array(':id' => $category_info->source_id));
         $artistIds = array();
         $criteria = new CDbCriteria();
         $criteria->condition = 'category_id =:category_id';
         $criteria->params = array(':category_id' => $category_id);
         $artistRelativeIds = ShowCategoryRelative::model()->findAll($criteria);
         foreach ($artistRelativeIds as $artistRelativeId) {
             $artistIds[] = $artistRelativeId->artist_id;
         }
         $criteria = new CDbCriteria();
         $criteria->addInCondition('id', $artistIds);
         $criteria->addCondition('`on` = 1');
         $criteria->order = 'view desc';
         $artistLists = ShowArtist::model()->findAll($criteria);
     }
     $this->render('list', array('artistLists' => $artistLists, 'category_info' => $category_info, 'category_resource_info' => $category_resource_info));
 }