@extends('layouts.app')
@section('title','Attendance Report')
@section('page-title','Attendance 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 d-flex flex-row gap-4"><div class="text-center"><div class="text-muted small">Present Days</div><div class="fs-5 fw-bold text-success">{{ $records->where('status','present')->count() }}</div></div><div class="text-center"><div class="text-muted small">Absent</div><div class="fs-5 fw-bold text-danger">{{ $records->where('status','absent')->count() }}</div></div><div class="text-center"><div class="text-muted small">Total Labour Cost</div><div class="fs-5 fw-bold">GH₵ {{ number_format($totalLabourCost,2) }}</div></div></div>
<div class="card stat-card"><div class="table-responsive"><table class="table table-sm mb-0">
  <thead><tr><th>Date</th><th>Staff</th><th>Role</th><th>Status</th><th>Time In</th><th>Time Out</th><th class="text-end">Pay</th></tr></thead>
  <tbody>
    @foreach($records as $r)
    <tr><td class="small">{{ $r->date->format('d/m/Y') }}</td><td class="small fw-semibold">{{ $r->staff->name??'-' }}</td><td class="small">{{ $r->staff->role??'-' }}</td><td><span class="badge bg-{{ $r->status==='present'?'success':($r->status==='absent'?'danger':'warning text-dark') }}">{{ $r->status }}</span></td><td class="small">{{ $r->time_in??'-' }}</td><td class="small">{{ $r->time_out??'-' }}</td><td class="text-end small">{{ $r->daily_rate?'GH₵ '.number_format($r->daily_rate,2):'-' }}</td></tr>
    @endforeach
  </tbody>
</table></div></div>
@endsection