@extends('layouts.master')
@section('title', 'Loans')
@section('content')
<div class="page-head">
    <div><div class="crumbs">Payroll</div><h2>Employee loans</h2><div class="sub">Instalments are deducted in payroll from the start month until the loan is fully repaid.</div></div>
    <div class="actions">
        <form><select name="status" class="form-select" onchange="this.form.submit()"><option value="">All statuses</option>@foreach (\App\Models\Loan::STATUSES as $k => $l)<option value="{{ $k }}" @selected(request('status') == $k)>{{ $l }}</option>@endforeach</select></form>
        @can('Employee Loans add')<button id="addbtn" class="btn btn-primary text-nowrap" data-modal-form="#formModal" data-action="{{ route('loans.store') }}" data-title="New loan"><i class="fas fa-plus me-1"></i> New loan</button>@endcan
    </div>
</div>
<div class="row g-3 mb-3">
    <div class="col-md-4"><div class="card kpi tone-primary"><span class="kpi-label">Disbursed</span><span class="kpi-value">{{ money($loans->sum('total_amount')) }}</span></div></div>
    <div class="col-md-4"><div class="card kpi tone-success"><span class="kpi-label">Repaid</span><span class="kpi-value">{{ money($loans->sum('paid_amount')) }}</span></div></div>
    <div class="col-md-4"><div class="card kpi tone-danger"><span class="kpi-label">Outstanding</span><span class="kpi-value">{{ money($loans->where('status', 'active')->sum('balance')) }}</span></div></div>
</div>
<div class="card"><div class="card-body"><div class="table-responsive">
    <table class="table table-hover datatable">
        <thead><tr><th>Employee</th><th>Start</th><th class="num">Loan</th><th class="num">Repaid</th><th class="num">Balance</th><th class="num">Instalment</th><th>Progress</th><th>Status</th><th class="no-sort"></th></tr></thead>
        <tbody>
            @foreach ($loans as $l)
                @php $p = $l->total_amount > 0 ? round($l->paid_amount / $l->total_amount * 100) : 0; @endphp
                <tr>
                    <td>@include('partials.person', ['e' => $l->employee])</td>
                    <td data-order="{{ $l->start_date->format('Y-m-d') }}">{{ 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 text-danger">{{ money($l->balance, false) }}</td><td class="num">{{ money($l->monthly_deduction, false) }}</td>
                    <td style="min-width:110px"><div class="meter"><span style="width:{{ $p }}%"></span></div><div class="tx-11 text-muted">{{ $p }}% · {{ $l->monthly_deduction > 0 ? ceil($l->balance / $l->monthly_deduction) . ' months left' : '—' }}</div></td>
                    <td>{!! status_badge($l->status) !!}</td>
                    <td class="text-end">@include('partials.row-actions', ['modal' => '#editModal', 'edit' => 'Employee Loans edit', 'delete' => 'Employee Loans delete', 'update' => route('loans.update', $l), 'destroy' => route('loans.destroy', $l), 'title' => 'Edit loan · ' . optional($l->employee)->full_name, 'record' => rec($l, ['total_amount', 'paid_amount', 'monthly_deduction', 'start_date', 'end_date', 'status', 'notes'])])</td>
                </tr>
            @endforeach
        </tbody>
    </table>
</div></div></div>
@include('partials.modal-open', ['title' => 'New loan'])
    <div class="mb-3"><label class="form-label">Employee <span class="req">*</span></label>@include('partials.employee-select', ['employees' => $employees])</div>
    <div class="row g-3">
        <div class="col-6"><label class="form-label">Loan amount <span class="req">*</span></label><input type="number" step="0.01" min="1" name="total_amount" class="form-control" required></div>
        <div class="col-6"><label class="form-label">Monthly instalment <span class="req">*</span></label><input type="number" step="0.01" min="1" name="monthly_deduction" class="form-control" required></div>
        <div class="col-6"><label class="form-label">First deduction month <span class="req">*</span></label><input type="date" name="start_date" class="form-control" value="{{ today()->toDateString() }}" required></div>
        <div class="col-6"><label class="form-label">Expected end</label><input type="date" name="end_date" class="form-control"></div>
        <div class="col-12"><label class="form-label">Notes</label><textarea name="notes" class="form-control" rows="2"></textarea></div>
    </div>
@include('partials.modal-close')
@include('partials.modal-open', ['id' => 'editModal', 'title' => 'Edit loan'])
    <div class="row g-3">
        <div class="col-6"><label class="form-label">Loan amount</label><input type="number" step="0.01" min="1" name="total_amount" class="form-control" required></div>
        <div class="col-6"><label class="form-label">Repaid</label><input type="number" step="0.01" min="0" name="paid_amount" class="form-control" required></div>
        <div class="col-6"><label class="form-label">Monthly instalment</label><input type="number" step="0.01" min="0" name="monthly_deduction" class="form-control" required></div>
        <div class="col-6"><label class="form-label">Status</label><select name="status" class="form-select">@foreach (\App\Models\Loan::STATUSES as $k => $v)<option value="{{ $k }}">{{ $v }}</option>@endforeach</select></div>
        <div class="col-6"><label class="form-label">Start</label><input type="date" name="start_date" class="form-control" required></div>
        <div class="col-6"><label class="form-label">End</label><input type="date" name="end_date" class="form-control"></div>
        <div class="col-12"><label class="form-label">Notes</label><textarea name="notes" class="form-control" rows="2"></textarea></div>
    </div>
@include('partials.modal-close')
@endsection