@extends('layouts.app')
@section('title','Subcontractor Report')
@section('page-title','Subcontractor Payment Report')
@section('content')
<div class="row g-3 mb-3">
  <div class="col-md-3"><div class="card stat-card p-3 text-center"><div class="text-muted small">Total Agreed</div><div class="fs-5 fw-bold">GH₵ {{ number_format($subcontractors->sum('agreed_amount'),2) }}</div></div></div>
  <div class="col-md-3"><div class="card stat-card p-3 text-center"><div class="text-muted small">Total Paid</div><div class="fs-5 fw-bold text-success">GH₵ {{ number_format($subcontractors->sum('amount_paid'),2) }}</div></div></div>
  <div class="col-md-3"><div class="card stat-card p-3 text-center"><div class="text-muted small">Outstanding</div><div class="fs-5 fw-bold text-danger">GH₵ {{ number_format($subcontractors->sum(fn($s)=>$s->balance),2) }}</div></div></div>
  <div class="col-md-3"><div class="card stat-card p-3 text-center"><div class="text-muted small">Subcontractors</div><div class="fs-5 fw-bold">{{ $subcontractors->count() }}</div></div></div>
</div>
<div class="card stat-card"><div class="table-responsive"><table class="table table-hover mb-0">
  <thead><tr><th>Name</th><th>Trade</th><th>Project</th><th>Agreed</th><th>Paid</th><th>Balance</th><th>Status</th></tr></thead>
  <tbody>
    @foreach($subcontractors as $sc)
    <tr>
      <td class="fw-semibold small">{{ $sc->name }}</td>
      <td class="small">{{ $sc->trade }}</td>
      <td class="small">{{ $sc->project->name ?? '-' }}</td>
      <td class="small">GH₵ {{ number_format($sc->agreed_amount,2) }}</td>
      <td class="small text-success">GH₵ {{ number_format($sc->amount_paid,2) }}</td>
      <td class="small {{ $sc->balance>0?'text-danger fw-bold':'' }}">GH₵ {{ number_format($sc->balance,2) }}</td>
      <td><span class="badge bg-{{ $sc->status==='active'?'success':'secondary' }}">{{ $sc->status }}</span></td>
    </tr>
    @endforeach
  </tbody>
</table></div></div>
@endsection