@extends('layouts.app')
@section('title', 'Budgets')
@section('breadcrumbs')
<nav aria-label="breadcrumb"><ol class="breadcrumb"><li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li><li class="breadcrumb-item"><a href="#">Finance</a></li><li class="breadcrumb-item active">Budgets</li></ol></nav>
@endsection
@section('content')
<div class="d-flex justify-content-between align-items-center mb-4">
    <div><h1 class="h3 mb-1 text-dark fw-semibold">Budget vs Actual</h1><p class="text-muted mb-0">Compare budgeted amounts with actual spending</p></div>
    <button class="btn btn-outline-success btn-sm"><i class="bi bi-file-earmark-excel me-1"></i>Export</button>
</div>
<div class="row g-3 mb-4">
    @php $stats = [['label'=>'Total Budget','count'=>'₹'.number_format($stats['budget']??0,2),'icon'=>'bi-piggy-bank','color'=>'primary'],['label'=>'Actual Spent','count'=>'₹'.number_format($stats['actual']??0,2),'icon'=>'bi-cash-stack','color'=>'info'],['label'=>'Variance','count'=>'₹'.number_format($stats['variance']??0,2),'icon'=>'bi-arrows-angle-contract','color'=>($stats['variance']??0)>=0?'success':'danger'],['label'=>'Utilization','count'=>number_format($stats['utilization']??0,1).'%','icon'=>'bi-speedometer2','color'=>'warning']]; @endphp
    @foreach($stats as $stat)<div class="col"><x-kpi-card :title="$stat['label']" :value="$stat['count']" :icon="$stat['icon']" :color="$stat['color']" /></div>@endforeach
</div>
<div class="card border-0 shadow-sm">
    <div class="card-body">
        <div class="table-responsive">
            <table id="budgetTable" class="table table-hover align-middle mb-0 w-100">
                <thead class="bg-light"><tr><th class="border-0 px-3 py-3 fw-semibold text-muted small">Department / Category</th><th class="border-0 px-3 py-3 fw-semibold text-muted small text-end">Budget</th><th class="border-0 px-3 py-3 fw-semibold text-muted small text-end">Actual</th><th class="border-0 px-3 py-3 fw-semibold text-muted small text-end">Variance</th><th class="border-0 px-3 py-3 fw-semibold text-muted small text-end">Utilization</th><th class="border-0 px-3 py-3 fw-semibold text-muted small" style="width:200px;">Progress</th></tr></thead>
                <tbody>
                    @forelse($budgets ?? [] as $b)
                    @php $util = ($b->budget ?? 1) > 0 ? (($b->actual ?? 0) / ($b->budget ?? 1)) * 100 : 0; $var = ($b->budget ?? 0) - ($b->actual ?? 0); @endphp
                    <tr>
                        <td class="px-3 fw-medium">{{ $b->category ?? 'N/A' }}</td>
                        <td class="px-3 text-end">₹{{ number_format($b->budget ?? 0, 2) }}</td>
                        <td class="px-3 text-end">₹{{ number_format($b->actual ?? 0, 2) }}</td>
                        <td class="px-3 text-end"><span class="{{ $var >= 0 ? 'text-success' : 'text-danger' }} fw-medium">₹{{ number_format($var, 2) }}</span></td>
                        <td class="px-3 text-end"><span class="badge {{ $util > 100 ? 'bg-danger-subtle text-danger' : ($util > 80 ? 'bg-warning-subtle text-warning' : 'bg-success-subtle text-success') }}">{{ number_format($util, 1) }}%</span></td>
                        <td class="px-3"><div class="progress" style="height:6px;"><div class="progress-bar bg-{{ $util > 100 ? 'danger' : ($util > 80 ? 'warning' : 'success') }}" style="width:{{ min($util, 100) }}%"></div></div></td>
                    </tr>
                    @empty
                    <tr><td colspan="6" class="text-center py-5 text-muted"><i class="bi bi-inbox display-4 d-block mb-2"></i><p>No budget data</p></td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection
@push('scripts')
<script>$(document).ready(function(){ $('#budgetTable').DataTable({order:[[3,'asc']],pageLength:25}); });</script>
@endpush