@extends('layouts.app')
@section('title', 'Commission 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-megaphone me-2"></i>Commission Due Report</h4>
            <p class="text-muted mb-0 small">All media agents with pending commissions</p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('reports.export', ['format' => 'pdf', 'report' => 'commission-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' => 'commission-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' => 'commission-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="row g-3 mb-4">
        <div class="col-sm-4">
            <div class="stat-card stat-primary">
                <div class="stat-icon"><i class="bi bi-receipt"></i></div>
                <div class="stat-info">
                    <h3>৳{{ number_format($data->sum('total_commission')) }}</h3>
                    <p>Total Commission</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>Agent Name</th>
                            <th>Company</th>
                            <th>Mobile</th>
                            <th class="text-end">Commission</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->company_name ?? '—' }}</td>
                                <td>{{ $row->mobile }}</td>
                                <td class="text-end">৳{{ number_format($row->total_commission) }}</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 pending commissions found.</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection