@foreach($dists as $dist)
@php
$areas = \App\Areas::where('region_id',$dist->region_id)->select('id','area_name')->get();
$territories = \App\Territories::where('area_id',$dist->distributor_area_id)->select('id','territory_name')->get();
$cities = \Illuminate\Support\Facades\DB::table('area_assignment')
->join("cities","cities.id","=","area_assignment.city_id")
->where('area_assignment.area_id',$dist->distributor_area_id)
->groupBy('cities.id')
->select('cities.id','cities.name')->get();
@endphp
| {{$dist->id}} |
{{$dist->distributor_name}} ({{$dist->id}}) |
|
|
|
|
|
|
|
Update |
@endforeach