@extends('layouts.app')
@section('contenu')
<!--table des rendez-vous-->
<div class="box col-md-12 box-inner">
    <div class="box-header well" data-original-title="">
                    <h2><i class="glyphicon glyphicon-pack"></i>Liste des Rendez-vous</h2>
                </div>
                <form action="{{route('rdv')}}">
    <table class="table table-striped table-bordered bootstrap-datatable datatable responsive" id="example">
    <thead>
    <tr>
        <th><input type="checkbox" onclick="cocherTout(this.checked);" ></th>
        <th>Entreprise</th>
        <th>Adresse</th>
        <th>Type</th>
        <th>Telephone</th>
        <th>Categorie</th>
        <th>Nombre de Rendez-Vous</th>
        <th>Action</th>
        <!--
-->
    </tr>
    </thead>
    <tbody>
        @foreach(App\Models\rendezvous::where('user_id',Auth::user()->id)->groupBy('societe_id')->get() as $key => $value)
    
        @foreach(DB::table('rendezvous')
        ->select(DB::raw('COUNT(societe_id) as nbr_doublon','societe_id'))
        ->where('societe_id',$value->societe_id)
            ->groupBy('societe_id')
            ->havingRaw('nbr_doublon >= ?',[1] )
            ->get() as $key => $rdv)
            @endforeach
        
    <tr>

        <td class="center">
       <input type="radio" name="idr" value="{{ $value->id }}">
        </td>
        <td class="center">

            {{ $value->societe->nom_ets ?? '' }}


        </td>
        <td>{{ $value->societe->adresse ?? '' }}</td>
       
        <td class="center">
            {{ $value->observation ?? '' }} 
        </td>

        <td class="center">
            {{ $value->societe->tel ?? '' }} 
        </td>

        <th class="center">
            {{$value->societe->categorie->code}}
        </th>

        <th class="center">
           {{ 
            $rdv->nbr_doublon
             }}
        </th>

        <th class="center">
        <a href="{{ route('rdv.show',$value->id) }}" type="submit" class="btn btn-info " value="{{$value->id  ?? ''}}">
                <i class="glyphicon glyphicon-list-alt"></i> Détails</a>
        </th>
    </tr>
    @endforeach

    </tbody>
    </table>
            </div>
@endsection