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