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); }