@extends('layouts.admin')

@section('content')
    @php
        $sNo = request()->page ? request()->page * 10 - 10 : 0;
    @endphp
    <section class="section">
        <div class="section-body">
            <div class="row">
                <div class="col-12 col-md-12 col-lg-12">
                    {{-- <x-admin_alert /> --}}
                    <div class="card">
                        <div class="card-header custom-cart-header">
                            <h4>Completed Events</h4>
                            {{-- <x-search-form/> --}}
                        </div>
                        <div class="tabs completed-events-tab">
                            <ul class="nav nav-tabs">
                                <li class="nav-item">
                                    <a class="nav-link {{ $tab == 'open' ? 'active' : '' }}"
                                        href="{{ route('admin.events.completed', ['tab' => 'open', 'search' => request('search')]) }}">Completed
                                        Events -
                                        Open</a>
                                </li>
                                <li class="nav-item">
                                    <a class="nav-link {{ $tab == 'closed' ? 'active' : '' }}"
                                        href="{{ route('admin.events.completed', ['tab' => 'closed', 'search' => request('search')]) }}">Completed
                                        Events -
                                        Closed</a>
                                </li>
                            </ul>
                            <div class="tab-content">
                                <!-- Tab 1: Events with host payout -->
                                <div class="tab-pane {{ $tab == 'open' ? 'active' : '' }}">
                                    <div class="card-body">
                                        <form method="GET">
                                            <div class="row mb-3">
                                                <div class="col-md-4">
                                                    <input type="text" name="search" class="form-control"
                                                        value="{{ request('search') }}" placeholder="Search...">
                                                    <input type="hidden" name="tab"
                                                        value="{{ request('tab', 'with') }}">
                                                </div>

                                                <div class="col">
                                                    <button type="submit" class="btn btn-primary">Search</button>
                                                    <a href="{{ route('admin.events.completed') }}"
                                                        class="btn btn-secondary">Clear</a>
                                                </div>
                                            </div>
                                        </form>

                                        {{-- <p>Total Event Fees $ Earned year to date - completed Events:
                                            <span>${{ number_format($total['event-fee-year-to-date'] ?? 0, 2) }}</span>
                                        </p>

                                        <p>Total Event Fees $ Paid:
                                            <span>${{ number_format($total['event-fee-paid'] ?? 0, 2) }}</span>
                                        </p> --}}

                                        <p>Total Event Fees owed to Hosts:
                                            <span>${{ number_format($total['total-owned-to-host'] ?? 0.0, 2) }}</span>
                                        </p>

                                        <div class="table-responsive">
                                            <table class="table table-striped table-md table-data-text-center">
                                                <tr>
                                                    <th>#Sno.</th>
                                                    <th>Host Logo</th>
                                                    <th>Host #Sno.</th>
                                                    <th>Event Code</th>
                                                    <th>Event Start Date</th>
                                                    <th>Event End Date</th>
                                                    <th>Entry Fee</th>
                                                    <th>No. of Participants</th>

                                                    <th>Entry Fee Revenue Due</th>
                                                    <th>Email</th>
                                                    <th>Bank Routing #</th>
                                                    <th>Bank Account #</th>

                                                    {{-- <th>Receipt <i class="fas fa-file-invoice"></i></th> --}}
                                                    <th>Receipt
                                                        {{-- <img src="{{ asset('images/receipt-icon.png') }}" alt=""> --}}
                                                    </th>
                                                    {{-- <th>Date Paid</th> --}}
                                                    <th>
                                                        <button class="btn btn-warning">Confirm
                                                            Payment
                                                            and Post
                                                            Receipt</button>
                                                    </th>
                                                </tr>

                                                @forelse ($completed_events_with_data as $event)
                                                    <tr>
                                                        <td>{{ $sNo + $loop->index + 1 }}</td>
                                                        <td><img src="{{ isset($event->eventLogo->first()->path) ? asset('storage/' . $event->eventLogo->first()->path) : asset('images/upload-host-logo.svg') }}"
                                                                alt="" height="50" width="50"></td>
                                                        <td>{{ $event->user ? makeHostId($event->user->id) : 'N/A' }}</td>
                                                        <td>{{ $event->event_code ?? '' }}</td>
                                                        <td>{{ $event->start_date ? $event->start_date->format('m/d/Y') : '' }}
                                                        </td>
                                                        <td>{{ $event->end_date ? $event->end_date->format('m/d/Y') : '' }}
                                                        </td>
                                                        <td>$ {{ number_format($event->event_fee ?? 0, 2) }}</td>
                                                        <td class="text-center">{{ $event->total_participants ?? 0 }}</td>
                                                        <td class="text-center">$
                                                            {{ number_format($event->total_due ?? 0, 2) }}</td>
                                                        <td>{{ $event->user->email ?? '' }}</td>
                                                        <td>
                                                            @php
                                                                $routingNumber =
                                                                    $event->user?->bankDetails?->routing_number;
                                                            @endphp
                                                            {{ $routingNumber ? jsdecode_userdata($routingNumber) : 'N/A' }}
                                                        </td>
                                                        <td>
                                                            @php
                                                                $accountNumber =
                                                                    $event->user?->bankDetails?->account_number;
                                                            @endphp
                                                            {{ $accountNumber ? jsdecode_userdata($accountNumber) : 'N/A' }}
                                                        </td>
                                                        {{-- <td><i class="fas fa-file-invoice"></i></td> --}}
                                                        <td class="text-center">
                                                            @if ($event->receiptFile('event_revenue_receipt'))
                                                                <button type="button"
                                                                    class="btn btn-warning btn-sm resetButton"
                                                                    data-url="{{ route('admin.member.resetReceipt') }}"
                                                                    data-type="{{ jsencode_userdata('event_revenue_receipt') }}"
                                                                    data-event-id="{{ $event->id }}">
                                                                    <i class="fas fa-undo-alt"></i> Reset
                                                                </button>

                                                                <a href="{{ Storage::disk('public')->url($event->receiptFile('event_revenue_receipt') ? $event->receiptFile('event_revenue_receipt')->path : '') }}"
                                                                    target="_blank" class="btn btn-info btn-sm viewButton">
                                                                    <i class="fa fa-eye" aria-hidden="true"></i> View
                                                                </a>
                                                            @else
                                                                <input type="file" class="receiptFile"
                                                                    id="receiptFile_{{ $event->id }}" name="receipt"
                                                                    style="display: none;" accept="application/pdf"
                                                                    data-url="{{ route('admin.member.uploadReceipt') }}"
                                                                    data-event-id="{{ $event->id }}"
                                                                    data-type="{{ jsencode_userdata('event_revenue_receipt') }}">
                                                                <button type="button" class="uploadButton"
                                                                    data-event-id="{{ $event->id }}"
                                                                    data-is-uploaded="{{ $event->receiptFile('event_revenue_receipt') ? true : false }}">
                                                                    <img src="{{ asset('images/receipt-icon.png') }}"
                                                                        alt=""></button>
                                                            @endif

                                                        </td>
                                                        {{-- <td>
                                                            {{ $event->hostPayoutByEventRevenue->first() ? $event->hostPayoutByEventRevenue->first()->payout_date->format('m/d/Y') : 'N/A' }}
                                                        </td> --}}
                                                        <td class='text-center'>
                                                            @if ($event && isPayoutExistForEventRevenue($event->id))
                                                                <span class="badge bg-success">Paid</span>
                                                            @elseif(!($event && isPayoutExistForEventRevenue($event->id)) && $event->total_due == 0)
                                                                <span class="badge bg-warning">No Due Amount</span>
                                                            @else
                                                                <a href="{{ route('admin.member.createHostPayoutByEvent', ['type' => jsencode_userdata('event_revenue')]) }}"
                                                                    class="btn btn-warning confirm-payment"
                                                                    data-host-id="{{ $event->user->id ?? null }}"
                                                                    data-event-id="{{ $event->id ?? null }}"
                                                                    data-is-uploaded="{{ $event->receiptFile('event_revenue_receipt') ? true : false }}">Confirm
                                                                    Payment
                                                                    and Post
                                                                    Receipt</a>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @empty
                                                    <tr>
                                                        <td class="no-record-found" colspan="8">
                                                            <center>Did not found any events</center>
                                                        </td>
                                                    </tr>
                                                @endforelse
                                            </table>
                                            {{ $completed_events->links() }}
                                        </div>
                                    </div>
                                </div>

                                <div class="tab-pane {{ $tab == 'closed' ? 'active' : '' }}">

                                    <div class="card-body">
                                        <form method="GET">
                                            <div class="row mb-3">
                                                <div class="col-md-4">
                                                    <input type="text" name="search" class="form-control"
                                                        value="{{ request('search') }}" placeholder="Search...">
                                                </div>

                                                <div class="col">
                                                    <button type="submit" class="btn btn-primary">Search</button>
                                                    <a href="{{ route('admin.events.completed') }}"
                                                        class="btn btn-secondary">Clear</a>
                                                </div>
                                            </div>
                                        </form>

                                        <p>Total Event Fees $ Earned year to date - completed Events:
                                            <span>${{ number_format($total['event-fee-year-to-date-closed'] ?? 0, 2) }}</span>
                                        </p>

                                        <p>Total Event Fees $ Paid:
                                            <span>${{ number_format($total['event-fee-paid'] ?? 0, 2) }}</span>
                                        </p>


                                        {{-- <p>Total Event Fees owed to Hosts:
                                            <span>${{ number_format($total['total-owned-to-host'] ?? 0.0, 2) }}</span>
                                        </p> --}}

                                        <div class="card-download-list">
                                            <h4>Download list</h4>
                                            <div class="card-download-list-inner">
                                                <div class="card-download-select">
                                                    <div class="card-download-select-date">
                                                        <input type="text" name="start_date" id="start-date"
                                                            placeholder="Select date" class="form-control date-picker"
                                                            value="" autocomplete="off" readonly>
                                                    </div>
                                                    <span>Thru</span>
                                                    <div class="card-download-select-date">
                                                        <input type="text" name="end_date" id="end-date" readonly
                                                            placeholder="Select date" class="form-control date-picker"
                                                            value="" autocomplete="off">
                                                    </div>
                                                </div>
                                                <div class="card-download-btn">
                                                    <a href="javascript:void(0)" data-start_date="" data-end_date=""
                                                        class="download_member-result">
                                                        <svg width="22" height="22" viewBox="0 0 22 22"
                                                            fill="none" xmlns="http://www.w3.org/2000/svg">
                                                            <path d="M4.33325 17.667H17.6666" stroke="white"
                                                                stroke-width="2" stroke-linecap="round"
                                                                stroke-linejoin="round" />
                                                            <path
                                                                d="M11 4.33398V13.2229M11 13.2229L14.8889 9.33398M11 13.2229L7.11108 9.33398"
                                                                stroke="white" stroke-width="2" stroke-linecap="round"
                                                                stroke-linejoin="round" />
                                                            <path
                                                                d="M1 20.3333V1.66667C1 1.29848 1.29848 1 1.66667 1H20.3333C20.7016 1 21 1.29848 21 1.66667V20.3333C21 20.7016 20.7016 21 20.3333 21H1.66667C1.29848 21 1 20.7016 1 20.3333Z"
                                                                stroke="white" stroke-width="2" />
                                                        </svg>
                                                        Download
                                                    </a>
                                                </div>
                                            </div>
                                        </div>


                                        <div class="table-responsive">
                                            <table class="table table-striped table-md">
                                                <tr>
                                                    <th>#Sno.</th>
                                                    <th>Host Logo</th>
                                                    <th>Host #Sno.</th>
                                                    <th>Event Code</th>
                                                    <th>Event Start Date</th>
                                                    <th>Event End Date</th>
                                                    <th>Entry Fee</th>
                                                    <th>No. of Participants</th>
                                                    <th>Event Revenue Paid</th>
                                                    <th>Entry Fee Revenue Due</th>
                                                    <th>Email</th>
                                                    <th>Bank Routing #</th>
                                                    <th>Bank Account #</th>
                                                    {{-- <th>Receipt <i class="fas fa-file-invoice"></i></th> --}}
                                                    <th>Receipt
                                                        {{-- <img src="{{ asset('images/receipt-icon.png') }}" alt=""> --}}
                                                    </th>
                                                    <th>Date Paid</th>
                                                    <th>Status</th>
                                                </tr>
                                                @forelse ($completed_events_with_data as $event)
                                                    <tr>
                                                        <td>{{ $sNo + $loop->index + 1 }}</td>
                                                        <td><img src="{{ isset($event->eventLogo->first()->path) ? asset('storage/' . $event->eventLogo->first()->path) : asset('images/upload-host-logo.svg') }}"
                                                                alt="" height="50" width="50"></td>
                                                        <td>{{ $event->user ? makeHostId($event->user->id) : 'N/A' }}</td>
                                                        <td>{{ $event->event_code ?? '' }}</td>
                                                        <td>{{ $event->start_date ? $event->start_date->format('m/d/Y') : '' }}
                                                        </td>
                                                        <td>{{ $event->end_date ? $event->end_date->format('m/d/Y') : '' }}
                                                        </td>
                                                        <td>$ {{ number_format($event->event_fee ?? 0, 2) }}</td>
                                                        <td>{{ $event->total_participants ?? 0 }}</td>
                                                        {{-- <td>{{ $event->hostPayoutByEventRevenue ? '$'. number_format($event->hostPayoutByEventRevenue->sum('payout_amount'), 2) : 'N/A' }}</td> --}}
                                                        <td>$ {{ number_format($event->total_paid ?? 0, 2) }}</td>
                                                        <td>$ {{ number_format($event->total_due ?? 0, 2) }}</td>
                                                        <td>{{ $event->user->email ?? '' }}</td>
                                                        <td>
                                                            @php
                                                                $routingNumber =
                                                                    $event->user?->bankDetails?->routing_number;
                                                            @endphp
                                                            {{ $routingNumber ? jsdecode_userdata($routingNumber) : 'N/A' }}
                                                        </td>
                                                        <td>
                                                            @php
                                                                $accountNumber =
                                                                    $event->user?->bankDetails?->account_number;
                                                            @endphp
                                                            {{ $accountNumber ? jsdecode_userdata($accountNumber) : 'N/A' }}
                                                        </td>
                                                        {{-- <td><i class="fas fa-file-invoice"></i></td> --}}
                                                        <td class="text-center">
                                                            @if ($event->receiptFile('event_revenue_receipt'))
                                                                {{-- <button type="button"
                                                                    class="btn btn-warning btn-sm resetButton"
                                                                    data-url="{{ route('admin.member.resetReceipt') }}"
                                                                    data-type="{{ jsencode_userdata('event_revenue_receipt') }}"
                                                                    data-event-id="{{ $event->id }}">
                                                                    <i class="fas fa-undo-alt"></i> Reset
                                                                </button> --}}

                                                                <a href="{{ Storage::disk('public')->url($event->receiptFile('event_revenue_receipt') ? $event->receiptFile('event_revenue_receipt')->path : '') }}"
                                                                    target="_blank"
                                                                    class="btn btn-info btn-sm viewButton">
                                                                    <i class="fa fa-eye" aria-hidden="true"></i> View
                                                                </a>
                                                            @else
                                                                <input type="file" class="receiptFile"
                                                                    id="receiptFile_{{ $event->id }}" name="receipt"
                                                                    style="display: none;" accept="application/pdf"
                                                                    data-url="{{ route('admin.member.uploadReceipt') }}"
                                                                    data-event-id="{{ $event->id }}"
                                                                    data-type="{{ jsencode_userdata('event_revenue_receipt') }}">
                                                                <button type="button" class="uploadButton"
                                                                    data-event-id="{{ $event->id }}"
                                                                    data-is-uploaded="{{ $event->receiptFile('event_revenue_receipt') ? true : false }}">
                                                                    <img src="{{ asset('images/receipt-icon.png') }}"
                                                                        alt=""></button>
                                                            @endif
                                                        </td>
                                                        <td>
                                                            {{ $event->hostPayoutByEventRevenue->first() ? $event->hostPayoutByEventRevenue->first()->payout_date->format('m/d/Y') : 'N/A' }}
                                                        </td>
                                                        <td>
                                                            @if ($event && isPayoutExistForEventRevenue($event->id))
                                                                <span class="badge bg-success">Paid</span>
                                                            @elseif(!($event && isPayoutExistForEventRevenue($event->id)) && $event->total_due == 0)
                                                                <span class="badge bg-warning">No Due Amount</span>
                                                            @else
                                                                <a href="{{ route('admin.member.createHostPayoutByEvent', ['type' => jsencode_userdata('event_revenue')]) }}"
                                                                    class="btn btn-warning confirm-payment"
                                                                    data-host-id="{{ $event->user->id ?? null }}"
                                                                    data-event-id="{{ $event->id ?? null }}">Confirm
                                                                    Payment
                                                                    and Post
                                                                    Receipt</a>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @empty
                                                    <tr>
                                                        <td class="no-record-found" colspan="8">
                                                            <center>Did not found any events</center>
                                                        </td>
                                                    </tr>
                                                @endforelse
                                            </table>
                                            {{ $completed_events->links() }}
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
    </section>
