@foreach( $captions as $caption )
    @if( !empty($caption) )
        <tr class="caption_tr">
            <td class="text-left" colspan="{{ $colspan }}">{{ $caption }}</td>
        <tr>
    @endif
@endforeach

@php 
    $subTotal = (object) [
        'this_month_cash'    => 0,
        'last_june'          => 0,
        'this_month_noncash' => 0,
        'this_fy_cash'       => 0,
        'this_fy_noncash'    => 0,

        'this_month_cash_migrated'    => 0,
        'this_month_noncash_migrated' => 0,
        'this_fy_cash_migrated'       => 0,
        'this_fy_noncash_migrated'    => 0,
        'last_june_migrated'          => 0,

        'this_month_cash_migrated_own'    => 0,
        'this_month_noncash_migrated_own' => 0,
        'this_fy_cash_migrated_own'       => 0,
        'this_fy_noncash_migrated_own'    => 0,
        'last_june_migrated_own'          => 0,
    ]; 
@endphp

@if( !empty($ac_codes) )

    @foreach( $ac_codes as $ac_code )

        @php 
            
            $hideTrClass = ( empty($indicators[$ac_code]->acc_ledgerId) ) ? true : false;
            $hideTrClass = false;

            $subTotal->this_month_cash      += (float) $indicators[$ac_code]->this_month_cash; 
            $subTotal->last_june            += (float) $indicators[$ac_code]->last_june; 
            $subTotal->this_month_noncash   += (float) $indicators[$ac_code]->this_month_noncash; 
            $subTotal->this_fy_cash         += (float) $indicators[$ac_code]->this_fy_cash; 
            $subTotal->this_fy_noncash      += (float) $indicators[$ac_code]->this_fy_noncash; 

            $subTotal->this_month_cash_migrated     += (float) $indicators[$ac_code]->this_month_cash_migrated; 
            $subTotal->this_month_noncash_migrated  += (float) $indicators[$ac_code]->this_month_noncash_migrated; 
            $subTotal->this_fy_cash_migrated        += (float) $indicators[$ac_code]->this_fy_cash_migrated; 
            $subTotal->this_fy_noncash_migrated     += (float) $indicators[$ac_code]->this_fy_noncash_migrated; 
            $subTotal->last_june_migrated           += (float) $indicators[$ac_code]->last_june_migrated; 

            $subTotal->this_month_cash_migrated_own     += (float) $indicators[$ac_code]->this_month_cash_migrated_own; 
            $subTotal->this_month_noncash_migrated_own  += (float) $indicators[$ac_code]->this_month_noncash_migrated_own; 
            $subTotal->this_fy_cash_migrated_own        += (float) $indicators[$ac_code]->this_fy_cash_migrated_own; 
            $subTotal->this_fy_noncash_migrated_own     += (float) $indicators[$ac_code]->this_fy_noncash_migrated_own; 
            $subTotal->last_june_migrated_own           += (float) $indicators[$ac_code]->last_june_migrated_own; 

            $identifier = implode( '_', explode('.', $ac_code) );

        @endphp

        <tr class="{{ $hideTrClass ? 'hide_class' : ''  }}">            
            <td class="text-left">
                
                <input type="hidden" name="identifiers[]" value="{{$identifier}}" />
                
                {{ $indicators[$ac_code]->acchead }} 
                
                <small style="color: #737373; padding-left: 5px"> ( {{ $ac_code }} ) </small>
                
                <p>
                    
                    <small style="color: #737373"> Acc Ledger Code: {{ $indicators[$ac_code]->acc_ledgerCode }} </small>
                
                </p>
                
            </td>


            @if($accgroup == 'BS')

                <td class="text-right">{{ number_format( $indicators[$ac_code]->last_june , 2) }}</td>
                <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_month_cash, 2) }}</td>
                
                @if($is_migrated)
                    <td class="text-right">{{ number_format( $indicators[$ac_code]->last_june_migrated, 2) }}</td>
                    <td class="text-right border-right">{{ number_format($indicators[$ac_code]->this_month_cash_migrated, 2) }}</td>
                @endif
                
                <td class="text-right">{{ number_format( $indicators[$ac_code]->last_june_migrated_own, 2) }}</td>
                <td class="text-right border-right">{{ number_format($indicators[$ac_code]->this_month_cash_migrated_own, 2) }}</td>
                
            @elseif($accgroup == 'IS')
            
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_cash, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_fy_cash, 2) }}</td>
                
                @if($is_migrated)
                    <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_cash_migrated, 2) }}</td>
                    <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_fy_cash_migrated, 2) }}</td>
                @endif
                
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_cash_migrated_own, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_fy_cash_migrated_own, 2) }}</td>
                
            @elseif($accgroup == 'RP')

                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_cash, 2) }}</td>
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_fy_cash, 2) }}</td>
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_noncash, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_fy_noncash, 2) }}</td>
                
                @if($is_migrated)
                    <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_cash_migrated, 2) }}</td>
                    <td class="text-right">{{ number_format( $indicators[$ac_code]->this_fy_cash_migrated, 2) }}</td>
                    <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_noncash_migrated, 2) }}</td>
                    <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_fy_noncash_migrated, 2) }}</td>
                @endif
                
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_cash_migrated_own, 2) }}</td>
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_fy_cash_migrated_own, 2) }}</td>
                <td class="text-right">{{ number_format( $indicators[$ac_code]->this_month_noncash_migrated_own, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $indicators[$ac_code]->this_fy_noncash_migrated_own, 2) }}</td>
                
            @endif
            
            
            <input 
                name="last_june[]" 
                value="{{ number_format($indicators[$ac_code]->last_june , 2) }}" 
                type="hidden"
            /> 
                        
            <input 
                name="this_month_cash[]" 
                value="{{ number_format($indicators[$ac_code]->this_month_cash , 2) }}" 
                type="hidden"
            /> 
            
            <input 
                name="this_fy_cash[]" 
                value="{{ number_format($indicators[$ac_code]->this_fy_cash , 2) }}" 
                type="hidden"
            /> 
        
            <input 
                name="this_month_noncash[]" 
                value="{{ number_format($indicators[$ac_code]->this_month_noncash , 2) }}" 
                type="hidden"
            /> 
                
            <input 
                name="this_fy_noncash[]" 
                value="{{ number_format($indicators[$ac_code]->this_fy_noncash , 2) }}" 
                type="hidden" 
            /> 
            

        </tr>

    @endforeach

