@extends('layouts.master')
@section('title', 'Impact sur les dotations budgetaire')
@section('content')
<div class="container">
    <h2>Impact sur les Dotations Budgétaire</h2>
    <div class="table-responsive">
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>Années</th>
                    <th>Date début</th>
                    <th>Date fin</th>
                    <th>Dotation allouée (A)</th>
                    <th>Prises en charge sur le budget (B)</th>
                    <th>Disponible (A-B)</th>
                    <th>Taux d'exécution (B/A)</th>
                </tr>
            </thead>
            <tbody>
                @forelse($rows as $row)
                <tr>
                    <td>{{ $row['annee'] }}</td>
                    <td>{{ \Carbon\Carbon::parse($row['date_debut'])->format('d/m/Y') }}</td>
                    <td>{{ \Carbon\Carbon::parse($row['date_fin'])->format('d/m/Y') }}</td>
                    <td>{{ number_format($row['alloue'], 0, ',', ' ') }}</td>
                    <td>{{ number_format($row['pec'], 0, ',', ' ') }}</td>
                    <td>{{ number_format($row['disponible'], 0, ',', ' ') }}</td>
                    <td>{{ number_format($row['taux'], 2, ',', ' ') }}%</td>
                </tr>
                @empty
                <tr>
                    <td colspan="7">Aucune donnée disponible</td>
                </tr>
                @endforelse
            </tbody>
            <tfoot class="font-weight-bold">
                <tr class="total-row">
                    <td colspan="3">Total</td>
                    <td>{{ number_format($totalAlloue, 0, ',', ' ') }}</td>
                    <td>{{ number_format($totalPEC, 0, ',', ' ') }}</td>
                    <td>{{ number_format($totalDisponible, 0, ',', ' ') }}</td>
                    <td>{{ number_format($totalTaux, 2, ',', ' ') }}%</td>
                </tr>
            </tfoot>
        </table>
    </div>
</div>
@endsection
@push('styles')
<style>
    table {
        font-size: 11px;
        white-space: nowrap;
    }
    thead tr th {
        font-weight: bold;
        text-align: center;
        vertical-align: middle;
        padding: 8px 4px;
    }
    td {
        border: 1px solid #999;
        text-align: center;
        vertical-align: middle;
        padding: 8px 4px;
    }
    .total-row {
        background-color: #c8e6c9;
        font-weight: bold;
    }
</style>