@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')
{{-- BARRA DE BOTÕES --}}
<x-form.header.button-bar>

    <x-form.header.button-new label="Adicionar Região" tooltip="Incluir uma nova região"
                              :route="route('regions.create')" :can-any="['create-users']"/>

</x-form.header.button-bar>

{{-- ALERTAS --}}
@include('components.widget.alerts')

{{-- FILTROS --}}
<x-filter.area label="Regiões" class="bg-info" route="{{ route('regions.index') }}" filter-code="regions">
        <x-filter.where :where-value="$data['where']" 
                :classWhere="'col-sm-6 col-md-4'"
                :region-items=null 
				{{-- :region-items="$regionsArray" :region-value="$data['region']"  --}}
                :city-items="$cities" :city-value="$data['city']" />
</x-filter.area>

{{-- BODY - refatorar no futuro--}}
@if($regions->count() == 0)
<div class="alert alert-info">
    <strong>Atenção: </strong> Nenhuma região disponível para visualização.
</div>
@endif
        
<div class="card shadow mb-4">
    <div class="card-header py-3">
        <h6 class="m-0 font-weight-bold text-primary">Lista de Regiões</h6>
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                <thead>
                    <tr>
                        <th>Região</th>
                        <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>Facilit.</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>Hospitais</th>
                        <th class="text-center"><i class="fas fa-hospital mr-1"></i>Escolas</th>
                        <th class="text-center"><i class="fas fa-hospital mr-1"></i>Hospita/Escola</th>
                        <th class="text-center"><i class="fas fa-hospital mr-1"></i>Outros</th>
                        @canany(['edit-users','delete-users'])
                                <th class="text-center">Opções</th>
                        @endcanany
                    </tr>
                </thead>
                <tbody>
                    @foreach($regions as $region)
                    <tr>
                        <td style='color: black; background-color: {{ $region->color }};'>
                            <a href="{{ route('regions.show', ['region'=>$region->id])  }}">
                            <strong>{!! $region->name !!}</strong>
                            </a>
                        </td>
                        <td class="text-center">
							@can('edit-users')
								<a href="{{ route('regions.edit', ['region'=>$region->id])  }}">
							@endcan
							{!! isset($region->cities) ? $region->cities->count() : '' !!}
							@can('edit-users')
							</a>
							@endcan
						</td>
                        <td class="text-center">
							@can('edit-users')
								<a href="{{ route('users.index', ['where'=>'region','region'=>$region->id, 'tipo'=> 1]) }}">
							@endcan
							{!! isset($region->usershlc) ? $region->usershlc->count() : '' !!}
							</a>
						</td>
                        <td class="text-center">
							@can('edit-users')
								<a href="{{ route('users.index', ['where'=>'region','region'=>$region->id, 'tipo'=> 2]) }}">
							@endcan
							{!! isset($region->userspvg) ? $region->userspvg->count() : '' !!}
							</a>
						</td>
						<td class="text-center">
							@can('edit-users')
								<a href="{{ route('congregations.index', ['regions'=>$region->id]) }}">
							@endcan
							{!! isset($region->congregations) ? $region->congregations->count() : '' !!}
							@can('edit-users')
							</a>
							@endcan
						</td>
						<td class="text-center">
							@can('view-easers')
								<a href="{{ route('easers.index', ['regions'=>$region->id]) }}">
							@endcan
							{!! isset($region->easers) ? $region->easers->count() : '' !!}
							</a>
						</td>
						<td class="text-center">
							@can('view-coworkers')
								<a href="{{ route('coworkers.index', ['regions'=>$region->id]) }}">
							@endcan
							{!! App\Models\Coworker::where('region_id',$region->id)->get() ? App\Models\Coworker::where('region_id',$region->id)->get()->count() : '' !!}
							</a>
						</td>
                        <td class="text-center">
                            @can('view-doctor')
                                <a href="{{ route('doctors.index', ['regions'=>$region->id]) }}">
                            @endcan
                            
                            @php($get = App\Models\Doctor::inCooperators()->whereHas('addresses',function($q)use($region){$q->where('region_id',$region->id);})->get())
                            {{$get ? $get->count() : '-'}}
                                
                            @can('view-doctor')
                            </a>
                            @endcan
                        </td>
                        <td class="text-center">
                                @can('view-hospitals')
                                        <a href="{{ route('hospitals.index', ['regions'=>$region->id, 'types'=>1 ]) }}">
                                @endcan
                                {!! $region->hospitals()->TypeHospital()->where('region_id',$region->id)->get()->count() !!}
                                </a>
                        </td>
                        <td class="text-center">
                                @can('view-hospitals')
                                        <a href="{{ route('hospitals.index', ['regions'=>$region->id, 'types'=>2 ]) }}">
                                @endcan
                                {!! $region->hospitals()->TypeSchool()->where('region_id',$region->id)->get()->count() !!}
                                </a>
                        </td>
                        <td class="text-center">
                                @can('view-hospitals')
                                        <a href="{{ route('hospitals.index', ['regions'=>$region->id, 'types'=>3 ]) }}">
                                @endcan
                                {!! $region->hospitals()->TypeHospitalSchool()->where('region_id',$region->id)->get()->count() !!}
                                </a>
                        </td>
                        <td class="text-center">
                                @can('view-hospitals')
                                        <a href="{{ route('hospitals.index', ['regions'=>$region->id, 'types'=>4 ]) }}">
                                @endcan
                                {!!$region->hospitals()->TypeOther()->where('region_id',$region->id)->get()->count() !!}
                                </a>
                        </td>
                        @canany(['edit-users','delete-users','view-users'])
                                <td class="text-center text-nowrap">
                                        @can('view-users')
                                                <a href="{!! route('regions.show', ['region' => $region->id]) !!}" class="btn btn-success btn-circle btn-sm" data-placement="top" data-tooltip="tooltip" title="Ver">
                                                        <i class="fas fa-eye"></i>
                                                </a>
                                        @endcan
                                        @can('edit-users')
                                                <a href="{!! route('regions.edit', ['region' => $region->id]) !!}" class="btn btn-info btn-circle btn-sm" data-placement="top" data-tooltip="tooltip" title="Atualizar">
                                                        <i class="fas fa-pencil-alt"></i>
                                                </a>
                                        @endcan
                                        @can('delete-users')
                                                <a href="#deleteRegionModal" data-region-id="{!! $region->id !!}" class="btn btn-danger btn-circle btn-sm delete-region" data-bs-toggle="modal" data-placement="top" data-tooltip="tooltip" title="Deletar">
                                                        <i class="fas fa-trash"></i>
                                                </a>
                                        @endcan
                                </td>
                        @endcanany

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

        {!! $regions->appends($data)->render() !!}
    </div>
</div>


@include('components.delete.region')
        
@endsection