$id = isset($_REQUEST['id']) ? (int) $_REQUEST['id'] : '';
$act = isset($_REQUEST['act']) ? $_REQUEST['act'] : '';
$customer_id = (int) $_SESSION['customer_id'];
$info_type = 'music';
$data = array();
//delete
if ($act == 'del' && $id) {
Model_Table::get('InfoMusic')->delete("id='{$id}' and customer_id='{$customer_id}'");
Model_Table::get('KeywordList')->delete("info_id='{$id}' and customer_id='{$customer_id}' and info_type='{$info_type}'");
// js_alter('','/home/info/test.php');
header("location:/home/info/index.php?type=music");
die;
}
//method:add||modify
if ($id) {
$music_table = new Model_InfoMusic();
$data = $music_table->fetchRow("select * from info_music where id='{$id}' and customer_id='{$customer_id}'");
$smarty->assign('infoRow', $data);
}
//submit
if (method_is('post')) {
$data['customer_id'] = $customer_id;
$data['keyword'] = isset($_POST['keyword']) ? str_inmysql(str_replace(array(';', '，'), ',', $_POST['keyword'])) : '';
$data['cate_id'] = isset($_POST['cate_id']) ? (int) $_POST['cate_id'] : '';
$data['music_name'] = isset($_POST['music_name']) ? str_inmysql($_POST['music_name']) : '';
$data['music_url'] = isset($_POST['music_url']) ? str_inmysql($_POST['music_url']) : '';
$data['music_desc'] = isset($_POST['music_desc']) ? str_inmysql($_POST['music_desc']) : '';
$data['state'] = isset($_POST['state']) ? str_inmysql($_POST['state']) : '';
$data['create_date'] = date('Y-m-d H:i:s', $_WGT['TIME']);
if (!$data['keyword']) {
ajax_feedback(0, '1201');
public function getMusic()
{
$infomusicModel = new Model_InfoMusic();
$filter['where'] = " id='{$this->info_id}' and customer_id='{$this->customer_id}' and state='1' ";
$sql = $infomusicModel->select($filter);
$inforesult = $infomusicModel->fetchRow($sql);
$sql = "update info_music set push_num=push_num+1 where id='{$this->info_id}' and customer_id='{$this->customer_id}' limit 1";
$infomusicModel->query($sql);
$data['msgtype'] = 'music';
$data['title'] = $inforesult['music_name'];
$data['description'] = $inforesult['music_desc'];
$data['url'] = $inforesult['url'];
return $data;
}
$infocommonModel = new Model_InfoCommon();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}' and state='1' ";
$filter['group'] = "info_type";
$sql = $infocommonModel->select($filter, 'count(id) as count_num,info_type');
$infocommonarray = $infocommonModel->fetchAll($sql);
foreach ($infocommonarray as $key => $value) {
$infocount[$value['info_type']] = $value['count_num'];
}
//图片统计
$infopicModel = new Model_InfoPic();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}'";
$infocount['pic'] = $infopicModel->count($filter);
//音乐统计
$infomusicModel = new Model_InfoMusic();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}'";
$infocount['music'] = $infomusicModel->count($filter);
//视频统计
$infovideoModel = new Model_InfoVideo();
$filter = array();
$filter['where'] = "customer_id = '{$customer_id}'";
$infocount['video'] = $infovideoModel->count($filter);
$chart_data1['label'] = rtrim($days_str, ',');
$chart_data1['value'] = rtrim($days_value_str, ',');
$chart_data1b['value'] = rtrim($days_valueb_str, ',');
$chart_data1c['value'] = rtrim($days_valuec_str, ',');
$smarty->assign("count", $count);
$smarty->assign("chart_data1", $chart_data1);
$smarty->assign("chart_data1b", $chart_data1b);
