<table id="guestlist">
    <thead>
        <tr>
            <th>No</th>
            <th>Guest Segment</th>

            @if (\Request::get('show_filter') == "mtd")
                <th>#Rm</th>
                <th>(%)</th>
            @endif

            <th>MTD Total Room</th>
            <th>(%)</th>

            @if (\Request::get('show_filter') == "ytd")
                <th>YTD Total Room</th>
                <th>(%)</th>
            @endif

            @if (\Request::get('show_filter') == "mtd")
                <th>Pax</th>
            @endif

            <th>MTD Total Pax</th>

            @if (\Request::get('show_filter') == "ytd")
                <th>YTD Total Pax</th>
            @endif

            @if (\Request::get('show_filter') == "mtd")
                <th>Average-Rate</th>
            @endif

            <th>MTD AvrgRate</th>

            @if (\Request::get('show_filter') == "ytd")
                <th>YTD AvrgRate</th>
            @endif

            @if (\Request::get('show_filter') == "mtd")
                <th>Room Lodging</th>
            @endif

            <th>MTD Lodging</th>

            @if (\Request::get('show_filter') == "ytd")
                <th>YTD Lodging</th>
            @endif
        </tr>
    </thead>

    <tbody>
        @php
            $no = 1;
        @endphp

        {{-- @if (count($guest_segments) > 0) --}}
            @foreach(config('custom.segment_ratecodes') as $key_segmentation => $segmentation)
                @php
                    // Guest Segment
                        // today
                        $guest_segments[$key_segmentation]['room'] = $guest_segments[$key_segmentation]['room'] ?? 0;
                        $guest_segments[$key_segmentation]['pax'] = $guest_segments[$key_segmentation]['pax'] ?? 0;
                        $guest_segments[$key_segmentation]['room_revenue'] = $guest_segments[$key_segmentation]['room_revenue'] ?? 0;
                        $guest_segments[$key_segmentation]['percent'] = 0;
                        $guest_segments[$key_segmentation]['average_rate'] = 0;

                        if ($guest_segments[$key_segmentation]['room'] > 0) {
                            $guest_segments[$key_segmentation]['percent'] = $guest_segments[$key_segmentation]['room'] / $total_rev_room['room'] * 100;
                        }

                        if ($guest_segments[$key_segmentation]['room_revenue'] > 0) {
                            $guest_segments[$key_segmentation]['average_rate'] = $guest_segments[$key_segmentation]['room_revenue'] / $guest_segments[$key_segmentation]['room'];
                        }


                        // MTD
                        $guest_segments[$key_segmentation]['room_mtd'] = $guest_segments[$key_segmentation]['room_mtd'] ?? 0;
                        $guest_segments[$key_segmentation]['pax_mtd'] = $guest_segments[$key_segmentation]['pax_mtd'] ?? 0;
                        $guest_segments[$key_segmentation]['room_revenue_mtd'] = $guest_segments[$key_segmentation]['room_revenue_mtd'] ?? 0;
                        $guest_segments[$key_segmentation]['percent_mtd'] = 0;
                        $guest_segments[$key_segmentation]['average_rate_mtd'] = 0;

                        if ($guest_segments[$key_segmentation]['room_mtd'] > 0) {
                            $guest_segments[$key_segmentation]['percent_mtd'] = $guest_segments[$key_segmentation]['room_mtd'] / $total_rev_room['room_mtd'] * 100;
                        }

                        if ($guest_segments[$key_segmentation]['room_revenue_mtd'] > 0) {
                            $guest_segments[$key_segmentation]['average_rate_mtd'] = $guest_segments[$key_segmentation]['room_revenue_mtd'] / $guest_segments[$key_segmentation]['room_mtd'];
                        }

                        // YTD
                        $guest_segments[$key_segmentation]['room_ytd'] = $guest_segments[$key_segmentation]['room_ytd'] ?? 0;
                        $guest_segments[$key_segmentation]['pax_ytd'] = $guest_segments[$key_segmentation]['pax_ytd'] ?? 0;
                        $guest_segments[$key_segmentation]['room_revenue_ytd'] = $guest_segments[$key_segmentation]['room_revenue_ytd'] ?? 0;
                        $guest_segments[$key_segmentation]['percent_ytd'] = 0;
                        $guest_segments[$key_segmentation]['average_rate_ytd'] = 0;

                        if ($guest_segments[$key_segmentation]['room_ytd'] > 0) {
                            $guest_segments[$key_segmentation]['percent_ytd'] = $guest_segments[$key_segmentation]['room_ytd'] / $total_rev_room['room_ytd'] * 100;
                        }

                        if ($guest_segments[$key_segmentation]['room_revenue_ytd'] > 0) {
                            $guest_segments[$key_segmentation]['average_rate_ytd'] = $guest_segments[$key_segmentation]['room_revenue_ytd'] / $guest_segments[$key_segmentation]['room_ytd'];
                        }
                    // Closed Guest Segment

                    // Total Rev Room
                        // Today
                        if ($total_rev_room['room'] > 0) {
                            $total_rev_room['percent'] = $total_rev_room['room'] / $total_rev_room['room'] * 100;
                        }

                        if ($total_rev_room['room_revenue'] > 0) {
                            $total_rev_room['average_rate'] = $total_rev_room['room_revenue'] / $total_rev_room['room'];
                        }

                        // mtd
                        if ($total_rev_room['room_mtd'] > 0) {
                            $total_rev_room['percent_mtd'] = $total_rev_room['room_mtd'] / $total_rev_room['room_mtd'] * 100;
                        }
                        if ($total_rev_room['room_revenue_mtd'] > 0) {
                            $total_rev_room['average_rate_mtd'] = $total_rev_room['room_revenue_mtd'] / $total_rev_room['room_mtd'];
                        }

                        // ytd
                        if ($total_rev_room['room_ytd'] > 0) {
                            $total_rev_room['percent_ytd'] = $total_rev_room['room_ytd'] / $total_rev_room['room_ytd'] * 100;
                        }
                        if ($total_rev_room['room_revenue_ytd'] > 0) {
                            $total_rev_room['average_rate_ytd'] = $total_rev_room['room_revenue_ytd'] / $total_rev_room['room_ytd'];
                        }
                    // Closed Total Rev Room


                @endphp

                <tr>
                    <td>{{ $no }}</td>
                    {{-- <td>{{ config('custom.segment_ratecodes.'.$key) }}</td> --}}
                    <td>{{ $segmentation }}</td>

                    @if (\Request::get('show_filter') == "mtd")
                        <td>{{ $guest_segments[$key_segmentation]['room'] }}</td>
                        <td>{{ decimalWithDot($guest_segments[$key_segmentation]['percent'], 2) }}</td>
                    @endif

                    <td>{{ $guest_segments[$key_segmentation]['room_mtd'] }}</td>
                    <td>{{ decimalWithDot($guest_segments[$key_segmentation]['percent_mtd'], 2) }}</td>

                    @if (\Request::get('show_filter') == "ytd")
                        <td>{{ $guest_segments[$key_segmentation]['room_ytd'] }}</td>
                        <td>{{ decimalWithDot($guest_segments[$key_segmentation]['percent_ytd'], 2) }}</td>
                    @endif

                    @if (\Request::get('show_filter') == "mtd")
                        <td>{{ $guest_segments[$key_segmentation]['pax'] }}</td>
                    @endif

                    <td>{{ $guest_segments[$key_segmentation]['pax_mtd'] }}</td>

                    @if (\Request::get('show_filter') == "ytd")
                        <td>{{ $guest_segments[$key_segmentation]['pax_ytd'] }}</td>
                    @endif

                    @if (\Request::get('show_filter') == "mtd")
                        <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate']) }}</td>
                    @endif

                    <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate_mtd']) }}</td>

                    @if (\Request::get('show_filter') == "ytd")
                        <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate_ytd']) }}</td>
                    @endif

                    @if (\Request::get('show_filter') == "mtd")
                        <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue']) }}</td>
                    @endif

                    <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue_mtd']) }}</td>

                    @if (\Request::get('show_filter') == "ytd")
                        <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue_ytd']) }}</td>
                    @endif
                </tr>
                @php $no++; @endphp
            @endforeach
        {{-- @else
            <tr>
                <td style="text-align:center" colspan="11">
                    <h4>No Data</h4>
                </td>
            </tr>
        @endif --}}
    </tbody>

    <tfoot>
        @if (count($guest_segments) > 0)
            <tr>
                <td></td>
                <td>Total Rev-Room</td>

                @if (\Request::get('show_filter') == "mtd")
                    <td>{{ $total_rev_room['room'] }}</td>
                    <td>{{ decimalWithDot($total_rev_room['percent'], 2) }}</td>
                @endif

                <td>{{ $total_rev_room['room_mtd'] }}</td>
                <td>{{ decimalWithDot($total_rev_room['percent_mtd'], 2)}}</td>

                @if (\Request::get('show_filter') == "ytd")
                    <td>{{ $total_rev_room['room_ytd'] }}</td>
                    <td>{{ decimalWithDot($total_rev_room['percent_ytd'], 2)}}</td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td>{{ $total_rev_room['pax'] }}</td>
                @endif

                <td>{{ $total_rev_room['pax_mtd']}}</td>

                @if (\Request::get('show_filter') == "ytd")
                    <td>{{ $total_rev_room['pax_ytd']}}</td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate'])}}</td>
                @endif

                <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate_mtd'])}}</td>

                @if (\Request::get('show_filter') == "ytd")
                    <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate_ytd'])}}</td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue'])}}</td>
                @endif

                <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue_mtd'])}}</td>

                @if (\Request::get('show_filter') == "ytd")
                    <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue_ytd'])}}</td>
                @endif
            </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>
            </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>
            </tr> --}}

            <tr>
                <td></td>
                <td>Compliment Rooms</td>

                @if (\Request::get('show_filter') == "mtd")
                    <td></td>
                    <td></td>
                @endif

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

                @if (\Request::get('show_filter') == "ytd")
                    <td></td>
                    <td></td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td></td>
                @endif

                <td></td>

                @if (\Request::get('show_filter') == "ytd")
                    <td></td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td></td>
                @endif

                <td></td>

                @if (\Request::get('show_filter') == "ytd")
                    <td></td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td></td>
                @endif

                <td></td>

                @if (\Request::get('show_filter') == "ytd")
                    <td></td>
                @endif
            </tr>
            <tr>
                <td></td>
                <td>COMP</td>

                @if (\Request::get('show_filter') == "mtd")
                    <td>{{ $total_complimentary['room'] }}</td>
                    <td></td>
                @endif

                <td>{{ $total_complimentary['room_mtd'] }}</td>
                <td></td>

                @if (\Request::get('show_filter') == "ytd")
                    <td>{{ $total_complimentary['room_ytd'] }}</td>
                    <td></td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td>{{ $total_complimentary['pax'] }}</td>
                @endif

                <td>{{ $total_complimentary['pax_mtd'] }}</td>

                @if (\Request::get('show_filter') == "ytd")
                    <td>{{ $total_complimentary['pax_ytd'] }}</td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td></td>
                @endif

                <td></td>

                @if (\Request::get('show_filter') == "ytd")
                    <td></td>
                @endif

                @if (\Request::get('show_filter') == "mtd")
                    <td></td>
                @endif

                <td></td>

                @if (\Request::get('show_filter') == "ytd")
                    <td></td>
                @endif
            </tr>
        @endif
    </tfoot>
