@extends('layouts.app')
@section('title','Labour Cost')
@section('page-title','Labour Cost Report')
@section('content')
<div class="card stat-card mb-3 p-2"><form class="row g-2" method="GET">
  <div class="col-md-2"><select name="project_id" class="form-select form-select-sm"><option value="">All Projects</option>@foreach($projects as $p)<option value="{{ $p->id }}" {{ request('project_id')==$p->id?'selected':'' }}>{{ $p->name }}</option>@endforeach</select></div>
  <div class="col-md-2"><input name="date_from" type="date" class="form-control form-control-sm" value="{{ request('date_from',today()->startOfMonth()->format('Y-m-d')) }}"></div>
  <div class="col-md-2"><input name="date_to" type="date" class="form-control form-control-sm" value="{{ request('date_to',today()->format('Y-m-d')) }}"></div>
  <div class="col-md-2"><button class="btn btn-primary btn-sm">Generate</button></div>
</form></div>
<div class="card stat-card mb-3 p-3"><div class="fw-semibold mb-2">By Staff Member</div><div class="table-responsive"><table class="table table-sm mb-0"><thead><tr><th>Name</th><th>Role</th><th class="text-center">Days</th><th class="text-end">Total Pay</th></tr></thead><tbody>
  @foreach($byStaff->sortByDesc('total') as $staffData)
  <tr><td class="small fw-semibold">{{ $staffData['name'] }}</td><td class="small">{{ $staffData['role'] }}</td><td class="text-center small">{{ $staffData['days'] }}</td><td class="text-end fw-bold">GH₵ {{ number_format($staffData['total'],2) }}</td></tr>
  @endforeach
  <tr class="table-light"><td colspan="3" class="fw-bold">TOTAL</td><td class="text-end fw-bold">GH₵ {{ number_format($byStaff->sum('total'),2) }}</td></tr>
</tbody></table></div></div>
@endsection