return false;
}
}
}
return true;
});
Route::get('mDelKey', function () {
set_time_limit(0);
$keys = Input::get('key');
if (!empty($keys)) {
RedisHelper::delMKey($keys);
}
pr('complete');
});
Route::get('reportAudience', function () {
$tracking = new RawTrackingAudience();
$data = $tracking->reportAudience();
pr($data);
});
Route::get('get-adrequest-hourly', function () {
$tracking = new RawTrackingAdRequest();
if ($rows = $tracking->reportScheduleHourly()) {
pr($rows);
echo "Report Success";
} else {
echo "No Report Complete";
}
die;
});
Route::get('get-adrequest-daily', function () {
$tracking = new RawTrackingAdRequest();
public function reportExportAudience($bid = 0)
{
$listAudience = array();
$this->layout = null;
$banner_name = '';
if ($bid) {
$rawTrackingAudience = new RawTrackingAudience();
$listAudience = $rawTrackingAudience->getListAudienceTracking($bid);
$ad = (new Delivery())->getAd($bid);
if ($ad) {
$banner_name = $ad->name;
}
}
$format = "csv";
$data = [];
if (!empty($listAudience)) {
foreach ($listAudience as $k => $row) {
$data[$k]['uuid'] = $row->uuid;
$data[$k]['impression'] = !empty($row->impression) ? $row->impression : "0";
$data[$k]['click'] = !empty($row->click) ? $row->click : "0";
$data[$k]['time'] = !empty($row->time) ? date('Y-m-d H:i:s', $row->time) : '';
}
}
$title = "List Audience Of Banner: {$banner_name}";
$filename = "audience_" . date('Ymd');
Excel::create($filename, function ($excel) use($data, $format, $title) {
$excel->sheet('Audience', function ($sheet) use($data, $format, $title) {
$sheet->mergeCells('A1:D1');
$sheet->setHeight(1, 50);
$sheet->cells('A1:D1', function ($cells) {
$cells->setFont(array('family' => 'Calibri', 'size' => '18', 'bold' => true));
$cells->setAlignment('center');
$cells->setValignment('middle');
});
$sheet->row(1, array($title));
$sheet->row(2, function ($row) {
$row->setFontWeight('bold');
$row->setAlignment('center');
});
$sheet->setAutoSize(true);
$sheet->setAllBorders('none');
$sheet->fromArray($data, 'null', 'A2');
});
})->download('csv');
}
