@extends('admin.layout')

@section('content')
<div class="container mt-5">
    <h1 class="mb-4">Payroll Report</h1>
      <form method="GET" action="{{ route('admin.payroll') }}" class="mb-4">
        <div class="row g-3 align-items-center">
            <div class="col-auto">
                <label for="month" class="col-form-label">Select Month:</label>
            </div>
            <div class="col-auto">
                <input type="month" id="month" name="month" value="{{ $month }}" class="form-control">
            </div>
            <label>Worker:</label>
    <select name="worker_id">
        <option value="">All Workers</option>
        @foreach ($workerall as $w)
            <option value="{{ $w->id }}" {{request('worker_id') == $w->id ? 'selected' : ''}}>
                {{ $w->name }}
            </option>
        @endforeach
    </select>
            <div class="col-auto">
                <button class="btn btn-primary">Filter</button>
            </div>
        </div>

    </form>

     <form method="GET" action="{{ route('export.payroll') }}">
    <input type="hidden" name="worker_id" value="{{ request('worker_id') }}">
    <input type="hidden" name="month" value="{{ request('month') }}">
    <button type="submit" class="btn btn-primary">Export to Excel</button>
</form>
    <table class="table table-bordered table-striped">
        <thead class="table-dark">
        <tr>
            <th>Worker</th>
            <th>Total Hours</th>
            <th>Overtime Hours</th>
            <th>Regular Pay ($)</th>
            <th>Overtime Pay ($)</th>
            <th>Total Pay ($)</th>
        </tr>
        </thead>
        <tbody>
        @foreach($payrolls as $payroll)
            <tr>
                <td>{{ $payroll['worker'] }}</td>
                <td>{{ $payroll['total_hours'] }}</td>
                <td>{{ $payroll['overtime_hours'] }}</td>
                <td>{{ number_format($payroll['regular_pay'], 2) }}</td>
                <td>{{ number_format($payroll['overtime_pay'], 2) }}</td>
                <td>{{ number_format($payroll['total_pay'], 2) }}</td>
            </tr>
        @endforeach
        </tbody>
    </table>
</div>
@endsection