public function getDashboardFilghtWebsite()
{
$flight = Input::get("flight");
$campaign = Input::get("campaign");
$ad = Input::get("ad");
if ($flight > 0) {
$datas = TrackingSummaryBaseModel::getDataPerDate(date('Y-m-d'), $campaign, $ad, $flight, 'site');
$this->data['datas'] = $datas;
$this->data['flight'] = $flight;
return View::make("dashboardFilghtWebsite", $this->data);
}
return "";
}
function getDailyInventory()
{
$typeapp = 'site';
$datas = TrackingSummaryBaseModel::getDataPerDate(date('Y-m-d'), $this->campaign_id, $this->ad_id, $this->id, $typeapp);
if (isset($datas['summary']) && count($datas['summary']) > 0) {
$sumImpression = $sumImpressionOver = $sumUniqueImpression = $sumUniqueImpressionOver = $sumClick = $sumClickOver = $sumUniqueClick = $sumUniqueClickOver = 0;
foreach ($datas['summary'] as $data) {
$frequency = 0;
if ($data['total_impression'] > 0 && $data['total_unique_impression'] > 0) {
$frequency = number_format(($data['total_impression'] + $data['total_impression_over']) / ($data['total_unique_impression'] + $data['total_unique_impression_over']), 2);
}
$ctr = 0;
if ($data['total_click'] > 0 && $data['total_impression'] > 0) {
$ctr = number_format(($data['total_click'] + $data['total_click_over']) / ($data['total_impression'] + $data['total_impression_over']) * 100, 2);
}
$sumImpression += $data['total_impression'];
$sumImpressionOver += $data['total_impression_over'];
$sumUniqueImpression += $data['total_unique_impression'];
$sumUniqueImpressionOver += $data['total_unique_impression_over'];
$sumClick += $data['total_click'];
$sumClickOver += $data['total_click_over'];
$sumUniqueClick += $data['total_unique_click'];
$sumUniqueClickOver += $data['total_unique_click_over'];
}
$sumFrequency = 0;
if ($sumImpression > 0 && $sumUniqueImpression > 0) {
$sumFrequency = number_format(($sumImpression + $sumImpressionOver) / ($sumUniqueImpression + $sumUniqueImpressionOver), 2);
}
$sumCTR = 0;
if ($sumClick > 0 && $sumImpression > 0) {
$sumCTR = number_format(($sumClick + $sumClickOver) / ($sumImpression + $sumImpressionOver) * 100, 2);
}
return array("sumImpression" => $sumImpression, "sumImpressionOver" => $sumImpressionOver, "sumUniqueImpression" => $sumUniqueImpression, "sumUniqueImpressionOver" => $sumUniqueImpressionOver, "sumClick" => $sumClick, "sumClickOver" => $sumClickOver, "sumUniqueClick" => $sumUniqueClick, "sumUniqueClickOver" => $sumUniqueClickOver, "sumFrequency" => $sumFrequency, "sumCTR" => $sumCTR);
}
return "0";
}
function getReportDateDetail()
{
$flight = Input::get('flight');
$campaign = Input::get('campaign');
$ad = Input::get('ad');
$date = Input::get('date');
$typeapp = Input::get('typeapp');
if ($typeapp == "") {
$typeapp = 'hour';
}
$items['typeapp'] = $typeapp;
$items['tracking'] = TrackingSummaryBaseModel::getDataPerDate($date, $campaign, $ad, $flight, $typeapp);
return View::make("reportdate", $items);
}