@php
  $directCost = $reportData->where('group_name', 'Direct Cost')->first();
  $revenue = $reportData->where('group_name', 'Revenue')->first();
  $expenses = $reportData->where('group_name', 'Expenses')->first();
  $reportData = collect([$revenue, $directCost, $expenses]);
@endphp

<table cellspacing="0">
  <thead>
    <tr>
      <td>Profit And Loss</td>
    </tr>
    <tr>
      <td>{{ $company }}</td>
    </tr>
    <tr>
      <td>
        From {{ \Carbon\Carbon::parse($date[0])->startOfMonth()->format('j M Y') }} 
        to {{  \Carbon\Carbon::parse($date[1])->startOfMonth()->format('j M Y') }}</td>
    </tr>
    <tr>
      <td></td>
      @foreach($periods as $index => $period)
        <td class="text-xs fw-bold text-end">
          {{ App\Http\Classes\Formatting\CustomDateFormat::displayDate($period[0]) }} - 
          {{ App\Http\Classes\Formatting\CustomDateFormat::displayDate($period[1]) }}
        </td>
      @endforeach
    </tr>
  </thead>
  <tbody>
    @foreach($reportData as $rindex => $data)
      <tr>
        <td :colspan="{{count($periods) + 1}}" class="fw-bolder text-dark" style="font-size: 12px; font-weight:bold;">
          {{ $data->group_name }}
        </td>
      </tr>
      
      @foreach($data->account_types as $typeIndex => $accountType)
        <!-- Temporarily blocked -->
        {{--
          <tr>
            <td :colspan="{{count($periods) + 1}}" class="text-sm fw-bolder text-dark ps-4" style="font-size: 12px;font-weight:bold;">
              {{ $accountType->type_name }}
            </td>
          </tr>
        --}}
        
        @foreach($accountType->accounts as $acctIndex => $account)
          @if(
            $accountType->account_type_balances_period_total && 
            $accountType->account_type_balances_period_total != 0 &&
            $account->account_transactions_period_total && 
            $account->account_transactions_period_total != 0
          )
            <tr>
              <td class="text-sm text-dark ps-5">
                {{ $account->account_name }}
              </td>
              
              @foreach($periods as $index => $period)
                <td class="text-sm text-dark text-end">
                  @php
                    $accountTransactions = collect($account)['account_transactions_' . $index];
                    $accountBalance = collect($accountTransactions)->sum('balance') ?? 0;
                  @endphp

                  {{ App\Http\Classes\Formatting\CustomNumFormat::decimal($accountBalance) }}
                </td>
              @endforeach
            </tr>
          @endif
        @endforeach
        
        <!-- Temporarily blocked -->
        {{--
          <tr>
            <td class="text-sm text-muted fw-bold ps-4" >
              Total {{ $accountType->type_name }}
            </td>
            @foreach($periods as $index => $period)
              <td class="text-sm text-dark text-end fw-bolder">
                @php
                  $typeBalances = 'account_type_balances_' . $index;
                @endphp
                {{ App\Http\Classes\Formatting\CustomNumFormat::decimal($accountType->$typeBalances ?? 0) }}
              </td>
            @endforeach
          </tr>
        --}}
      @endforeach

      <tr>
        <td class="text-dark"
          style="border-top: 1px solid black;
          border-bottom: 1px solid black;
          font-size: 12px;
          font-weight:bold;"
        >Total {{ $data->group_name }}</td>
        @foreach($periods as $index => $period)
          <td class="text-end text-dark"
            style="border-top: 1px solid black;
            border-bottom: 1px solid black;
            font-size: 12px;
            font-weight:bold;"
          >
            {{ App\Http\Classes\Formatting\CustomNumFormat::decimal(
              collect($data->account_types)->sum('account_type_balances_' . $index) ?? 0
            ) }}
          </td>
        @endforeach
      </tr>
      
      @if($data->group_name == 'Direct Cost')
        <tr>
          <td></td>
        </tr>
        <tr>
          <td class="text-dark fs-5 fw-bolder"
            style="font-size: 12px;
            font-weight:bold;
            border-bottom: 2px solid black;"
          >GROSS PROFIT</td>
          @foreach($periods as $index => $period)
            <td class="text-dark fs-5 fw-bolder text-end"
              style="font-size: 12px;
              font-weight:bold;
              border-bottom: 3px solid black;"
            >
                @php
                  $gross = $reportData->whereIn('group_name', ['Direct Cost', 'Revenue'])
                    ->pluck('account_types')
                    ->flatten(1)
                    ->sum('account_type_balances_' . $index);
                @endphp
                {{ App\Http\Classes\Formatting\CustomNumFormat::decimal($gross) }}
            </td>
          @endforeach
        </tr>
      @endif

      <tr>
        <td></td>
      </tr>

      @if($data->group_name == 'Expenses')
        <tr>
          <td class="text-dark fs-5 fw-bolder" 
            style="font-size: 12px;
            font-weight:bold;
            border-bottom: double black;"
          >NET PROFIT</td>
          @foreach($periods as $index => $period)
            <td class="text-dark fs-5 fw-bolder text-end"
              style="font-size: 12px;
              font-weight:bold;
              border-bottom: double black;"
            >
              @php
                $gross = $reportData->whereIn('group_name', ['Direct Cost', 'Revenue'])
                    ->pluck('account_types')
                    ->flatten(1)
                    ->sum('account_type_balances_' . $index);
                $net = $reportData->where('group_name', 'Expenses')
                  ->pluck('account_types')
                  ->flatten(1)
                  ->sum('account_type_balances_' . $index);
              @endphp
              {{ App\Http\Classes\Formatting\CustomNumFormat::decimal($gross + $net) }}
            </td>
          @endforeach
        </tr>
      @endif
    @endforeach
    
    {{--
      <template v-for="(data, rindex) in reportData" :key="rindex">
     
      <template v-for="(accountType, typeIndex) in data.account_types" :key="typeIndex">
        

      </template>
      
      <tr v-if="data.group_name === 'Expenses'">
        <td class="text-dark fs-5 fw-bolder">NET PROFIT</td>
        <template v-for="(period, index) in periods">
          <td class="text-dark fs-5 fw-bolder text-end">
            {{
              formatter.decimal(
                $lodash.sumBy(reportData, (data) => {
                  if (data.group_name !== 'Expenses') {
                    return $lodash.sumBy(data.account_types, `account_type_balances_${index}`)
                  }
                }) + 
                $lodash.sumBy(reportData, (data) => {
                  if (data.group_name === 'Expenses') {
                    return $lodash.sumBy(data.account_types, `account_type_balances_${index}`)
                  }
                })
              )
            }}
          </td>
        </template>
      </tr>
    </template>
      --}}
  </tbody>
</table>