@extends('layouts.app') @section('page_title','Budget Planning') @section('content')
<div class="flex flex-col md:flex-row justify-between gap-3 mb-4"><div><h2 class="text-[18px] font-semibold">Budget Planning</h2><p class="fp-muted text-[11px] mt-1">Plan monthly spending and compare budget against actual.</p></div><form class="flex gap-2"><select name="year" class="fp-input !w-24">@for($y=now()->year-2;$y<=now()->year+2;$y++)<option {{$year==$y?'selected':''}}>{{$y}}</option>@endfor</select><select name="month" class="fp-input !w-32">@for($m=1;$m<=12;$m++)<option value="{{$m}}" {{$month==$m?'selected':''}}>{{Carbon\Carbon::create()->month($m)->format('F')}}</option>@endfor</select><button class="fp-btn fp-soft">Apply</button></form></div>
<div class="grid grid-cols-1 md:grid-cols-3 gap-4 mb-4"><div class="fp-card p-4"><div class="fp-muted text-[10px]">Monthly Planned</div><div class="text-[20px] font-semibold mt-1 whitespace-nowrap">৳ {{number_format($monthlyBudget,2)}}</div></div><div class="fp-card p-4"><div class="fp-muted text-[10px]">Monthly Actual Expenses</div><div class="text-[20px] font-semibold mt-1 whitespace-nowrap">৳ {{number_format($monthlyActual,2)}}</div></div><div class="fp-card p-4"><div class="fp-muted text-[10px]">Monthly Remaining</div><div class="text-[20px] font-semibold mt-1 whitespace-nowrap {{$monthlyRemaining<0?'text-red-500':'text-emerald-600'}}">৳ {{number_format($monthlyRemaining,2)}}</div></div></div><div class="grid xl:grid-cols-3 gap-4"><div class="fp-card p-5"><h3 class="font-semibold text-[14px]">Set Budget</h3><form method="post" action="{{route('budgets.store')}}" class="space-y-3 mt-4">@csrf<input type="hidden" name="year" value="{{$year}}"><input type="hidden" name="month" value="{{$month}}"><select name="category_id" class="fp-input"><option value="">Overall / Other</option>@foreach($cats as $c)<option value="{{$c->id}}">{{$c->name}}</option>@endforeach</select><input name="amount" type="number" step="0.01" min="0.01" class="fp-input" placeholder="Budget amount" required><textarea name="notes" class="fp-input" rows="3" placeholder="Notes"></textarea><button class="fp-btn fp-primary w-full">Save Budget</button></form></div><div class="fp-card p-5 xl:col-span-2"><h3 class="font-semibold text-[14px]">{{$month}} / {{$year}} Budget vs Actual</h3><div class="overflow-x-auto mt-3"><table class="fp-table w-full"><thead><tr><th>Category</th><th>Budget</th><th>Actual</th><th>Remaining</th><th>Usage</th><th></th></tr></thead><tbody>@forelse($rows as $b)@php($a=(float)($actual[$b->category_id]??0))

<tr>
    <td>{{$b->category?->name??'Overall / Other'}}</td>

    <td class="whitespace-nowrap">
        ৳ {{number_format($b->amount,2)}}
    </td>

    <td class="whitespace-nowrap">
        ৳ {{number_format($a,2)}}
    </td>

    <td class="whitespace-nowrap {{$a>$b->amount?'text-red-500':'text-emerald-600'}}">
        ৳ {{number_format((float)$b->amount-$a,2)}}
    </td>

    <td class="whitespace-nowrap">
        {{round($a/$b->amount*100)}}%
    </td>
    
    
    <td><form method="post" action="{{route('budgets.destroy',$b)}}">@csrf @method('DELETE')<button class="text-red-500 text-[10px]">Delete</button></form></td></tr>@empty<tr><td colspan="6" class="text-center fp-muted py-12">No budgets defined for this month.</td></tr>@endforelse</tbody></table></div></div></div>
@endsection