{{-- 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') }}</th>
            <th>{{ __('lang.dealer') }}</th>
            <th>{{ __('lang.receipt_no') }}</th>
            <th>{{ __('lang.term') }}</th>
            <th>{{ __('lang.receipt_date') }}</th>
            <th>{{ __('lang.mode_of_payment') }}</th>
            <th class="text-right">{{ __('lang.receipt_amount') }} ({{config('settings.currency_code')}})</th>
            <th class="text-right">{{ __('lang.rebate_amounts') }} ({{config('settings.currency_code')}})</th>
            <th class="text-center" >{{ __('lang.status') }}</th>
        </tr>
    </thead>
    <tbody>

        @php
            $total_actual_amount = 0;
            $total_rebate_amount = 0;
        @endphp

        @foreach ($receipt_rebates as $receipt_rebate)
            @php
                $total_actual_amount += $receipt_rebate->actual_amount;
                $total_rebate_amount += $receipt_rebate->rebate_amount;                        
            @endphp
            <tr>
                <td class="text-center">{{ $loop->iteration }}</td>

                <td>{{ $receipt_rebate->registration_no }}</td>
                <td>{{ $receipt_rebate->customer_name }}</td>
                <td>{{ $receipt_rebate->dealer_name }}</td>
                <td>{{ $receipt_rebate->receipt_no }}</td>
                <td>{{ $receipt_rebate->terms }}</td>
                <td>{{ $transaction->date_format($receipt_rebate->date_of_collection_new) }}</td>
                <td>{{ $receipt_rebate->made_of_payment }}</td>
                <td class="text-right">{{ $transaction->convert_money_format($receipt_rebate->actual_amount) }}</td>
                <td class="text-right">{{ $transaction->convert_money_format($receipt_rebate->rebate_amount) }}</td>
                <td class="text-center">{{ $receipt_rebate->payment_status}}</td>
            </tr>
        @endforeach

        <tr>
            <th colspan="8" class="text-right">Total</th>
            <th class="text-right">{{ $transaction->convert_money_format($total_actual_amount) }}</th>
            <th class="text-right">{{ $transaction->convert_money_format($total_rebate_amount) }}</th>
            <th></th>
        </tr>


    </tbody>
</table>