@extends('layout.backend')
@section('styles')
    @parent
@endsection
@section('scripts')
    @parent
	@vite(['resources/js/create-regions.js'])
@endsection
@section('content',null)

<x-form.header.button-bar>
    <x-form.header.button-back :route="route('regions.index')" />
    @can('edit-users')
        <x-form.header.button
            :route="route('regions.edit', ['region' => $region->id])"
            icon="fa-pen-to-square"
            class="btn-primary"
            tooltip="Editar esta região">
            Editar Região
        </x-form.header.button>
    @endcan
</x-form.header.button-bar>

@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-user-tie mr-1"></i>Colih</th>
                        <th class="text-center"><i class="fas fa-user-group 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-headset mr-1"></i>Assistentes</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)
                    @php
                        $cityId = $regioncity->city_id;
                        $cityFilter = function($q) use ($cityId) {
                            $q->where('city_id', $cityId)
                              ->orWhereHas('congregation', fn($sq) => $sq->where('city_id', $cityId));
                        };
                        $countHlc    = App\Models\User::isHlc()->where($cityFilter)->count();
                        $countPvg    = App\Models\User::isPvg()->where($cityFilter)->count();
                        $countAssist = App\Models\User::isAssistant()->where($cityFilter)->count();
                    @endphp
                    <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
                                {{ $countHlc }}
                            @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
                                {{ $countPvg }}
                            @can('view-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('congregations.index', ['city'=>$regioncity->city_id])  }}">
                            @endcan
                                {!! App\Models\Congregation::where('city_id',$regioncity->city_id)->count() !!}
                            @can('view-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-users')
                            <a href="{{ route('easers.index', ['where' => 'city', 'city'=>$regioncity->city_id])  }}">
                            @endcan
                                {!! App\Models\Easer::where('city_id',$regioncity->city_id)->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'=>3])  }}">
                            @endcan
                                {{ $countAssist }}
                            @can('view-users')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                            @can('view-doctor')
                            <a href="{{ route('doctors.index', ['cities'=>$regioncity->city_id])  }}">
                            @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