public function district(Request $request) { $district_id = $request->input('district'); $districts = District::where('id', '=', $district_id)->get(); $sectors = Sector::where('district_id', "=", $district_id)->get(); foreach ($sectors as $sector) { $sectors_ids[] = $sector->id; } $cells = Cell::whereIn('sector_id', $sectors_ids)->get(); foreach ($cells as $cell) { $cells_ids[] = $cell->id; } $markets = Market::whereIn('cell_id', $cells_ids)->get(); foreach ($markets as $market) { $markets_ids[] = $market->id; } $prices = Price::whereIn('market_id', $markets_ids)->get(); return view('reports.district')->with('districts', $districts)->with('sectors', $sectors)->with('prices', $prices); }