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