s_db = pc_base::load_model('poster_space_model'); $this->db = pc_base::load_model('poster_model'); $setting = new_html_special_chars(getcache('poster', 'commons')); $this->M = $setting[$this->get_siteid()]; } /** * 广告列表 */ public function init() { $spaceid = $_GET['spaceid'] ? intval($_GET['spaceid']) : 0; if (!isset($spaceid) || empty($spaceid)) { showmessage(L('illegal_action'), HTTP_REFERER); } $page = max($_GET['page'], 1); $infos = $this->db->listinfo(array('spaceid'=>$spaceid, 'siteid'=>$this->get_siteid()), '`listorder` ASC, `id` DESC', $page); pc_base::load_sys_class('format', '', 0); $types = array('images'=>L('photo'), 'flash'=>L('flash'), 'text'=>L('title')); $show_dialog = $show_header = true; $big_menu = array('javascript:window.top.art.dialog({id:\'add\',iframe:\'?m=poster&c=space&a=add\', title:\''.L('add_space').'\', width:\'540\', height:\'320\'}, function(){var d = window.top.art.dialog({id:\'add\'}).data.iframe;var form = d.document.getElementById(\'dosubmit\');form.click();return false;}, function(){window.top.art.dialog({id:\'add\'}).close()});void(0);', L('add_space')); include $this->admin_tpl('poster_list'); } /** * 添加广告 */ public function add() { if (isset($_POST['dosubmit'])) { $poster = $this->check($_POST['poster']); $setting = $this->check_setting($_POST['setting'], $poster['type']); $poster['siteid'] = $this->get_siteid(); $poster['setting'] = array2string($setting); $poster['addtime'] = SYS_TIME; $id = $this->db->insert($poster, true); if ($id) { $this->s_db->update(array('items'=>'+=1'), array('spaceid'=>$poster['spaceid'], 'siteid'=>$this->get_siteid())); $this->create_js($poster['spaceid']); if(is_array($setting['images'])) { foreach ($setting['images'] as $im) { $imgs[] = $im['imageurl']; } } if (pc_base::load_config('system','attachment_stat')) { $this->attachment_db = pc_base::load_model('attachment_model'); $this->attachment_db->api_update($imgs, 'poster-'.$id, 1); } showmessage(L('add_ads_success'), 'index.php?m=poster&c=space&a=init'); } else { showmessage(L('operation_failure'), 'index.php?m=poster&c=space&a=init'); } } else { $spaceid = intval($_GET['spaceid']); $sinfo = $this->s_db->get_one(array('spaceid' => $spaceid, 'siteid'=>$this->get_siteid()), 'name, type'); $setting = $this->get_setting($sinfo['type']); $TYPES = get_types(); $default = count($setting)>0 ? L('please_select').'    ' : ''; } $big_menu = array('javascript:window.top.art.dialog({id:\'add\',iframe:\'?m=poster&c=space&a=add\', title:\''.L('add_space').'\', width:\'540\', height:\'320\'}, function(){var d = window.top.art.dialog({id:\'add\'}).data.iframe;var form = d.document.getElementById(\'dosubmit\');form.click();return false;}, function(){window.top.art.dialog({id:\'add\'}).close()});void(0);', L('add_space')); pc_base::load_sys_class('form', '', 0); include $this->admin_tpl('poster_add'); } /** * 广告修改 */ public function edit() { $_GET['id'] = intval($_GET['id']); if (!$_GET['id']) showmessage(L('illegal_action'), HTTP_REFERER); if (isset($_POST['dosubmit'])) { $poster = $this->check($_POST['poster']); $setting = $this->check_setting($_POST['setting'], $poster['type']); $poster['setting'] = array2string($setting); $this->db->update($poster, array('id'=>$_GET['id'], 'siteid'=>$this->get_siteid())); $this->create_js(intval($_GET['spaceid'])); foreach ($setting as $im) { $imgs[] = $im['imageurl']; } if(pc_base::load_config('system','attachment_stat')) { $this->attachment_db = pc_base::load_model('attachment_model'); $this->attachment_db->api_update($imgs, 'poster-'.$_GET['id'], 1); } showmessage(L('edit_ads_success'), 'index.php?m=poster&c=poster&a=init&spaceid='.$_GET['spaceid']); } else { $info = $this->db->get_one(array('id'=>$_GET['id'], 'siteid'=>$this->get_siteid())); $sinfo = $this->s_db->get_one(array('spaceid' => $info['spaceid'], 'siteid'=>$this->get_siteid()), 'name, type'); $setting = $this->get_setting($sinfo['type']); $TYPES = get_types(); $info['setting'] = string2array($info['setting']); $default = count($setting)>0 ? L('please_select').'    ' : ''; $big_menu = array('javascript:window.top.art.dialog({id:\'add\',iframe:\'?m=poster&c=space&a=add\', title:\''.L('add_space').'\', width:\'540\', height:\'320\'}, function(){var d = window.top.art.dialog({id:\'add\'}).data.iframe;var form = d.document.getElementById(\'dosubmit\');form.click();return false;}, function(){window.top.art.dialog({id:\'add\'}).close()});void(0);', L('add_space')); pc_base::load_sys_class('form', '', 0); include $this->admin_tpl('poster_edit'); } } /** * 广告排序 */ public function listorder() { if (isset($_POST['listorder']) && is_array($_POST['listorder'])) { $listorder = $_POST['listorder']; foreach ($listorder as $k => $v) { $this->db->update(array('listorder'=>$v), array('id'=>$k)); } } showmessage(L('operation_success'), HTTP_REFERER); } /** * 生成广告js文件 * @param intval $id 广告版位ID * @return boolen 成功返回true */ private function create_js($id = 0) { $html = pc_base::load_app_class('html'); if (!$html->create_js($id)) showmessge($html->msg, HTTP_REFERER); return true; } /** * 启用、停用广告。此方法不真正执行操作,调用真正的操作方法 * @param intval $id 广告ID */ public function public_approval() { if (!isset($_POST['id']) || !is_array($_POST['id'])) { showmessage(L('illegal_parameters'), HTTP_REFERER); } else { array_map(array($this, _approval), $_POST['id']); } showmessage(L('operation_success'), HTTP_REFERER); } private function _approval($id = 0) { $id = intval($id); if (!$id) return false; $_GET['passed'] = intval($_GET['passed']); $this->db->update(array('disabled'=>$_GET['passed'] ), array('id'=>$id, 'siteid'=>$this->get_siteid())); return true; } /** * 删除广告 此方法不真正执行删除操作,调用真正的删除操作方法 * @param invtal $id 广告ID */ public function delete() { if (!isset($_POST['id']) || !is_array($_POST['id'])) { showmessage(L('illegal_parameters'), HTTP_REFERER); } else { array_map(array($this, _del), $_POST['id']); } showmessage(L('operation_success'), HTTP_REFERER); } /*** * 广告删除 */ private function _del($id = 0) { $id = intval($id); if (!$id) return false; $r = $this->db->get_one(array('id'=>$id, 'siteid'=>$this->get_siteid()), 'spaceid'); $this->s_db->update(array('items'=>'-=1'), array('spaceid'=>$r['spaceid'], 'siteid'=>$this->get_siteid())); $this->db->delete(array('id'=>$id, 'siteid'=>$this->get_siteid())); if (pc_base::load_config('system','attachment_stat')) { $this->attachment_db = pc_base::load_model('attachment_model'); $keyid = 'poster-'.$id; $this->attachment_db->api_delete($keyid); } return true; } /** * 广告统计 */ public function stat() { $_GET['id'] = intval($_GET['id']); $info = $this->db->get_one(array('id'=>$_GET['id']), 'spaceid'); if (!$_GET['id']) showmessage(L('illegal_operation')); /** *如果设置了日期查询,设置查询的开始时间和结束时间 */ $sdb = pc_base::load_model('poster_stat_model'); //调用广告统计的数据模型 $year = date('Y', SYS_TIME); $month = date('m', SYS_TIME); $day = date('d', SYS_TIME); $where = $group = $order = ''; $fields = '*'; $where = "`pid`='".$_GET['id']."' AND `siteid`='".$this->get_siteid()."'"; if ($_GET['range'] == 2) { //昨天的统计 $fromtime = mktime(0, 0, 0, $month, $day-2, $year); $totime = mktime(0, 0, 0, $month, $day-1, $year); $where .= " AND `clicktime`>='".$fromtime."'"; $where .= " AND `clicktime`<='".$totime."'"; } elseif(is_numeric($_GET['range'])) { //如果设置了查询的天数 $fromtime = mktime(0, 0, 0, $month, $day-$_GET['range'], $year); $where .= " AND `clicktime`>='".$fromtime."'"; } $order = '`clicktime` DESC'; //如果设置了按点击、展示统计 $_GET['click'] = isset($_GET['click']) ? intval($_GET['click']) : 0; if (is_numeric($_GET['click'])) { $_GET['click'] = intval($_GET['click']); $where .= " AND `type`='".$_GET['click']."'"; //如果设置了按地区或者按ip分类 if ($_GET['group']) { $_GET['group'] = preg_replace('#`#', '', $_GET['group']); $group = " `".$_GET['group']."`"; $fields = "*, COUNT(".$_GET['group'].") AS num"; $order = " `num` DESC"; } $r = $sdb->get_one($where, 'COUNT(*) AS num', '', $group); //取得总数 } else { $r = $sdb->get_one($where, 'COUNT(*) AS num'); } $page = max(intval($_GET['page']), 1); $curr_page = 20; $limit = ($page-1)*$curr_page.','.$curr_page; $pages = pages($r['num'], $page, 20); //生成分页 $data = $sdb->select($where, $fields, $limit, $order, $group); $selectstr = $sdb->get_list($_GET['year']); //取得历史查询下拉框,有历史数据查询时,会自动换表 pc_base::load_sys_class('format', '', 0); $show_header = true; unset($r); include $this->admin_tpl('poster_stat'); } /** * 根据版位的类型,得到版位的配置信息。如广告类型等 * @param string $type 版位的类型,默认情况下是一张图片或者动画 * return boolean */ private function get_setting($type) { $data = $poster_template = array(); $poster_template = getcache('poster_template_'.$this->get_siteid(), 'commons'); if (is_array($poster_template) && !empty($poster_template)) { $data = $poster_template[$type]; } else { switch($type) { case 'banner': $data['type'] = array('images' => L('photo'), 'flash' => L('flash')); $data['num'] = 1; break; case 'fixure': $data['type'] = array('images' => L('photo'), 'flash' => L('flash')); $data['num'] = 1; break; case 'float': $data['type'] = array('images' => L('photo'), 'flash' => L('flash')); $data['num'] = 1; break; case 'couplet': $data['type'] = array('images' => L('photo'), 'flash' => L('flash')); $data['num'] = 2; break; case 'imagechange': $data['type'] = array('images' => L('photo')); $data['num'] = 1; break; case 'imagelist': $data['type'] = array('images' => L('photo')); $data['num'] = 1; break; case 'text': $data['type'] = array('text' => L('title')); break; case 'code': $data['type'] = array('text' => L('title')); break; default : $data['type'] = array('images' => L('photo'), 'flash' => L('flash')); $data['num'] = 1; } } return $data; } /** * 检查广告属性信息 * @param array $data * return array */ private function check($data) { if (!isset($data['name']) || empty($data['name'])) showmessage(L('adsname_no_empty'), HTTP_REFERER); if (!isset($data['type']) || empty($data['type'])) showmessage(L('no_ads_type'), HTTP_REFERER); $data['startdate'] = $data['startdate'] ? strtotime($data['startdate']) : SYS_TIME; $data['enddate'] = $data['enddate'] ? strtotime($data['enddate']) : strtotime('next month', $data['startdate']); if($data['startdate']>=$data['enddate']) $data['enddate'] = strtotime('next month', $data['startdate']); return $data; } /** * 检查广告的内容信息,如图片、flash、文字 * @param array $setting * @param string $type 广告的类型 * @return array */ private function check_setting($setting = array(), $type = 'images') { switch ($type) { case 'images': unset($setting['flash'], $setting['text']); if(is_array($setting['images'])) { $tag = 0; foreach ($setting['images'] as $k => $s) { if($s['linkurl']=='http://') { $setting['images'][$k]['linkurl'] = ''; } if (!$s['imageurl']) unset($setting['images'][$k]); else $tag = 1; } if (!$tag) showmessage(L('no_setting_photo'), HTTP_REFERER); } break; case 'flash': unset($setting['images'], $setting['text']); if (is_array($setting['flash'])) { $tag = 0; foreach ($setting['flash'] as $k => $s) { if (!$s['flashurl']) unset($setting['flash'][$k]); else $tag = 1; } if (!$tag) showmessage(L('no_flash_path'), HTTP_REFERER); } break; case 'text': unset($setting['images'], $setting['flash']); if ((!isset($setting['text'][1]['title']) || empty($setting['text'][1]['title'])) && (!isset($setting['text']['code']) || empty($setting['text']['code']))) { showmessage(L('no_title_info'), HTTP_REFERER); } break; } return $setting[$type]; } /** * ajax检查广告名的合法性 */ public function public_check_poster() { if (!$_GET['name']) exit(0); if (CHARSET=='gbk') { $_GET['name'] = safe_replace(iconv('UTF-8', 'GBK', $_GET['name'])); } if ($_GET['id']) { $spaceid = intval($_GET['spaceid']); $r = $this->db->get_one(array('id' => $id)); if($r['name'] == $_GET['name']) { exit('1'); } } $r = $this->db->get_one(array('siteid' => $this->get_siteid(), 'name' => $_GET['name']), 'id'); if ($r['id']) { exit('0'); } else { exit('1'); } } } ?>