</table>
No	Guest Segment	#Rm	(%)	MTD Total Room	(%)	YTD Total Room	(%)	Pax	MTD Total Pax	YTD Total Pax	Average-Rate	MTD AvrgRate	YTD AvrgRate	Room Lodging	MTD Lodging	YTD Lodging
{{ $no }}	{{ config('custom.segment_ratecodes.'.$key) }}	{{ $segmentation }}	{{ $guest_segments[$key_segmentation]['room'] }}	{{ decimalWithDot($guest_segments[$key_segmentation]['percent'], 2) }}	{{ $guest_segments[$key_segmentation]['room_mtd'] }}	{{ decimalWithDot($guest_segments[$key_segmentation]['percent_mtd'], 2) }}	{{ $guest_segments[$key_segmentation]['room_ytd'] }}	{{ decimalWithDot($guest_segments[$key_segmentation]['percent_ytd'], 2) }}	{{ $guest_segments[$key_segmentation]['pax'] }}	{{ $guest_segments[$key_segmentation]['pax_mtd'] }}	{{ $guest_segments[$key_segmentation]['pax_ytd'] }}	{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate']) }}	{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate_mtd']) }}	{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate_ytd']) }}	{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue']) }}	{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue_mtd']) }}	{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue_ytd']) }}
No Data
	Total Rev-Room	{{ $total_rev_room['room'] }}	{{ decimalWithDot($total_rev_room['percent'], 2) }}	{{ $total_rev_room['room_mtd'] }}	{{ decimalWithDot($total_rev_room['percent_mtd'], 2)}}	{{ $total_rev_room['room_ytd'] }}	{{ decimalWithDot($total_rev_room['percent_ytd'], 2)}}	{{ $total_rev_room['pax'] }}	{{ $total_rev_room['pax_mtd']}}	{{ $total_rev_room['pax_ytd']}}	{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate'])}}	{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate_mtd'])}}	{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate_ytd'])}}	{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue'])}}	{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue_mtd'])}}	{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue_ytd'])}}


	Compliment Rooms
	COMP	{{ $total_complimentary['room'] }}		{{ $total_complimentary['room_mtd'] }}		{{ $total_complimentary['room_ytd'] }}		{{ $total_complimentary['pax'] }}	{{ $total_complimentary['pax_mtd'] }}	{{ $total_complimentary['pax_ytd'] }}