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 actionImv() { $url = "http://" . Yii::app()->params['bucket'] . "." . Yii::app()->params['domain'] . "/"; $uid = Yii::app()->session['uid']; $mvModel = new Mv(); $mvInfo = $mvModel->findAllBySql("select * from {{mv}} where userid = {$uid} order by sort asc "); $data = array('mvInfo' => $mvInfo, 'url' => $url); $this->render("imv", $data); }