@extends('layouts.app')
@section('title', 'Contractor Due Report')

@section('content')
    <div class="d-flex align-items-center justify-content-between mb-4">
        <div>
            <h4 class="mb-0"><i class="bi bi-person-workspace me-2"></i>Contractor Due Report</h4>
            <p class="text-muted mb-0 small">All contractors with outstanding work order balances</p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('reports.export', ['format' => 'pdf', 'report' => 'contractor-due'] + request()->all()) }}"
                class="btn btn-danger btn-sm" target="_blank"><i class="bi bi-file-pdf me-1"></i>PDF</a>
            <a href="{{ route('reports.export', ['format' => 'excel', 'report' => 'contractor-due'] + request()->all()) }}"
                class="btn btn-success btn-sm"><i class="bi bi-file-earmark-excel me-1"></i>Excel</a>
            <a href="{{ route('reports.export', ['format' => 'csv', 'report' => 'contractor-due'] + request()->all()) }}"
                class="btn btn-info text-white btn-sm"><i class="bi bi-filetype-csv me-1"></i>CSV</a>
            <button class="btn btn-secondary btn-sm" onclick="window.print()"><i class="bi bi-printer me-1"></i>Print</button>
        </div>
    </div>

    <div class="card mb-3">
        <div class="card-body py-2">
            <form method="GET" class="row g-2 align-items-end">
                <div class="col-md-4">
                    <select name="project_id" class="form-select form-select-sm" onchange="this.form.submit()">
                        <option value="">All Projects</option>
                        @foreach ($projects as $p)
                            <option value="{{ $p->id }}" {{ $projectId == $p->id ? 'selected' : '' }}>{{ $p->project_name }}
                            </option>
                        @endforeach
                    </select>
                </div>
            </form>
        </div>
    </div>

    <div class="row g-3 mb-4">
        <div class="col-sm-4">
            <div class="stat-card stat-primary">
                <div class="stat-icon"><i class="bi bi-file-earmark-text"></i></div>
                <div class="stat-info">
                    <h3>৳{{ number_format($data->sum('total_agreed')) }}</h3>
                    <p>Total Agreed</p>
                </div>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="stat-card stat-success">
                <div class="stat-icon"><i class="bi bi-cash-stack"></i></div>
                <div class="stat-info">
                    <h3>৳{{ number_format($data->sum('total_paid')) }}</h3>
                    <p>Total Paid</p>
                </div>
            </div>
        </div>
        <div class="col-sm-4">
            <div class="stat-card stat-danger">
                <div class="stat-icon"><i class="bi bi-exclamation-triangle"></i></div>
                <div class="stat-info">
                    <h3>৳{{ number_format($data->sum('total_due')) }}</h3>
                    <p>Total Due</p>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover table-sm mb-0">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Contractor</th>
                            <th>Specialization</th>
                            <th>Mobile</th>
                            <th class="text-end">Agreed</th>
                            <th class="text-end">Paid</th>
                            <th class="text-end">Due</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($data as $i => $row)
                            <tr>
                                <td>{{ $i + 1 }}</td>
                                <td class="fw-semibold">{{ $row->name }}</td>
                                <td>{{ $row->specialization ?? '—' }}</td>
                                <td>{{ $row->mobile }}</td>
                                <td class="text-end">৳{{ number_format($row->total_agreed) }}</td>
                                <td class="text-end text-success">৳{{ number_format($row->total_paid) }}</td>
                                <td class="text-end text-danger fw-bold">৳{{ number_format($row->total_due) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="7" class="text-center py-4 text-muted">No contractor dues found.</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection