@extends('admin.admin_dashboard')
@section('admin')

<div class="page-content">
  <!-- Breadcrumb & Title -->
  <div class="page-breadcrumb d-flex justify-content-between align-items-center mb-3 p-3 bg-primary text-white rounded shadow-sm">
    <div>
      <a href="{{ route('budgets.show', $budget->id) }}" class="btn btn-light btn-sm me-2">
        <i class="bx bx-arrow-back"></i>
      </a>
      Variance Analysis: {{ $budget->name }}
    </div>
  </div>

  <div class="card shadow-sm rounded-lg border-0">
    <div class="card-body p-4">
      <div class="table-responsive">
        <table class="table table-hover table-striped table-bordered align-middle">
          <thead class="table-dark">
            <tr>
              <th>Account</th>
              <th>Period</th>
              <th class="text-end">Budgeted</th>
              <th class="text-end">Actual</th>
              <th class="text-end">Variance</th>
            </tr>
          </thead>
          <tbody>
            @foreach($budget->lines as $line)
              @php
                // key must match the one we used in the controller
                $key    = $line->account_id . '|' . \Carbon\Carbon::parse($line->period)->format('Y-m');
                $actual = $actuals->has($key) ? $actuals[$key]->actual : 0;
                $variance = $line->amount - $actual;
              @endphp
              <tr>
                <td>{{ $line->account->full_name }}</td>
                <td>{{ \Carbon\Carbon::parse($line->period)->format('Y-m') }}</td>
                <td class="text-end">{{ number_format($line->amount, 2) }}</td>
                <td class="text-end">{{ number_format($actual, 2) }}</td>
                <td class="text-end">{{ number_format($variance, 2) }}</td>
              </tr>
            @endforeach
          </tbody>
        </table>
      </div>
    </div>
  </div>
</div>

@endsection