public function __construct() { // contructor starts parent::__construct(); $this->_playlistsearchQuery = filter_input(INPUT_POST, 'PlaylistssearchQuery'); $this->_addnewPlaylist = filter_input(INPUT_POST, 'playlistadd'); $this->_status = filter_input(INPUT_GET, 'status'); $this->_searchBtn = filter_input(INPUT_POST, 'playlistsearchbtn'); $this->_update = filter_input(INPUT_GET, 'update'); $this->_add = filter_input(INPUT_GET, 'add'); $this->_del = filter_input(INPUT_GET, 'del'); $this->_orderDirection = filter_input(INPUT_GET, 'order'); $this->_orderBy = filter_input(INPUT_GET, 'orderby'); }
public function actionDel() { $id = Yii::app()->request->getParam('id'); $listsong = PlaylistSongModel::model()->deleteAll('playlist_id = :pid', array(':pid' => $id)); try { $res = PlaylistModel::model()->findByPk($id); try { $res->delete(); echo '1'; } catch (Exception $ex) { echo '0'; } } catch (Exception $ex1) { echo '0'; } Yii::app()->end(); }
/** * Constructor starts */ public function __construct() { parent::__construct(); /** Get PlaylistssearchQuery from query parameters */ $this->_playlistsearchQuery = filter_input(INPUT_POST, 'PlaylistssearchQuery'); /** Get playlistadd from query parameters */ $this->_addnewPlaylist = filter_input(INPUT_POST, 'playlistadd'); /** Get status from query parameters */ $this->_status = filter_input(INPUT_GET, 'status'); /** Get playlistsearchbtn from query parameters */ $this->_searchBtn = filter_input(INPUT_POST, 'playlistsearchbtn'); /** Get update from query parameters */ $this->_update = filter_input(INPUT_GET, 'update'); /** Get add from query parameters */ $this->_add = filter_input(INPUT_GET, 'add'); /** Get del from query parameters */ $this->_del = filter_input(INPUT_GET, 'del'); /** Get order from query parameters */ $this->_orderDirection = filter_input(INPUT_GET, 'order'); /** Get orderby from query parameters */ $this->_orderBy = filter_input(INPUT_GET, 'orderby'); }
public function actionAddNewPlaylist() { $name = CHtml::encode(Yii::app()->request->getParam('name', 0)); $song_id = (int) Yii::app()->request->getParam('songId', 0); $phone = Yii::app()->user->getState('msisdn'); if (strlen($name) >= 80) { echo "3"; } else { $playlist_name = ucwords($name); //if( !preg_match('/^[0-9a-zA-Z_ ]+$/', $playlist_name) ){//ten playlistk dc su dung ky tu dac biet if (preg_match('/[\'\\/~`\\!@#\\$%\\^&\\*\\(\\)_\\-\\+=\\{\\}\\[\\]\\|;:"\\<\\>,\\.\\?\\\\]/', $playlist_name)) { echo '4'; $this->layout = false; Yii::app()->end(); } $list = PlaylistModel::model()->findAllByAttributes(array('msisdn' => $phone)); $listPl = CHtml::listData($list, 'name', 'name'); if (in_array($playlist_name, $listPl, true)) { echo "1"; // trung ten } else { $model = new PlaylistModel(); $model->name = $playlist_name; $model->url_key = Common::makeFriendlyUrl($name); $model->msisdn = Formatter::formatPhone($phone); $model->created_time = new CDbExpression('NOW()'); if ($model->insert()) { // check xem bai hat do da co chua? // $song_in_pl = WapPlaylistSongModel::model()->findByAttributes(array('playlist_id'=>$model->id,'song_id'=>$song_id)); $songInPl = PlaylistSongModel::model()->findAllByAttributes(array("playlist_id" => $model->id)); $listsong = CHtml::listData($songInPl, 'song_id', 'song_id'); if (!$listsong) { $playlist_song = new PlaylistSongModel(); $playlist_song->playlist_id = $model->id; $playlist_song->song_id = $song_id; $playlist_song->status = '1'; $ret = $playlist_song->save(); if ($ret) { echo '2'; } } } else { echo '0'; } } } $this->layout = false; Yii::app()->end(); }
public static function retrievePlaylist() { $response = json_encode(PlaylistModel::getPlaylistSongs()); echo $response; die; }