$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);