@php
    set_time_limit(0);
@endphp
<table>
    <thead>
        <tr>
            <th>Invoice Number</th>
            <th>Institute</th>
            <th>Guest Number</th>
            <th>Paid Amount</th>
            <th>Refund Amount</th>
            <th>Net Paid Amount</th>
            <th>Venue</th>
            <th>Ceremony Date</th>
            <th>Ceremony Time</th>
            <th>Student Id</th>
            <th>First Name</th>
            <th>Middle Name</th>
            <th>Last Name</th>
            <th>Mobile</th>
            <th>Email</th>
            <th>Campus</th>
            <th>Course Name</th>
            <th>Order Status</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($orders as $order)
            <tr>
                <td>{{ $order->invoice_number }}</td>
                <td>{{ $order->institution->name ?? null }}</td>
                <td>{{ $order->guest_number }}</td>
                <td>{{ number_format($order->paid_amount, 2) }}</td>
                <td>{{ number_format($order->refund_amount, 2) }}</td>
                <td>{{ number_format($order->net_paid_amount, 2) }}</td>
                <td>{{ $order->ceremony->venue ?? null }}</td>
                <td>{{ $order->ceremony->date_formatted ?? null }}</td>
                <td>{{ $order->ceremony->time ?? null }}</td>
                <td>{{ $order->graduate->student_id ?? null }}</td>
                <td>{{ $order->graduate->title ?? 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->campus ?? null }}</td>
                <td>{{ $order->graduate->course->course_name ?? null }}</td>
                <td>{{ $order->order_status }}</td>
            </tr>
        @endforeach
    </tbody>
    <tfoot>
        <tr>
            <th colspan="2" align="right"><b>Total</b></th>
            <th><b>{{ $orders->sum('guest_number') }}</b></th>
            <th><b>{{ number_format($orders->sum('paid_amount'), 2) }}</b></th>
            <th><b>{{ number_format($orders->sum('refund_amount'), 2) }}</b></th>
            <th><b>{{ number_format($orders->sum('net_paid_amount'), 2) }}</b></th>
            <th colspan="12"></th>
        </tr>
    </tfoot>
</table>