@extends('layouts.dash')

@section('title') Importations général @stop
@section('subtitle_card',"")

@section('content')

    {{ html()->form('POST', url('compta_import_definitif'))->open() }} 
    <div class="card">
        <div class="card-header bg-info">
            <h3 class="card-title">Brouillon avant importation</div>
        </div>
        <div class="card-body">
            @if (Session::has('message'))
                <div class="alert alert-warning">{!! Session::get('message') !!}</div>
            @endif
            <div class='form-group row'>
                <div class="col-md-12 ">
                    <table id="_table" class="table table-condensed table-striped table-bordered">
                        <thead>
                            <tr>
                                <th width='1%'>Trans.</th>
                                <th width='1%'>Journal</th>
                                <th>DateCpt</th>
                                <th>DateOpé</th>
                                <th>Réf.Ident.</th>
                                <th>Réf.Libellé</th>
                                <th>Compte</th>
                                <th>Compte Libelle</th>
                                <th>Compte Aux.</th>
                                <th>Compte Aux. Libelle</th>
                                <th>Désignation</th>
                                <th>Débit</th>
                                <th>Crédit</th>
                                <th width='1%'>Trim</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php $total_debit=0;$total_credit=0;$total_solde_tr=0;$old_num_transac="";$k=0;$err=""; @endphp
                            @foreach ($tmp_imports as $tmp_import)
                                @php
                                    $k++;
                                    $num_transac=$tmp_import->transaction;
                                    $numcolor=($num_transac%9)-1;
                                    $color=isset(App\Models\MyApp::color_list[$numcolor])?App\Models\MyApp::color_list[$numcolor]:"white";
                                    $total_debit+=$tmp_import->debit;
                                    $total_credit+=$tmp_import->credit;
                                    //pour tester le solde par transaction
                                    if($k==0) $old_num_transac=$num_transac;
                            
                                    if($old_num_transac==$num_transac) {
                                        $total_solde_tr+=$tmp_import->debit-$tmp_import->credit;
                                    } else {
                                        if($total_solde_tr!=0) $err.=(($err=="")?"":",").($num_transac-1);
                                        $total_solde_tr=$tmp_import->debit-$tmp_import->credit;
                                    }
                                @endphp
                                <tr style="background-color:{{ $color }}">
                                    <td align="center">{!! $tmp_import->transaction !!}</td>
                                    <td align="center">{!! $tmp_import->journal !!}</td>
                                    <td nowrap align="center">{!! $tmp_import->date_doc !!}</td>
                                    <td nowrap align="center">{!! $tmp_import->date_ref !!}</td>
                                    <td >{!! $tmp_import->id_ref !!}</td>
                                    <td >{!! $tmp_import->ref_doc !!}</td>
                                    <td align="center">{!! $tmp_import->compte !!}</td>
                                    <td align="center">{!! $tmp_import->compte_label !!}</td>
                                    <td >{!! $tmp_import->compte_aux !!}</td>
                                    <td align="center">{!! $tmp_import->compte_aux_label !!}</td>
                                    <td >{!! $tmp_import->designation !!}</td>
                                    <td align="right">{!! $tmp_import->debit !!}</td>
                                    <td align="right">{!! $tmp_import->credit !!}</td>
                                    <td align="center">{!! $tmp_import->trim !!}</td>
                                </tr>
                                @php $old_num_transac=$num_transac; @endphp
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan='11'></th>
                                <th style="text-align:right;color:darkred">{{ $total_debit }}</th>
                                <th style="text-align:right;color:darkgreen">{{ $total_credit }}</th>
                                <th style="text-align:right;color:{{ ($total_debit-$total_credit<0)?'darkred':'darkgreen' }}">{{ $total_debit-$total_credit }}</th>
                            </tr>
                        </thead>
                    </table>
                </div>
            </div>
        </div>
        <div class="card-footer">
            @if(($total_debit-$total_credit<>0)||($err))
                @if($err)
                    <h3 class="text-danger">Les transactions suivantes ne sont pas équilibrées : {{ $err }}</h3>   
                @else
                    <h3 class="text-danger">Ecritures non équilibrées, importation interdite</h3>
                @endif
            @else
                <button class="btn btn-success" onclick="if(!confirm('Voulez-vous vraiment importer ces lignes dans le Grand-Livre ?')) return false">
                    Importer
                </button>
            @endif
                <a href="{{ url('compta_import_annule') }}" class="btn btn-danger" onclick="if(!confirm('Voulez-vous vraiment annuler cette importation ?')) return false">
                    Annuler l'importation
                </a>
           
        </div>
    </div>
    {{ html()->form()->close() }}
@endsection

@section('scripts')
<script>
  $(function () {
    $("#_table").DataTable({
      "paging": false,
      "lengthChange": false,
      "searching": true,
      "ordering": false,
      "info": true,
      "responsive": false, 
      "autoWidth": true,
      oLanguage: {
                    "sZeroRecords": "Aucune ligne",
                    "sInfo": "Affichage de _START_ &agrave; _END_ sur _TOTAL_ lignes",
                    "sInfoEmpty": "Showing 0 to 0 of 0 records",
                    "sInfoFiltered": "(sur un total de _MAX_ lignes)",
                    "oPaginate": {"sPrevious": "Pr&eacute;c&eacute;dente","sNext": "Suivante"
                        ,"sFirst": "Premi&egrave;re","sLast": "Derni&egrave;re"},
                        "sSearch":"Chercher",         
            buttons: {
                copy: 'Copier',
                copyTitle: 'Ajouté au presse-papiers',
                copyKeys: 'Appuyez sur <i>ctrl</i> ou <i>\u2318</i> + <i>C</i> pour copier les données du tableau à votre presse-papiers. <br><br>Pour annuler, cliquez sur ce message ou appuyez sur Echap.',
                copySuccess: {
                    _: '%d lignes copiées',
                    1: '1 ligne copiée'
                    }
                }
        },
        dom: "<'row'<'col-sm-6'l><'col-sm-6'f>>" + "<'row'<'col-sm-12'tr>>" + "<'row'<'col-sm-4'i><'col-sm-4'B><'col-sm-4'p>>",
        "buttons": ["copy", "excel"], 
    })


  });
</script>
@endsection