@foreach ($ceremonyReportData as $data)
<div class="card mb-3">
    <div class="card-body">
        <h3 style="font-size:1.4em"><u>Ceremony:  <a href="{{ route('ceremony.show', $data['ceremony_id']) }}" target="_blank">{{ $data['ceremony'] }}</a></u></h3>
        <p>Could you please forward your <b>invoice for the amount of ${{ number_format($grandTotal, 2) }} (incl. GST)</b> so we can arrange settlement of the account?</b>
        <p><b>Summary</b> <i>(Collected through the Registration Portal)</i></p>
        <ul>
            <li>Total Student Registrations payment by graduate: <b>{{ $data['order_count_paid_by_graduate'] }} x ${{ number_format($data['package_price'], 2) }} = ${{ number_format($data['order_amount_paid_by_graduate'], 2) }}</b></li>
            <li>Total Student Registrations payment by institution: <b>{{ $data['order_count_paid_by_institution'] }} x ${{ number_format($data['package_price'], 2) }} = ${{ number_format($data['order_amount_paid_by_institution'], 2) }}</b></li>
        </ul>
        <p><b>Breakdown</b></p>
        <ul>
            <li>Graduation Photography portion: <b>{{ $data['order_count'] }} x ${{ number_format($data['gp_portion_amount'], 2) }} = ${{ number_format($data['order_gp_portion_amount'], 2) }}</b></li>
            <li>{{ $institution->name ?? 'N/A'  }} portion: <b>{{ $data['order_count_paid_by_graduate'] }} x ${{ number_format($data['institution_portion_amount'], 2) }} = ${{ number_format($data['order_institution_portion_amount'], 2) }}</b></li>
            <li>Free Guest Tickets: <b>{{ $data['free_tickets_sold'] }} x ${{ number_format(0.00, 2) }} = ${{ number_format(0.00, 2) }}</b></li>
            <li>Paid Guest Tickets: <b>{{ $data['extra_tickets_sold'] }} x ${{ number_format($data['extra_ticket_price'], 2) }} = ${{ number_format($data['extra_ticket_sold_amount'], 2) }}</b></li>
            <li>GP Pid Guest ticket processing fee: <b>{{ $data['extra_tickets_sold'] }} x ${{ number_format($data['extra_ticket_processing_fee'], 2) }} = ${{ number_format($data['extra_ticket_processing_amount'], 2) }}</b></li>
            <li>{{ $institution->name ?? 'N/A'  }} Paid Guest Tickets: <b>{{ $data['extra_tickets_sold'] }} x ${{ number_format($data['institution_extra_ticket_price'], 2) }} = ${{ number_format($data['institution_extra_ticket_portion_amount'], 2) }}</b></li>
            <li>{{ $institution->name ?? 'N/A'  }} Subtotal: <b>${{ number_format($data['subtotal'], 2) }}</b></li>
        </ul>
    </div>
</div>
@endforeach
<p><b>Total Transfer to {{ $institution->name ?? 'N/A' }} (Incl. GST): ${{ number_format($grandTotal, 2) }}</b>