@php
    $hblOrderReferences = collect();

    if (\Illuminate\Support\Facades\Schema::hasTable('hbl_order_ids')) {
        $hblOrderReferencesQuery = \Illuminate\Support\Facades\DB::table('hbl_order_ids');

        if (\Illuminate\Support\Facades\DB::connection()->getDriverName() === 'sqlsrv') {
            $hblOrderReferencesQuery->whereRaw("CHARINDEX(',' + ? + ',', ',' + REPLACE(order_id, ' ', '') + ',') > 0", [(string) $order->getKey()]);
        } else {
            $hblOrderReferencesQuery->whereRaw("FIND_IN_SET(?, REPLACE(order_id, ' ', ''))", [(string) $order->getKey()]);
        }

        $hblOrderReferences = $hblOrderReferencesQuery
                ->whereNotNull('order_reference')
                ->orderByDesc('id')
                ->pluck('order_reference')
                ->filter()
                ->unique()
                ->values();
    }
@endphp

@if ($hblOrderReferences->isNotEmpty())
    <div class="p-3 border-bottom bg-primary-lt">
        <div class="d-flex flex-wrap align-items-center justify-content-between gap-3">
            <div>
                <div class="text-uppercase fw-bold text-primary small mb-1">{{ __('HBL Order ID') }}</div>
                <div class="h2 mb-0 text-primary">
                    {{ $hblOrderReferences->implode(', ') }}
                </div>
            </div>

            <x-core::badge color="primary" class="text-uppercase">
                {{ __('Main Reference') }}
            </x-core::badge>
        </div>
    </div>
@endif