@extends('dashboard.layouts.app')

@section('content')
    @include('components.alert')

    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card h-100 border-0 shadow-sm overflow-hidden p-3">
                    <div class="mb-3 fw-bold">
                        Promocode Details: {{ $promocode->code }}
                    </div>

                    <!-- Filter Form -->
                    <div class="mb-4">
                        <form action="{{ route('promocodes.show', $promocode->id) }}" method="GET" class="row g-3">
                            <div class="col-md-3">
                                <label for="month" class="form-label">Month</label>
                                <select name="month" id="month" class="form-select">
                                    @for ($m = 1; $m <= 12; $m++)
                                        <option value="{{ $m }}" {{ $month == $m ? 'selected' : '' }}>
                                            {{ \Carbon\Carbon::create()->month($m)->format('F') }}
                                        </option>
                                    @endfor
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label for="year" class="form-label">Year</label>
                                <select name="year" id="year" class="form-select">
                                    @for ($y = 2020; $y <= now()->year; $y++)
                                        <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>
                                            {{ $y }}
                                        </option>
                                    @endfor
                                </select>
                            </div>
                            <div class="col-md-3 align-self-end">
                                <button type="submit" class="btn btn-primary">Filter</button>
                            </div>
                        </form>
                    </div>

                    <!-- Promocode Summary -->
                    <div class="mb-3" style="overflow: auto;">

                        <table class=" text-center table table-bordered table-sm table bordered-table sm-table mb-0">
                            <thead class="">
                                <tr>
                                    <th class="text-center">Code</th>
                                    <th class="text-center">Limit</th>
                                    <th class="text-center">Type</th>
                                    <th class="text-center">Discount</th>
                                    <th class="text-center">Monthly Renewable</th>
                                    <th class="text-center">Expiry Date</th>
                                    <th class="text-center">Total Usage Count</th>
                                    <th class="text-center">Usage Count
                                        ({{ \Carbon\Carbon::create()->month((int) $month)->year((int) $year)->format('F Y') }})
                                    </th>
                                    <th class="text-center">Created By</th>
                                </tr>
                            </thead>
                            <tbody>
                                <tr>
                                    <td>{{ $promocode->code }}</td>
                                    <td>{{ $promocode->limit }}</td>
                                    <td>{{ ucfirst($promocode->type) }}</td>
                                    <td>{{ $promocode->type === 'percentage' ? $promocode->discount . '%' : $promocode->discount }}</td>
                                    <td>{{ $promocode->is_monthly_renewable ? 'Yes' : 'No' }}</td>
                                    <td>{{ \Carbon\Carbon::parse($promocode->expire_date)->format('d M Y') }}</td>
                                    <td>{{ $promocode->usage_count_total ?? 0 }}</td>
                                    <td>{{ $promocode->usage_count_filtered ?? 0 }}</td>
                                    <td>{{ $promocode->createdBy->full_name ?? '' }}</td>
                                </tr>
                            </tbody>
                        </table>
                    </div>

                    <!-- Student Invoices Table -->
                    <div class="mb-3 fw-bold">
                        Invoices for {{ \Carbon\Carbon::create()->month((int) $month)->year((int) $year)->format('F Y') }}
                    </div>
                    <div style="overflow: auto;">
                        <table class="text-center table table-bordered table-sm table bordered-table sm-table mb-0">
                            <thead class="">
                                <tr>
                                    <th class="text-center">Index</th>
                                    <th class="text-center">Invoice Number</th>
                                    <th class="text-center">Created By</th>
                                    <th class="text-center">Student</th>
                                    <th class="text-center">Course/Product</th>
                                    <th class="text-center">Invoice Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse ($promocode->studentInvoices as $invoice)
                                    <tr>
                                        <td>{{ $loop->iteration }}</td>
                                        <td>{{ $invoice->invoice_number }}</td>
                                        {{-- <td>{{ $invoice->createdBy->full_name ?? '' }}</td> --}}
                                        <td>{{ $invoice->createdBy->email ?? '' }}</td>
                                        <td>{{ ($invoice->student->first_name ?? '') . ' ' . ($invoice->student->last_name ?? '') }}
                                        </td>
                                        <td>
                                            @if ($invoice->type == 'track')
                                                {{ $invoice->track->name_en ?? '' }}
                                            @else
                                                {{ $invoice->product->name_en ?? '' }}
                                            @endif
                                        </td>
                                        <td>{{ \Carbon\Carbon::parse($invoice->created_at)->format('d M Y') }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="6" class="text-center">No invoices found for this promocode in
                                            {{ \Carbon\Carbon::create()->month((int) $month)->year((int) $year)->format('F Y') }}.
                                        </td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection