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