@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 des immeubles batis")
@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 style="font-weight: bold;">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 style="font-weight: bold;">Aspect juridique : </td>
                    <td>
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label>Sur terrain appartenant à l'état
                    </td>
                    <td>
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label> Sur terrain appartenant à autrui
                    </td>
                    <td>
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label> Bien loué à moyen ou long terme
                    </td>
                </tr>
                <tr>
                    <td colspan="2">
                        Cité administrative <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label>
                    </td>
                    <td colspan="4">
                        Immeuble occupé par plusieurs ministères, IC ou AAIR ou autre entité publique ou personnes privées
                        <label>
                            <input type="checkbox" style="background-color: burlywood;border: 2px solid burlywood;"/>
                        </label>
                    </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;">
                                    Utilisation du bien(Bureau, logement technique etc...)
                                </td>
                                <td>{{$addInfo->usage}}</td>
                            </tr>
                            <tr>
                                <td style="font-weight: bold;">Superficie du batiment</td>
                                <td>{{$addInfo->area}}</td>
                            </tr>
                            <tr>
                                <td style="font-weight: bold;">Type de batiment( Plein pied ou R+ ....)</td>
                                <td>{{$addInfo->type_building}}</td>
                            </tr>
                            <tr>
                                <td style="font-weight: bold;">Nombre de pièce</td>
                                <td>{{$addInfo->piece}}</td>
                            </tr>
                            <tr>
                                <td style="font-weight: bold;">Etat du batiment( très bon, bon, acceptable, dégradé, etc...)</td>
                                <td>{{$addInfo->state}}</td>
                            </tr>
                            </tbody>
                        </table>
                    </td>
                    <td>
                        <table>
                            <tbody>
                            <tr>
                                <td>Autres caractéristiques</td>
                                <td></td>
                            </tr>
                            </tbody>
                        </table>
                    </td>
                </tr>
                <tr>
                    <td style="font-weight: bold;">Taux d'amortisssement linéaire : {{$addInfo->rate_amort}}</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>Amortis. ou <br/> Provision</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>
            <tr class="gl-header">
                <td>
                    {{"31/12/".$year}}
                </td>
                <td colspan="9" style="text-align: left;">
                    Dotation aux amortissements ( {{number_format($addInfo->unit_price, 0, ',', ' ')}} x {{$addInfo->rate_amort}} x {{$data['FirstYearElapsedMonth']}}/12 )
                </td>
{{--                <td style="white-space: nowrap;">{{number_format($addInfo->unit_price, 0, ',', ' ')}}</td>--}}
                <td style="white-space: nowrap;">{{number_format($data['FirstYearElapsedDepreciation'], 0, ',', ' ')}}</td>
                <td style="white-space: nowrap;">{{number_format($addInfo->unit_price - $data['FirstYearElapsedDepreciation'], 0, ',', ' ')}}</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" 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>Travaux d'entrtiens autres que grosses(dossier en annexe)</li>
                        <li>Autres : </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