public function common($uid) { $result = array(); $menuModel = new Menu(); //顶部菜单/底部菜单 for ($i = 1; $i < 7; $i++) { $sql = "select * from {{menu}} where sort = {$i} and position = 1 and userid = {$uid} and pid = 0 "; $data["upmenu_{$i}"] = $menuModel->findBySql($sql); $sql = "select * from {{menu}} where sort = {$i} and position = 2 and userid = {$uid} and pid = 0"; $data["downmenu_{$i}"] = $menuModel->findBySql($sql); } //下拉菜单 $sql = "select * from {{menu}} where pid = (select id from {{menu}} where position = 1 and userid = {$uid} and sort = 3 and pid = 0) and position = 1 and userid = {$uid} order by sort asc "; $data["uplistmenu_3"] = $menuModel->findAllBySql($sql); //视频列表 $mvModel = new Mv(); $sql = "select * from {{mv}} where userid = {$uid} order by sort asc "; $data['mvlist'] = $mvModel->findAllBySql($sql); //音乐列表 // $songModel = new Song(); // $sql = "select * from {{song}} where userid = $uid order by sort asc "; // $data['musiclist'] = $songModel->findAllBySql($sql); //网站个性配置 $webModel = new Config(); $sql = "select * from {{webconfig}} where userid = {$uid} "; $data['webconfig'] = $webModel->findBySql($sql); $data['url'] = "http://" . Yii::app()->params['bucket'] . "." . Yii::app()->params['domain'] . "/"; $data['uid'] = $uid; return $data; }
public function actionDelmv($id) { Yii::import('application.vendors.*'); require_once 'Qiniu/rs.php'; require_once 'Qiniu/io.php'; $bucket = Yii::app()->params['bucket']; $accessKey = Yii::app()->params['accessKey']; $secretKey = Yii::app()->params['secretKey']; $mvModel = new Mv(); $mvInfo = $mvModel->findByPk($id); if ($mvInfo != NULL) { Qiniu_SetKeys($accessKey, $secretKey); $client = new Qiniu_MacHttpClient(null); $err = Qiniu_RS_Delete($client, $bucket, $mvInfo['mv']); } //上传业务数据库中数据 if ($mvModel->deleteByPk($id)) { Yii::app()->user->setFlash('delmvstatus', 'YES,删除视频成功 :)'); } else { Yii::app()->user->setFlash('delmvstatus', 'Sorry,系统出错,删除视频失败 :('); } $this->redirect(array("imv")); }