@extends('layouts.app',[
    'class' => '',
    'folderActive' => '',
    'elementActive' => 'operations-164'
])

@section('content')
    <div class="app-page-title">
        <div class="page-title-wrapper">
            <div class="page-title-heading">
                <div class="page-title-icon">
                    <i class="fas fa-clipboard-list icon-gradient bg-mean-fruit"></i>
                </div>
                <div>
                    Opérations {{config('types.type_rapport.'.config('types.demande_to_rapports.' . $type_demande))}}
                    <div class="page-title-subheading">
                        Liste des opérations
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="main-card mb-3 card col-md-12 col-xl-12">
            <div class="no-gutters row">
                <div class="col-md-12 col-xl-2">
                    <div class="widget-content">
                        <div class="widget-content-wrapper">
                            <div class="widget-content-right ml-0 mr-3">
                                <div class="widget-numbers text-primary">{{$op['demandes']}}</div>
                            </div>
                            <div class="widget-content-left">
                                <div class="widget-heading">Total des</div>
                                <div class="widget-subheading">des demandes</div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['en_attente']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">Demandes</div>

                                <div class="widget-subheading">à traiter</div>

                            </div>

                        </div>

                    </div>

                </div>
                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['refusees']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">Demandes</div>

                                <div class="widget-subheading">refusées</div>

                            </div>

                        </div>

                    </div>

                </div>

                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['rdv_places']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">RDV</div>

                                <div class="widget-subheading">pris</div>

                            </div>

                        </div>

                    </div>

                </div>

                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['rdv_non_transformes']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">RDV</div>

                                <div class="widget-subheading">non transformes</div>

                            </div>

                        </div>

                    </div>

                </div>

                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['rdv_a_venir']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">RDV</div>

                                <div class="widget-subheading">à venir</div>

                            </div>

                        </div>

                    </div>

                </div>

                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['nbre_rapports']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">Rapports</div>

                                <div class="widget-subheading">effectués</div>

                            </div>

                        </div>

                    </div>

                </div>

                <div class="col-md-12 col-xl-2">

                    <div class="widget-content">

                        <div class="widget-content-wrapper">

                            <div class="widget-content-right ml-0 mr-3">

                                <div class="widget-numbers text-danger">
                                    {{$op['rapports_non_valides']}}
                                </div>

                            </div>

                            <div class="widget-content-left">

                                <div class="widget-heading">Rapports</div>

                                <div class="widget-subheading">Non validés</div>

                            </div>

                        </div>

                    </div>

                </div>



            </div>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12 col-xl-12">
            <div class="col-md-12">
                <div class="main-card mb-3 card">
                    <div class="table-responsive">

                        <a class="btn btn-primary init">Réinitialiser</a>

                        <table id="liste_operations"
                               class="align-middle mb-0 table table-borderless table-striped table-hover datatable">
                            <thead>
                            <tr>
                                <th>Client</th>
                                <th>Total des demandes</th>
                                <th>Demandes à traiter</th>
                                <th >Client_id</th>
                                <th>Demandes rejetées</th>
                                <th>RDV pris</th>
                                <th>RDV non transformés en rapports</th>
                                <th>RDV à venir</th>
                                <th>Rapports effectués</th>
                                <th>Rapports en attente de validation</th>
                                <th>Rapports incomplets</th>
                            </tr>
                            </thead>

                            @foreach ($results as $value)
                              
                                <tr>
                                    <td>{{ $value['client_title'] }}</td>
                                    <td style="text-align: center">
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="widget-numbers text-primary">
                                                        {{$value['count_demandes']}}
                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>
                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div style="cursor:pointer" class="widget-numbers text-danger filter"  data-column="3" data-client_id="{{$value['client_id']}}">
                                                        {{$value['demandes_non_traitees']}}
                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>
                                    <td >

                                                        {{$value['client_id']}}


                                    </td>
                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="widget-numbers text-danger">
                                                        {{$value['demandes_refusees']}}
                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="widget-numbers text-success">
                                                        {{$value['rdv_pris']}}

                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="">

                                                        <a target="_blank"
                                                           class="filter" data-column="3" data-client_id="{{$value['client_id']}}"><span
                                                                class="badge badge-pill badge-danger">{{$value['rdv_non_transformes']}} RDV non transformés</span></a>

                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="">

                                                        <a target="_blank" class="filter" data-column="3" data-client_id="{{$value['client_id']}}"
                                                           ><span
                                                                class="badge badge-pill badge-warning">{{$value['rdv_a_venir']}} RDV à venir</span></a>

                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="">

                                                        <a target="_blank"
                                                           href="/rapports?client_id={{$value['client_id']}}&cdp=2&type_rapport={{config('types.demande_to_rapports.' . $type_demande)}}"><span
                                                                class="badge badge-pill badge-primary">{{$value['rapports']}} rapports effectués</span></a>

                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

                                    <td style="text-align:center">
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="">

                                                        <a target="_blank"
                                                           href="/rapports?client_id={{$value['client_id']}}&cdp=2&type_rapport={{config('types.demande_to_rapports.' . $type_demande)}}&statut_rdv=1"><span
                                                                class="badge badge-pill badge-danger">{{$value['rapports_non_valides']}} rapports non validés</span></a>


                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

                                    <td>
                                        <div class="widget-content">

                                            <div class="widget-content-wrapper">

                                                <div class="widget-content-right ml-0 mr-3">

                                                    <div class="widget-numbers text-warning">
                                                     {{$value['demandes_non_traitees']}}

                                                    </div>

                                                </div>

                                            </div>

                                        </div>

                                    </td>

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


    <div class="row">
        <div class="col-sm-12 col-lg-12 col-xl-12">
            <div class="main-card mb-3 card">
                <div class="card-body"><h5 class="card-title">RDV restants
                        (<span id="count_rdv">{{ count($rdv_left) }}</span>)</h5>


                    <table class="mb-0 table" id="rdv_operation">
                        <thead>
                        <tr>
                            <th>Date du RDV</th>
                            <th>Date du RDV</th>
                            <th>ID Client</th>
                            <th>ID Client</th>
                            <th>Bénéficiaire</th>
                            


                            <th></th>
                            <th>Inspecteur</th>
                            <th></th>
                            <th></th>
                            <th></th>

                        </tr>
                        </thead>
                        @foreach($rdv_left as $rdv)
                            <tr class="rdv_{{ $rdv['id_rdv'] }} ">

                                <td>{{ strtotime($rdv['date_rdv']) }}</td>
                                <td>{{ date("d/m/Y", strtotime($rdv['date_rdv'])) }}</td>
                                <td>{{ $rdv['client_title'] }}</td>
                                <td>{{ $rdv['client_id'] }}</td>

                                <td>{!! '<strong>' . $rdv['beneficiaire_name'] . '</strong><br/>' . $rdv['beneficiaire_adresse'] . '<br/>' . $rdv['beneficiaire_cp'] . ' ' . $rdv['beneficiaire_ville'] !!}</td>
                                <td>
                                   @if(strtotime($rdv['date_rdv'])<strtotime('now')) 
                                   Non transformé
                                   @endif

                                   @if(strtotime($rdv['date_rdv'])>strtotime('now')) 
                                   A venir
                                   @endif

                                </td>
                                <td><a class="btn btn-primary"
                                       style="background:{{ $rdv['color'] }}">{{ $rdv['user_firstname'] . ' ' . $rdv['user_lastname'] }}</a>
                                </td>

                                <td></td>

                                <td></td>
                                <td><a class="btn btn-primary "
                                       href="{{ route('demandes.show', $rdv['demande_id']) }}"
                                       target="_blank"
                                       data-rdv_id="{{ $rdv['demande_id'] }}"
                                    >Voir la demande</a>
                                </td>
                            </tr>

                        @endforeach

                    </table>
                </div>

            </div>

        </div>
    </div>



    <div class="row">
        <div class="col-sm-12 col-lg-12 col-xl-12">
            <div class="main-card mb-3 card">
                <div class="card-body"><h5 class="card-title">Demandes à traiter
                        (<span id="count_demandes">{{ count($demande_left) }}</span>)</h5>


                    <table class="mb-0 table" id="demandes_operation">
                        <thead>
                        <tr>
                            <th>Date de la demande</th>
                            <th>Date de la demande</th>
                            <th>ID Client</th>
                            <th>ID Client</th>
                            <th>Bénéficiaire</th>
                            


                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>
                            <th></th>

                        </tr>
                        </thead>
                        @foreach($demande_left as $demande)
                            <tr class="rdv_{{ $demande['demande_id'] }} ">

                                <td>{{ strtotime($demande['date_demande']) }}</td>
                                <td>{{ date("d/m/Y", strtotime($demande['date_demande'])) }}</td>
                                <td>{{ $demande['client_title'] }}</td>
                                <td>{{ $demande['client_id'] }}</td>

                                <td>{!! '<strong>' . $demande['proprietaire_name'] . '</strong><br/>' . $demande['proprietaire_adresse'] . '<br/>' . $demande['proprietaire_cp'] . ' ' . $demande['proprietaire_ville'] !!}</td>
                                <td>


                                </td>
                                <td></td>
                                <td></td>
                                <td></td>


                                <td><a class="btn btn-primary "
                                       href="{{ route('demandes.show', $rdv['demande_id']) }}"
                                       target="_blank"
                                       data-rdv_id="{{ $rdv['demande_id'] }}"
                                    >Voir la demande</a>
                                </td>
                            </tr>

                        @endforeach

                    </table>
                </div>

            </div>

        </div>
    </div>

    <script type="text/javascript"
            src="{{ asset('js/datatables.js') }}">
    </script>
    <script type="text/javascript">


                let table1 = $('#rdv_operation').DataTable({
            "language": {
                "sProcessing": "Traitement en cours...",
                "sSearch": "Rechercher&nbsp;:",
                "sLengthMenu": "Afficher _MENU_ &eacute;l&eacute;ments",
                "sInfo": "Affichage de l'&eacute;l&eacute;ment _START_ &agrave; _END_ sur _TOTAL_ &eacute;l&eacute;ments",
                "sInfoEmpty": "Affichage de l'&eacute;l&eacute;ment 0 &agrave; 0 sur 0 &eacute;l&eacute;ment",
                "sInfoFiltered": "(filtr&eacute; de _MAX_ &eacute;l&eacute;ments au total)",
                "sInfoPostFix": "",
                "sLoadingRecords": "Chargement en cours...",
                "sZeroRecords": "Aucun &eacute;l&eacute;ment &agrave; afficher",
                "zeroRecords": "Aucun rapport à afficher, veuillez appliquer 1 ou plusieurs filtres",
                "sEmptyTable": "Aucune donn&eacute;e disponible dans le tableau",
                "oPaginate": {
                    "sFirst": "Premier",
                    "sPrevious": "Pr&eacute;c&eacute;dent",
                    "sNext": "Suivant",
                    "sLast": "Dernier"
                }
            },

            "searching": true,
            "ordering": true,
            "sortable": true,
            "pageLength": -1,
            "bLengthChange": false,
            "bInfo": false,
            "bFilter": true,
            "order": [0, "desc"],
            "deferRender": true,

        columnDefs: [{
            targets: [0],
            orderData: [0],
            visible: false
        },

        {
            targets: [3],
            visible: false
        },
         {
            targets: [1],
            orderData: [0]
        }],

        });


                let table2 = $('#demandes_operation').DataTable({
            "language": {
                "sProcessing": "Traitement en cours...",
                "sSearch": "Rechercher&nbsp;:",
                "sLengthMenu": "Afficher _MENU_ &eacute;l&eacute;ments",
                "sInfo": "Affichage de l'&eacute;l&eacute;ment _START_ &agrave; _END_ sur _TOTAL_ &eacute;l&eacute;ments",
                "sInfoEmpty": "Affichage de l'&eacute;l&eacute;ment 0 &agrave; 0 sur 0 &eacute;l&eacute;ment",
                "sInfoFiltered": "(filtr&eacute; de _MAX_ &eacute;l&eacute;ments au total)",
                "sInfoPostFix": "",
                "sLoadingRecords": "Chargement en cours...",
                "sZeroRecords": "Aucun &eacute;l&eacute;ment &agrave; afficher",
                "zeroRecords": "Aucun rapport à afficher, veuillez appliquer 1 ou plusieurs filtres",
                "sEmptyTable": "Aucune donn&eacute;e disponible dans le tableau",
                "oPaginate": {
                    "sFirst": "Premier",
                    "sPrevious": "Pr&eacute;c&eacute;dent",
                    "sNext": "Suivant",
                    "sLast": "Dernier"
                }
            },

            "searching": true,
            "ordering": true,
            "sortable": true,
            "pageLength": -1,
            "bLengthChange": false,
            "bInfo": false,
            "bFilter": true,
            "order": [0, "desc"],
            "deferRender": true,

        columnDefs: [{
            targets: [0],
            orderData: [0],
            visible: false
        },

        {
            targets: [3],
            visible: false
        },
         {
            targets: [1],
            orderData: [0]
        }],

        });

        let table = $('#liste_operations').DataTable({
            "language": {
                "sProcessing": "Traitement en cours...",
                "sSearch": "Rechercher&nbsp;:",
                "sLengthMenu": "Afficher _MENU_ &eacute;l&eacute;ments",
                "sInfo": "Affichage de l'&eacute;l&eacute;ment _START_ &agrave; _END_ sur _TOTAL_ &eacute;l&eacute;ments",
                "sInfoEmpty": "Affichage de l'&eacute;l&eacute;ment 0 &agrave; 0 sur 0 &eacute;l&eacute;ment",
                "sInfoFiltered": "(filtr&eacute; de _MAX_ &eacute;l&eacute;ments au total)",
                "sInfoPostFix": "",
                "sLoadingRecords": "Chargement en cours...",
                "sZeroRecords": "Aucun &eacute;l&eacute;ment &agrave; afficher",
                "zeroRecords": "Aucun rapport à afficher, veuillez appliquer 1 ou plusieurs filtres",
                "sEmptyTable": "Aucune donn&eacute;e disponible dans le tableau",
                "oPaginate": {
                    "sFirst": "Premier",
                    "sPrevious": "Pr&eacute;c&eacute;dent",
                    "sNext": "Suivant",
                    "sLast": "Dernier"
                }
            },

            "searching": true,
            "ordering": true,
            "sortable": true,
            "pageLength": -1,
            "bLengthChange": false,
            "bInfo": false,
            "bFilter": true,
            "order": [1, "desc"],
            "deferRender": true,
                    columnDefs: [

        {
            targets: [3],
            visible: false
        },
        ],
        });

$( ".filter" ).click(function() {

    var searchTerm=$(this).data('client_id');

    regex = searchTerm;

    table1
        .columns( $(this).data('column') )
        .search( '^'+searchTerm+'$', true, false )
        .draw();

    table2
        .columns( $(this).data('column') )
        .search( '^'+searchTerm+'$', true, false )
        .draw();


    table
        .columns( $(this).data('column') )
        .search( '^'+searchTerm+'$', true, false )
        .draw();


});

$( ".init" ).click(function() {



   table2.columns().search('').draw();
   table1.columns().search('').draw();
   table.columns().search('').draw();




});


  table1.on( 'draw', function () {


    $('#count_rdv').html(table1.rows( {search:'applied'} ).count());

  } );

  table2.on( 'draw', function () {


    $('#count_demandes').html(table2.rows( {search:'applied'} ).count());

  } );
    </script>

@endsection