protected function unlinkArtistFromAlbums($artistid) { $sql = "DELETE FROM artist_album WHERE artist_id=:artist_id"; $command = Artist::model()->getDbConnection()->createCommand($sql); $command->bindValues(array(":artist_id" => $artistid)); $command->execute(); return true; }
/** * 返回基于主键值的数据模型,主键值由 GET 变量提供。 * 若数据模型没有找到,一个 HTTP 异常被唤起。 */ public function loadModel() { if ($this->_model === null) { if (isset($_GET['id'])) { if (Yii::app()->user->name == "admin") { $condition = ''; } else { $condition = 'proved=' . Artist::STATUS_PROVED; } $this->_model = Artist::model()->findbyPk($_GET['id'], $condition); } if ($this->_model === null) { throw new CHttpException(404, '您所请求的页面不存在。'); } } return $this->_model; }
public function run() { $model = new Album(); if (isset($_GET['artist_id'])) { $artist_id = $_GET['artist_id']; $artist_info = Artist::model()->findByPk($artist_id); $model->artist_id = $artist_id; } // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Album'])) { $model->attributes = $_POST['Album']; $model->image = CUploadedFile::getInstance($model, 'image'); if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } $this->render('create', array('model' => $model)); }
public function run($region = 1, $type = 2) { $criteria = new CDbCriteria(); $criteria->condition = 'proved=:proved'; $criteria->params = array(':proved' => Artist::STATUS_PROVED); $criteria->order = "sort ASC,add_time DESC"; $criteria->group = 'sort,id'; $region = (int) $region; $type = (int) $type; $criteria->addSearchCondition('area_id', $region); $criteria->addSearchCondition('type_id', $type); $rawData = Artist::model()->findAll($criteria); $value = Yii::app()->cache->get('ARTISTS_' . $region . '_' . $type); if ($value === false) { $dataProvider = new CArrayDataProvider($rawData, array('id' => 'artist', 'pagination' => array('pageSize' => 500))); Yii::app()->cache->set('ARTISTS_' . $region . '_' . $type, $dataProvider, 10); } else { $dataProvider = $value; } $regionData = ArtistArea::model()->findByPk($region); $typeData = ArtistType::model()->findByPk($type); $this->render('index', array('dataProvider' => $dataProvider, 'region' => $region, 'type' => $type, 'regionData' => $regionData, 'typeData' => $typeData)); }
/** * 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 Artist the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Artist::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
protected function afterFind() { parent::afterFind(); $this->_tags = $this->_oldTags = ItemsTags::returnTagsString(ItemsTags::ARTIST_TYPE, $this->id); Artist::model()->updateCounters(array('click' => 1), 'id=:id', array(':id' => $this->id)); }