@extends('layouts.app')

@section('title', 'Monthly 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-calendar-alt mr-2"></i>Monthly Payment Schedules
                        @if(request('date_from') || request('date_to'))
                            ({{ \Carbon\Carbon::parse(request('date_from', $monthStart))->format('M d, Y') }} - {{ \Carbon\Carbon::parse(request('date_to', $monthEnd))->format('M d, Y') }})
                        @else
                            - {{ now()->format('F Y') }}
                        @endif
                    </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">Monthly Schedule</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.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

    <!-- Date Filter Form -->
    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('reseller.payment-schedules.monthly') }}" class="row">
                <div class="col-md-4">
                    <div class="form-group">
                        <label for="date_from" class="small">From Date</label>
                        <input type="date" class="form-control form-control-sm" id="date_from" name="date_from" value="{{ request('date_from', $monthStart->format('Y-m-d')) }}">
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="form-group">
                        <label for="date_to" class="small">To Date</label>
                        <input type="date" class="form-control form-control-sm" id="date_to" name="date_to" value="{{ request('date_to', $monthEnd->format('Y-m-d')) }}">
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="form-group">
                        <label class="small">&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.monthly') }}" class="btn btn-sm btn-secondary">
                                <i class="fas fa-times mr-1"></i>Clear
                            </a>
                        </div>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <!-- Summary Cards -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card border-primary">
                <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-primary">BDT {{ number_format($totalAmount, 2) }}</h4>
                        </div>
                        <div>
                            <i class="fas fa-calendar-alt fa-2x text-primary"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card border-success">
                <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-success">BDT {{ number_format($totalPaidAmount, 2) }}</h4>
                        </div>
                        <div>
                            <i class="fas fa-money-bill-wave fa-2x text-success"></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>
                        </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-info">
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center">
                        <div>
                            <h6 class="text-muted mb-1">Total Schedules</h6>
                            <h4 class="mb-0 text-info">{{ $totalCount }}</h4>
                        </div>
                        <div>
                            <i class="fas fa-list fa-2x text-info"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Day-wise Summary Table -->
    @if($schedulesByDate->count() > 0)
        <div class="card mb-4">
            <div class="card-header bg-info text-white">
                <h5 class="mb-0">
                    <i class="fas fa-table mr-2"></i>Day-wise Summary
                </h5>
            </div>
            <div class="table-responsive">
                <table class="table table-bordered mb-0">
                    <thead class="thead-light">
                        <tr>
                            <th>Date</th>
                            <th>Day</th>
                            <th>Total Amount</th>
                            <th>Committed Amount</th>
                            <th>Remaining Amount</th>
                            <th>Total Schedules</th>
                            <th>Status</th>
                            <th class="text-right">Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($schedulesByDate as $date => $schedules)
                            @php
                                $dayAmount = $schedules->sum('amount');
                                $dayPaidAmount = $schedules->sum('paid_amount');
                                $dayRemainingAmount = $dayAmount - $dayPaidAmount;
                                $dayCount = $schedules->count();
                                $dateObj = \Carbon\Carbon::parse($date);
                                $isToday = $dateObj->isToday();
                                $isPast = $dateObj->isPast() && !$isToday;
                                $isFuture = $dateObj->isFuture();
                            @endphp
                            <tr class="{{ $isToday ? 'table-warning' : ($isPast ? 'table-danger' : 'table-success') }}">
                                <td>
                                    <strong>{{ $dateObj->format('Y-m-d') }}</strong>
                                    @if($isToday)
                                        <span class="badge badge-dark ml-2">Today</span>
                                    @endif
                                </td>
                                <td>{{ $dateObj->format('l') }}</td>
                                <td class="text-right">
                                    <strong class="text-primary">BDT {{ number_format($dayAmount, 2) }}</strong>
                                </td>
                                <td class="text-right">
                                    <strong class="text-success">BDT {{ number_format($dayPaidAmount, 2) }}</strong>
                                </td>
                                <td class="text-right">
                                    <strong class="text-danger">BDT {{ number_format($dayRemainingAmount, 2) }}</strong>
                                </td>
                                <td class="text-center">
                                    <span class="badge badge-info">{{ $dayCount }}</span>
                                </td>
                                <td>
                                    @if($isToday)
                                        <span class="badge badge-warning">Today</span>
                                    @elseif($isPast)
                                        <span class="badge badge-danger">Past</span>
                                    @else
                                        <span class="badge badge-success">Future</span>
                                    @endif
                                </td>
                                <td class="text-right">
                                    <a href="{{ route('reseller.payment-schedules.date', $date) }}" class="btn btn-sm btn-outline-info" title="View Details">
                                        <i class="fas fa-eye"></i> View
                                    </a>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot class="table-info">
                        <tr>
                            <th colspan="2" class="text-right"><strong>Grand Total:</strong></th>
                            <th class="text-right"><strong>BDT {{ number_format($totalAmount, 2) }}</strong></th>
                            <th class="text-right"><strong>BDT {{ number_format($totalPaidAmount, 2) }}</strong></th>
                            <th class="text-right"><strong>BDT {{ number_format($totalRemainingAmount, 2) }}</strong></th>
                            <th class="text-center"><strong>{{ $totalCount }}</strong></th>
                            <th></th>
                            <th></th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    @else
        <div class="card">
            <div class="card-body text-center py-5">
                <i class="fas fa-calendar-times fa-3x text-muted mb-3"></i>
                <h5 class="text-muted">No payment schedules found for the selected period.</h5>
            </div>
        </div>
    @endif

    <!-- Detailed Schedule List -->
    @if($monthlySchedules->count() > 0)
        <div class="card">
            <div class="card-header bg-primary text-white">
                <h5 class="mb-0">
                    <i class="fas fa-list mr-2"></i>Detailed Schedule List
                </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>Amount</th>
                            <th>Committed Amount</th>
                            <th>Remaining</th>
                            <th>Payment Status</th>
                            <th>Notes</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($monthlySchedules as $schedule)
                            <tr>
                                <td>{{ $loop->iteration }}</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="{{ $schedule->isOverdue() ? 'text-danger' : '' }}">
                                        {{ $schedule->due_date->format('d M Y') }}
                                    </strong>
                                    @if($schedule->isOverdue())
                                        <span class="badge bg-danger ml-1">Overdue</span>
                                    @endif
                                </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>
    @endif

</div>
@endsection