@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" selected>Success</option>
                                        <option value="pending">Pending</option>
                                        <option value="failed">Failed</option>
                                        <option value="canceled">Canceled</option>
                                        <option value="refunded">Refunded</option>
                                        <option value="additional">Additional Participants</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 ($participants as $item)
                                    <tr>

                                        {{-- NAME --}}
                                        <td>
                                            @if($item->is_additional)
                                                {{ $item->eventReservation->user->personalInformation?->full_name_english }}
                                                <span class="text-muted">
                                                    (Additional)
                                                </span>
                                            @else
                                                {{ $item->registration_type=='guest'
                                                    ? $item->guest->name
                                                    : $item->user->personalInformation?->full_name_english }}
                                            @endif
                                        </td>

                                        {{-- FACULTY --}}
                                        <td>
                                            @if(!$item->is_additional)
                                                {{ $item->registration_type=='guest'
                                                    ? ''
                                                    : $item->user->personalInformation?->faculty?->name }}
                                            @else
                                                {{ $item->eventReservation->user->personalInformation?->faculty?->name }}
                                            @endif
                                        </td>

                                        {{-- PHONE --}}
                                        <td>
                                            @if($item->is_additional)
                                                {{ $item->eventReservation->user->personalInformation?->mobile_no }}
                                            @else
                                                {{ $item->registration_type=='guest'
                                                    ? $item->guest->phone
                                                    : $item->user->personalInformation?->mobile_no }}
                                            @endif
                                        </td>

                                        {{-- EMAIL --}}
                                        <td>
                                            @if($item->is_additional)
                                                {{ $item->eventReservation->user->personalInformation?->email }}
                                            @else
                                                {{ $item->registration_type=='guest'
                                                    ? $item->guest->email
                                                    : $item->user->personalInformation?->email }}
                                            @endif
                                        </td>

                                        {{-- TOTAL PARTICIPANTS --}}
                                        <td>
                                            @if($item->is_additional)
                                                {{
                                                    $item->spouse +
                                                    $item->children_below_5 +
                                                    $item->children_5_to_12 +
                                                    $item->children_above_12 +
                                                    $item->driver +
                                                    $item->maid +
                                                    $item->other_guest
                                                }}
                                            @else
                                                {{
                                                    $item->alumni +
                                                    $item->spouse +
                                                    $item->children_below_5 +
                                                    $item->children_5_to_12 +
                                                    $item->children_above_12 +
                                                    $item->driver +
                                                    $item->maid +
                                                    $item->other_guest
                                                }}
                                            @endif
                                        </td>

                                        {{-- PAYMENT TOTAL --}}
                                        <td>
                                            {{ $item->invoice['total'] ?? 0 }}
                                            <small class="text-muted">+ ({{ $maintenanceFeePercent }}%)</small>
                                            = {{ number_format(($item->invoice['total'] ?? 0) + (($item->invoice['total'] ?? 0) * $maintenanceFeePercent / 100), 2) }}
                                        </td>

                                        <td>{{ $item->created_at?->format('d M Y h:i A') }}</td>

                                        {{-- PAYMENT STATUS --}}
                                        <td class="text-center">
                                            @if($item->payment_status === 'success')
                                                <span class="badge bg-success">{{ $item->payment_status }}</span>
                                            @else
                                                <span class="badge bg-danger">{{ $item->payment_status }}</span>
                                            @endif

                                            @if($item->is_additional)
                                                <span class="badge bg-warning">(Additional)</span>
                                            @endif
                                        </td>

                                        {{-- ACTIONS --}}
                                        <td>
                                            <div class="btn-group btn-group-sm" role="group">
                                                @if(!$item->is_additional)
                                                    <a target="_blank" 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 target="_blank" href="{{ route('invoice.show', encrypt($item->paymentLog->invoice->id)) }}"
                                                           class="btn btn-info btn-sm">
                                                            Invoice
                                                        </a>
                                                    @endif
                                                @else
                                                    <a target="_blank"
                                                       href="{{ route('reservation.additional.show', [$item->eventReservation->id, $item->id]) }}"
                                                       class="btn btn-primary btn-sm">
                                                        View
                                                    </a>

                                                    @if($item->payment_status === 'success')
                                                        <a target="_blank" href="{{ route('invoice.additional-reservation.show', encrypt($item->paymentLog->invoice->id)) }}"
                                                           class="btn btn-info btn-sm">
                                                            Invoice
                                                        </a>
                                                    @endif
                                                @endif
                                            </div>
                                        </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)

                const nameColumn = data[0].toLowerCase();    // Name column (contains "(Additional)" if additional)

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

                if (filterValue === 'additional') {
                    // Show only additional participants
                    return nameColumn.includes('(additional)');
                }

                // 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();
        });

        if($('#paymentStatusFilter').val()){
            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