@extends('inventaires.layouts')

@section('content')
<div class="row justify-content-center mt-3">
    <div class="col-md-12">

        @if ($message = Session::get('success'))
            <div class="alert alert-success" role="alert">
                {{ $message }}
            </div>
        @endif
        <div class="card">
            <div class="card-header">Inventaire Annuel des Produits avec Prix</div>
            <div class="card-body">
                <div id="toolbar">
                    <a href="{{ route('inventaires.create') }}" class="btn btn-success btn-sm my-2"><i class="bi bi-plus-circle"></i> Renseigner l'Inventaire d'un Produit</a>
                </div>


                <table
                    id="table"
                    data-toolbar="#toolbar"
                    data-toggle="table"
                    data-show-toggle="false"
                    data-show-fullscreen="true"
                    data-search="true"
                    data-show-columns="true"
                    data-pagination="true"
                    data-show-pagination-switch="true"
                    data-show-export="true"
                    data-export-data-type="all"
                    data-export-types="['csv', 'excel' , 'pdf']"
                    data-cookie="true"
                    data-cookie-id-table="inventaireChiffreIndex"
                    class="table table-striped table-bordered"
                    >
                    <thead>
                      <tr>
                        <th scope="col" data-sortable="true">Page</th>
                        <th scope="col" data-sortable="true">Ref</th>
                        <th scope="col" data-sortable="true">Ref2</th>
                        <th scope="col" data-sortable="true">Site</th>
                        <th scope="col" data-sortable="true">Famille</th>
                        <th scope="col" data-sortable="true">Type</th>
                        <th scope="col" data-sortable="true">Essence</th>
                        <th scope="col" data-sortable="true">Qualité</th>
                        <th scope="col">Epaisseur</th>
                        <th scope="col">Largeur</th>
                        <th scope="col">Longueur</th>
                        <th scope="col">Humidité</th>
                        <th scope="col" data-sortable="true">Origine</th>
                        <th scope="col">Date Inv 23</th>
                        <th scope="col">Q23</th>
                        <th scope="col">U23</th>
                        <th scope="col" data-sortable="true">Quantité Inv 23</th>
                        <th scope="col">Prix de Revient Inv 23</th>
                        <th scope="col" data-sortable="true">Total Inv 23</th>
                        <th></th>
                        <th scope="col">Date Inv 24</th>
                        <th scope="col">Q24</th>
                        <th scope="col">U24</th>
                        <th scope="col" data-sortable="true">Quantité Inv 24</th>
                        <th scope="col">Prix de Revient Inv 24</th>
                        <th scope="col" data-sortable="true">Total Inv 24</th>
                        <th></th>
                        <th scope="col">Evolution</th>
                        <th scope="col">Localisation</th>
                      </tr>
                    </thead>
                    <tbody>
                        @forelse ($i2 as $data)
                                                <tr>
                        <td>{{ (strlen($data->analytiqueC)>1 && $data->analytiqueC[0] == 'P'?substr((strpos($data->analytiqueC, '-')?substr($data->analytiqueC, 0, strpos($data->analytiqueC, '-')):$data->analytiqueC),1):$data->analytiqueC) }}</td>
                            <td>{{ $data->referenceA }}</td>
                            <td>{{ $data->referenceB }}</td>
                            @if(null == $data->alternatif || '' == $data->alternatif)
                            <td>{{ $data->site }}</td>
                            <td>{{ $data->famille }}</td>
                            <td>{{ $data->type }}</td>
                            <td>@if( $data->essence == '--N/A--') &nbsp; @else {{ $data->essence }}@endif</td>
                            <td>{{ $data->qualite }}</td>
                            <td>@if($data->epaisseur>0) {{ $data->epaisseur }} @else &nbsp; @endif</td>
                            <td>@if($data->largeur>0) {{ $data->largeur }} @else &nbsp; @endif</td>
                            <td>@if($data->longueur>0) {{ $data->longueur }} @else &nbsp; @endif</td>
                            <td>{{ Produit::humiditeLabelStat($data->humidite); }}</td>
                            @else
                            <td colspan="9">{{ $data->alternatif }}</td>
                            @endif
                            <td>{{ $data->origine }}</td>
                            <td>{{ $data->date_inv_23 }}</td>
                            <td  style="text-align:right">@if($data->quantite_inv_23){{ $data->quantite_inv_23 * 1}}@endif</td>
                            <td  style="text-align:right">@if($data->quantite_inv_23){{$data->unite_inv_23}}@endif</td>
                            <td  style="text-align:right">@if($data->quantite_inv_23){{ $data->quantite_inv_23 * 1}}&nbsp;@endif</td>
                            <td style="text-align:right">@if($data->prix_inv_23){{ $data->prix_inv_23 * 1 }}&nbsp;&euro;@endif</td>
                            <td style="text-align:right">@if($data->quantite_inv_23 * $data->prix_inv_23){{ round($data->quantite_inv_23 * $data->prix_inv_23) }}@endif</td>
                            <td>&nbsp;&euro;</td>
                            <td>{{ $data->date_inv_24 }}</td>
                            <td  style="text-align:right">@if($data->quantite_inv_24){{ $data->quantite_inv_24 * 1}}@endif</td>
                            <td  style="text-align:right">@if($data->quantite_inv_24){{$data->unite_inv_24}}@endif</td>
                            <td  style="text-align:right">@if($data->quantite_inv_24){{ $data->quantite_inv_24 * 1}}&nbsp;@endif</td>
                            <td style="text-align:right">@if($data->quantite_inv_24) @if($data->prix_inv_24){{ $data->prix_inv_24 * 1 }}&nbsp;&euro;@endif @endif</td>
                            <td style="text-align:right">@if($data->quantite_inv_24 * $data->prix_inv_24){{ round($data->quantite_inv_24 * $data->prix_inv_24) }}@endif</td>
                            <td>@if($data->quantite_inv_24)&nbsp;&euro;@endif</td>
                            <td>@if($data->prix_inv_23) @if($data->prix_inv_23>0) @if($data->prix_inv_24) @if($data->prix_inv_24>0) {{($data->prix_inv_24 / $data->prix_inv_23)-1}} @endif @endif @endif @endif</td>
                            <td>{{ $data->localisation_inv_24 }}</td>
                        </tr>
                        @empty
                            <td colspan="13">
                                <span class="text-danger">
                                    <strong>Aucun inventaire!</strong>
                                </span>
                            </td>
                        @endforelse
                    </tbody>
                  </table>

            </div>
        </div>
    </div>    
</div>
    
@endsection