@extends('layouts.admin.master')
@section('title', 'Events Management')

@php
    $maintenanceFeePercent = config('services.maintenance_fee');
@endphp

@section('content')
<div class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1 class="m-0">Events Management</h1>
            </div>
            <div class="col-sm-6">
                <ol class="breadcrumb float-sm-right">
                    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                    <li class="breadcrumb-item active">Events</li>
                </ol>
            </div>
        </div>
    </div>
</div>
<div class="content">
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <div class="d-flex justify-content-between align-items-center">
                            <h3 class="card-title mb-0">Participants List for ({{ $event->name }})</h3>
                        </div>

                        {{-- Payment Status Filter --}}
                        <div class="row mt-3">
                            <div class="col-md-5 ml-auto">
                                <div class="d-flex justify-content-between align-items-center" style="gap: 15px;">
                                    <select id="paymentStatusFilter" class="form-control form-control-sm">
                                        <option value="">All Statuses</option>
                                        <option value="success">Success</option>
                                        <option value="pending">Pending</option>
                                        <option value="failed">Failed</option>
                                        <option value="canceled">Canceled</option>
                                        <option value="refunded">Refunded</option>
                                    </select>
                                    <a href="{{ route('admin.event.participants.export', $event->id) }}" id="exportBtn" class="btn btn-success btn-sm float-right" style="width: 200px;">
                                        <i class="fas fa-file-excel"></i> Export to Excel
                                    </a>
                                </div>
                            </div>
                            {{-- <div class="col-md-3 ml-auto">
                                <select id="paymentStatusFilter" class="form-control form-control-sm">
                                    <option value="">All Statuses</option>
                                    <option value="success">Success</option>
                                    <option value="pending">Pending</option>
                                    <option value="failed">Failed</option>
                                    <option value="canceled">Canceled</option>
                                    <option value="refunded">Refunded</option>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <a href="{{ route('admin.event.participants.export', $event->id) }}" id="exportBtn" class="btn btn-success btn-sm float-right">
                                    <i class="fas fa-file-excel"></i> Export to Excel
                                </a>
                            </div> --}}
                        </div>
                    </div>
                    <div class="card-body">

                        <div class="table-responsive">
                            <table id="eventsTable" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th>Name</th>
                                        <th>Faculty</th>
                                        <th>Mobile</th>
                                        <th>Email</th>
                                        <th>Participants Number</th>
                                        <th>Amount</th>
                                        <th>Date/Time</th>
                                        <th style="width: 10%">Payment Status</th>
                                        <th style="width: 10%">Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($event->participants as $item)
                                        <tr>
                                            <td>{{ $item->registration_type=='guest' ? $item->guest->name : $item->user->personalInformation?->full_name_english }}</td>
                                            <td>{{ $item->registration_type=='guest' ? '' : $item->user->personalInformation?->faculty?->name }}</td>
                                            <td>{{ $item->registration_type=='guest' ? $item->guest->phone : $item->user->personalInformation?->mobile_no }}</td>
                                            <td>{{ $item->registration_type=='guest' ? $item->guest->email : $item->user->personalInformation?->email }}</td>
                                            <td>
                                                {{
                                                    $item->alumni+$item->spouse+$item->children_below_5+$item->children_5_to_12+$item->children_above_12+$item->driver+$item->maid+$item->other_guest
                                                }}
                                                {{-- <p class="mb-0"><strong>alumni : </strong>{{ $item->alumni }}</p>
                                                <p class="mb-0"><strong>spouse : </strong>{{ $item->spouse }}</p>
                                                <p class="mb-0"><strong>children below 5 : </strong>{{ $item->children_below_5 }}</p>
                                                <p class="mb-0"><strong>children 5 to 12 : </strong>{{ $item->children_5_to_12 }}</p>
                                                <p class="mb-0"><strong>children above 12 : </strong>{{ $item->children_above_12 }}</p>
                                                <p class="mb-0"><strong>driver : </strong>{{ $item->driver }}</p>
                                                <p class="mb-0"><strong>maid : </strong>{{ $item->maid }}</p>
                                                <p class="mb-0"><strong>other guest : </strong>{{ $item->other_guest }}</p>
                                                @if (!empty($item->special_requirements))
                                                    <p class="mb-0"><strong>special requirements : </strong>{{ $item->special_requirements ?? '' }}</p>
                                                @endif --}}
                                            </td>
                                            <td>
                                                {{ $item->invoice['total'] ?? 0 }}
                                                <small class="text-muted">
                                                    + ({{ $maintenanceFeePercent }}%)
                                                </small>
                                                = {{ number_format($item->invoice['total'] + ($item->invoice['total'] * $maintenanceFeePercent / 100), 2) }}
                                            </td>
                                            <td>{{ $item->created_at?->format('d M Y h:i A') }}</td>
                                            <td class="text-center">
                                                @switch($item->payment_status)
                                                    @case('pending')
                                                    @case('refunded')
                                                    @case('failed')
                                                    @case('canceled')
                                                        <span class="badge bg-danger">{{ $item->payment_status }}</span>
                                                        @break
                                                    @default
                                                        <span class="badge bg-success">{{ $item->payment_status }}</span>
                                                @endswitch
                                            </td>
                                            <td>
                                                <a href="{{ route('reservation.details', $item->id) }}" class="btn btn-primary btn-sm">View</a>
                                                @if ($item->payment_status == 'success' && $item->paymentLog && $item->paymentLog->invoices->isNotEmpty())
                                                    <a href="{{ route('invoice.show', encrypt($item->paymentLog->invoice->id)) }}" class="btn btn-info btn-sm" target="_blank">
                                                        Invoice
                                                    </a>
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection
@push('js')
<script src="https://cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.11.5/js/dataTables.bootstrap4.min.js"></script>
<script>
    $(document).ready(function(){
        const table = $('#eventsTable').DataTable({
            pageLength: 25,
            responsive: false,
            processing: true,
            lengthMenu: [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]],
            ordering: false,
        });

        // Custom filter for payment status
        $.fn.dataTable.ext.search.push(
            function(settings, data, dataIndex) {
                const filterValue = $('#paymentStatusFilter').val().toLowerCase();
                const paymentStatus = data[7]; // Payment Status is in column index 6 (0-based)

                // If no filter selected, show all rows
                if (filterValue === '') {
                    return true;
                }

                // Check if the payment status matches the filter
                return paymentStatus.toLowerCase().includes(filterValue);
            }
        );

        // Trigger table redraw when filter changes
        $('#paymentStatusFilter').on('change', function() {
            table.draw();
            updateExportUrl();
        });

        // Update export URL based on filter
        function updateExportUrl() {
            const filterValue = $('#paymentStatusFilter').val();
            const baseUrl = '{{ route('admin.event.participants.export', $event->id) }}';
            const newUrl = filterValue ? baseUrl + '?status=' + filterValue : baseUrl;
            $('#exportBtn').attr('href', newUrl);
        }

        // Initialize export URL
        updateExportUrl();
    });
</script>
@endpush