@extends('layouts.pdf')

@section('content')
<style>
    body {
        font-size: 13px;
    }
    table {
        width: 100%;
        border-collapse: collapse;
    }
    .no-border td, .no-border th {
        border: none!important;
        text-align: left;
    }
    .bordered th, .bordered td {
        border: 1px solid black;
    }
    th, td {
        padding: 8px;
        text-align: center;
    }
    .striped tr:nth-child(even) {
        background-color: #f2f2f2;
    }
    .title-row {
        background: #f2f2f2;
    }
    .total-row td {
        font-weight: bold;
    }
    .total-row {
        background: #F1F5F9;
    }
    .font-smaller td:nth-child(odd) {
        font-size: 11px;
    }
    td {
        padding: 4px!important;
    }
    table .no-pad {
        padding: 0px!important;
    }
    h4 {
        margin-top: 10px;
        margin-bottom: 5px;
    }
</style>

<img src="{{ resource_path('img/logo-v3.png') }}" style="height: 60px;">

<div style="position: absolute; right: 5px; top: 20px;">
    <h4 style="font-size:14px">{{ now()->format('d/m/Y') }}</h4>
</div>

<div style="text-align: center; width: 100%">
    <h2 style="margin-top: 0px">GRILLE D'ETUDE: {{ $client_names }}</h2>
</div>

<table class="no-border font-smaller" style="background: #f2f2f2; padding: 15px; font-size:13px">
    <tr>
        <td>AGE EMPRUNTEUR:</td>
        <td colspan="2">{{ data_get($clients, '0.age', '') }}</td>
        <td>SITUATION FAM:</td>
        <td colspan="4">{{ data_get($clients, '0.matrimonial_situation', '') }}</td>
    </tr>
    <tr>
        <td>AGE CO-EMPRUNTEUR:</td>
        <td colspan="2">{{ data_get($clients, '1.age', '') }}</td>
        <td>ENFANTS À CHARGE:</td>
        <td colspan="4">{{ data_get($infants, 'count') }}</td>
    </tr>
    <tr>
        <td>ANCIENNETÉ PRO EMPRUNTEUR:</td>
        <td colspan="2">{{ data_get($clients, '0.employment_start_date', '') }}</td>
        <td>@if(data_get($infants, 'ages')) AGE DES ENFANTS:  @endif</td>
        <td colspan="4">{{ data_get($infants, 'ages') }}</td>
    </tr>
    <tr>
        <td>PROFESSION EMPRUNTEUR:</td>
        <td colspan="2">{{ data_get($clients, '0.employment_profession', '') }}</td>
    </tr>
    @if(count($clients) > 1)
    <tr>
        <td>ANCIENNETÉ PRO CO-EMPRUNTEUR:</td>
        <td colspan="2">{{ data_get($clients, '1.employment_start_date', '') }}</td>
    </tr>
    <tr>
        <td>PROFESSION CO-EMPRUNTEUR:</td>
        <td colspan="2">{{ data_get($clients, '1.employment_profession', '') }}</td>
    </tr>
    @endif
</table>
<br>

<h4>{{ __('Income') }}</h4>
<table class="bordered">
    <tr>
        @foreach($clients as $i => $client)
        <td colspan="3">
            <b>{!! strip_tags(data_get($clients, "$i.fullname")) !!}</b>
        </td>
        @endforeach
    </tr>
    <tr>
        @foreach($clients as $i => $client)
        <td></td>
        <td>BS</td>
        <td>AI</td>
        @endforeach
    </tr>
    @foreach([__('Salary/Pension') => 'monthly', __('Rentals Revenue') => 'property_income', __('Family Allowance') => 'family_allowance'] as $name => $key)
        @continue(! (data_get($clients, "0.income.$key") || (data_get($clients, "1.income.$key"))))
        <tr>
            @foreach($clients as $i => $client)
            <td class="title-row">{{ $name }}</td>
            <td>{{ str()->formatDecimal(data_get($client, "income.$key"), 2, ',', '') ?: ''  }}</td>
            <td>{{ str()->formatDecimal(data_get($client, "external_data.income.$key"), 2, ',', '') ?: '' }}</td>
            @endforeach
        </tr>
    @endforeach
    @if(data_get($clients, '0.income.has_other_income') || data_get($clients, '1.income.has_other_income'))
        @for($inc = 1; $inc <= 5; $inc++)
            @php($ic = $inc == 1? '' : $inc)
            @if(data_get($clients, "0.income.other_income{$ic}_id", false) || data_get($clients, "1.income.other_income{$ic}_id", false))
                <tr>
                    @foreach($clients as $i => $client)
                        <td class="title-row">{{ data_get($client, "income.other_income{$ic}_name") }}</td>
                        <td>{{ str()->formatDecimal(data_get($client, "income.other$inc"), 2, ',', '') ?: '' }}</td>
                        <td>{{ str()->formatDecimal(data_get($client, "external_data.income.other$inc"), 2, ',', '') ?: '' }}</td>
                    @endforeach
                </tr>
            @endif
        @endfor
    @endif
