@php
    $this_total_rev  = 0;
    $this_total_occ = 0;
    $this_total_guest = 0;
    $this_total_arr = 0;
    $this_total_revpar = 0;
    $this_total_room_ava = 0;
    $this_total_room_occupancy = 0;
@endphp

@php
switch ($type_detail) {
    case 'roomnumber':

    $this_total_array  = [];

    foreach ($periods as $key => $period) {
        foreach ($rooms as $k=>$room) {
            if (isset($this_total_array[$room->no_kamar])) {
                $this_total_array[$room->no_kamar]['this_total_rev']         += (array_key_exists($room->no_kamar, $revenue) ? (array_key_exists($period, $revenue[$room->no_kamar]) ? ($revenue[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_occ']         += (array_key_exists($room->no_kamar, $room_occ) ? (array_key_exists($period, $room_occ[$room->no_kamar]) ? ($room_occ[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_guest']       += (array_key_exists($room->no_kamar, $guest) ? (array_key_exists($period, $guest[$room->no_kamar]) ? ($guest[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_arr']         += (array_key_exists($room->no_kamar, $arr) ? (array_key_exists($period, $arr[$room->no_kamar]) ? ($arr[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_revpar']      += (array_key_exists($room->no_kamar, $total_room_ava) ? (array_key_exists($period, $total_room_ava[$room->no_kamar]) ? ($total_room_ava[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_room_ava']    += (array_key_exists($room->no_kamar, $room_occupancy) ? (array_key_exists($period, $room_occupancy[$room->no_kamar]) ? ($room_occupancy[$room->no_kamar][$period]) : 0) : 0);
            }else{
                $this_total_array[$room->no_kamar]['this_total_rev']         = (array_key_exists($room->no_kamar, $revenue) ? (array_key_exists($period, $revenue[$room->no_kamar]) ? ($revenue[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_occ']         = (array_key_exists($room->no_kamar, $room_occ) ? (array_key_exists($period, $room_occ[$room->no_kamar]) ? ($room_occ[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_guest']       = (array_key_exists($room->no_kamar, $guest) ? (array_key_exists($period, $guest[$room->no_kamar]) ? ($guest[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_arr']         = (array_key_exists($room->no_kamar, $arr) ? (array_key_exists($period, $arr[$room->no_kamar]) ? ($arr[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_revpar']      = (array_key_exists($room->no_kamar, $total_room_ava) ? (array_key_exists($period, $total_room_ava[$room->no_kamar]) ? ($total_room_ava[$room->no_kamar][$period]) : 0) : 0);
                $this_total_array[$room->no_kamar]['this_total_room_ava']    = (array_key_exists($room->no_kamar, $room_occupancy) ? (array_key_exists($period, $room_occupancy[$room->no_kamar]) ? ($room_occupancy[$room->no_kamar][$period]) : 0) : 0);
            }
        }
    }

    foreach ($periods as $key => $period) {
        foreach ($rooms as $k=>$room) {
            if (isset($this_total_array[$room->no_kamar])) {
                $this_total_array[$room->no_kamar]['this_total_room_occupancy'] = (@$this_total_array[$room->no_kamar]['this_total_room_ava'] > 0) ?  ((@$this_total_array[$room->no_kamar]['this_total_occ']/$this_total_array[$room->no_kamar]['this_total_room_ava'])*100) : 0;
            }
        }
    }

        // $this_total_array['this_total_room_occupancy'] = (@$this_total_room_ava > 0) ?  ((@$this_total_occ/$this_total_room_ava)*100) : 0;

        break;

    case 'roomtype':

    $this_total_array  = [];

    foreach ($periods as $key => $period) {
        foreach ($roomtypes as $k=>$roomtype) {
            if (isset($this_total_array[$roomtype->id])) {
                $this_total_array[$roomtype->id]['this_total_rev']         += (array_key_exists($roomtype->id, $revenue) ? (array_key_exists($period, $revenue[$roomtype->id]) ? ($revenue[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_occ']         += (array_key_exists($roomtype->id, $room_occ) ? (array_key_exists($period, $room_occ[$roomtype->id]) ? ($room_occ[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_guest']       += (array_key_exists($roomtype->id, $guest) ? (array_key_exists($period, $guest[$roomtype->id]) ? ($guest[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_arr']         += (array_key_exists($roomtype->id, $arr) ? (array_key_exists($period, $arr[$roomtype->id]) ? ($arr[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_revpar']      += (array_key_exists($roomtype->id, $total_room_ava) ? (array_key_exists($period, $total_room_ava[$roomtype->id]) ? ($total_room_ava[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_room_ava']    += (array_key_exists($roomtype->id, $room_occupancy) ? (array_key_exists($period, $room_occupancy[$roomtype->id]) ? ($room_occupancy[$roomtype->id][$period]) : 0) : 0);
            }else{
                $this_total_array[$roomtype->id]['this_total_rev']         = (array_key_exists($roomtype->id, $revenue) ? (array_key_exists($period, $revenue[$roomtype->id]) ? ($revenue[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_occ']         = (array_key_exists($roomtype->id, $room_occ) ? (array_key_exists($period, $room_occ[$roomtype->id]) ? ($room_occ[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_guest']       = (array_key_exists($roomtype->id, $guest) ? (array_key_exists($period, $guest[$roomtype->id]) ? ($guest[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_arr']         = (array_key_exists($roomtype->id, $arr) ? (array_key_exists($period, $arr[$roomtype->id]) ? ($arr[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_revpar']      = (array_key_exists($roomtype->id, $total_room_ava) ? (array_key_exists($period, $total_room_ava[$roomtype->id]) ? ($total_room_ava[$roomtype->id][$period]) : 0) : 0);
                $this_total_array[$roomtype->id]['this_total_room_ava']    = (array_key_exists($roomtype->id, $room_occupancy) ? (array_key_exists($period, $room_occupancy[$roomtype->id]) ? ($room_occupancy[$roomtype->id][$period]) : 0) : 0);
            }
        }
    }

    foreach ($periods as $key => $period) {
        foreach ($roomtypes as $k=>$roomtype) {
            if (isset($this_total_array[$roomtype->id])) {
                $this_total_array[$roomtype->id]['this_total_room_occupancy'] = (@$this_total_array[$roomtype->id]['this_total_room_ava'] > 0) ?  ((@$this_total_array[$roomtype->id]['this_total_occ']/$this_total_array[$roomtype->id]['this_total_room_ava'])*100) : 0;
            }
        }
    }

    // $this_total_array['this_total_room_occupancy'] = (@$this_total_room_ava > 0) ?  ((@$this_total_occ/$this_total_room_ava)*100) : 0;

        break;

    default:

    $this_total_rev  = 0;
    $this_total_occ = 0;
    $this_total_guest = 0;
    $this_total_arr = 0;
    $this_total_revpar = 0;
    $this_total_room_ava = 0;
    $this_total_room_occupancy = 0;

    foreach ($periods as $key => $period) {
        $this_total_rev         += (array_key_exists($period, $revenue) ? ($revenue[$period]) : 0);
        $this_total_occ         += (array_key_exists($period, $room_occ) ? ($room_occ[$period]) : 0);
        $this_total_guest       += (array_key_exists($period, $guest) ? ($guest[$period]) : 0);
        // $this_total_arr         += (array_key_exists($period, $arr) ? ($arr[$period]) : 0);
        // $this_total_revpar      += (array_key_exists($period, $revpar) ? ($revpar[$period]) : 0);
        $this_total_room_ava    += (array_key_exists($period, $total_room_ava) ? ($total_room_ava[$period]) : 0);
    }
    $this_total_room_occupancy = (@$this_total_room_ava > 0) ?  ((@$this_total_occ/$this_total_room_ava)*100) : 0;
    $this_total_revpar         = (@$this_total_room_ava > 0) ?  ((@$this_total_rev/$this_total_room_ava)) : 0;
    $this_total_arr            = (@$this_total_guest > 0) ?  ((@$this_total_rev/$this_total_guest)) : 0;
    break;
}
@endphp

@if ($this_page == 'quickreport')
<table class="maintable" style="margin-top: 20px; width: 100%; margin-bottom: 0.5em">
    <thead>
        <tr style="text-align:center;background-color:#3eadd9;">
            @if ($type_detail == 'roomtype')
            <th style="width:7%">RoomType</th>
            @elseif ($type_detail == 'roomnumber')
            <th style="width:7%">Room Number</th>
            @else
            <th style="width:7%">Summary</th>
            @endif
            @foreach($periods as $key=>$period)
                @if ($type_period == 1)
                    <th style="text-align: right; white-space: nowrap;">{{date('d-m-Y',strtotime($period))}}</th>
                @else
                    {{-- <th style="text-align: right; white-space: nowrap;">{{date('F, Y', strtotime(date('Y-d-m', strtotime('01/' . str_replace('-', '/', $period)))))}}</th> --}}
                    <th style="text-align: right; white-space: nowrap;"><small>{{date('F, Y', strtotime(date('Y-d-m', strtotime('01/' . str_replace('-', '/', $period)))))}}</small></th>
                @endif
            @endforeach
            <th>Total Period</th>
        </tr>
    </thead>
    <tbody>

        {{-- <tr>
            <td colspan="14">&nbsp;</td>
        </tr> --}}

        @switch($type_detail)
            @case('roomtype')

                <!-- Revenue -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px;" colspan="14">Revenue </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} {{$key == 0}}</td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $revenue) ? (array_key_exists($period, $revenue[$roomtype->id]) ? number_format($revenue[$roomtype->id][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_rev'], 2)}}</td>
                    </tr>
                @endforeach

                <!-- Occupancy(%) -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Occupancy(%) </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $room_occupancy) ? (array_key_exists($period, $room_occupancy[$roomtype->id]) ? number_format($room_occupancy[$roomtype->id][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_room_occupancy'], 2)}}</td>
                    </tr>
                @endforeach

                <!-- Room Occupied -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Room Occupied </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $room_occ) ? (array_key_exists($period, $room_occ[$roomtype->id]) ? number_format($room_occ[$roomtype->id][$period]) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_occ'])}}</td>
                    </tr>
                @endforeach

                <!-- Room Available -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Room Available </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $total_room_ava) ? (array_key_exists($period, $total_room_ava[$roomtype->id]) ? number_format($total_room_ava[$roomtype->id][$period]) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_room_ava'])}}</td>
                    </tr>
                @endforeach

                <!-- Guest in house -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Guest in house </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $guest) ? (array_key_exists($period, $guest[$roomtype->id]) ? number_format($guest[$roomtype->id][$period]) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_guest'])}}</td>
                    </tr>
                @endforeach

                <!-- Average Room Rate -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Average Room Rate </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $arr) ? (array_key_exists($period, $arr[$roomtype->id]) ? number_format($arr[$roomtype->id][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_arr'], 2)}}</td>
                    </tr>
                @endforeach

                <!-- RevPAR -->
                @foreach ($roomtypes as $key=>$roomtype)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">RevPAR </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$roomtype->nama}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($roomtype->id, $arr) ? (array_key_exists($period, $arr[$roomtype->id]) ? number_format($arr[$roomtype->id][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$roomtype->id]['this_total_revpar'], 2)}}</td>
                    </tr>
                @endforeach

                @break
            @case('roomnumber')
                <!-- Revenue -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Revenue </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}}</td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $revenue) ? (array_key_exists($period, $revenue[$room->no_kamar]) ? number_format($revenue[$room->no_kamar][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_rev'], 2)}}</td>
                    </tr>
                @endforeach

                <!-- Occupancy(%) -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Occupancy(%) </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $room_occupancy) ? (array_key_exists($period, $room_occupancy[$room->no_kamar]) ? number_format($room_occupancy[$room->no_kamar][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_room_occupancy'], 2)}}</td>
                    </tr>
                @endforeach

                <!-- Room Occupied -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Room Occupied </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $room_occ) ? (array_key_exists($period, $room_occ[$room->no_kamar]) ? number_format($room_occ[$room->no_kamar][$period]) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_occ'])}}</td>
                    </tr>
                @endforeach

                <!-- Room Available -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Room Available </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $total_room_ava) ? (array_key_exists($period, $total_room_ava[$room->no_kamar]) ? number_format($total_room_ava[$room->no_kamar][$period]) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_room_ava'])}}</td>
                    </tr>
                @endforeach

                <!-- Guest in house -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Guest in house </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $guest) ? (array_key_exists($period, $guest[$room->no_kamar]) ? number_format($guest[$room->no_kamar][$period]) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_guest'])}}</td>
                    </tr>
                @endforeach

                <!-- Average Room Rate -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">Average Room Rate </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $arr) ? (array_key_exists($period, $arr[$room->no_kamar]) ? number_format($arr[$room->no_kamar][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_arr'], 2)}}</td>
                    </tr>
                @endforeach

                <!-- RevPAR -->
                @foreach ($rooms as $key=>$room)
                    @if ($key === 0)
                        <tr>
                            <td style="font-weight: bold; font-size:12px" colspan="14">RevPAR </td>
                        </tr>
                    @endif
                    <tr>
                        <td style="font-size:12px">{{$room->no_kamar}} </td>
                        @foreach($periods as $period)
                        <td style="font-size: 12px; text-align:right;">{{ array_key_exists($room->no_kamar, $arr) ? (array_key_exists($period, $arr[$room->no_kamar]) ? number_format($arr[$room->no_kamar][$period], 2) : 0) : 0}}</td>
                        @endforeach
                        <td style="font-size: 12px; text-align:right;">{{number_format($this_total_array[$room->no_kamar]['this_total_revpar'], 2)}}</td>
                    </tr>
                @endforeach

                @break
            @default
                <!-- 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, $revenue) ? number_format($revenue[$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_rev, 2)}}</td>
                </tr>
                <!-- Occupancy -->
                <tr>
                    <td style="font-weight: bold; font-size:12px">Occupancy(%)</td>
                    @foreach($periods as $period)
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $room_occupancy) ? number_format($room_occupancy[$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_room_occupancy, 2)}}%</td>
                </tr>
                <!-- Room Occupied -->
                <tr>
                    <td style="font-weight: bold; font-size:12px">Room Occupied</td>
                    @foreach($periods as $period)
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $room_occ) ? number_format($room_occ[$period]) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_occ)}}</td>
                </tr>
                <!-- Room Available -->
                <tr>
                    <td style="font-weight: bold; font-size:12px">Room Available</td>
                    @foreach($periods as $period)
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_room_ava) ? number_format($total_room_ava[$period]) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_room_ava)}}</td>
                </tr>
                <!-- Guest in house -->
                <tr>
                    <td style="font-weight: bold; font-size:12px">Guest in house</td>
                    @foreach($periods as $period)
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $guest) ? number_format($guest[$period]) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_guest)}}</td>
                </tr>
                <!-- Average room rates -->
                <tr>
                    <td style="font-weight: bold; font-size:12px">Average room rates</td>
                    @foreach($periods as $period)
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $arr) ? number_format($arr[$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_arr, 2)}}</td>
                </tr>
                <!-- RevPAR -->
                <tr>
                    <td style="font-weight: bold; font-size:12px">RevPAR</td>
                    @foreach($periods as $period)
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{ array_key_exists($period, $total_room_ava) ? number_format($revpar[$period], 2) : 0}}</td>
                    @endforeach
                    <td style="font-size: 12px; text-align:right; font-weight: bold">{{number_format($this_total_revpar, 2)}}</td>
                </tr>

        @endswitch

    </tbody>
</table>
@endif

@if ($this_page == 'quickota')
<table class="maintable" style="margin-top: 20px; width: 100%; margin-bottom: 0.5em">
    <thead>
        <tr style="text-align:center">
            <th {{--rowspan="2"--}} style="width:20%">OTA</th>
            @foreach($periods as $key=>$period)
            @if ($type_period == 1)
                <th style="text-align: right; white-space: nowrap;">{{date('d-m-Y',strtotime($period))}}</th>
            @else
                {{-- <th style="text-align: right; white-space: nowrap;">{{date('F, Y', strtotime(date('Y-d-m', strtotime('01/' . str_replace('-', '/', $period)))))}}</th> --}}
                {{-- <th style="text-align: right; white-space: nowrap;"><small>{{date('F, Y', strtotime(date('Y-d-m', strtotime('01/' . str_replace('-', '/', $period)))))}}</small></th> --}}
                <th style="text-align: center; white-space: nowrap;" {{--colspan="2"--}}>{{date('F, Y', strtotime(date('Y-d-m', strtotime('01/' . str_replace('-', '/', $period)))))}}</th>
            @endif
            @endforeach
            <th style="text-align: center; white-space: nowrap;" {{--colspan="2"--}}>Total Period</th>
        </tr>
        {{-- <tr>
            @foreach($periods as $key=>$period)
            <th style="text-align: center; white-space: nowrap;">NETT</th>
            <th style="text-align: center; white-space: nowrap;">GROSS</th>
            @endforeach
            <th style="text-align: center; white-space: nowrap;">TOTAL NETT</th>
            <th style="text-align: center; white-space: nowrap;">TOTAL GROSS</th>
        </tr> --}}
    </thead>

    @foreach ($otas as $key=>$ota)
        <tr>
            <td style="font-size:12px">{{$ota->name}} </td>
            @foreach($periods as $period)
            <td style="font-size: 12px; text-align:right;">{{ array_key_exists($ota->id, $data_ota) ? (array_key_exists($period, $data_ota[$ota->id]['per_period_nett']) ? number_format($data_ota[$ota->id]['per_period_nett'][$period], 2) : 0) : 0}}</td>
            {{-- <td style="font-size: 12px; text-align:right;">{{ array_key_exists($ota->id, $data_ota) ? (array_key_exists($period, $data_ota[$ota->id]['per_period_gross']) ? number_format($data_ota[$ota->id]['per_period_gross'][$period], 2) : 0) : 0}}</td> --}}
            @endforeach
            <td style="font-size: 12px; text-align:right;">{{ array_key_exists($ota->id, $data_ota) ? (array_key_exists($ota->id, $data_ota) ? number_format($data_ota[$ota->id]['total_nett'], 2) : '0') : '0'}}</td>
            {{-- <td style="font-size: 12px; text-align:right;">{{ array_key_exists($ota->id, $data_ota) ? (array_key_exists($ota->id, $data_ota) ? number_format($data_ota[$ota->id]['total_gross'], 2) : '0') : '0'}}</td> --}}
        </tr>
    @endforeach

</table>
@endif