@extends('layouts.app')

@section('title', 'Loan Arrears Report')

@section('content')
<div class="max-w-7xl mx-auto py-6">
    <div class="bg-white shadow rounded-lg">
        <div class="px-6 py-4 border-b border-red-600 flex items-center justify-between bg-red-600 text-white rounded-t-lg">
            <h2 class="text-xl font-bold flex items-center">
                <svg class="w-6 h-6 mr-2 text-yellow-300" fill="none" stroke="currentColor" viewBox="0 0 24 24"><path stroke-linecap="round" stroke-linejoin="round" stroke-width="2" d="M12 9v2m0 4h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z" /></svg>
                Loan Arrears Report
            </h2>
            <div>
                <button onclick="window.print()" class="bg-white text-red-600 px-3 py-1 rounded shadow hover:bg-gray-100 mr-2">
                    <i class="fas fa-print mr-1"></i> Print
                </button>
            </div>
        </div>
        <div class="p-6">
            <!-- Filter Form -->
            <form method="GET" class="mb-6 grid grid-cols-1 md:grid-cols-3 gap-4">
                <div>
                    <label class="block text-sm font-medium text-gray-700">Branch</label>
                    <select name="branch_id" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                        <option value="">All Branches</option>
                        @foreach($branches as $branch)
                            <option value="{{ $branch->id }}" {{ $branch_id == $branch->id ? 'selected' : '' }}>{{ $branch->name ?? 'Unknown' }}</option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label class="block text-sm font-medium text-gray-700">Loan Type</label>
                    <select name="loan_type" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                        <option value="">All Types</option>
                        <option value="BL" {{ $loan_type == 'BL' ? 'selected' : '' }}>Business Loan</option>
                        <option value="ML" {{ $loan_type == 'ML' ? 'selected' : '' }}>Micro Loan</option>
                        <option value="LL" {{ $loan_type == 'LL' ? 'selected' : '' }}>Leasing Loan</option>
                    </select>
                </div>
                <div>
                    <label class="block text-sm font-medium text-gray-700">Repayment Method</label>
                    <select name="repayment_method" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                        <option value="">All Methods</option>
                        <option value="daily" {{ $repayment_method == 'daily' ? 'selected' : '' }}>Daily</option>
                        <option value="weekly" {{ $repayment_method == 'weekly' ? 'selected' : '' }}>Weekly</option>
                        <option value="monthly" {{ $repayment_method == 'monthly' ? 'selected' : '' }}>Monthly</option>
                        <option value="bullet" {{ $repayment_method == 'bullet' ? 'selected' : '' }}>Bullet</option>
                    </select>
                </div>
                <div>
                    <label class="block text-sm font-medium text-gray-700">Credit Officer</label>
                    <select name="credit_officer_name" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                        <option value="">All Officers</option>
                        @foreach($officers as $officer)
                            <option value="{{ $officer->name ?? $officer->username }}" {{ $credit_officer == ($officer->name ?? $officer->username) ? 'selected' : '' }}>
                                {{ $officer->name ?? $officer->username }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div>
                    <label class="block text-sm font-medium text-gray-700">Minimum Days Overdue</label>
                    <select name="days_overdue" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                        <option value="1" {{ $days_overdue == 1 ? 'selected' : '' }}>1+ days</option>
                        <option value="7" {{ $days_overdue == 7 ? 'selected' : '' }}>7+ days</option>
                        <option value="30" {{ $days_overdue == 30 ? 'selected' : '' }}>30+ days (default)</option>
                        <option value="60" {{ $days_overdue == 60 ? 'selected' : '' }}>60+ days</option>
                        <option value="90" {{ $days_overdue == 90 ? 'selected' : '' }}>90+ days</option>
                    </select>
                </div>
                <div>
                    <label class="block text-sm font-medium text-gray-700">As of Date</label>
                    <input type="date" name="date_as_of" class="w-full border border-gray-300 rounded px-2 py-1 text-sm" value="{{ $date_as_of }}">
                </div>
                <div class="md:col-span-3 flex justify-end items-end space-x-2">
                    <button type="submit" class="bg-red-600 hover:bg-red-700 text-white px-4 py-1.5 rounded text-sm">
                        <i class="fas fa-filter mr-1"></i> Filter
                    </button>
                    <a href="{{ route('reports.arrears-report') }}" class="border border-gray-300 px-4 py-1.5 rounded text-sm text-gray-700 hover:bg-gray-100">
                        <i class="fas fa-sync-alt mr-1"></i> Reset
                    </a>
                </div>
            </form>

            <!-- Report Summary -->
            <div class="bg-yellow-100 border-l-4 border-yellow-500 text-yellow-700 p-4 mb-4 rounded">
                <div class="grid grid-cols-1 md:grid-cols-4 gap-4">
                    <div><strong>Total Loans in Arrears:</strong> {{ $total_loans }}</div>
                    <div><strong>Total Outstanding:</strong> Rs {{ number_format($total_outstanding, 2) }}</div>
                    <div><strong>Avg. Days Overdue:</strong> {{ number_format($avg_overdue, 1) }} days</div>
                    <div><strong>As of Date:</strong> {{ \Carbon\Carbon::parse($date_as_of)->format('M d, Y') }}</div>
                </div>
            </div>

            <!-- Report Table -->
            <div class="overflow-x-auto">
                <table class="min-w-full text-xs text-left border border-gray-300" id="reportTable">
                    <thead class="bg-gray-800 text-white">
                        <tr>
                            <th class="px-2 py-1 border">Loan ID</th>
                            <th class="px-2 py-1 border">Member</th>
                            <th class="px-2 py-1 border">NIC</th>
                            <th class="px-2 py-1 border">Branch</th>
                            <th class="px-2 py-1 border">Product</th>
                            <th class="px-2 py-1 border">Repayment Method</th>
                            <th class="px-2 py-1 border">Due Date</th>
                            <th class="px-2 py-1 border">Days Overdue</th>
                            <th class="px-2 py-1 border">Total Due (Rs.)</th>
                            <th class="px-2 py-1 border">Paid (Rs.)</th>
                            <th class="px-2 py-1 border">Status</th>
                            <th class="px-2 py-1 border">Credit Officer</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($rows as $row)
                        @php
                            $overdue_class = '';
                            if ($row->days_overdue >= 90) {
                                $overdue_class = 'bg-red-600 text-white';
                            } elseif ($row->days_overdue >= 60) {
                                $overdue_class = 'bg-yellow-400 text-black';
                            } elseif ($row->days_overdue >= 30) {
                                $overdue_class = 'bg-blue-200 text-black';
                            }
                        @endphp
                        <tr>
                            <td>
                                <a href="#" class="text-blue-600 hover:underline">{{ $row->loan_id }}</a>
                            </td>
                            <td>{{ $row->member_name }}</td>
                            <td>{{ $row->member_nic }}</td>
                            <td>{{ $row->branch_name }}</td>
                            <td>{{ $row->product_name }}</td>
                            <td>{{ ucfirst($row->repayment_method) }}</td>
                            <td>{{ \Carbon\Carbon::parse($row->due_date)->format('Y-m-d') }}</td>
                            <td class="{{ $overdue_class }} text-center font-bold">{{ $row->days_overdue }}</td>
                            <td class="text-right">{{ number_format($row->total_due, 2) }}</td>
                            <td class="text-right">{{ number_format($row->paid_amount, 2) }}</td>
                            <td>
                                <span class="bg-yellow-400 text-black px-2 py-1 rounded text-xs">{{ ucfirst($row->status) }}</span>
                            </td>
                            <td>{{ $row->credit_officer_name }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr class="bg-gray-100 font-semibold text-sm">
                            <td colspan="8" class="text-right px-2 py-1 border">Totals:</td>
                            <td class="text-right px-2 py-1 border">{{ number_format($total_outstanding, 2) }}</td>
                            <td colspan="3" class="border"></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection