@extends('layouts.header')

@section('content')
<main>
    <div class="container-fluid px-4">
        <h1 class="mt-4">Sponsor List</h1>
        <ol class="breadcrumb mb-4">
            <li class="breadcrumb-item"><a href="{{ route('dash') }}">Dashboard</a></li>
            <li class="breadcrumb-item active"><a href="{{ route('sponsor.list') }}">Sponsor List</a></li>
        </ol>
        <div class="row">
            <div class="col-xl-12">
                <div class="card mb-4">
                    <div class="card-header">
                        <i class="fas fa-table me-1"></i>
                        Sponsor Details
                    </div>
                    <div class="card-body">
                        <!-- File upload form -->
                        <form id="uploadForm" enctype="multipart/form-data">
                            @csrf
                            <div class="d-flex align-items-end">
                                <div class="me-2">
                                    <label for="file" class="form-label">Upload Excel File:</label>
                                    <input type="file" id="file" name="file" class="form-control" accept=".xlsx, .xls">
                                </div>
                                <button type="button" id="uploadButton" class="btn btn-primary">Upload</button>
                            </div>
                        </form>

                        <!-- Sponsor Table -->
                        <table id="datatablesSimple" class="table mt-4">
                            <thead>
                                <tr>
                                    <th>Serial Number</th>
                                    <th>Full Name</th>
                                    <th>Gender</th>
                                    <th>Date of Birth</th>
                                    <th>Address</th>
                                    <th>City</th>
                                    <th>State/Province</th>
                                    <th>Zip/Postal Code</th>
                                    <th>Country</th>
                                    <th>Phone Number</th>
                                    <th>Email Address</th>
                                    <th>PAN Card Number</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                $serialNumber = 1;
                                @endphp
                                @foreach($sponsors as $sponsor)
                                <tr>
                                    <td>{{ $serialNumber }}</td>
                                    <td>{{ $sponsor->fullName }}</td>
                                    <td>{{ $sponsor->gender }}</td>
                                    <td>{{ \Carbon\Carbon::parse($sponsor->dob)->format('d/m/Y') }}</td>
                                    <td>{{ $sponsor->address }}</td>
                                    <td>{{ $sponsor->city }}</td>
                                    <td>{{ $sponsor->state }}</td>
                                    <td>{{ $sponsor->zip }}</td>
                                    <td>{{ $sponsor->country }}</td>
                                    <td>{{ $sponsor->phone }}</td>
                                    <td>{{ $sponsor->email }}</td>
                                    <td>{{ $sponsor->pan }}</td>
                                    <td>
                                        <a href="{{ route('sponsor.edit', $sponsor->id) }}" class="btn btn-primary">Edit</a>
                                        <a href="{{ route('payment.paymentlist', $sponsor->id) }}" class="btn btn-primary">Payment List</a>
                                        <form action="{{ route('sponsor.destroy', $sponsor->id) }}" method="POST" style="display: inline;">
                                            @csrf
                                            @method('DELETE')
                                            <button type="submit" class="btn btn-danger">Delete</button>
                                        </form>
                                    </td>
                                </tr>
                                @php
                                $serialNumber++;
                                @endphp
                                @endforeach
                            </tbody>
                        </table>

                    </div>
                </div>
            </div>
        </div>
    </div>
    @if(session('success'))
    <div id="successMessage" class="alert alert-success">
        {{ session('success') }}
    </div>
    @endif
</main>
@endsection

@push('scripts')
<script>
    document.addEventListener("DOMContentLoaded", function() {
        const successMessage = document.getElementById('successMessage');
        if (successMessage) {
            // Display the success message as a centered popup
            successMessage.style.position = 'fixed';
            successMessage.style.top = '50%';
            successMessage.style.left = '50%';
            successMessage.style.transform = 'translate(-50%, -50%)';
            successMessage.style.zIndex = '1000';

            // Hide the success message after 5 seconds
            setTimeout(function() {
                successMessage.style.display = 'none';
            }, 5000);
        }
    });
</script>
<!-- Include jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<script>
$(document).ready(function () {
    $('#uploadButton').on('click', function () {
        var formData = new FormData($('#uploadForm')[0]);

        var file = $('#file')[0].files[0];

        if (!file) {
            alert("Please select a file.");
            return;
        }

        formData.append('file', file);

        $.ajax({
            url: "{{ route('sponsor.import') }}",
            type: 'POST',
            data: formData,
            processData: false,
            contentType: false,
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            },
            success: function (response) {
                alert("Sponsors imported successfully.");
                // Optionally, you can refresh the page or do something else here
                location.reload();
            },
            error: function (xhr) {
                alert("An error occurred while uploading the file.");
                console.log(xhr.responseText); // For debugging purposes
            }
        });
    });
});
</script>
@endpush