@extends('layouts.master')
@section('title', 'Loans & advances report')
@section('content')
<div class="page-head">
    <div><div class="crumbs">Reports</div><h2>Loans &amp; advances</h2></div>
    <div class="actions no-print"><button onclick="window.print()" class="btn btn-light"><i class="fas fa-print me-1"></i> Print</button></div>
</div>
@include('partials.print-head', ['title' => 'Loans & advances'])
<div class="card mb-3"><div class="card-body">
    <form class="filter-bar no-print">
        <div><label class="form-label">Status</label><select name="status" class="form-select">@foreach (['active' => 'Active / outstanding', 'completed' => 'Completed / recovered', 'cancelled' => 'Cancelled', 'all' => 'All'] as $k => $l)<option value="{{ $k }}" @selected($status == $k)>{{ $l }}</option>@endforeach</select></div>
        <div style="min-width:240px"><label class="form-label">Employee</label>@include('partials.employee-select', ['employees' => $employees, 'selected' => request('employee_id'), 'required' => false])</div>
        <div style="min-width:auto"><button class="btn btn-primary">Run</button></div>
    </form>
</div></div>
<div class="row g-3">
    <div class="col-xl-6"><div class="card"><div class="card-header"><h5>Loans</h5><span class="fw-bold text-danger">{{ money($loans->sum('balance')) }} outstanding</span></div><div class="card-body p-0"><div class="table-responsive">
        <table class="table mb-0"><thead><tr><th>Employee</th><th>Start</th><th class="num">Loan</th><th class="num">Repaid</th><th class="num">Balance</th><th>Status</th></tr></thead><tbody>
            @forelse ($loans as $l)<tr><td>{{ optional($l->employee)->full_name }}</td><td>{{ fmt_date($l->start_date) }}</td><td class="num">{{ money($l->total_amount, false) }}</td><td class="num">{{ money($l->paid_amount, false) }}</td><td class="num fw-bold">{{ money($l->balance, false) }}</td><td>{!! status_badge($l->status) !!}</td></tr>
            @empty<tr><td colspan="6"><div class="empty-state">No loans</div></td></tr>@endforelse
        </tbody></table>
    </div></div></div></div>
    <div class="col-xl-6"><div class="card"><div class="card-header"><h5>Advances</h5><span class="fw-bold text-danger">{{ money($advances->sum('balance')) }} outstanding</span></div><div class="card-body p-0"><div class="table-responsive">
        <table class="table mb-0"><thead><tr><th>Employee</th><th>Given</th><th class="num">Amount</th><th class="num">Recovered</th><th class="num">Balance</th><th>Status</th></tr></thead><tbody>
            @forelse ($advances as $a)<tr><td>{{ optional($a->employee)->full_name }}</td><td>{{ fmt_date($a->given_date) }}</td><td class="num">{{ money($a->amount, false) }}</td><td class="num">{{ money($a->recovered, false) }}</td><td class="num fw-bold">{{ money($a->balance, false) }}</td><td>{!! status_badge($a->status) !!}</td></tr>
            @empty<tr><td colspan="6"><div class="empty-state">No advances</div></td></tr>@endforelse
        </tbody></table>
    </div></div></div></div>
    <div class="col-12"><div class="card"><div class="card-header"><h5>Recent payroll recoveries</h5></div><div class="card-body p-0"><div class="table-responsive">
        <table class="table mb-0"><thead><tr><th>Payroll month</th><th>Employee</th><th>Source</th><th class="num">Amount</th></tr></thead><tbody>
            @forelse ($recoveries as $r)<tr><td>{{ optional($r->payroll)->periodLabel() }}</td><td>{{ optional(optional($r->payroll)->employee)->full_name }}</td><td>{{ ucfirst($r->source_type) }} #{{ $r->source_id }}</td><td class="num">{{ money($r->amount, false) }}</td></tr>
            @empty<tr><td colspan="4"><div class="empty-state">No recoveries yet</div></td></tr>@endforelse
        </tbody></table>
    </div></div></div></div>
</div>
@endsection