@extends('layouts.app')

@section('content')
<div class="container">
    <h2 class="mb-3">Payrolls</h2>

    <form method="GET" action="{{ route('financial.payrolls.index') }}" class="row g-2 mb-4">
        <div class="col-md-3">
            <input type="text" name="name" value="{{ request('name') }}" class="form-control" placeholder="Search by Name">
        </div>

        <div class="col-md-2">
            <select name="role" class="form-select">
                <option value="">All Roles</option>
                @foreach($roles as $role)
                    <option value="{{ $role }}" {{ request('role') == $role ? 'selected' : '' }}>{{ $role }}</option>
                @endforeach
            </select>
        </div>

        <div class="col-md-2">
            <select name="payment_status" class="form-select">
                <option value="">All Status</option>
                @foreach($statuses as $status)
                    <option value="{{ $status }}" {{ request('payment_status') == $status ? 'selected' : '' }}>{{ $status }}</option>
                @endforeach
            </select>
        </div>

        <div class="col-md-2">
            <input type="date" name="training_date" value="{{ request('training_date') }}" class="form-control">
        </div>

        <div class="col-md-3 d-flex gap-2">
            <button type="submit" class="btn btn-primary w-50">Filter</button>
            <a href="{{ route('financial.payrolls.index') }}" class="btn btn-secondary w-50">Reset</a>
        </div>
    </form>

    {{-- Action buttons row --}}
    <div class="d-flex justify-content-end mb-3 gap-2">
        <a href="{{ route('financial.payrolls.create') }}" class="btn btn-success btn-sm">
            <i class="bi bi-plus-circle"></i> Record Payroll
        </a>
        <a href="{{ route('financial.payrolls.export.excel', request()->query()) }}" class="btn btn-outline-success btn-sm">
            <i class="bi bi-file-earmark-excel"></i> Export Excel
        </a>
        <a href="{{ route('financial.payrolls.export.csv', request()->query()) }}" class="btn btn-outline-warning btn-sm">
            <i class="bi bi-file-earmark-spreadsheet"></i> Export CSV
        </a>
    </div>

    <table class="table table-bordered align-middle">
        <thead class="table-light">
            <tr>
                <th>#</th>
                <th>Name</th>
                <th>Role</th>
                <th>Training Date</th>
                <th>Expected</th>
                <th>Paid</th>
                <th>Pending</th>
                <th>Status</th>
                <th>Remarks</th>
            </tr>
        </thead>
        <tbody>
            @forelse ($payrolls as $payroll)
                <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $payroll->user->name ?? '-' }}</td>
                    <td>{{ $payroll->role }}</td>
                    <td>{{ $payroll->training_date }}</td>
                    <td>{{ number_format($payroll->expected_amount, 2) }}</td>
                    <td>{{ number_format($payroll->paid_amount, 2) }}</td>
                    <td>{{ number_format($payroll->pending_amount, 2) }}</td>
                    <td>{{ $payroll->payment_status }}</td>
                    <td>{{ $payroll->remarks }}</td>
                </tr>
            @empty
                <tr><td colspan="9" class="text-center">No payrolls found.</td></tr>
            @endforelse
        </tbody>
    </table>

    {{ $payrolls->links() }}
</div>
@endsection