/** * 导出广告idfa * @param $id */ public function data_load($id) { $type = $_REQUEST['type']; $start_date = $_REQUEST['start-date']; $end_date = date('Y-m-d', strtotime($_REQUEST['end-date']) + 24 * 60 * 60); $service = new AD(); if (!$service->check_ad_owner($id)) { $this->exit_with_error('60', '不是您的广告,您不能导出该广告的手机串号数据', 401); } // 根据广告id查询广告相关信息 $filters = array('id' => $id); $ad = $service->get_ad_info($filters, 0, 1); $filename = $ad['ad_name'] . ' ' . $ad['channel'] . '+' . $ad['cid'] . ' ' . $start_date . '~' . $_REQUEST['end-date'] . ' '; // 判断是否导出深度任务 if ($type === "1" || $type === "2") { $this->data_load_task($id, $filename, $start_date, $end_date, $type); return; } $ad_str = "date,IMEI\n"; $ios_str = "date,IDFA\n"; if ($ad['ad_app_type'] == 2) { // ios广告 if ($ad['feedback'] == 4) { // 对接接口 $ios_transfer = $service->get_ios_transfer_log($id, $start_date, $end_date); foreach ($ios_transfer as $transfer) { $idfa = $transfer['device_id']; $ios_str .= explode(' ', $transfer['adnotify_time'])[0] . "," . $idfa . "\n"; } $filters = array('ios_start_time' => $start_date, 'ios_end_time' => $end_date); $imei_total = $service->get_ad_transfer_total($filters, $id, 't_income_transfer_ios_log'); } else { // 不对接接口 $ios_transfer = $service->get_ad_transfer_log($id, $start_date, $end_date); foreach ($ios_transfer as $transfer) { $idfa = $transfer['device_id']; $ios_str .= explode(' ', $transfer['transfer_time'])[0] . "," . $idfa . "\n"; } $filters = array('ad_start_time' => $start_date, 'ad_end_time' => $end_date); $imei_total = $service->get_ad_transfer_total($filters, $id, 't_offer_transfer_log'); } $filename .= 'imei总数' . $imei_total . '个.csv'; Utils::export_csv($filename, $ios_str); } else { // android广告 $ad_transfer = $service->get_ad_transfer_log($id, $start_date, $end_date); foreach ($ad_transfer as $transfer) { $imei = $transfer['device_id']; $ad_str .= explode(' ', $transfer['transfer_time'])[0] . "," . $imei . "\n"; } $filters = array('ad_start_time' => $start_date, 'ad_end_time' => $end_date); $imei_total = $service->get_ad_transfer_total($filters, $id, 't_offer_transfer_log'); $filename .= 'imei总数' . $imei_total . '个.csv'; Utils::export_csv($filename, $ad_str); } }