/**
* 导出广告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);
}
}
