@php
    $addInfo = json_decode($data['additional_info']);
    $year = date('y', strtotime($addInfo->periodicity));
    $sumBrut = $data['FirstYearElapsedDepreciation'];
    $brut = $addInfo->unit_price;// - $data['FirstYearElapsedDepreciation'];
    $i = 1;
@endphp
@extends('templates.base.base_support')
@section('bindLabelCode', "spécifique du terrain")
@section('labelledChart', $addInfo->chart." ".$addInfo->chart_label)
@section('ministry', ucwords($addInfo->ministry))
@section('direction', ucwords($addInfo->direction))
@section('creator', "test")

@section('content')
    <style>
        .table{
            width: 100%;
            border-collapse: collapse;
            font-size: x-small;
        }
        .table td{
            border: 2px solid #000;
            text-align: center;
        }
        .head-table{
            width: 100%;
            border-collapse: collapse;
        }
        .gl-header td{
            border: 2px solid #000;
            text-align: center;
            font-weight: bold;
            font-size: small;
            border-collapse: collapse;
        }
        ul li {
            list-style-type: none;
            padding-left: -10px;
        }
    </style>
    <div style="background-color: #c5c6c7;padding: 5px;border: 2px solid black;border-bottom: none;border-top: none;">
        <table class="head-table">
            <tbody>
                <tr>
                    <td style="font-weight: bold;">Site</td>
                    <td>{{$addInfo->site}}</td>
                    <td style="font-weight: bold;">Province</td>
                    <td>{{ucfirst($addInfo->provincy)}}</td>
                    <td style="font-weight: bold;">Département</td>
                    <td>{{$addInfo->departement}}</td>
                    <td style="font-weight: bold;">Ville/Commune</td>
                    <td>{{ucfirst($addInfo->city)}}</td>
                    <td style="font-weight: bold;">Arrondissement</td>
                    <td>{{$addInfo->arrondissement}}</td>
                </tr>
                <tr>
                    <td style="font-weight: bold;">Coordonnées GPS</td>
                    <td>{{"gps"}}</td>
                    <td colspan="6"></td>
                    <td style="font-weight: bold;">Quartier/Village</td>
                    <td>{{$addInfo->quater}}</td>
                </tr>
            </tbody>
        </table>
    </div>
    <div style="background-color: #c5c6c7;padding: 5px;border: 2px solid black;border-bottom: none;border-top: none;">
        <table class="head-table">
            <tbody>
                <tr>
                    <td>Situation juridique</td>
                    <td>
                        <table style="width: 100%">
                            <tbody>
                                <tr>
                                    <td colspan="2" style="white-space: nowrap;">
                                        <span style="font-weight: bold;">1- N° titre foncier : </span> {{$addInfo->tf}}
                                    </td>
                                    <td colspan="2" style="white-space: nowrap;">
                                        <span style="font-weight: bold;">2- Parcelle N° : </span> {{$addInfo->parcelle}}
                                    </td>
                                    <td colspan="2" style="white-space: nowrap;">
                                        <span style="font-weight: bold;">3- Section N° : </span> {{$addInfo->section}}
                                    </td>
                                    <td colspan="2">
                                        <span style="font-weight: bold;">4- Surface/Superficie(m²) : </span>{{$addInfo->area." m²"}}
                                    </td>
                                    <td colspan="2">
                                        <span style="font-weight: bold;">5- DUP </span>{{"dup"}}
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="2">
                                        <span style="font-weight: bold;">6- RI </span>{{"ri"}}
                                    </td>
                                    <td colspan="2">
                                        <span style="font-weight: bold;">7- RF </span>{{"rf"}}
                                    </td>
                                    <td colspan="2">
                                        <span style="font-weight: bold;">8- RG </span>{{"rg"}}
                                    </td>
                                    <td colspan="2">
                                        <span style="font-weight: bold;">9- ZAC </span>{{"zac"}}
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
    <div style="background-color: #c5c6c7;padding: 5px;border: 2px solid black;border-top: none;border-bottom: none;">
        <table class="head-table">
            <tbody>
                <tr>
                    <td>
                        <table>
                            <tbody>
                                <tr>
                                    <td style="font-weight: bold;">
                                        Nature du terrain(agricole, forrestier, minier, etc...)
                                    </td>
                                    <td>{{$addInfo->type_land}}</td>
                                </tr>
                                <tr>
                                    <td style="font-weight: bold;">Nombre de batiments sur le terrain ou la parcelle</td>
                                    <td>{{$addInfo->piece}}</td>
                                </tr>
                                <tr>
                                    <td style="font-weight: bold;">Superficie du terrain</td>
                                    <td>{{$addInfo->area}}</td>
                                </tr>
                                <tr>
                                    <td style="font-weight: bold;">Etat du terrain( très bon, bon, acceptable, dégradé, etc...)</td>
                                    <td>{{$addInfo->state}}</td>
                                </tr>
                            </tbody>
                        </table>
                    </td>
                    <td>
                        <table>
                            <tbody>
                                <tr>
                                    <td style="font-weight: bold;">Autres caractéristiques</td>
                                    <td></td>
                                </tr>
                            </tbody>
                        </table>
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
    <div style="background-color: #c5c6c7;padding: 5px;border: 2px solid black;border-top: none;border-bottom: none;">
        <table class="head-table">
            <tbody>
                <tr>
                    <td style="font-weight: bold;">Aspect juridique : </td>
                    <td>
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label> Terrain appartenant à l'état
                    </td>
                    <td>
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label> Terrain appartenant à autrui
                    </td>
                    <td>
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label> Autres cas
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
    <div>
        <table class="table">
            <tbody>
                <tr class="gl-header">
                    <td rowspan="2">Date</td>
                    <td rowspan="2">Nature de l'opération</td>
                    <td rowspan="2">No de prise  en <br/>charge à l'inventaire</td>
                    <td rowspan="2">Hors bilan d'ouverture: <br/> nom de propriétaire <br/> exproprié ou donateur</td>
                    <td rowspan="2">No cadastre</td>
                    <td rowspan="2">Date de mise <br/> en service</td>
                    <td colspan="3">Bénéficiare</td>
                    <td colspan="3">Montant</td>
                </tr>
                <tr class="gl-header">
                    <td >Ministère <br/> ou Institution</td>
                    <td>Direction</td>
                    <td>Service occupant</td>
                    <td >Brut</td>
                    <td>Dépréciation</td>
                    <td>Net(fin d'exercice)</td>
                </tr>
                <tr class="gl-header">
                    <td colspan="12" style="text-align: left;padding-left: 5px;">1. Entrée : modalités d'entrée (bilan d'ouverture, acquisition à titre onéreux, don, bien mis à disposition, grosse réparation)</td>
                </tr>
                <tr class="gl-header">
                    <td>
                        {{date('d/m/y', strtotime($addInfo->periodicity))}}
                    </td>
                    <td>
                        {{ $addInfo->cat_op }}
                    </td>
                    <td>
                        {{$addInfo->code}}
                    </td>
                    <td>Agent 007</td>
                    <td>{{$addInfo->ref_input}}</td>
                    <td>
                        {{$addInfo->due_date}}
                    </td>
                    <td>
                        {{ucwords($addInfo->ministry)}}
                    </td>
                    <td>
                        {{ucwords($addInfo->direction)}}
                    </td>
                    <td>
                        {{ucwords($addInfo->service)}}
                    </td>
                    <td style="white-space: nowrap;">
                        {{number_format($brut, 0, ',', ' ')}}
                    </td>
                    <td style="white-space: nowrap;">
                        {{number_format($brut, 0, ',', ' ')}}
                    </td>
                    <td style="white-space: nowrap;">
                        {{number_format($brut*0, 0, ',', ' ')}}
                    </td>
                </tr>
                <tr class="gl-header" style="text-align: left">
                    <td colspan="12" style="text-align: left;padding-left: 5px;">2. Inventaire annuel</td>
                </tr>
                @for($i = 1; $i <= $data['ElapsedYearOndepreciation'];$i++)
                    @php $sumBrut += $data['annualRate'];@endphp
                    <tr class="gl-header">
                        <td>
                            {{"31/12/".(int)$year + $i}}
                        </td>
                        <td colspan="9" style="text-align: left;">
                            Dotation aux amortissements ({{number_format($addInfo->unit_price, 0, ',', ' ')}} x {{$addInfo->rate_amort}})
                        </td>
{{--                        <td style="white-space: nowrap;">{{number_format($brut, 0, ',', ' ')}}</td>--}}
                        <td style="white-space: nowrap;">{{number_format($data['annualRate'], 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($brut - $sumBrut, 0, ',', ' ')}}</td>
                    </tr>
                @endfor
                @if($data['ElapsedYearOndepreciation'] == $addInfo->durer_amort)
                    <tr class="gl-header">
                        <td>
                            {{"31/12/".(int)$year + $i++}}
                        </td>
                        <td colspan="10" style="text-align: left;">
                            Dotation aux amortissements ( {{number_format($addInfo->unit_price, 0, ',', ' ')." x ".$addInfo->rate_amort." x ".$data['LastMonth']."/12"}} )
                        </td>
                        {{--                    <td style="white-space: nowrap;">{{number_format($data['annual_rate'], 0, ',', ' ')}}</td>--}}
                        <td style="white-space: nowrap;">{{number_format($brut - $sumBrut, 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format(($brut - $sumBrut)*0, 0, ',', ' ')}}</td>
                    </tr>
                @endif
                <tr class="gl-header" style="text-align: left">
                    <td colspan="12" style="text-align: left;padding-left: 5px;">3. Sortie définitive (cession, perte ou destruction)</td>
                </tr>
                <tr class="gl-header">
                    <td></td>
                    <td></td>
                    <td colspan="7" style="text-align: left">
                        Bénéficiare si cession : <br>
                        Prix de cession :
                    </td>
                    <td style="text-align: center"></td>
                    <td style="text-align: center"></td>
                    <td style="text-align: center"></td>
                </tr>
{{--                <tr class="gl-header">--}}
{{--                    <td colspan="9"> Constatation de la sortie définitive : en moins le montant cumulé brut (a), le montant cumulé des ammortissments (b)</td>--}}
{{--                    <td></td>--}}
{{--                    <td></td>--}}
{{--                    <td></td>--}}
{{--                </tr>--}}
                <tr class="gl-header" style="text-align: left">
                    <td colspan="6" style="text-align: left;"><span style="padding-left: 5px;">4. Autres informations</span> <br>
                        <ul>
                            <li>Dépréciation exceptionnelle, object d'une provision pour dépréciation(dossier annexe)</li>
                            <li>Bien concédé par l'Etat ou l'entité publique(dossier en annexe)</li>
                            <li>Autres : </li>
                            <li>Nom ou code des agents récenseurs</li>
                        </ul>
                    </td>
                    <td colspan="6" style="text-align: left; padding-left: 5px;">
                        NB <br/>
                        <ul>
                            <li><span style="color: red">RI</span> = Réquisition d'Immatriculation</li>
                            <li><span style="color: red">RF</span> = Réservation Foncière</li>
                            <li><span style="color: red">DUP</span> = Déclaration d'Utilité Publique</li>
                            <li><span style="color: red">ZAC</span> = Zone d'Aménagement Concerté</li>
                        </ul>
                    </td>
                </tr>
            </tbody>
        </table>
    </div>
@endsection