@extends('layouts.app')
@section('content')
<div class="max-w-6xl mx-auto p-6">
    <h1 class="text-xl font-semibold mb-4">Overdue Installments</h1>
    <div class="flex items-center gap-2 mb-4">
        <form method="POST" action="{{ route('reports.export.pdf', 'overdue-installments') }}">
            @csrf
            <button class="px-3 py-2 bg-red-600 text-white rounded">PDF</button>
        </form>
        <form method="POST" action="{{ route('reports.export.excel', 'overdue-installments') }}">
            @csrf
            <button class="px-3 py-2 bg-green-600 text-white rounded">Excel</button>
        </form>
    </div>
    <div class="bg-white rounded shadow overflow-hidden">
        <table class="min-w-full">
            <thead class="bg-gray-50">
                <tr>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Customer</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">CNIC</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Phone</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Unit#</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Inst#</th>
                    <th class="px-4 py-2 text-left text-xs font-medium text-gray-500">Due Date</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Overdue Days</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Amount</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Fine</th>
                    <th class="px-4 py-2 text-right text-xs font-medium text-gray-500">Total Due</th>
                </tr>
            </thead>
            <tbody class="divide-y divide-gray-100">
                @foreach($rows as $r)
                @php $days = \Carbon\Carbon::now()->diffInDays($r->due_date); @endphp
                <tr>
                    <td class="px-4 py-2">{{ $r->booking?->customer?->name }}</td>
                    <td class="px-4 py-2">{{ $r->booking?->customer?->cnic }}</td>
                    <td class="px-4 py-2">{{ $r->booking?->customer?->phone }}</td>
                    <td class="px-4 py-2">{{ $r->booking?->unit?->unit_number }}</td>
                    <td class="px-4 py-2">{{ $r->installment_number }}</td>
                    <td class="px-4 py-2">{{ $r->due_date->format('Y-m-d') }}</td>
                    <td class="px-4 py-2 text-right">{{ $days }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r->amount, 2) }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r->fine_amount, 2) }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r->amount + $r->fine_amount, 2) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection