{{-- Excel table title format start --}}
<table>
    <tr>
        
        <th></th>
        <td colspan="1"  style="font-size: 20px!important;text-align: center;">
            {{ config('settings.company_name') }}
        </td>
    </tr>
    <tr>
        
        <td style="text-align: center;" colspan="3">
            {{ config('settings.address_1') }}
        </td>
    </tr>

</table>

<table>

    <tr>
        
        <th>{{ $extra['branch'] ? $extra['branch']->name : 'All Projects' }}</th>
        <td colspan="1" style="font-size: 20px!important;text-align: center;">
            {{ $heading }}
        </td>
        <td>
            @if ($search_by['from'] && $search_by['to'])
                <b>{{__('lang.from')}}:</b> {{ $transaction->date_format($search_by['from']) }}
                <b>{{__('lang.to')}}:</b> {{ $transaction->date_format($search_by['to']) }}
            @else
                <b>{{ 'Upto ' . $transaction->date_format(now()) }} </b>
            @endif
        </td>
    </tr>
</table>
{{-- Excel title format end --}}

<table class="table  table-bordered" style="border-top: 0px !important">
    <thead>
        <tr class= "fixed_tr">
            <th class = "text-center">{{__('lang.sno')}}</th>
            <th>{{__('lang.registration_no')}}</th>
            <th >{{__('lang.customer_name')}}</th>
            <th>{{__('lang.father_or_husband_name')}}</th>
            <th>{{__('lang.nic')}}</th>
            <th>{{__('lang.phone')}}</th>
            <th>{{__('lang.address')}}</th>
            <th>{{__('lang.city')}}</th>
            <th>{{__('lang.gender')}}</th>
            <th>{{__('lang.nominee_name')}}</th>
            <th>{{__('lang.nominee_father_name')}}</th>
            <th>{{__('lang.nominee_nic')}}</th>
            <th>{{__('lang.nominee_phone')}}</th>
            <th>{{__('lang.nominee_address')}}</th>
            <th>{{__('lang.nominee_relation')}}</th>
        </tr>
    </thead>
    <tbody>

        @foreach ($sells as $sell)
            @php
                $schedule_route = route('schedule_manage'    ,['sell_id'   => $sell->id]);
                $nominees_name  = $nominees_f_name  = $nominees_nic = $nominees_phone = $nominees_address = $nominees_relation  = "-" ;
                
                if(count($sell->nominees) > 0){
                    $nominees_name      = $sell->nominees->implode('name',', <br>');
                    $nominees_f_name    = $sell->nominees->implode('so_do_wo',', <br>');
                    $nominees_nic       = $sell->nominees->implode('nic',', <br>');
                    $nominees_phone     = $sell->nominees->implode('phone',', <br>');
                    $nominees_address   = $sell->nominees->implode('address',', <br>');
                    $nominees_relation  = $sell->nominees->implode('relation',', <br>');
                    $nominees_address   = str_replace('&', 'and', $nominees_address);
                }
            @endphp
            <tr>
                <td>{{ $loop->iteration }}</td>
                <td><a href="{{$schedule_route}}" target="_blank">{{ $sell->registration_no }}</a></td>
                <td>{{ $sell->customer->name ?? '-' }}</td>
                <td>{{ $sell->customer->father_or_husband_name ?? '-' }}</td>
                <td>{{ $sell->customer->nid ?? '-'}}</td>
                <td>{{ $sell->customer->phone ?? '-'}}</td>
                <td>{{ $sell->customer->mailing_address ?? '-'}}</td>
                <td>{{ $sell->customer->city->name ?? '-'}}</td>
                <td>{{ $sell->customer->gender ?? '-'}}</td>
                <td>{!! $nominees_name !!}</td>
                <td>{!! $nominees_f_name !!}</td>
                <td>{!! $nominees_nic !!}</td>
                <td>{!! $nominees_phone !!}</td>
                <td>{!! $nominees_address !!}</td>
                <td>{!! $nominees_relation !!}</td>
            </tr>
        @endforeach
    </tbody>
</table>