@php
    set_time_limit(0);
@endphp
<table>
    <thead>
        <tr>
            {{-- <th>Payment By Institution</th> --}}
            <th>Invoice Number</th>
            <th>Institute</th>
            <th>Guest Number</th>
            {{-- <th>Guest Invitation Letter</th> --}}
            <th>Total Amount</th>
            <th>Venue</th>
            <th>Ceremony Date</th>
            <th>Ceremony Time</th>
            <th>User Type</th>
            <th>Student Id</th>
            <th>Title</th>
            <th>First Name</th>
            <th>Middle Name</th>
            <th>Last Name</th>
            <th>Mobile</th>
            <th>Email</th>
            <th>Certificate Legal Name</th>
            <th>On Stage Preferred Name</th>
            <th>Phonetically Spelt First Name</th>
            <th>Phonetically Spelt Middle Name</th>
            <th>Phonetically Spelt Last Name</th>
            <th>USI NUmber</th>
            <th>Study Period Completed</th>
            <th>Campus</th>
            <th>Course Code</th>
            <th>Course Name</th>
            @if($orders->count() > 0)
            @if($orders[0]->graduation->package)
            @foreach ($orders[0]->graduation->package->packageProducts as $product)
                <th>{{$product->product_name}}</th>
            @endforeach
            @endif
            @endif
            <th>Order Status</th>
            <th>Archive</th>
            <th>Channel</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($orders as $order)
            <tr>
                {{-- <td>{!! yesNo($order->payment_by_institution) !!}</td> --}}
                <td>{{ $order->invoice_number }}</td>
                <td>{{ $order->institution->name ?? null }}</td>
                <td>{{ $order->guest_number }}</td>
                {{-- <td>{{ $order->guest_invitation_letter }}</td> --}}
                <td>{{ $order->total_amount_formatted }}</td>
                <td>{{ $order->ceremony->venue ?? null }}</td>
                <td>{{ $order->ceremony->date_formatted ?? null }}</td>
                <td>{{ $order->ceremony->time ?? null }}</td>
                <td>{{ $order->graduate->user_type ?? null }}</td>
                <td>{{ $order->graduate->student_id ?? null }}</td>
                <td>{{ $order->graduate->title ?? null }}</td>
                <td>{{ $order->graduate->first_name ?? null }}</td>
                <td>{{ $order->graduate->middle_name ?? null }}</td>
                <td>{{ $order->graduate->last_name ?? null }}</td>
                <td>{{ $order->graduate->mobile ?? null }}</td>
                <td>{{ $order->graduate->email ?? null }}</td>
                <td>{{ $order->graduate->certificate_legal_name ?? null }}</td>
                <td>{{ $order->graduate->on_stage_name ?? null }}</td>
                <td>{{ $order->graduate->phonetically_spelt_first_name ?? null }}</td>
                <td>{{ $order->graduate->phonetically_spelt_middle_name ?? null }}</td>
                <td>{{ $order->graduate->phonetically_spelt_last_name ?? null }}</td>
                <td>{{ $order->graduate->usi_number ?? null }}</td>
                <td>{{ $order->graduate->study_period_completed ?? null }}</td>
                <td>{{ $order->graduate->campus ?? null }}</td>
                <td>{{ $order->graduate->course->course_code ?? null }}</td>
                <td>{{ $order->graduate->course->course_name ?? null }}</td>
                @if($orders->count() > 0)
                @if($orders[0]->graduation->package)
                @foreach ($orders[0]->graduation->package->packageProducts as $product)
                    @php 
                        $op = $order->orderProducts->where('package_product_id', $product->id)->first();
                    @endphp
                    @if ($op)
                        <th>{{ $op->product_size }}</th>
                    @else
                    <th></th>
                    @endif
                @endforeach
                @endif
                @endif
                <td>{{ $order->order_status }}</td>
                <td>{{ $order->archive == config('custom.yes') ? config('custom.yes_text') : config('custom.no_text') }}</td>
                <td>{{ $order->channel }}</td>
            </tr>
        @endforeach
    </tbody>
</table>