</table>

@if(count($claims))
<h4>{{ __('Claims') }}</h4>
<table class="bordered">
    <tr class="title-row">
        <th>{{ __('Claim Type') }}</th>
        <th>{{ __('Creditor') }}</th>
        <th>{{ __('Monthly') }}</th>
    </tr>

    @foreach($claims as $i => $claim)
    <tr>
        <td>{{ data_get($claim, 'claim_type') }}</td>
        <td>{{ data_get($claim, 'creditor') }}</td>
        <td>{{ str()->formatDecimal(data_get($claim, 'monthly'), 2, ',', '') }}</td>
    </tr>
    @endforeach
</table>
@endif

<h4>{{ __('Debts') }}</h4>
<table class="bordered">
    <tr class="title-row">
        <th>N<sup>o</sup></th>
        <th>Ref</th>
        <th>Organisme</th>
        <th>Type</th>
        <th>Mt initial</th>
        <th>Début</th>
        <th>Objet</th>
        <th>Taux</th>
        <th>Mens.</th>
        <th>KRD</th>
        <th>Reprise</th>
    </tr>

    @foreach($debts as $i => $debt)
    <tr>
        <td>{{ $i + 1 }}</td>
        <td>{{ data_get($debt, 'ref') }}</td>
        <td>{{ data_get($debt, 'creditor') }}</td>
        <td>{{ data_get($debt, 'debt_type') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'initial_capital'), 2, ',', '') }}</td>
        <td>{{ data_get($debt, 'start_at_short') }}</td>
        <td>{{ data_get($debt, 'object') }}</td>
        <td>{{ str()->formatDecimal( data_get($debt, 'rate'), 2, ',', '') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'monthly'), 2, ',', '') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'remaining_capital'), 2, ',', '') }}</td>
        <td>{{ data_get($debt, 'recovery') ? __('Yes') : __('No') }}</td>
    </tr>
    @if(data_get($debts, ($i + 1)) && data_get($debt, 'recovery') !== data_get($debts, ($i + 1).'.recovery'))
    <tr class="total-row">
        <td colspan="8">Total</td>
        <td>{{ str()->formatDecimal(data_get($debt_totals, 'monthly_no_recovery'), 2, ',', '') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt_totals, 'remaining_capital_no_recovery'), 2, ',', '') }}</td>
        <td></td>
    </tr>
    <tr class="title-row">
        <td colspan="11" class="bg-light">{{ data_get($debt, 'recovery') ? 'À conserver' : 'À reprendre' }}</td>
    </tr>
    @endif
    @if(! data_get($debts, ($i + 1)) && data_get($debt, 'recovery'))
    <tr class="total-row">
        <td colspan="8">Total</td>
        <td>{{ str()->formatDecimal(data_get($debt_totals, 'monthly_recovery'), 2, ',', '') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt_totals, 'remaining_capital_recovery'), 2, ',', '') }}</td>
        <td></td>
    </tr>
    @endif
    @endforeach
    @if(count($temp_debts ?? []))
    <td colspan="11" style="height: 10px"></td>
    @endif
    @foreach($temp_debts as $i => $debt)
    <tr>
        <td></td>
        <td>{{ data_get($debt, 'ref') }}</td>
        <td>{{ data_get($debt, 'creditor') }}</td>
        <td>{{ data_get($debt, 'debt_type') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'initial_capital'), 2, ',', '') }}</td>
        <td>{{ data_get($debt, 'start_at_short') }}</td>
        <td>{{ data_get($debt, 'object') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'rate'), 2, ',', '') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'monthly'), 2, ',', '') }}</td>
        <td>{{ str()->formatDecimal(data_get($debt, 'remaining_capital'), 2, ',', '') }}</td>
        <td>{{ data_get($debt, 'recovery') ? __('Yes') : __('No') }}</td>
    </tr>
    @endforeach
