{{-- Excel table title format start --}}
<table>
    <tr>
        <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>
    <tr>
        <td style="text-align: center;" colspan="3">
            {{ __('lang.surcharge_report') }}
        </td>
    </tr>
</table>

{{-- Excel title format end --}}

@php
    $total_surchage_amount = $total_discount_amount = $total_net_amount = $total_paid_amount = 0;
@endphp

<table class="table  table-bordered" style="border-top: 0px !important">
    <thead>
        <tr class="fixed_tr">
            <th scope="col" class = "text-center">{{ __('lang.sno') }}</th>
            <th scope="col">{{ __('lang.project') }}</th>
            <th scope="col">{{ __('lang.registration_no') }}</th>
            <th scope="col">{{ __('lang.customer') }}</th>
            <th scope="col">{{ __('lang.receipt_no') }}</th>
            <th scope="col">{{ __('lang.term') }}</th>
            <th scope="col">{{ __('lang.no_of_days') }}</th>
            <th scope="col" class = "text-right">{{ __('lang.surcharge_amount') }} ({{config('settings.currency_code')}})</th>
            <th scope="col" class = "text-right">{{ __('lang.discount') }} ({{config('settings.currency_code')}})</th>
            <th scope="col" class = "text-right">{{ __('lang.net_amount') }} ({{config('settings.currency_code')}})</th>
            <th scope="col">{{ __('lang.mode_of_payment') }}</th>
            <th scope="col">{{ __('lang.payment_date') }}</th>
            <th scope="col" class = "text-right">{{ __('lang.paid_amount') }} ({{config('settings.currency_code')}})</th>
            <th scope="col" class = "text-center">{{ __('lang.status') }}</th>
        </tr>
    </thead>
    <tbody>
        @foreach ($schedule_surchages as $schedule_surchage)
        @php
                $actual_received    = $schedule_surchage->actual_received;
                $sell               = $schedule_surchage->actual_received->sell;
                $schedule           = $schedule_surchage->schedule_receivable;
                $status             = $schedule_surchage->is_waived ? "Waived" : "";
                $mode_of_payment    = $schedule_surchage->mode_of_payment;
                $payment_date       = $schedule_surchage->payment_date;
                $payment            = $schedule_surchage->payment ?? 0;
                $badge_class        = $status == 'Waived' ? 'badge-warning' : '';

                if ($status == 'Waived' || $payment == 0) {
                    $mode_of_payment    = '-';
                    $payment_date       = '';
                }

                $total_surchage_amount += $schedule_surchage->amount ?? 0;
                $total_discount_amount += $schedule_surchage->discount_amount ?? 0;
                $total_net_amount      += $schedule_surchage->net_amount ?? 0;
                $total_paid_amount     += $payment ;
        @endphp
        <tr>
            <td class="text-center">{{$loop->iteration}}</td>
            <td>{{$actual_received->branch->name}}</td>
            <td>{{$sell->registration_no}}</td>
            <td>{{$sell->customer->name }}</td>
            <td>{{$actual_received->receipt_no}}</td>
            <td>{{$schedule->term}}</td>
            <td>{{$schedule_surchage->days}}</td>
            <td class="text-right">{{$transaction->convert_money_format($schedule_surchage->amount )}}</td>
            <td class="text-right">{{$transaction->convert_money_format($schedule_surchage->discount_amount)}}</td>
            <td class="text-right">{{$transaction->convert_money_format($schedule_surchage->net_amount)}}</td>
            <td>{{$mode_of_payment}}</td>
            <td>{{$transaction->date_format($payment_date) ?? '-'}}</td>
            <td class="text-right">{{$transaction->convert_money_format($payment)}}</td>
            <td><span class="badge {{ $badge_class }}" style="font-size: 10px;">{{ $status }}</span></td>
        </tr>
        @endforeach
        <tr class="font-w-b">
            <th class="text-right" colspan="7">Total</th>
            <th class="text-right">{{$transaction->convert_money_format($total_surchage_amount)}}</th>
            <th class="text-right">{{$transaction->convert_money_format($total_discount_amount)}}</th>
            <th class="text-right">{{$transaction->convert_money_format($total_net_amount)}}</th>
            <th colspan="2"></th>
            <th class="text-right">{{$transaction->convert_money_format($total_paid_amount)}}</th>
            <th></th>
        </tr>
    </tbody>
</table>