function getDashboardHQ()
{
$flight_dates = FlightDateBaseModel::with('flight.campaign')->where("start", "<=", date("Y-m-d"))->Where("end", ">=", date("Y-m-d"))->orderBy("flight_id", "DESC")->get();
$data["data"] = array();
$campaignIds = null;
$flightIds = null;
$adIds = null;
foreach ($flight_dates as $flight_date) {
$flight = $flight_date->flight;
$campagin = $flight->campaign;
$campaignIds[] = $flight->campaign->id;
$flightIds[] = $flight->id;
$adIds[] = $flight->ad_id;
$flight->daily_inventory = $flight_date->daily_inventory;
if ($flight->cost_type == 'cpm') {
$flight->daily_inventory = $flight_date->daily_inventory * 1000;
}
$data["datas"][$campagin->name][$flight->id] = $flight;
}
$dailyInventories = FlightBaseModel::getDailyInventories($campaignIds, $flightIds, $adIds);
$totalInventories = TrackingSummaryBaseModel::getFlightSummaryByIDs($flightIds);
//var_dump($totalInventories); die();
$data['dailyInventories'] = $dailyInventories;
$data['totalInventories'] = $totalInventories;
return View::make('dashboard_hq', $data);
}
