@extends('layouts.app')

@section('title', 'Expired Payment Schedules')

@section('content')
<div class="container-fluid">
    <!-- Page Header -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex justify-content-between align-items-center">
                <div>
                    <h1 class="h3 mb-0 text-gray-800">
                        <i class="fas fa-exclamation-triangle text-warning mr-2"></i>Expired Payment Schedules
                    </h1>
                    <nav aria-label="breadcrumb">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{ route('reseller.payment-schedules.index') }}">Payment Schedules</a></li>
                            <li class="breadcrumb-item active">Expired Commitment</li>
                        </ol>
                    </nav>
                </div>
                <div>
                    <a href="{{ route('reseller.payment-schedules.index') }}" class="btn btn-secondary mr-2">
                        <i class="fas fa-arrow-left mr-2"></i>Back
                    </a>
                    <a href="{{ route('reseller.payment-schedules.monthly') }}" class="btn btn-info mr-2">
                        <i class="fas fa-calendar-alt mr-2"></i>Monthly Schedule
                    </a>
                    <a href="{{ route('reseller.payment-schedules.create') }}" class="btn btn-primary">
                        <i class="fas fa-plus mr-2"></i>Create Schedule
                    </a>
                </div>
            </div>
        </div>
    </div>

    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            <i class="fas fa-check-circle mr-2"></i>{{ session('success') }}
            <button type="button" class="close" data-dismiss="alert">
                <span>&times;</span>
            </button>
        </div>
    @endif

    @if(session('error'))
        <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <i class="fas fa-exclamation-circle mr-2"></i>{{ session('error') }}
            <button type="button" class="close" data-dismiss="alert">
                <span>&times;</span>
            </button>
        </div>
    @endif

    <!-- Summary Cards -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card border-danger">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="text-muted mb-1">Total Expired Schedules</h6>
                            <h4 class="mb-0 text-danger">{{ $totalCount }}</h4>
                            <small class="text-muted">Unpaid expired commitments</small>
                        </div>
                        <div>
                            <i class="fas fa-exclamation-triangle fa-2x text-danger"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-warning">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="text-muted mb-1">Total Amount</h6>
                            <h4 class="mb-0 text-warning">BDT {{ number_format($totalAmount, 2) }}</h4>
                            <small class="text-muted">From expired schedules</small>
                        </div>
                        <div>
                            <i class="fas fa-money-bill-wave fa-2x text-warning"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-info">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="text-muted mb-1">Total Committed Amount</h6>
                            <h4 class="mb-0 text-info">BDT {{ number_format($totalPaidAmount, 2) }}</h4>
                            <small class="text-muted">Against expired schedules</small>
                        </div>
                        <div>
                            <i class="fas fa-check-circle fa-2x text-info"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-danger">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="text-muted mb-1">Remaining Amount</h6>
                            <h4 class="mb-0 text-danger">BDT {{ number_format($totalRemainingAmount, 2) }}</h4>
                            <small class="text-muted">Still due</small>
                        </div>
                        <div>
                            <i class="fas fa-exclamation-circle fa-2x text-danger"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Filter Form -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('reseller.payment-schedules.expired') }}" class="row">
                <div class="col-md-3 mb-2">
                    <label class="small mb-1">Provider</label>
                    <select name="provider_id" class="form-control">
                        <option value="">All Providers</option>
                        @foreach($providers as $provider)
                            <option value="{{ $provider->id }}" {{ request('provider_id') == $provider->id ? 'selected' : '' }}>
                                {{ $provider->company_name ?? $provider->name }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3 mb-2">
                    <label class="small mb-1">Invoice</label>
                    <select name="invoice_id" class="form-control">
                        <option value="">All Invoices</option>
                        @foreach($invoices as $invoice)
                            <option value="{{ $invoice->id }}" {{ request('invoice_id') == $invoice->id ? 'selected' : '' }}>
                                {{ $invoice->bill_no ?? 'Invoice #' . $invoice->id }}
                            </option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2 mb-2">
                    <label class="small mb-1">From Date</label>
                    <input type="date" name="date_from" class="form-control" value="{{ $dateFromValue }}">
                </div>
                <div class="col-md-2 mb-2">
                    <label class="small mb-1">To Date</label>
                    <input type="date" name="date_to" class="form-control" value="{{ $dateToValue }}">
                </div>
                <div class="col-md-2 mb-2">
                    <label class="small mb-1">&nbsp;</label>
                    <div>
                        <button type="submit" class="btn btn-sm btn-info">
                            <i class="fas fa-filter mr-1"></i>Filter
                        </button>
                        <a href="{{ route('reseller.payment-schedules.expired') }}" class="btn btn-sm btn-secondary">
                            <i class="fas fa-times mr-1"></i>Clear
                        </a>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <!-- Expired Schedules Table -->
    @if($expiredSchedulesPaginated->count() > 0)
        <div class="card">
            <div class="card-header bg-danger text-white">
                <h5 class="mb-0">
                    <i class="fas fa-list mr-2"></i>Expired Payment Schedules
                </h5>
            </div>
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead class="thead-light">
                        <tr>
                            <th>#</th>
                            <th>Provider</th>
                            <th>Invoice</th>
                            <th>Due Date</th>
                            <th>Days Overdue</th>
                            <th>Amount</th>
                            <th>Committed Amount</th>
                            <th>Remaining</th>
                            <th>Payment Status</th>
                            <th>Notes</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($expiredSchedulesPaginated as $schedule)
                            <tr class="{{ $schedule->days_overdue > 30 ? 'table-danger' : ($schedule->days_overdue > 7 ? 'table-warning' : '') }}">
                                <td>{{ $loop->iteration + ($expiredSchedulesPaginated->currentPage() - 1) * $expiredSchedulesPaginated->perPage() }}</td>
                                <td>
                                    <strong>{{ $schedule->provider->company_name ?? $schedule->provider->name ?? 'N/A' }}</strong>
                                </td>
                                <td>
                                    @if($schedule->invoice_id)
                                        <a href="{{ route('reseller.purchase-invoices.show', $schedule->invoice_id) }}" class="text-primary">
                                            {{ $schedule->invoice->bill_no ?? 'Invoice #' . $schedule->invoice_id }}
                                        </a>
                                    @else
                                        <span class="text-muted">—</span>
                                    @endif
                                </td>
                                <td>
                                    <strong class="text-danger">{{ $schedule->due_date->format('d M Y') }}</strong>
                                </td>
                                <td>
                                    <span class="badge badge-danger">{{ $schedule->days_overdue }} days</span>
                                </td>
                                <td class="text-right">
                                    <strong>BDT {{ number_format($schedule->amount, 2) }}</strong>
                                </td>
                                <td class="text-right text-success">
                                    <strong>BDT {{ number_format($schedule->paid_amount, 2) }}</strong>
                                </td>
                                <td class="text-right text-danger">
                                    <strong>BDT {{ number_format($schedule->remaining_amount, 2) }}</strong>
                                </td>
                                <td>
                                    @if($schedule->payment_status == 'paid')
                                        <span class="badge bg-success">Paid</span>
                                    @elseif($schedule->payment_status == 'partial')
                                        <span class="badge bg-warning">Partial</span>
                                    @else
                                        <span class="badge bg-danger">Pending</span>
                                    @endif
                                </td>
                                <td>
                                    @if($schedule->notes)
                                        <span title="{{ $schedule->notes }}">{{ Str::limit($schedule->notes, 30) }}</span>
                                    @else
                                        <span class="text-muted">—</span>
                                    @endif
                                </td>
                                <td>
                                    <div class="btn-group btn-group-sm">
                                        <a href="{{ route('reseller.payment-schedules.show', $schedule->id) }}" class="btn btn-info" title="View">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                        <a href="{{ route('reseller.payment-schedules.edit', $schedule->id) }}" class="btn btn-warning" title="Edit">
                                            <i class="fas fa-edit"></i>
                                        </a>
                                    </div>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
            <div class="card-footer">
                {{ $expiredSchedulesPaginated->links() }}
            </div>
        </div>
    @else
        <div class="card">
            <div class="card-body text-center py-5">
                <i class="fas fa-check-circle fa-3x text-success mb-3"></i>
                <h5 class="text-muted">No expired payment schedules found for the selected period.</h5>
                <p class="text-muted">All payment schedules are up to date!</p>
            </div>
        </div>
    @endif

</div>
@endsection