{{-- 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">
    <thead>
        <tr class= "fixed_tr">
            <th scope="col" width="10%">{{__('lang.code')}}</th>
            <th scope="col" width="40%">{{__('lang.name')}}</th>
            <th scope="col">{{__('lang.reference_no')}}</th>
            <th scope="col">{{__('lang.rate')}}</th>
            <th scope="col">{{__('lang.qty')}}</th>
            <th scope="col">{{__('lang.amount')}}</th>
            <th scope="col">{{__('lang.purchase_date')}}</th>
        </tr>
    </thead>
    <tbody>
        @php
            $grand_total_amount = 0;
            $grand_total_qty    = 0;
        @endphp

        @foreach ($heads_data as $type_name => $type_data)
            <tr >
                <th colspan="100%" style="padding-left:30px" class="border_bottom bold">{{ $type_name }}</th>
            </tr>

            @foreach ($type_data as $group_name => $group_data )
                @php
                    $group_total_amount = 0;
                    $group_total_qty    = 0;
                @endphp
                <tr>
                    <td colspan="100%" style="padding-left:60px" class="border_bottom bold">{{ $group_name }}</td>
                </tr>

                @foreach ($group_data  as $sub_group_name => $sub_group_data )
                    @php
                        $sub_group_total_amount = 0;
                        $sub_group_total_qty    = 0;

                        $sub_total_text         = __('lang.sub_total');
                    @endphp
                    <tr>
                        <td colspan="100%" style="padding-left:90px" class="border_bottom bold">{{ $sub_group_name }}</td>
                    </tr>

                    @foreach ($sub_group_data as $head_data )

                        @php
                            $head_data      = (object) $head_data;
                            $head_code      = $head_data->head_code ?? '-';
                            $name           = $head_data->name ?? '-';
                            $rate           = $head_data->rate ?? 0;
                            $qty            = $head_data->qty ?? 0;
                            $amount         = $head_data->amount ?? '-';
                            $purchase_date  = $head_data->purchase_date ?? '-';

                            $sub_group_total_qty     += $qty;
                            $sub_group_total_amount  += $amount;

                            $group_total_qty         += $qty;
                            $group_total_amount      += $amount;

                            $grand_total_qty         += $qty;
                            $grand_total_amount      += $amount;

                        @endphp
                        
                        <tr>
                            <td class="text-right" style="padding-left:120px">{{ $head_code }}</td>
                            <td>{{ $name }}</td>
                            <td>{{ $head_data->references }}</td>
                            <td class="text-right">{{ $transaction->convert_money_format($rate) }}</td>
                            <td class="text-right">{{ $transaction->convert_money_format($qty) }}</td>
                            <td class="text-right">{{ $transaction->convert_money_format($amount) }}</td>
                            <td>{{ $transaction->date_format($purchase_date) }}</td>
                        </tr>
                    @endforeach

                    <tr class="sub_total_summary">
                        <th style="padding-left:90px" class="text-right sub_total"  colspan="4">{{ $sub_total_text }}</th>                            
                        <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_total_qty) }}</th>
                        <th class="text-right sub_total">{{ $transaction->isNegative($sub_group_total_amount) }}</th>
                        <th></th>
                    </tr>
                @endforeach
                <tr class="text-right">
                    <th style="padding-left:90px" colspan="4">{{__('lang.group_total')}}</th>                            
                    <th class="text-right">{{ $transaction->isNegative($group_total_qty) }}</th>
                    <th class="text-right">{{ $transaction->isNegative($group_total_amount) }}</th>
                    <th></th>
                </tr>
            @endforeach
        @endforeach
        <tr class="text-right">
            <th style="padding-left:90px" colspan="4">{{__('lang.total')}}</th>                            
            <th class="text-right">{{ $transaction->isNegative($grand_total_qty) }}</th>
            <th class="text-right">{{ $transaction->isNegative($grand_total_amount) }}</th>
            <th></th>
        </tr>
    </tbody>
</table>