public function ad_stat_by_date($ymd, $monthly)
{
$value = array();
if ($monthly) {
$start = $ymd . '-01';
$end = date('Y-m-d', mktime(0, 0, 0, substr($ymd, 5, 2) + 1, 0, substr($ymd, 0, 4)));
} else {
$start = $ymd;
$end = $ymd;
}
$transferStat_service = new TransferStat();
$transfer_res = $transferStat_service->get_ad_transfer_by_ads($start, $end, "");
$happy_lock_transfer = $transferStat_service->get_all_ad_happy_lock_transfer($start, $end);
$click = $transferStat_service->get_offer_click_total($start, $end);
$adminStat_service = new AdminTaskStat();
$task = $adminStat_service->get_ad_task_stat($start, $end);
$limited_task = $adminStat_service->get_ad_limited_task_stat($start, $end);
$es_task = $adminStat_service->get_all_ad_happy_lock_task($start, $end);
$es_limited_task = $adminStat_service->get_all_ad_happy_lock_limited_task($start, $end);
$nativeStat_service = new NativeStat();
$native = $nativeStat_service->get_native_stat_ad($start, $end);
$native_transfer = $nativeStat_service->get_native_transfer_stat_by_ad($start, $end);
$callback = $transferStat_service->get_income_stat_ios($start, $end);
$install = $transferStat_service->get_offer_install_stat_ad($start, $end);
$happy_lock_task = array();
foreach ($es_task['aggregations']['all_ad_ids']['buckets'] as $ad_task) {
$happy_lock_task[$ad_task['key']] = $ad_task['sum_rmb']['value'];
}
$happy_lock_limited_task = array();
foreach ($es_limited_task['aggregations']['all_ad_ids']['buckets'] as $ad_task) {
$happy_lock_limited_task[$ad_task['key']] = $ad_task['sum_rmb']['value'];
}
$ad_ids = array_unique(array_merge(array_keys((array) $transfer_res), array_keys((array) $click), array_keys((array) $task), array_keys((array) $limited_task), array_keys((array) $install), array_keys((array) $native), array_keys((array) $native_transfer), array_keys((array) $callback)));
foreach ($ad_ids as $ad_id) {
$stat = array('id' => $ad_id, 'rmb1' => round((isset($transfer_res[$ad_id]) ? ($transfer_res[$ad_id]['rmb'] - $happy_lock_transfer[$ad_id]['rmb'] / 2) / 100 : 0) + ($task[$ad_id]['rmb'] + $limited_task[$ad_id]['rmb'] - $happy_lock_task[$ad_id] / 2 - $happy_lock_limited_task[$ad_id] / 2) / 100, 2), 'device1' => (int) $transfer_res[$ad_id]['transfer'], 'native' => (int) $native[$ad_id], 'native_transfer' => (int) $native_transfer[$ad_id], 'task_num' => $task[$ad_id]['num'] + $limited_task[$ad_id]['num'], 'task_rmb' => ($task[$ad_id]['rmb'] + $limited_task[$ad_id]['rmb'] - $happy_lock_task[$ad_id] / 2 - $happy_lock_limited_task[$ad_id] / 2) / 100, 'task_ready' => $task[$ad_id]['ready'], 'click' => $click[$ad_id], 'install' => $install[$ad_id], 'callback' => $callback[$ad_id]);
$value[$ad_id] = $stat;
}
return $value;
}
public function get_stat_by_apk($id)
{
$ad_service = new AD();
$ad = $ad_service->select_ad_join_source_create_time($id);
$today = date("Y-m-d");
$start = empty($_GET['start']) ? $today : $_GET['start'];
$end = empty($_GET['end']) ? $today : $_GET['end'];
$transfer_service = new TransferStat();
$transfer_res = $transfer_service->get_app_transfer_by_ad($start, $end, $id);
$adminStat_service = new AdminTaskStat();
$task_stat = $adminStat_service->get_ad_task_stat_by_app($start, $end, $id);
$limited_task_stat = $adminStat_service->get_ad_limited_task_stat_by_app($start, $end, $id);
$task = array();
foreach ($task_stat['aggregations']['all_app_ids']['buckets'] as $task_app) {
if ($task_app['sum_num']['value'] || $task_app['sum_ready']['value']) {
$task[$task_app['key']['num']] += $task_app['sum_num']['value'];
$task[$task_app['key']['ready']] += $task_app['sum_ready']['value'];
$task[$task_app['key']['rmb']] += $task_app['sum_rmb']['value'];
}
}
$limited_task = array();
foreach ($limited_task_stat['aggregations']['all_app_ids']['buckets'] as $task_app) {
if ($task_app['sum_num']['value'] || $task_app['sum_ready']['value']) {
$limited_task[$task_app['key']['num']] += $task_app['sum_num']['value'];
$limited_task[$task_app['key']['ready']] += $task_app['sum_ready']['value'];
$limited_task[$task_app['key']['rmb']] += $task_app['sum_rmb']['value'];
}
}
$appids = implode("','", array_merge(array_keys((array) $transfer_res), array_keys($task), array_keys($limited_task)));
$appinfo_service = new AdminAppinfo();
$appinfo = $appinfo_service->get_apps_detail_and_account($appids);
$result = array_merge($ad, array('start' => $start, 'end' => $end, 'ctime' => substr($ad['create_time'], 5, 5), 'apks' => array(), 'rmb1' => 0, 'device1' => 0, 'ad_app_type' => $ad['ad_app_type'] == 1 ? 'android' : 'ios', 'task_num' => 0, 'task_rmb' => 0, 'task_ready' => 0, 'limited_task_num' => 0, 'limited_task_rmb' => 0, 'limited_task_ready' => 0));
foreach ($appinfo as $key => $value) {
$apk = array('appid' => $key, 'appname' => $value['appname'], 'account' => $value['account'], 'userid' => $value['user_id'], 'rmb1' => $key == '5763c2eb596b7a4e511f588d4ee7e50f' || $key == 'c81bc556d5dc52b854f591320d4c951b' ? $transfer_res[$key]['rmb'] / 100 / 2 : $transfer_res[$key]['rmb'] / 100, 'device1' => (int) $transfer_res[$key]['transfer'], 'task_num' => (int) $task[$key]['num'], 'task_ready' => (int) $task[$key]['ready'], 'task_rmb' => $key == '5763c2eb596b7a4e511f588d4ee7e50f' || $key == 'c81bc556d5dc52b854f591320d4c951b' ? $task[$key]['rmb'] / 100 / 2 : $task[$key]['rmb'] / 100, 'task_ratio' => $task[$key]['ready'] ? (int) ($task[$key]['num'] / $task[$key]['ready'] * 100) : 0, 'limited_task_num' => (int) $limited_task[$key]['num'], 'limited_task_ready' => (int) $limited_task[$key]['ready'], 'limited_task_rmb' => $key == '5763c2eb596b7a4e511f588d4ee7e50f' || $key == 'c81bc556d5dc52b854f591320d4c951b' ? $limited_task[$key]['rmb'] / 100 / 2 : $limited_task[$key]['rmb'] / 100, 'limited_task_ratio' => $limited_task[$key]['ready'] ? (int) ($limited_task[$key]['num'] / $limited_task[$key]['ready'] * 100) : 0);
$result['apks'][] = $apk;
$result['rmb1'] += $apk['rmb1'];
$result['device1'] += $apk['device1'];
$result['task_num'] += $apk['task_num'];
$result['task_rmb'] += $apk['task_rmb'];
$result['task_ready'] += $apk['task_ready'];
$result['limited_task_num'] += $apk['limited_task_num'];
$result['limited_task_rmb'] += $apk['limited_task_rmb'];
$result['limited_task_ready'] += $apk['limited_task_ready'];
}
$result['task_ratio'] = $result['task_ready'] ? (int) ($result['task_num'] / $result['task_ready'] * 100) : 0;
$result['limited_task_ratio'] = $result['limited_task_ready'] ? (int) ($result['limited_task_num'] / $result['limited_task_ready'] * 100) : 0;
$this->output(array('code' => 0, 'msg' => 'msg', 'list' => $result['apks']));
}
private function get_total_data($start, $end, $me)
{
$ad_service = new AD();
$filters = array('salesman' => $me);
$ad_info = $ad_service->get_all_basic_ad_info($filters);
$adids = array_keys((array) $ad_info);
$transfer_service = new TransferStat();
$transfer = $transfer_service->get_ad_transfer_by_ads($start, $end, '');
$quote_service = new Quote();
$adquote = $quote_service->get_ad_quote_by_owner($start, $end, $me);
$adminTask_service = new AdminTaskStat();
$task = $adminTask_service->get_ad_task_outcome_by_sale($start, $end, $me);
// 本月数据*4 + 我的广告
$income_total = 0;
$out_total = 0;
$stat_total = 0;
$cpa_total = 0;
foreach ($adids as $adid) {
if (!in_array($adid, $adids)) {
continue;
}
$income = (int) $adquote[$adid]['income'];
$out = (int) $transfer[$adid]['rmb'] + (int) $task[$adid];
$stat = (int) $transfer[$adid]['transfer'];
$cpa = (int) $adquote[$adid]['cpa'];
$income_total += $income;
$out_total += $out;
$stat_total += $stat;
$cpa_total += $cpa;
}
return array($income_total, $out_total, $stat_total, $cpa_total);
}
