/** * 单个广告某天数据统计 * @param $id * @param $date */ public function get_ad_daily_stat($id, $date) { $ad = new AD(); if (!$ad->check_ad_owner($id)) { $this->exit_with_error(20, '您无法查询此广告', 401); } $info = $ad->get_ad_info(array('id' => $id), 0, 1); $filter = array(':date' => $date, ':ad_id' => $id); $stat = new Stat(); $transfer_res = $stat->get_ad_transfer_by_hour($filter); $click_res = $stat->get_ad_click_by_hour($filter); $result = array(); for ($hour = 0; $hour < 24; $hour++) { if (!$transfer_res[$hour] && !$click_res[$hour]) { continue; } $result[] = array('hour' => $hour, 'transfer' => (int) $transfer_res[$hour], 'click' => (int) $click_res[$hour], 'cost' => $info['quote_rmb'] * (int) $transfer_res[$hour]); } $this->output(array('code' => 0, 'msg' => 'fetched', 'total' => 24, 'start' => 0, 'list' => $result)); }
/** * 取新建广告的表单项,修改广告时当前内容 * @author Meathill * @since 0.1.0 * @param $id */ public function init($id) { $CM = $this->get_cm(); $service = new AD(); $admin = new Admin(); $labels = $service->get_all_labels(); $permissions = $service->get_all_permissions(); $me = $_SESSION['id']; $im_cp = $_SESSION['role'] == Auth::$CP_PERMISSION; $init = array('ad_app_type' => $im_cp ? 2 : 1, 'ad_type' => 0, 'cate' => 1, 'cpc_cpa' => 'cpa', 'put_level' => 3, 'imsi' => 0, 'put_net' => 0, 'net_type' => 0, 'put_jb' => 0, 'put_ipad' => 0, 'salt' => substr(md5(time()), 0, 8), 'url_type' => '', 'province_type' => 0, 'share_text' => '', 'down_type' => 0); $options = array('cates' => array('试用', '注册'), 'net_types' => array('全部', '移动', '联通', '电信'), 'channel_types' => ChannelModel::$TYPE, 'ad_types' => $labels, 'permissions' => $permissions, 'provinces' => $CM->provinces, 'sales' => false, 'cp' => $im_cp); $agreement = new Agreement(); if (!$im_cp) { $init = array_merge($init, array('ratio' => 1, 'feedback' => 0, 'cycle' => 0)); $relative_sales = $options['sales'] = $admin->get_sales_by_me($me); if ($relative_sales) { $relative = array(); foreach ($relative_sales as $key => $value) { $relative[] = array('key' => $key, 'value' => $value); } $options["relativeSales"] = $relative; } $options['agreements'] = $agreement->get_my_agreement(['today' => date('Y-m-d')]); } if ($id === 'init') { $this->output(array('code' => 0, 'msg' => 'init', 'ad' => $init, 'options' => $options)); } // 广告内容 if (!$service->check_ad_owner($id)) { $this->exit_with_error(20, '您无法查询此广告的详细信息', 401); } $res = $service->get_ad_info(array('id' => $id), 0, 1); $res['id'] = $id; $ad_shoot = preg_replace('/^,|,$/', '', $res['ad_shoot']); $ad_shoots = preg_split('/,+/', $ad_shoot); if (is_array($ad_shoots)) { foreach ($ad_shoots as $key => $ad_shoot) { $ad_shoots[$key] = $this->createCompletePath($ad_shoot); } $res['ad_shoot'] = $ad_shoots; } $res['ad_url'] = $this->createCompletePath($res['ad_url']); $res['pic_path'] = $this->createCompletePath($res['pic_path']); // 取计划任务,得投放量 $job_service = new Job(); $job = $job_service->get_ad_daily_job($id); $job = (array) $job[$id]; // 省份 if ($res['province_type'] == 1) { $location = new Location(); $provinces = $location->get_provinces_by_ad($id); $res['put_provinces'] = array_values(array_unique($provinces)); } // 被据广告读原因 if ($res['status'] == 4) { $op_log = new ADOperationLogger(); $log = $op_log->get_log(array('adid' => $id, 'type' => 'ad', 'action' => 'decline')); $res['decline'] = $log; } // 点评 $res['comments'] = $service->get_comments(array('ad_id' => $id)); // 今天的投放情况 $stat = new Stat(); $today = date('Y-m-d'); $filter = [':ad_id' => $id, ':date' => $today]; $clicks = $stat->get_ad_click_by_hour($filter); $transfer = $stat->get_ad_transfer_by_hour($filter); $today_stat = []; for ($hour = 0; $hour < 24; $hour++) { $item = array('hour' => $today . ' ' . $hour); if (isset($clicks[$hour])) { $item['click'] = (int) $clicks[$hour]; } if (isset($transfer[$hour])) { $item['transfer'] = (int) $transfer[$hour]; } $today_stat[] = $item; } if (in_array($res['status'], array(0, 1))) { // 备注 $comments = $service->get_ad_comments(array($id)); $res = array_merge($res, array('cm_others' => $comments[$id])); } $result = array_merge($init, $res, $job); $result['today_stat'] = $today_stat; $this->output(array('code' => 0, 'msg' => 'fetched', 'ad' => $result, 'options' => $options)); }