@extends('layouts.squelette')
<!-- ************************************** -->
@section('css_header')
@endsection
<!-- ************************************** -->
@section('titre_page')
{{ __("Statistiques sur les demandes d'intervention") }}
@endsection
<!-- ************************************** -->

<!-- ************************************** -->
@section('panel_boutons')
 @include('layouts.partials.panelboutons', [ 'btn_export'=> true])
@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-6">
                                <div class="row">
                                    <div class="col-sm-6">
                                        @component('components.select.select_customer',['customers' => @$customers,'value' => '','search' => 'true','emptyValue' => 'true'])
                                        @endcomponent
                                    </div>
                                    <div class="col-sm-6">
                                        @component('components.select.select_sign',['signs' => @$signs,'value' => '','search' => 'true','emptyValue' => 'true'])
                                        @endcomponent
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-sm-6">
                                        <div class="form-group">
                                            <label for="role">{{ __('Type de rapport') }}</label>
                                                <select class="selectpicker form-control" id="type_rapport" name="type_rapport">
                                                <option value="MENSUEL" selected>{{ __('Mensuel') }}</option>
                                                <option value="ANNUEL">{{ __('Annuel') }} </option>
                                                </select>
                                        </div>
                                    </div>
                                    <div class="col-sm-6">
                                        <div class="form-group" id="div_sel_nb_mois" name="div_sel_nb_mois">
                                            <label>{{ __('Sur les') }} </label>
                                            <div class="input-group mb-3">
                                            <input class="form-control max200" id="nbmois_type_rapport" name="nbmois_type_rapport" type="text" value="12">
                                            <div class="input-group-append">
                                                <span class="input-group-text" id="basic-addon2">{{ __('derniers mois') }}</span>
                                            </div>
                                            </div>
                                        </div>

                                        <div class="form-group" id="div_sel_nb_ans" name="div_sel_nb_ans">
                                            <label>{{ __('Sur les') }} </label>
                                            <div class="input-group mb-3">
                                            <input class="form-control max200" id="nban_type_rapport" name="nban_type_rapport" type="text" value="5">
                                            <div class="input-group-append">
                                                <span class="input-group-text" id="basic-addon2">{{ __('dernieres années') }}</span>
                                            </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-sm-6">
                                        <div class="form-group">
                                        <label for="role">{{ __('Devis prestataire') }}</label>
                                            <select class="selectpicker form-control" id="type_devis" name="type_devis">
                                            <option value="" selected>{{ __('Toutes') }}</option>
                                            <option value="avec">{{ __('Avec devis uniquement') }} </option>
                                            <option value="sans">{{ __('Sans devis uniquement') }} </option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-sm-6">
                                        @component('components.select.select_activity',['activities' => '','value' => '','search' => 'true','emptyValue' => 'false'])
                                        @endcomponent
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="row">
                                    <div class="col-sm-4">
                                        @component('components.dates.select_simple',['label' => 'Demandes créées entre le','value' => '','name' => 'int_createdDate1'])
                                        @endcomponent
                                    </div>
                                    <div class="col-sm-4">
                                        @component('components.dates.select_simple',['label' => 'et le','value' => '','name' => 'int_createdDate2'])
                                        @endcomponent
                                    </div>
                                    <div class="col-sm-2">
                                        @component('components.dates.buttons_selection',['target1' => 'int_createdDate1','target2' => 'int_createdDate2'])
                                        @endcomponent
                                    </div>
                                    <div class="col-sm-4">
                                        @component('components.dates.select_simple',['label' => 'Demandes planifiées entre le','value' => '','name' => 'int_planningDate1'])
                                        @endcomponent
                                    </div>
                                    <div class="col-sm-4">
                                        @component('components.dates.select_simple',['label' => 'et le','value' => '','name' => 'int_planningDate2'])
                                        @endcomponent
                                    </div>
                                    <div class="col-sm-2">
                                        @component('components.dates.buttons_selection',['target1' => 'int_planningDate1','target2' => 'int_planningDate2'])
                                        @endcomponent
                                    </div>
                                </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;
                            <!--<a class="btn btn-defaut app2" id="btn_export" href="export/{{ request()->path() }}" data-export={{ Route::current()->getName() }}> <i class="fas fa-file-export"></i> {{ __("Exporter") }} </a>
                            <a class="btn btn-defaut app2" id="btn_export" href="export/{{ request()->path() }}" data-export={{ Route::current()->getName() }}> <i class="fas fa-file-pdf"></i> {{ __("Editer") }} </a>-->
                        </div>
                    </div>
            </div>
    </form>

    <div class="row">
        <div class="col-md-12">
            <div class="card card-gray">
                <div class="card-header">
                 <h3 class="card-title">{{ __('Nombre de demandes et coût') }}</h3>
                </div>
                <div class="card-body">
                    <div id="div_stats_di" name="div_stats_di"></div>

                </div>
            </div>
        </div>
        <div class="col-md-12">
            <div class="card card-gray">
                <div class="card-header">
                  <h3 class="card-title">{{ __('Délais') }}</h3>
                </div>
                <div class="card-body">
                    <div id="div_stats_delais_di" name="div_stats_delais_di"></div>
                </div>
              </div>
        </div>
    </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_di.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_statsDi'));
            XLSX.utils.book_append_sheet(workbook, ws1, "Demandes_couts");

            var ws2 = XLSX.utils.table_to_sheet(document.getElementById('tab_statsDiDelais1'));
            XLSX.utils.book_append_sheet(workbook, ws2, "Delais_planif");

            var ws2 = XLSX.utils.table_to_sheet(document.getElementById('tab_statsDiDelais2'));
            XLSX.utils.book_append_sheet(workbook, ws2, "Delais_real");

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

            XLSX.writeFile(workbook, 'stats_interventions.' + type);

            // var data = document.getElementById('tab_statsDi');

            // var file = XLSX.utils.table_to_book(data, {sheet: "demandes"});
            // var file = XLSX.utils.table_to_book(data, {sheet: "tab_statsDiDelais3"});

            // XLSX.write(file, { bookType: type, bookSST: true, type: 'base64' });

            //XLSX.writeFile(file, 'file.' + type);
        }

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

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

@endsection

@section('modale')
@endsection