@extends('layouts.squelette')
<!-- ************************************** -->
@section('css_header')
@endsection
<!-- ************************************** -->
@section('titre_page')
{{ __("Statistiques sur les activités / lots") }}
@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','multiple' => '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-4">
                            @component('components.select.select_activity',['activities' => '','value' => '','search' => 'true','emptyValue' => 'false'])
                            @endcomponent
                        </div>
                        <div class="col-sm-4">
                            <div class="form-group">
                                <label for="role">{{ __('Devis client') }}</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-4"> 
                            <div class="form-group">
                                <label for="role">{{ __('Portefeuilles') }}</label>
                                <select class="selectpicker form-control " multiple id="wallet_id[]" name="wallet_id[]"   >
                                  <option value=""></option>
                                  @foreach (Session::get('list_wallets') as $item)
                                      <option value="{{$item->wal_id}}"  {{ (Session::get('wallet_selected') == $item->wal_id) ? 'selected' : '' }}  >{{$item->wal_name}}</option>
                                  @endforeach
                                </select> 
                            </div>
                        </div>
                    </div>

                </div>
                <div class="col-md-6">
                    <div class="row">
                        <div class="col-sm-4">
                            @component('components.dates.select_simple',['label' => 'Période (date de réalisation) du','value' => '','name' => 'startDate'])
                            @endcomponent
                        </div>
                        <div class="col-sm-4">
                            @component('components.dates.select_simple',['label' => 'au','value' => '','name' => 'endDate'])
                            @endcomponent
                        </div>
                        <div class="col-sm-2">
                            @component('components.dates.buttons_selection',['target1' => 'startDate','target2' => 'endDate'])
                            @endcomponent
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-sm-6">
                            <div class="form-group">
                                <label for="role">{{ __('Tri des élements') }}</label>
                                    <select class="selectpicker form-control" id="type_tri" name="type_tri">
                                    <option value="activity.act_nameFr">{{ __('Par nom') }} </option>
                                    <option value="total">{{ __('Par valeur / montant') }} </option>
                                </select>
                            </div>
                        </div>
                        <div class="col-sm-6">
                            <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>
            </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 id="div_resultats" name="div_resultats"></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_activites.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_statsCustomers'));
        XLSX.utils.book_append_sheet(workbook, ws1, "demandes");

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

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

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

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

</script>

@endsection

@section('modale')
@endsection