@endsection

@push('pagespecificscripts')
    @include('admin.manage_events.js-confirm-payout-receipt');
    <script>
        jQuery(document).ready(function(e) {
            $('#start-date').datepicker({
                format: 'mm/dd/yyyy',
                autoclose: true,
                todayHighlight: true,
            });

            $('#end-date').datepicker({
                format: 'mm/dd/yyyy',
                autoclose: true,
                todayHighlight: true,
            });

            $('#start-date, #end-date').on('change', function() {
                var startDate = $('#start-date').val();
                var endDate = $('#end-date').val();

                // Convert to Date objects
                var start = new Date(startDate);
                var end = new Date(endDate);

                // Set the time to midnight (00:00:00) to ignore the time part
                start.setHours(0, 0, 0, 0);
                end.setHours(0, 0, 0, 0);

                // Check if end date is smaller than start date
                if (end < start) {
                    $('#end-date').val('');
                    iziToast.error({
                        title: 'Error',
                        message: 'End date must be greater than start date',
                        position: 'topRight'
                    });
                    return false;
                }

                if (startDate && endDate) {
                    
                    $('.download_member-result').attr("data-start_date", convertDateFormat(startDate) );
                    $('.download_member-result').attr("data-end_date", convertDateFormat(endDate));
                }
            });

            $('.download_member-result').click(function() {
                var startDate = $(this).attr('data-start_date');
                var endDate = $(this).attr('data-end_date');

                // let data = {
                //     start_date: startDate,
                //     end_date: endDate,
                // };



                if (startDate == '' && endDate == '') {
                    iziToast.error({
                        title: 'Error',
                        message: 'Please select dates',
                        position: 'topRight'
                    });
                    return false
                }

                let url = `${APP_URL}/admin/download/paidedEvents/${startDate}/${endDate}`;
                
                window.location.href = url;
                return false;

                // let response = ajaxCall(url, 'get', data);

                // response.then((response) => {

                //     if (response.success === true) {
                //         iziToast.success({
                //             title: 'Success',
                //             message: response.message,
                //             position: 'topRight'
                //         });
                //         const secureUrl = response.file_url ? response.file_url.replace('http://',
                //             'https://') : '';

                //         if (secureUrl) {
                //             const link = document.createElement('a');
                //             link.href = secureUrl;
                //             link.download = '';
                //             document.body.appendChild(link);

                //             link.click();
                //             document.body.removeChild(link);

                //         } else {
                //             iziToast.error({
                //                 title: 'Error',
                //                 message: 'File URL is not found.',
                //                 position: 'topRight'
                //             });
                //         }
                //     } else {
                //         iziToast.error({
                //             title: 'Error',
                //             message: response.message,
                //             position: 'topRight'
                //         });
                //     }
                // }).catch(error => {
                //     console.error('Error:', error);
                //     iziToast.error({
                //         title: 'Error',
                //         message: 'An unexpected error occurred.',
                //         position: 'topRight'
                //     });
                // });
            });
        });
    </script>
    {{-- <script>
        $(document).ready(function() {
            $('.confirm-payment').click(function(e) {
                e.preventDefault();
                Swal.fire({
                    title: "Are you sure?",
                    text: "You want to confirm the payment?",
                    icon: "warning",
                    showCancelButton: true,
                    confirmButtonColor: "#3085d6",
                    cancelButtonColor: "#d33",
                    confirmButtonText: "Yes"
                }).then((result) => {
                    if (result.isConfirmed) {

                        let hostId = $(this).data('host-id');
                        let eventId = $(this).data('event-id');
                        let formData = {
                            eventId: eventId,
                            hostId: hostId,
                        }

                        let url = jQuery(this).attr('href');

                        let response = ajaxCall(url, 'post', formData, true, true);

                        let $currentElement = $(this);

                        // response = ajaxCall(url, 'get')
                        response.then((response) => {
                            if (response.status) {
                                $currentElement.closest('td').text('Paid');
                                Swal.fire({
                                    title: "Confirmed!",
                                    text: response.message,
                                    icon: (response.status ? 'success' : 'error')
                                });
                                setTimeout(() => window.location.reload(), 2000);
                            } else {
                                Swal.fire({
                                    title: "Error",
                                    text: response.message,
                                    icon: "error"
                                });
                            }
                        });
                    }
                    // else {
                    //     Swal.fire({
                    //         title: "Cancelled",
                    //         text: "Your payment has not been confirmed",
                    //         icon: "error"
                    //     });
                    // }
                });
            });

            // upload receipt
            $('.uploadButton').on('click', function() {
                // console.log('clicked');
                var eventId = $(this).data('event-id');
                $("#receiptFile_" + eventId).click();
            });
            $('.receiptFile').on('change', function() {
                var this_element = $(this);
                if ($(this)[0].files.length > 0) {
                    let file = $(this)[0].files[0];
                    let fileSizeMB = file.size / (1024 * 1024);
                    if (fileSizeMB > 10) {
                        backendErrorShow('Error', 'File size exceeds the limit of 10MB', 'Try again');
                        this_element.val('');
                        return;
                    }
                    let url = $(this).data('url');
                    let eventId = $(this).data('event-id');
                    let type = $(this).data('type');
                    let formData = new FormData();
                    formData.append('receipt', $(this)[0].files[0]);
                    formData.append('eventId', eventId);
                    formData.append('type', type);
                    let response = ajaxCall(url, 'post', formData, true, true);
                    response.then((response) => {
                        if (response.success == true) {
                            backendSuccessShow(response.msg)
                        } else {
                            backendErrorShow('Error', response.msg, 'Try again');
                        }
                    })
                }
            })

        });
    </script> --}}

    <script>
        function convertDateFormat(date) {
            var dateStr = date; // Get the date string (m/d/y)

            // Split the date string by the '/' delimiter
            var dateParts = dateStr.split('/');

            // Ensure we have 3 parts: month, day, year
            if (dateParts.length === 3) {
                var month = dateParts[0];
                
                var day = dateParts[1];
                var year = dateParts[2];

                // Convert to y-m-d format
                var formattedDate = year + '-' + ('0' + month).slice(-2) + '-' + ('0' + day).slice(-2);

                // Display the result
                return formattedDate;
            } else {
                return false;
            }
        }
    </script>
@endpush