@extends('layouts.admin.admin')

@section('title', 'Order')

@section('content')
    <div class="row">
        <div class="col-12">
            <div class="page-title-box d-flex align-items-center justify-content-between">
                <h5 class="mb-0 font-size-18">{{ ucwords($order_status[0] ?? config('custom.all')) }} Order</h5>

                <div class="page-title-right">
                    <ol class="breadcrumb m-0">
                        <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                        <li class="breadcrumb-item">Order</li>
                        <li class="breadcrumb-item active">{{ ucwords($order_status[0] ?? config('custom.all')) }}</li>
                    </ol>
                </div>

            </div>
        </div>
    </div>
    <div>
        <form>
            <div class="card">
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user" class="col-form-label pt-0">Choose Instituion</label>
                                <select data-placeholder="Select Option" id="institution_id"
                                    class="select2 tail-select  form-control" name="institution_id"
                                    onchange="getCoursesCeremonies('0')" required>
                                    <option value="0" selected>All</option>
                                    @foreach ($institutions as $institute)
                                        <option value="{{ $institute->id }}">{{ $institute->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user" class="col-form-label pt-0">Ceremony Type</label>
                                <select data-placeholder="Select Option" id="ceremony_type"
                                    class="select2 tail-select  form-control" name="ceremony_type"
                                    onchange="getCeremonyList('0')" required>
                                    <option value="{{ \App\Constant\Constant::ACTIVE }}" selected>
                                        {{ \App\Constant\Constant::ACTIVE }} Only</option>
                                    <option value="{{ \App\Constant\Constant::ALL }}">{{ \App\Constant\Constant::ALL }}
                                    </option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user" class="col-form-label pt-0">Graduation Ceremonies</label>
                                <select data-placeholder="Select Option" name="ceremony_id" id="ceremony"
                                    class="select2 tail-select  form-control ceremony" required>
                                    <option value="0">All</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user" class="col-form-label pt-0">Course</label>
                                <select data-placeholder="Select Option" id="course_id"
                                    class="select2 tail-select  form-control courses" name="course_id" required>
                                    <option value="0">All</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user" class="col-form-label pt-0">Order Status</label>
                                <select data-placeholder="Select Option" id="order_status"
                                    class="select2 tail-select  form-control" name="order_status" required>
                                    @foreach ($order_status as $status)
                                        <option value="{{ $status }}">{{ $status }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label for="user" class="col-form-label pt-0">Academic Regalia Status</label>
                                <select data-placeholder="Select Option" id="academic_regalia_status"
                                    class="select2 tail-select  form-control" name="academic_regalia_status" required>
                                    @foreach ($academic_regalia_status as $ars)
                                        <option value="{{ $ars }}">{{ $ars }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-md-12">
                            <div>
                                <button class="btn btn-dark btn-sm mr-3" type="submit">
                                    <i class="fa fa-search"></i> Search
                                </button>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>
        @if (isset($orders))
            <div class="card mt-2 p-4">
                <div class="card-body">
                    <div class="table-responsive">

                        <table id="datatable" class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Invoice Number</th>
                                    <th>Student</th>
                                    <th>Guest Number</th>
                                    <th>Guests</th>
                                    <th>Paid / Free
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $gsn = 0;
                                    $ticket_paid_guest_count = 0;
                                    $ticket_unpaid_guest_count = 0;
                                    $guest_paid_count = 0;
                                    $guest_unpaid_count = 0;
                                    $total_paid_tickets = 0;
                                    $total_free_tickets = 0;
                                @endphp
                                @forelse ($orders as $key => $order)
                                    <tr
                                        class="{{ $order->guest_number != $order->guestLists->count() ? 'bg-light-red' : '' }}">
                                        <td>{{ $key + 1 }}</td>
                                        <td class="{{ $order->guest_number == 0 ? 'bg-orange' : '' }}">
                                            <a href="{{ route('order.show', $order->id) }}">
                                                {{ $order->invoice_number }}<br>
                                                {!! orderStatus($order->order_status) !!}
                                            </a>
                                        </td>
                                        <td>
                                            {{ $order->graduate->student_id ?? 'N/A' }} <br>
                                            {{ $order->graduate->full_name ?? 'N/A' }}
                                        </td>
                                        <td>
                                            @php
                                                if (isOrderComplete($order)) {
                                                    $guest_paid_count += $order->guest_number;
                                                } else {
                                                    $guest_unpaid_count += $order->guest_number;
                                                }
                                            @endphp
                                            {{ $order->guest_number ?? '0' }}<br>
                                            PAID Guest: <span class="badge badge-success">{{ $guest_paid_count }}</span>
                                            <br>
                                            UNPAID Guest: <span class="badge badge-danger">{{ $guest_unpaid_count }}</span>
                                        </td>
                                        <td>
                                            Count: {{ $order->guestLists->count() }} <br>
                                            @foreach ($order->guestLists as $guest)
                                                @php
                                                    $gsn++;
                                                    if (isTrue($guest->paid)) {
                                                        $ticket_paid_guest_count++;
                                                    } else {
                                                        $ticket_unpaid_guest_count++;
                                                    }
                                                @endphp
                                                <div class="mb-5"> 
                                                    {{ $gsn }} - {{ $guest->id }} - {{ $guest->full_name }} -
                                                    {!! yesNo($guest->paid) !!} - {{ $guest->archive }} 
                                                    <br>PAID Count: <span class="badge badge-success">{{ $ticket_paid_guest_count }}</span>
                                                    <br>UNPAID Count: <span class="badge badge-danger">{{ $ticket_unpaid_guest_count }}</span>
                                                </div>
                                            @endforeach
                                        </td>
                                        <td>
                                            @if (isOrderComplete($order))
                                            @php
                                                // $allowed_free_guest = getOrderPackageTicketData($order->graduate, $order->ceremony->graduation->package, 'free_guest_number');
                                                $allowed_free_guest = $order->free_guest_number;
                                                $ordered_ticket = $order->guest_number;
                                                $sub = $ordered_ticket - $allowed_free_guest;
                                                $paid_ticket = $sub > 0 ? $sub: 0;
                                                $total_paid_tickets += $paid_ticket;
                                                $free_ticket = $sub > 0 ? $allowed_free_guest: $ordered_ticket;
                                                $total_free_tickets += $free_ticket;
                                            @endphp
                                            Free Allowed: {{ $allowed_free_guest }}<br>
                                            Ordered: {{ $ordered_ticket }}<br>
                                            Paid: {{ $paid_ticket }}<br>
                                            Free: {{ $free_ticket }}<br>
                                            Total Paid: {{ $total_paid_tickets }}<br>
                                            Total Free: {{ $total_free_tickets }}<br>
                                            @endif
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="5" class="text-center">No orders found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <tr>
                                    <td colspan="3"></td>
                                    <th>Total Guest: {{ $orders->sum('guest_number') }}</th>
                                    <td></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        @endif
    </div>
@endsection