@php
    $total_year_rev  = 0;
    $total_year_cost = 0;
    $total_year_gross = 0;
    $total_year_exp = 0;
    $total_year_ebitda = 0;
    $total_year_non_op_exp = 0;
    $total_year_nett_profit = 0;
@endphp
<table style="margin-top: 20px; width: 100%; margin-bottom: 0.5em">
    <thead>
        <tr style="text-align:center">
            <th style="width:20%">Description</th>
            @foreach($periods as $period)
            <th style="text-align: right; white-space: nowrap">{{date('F, Y', strtotime(date('Y-d-m', strtotime('01/' . str_replace('-', '/', $period)))))}}</th>
            @endforeach
            <th>Total Year</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td colspan="14">&nbsp;</td>
        </tr>
        <!-- Summary -->
        <tr>
            <td style="font-weight: bold; font-size:12px">Summary</td>
            <td colspan="13"></td>
        </tr>
            <!-- Revenue -->
            <tr>
                <td style="font-weight: bold; font-size:12px">Revenue</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_revenues) ? number_format($total_revenues[$period], 2) : 0}}</td>
                @endforeach
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_rev, 2)}}</td>
            </tr>
            <!-- Cost -->
            <tr>
                <td style="font-weight: bold; font-size:12px">Cost</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_cost) ? number_format($total_cost[$period], 2) : 0}}</td>
                @endforeach
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_cost, 2)}}</td>
            </tr>
            <!-- Gross -->
            <tr>
                <td style="font-weight: bold; font-size:12px">Gross</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_gross) ? number_format($total_gross[$period], 2) : 0}}</td>
                @endforeach
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_gross, 2)}}</td>
            </tr>
            <!-- Expenses -->
            <tr>
                <td style="font-weight: bold; font-size:12px">Expenses</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_expenses) ? number_format($total_expenses[$period], 2) : 0}}</td>
                @endforeach
                 <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_exp, 2)}}</td>
            </tr>
            <!-- Ebitda -->
            <tr>
                <td style="font-weight: bold; font-size:12px">EBITDA</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $EBITDA) ? number_format($EBITDA[$period], 2) : 0}}</td>
                @endforeach
                 <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_ebitda, 2)}}</td>
            </tr>
            <!-- NonOpertingExp -->
            <tr>
                <td style="font-weight: bold; font-size:12px">Non Operating Exp</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_non_operating_exp) ? number_format($total_non_operating_exp[$period], 2) : 0}}</td>
                @endforeach
                 <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_non_op_exp, 2)}}</td>
            </tr>
            <!-- Nettprofit -->
            <tr>
                <td style="font-weight: bold; font-size:12px">Nett</td>
                @foreach($periods as $period)
                <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_nett_profit) ? number_format($total_nett_profit[$period], 2) : 0}}</td>
                @endforeach
                 <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($total_year_nett_profit, 2)}}</td>
            </tr>
        <!-- Summary -->
        <tr>
            <td colspan="14">&nbsp;</td>
        </tr>

        <tr>
            <td style="font-weight: bold;">Revenue:</td>
            <td style="text-align:right" colspan="13"></td>
        </tr>
    {{-- NEW PENJABARAN HPP --}}
        @if (count($revenue_datas) > 0)
            @foreach ($revenue_datas as $item)
                @php
                    $TCoaYear = 0;
                @endphp
                <tr>
                    <td style="font-size:11px">{{$item['description']}}</td>
                    @foreach($periods as $period)
                    @php
                        $TCoaYear += array_key_exists($period, $item['value']) ? ($item['value'][$period]) : 0;
                    @endphp
                    <td style="font-size: 11px;text-align:right">{{ array_key_exists($period, $item['value']) ? number_format($item['value'][$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 11px;text-align:right"> <!-- Total Year Per COA -->
                        {{number_format($TCoaYear, 2)}}
                    </td>
                </tr>
            @endforeach
        @endif
    {{-- NEW PENJABARAN HPP --}}
        {{-- <tr>
            <td>Room Revenue</td>
            @foreach($periods as $period)
            <td style="text-align:right">{{array_key_exists($period, $room_rev_total) ? number_format($room_rev_total[$period], 2) : ''}}</td>
            @endforeach
        </tr>
        <tr>
            <td>Food F{{'&'}}B</td>
            @foreach($periods as $period)
            <td style="text-align:right">{{array_key_exists($period, $fb_food_total) ? number_format($fb_food_total[$period], 2) : ''}}</td>
            @endforeach
        </tr>
        <tr>
            <td>Beverages F{{'&'}}B</td>
            @foreach($periods as $period)
            <td style="text-align:right">{{array_key_exists($period, $fb_bev_total) ? number_format($fb_bev_total[$period], 2) : ''}}</td>
            @endforeach
        </tr>
        <tr>
            <td>Other F{{'&'}}B</td>
            @foreach($periods as $period)
            <td style="text-align:right">{{array_key_exists($period, $fb_other_total) ? number_format($fb_other_total[$period], 2) : ''}}</td>
            @endforeach
        </tr>
        <tr>
            <td>Other Revenue</td>
            @foreach($periods as $period)
            <td style="text-align:right">{{ array_key_exists($period, $other_rev) ? number_format($other_rev[$period], 2) : ''}}</td>
            @endforeach
        </tr> --}}
        <tr>
            <td style="font-weight: bold;">Total Revenue</td>
            @foreach($periods as $period)
            {{-- <td style="text-align:right;font-weight:bold">{{ array_key_exists($period, $pendapatan_usaha) ? number_format($pendapatan_usaha[$period], 2) : ''}}</td> --}}
            <td style="font-size: 15px;text-align:right;font-weight:bold">{{ array_key_exists($period, $total_revenues) ? number_format($total_revenues[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $total_revenues)) {
                        $total_year_rev += $total_revenues[$period];
                    }
                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_rev, 2)}}</td>
        </tr>
        <tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>
        <tr>
            <td style="font-weight: bold; white-space: nowrap">Cost </td>
            <td style="text-align:right" colspan="13"></td>
        </tr>
    <!-- NEW COST -->
        @if (count($costs_datas) > 0)
            @foreach ($costs_datas as $item)
                @php
                    $TCoaYear_exp = 0;
                @endphp
                <tr>
                    <td style="font-size:11px">{{$item['description']}}</td>
                    @foreach($periods as $period)
                    @php
                        $TCoaYear_exp += array_key_exists($period, $item['value']) ? ($item['value'][$period]) : 0;
                    @endphp
                    <td style="font-size: 11px;text-align:right">{{ array_key_exists($period, $item['value']) ? number_format($item['value'][$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 11px;text-align:right"> <!-- Total Year Per COA -->
                        {{number_format($TCoaYear_exp, 2)}}
                    </td>
                </tr>
            @endforeach
        @endif
        <tr>
            <td style="font-weight: bold; font-size:14px">Total Cost</td>
            @foreach($periods as $period)
            <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_cost) ? number_format($total_cost[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $total_cost)) {
                        $total_year_cost += $total_cost[$period];
                    }
                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_cost, 2)}}</td>
        </tr>
    <!-- NEW COST -->

    <!-- Gross Profit -->
        <tr>
            <td style="font-weight: bold; font-size:14px">Gross Profit</td>
            @foreach($periods as $period)
            <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_gross) ? number_format($total_gross[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $total_gross)) {
                        $total_year_gross += $total_gross[$period];
                    }
                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_gross, 2)}}</td>
        </tr>
    <!-- Gross Profit -->

        {{-- @if (count($cost_expenses) > 0)
            @foreach ($cost_expenses as $item)
                <tr>
                    <td style="white-space: nowrap">{{$item['description']}}</td>
                    @foreach($periods as $period)
                    <td style="text-align:right">{{ array_key_exists($period, $item['total']) ? number_format($item['total'][$period], 2) : ''}}</td>
                    @endforeach
                </tr>
            @endforeach
        @endif --}}

        {{-- <tr>
            <td style="font-weight: bold;">Total Cost {{'&'}} Expenses</td>
            @foreach($periods as $period) --}}
            {{-- <td style="text-align:right; font-weight: bold">{{ array_key_exists($period, $total_exp_cost) ? number_format($total_exp_cost[$period], 2) : ''}}</td> --}}
            {{-- <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_expenses) ? number_format($total_expenses[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $total_expenses)) {
                        $total_year_cost += $total_expenses[$period];
                    }
                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_cost, 2)}}</td>
        </tr> --}}
        <tr>
            <td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
        </tr>
    <!-- NEW EXPENSES -->
        <tr>
            <td style="font-weight: bold; font-size:14px">Expense:</td>
            <td style="font-size: 15px;text-align:right" colspan="13"></td>
        </tr>
        @if (count($expense_datas) > 0)
            @foreach ($expense_datas as $item)
                @php
                    $TCoaYear_exp = 0;
                @endphp
                <tr>
                    <td style="font-size:11px">{{$item['description']}}</td>
                    @foreach($periods as $period)
                    @php
                        $TCoaYear_exp += array_key_exists($period, $item['value']) ? ($item['value'][$period]) : 0;
                    @endphp
                    <td style="font-size: 11px;text-align:right">{{ array_key_exists($period, $item['value']) ? number_format($item['value'][$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 11px;text-align:right"> <!-- Total Year Per COA -->
                        {{number_format($TCoaYear_exp, 2)}}
                    </td>
                </tr>
            @endforeach
        @endif

        <tr>
            <td style="font-weight: bold; font-size:14px">Total Expenses</td>
            @foreach($periods as $period)
            {{-- <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_exp_cost) ? number_format($total_exp_cost[$period], 2) : ''}}</td> --}}
            <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_expenses) ? number_format($total_expenses[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $total_expenses)) {
                        $total_year_exp += $total_expenses[$period];
                    }
                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_exp, 2)}}</td>
        </tr>
    <!-- NEW EXPENSES -->

    <!-- EBITDA -->
        <tr>
            <td style="font-weight: bold; font-size:14px">EBITDA(laba Operasional)</td>
            @foreach($periods as $period)
            <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $EBITDA) ? number_format($EBITDA[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $EBITDA)) {
                        $total_year_ebitda += $EBITDA[$period];
                    }
                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_ebitda, 2)}}</td>
        </tr>
    <!-- EBITDA -->

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

    <!-- Non Operating EXP -->
            <tr>
                <td style="font-weight: bold; font-size:14px">Non Operating Exp:</td>
                <td style="font-size: 15px;text-align:right"></td>
            </tr>
            @if (count($non_op_exps_datas) > 0)
                @foreach ($non_op_exps_datas as $item)
                    @php
                        $TCoaYear_exp = 0;
                    @endphp
                    <tr>
                        <td style="font-size:11px">{{$item['description']}}</td>
                        @foreach($periods as $period)
                        @php
                            $TCoaYear_exp += array_key_exists($period, $item['value']) ? ($item['value'][$period]) : 0;
                        @endphp
                        <td style="font-size: 11px;text-align:right">{{ array_key_exists($period, $item['value']) ? number_format($item['value'][$period], 2) : 0}}</td>
                        @endforeach
                        <td style="font-size: 11px;text-align:right"> <!-- Total Year Per COA -->
                            {{number_format($TCoaYear_exp, 2)}}
                        </td>
                    </tr>
                @endforeach
            @endif

            <tr>
                <td style="font-weight: bold; font-size:14px">Total Non Operating Exp</td>
                @foreach($periods as $period)
                <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_non_operating_exp) ? number_format($total_non_operating_exp[$period], 2) : 0}}</td>
                    @php
                        if (array_key_exists($period, $total_non_operating_exp)) {
                            $total_year_non_op_exp += $total_non_operating_exp[$period];
                        }
                    @endphp
                @endforeach
                <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_non_op_exp, 2)}}</td>
            </tr>
    <!-- Non Operating EXP -->

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

     <!-- Nett Profit -->
        <tr>
            <td style="font-weight: bold; font-size:14px">Nett Profit</td>
            @foreach($periods as $period)
            <td style="font-size: 15px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_nett_profit) ? number_format($total_nett_profit[$period], 2) : 0}}</td>
                @php
                    if (array_key_exists($period, $total_nett_profit)) {
                        $total_year_nett_profit += $total_nett_profit[$period];
                    }

                @endphp
            @endforeach
            <td style="text-align:right;font-weight: bold; font-size:14px">{{number_format($total_year_nett_profit, 2)}}</td>
        </tr>
    <!-- Nett Profit -->

        <tr>
            <td style="font-weight: bold;">Profit{{'/'}}Loss</td>
            @foreach($periods as $period)
            {{-- <td style="text-align:right; font-weight: bold">{{array_key_exists($period, $profit_or_loss) ? number_format($profit_or_loss[$period], 2) : ''}}</td> --}}
            <td style="font-size: 15px;text-align:right; font-weight: bold">{{array_key_exists($period, $profit_or_loss) ? number_format($profit_or_loss[$period], 2) : 0}}</td>
            @endforeach
            @php
                $prof_loss_year = $total_year_rev - $total_year_cost;
            @endphp
            <td style="text-align:right;font-weight: bold; font-size:14px">{{ number_format($prof_loss_year,0) }}</td>
        </tr>

        {{-- <tr>
            <td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
        </tr> --}}


    </tbody>
</table>