</table>

@if(count($overdrafts))
<h4>{{ __('Overdrafts') }}</h4>
<table class="bordered">
    <tr class="title-row">
        <th>{{ __('Bank name') }}</th>
        <th>{{ __('IBAN') }}</th>
        <th>{{ __('Amount') }}</th>
    </tr>

    @foreach($overdrafts as $i => $overdraft)
    <tr>
        <td>{{ data_get($overdraft, 'bank_name') }}</td>
        <td>{{ data_get($overdraft, 'iban') }}</td>
        <td>{{ data_get($overdraft, 'ending_balance') }}</td>
    </tr>
    @endforeach
    @if(count($overdrafts))
    <tr class="total-row">
        <td colspan="2">Total</td>
        <td>{{ str()->formatDecimal($total_overdraft, 2, ',', '') }}</td>
    </tr>
    @endif
</table>
@endif

@if(count($cashflows))
<h4>{{ __('Cashflows') }}</h4>
<table class="bordered">
    <tr class="title-row">
        <th>{{ __('Reason') }}</th>
        <th>{{ __('Amount') }}</th>
    </tr>

    @foreach($cashflows as $i => $cashflow)
    <tr>
        <td>{{ data_get($cashflow, 'reason') }}</td>
        <td>{{ str()->formatDecimal(data_get($cashflow, 'amount'), 2, ',', '') }}</td>
    </tr>
    @endforeach
    @if(count($cashflows))
    <tr class="total-row">
        <td>Total</td>
        <td>{{ str()->formatDecimal($total_cashflow, 2, ',', '') }}</td>
    </tr>
    @endif
</table>
@endif

@if(count($properties))
<h4>{{ __('Properties') }}</h4>
<table class="bordered">
    <tr class="title-row">
        <th>{{ __('Property Type') }}</th>
        <th>{{ __('Property Nature') }}</th>
        <th>{{ __('Value of purchase') }}</th>
        <th>{{ __('Estimated value') }}</th>
        <th>{{ __('Zip Code') }}</th>
        <th>{{ __('City') }}</th>
        <th>{{ __('Warranty proposed') }}</th>
    </tr>

    @foreach($properties as $i => $property)
    <tr>
        <td>{{ data_get($property, 'property_type') }}</td>
        <td>{{ data_get($property, 'property_nature') }}</td>
        <td>{{ str()->formatDecimal(data_get($property, 'value_purchase'), 2, ',', '') }}</td>
        <td>{{ data_get($property, 'value') }}</td>
        <td>{{ data_get($property, 'address.zip_code', '') }}</td>
        <td>{{ data_get($property, 'address.city', '') }}</td>
        <td>{{ data_get($property, 'warranty_proposed') ? __('Yes') : __('No') }}</td>
    </tr>
    @endforeach
    @if(count($properties))
    <tr class="total-row">
        <td colspan="3">Total en garantie</td>
        <td>{{ $total_warranty_property_value }}</td>
        <td colspan="3"></td>
    </tr>
    @endif
</table>
@endif

{{-- note: [
    'id' => $note->id,
    'content' => $note->content,
    'created_at' => $note->created_at->format('d/m/Y H:i'),
    'created_by' => $note->user?->name_and_surname,
] --}}


@if(count($notes))
<h4>{{ __('Notes') }}</h4>
@endif

@foreach($notes->reverse() as $note)
<div style="margin-top: 10px;">
    <table class="bordered no-pad">
        <tr>
            <td>{!! nl2br(strip_tags($note['content'])) !!}</td>
        </tr>
    </table>
    <table class="no-border font-smaller">
        <tr>
            <td colspan="2">{{ $note['created_by'] }} - {{ $note['created_at'] }}</td>
        </tr>
    </table>
</div>
@endforeach

@endsection