@endif

@if( !empty($captions) )

    <tr class="sub_total_tr">

        <td class="text-left "> Sub total </td>

        @if($accgroup == 'BS')

            <td class="text-right">{{ number_format( $subTotal->last_june, 2) }}</td>
            <td class="text-right border-right">{{ number_format( $subTotal->this_month_cash, 2) }}</td>
            
            @if($is_migrated)
                <td class="text-right">{{ number_format( $subTotal->last_june_migrated, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $subTotal->this_month_cash_migrated, 2) }}</td>
            @endif
            
            <td class="text-right">{{ number_format( $subTotal->last_june_migrated_own, 2) }}</td>
            <td class="text-right border-right">{{ number_format( $subTotal->this_month_cash_migrated_own, 2) }}</td>
            
        @elseif($accgroup == 'IS')
        
            <td class="text-right">{{ number_format( $subTotal->this_month_cash, 2) }}</td>
            <td class="text-right border-right">{{ number_format( $subTotal->this_fy_cash, 2) }}</td>
        
            @if($is_migrated)
                <td class="text-right">{{ number_format( $subTotal->this_month_cash_migrated, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $subTotal->this_fy_cash_migrated, 2) }}</td>
            @endif
            
            <td class="text-right">{{ number_format( $subTotal->this_month_cash_migrated_own, 2) }}</td>
            <td class="text-right border-right">{{ number_format( $subTotal->this_fy_cash_migrated_own, 2) }}</td>

        @elseif($accgroup == 'RP')

            <td class="text-right">{{ number_format( $subTotal->this_month_cash, 2) }}</td>
            <td class="text-right">{{ number_format( $subTotal->this_fy_cash, 2) }}</td>
            <td class="text-right">{{ number_format( $subTotal->this_month_noncash, 2) }}</td>
            <td class="text-right border-right">{{ number_format( $subTotal->this_fy_noncash, 2) }}</td>
            
            @if($is_migrated)
                <td class="text-right">{{ number_format( $subTotal->this_month_cash_migrated, 2) }}</td>
                <td class="text-right">{{ number_format( $subTotal->this_fy_cash_migrated, 2) }}</td>
                <td class="text-right">{{ number_format( $subTotal->this_month_noncash_migrated, 2) }}</td>
                <td class="text-right border-right">{{ number_format( $subTotal->this_fy_noncash_migrated, 2) }}</td>
            @endif
            
            <td class="text-right">{{ number_format( $subTotal->this_month_cash_migrated_own, 2) }}</td>
            <td class="text-right">{{ number_format( $subTotal->this_fy_cash_migrated_own, 2) }}</td>
            <td class="text-right">{{ number_format( $subTotal->this_month_noncash_migrated_own, 2) }}</td>
            <td class="text-right border-right">{{ number_format( $subTotal->this_fy_noncash_migrated_own, 2) }}</td>

        @endif

    </tr> 

@endif