@extends('layouts.main.main')

@section('content')

<div class="row">
    <div class="col-12 text-right mb-2">
        <a href="/projets/{{ $project->id }}/rapport/xlsx" class="btn btn-sm btn-danger" data-toggle="tooltip" title="Télécharger au format Excel"><i class="text-white fa fa-file-excel"></i> Télécharger</a>
    </div>
</div>
<div class="row">
    <div class="col-12">
        
        <div class="table-responsive">
            @php
            $total_bdc = 0;
            $total_factures = 0;
            $total_ndf = 0;
            $total_frais_comp = 0;
            $total_intermittents = 0;
            @endphp
            <table class="table table-sm table-hover" id="project-report-table">
                <thead>
                    <tr class="bg-info text-white">
                        <th>{{ $project->customer->name }} - {{ $project->projectref }}</th>
                        <th class="text-right">CA : <span id="tt_ca">{{ number_format($project->income, 2, '.',' ') }}</span></th>
                        <th class="text-right" id="tt_achats">&nbsp;</th>
                        <th class="text-right" id="tt_resultat">&nbsp;</th>
                        <th class="text-right" id="tt_marge">&nbsp;</th>
                    </tr>
                </thead>
                <tbody>
                    @if($project->orders->where('status',1)->count() > 0)
                    <tr class="bg-secondary text-white">
                        <th colspan="5">BONS DE COMMANDE</th>
                    </tr>
                    <tr>
                        <th>Fournisseur</th>
                        <th class="text-right">BdC HT</th>
                        <th class="text-right">Facture HT</th>
                        <th class="text-center">Facture reçue</th>
                        <th>Réf BdC</th>
                    </tr>
                    @foreach($project->orders->where('status',1) as $order)
                    <tr>
                        <td>{{ $order->supplier->name }}</td>
                        <td class="text-right">{{ number_format($order->ht_total()->ht_total, 2,'.',' ') }}</td>
                        <td class="text-right">{{ ($order->invoice_ht_amount) ? number_format($order->invoice_ht_amount, 2,'.',' ') : '' }}</td>
                        <td class="text-center"><i class="{{ ($order->invoice_received) ? 'text-success fa fa-check' : 'text-danger fa fa-times' }}"></i></td>
                        <td>{{ $order->project->projectref }}/{{ $order->number }}{{ ($order->version > 1) ? '-'.$order->version : '' }}</td>
                    </tr>
                    @php
                    $total_bdc += $order->ht_total()->ht_total;
                    $total_factures += $order->invoice_ht_amount; 
                    @endphp
                    @endforeach
                    <tr class="bg-success text-white">
                        <th>TOTAUX BONS DE COMMANDES</th>
                        <th class="text-right">{{ number_format($total_bdc, 2,'.',' ') }}</th>
                        <th class="text-right">{{ number_format($total_factures, 2,'.',' ') }}</th>
                        <th colspan="2">&nbsp;</th>
                    </tr>
                    @else
                    <tr>
                        <th colspan="5">Aucun bon de commande validé sur ce projet</th>
                    </tr>
                    @endif
                    <tr class="bg-secondary text-white">
                        <th colspan="5">NOTES DE FRAIS</th>
                    </tr>
                    @if($project->expensesReports->count() > 0)
                    <tr>
                        <th colspan="5">TODO: intégration des notes de frais</th>
                    </tr>
                    @else
                    <tr>
                        <th colspan="5">Aucune note de frais n'est associée à ce projet</th>
                    </tr>
                    @endif
                    <tr class="bg-secondary text-white">
                        <th colspan="5">FRAIS COMPLÉMENTAIRES</th>
                    </tr>
                    @if($project->additionalExpensesTable->count() > 0)
                    <tr>
                        <th>Fournisseur</th>
                        <th class="text-right">Montant HT</th>
                        <th colspan="3">&nbsp;</th>
                    </tr>
                    @foreach ($project->additionalExpensesTable as $additionalexpense)
                    <tr>
                        <td>{{ $additionalexpense->supplier->name }}</td>
                        <td class="text-right">{{ number_format($additionalexpense->amount,2,'.',' ') }}</td>
                        <td colspan="3">&nbsp;</td>
                    </tr>
                    @php
                    $total_frais_comp += $additionalexpense->amount;
                    @endphp
                    @endforeach
                    <tr class="bg-success text-white">
                        <th>TOTAL FRAIS COMPLÉMENTAIRES</th>
                        <th class="text-right">{{ number_format($total_frais_comp, 2,'.',' ') }}</th>
                        <th colspan="3">&nbsp;</th>
                    </tr>
                    @else
                    <tr>
                        <th colspan="5">Aucun frais complémentaire n'est associé à ce projet</th>
                    </tr>
                    @endif
                    <tr class="bg-info text-white">
                        <th>TOTAL CHARGES</th>
                        <th class="text-right">{{ number_format(($total_bdc + $total_ndf + $total_frais_comp), 2,'.',' ') }}</th>
                        <th class="text-right">{{ number_format(($total_factures), 2,'.',' ') }}</th>
                        <th colspan="2">&nbsp;</th>
                    </tr>
                    <tr>
                        <th colspan="5">&nbsp;</th>
                    </tr>
                    <tr class="bg-secondary text-white">
                        <th colspan="5">INTERMITTENTS</th>
                    </tr>
                    @if($project->intermittents->count() > 0 || $project->singleStewards->count() > 0)
                    <tr>
                        <th>Intermittent</th>
                        <th class="text-right">Brut</th>
                        <th colspan="3">&nbsp;</th>
                    </tr>
                    @if($project->intermittents->count() > 0)
                    @foreach($project->intermittents as $intermittent)
                    <tr>
                        <td>{{ $intermittent->full_name }}</td>
                        <td class="text-right">{{ number_format(($intermittent->pivot->quantity * $intermittent->pivot->daily_cost), 2,'.',' ') }}</td>
                        <td colspan="3">&nbsp;</td>
                    </tr>
                    @php
                    $total_intermittents += ($intermittent->pivot->quantity * $intermittent->pivot->daily_cost);
                    @endphp
                    @endforeach
                    @endif
                    @if($project->singleStewards->count() > 0)
                    @foreach($project->singleStewards as $intermittent)
                    <tr>
                        <td>{{ $intermittent->full_name }}</td>
                        <td class="text-right">{{ number_format(($intermittent->pivot->quantity * $intermittent->pivot->daily_cost), 2,'.',' ') }}</td>
                        <td colspan="3">&nbsp;</td>
                    </tr>
                    @php
                    $total_intermittents += ($intermittent->pivot->quantity * $intermittent->pivot->daily_cost);
                    @endphp
                    @endforeach
                    @endif
                    @else
                    <tr>
                        <th colspan="5">Aucun intermittent n'est associé à ce projet</th>
                    </tr>
                    @endif
                    <tr class="bg-success text-white">
                        <th>TOTAL INTERMITTENTS</th>
                        <th class="text-right">{{ number_format($total_intermittents, 2,'.',' ') }}</th>
                        <td colspan="3">&nbsp;</td>
                    </tr>
                    <tr class="bg-info text-white">
                        <th>TOTAL ÉVÉNEMENT</th>
                        <th class="text-right">{{ number_format(($total_bdc + $total_ndf + $total_frais_comp + $total_intermittents), 2,'.',' ') }}</th>
                        <th class="text-right" id="ttachats">{{ number_format($total_factures, 2,'.',' ') }}</th>
                        <td colspan="2">&nbsp;</td>
                    </tr>
                </tbody>
            </table>
            
        </div>
    </div>
</div>

@endsection