{{-- 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>
            <th>{{__('lang.s_no')}}</th>
            <th>{{__('lang.name')}}</th>
            <th>{{__('lang.purchase_date')}}</th>
            <th class="text-right">{{__('lang.amount')}} {{ $transaction->systemSettingCurrency() }}</th>
            <th>{{__('lang.type')}}</th>
        
            @foreach (range(1,$schedule_duration) as $year)
                <th class="text-right"> {{ $year }} Year {{ $transaction->systemSettingCurrency() }}</th>
            @endforeach
        </tr>
    </thead>
    <tbody>

        @php
            $years_total =[];
            $grand_total= 0;
        @endphp
        @foreach ($fixed_assets as $fixed_asset)

            @php
                $type = ucwords($fixed_asset->depreciation_type);
                

                $depreciation_amount = $transaction->convert_money_format($fixed_asset->depreciation_amount);

                $depreciate_text ="Fixed : $depreciation_amount ".$transaction->systemSettingCurrency();


                if($fixed_asset->is_depreciation_fixed == 0){
                    $depreciate_text ="Percent : $fixed_asset->depreciation_percentage%";
                }

                $grand_total += $fixed_asset->amount;

            @endphp
        <tr>
            <td>{{ $loop->iteration }}</td>
            <td> <a href="{{ route('fixed-assets-register.edit',['id'=> $fixed_asset->id]) }}" target="_blank"> {{ $fixed_asset->name }}</a> </td>
            <td>{{ $transaction->date_format($fixed_asset->purchase_date) }}</td>
            <td class="text-right">{{ $transaction->convert_money_format($fixed_asset->amount) }} </td>
            <td>{{ $type }} <br> {{ $depreciate_text }}</td>

            @php
                $current_amount =  $fixed_asset->amount;
            @endphp

            @foreach (range(1,$schedule_duration) as $year)

                @php


                    if($fixed_asset->depreciation_type == 'depreciate'){
                        $current_amount -= $fixed_asset->depreciation_amount;
                    }
                    elseif($fixed_asset->depreciation_type == 'appreciate'){
                        $current_amount += $fixed_asset->depreciation_amount;
                    }

                    if($current_amount < 0){
                        $current_amount =0;
                    }


                    

                    $years_total[$year] += $current_amount;  

                @endphp

                <td class="text-right">
                    {{ $transaction->convert_money_format($current_amount) }}
                </td>
                
            @endforeach
        </tr>
        @endforeach
    </tbody>
    <tfoot>
        <tr>
            <th class="text-center" colspan="3">Total</th>
            <th class="text-right"> {{ $transaction->convert_money_format($grand_total) }}</th>
            <th></th>

            @foreach ($years_total as $year_total)
                <th class="text-right">{{ $transaction->convert_money_format($year_total) }}</th>
            @endforeach
        </tr>
    </tfoot>

    
   
</table>