@extends('layouts.squelette')
<!-- ************************************** -->
@section('css_header')
@endsection
<!-- ************************************** -->
@section('titre_page')
{{ __('Statistiques sur les prestataires') }}
@endsection
<!-- ************************************** -->
@section('js_header')
<script type="text/javascript" src="{{ asset('plugins/sheetjs-master/dist/xlsx.full.min.js')}}"></script>
@endsection
<!-- ************************************** -->
@section('contenu')

<form id="formSearch" class="collapse show" method="POST" action="">
    <input type="hidden" name="filtering" value="ok">
    @csrf
    {{ csrf_field() }}
                <div class="h-20"></div>
                <div class="panel">
                    <div class="panel-body">
                        <div class="row">

                            <div class="col-md-3">
                                @component('components.select.select_activity',['activities' => '','value' => '','search' => 'true','multiple' => 'true','emptyValue' => 'false'])
                                @endcomponent
                            </div>
                            <div class="col-md-3">
                                @component('components.select.select_provider',['providers' => '','value' => '','multiple' => 'true', 'search' => 'true','emptyValue' => 'false'])
                                @endcomponent
                            </div>

                            <div class="col-sm-3">
                                @component('components.dates.select_simple',['label' => 'Date de création des DI du','value' => '','name' => 'startDate'])
                                @endcomponent
                            </div>

                            <div class="col-sm-3">
                                @component('components.dates.select_simple',['label' => 'au','value' => '','name' => 'endDate'])
                                @endcomponent
                            </div>

                            <div class="col-sm-3">
                            </div>

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="role">{{ __('Type de DI') }}</label>
                                        <select class="selectpicker form-control" id="type_provider" name="type_provider">
                                        <option value="">{{ __('Tous') }} </option>
                                        <option value="with_proQuo">{{ __('Avec demande de devis') }} </option>
                                        <option value="with_proReq">{{ __('Avec commande') }} </option>
                                        <option value="with_proInv">{{ __('Avec facture') }} </option>
                                    </select>
                                </div>
                            </div>

                            {{-- <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="role">{{ __('Tri des élements') }}</label>
                                        <select class="selectpicker form-control" id="type_tri" name="type_tri">
                                        <option value="site.sit_name">{{ __('Par prestataire') }} </option>
                                        <option value="total">{{ __('Par nombre d\'interventions') }} </option>
                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-3">
                                <div class="form-group">
                                    <label for="role">{{ __('Ordre') }}</label>
                                        <select class="selectpicker form-control" id="ordre_tri" name="ordre_tri">
                                        <option value="asc">{{ __('Croissant') }} </option>
                                        <option value="desc">{{ __('Décroissant') }} </option>
                                    </select>
                                </div>
                            </div> --}}

                        </div>

                        <div class="text-center">
                            <button type="button" id="BTN_valid_formsearch" class="btn btn-secondary btn-see" >{{ __('Afficher') }}</button>
                            <button type="button" id="BTN_export" class="btn btn-success btn-export">{{ __('Exporter les résultats') }}</button>
                            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                        </div>
                    </div>
            </div>
    </form>


    <div id="div_stats_delais" name="div_stats_delais"></div>


  </section>
  <!-- /.content -->

@endsection

@section('js_footer')
<script src="{{ asset('plugins/chart.js/Chart.min.js')}}"></script>
    <script src="{{ asset('js/fonctions/init_datatables.js')}}"></script>
    <script src="{{ asset('js/reporting/reporting_providers.js')}}"></script>

    <script>
        //https://github.com/SheetJS/sheetjs
        function html_table_to_excel(type)
        {
            /* create new workbook */
            var workbook = XLSX.utils.book_new();

            // var ws1 = XLSX.utils.table_to_sheet(document.getElementById('tab_stats_factures'));
            // XLSX.utils.book_append_sheet(workbook, ws1, "factures");

            // var ws2 = XLSX.utils.table_to_sheet(document.getElementById('tab_stats_notations'));
            // XLSX.utils.book_append_sheet(workbook, ws2, "notations");

            // var ws2 = XLSX.utils.table_to_sheet(document.getElementById('tab_stats_devis'));
            // XLSX.utils.book_append_sheet(workbook, ws2, "devis");

            // var ws2 = XLSX.utils.table_to_sheet(document.getElementById('tab_stats_delais1'));
            // XLSX.utils.book_append_sheet(workbook, ws2, "delais1");

            // var ws2 = XLSX.utils.table_to_sheet(document.getElementById('tab_stats_delais2'));
            // XLSX.utils.book_append_sheet(workbook, ws2, "delais2");

            var ws1 = XLSX.utils.table_to_sheet(document.getElementById('tab_stats'));
            XLSX.utils.book_append_sheet(workbook, ws1, "prestataires");

            XLSX.writeFile(workbook, 'stats_prestataires.' + type);
        }

        const export_button = document.getElementById('BTN_export');

        export_button.addEventListener('click', () =>  {
            html_table_to_excel('xlsx');
        });
    </script>

@endsection

@section('modale')
@endsection