@extends('layouts.squelette')
<!-- ************************************** -->
@section('css_header')
@endsection
<!-- ************************************** -->
@section('titre')
@endsection
<!-- ************************************** -->
@section('titre_header')
@endsection

@section('titre_page')
{{ __("Importation de sites") }}
@endsection
<!-- ************************************** -->
@section('panel_boutons')
@endsection
<!-- ************************************** -->
@section('contenu')

<div class="card card-info card-tabs">
    <div class="card-body">

        <form id="importExcelForm" target="_blank" action="/admin/utils/importsites/importsites_etape1" method="POST" enctype="multipart/form-data">
            @csrf
            <div class="row">
                <div class="col-md-4">
                    @component('components.select.select_sign',['signs' => @$signs,'value' => @$site->sig_id,'search' => 'true','emptyValue' => 'true', 'required' => 'true'])
                    @endcomponent

                    @component('components.select.select_billingcompany',['bilCompanies' => @$billingCompanies,'value' => @$site->bil_id,'search' => 'true','emptyValue' => 'true', 'required' => 'false'])
                    @endcomponent

                    @component('components.cb_ouinon',['title' => 'Mettre un n° sur le nom du site si plusieurs dans la même ville ?',
                        'name' => 'sit_numOnName',
                        'value' => '1'])
                    @endcomponent

                    <div class="form-group">
                        <label for="sit_comment">{{ __('sit_comment') }}</label>
                        <textarea class="form-control" name="sit_comment" id="sit_comment" cols="100" rows="3"></textarea>
                    </div>

                    @component('components.cb_ouinon',['title' => 'Ignorer la première ligne ?',
                        'name' => 'firstline_ignore',
                        'value' => ''])
                    @endcomponent

                    <div class="form-group">
                        <label for="excel_file">{{ __('Fichier Excel') }}</label>
                        <input id="excel_file" class="fileinput_noprev" type="file" name="excel_file">
                    </div>

                    <center>
                        <button id="importExcelBtn" class="btn btn-success btn-import">Importer</button>
                    </center>
                </div>
                <div class="col-md-8">

                    <table id="tab_dispos" class="table text-xs  table-striped table-advance table-compact" width="100%" cellspacing="0" data-order='[[ 0, "asc" ]]'>
                        <thead class="thead-dark">
                            <tr>
                                <th>{{ __('Champ') }}</th>
                                <th>{{ __('N° colonne excel') }}</th>
                                <th>{{ __('Constante') }}</th>
                                {{-- <th>{{ __('Concaténation') }}</th> --}}
                                <th>{{ __('Debut') }}</th>
                                <th>{{ __('Fin') }}</th>
                                <th>{{ __('Format de date') }}</th>
                            </tr>
                        </thead>
                        <tbody>
                            {{-- <tr>
                                <td><b>sig_id</b></td>
                                <td></td>
                                <td><input class="form-control" id="sig_id" type="text" name="sig_id"></td>
                                <td></td>
                            </tr>
                            <tr>
                                <td><b>bil_id</b></td>
                                <td></td>
                                <td><input class="form-control" id="bil_id" type="text" name="bil_id"></td>
                                <td></td>
                            </tr>
                            <tr>
                                <td><b>sit_comment</b></td>
                                <td></td>
                                <td></td>
                                <td><input class="form-control" id="sit_comment" type="text" name="sit_comment"></td>
                            </tr> --}}
                            @for($i=1;$i<=20;$i++)
                                <tr>
                                    <td>
                                        <select id="field_{{$i}}" name="field_{{$i}}" class="form-control selectpicker" title="Sélectionnez le champ">
                                        <option value="" selected=""></option>
                                        @foreach($columns as $column)
                                         <option value="{{$column}}">{{$column}}</option>
                                        @endforeach
                                        </select>
                                    </td>
                                    <td><input class="form-control" id="numcol_{{$i}}" type="text" name="numcol_{{$i}}"></td>
                                    <td><input class="form-control" id="constant_{{$i}}" type="text" name="constant_{{$i}}"></td>
                                    {{-- <td><input class="form-control" id="concat_{{$i}}" type="text" name="concat_{{$i}}"></td> --}}
                                    <td><input class="form-control" id="debut_{{$i}}" type="text" name="debut_{{$i}}"></td>
                                    <td><input class="form-control" id="fin_{{$i}}" type="text" name="fin_{{$i}}"></td>
                                    <td>
                                        <select id="date_format_{{$i}}" name="date_format_{{$i}}" class="form-control selectpicker" title="Sélectionnez">
                                            <option value="" selected=""></option>
                                             <option value="DD/MM/YYYY">DD/MM/YYYY</option>
                                             <option value="YYY-MM-DD">YYY-MM-DD</option>
                                        </select>
                                    </td>
                                </tr>
                            @endfor
                        </tbody>
                    </table>
                    {{-- <ul>
                     @foreach($columns as $column)
                     @if ( ($column!='sit_comment') && ($column!='sit_active') && ($column!='sig_id') && ($column!='cou_id') && ($column!='bil_id') )
                     <li>
                        <label for="{{$column}}">{{$column}}</label>
                        <input type="text" id="{{$column}}" name="{{$column}}" class="form-control ${uppercaseClass}" placeholder="Lettre colonne excel pour {{$column}}">
                     </li>
                     @endif
                     @endforeach
                    </ul> --}}




                </div>

            </div>
        </form>

    </div>
</div>
@endsection

@section('js_footer')
@endsection

@section('modale')
@endsection