@extends('layout.backend')
@section('styles')
    @parent
@endsection
@section('scripts')
    @parent
    <script src="{{ asset('/js/plugins/jquery.mask.min.js') }}"></script>
	<script src="{{ mix('/js/create-regions.js') }}"></script>
@endsection
@section('content',null)

@can('create-users')
<a href="{!! route('regions.create') !!}" class="btn btn-primary btn-sm btn-icon-split">
    <span class="icon text-white-50">
        <i class="fas fa-plus"></i>
    </span>
    <span class="text">Adicionar Região</span>
</a>
<br/>
@endcan

@if(session()->has('alert-success'))
<div class="alert alert-success">
    {!! session()->get('alert-success') !!}
</div>
@endif

@if($regioncities->count() > 0)
<div class="card shadow mb-4">
    <div class="card-header py-3">
        <h6 class="m-0 font-weight-bold text-primary">Lista de cidades da região {{$region->name}}</h6>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                <thead>
                    <tr>
                        <th class="text-center">Cidades</th>
                        <th class="text-center"><i class="fas fa-users mr-1"></i>Colih</th>
                        <th class="text-center"><i class="fas fa-users mr-1"></i>GVP</th>
                        <th class="text-center">Congregações</th>
                        <th class="text-center"><i class="fas fa-user-nurse mr-1"></i>Facilitadores</th>
                        <th class="text-center"><i class="fas fa-user mr-1"></i>Colab.</th>
                        <th class="text-center"><i class="fas fa-stethoscope mr-1"></i>Médicos</th>
                        <th class="text-center"><i class="fas fa-hospital mr-1"></i>Instituições</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($regioncities as $regioncity)
                    <tr>
                        <td class="text-center">
                            {{$regioncity->city->city}}
                        </td>

                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('users.index', ['where'=>'city','city'=>$regioncity->city_id, 'tipo'=>1]) }}">
                                @endcan
                                {!! App\Models\User::isHlc()->whereHas('congregation',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get() ? App\Models\User::isHlc()->whereHas('congregation',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get()->count() : '' !!}
                            @can('view-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('users.index', ['where'=>'city','city'=>$regioncity->city_id, 'tipo'=>2])  }}">
                                @endcan
                                {!! App\Models\User::isPvg()->whereHas('congregation',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get() ? App\Models\User::isPvg()->whereHas('congregation',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get()->count() : '' !!}
                            @can('show-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('congregations.index', ['city'=>$regioncity->city_id])  }}">
                                @endcan
                                {!! App\Models\Congregation::whereHas('city',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get() ? App\Models\Congregation::whereHas('city',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get()->count() : '' !!}
                            @can('show-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('easers.index', ['city'=>$regioncity->city_id])  }}">
                                @endcan
                                {!! App\Models\Easer::whereHas('city',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get() ? App\Models\Easer::whereHas('city',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get()->count() : '' !!}
                            @can('show-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('coworkers.index', ['city'=>$regioncity->city_id])  }}">
                                @endcan
                                {!! App\Models\Coworker::whereHas('city',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get() ? App\Models\Coworker::whereHas('city',function($q) use ($regioncity){$q->where('city_id',$regioncity->city_id);})->get()->count() : '' !!}
                            @can('show-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-doctor')
                            <a href="{{ route('doctors.index', ['city'=>$regioncity->city_id, 'regions'=>'All'])  }}">
                            @endcan
                            @php($get = App\Models\Doctor::inCooperators()->whereHas('addresses',function($q)use($regioncity){$q->where('city_id',$regioncity->city_id);})->get())
                            {{$get ? $get->count() : '-'}}
                            @can('view-doctor')
                            </a>
                            @endcan
                        </td>

                        <td class="text-center">
							<a href="{!! route('hospitals.index', ['cities' => $regioncity->city_id]) !!}">
								{!! $region->hospitals()->where('city_id',$regioncity->city_id)->get()->count() !!}
	                        </a>
                        </td>

                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
</div>

@else
<div class="alert alert-info">
    <strong>Atenção: </strong> Nenhuma cidade cadastrada nessa região.
</div>
@endif

@endsection