@extends('layouts.app')

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

@section('content')
<div class="px-4 py-6">
    <div class="bg-white shadow rounded-lg">
        <div class="px-6 py-4 border-b border-gray-200 flex items-center justify-between">
            <div>
                <h2 class="text-lg font-semibold text-gray-800 flex items-center">
                    <i class="fas fa-book mr-2"></i> Loan Portfolio Report
                </h2>
                <p class="text-sm text-gray-500">Complete loan portfolio overview with filtering options</p>
            </div>
            <div class="space-x-2">
                <button class="btn btn-sm bg-gray-100 hover:bg-gray-200 text-sm px-3 py-1 rounded" onclick="window.print()">
                    <i class="fas fa-print mr-1"></i> Print
                </button>
                <button class="btn btn-sm bg-gray-100 hover:bg-gray-200 text-sm px-3 py-1 rounded" id="exportBtn">
                    <i class="fas fa-file-export mr-1"></i> Export
                </button>
            </div>
        </div>
        <div class="p-6">
            <!-- Filter Form -->
            <form method="GET" class="space-y-6 mb-6">
                <div class="grid grid-cols-1 md:grid-cols-4 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->branch_name }}
                                </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>
                          </select>
                      </div>
                      <div>
                          <label class="block text-sm font-medium text-gray-700">Status</label>
                          <select name="status" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                              <option value="">All Statuses</option>
                              <option value="Pending" {{ $status == 'Pending' ? 'selected' : '' }}>Pending</option>
                              <option value="Approved" {{ $status == 'Approved' ? 'selected' : '' }}>Approved</option>
                              <option value="Disbursed" {{ $status == 'Disbursed' ? 'selected' : '' }}>Disbursed</option>
                              <option value="Completed" {{ $status == 'Completed' ? 'selected' : '' }}>Completed</option>
                          </select>
                      </div>
                </div>
                <div class="grid grid-cols-1 md:grid-cols-2 gap-4">
                    <div class="flex items-center gap-2">
                        <label class="block text-sm font-medium text-gray-700">Date Range</label>
                    </div>
                    <div class="flex gap-2 items-end">
                        <input type="date" name="date_from" value="{{ $date_from }}" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                        <span class="text-gray-500">to</span>
                        <input type="date" name="date_to" value="{{ $date_to }}" class="w-full border border-gray-300 rounded px-2 py-1 text-sm">
                    </div>
                </div>

                <div class="flex justify-end space-x-2">
                    <button type="submit" class="bg-blue-600 hover:bg-blue-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.portfolio-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="alert alert-info mb-4">
                <div class="row">
                    <div class="col-md-2">
                        <strong>Total Loans:</strong> {{ $total_loans }}
                    </div>
                    <div class="col-md-2">
                        <strong>Total Amount:</strong> Rs. {{ number_format($total_amount, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Avg. Interest Rate:</strong> {{ number_format($total_interest, 2) }}%
                    </div>
                    <div class="col-md-2">
                        <strong>Total Rental:</strong> Rs. {{ number_format($total_rental, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Total Outstanding:</strong> Rs. {{ number_format($total_outstanding, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Total Paid:</strong> Rs. {{ number_format($total_paid, 2) }}
                    </div>
                </div>
                <div class="row mt-2">
                    <div class="col-md-2">
                        <strong>Capital Due:</strong> Rs. {{ number_format($capital_due, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Capital Paid:</strong> Rs. {{ number_format($capital_paid, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Interest Due:</strong> Rs. {{ number_format($interest_due, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Interest Paid:</strong> Rs. {{ number_format($interest_paid, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Total Due:</strong> Rs. {{ number_format($total_due, 2) }}
                    </div>
                    <div class="col-md-2">
                        <strong>Arrears:</strong> Rs. {{ number_format($arrears, 2) }}
                    </div>
                </div>
            </div>

            <!-- Report Table -->
            <div style="max-height: 120vh; overflow-y: auto;">
            <table id="reportTable" class="min-w-full text-xs text-left border border-gray-300">
                <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">Date</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 text-right">Amount (Rs.)</th>
                        <th class="px-2 py-1 border text-right">Interest (%)</th>
                        <th class="px-2 py-1 border text-center">Installments</th>
                        <th class="px-2 py-1 border text-right">Rental (Rs.)</th>
                        <th class="px-2 py-1 border text-right">Capital Due</th>
                        <th class="px-2 py-1 border text-right">Capital Paid</th>
                        <th class="px-2 py-1 border text-right">Interest Due</th>
                        <th class="px-2 py-1 border text-right">Interest Paid</th>
                        <th class="px-2 py-1 border text-right">Total Due</th>
                        <th class="px-2 py-1 border text-right">Arrears</th>
                        <th class="px-2 py-1 border text-right">Total Paid</th>
                        <th class="px-2 py-1 border text-right">Outstanding</th>
                        <th class="px-2 py-1 border">Status</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($loans as $loan)
                    <tr class="hover:bg-gray-100">
                        <td class="px-2 py-1 border">
                            <a href="{{ route('reports.loan-details', $loan->loan_id) }}" class="text-blue-600 hover:underline text-xs">
                                {{ $loan->loan_id }}
                            </a>
                        </td>
                        <td class="px-2 py-1 border">{{ \Carbon\Carbon::parse($loan->application_date)->format('Y-m-d') }}</td>
                        <td class="px-2 py-1 border">{{ $loan->member_name }}</td>
                        <td class="px-2 py-1 border">{{ $loan->member_nic }}</td>
                        <td class="px-2 py-1 border">{{ $loan->branch_name }}</td>
                        <td class="px-2 py-1 border">{{ $loan->product_name }}</td>
                        <td class="px-2 py-1 border">{{ ucfirst($loan->repayment_method) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->loan_amount, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->interest_rate, 2) }}</td>
                        <td class="px-2 py-1 border text-center">{{ $loan->installments }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->rental_value, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->capital_due, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->capital_paid, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->interest_due, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->interest_paid, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->total_due, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->arrears, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->total_paid, 2) }}</td>
                        <td class="px-2 py-1 border text-right">{{ number_format($loan->total_outstanding, 2) }}</td>
                        <td class="px-2 py-1 border">
                            @php
                                $statusClass = match($loan->status) {
                                    'Disbursed' => 'bg-green-100 text-green-800',
                                    'Pending' => 'bg-yellow-100 text-yellow-800',
                                    'Approved' => 'bg-blue-100 text-blue-800',
                                    default => 'bg-gray-100 text-gray-800',
                                };
                            @endphp
                            <span class="text-xs px-2 py-1 rounded {{ $statusClass }}">{{ $loan->status }}</span>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="bg-gray-100 font-semibold text-sm">
                    <tr>
                        <td colspan="11" class="text-right px-2 py-1 border">Totals:</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($capital_due, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($capital_paid, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($interest_due, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($interest_paid, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($total_due, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($arrears, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($total_paid, 2) }}</td>
                        <td class="text-right px-2 py-1 border">{{ number_format($total_outstanding, 2) }}</td>
                        <td class="border"></td>
                    </tr>
                </tfoot>
            </table>
            </div>
        </div>
    </div>
</div>

<form id="exportForm" method="GET" action="{{ route('reports.export') }}" class="hidden">
    <input type="hidden" name="report_type" value="portfolio_report">
    <input type="hidden" name="format" value="excel">
    <input type="hidden" name="branch_id" value="{{ $branch_id }}">
    <input type="hidden" name="loan_type" value="{{ $loan_type }}">
    <input type="hidden" name="status" value="{{ $status }}">
    <input type="hidden" name="date_from" value="{{ $date_from }}">
    <input type="hidden" name="date_to" value="{{ $date_to }}">
    <input type="hidden" name="repayment_method" value="{{ $repayment_method }}">
</form>
<button class="btn btn-sm bg-green-600 hover:bg-green-700 text-white px-3 py-1 rounded" onclick="document.getElementById('exportForm').submit();">
    <i class="fas fa-file-excel mr-1"></i> Export to Excel
</button>
@endsection