Ejemplo n.º 1
0
 public function export_payment($start, $end, $owner)
 {
     $daily_service = new DailyStat();
     $filters = array('salesman' => $owner);
     $result = $daily_service->get_daily_stat($start, $end, $filters, null, null, 0, 0);
     $list = $result['list'];
     $payments = $this->get_payment_by_owner($start, $end, $owner);
     foreach ($list as $key => $value) {
         $list[$key]['ad_app_type'] = $value['ad_app_type'] == ADModel::ANDROID ? 'Android' : 'iOS';
         $list[$key]['status'] = $value['status'] == ADModel::ONLINE ? 'ON' : 'OFF';
         $list[$key]['channel_type'] = ChannelModel::$TYPE[$value['channel_type']];
         $list[$key]['payment_status'] = '';
         foreach ($payments[$value['id']] as $payment) {
             if (!$payment['payment'] || !$payment['rmb']) {
                 $list[$key]['payment_status'] = 'N';
             } else {
                 $list[$key]['paid_time'] .= $payment['paid_time'] . ' ' . $payment['payment_person'] . ' ';
                 $list[$key]['invoice_time'] .= $payment['invoice_time'] . ' ';
                 $list[$key]['invoice_rmb'] .= $payment['invoice_rmb'] . ' ';
                 $list[$key]['real_rmb'] .= $payment['real_rmb'] / 100 . ' ';
                 $list[$key]['comment'] .= $payment['comment'] . ' ';
             }
         }
         $list[$key] = Utils::array_pick($list[$key], Payment::$FIELD_PAYMENT_EXPORT);
     }
     $title = array('渠道名', '渠道全称', '渠道类型', '广告名', '渠道号', '创建时间', '状态', '平台', '广告类型', '扣分', '排序', '激活支出', '深度任务支出', '收入', '红包锁屏收入', '其他收入', 'CPA', '渠道CPA', '单价', '实际价格', '损益价格', '毛利润', '毛利润率(%)', '结算率(%)', '商务负责人', '商务执行人', '是否回款', '回款时间', '开票时间', '开票金额', '实际回款金额', '备注');
     array_unshift($list, $title);
     $excel_service = new Excel();
     $excel_service->export($list, "{$start}至{$end}广告数据分析");
 }
Ejemplo n.º 2
0
 /**
  * 取单个广告按日数据分析
  * @param $id
  */
 public function get_daily_ad($id)
 {
     list($start, $end) = $this->getFilter();
     $daily_service = new DailyStat();
     $result = $daily_service->get_daily_ad_stat($id, $start, $end);
     $sublist = array($result['ad']);
     $this->output(array('list' => $result['list'], 'sublist' => $sublist, 'code' => 0, 'msg' => 'ok'));
 }
 public function get_stat($ad_app_type)
 {
     $today = date('Y-m-d');
     $start = empty($_REQUEST['start']) ? $today : $_REQUEST['start'];
     $end = empty($_REQUEST['end']) ? $today : $_REQUEST['end'];
     $pagesize = isset($_REQUEST['pagesize']) ? (int) $_REQUEST['pagesize'] : 10;
     $page = isset($_REQUEST['page']) ? (int) $_REQUEST['page'] : 0;
     $page_start = $page * $pagesize;
     $order = isset($_REQUEST['order']) ? trim($_REQUEST['order']) : 'create_time';
     $seq = isset($_REQUEST['seq']) ? trim($_REQUEST['seq']) : 'DESC';
     $im_cp = $_SESSION['role'] == Auth::$CP_PERMISSION;
     $me = $_SESSION['id'];
     $ad_app_type = trim($ad_app_type) == "android" ? ADModel::ANDROID : ADModel::IOS;
     $filters = array('ad_app_type' => $ad_app_type, 'keyword' => $_REQUEST['keyword'], 'ad_name' => $_REQUEST['ad_name'], 'channel' => $_REQUEST['channel'], $im_cp ? 'create_user' : 'salesman' => $me);
     $filters = Utils::array_pick_effect($filters);
     $ad_service = new AD();
     // 根据广告类型取出所有广告
     $ad_ids = $ad_service->get_ad_ids($filters);
     $result = array('oversea' => false, 'ads' => array());
     $total = array('rmb1' => 0, 'device1' => 0, 'native' => 0, 'native_transfer' => 0, 'task_num' => 0, 'task_rmb' => 0, 'task_ready' => 0, 'cpa' => 0, 'click' => 0, 'install' => 0, 'callback' => 0);
     $ids = array();
     $redis = $this->get_redis();
     $daily_service = new DailyStat();
     for ($date = $start; $date <= $end;) {
         list($ymd, $monthly, $date) = $daily_service->judge_date($date, $end);
         $key = 'diy_stat_ad_install_' . $ymd;
         $value = $redis->get($key);
         if ($value) {
             $redis->setTimeout($key, 86400 * 30);
         } else {
             $value = $daily_service->ad_stat_by_date($ymd, $monthly);
             $value = json_encode($value);
             if ($value && ($monthly || strtotime($ymd) < time() - 3600 * 30)) {
                 $redis->setex($key, 86400 * 30, $value);
             }
         }
         $stat = json_decode($value, true);
         foreach ($stat as $ad_stat) {
             $ad_id = $ad_stat['id'];
             if (!in_array($ad_id, $ad_ids)) {
                 continue;
             }
             $ids = array_unique(array_merge($ids, array($ad_id)));
             foreach ($total as $key => $value) {
                 $result['ads'][$ad_id][$key] += $ad_stat[$key];
                 $total[$key] += $ad_stat[$key];
             }
         }
     }
     $adinfos = $ad_service->get_all_ad_info($filters);
     foreach ($ids as $ad_id) {
         if ($adinfos[$ad_id]['oversea']) {
             continue;
         }
         if (!array_key_exists($ad_id, $adinfos)) {
             continue;
         }
         $comments = $ad_service->get_ad_comments_by_id($ad_id);
         $result['ads'][$ad_id] = array_merge($result['ads'][$ad_id], array('id' => $ad_id, 'channel_id' => $adinfos[$ad_id]['cid'], 'channel' => $adinfos[$ad_id]['channel'], 'agreement' => $adinfos[$ad_id]['agreement'], 'ad_name' => $adinfos[$ad_id]['ad_name'], 'comments' => $comments, 'ctime' => date('m-d', strtotime($adinfos[$ad_id]['create_time'])), 'others' => isset($adinfos[$ad_id]['others']) ? $adinfos[$ad_id]['others'] : '添加注释', 'sdk_type' => $adinfos[$ad_id]['ad_sdk_type'] == 7 ? 'promotions' : ($adinfos[$ad_id]['ad_sdk_type'] == 2 ? 'push' : ($adinfos[$ad_id]['ad_sdk_type'] == 4 ? 'wap' : 'ad_list not_promotions')), 'native_type' => $adinfos[$ad_id]['banner_url'] ? 'native' : '', 'ratio' => $result['ads'][$ad_id]['click'] ? round($result['ads'][$ad_id]['device1'] / $result['ads'][$ad_id]['click'] * 100, 2) : 0, 'click_ratio' => $result['ads'][$ad_id]['click'] ? round($result['ads'][$ad_id]['cpa'] / $result['ads'][$ad_id]['click'] * 100, 2) : 0, 'task_ratio' => $result['ads'][$ad_id]['task_ready'] ? round($result['ads'][$ad_id]['task_num'] / $result['ads'][$ad_id]['task_ready'] * 100, 2) : 0));
     }
     // 总计
     $total['ratio'] = $total['click'] ? round($total['transfer'] / $total['click'] * 100, 2) : 0;
     $total['click_ratio'] = $total['click'] ? round($total['cpa'] / $total['click'] * 100, 2) : 0;
     $total['task_ratio'] = $total['task_ready'] ? round($total['task_num'] / $total['task_ready'] * 100, 2) : 0;
     $result['total'] = array_merge(array('id' => 'amount', 'is_amount' => true), $total);
     $list = array_values($result['ads']);
     $total = count($list);
     // 排序
     $list = $this->get_order_list($list, $order, $seq);
     //分页
     $list = array_slice($list, $page_start, $pagesize);
     if (count($list) > 0) {
         array_push($list, $result['total']);
     }
     $is_android = $ad_app_type == 1 ? true : false;
     $this->output(array('code' => 0, 'msg' => 'get', 'list' => $list, 'total' => $total, 'options' => array('is_android' => $is_android)));
 }