Пример #1
0
    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer $id the ID of the model to be loaded
     * @return User the loaded model
     * @throws CHttpException
     */
    public function loadAdverts($id) {
        $model = Adverts::model()->findByPk($id);
        if ($model === null) {
            throw new CHttpException(404, 'The requested page does not exist.');
        }

        return $model;
    }
Пример #2
0
 static function getCategories()
 {
     // поставить кэширование запроса и обработку fields
     $categories = Yii::app()->db->createCommand('SELECT * FROM category')->queryAll();
     $ret_cat = array();
     foreach ($categories as $n => $cat) {
         $ret_cat[$cat['id']] = $cat;
         $ret_cat[$cat['id']]['fields'] = json_decode($cat['fields'], true);
         if (is_array($ret_cat[$cat['id']]['fields'])) {
             foreach ($ret_cat[$cat['id']]['fields'] as $f_n => $field) {
                 if ($field['type'] == 2) {
                     $ret_cat[$cat['id']]['fields'][$f_n]['atr'] = explode(",", $field['atr']);
                 }
             }
         }
     }
     $cat_count = Yii::app()->db->createCommand()->select('category_id, COUNT(*) count')->from(Adverts::model()->tableName())->group('category_id')->query();
     foreach ($cat_count as $row) {
         $ret_cat[$row['category_id']]['count'] = $row['count'];
     }
     return $ret_cat;
 }
Пример #3
0
 public function actionBan($id)
 {
     $model = $this->loadModel($id);
     $model->status = USER::STATUS_BANNED;
     $model->update(array('status'));
     //$adv_model = new Adverts();
     $adv_model = Adverts::model()->find("user_id = :id ", array(':id' => intval($id)));
     if ($adv_model) {
         $adv_model->delete();
     }
     $this->redirect(array('/'));
 }
Пример #4
0
 /**
  * Вывод главной
  * отличается наличием виджета категорий вверху
  */
 public function actionIndex() {
     $roots = Category::model()->roots()->findAll();
     $criteria = new CDbCriteria();
     $criteria->limit = 10;
     $criteria->order = 'id desc';
     $IndexAdv = Adverts::model()->findAll($criteria);
     $this->render('index', array(
         'roots' => $roots,
         'IndexAdv' => $IndexAdv,
     ));
 }