@php
$ministry = "";
$direction = "";
$soeBrutIn = 0;
$soeDepreIn = 0;
$soeNetIn = 0;
$soePuIn = 0;
$soeQteIn = 1;
$soeBrutOut = 0;
$soeDepreOut = 0;
$soeNetOut = 0;
$soePuOut = 0;
$soeQteOut = 0;
@endphp
@extends('templates.base.base_financial')
@section('doc-name', "Livre journal des matières suivies au Bilan de l'Etat")

@section('content')
    <style>
        .table{
            width: 100%;
            border-collapse: collapse;
            font-size: x-small;
        }
        .table td{
            border: 2px solid #000;
            text-align: center;
        }
    </style>
    <div>
        <table class="table">
            <tbody>
                <tr style="font-weight: bold;background-color: #c5c6c7;">
                    <td rowspan="3">
                        N° enregistrement
                    </td>
                    <td rowspan="3">Date</td>
                    <td rowspan="3">Compte PCE</td>
                    <td colspan="2">Désignation bien</td>
                    <td colspan="5">Pour les entrées et dépréciations</td>
                    <td colspan="5">Sorties définitives</td>
                </tr>
                <tr style="font-weight: bold;background-color: #c5c6c7;">
                    <td rowspan="2">Codification</td>
                    <td rowspan="2">Nature</td>
                    <td rowspan="2">1. P.U (TTC)</td>
                    <td colspan="2">Entrée</td>
                    <td>Dépréciation</td>
                    <td rowspan="2">Montant net (3-4)</td>
                    <td rowspan="2">5. P.U.</td>
                    <td rowspan="2">6. Qté.</td>
                    <td rowspan="2">7.Montant brut (5x6)</td>
                    <td rowspan="2">8.Dépréciation</td>
                    <td rowspan="2">Montant net (7-8)</td>
                </tr>
                <tr style="font-weight: bold;background-color: #c5c6c7;">
                    <td>2. Qté.</td>
                    <td>3.Montant brut total (1x2)</td>
                    <td>4.Montant</td>
                </tr>
                @php
                    if (count($data) > 1 ){
                @endphp
                @foreach($data as $item)
                    @php
                        $addInfo = json_decode($data['additional_info']);
                        $year = date('y', strtotime($data['period']));
                        $sumBrut = $data['FirstYearElapsedDepreciation'];
                        $brut = $addInfo->unit_price;// - $data['FirstYearElapsedDepreciation'];
                        $i = 1;
                        $ministry = ucwords($addInfo->ministry);
                        $direction = ucwords($addInfo->ministry);
                        $soePuIn += $brut;
                        $soeBrutIn += $brut;
                        if($addInfo->type == "Sortie définitive"){
                            $soeBrutOut += $addInfo->unit_price;
                            $soeDepreOut += $addInfo->depreciation;
                            $soeNetOut += $addInfo->netCurrentValue;
                        }
                        $ministry = ucwords($addInfo->ministry);
                        $direction = ucwords($addInfo->direction);
                        $soePuIn += $addInfo->unit_price;
                        $soeBrutIn += $addInfo->unit_price;
                        $soeDepreIn += $addInfo->FirstYearElapsedDepreciation;
                        $net = $addInfo->unit_price - $addInfo->FirstYearElapsedDepreciation;
                        $soeNetIn += $net;
                    @endphp
                    <tr>
                        <td>{{$item->num_save}}</td>
                        <td>{{date('d.m.y', strtotime($item->periodicity))}}</td>
                        <td>{{$item->chart}}</td>
                        <td>{{$item->code}}</td>
                        <td>$item->label</td>
                        <td>{{number_format($item->unit_price, 0, ',', ' ')}} </td>
                        <td>1</td>
                        <td style="white-space: nowrap;">{{number_format($data["data"]["unit_price"]*1, 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($data["data"]["FirstYearElapsedDepreciation"], 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($net, 0, ',', ' ')}}</td>
                        @if($addInfo->type == "Sortie définitive") {{-- set value out property --}}
                        <td style="white-space: nowrap;">{{number_format($addInfo->unit_price, 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">1</td>
                        <td style="white-space: nowrap;">{{number_format($addInfo->unit_price, 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($addInfo->depreciation, 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($addInfo->netCurrentValue, 0, ',', ' ')}}</td>
                        @else
                            <td style="white-space: nowrap;"></td>
                            <td style="white-space: nowrap;"></td>
                            <td style="white-space: nowrap;"></td>
                            <td style="white-space: nowrap;"></td>
                            <td style="white-space: nowrap;"></td>
                        @endif
                    </tr>
                @endforeach
                @php
                    }else if(count($data) == 1){
                        $ministry = ucwords($data["data"]["ministry"]);
                        $direction = ucwords($data["data"]["direction"]);
                        $soePuIn += $data["data"]["unit_price"];
                        $soeBrutIn += $data["data"]["unit_price"];
                        $soeDepreIn += $data["data"]["FirstYearElapsedDepreciation"];
                        $net = $data["data"]["unit_price"] - $data["data"]["FirstYearElapsedDepreciation"];
                        $soeNetIn += $net;
                @endphp
                <tr>
                    <td>{{$data["data"]["num_save"]}}</td>
                    <td>{{date('d.m.y', strtotime($data["data"]["periodicity"]))}}</td>
                    <td>{{$data["data"]["chart"]}}</td>
                    <td>{{$data["data"]["code"]}}</td>
                    <td>{{$data["data"]["label"]}}</td>
                    <td style="white-space: nowrap;">{{number_format($data["data"]["unit_price"], 0, ',', ' ')}} </td>
                    <td style="white-space: nowrap;">1</td>
                    <td style="white-space: nowrap;">{{number_format($data["data"]["unit_price"]*1, 0, ',', ' ')}}</td>
                    <td style="white-space: nowrap;">{{number_format($data["data"]["FirstYearElapsedDepreciation"], 0, ',', ' ')}}</td>
                    <td style="white-space: nowrap;">{{number_format($net, 0, ',', ' ')}}</td>
                    @if($data["data"]["type"] == "Sortie définitive") {{-- set value out property --}}
                        @php
                            $soeBrutOut += $data["data"]["unit_price"];
                            $soePuOut += $data["data"]["unit_price"];
                            $soeDepreOut += $data["data"]["depreciation"];
                            $soeNetOut += $data["data"]["netCurrentValue"];
                            $soeQteOut += 1;
                        @endphp
                        <td style="white-space: nowrap;">{{number_format($data["data"]["unit_price"], 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">1</td>
                        <td style="white-space: nowrap;">{{number_format($data["data"]["unit_price"], 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($data["data"]["depreciation"], 0, ',', ' ')}}</td>
                        <td style="white-space: nowrap;">{{number_format($data["data"]["netCurrentValue"], 0, ',', ' ')}}</td>
                    @else
                        <td style="white-space: nowrap;"></td>
                        <td style="white-space: nowrap;"></td>
                        <td style="white-space: nowrap;"></td>
                        <td style="white-space: nowrap;"></td>
                        <td style="white-space: nowrap;"></td>
                    @endif
                </tr>
                @php } @endphp
                <tr style="font-weight: bold;white-space: nowrap;">
                    <td colspan="5">Total</td>
                    <td>{{$soePuIn > 0 ? number_format($soePuIn, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeQteIn > 0 ? number_format($soeQteIn, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeBrutIn > 0 ? number_format($soeBrutIn, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeDepreIn > 0 ? number_format($soeDepreIn, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeNetIn > 0 ? number_format($soeNetIn, 0, ',', ' ') : ""}}</td>
                    <td>{{$soePuOut > 0 ? number_format($soePuOut, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeQteOut > 0 ? number_format($soeQteOut, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeBrutOut > 0 ? number_format($soeBrutOut, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeDepreOut > 0 ? number_format($soeDepreOut, 0, ',', ' ') : ""}}</td>
                    <td>{{$soeNetOut > 0 ? number_format($soeNetOut, 0, ',', ' ') : ""}}</td>
                    @php
                    $soeQteIn += 1;
                    $soeQteOut += 1;
                    @endphp
                </tr>
            </tbody>
        </table>
    </div>
@endsection

@section('ministry', $ministry)
@section('direction', $direction)
{{--@section('actualUser', $header['actual_user'])--}}
{{--@section('creator', $header['creator'])--}}