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;
}
