@extends(\Auth::user()->role != 10 ? 'layout' : 'layoutfrontdesk')

@section('title', 'Room Statistic By Guest Segment View')

@section('css')
<style type="text/css">
	.datatable-column-width{
		overflow: hidden; text-overflow: ellipsis; max-width: 200px;
	}

    .tebal {
        font-weight:bold;
        font-size:12px;
        background-color: #f2f2f2;
        border-top:1px solid black !important;
        border-bottom:1px solid black !important;
    }
</style>
@endsection

@section('content')

	<!-- Page header -->
	<div class="page-header page-header-light">
		<div class="page-header-content header-elements-md-inline">
			<div class="page-title d-flex">
				<h4>  <span class="font-weight-semibold">View</span> - Data Room Statistic By Guest Segments</h4>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>

            <div class="print" class="float-right">
                <a href="{{url('reporting/room-statistic-by-guest-segment/print-pdf')}}?{{ isset($_GET['tanggal']) ? "tanggal=".$_GET['tanggal'] : ''}}{{ isset($_GET['show_filter']) ? "&show_filter=".$_GET['show_filter'] : ''}}"
				   target="_blank"
				   class="btn btn-danger mr-2"
				   id="download_pdf"
				>
                    <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                </a>

                <a href="{{url('reporting/room-statistic-by-guest-segment/print-excel')}}?{{ isset($_GET['tanggal']) ? "tanggal=".$_GET['tanggal'] : '' }}{{ isset($_GET['show_filter']) ? "&show_filter=".$_GET['show_filter'] : ''}}" class="btn btn-success"><i class="far fa-file-excel"></i>&nbsp;Download Excel</a>
            </div>
		</div>
	</div>
	<!-- /page header -->

	<!-- Content area -->
	<div class="content">

		<!-- Hover rows -->
        <div class="card">
            <div class="card-header header-elements-inline">
                <div class="col-lg-12 row">
                    {{-- <h3 class="text-center">Daily Revenue Report</h3> --}}
                    <p class="mb-0">
                        <span class="float-left" style="font-size: 14px;">
                            <div class="period col-sm-3">
                                <p>Date: <input type="text"
                                                  id="tanggal"
                                                  name="tanggal"
                                                  class="form-control single-daterange"
                                                  value="{{ date('d-m-Y', strtotime(getSystemDate()) ) }}"
                                                  autocomplete="off"
                                                  required
                                            >
                                </p>
                            </div>

                            <div class="period col-sm-3">
                                <p>Show: <select name="show_filter"
                                                id="show_filter"
                                                class="form-control"
                                        >
                                            <option value="mtd" {{ \Request::get('show_filter') == "mtd" ? 'selected' : '' }}>MTD</option>
                                            <option value="ytd" {{ \Request::get('show_filter') == "ytd" ? 'selected' : '' }}>YTD</option>
                                        </select>
                                </p>
                            </div>
                        </span>
                    </p>
                </div>
            </div>
        </div>

        {{-- Room sales --}}
		<div class="card table-responsive">
            <div class="card-header">
                {{-- <div class="print" class="float-right">
                    <a href="{{url('reporting/in-house-guest-list-report/cetak-pdf')}}?no_roomrate=1" target="_blank" class="btn btn-danger mr-2">
                        <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                    </a>

                    <a href="{{url('reporting/in-house-guest-list-report/cetak-excel')}}?no_roomrate=1" class="btn btn-success" download><i class="far fa-file-excel"></i>&nbsp;Download Excel</a>
                </div> --}}
            </div>

			<table class="table datatable-basic table-hover">
                @php
                    $mtd = '';
                    $ytd = '';

                    if (\Request::get('show_filter') == "ytd") {
                        $mtd = 'd-none';
                        $ytd = '';
                    }else{
                        $mtd = '';
                        $ytd = 'd-none';
                    }
                @endphp

				<thead>
					<tr>
                        <th>No</th>
                        <th>Guest Segment</th>
                        <th class="{{ $mtd }}">#Rm</th>
                        <th class="{{ $mtd }}">(%)</th>
                        <th>MTD Total Room</th>
                        <th>(%)</th>
                        <th class="{{ $ytd }}">YTD Total Room</th>
                        <th class="{{ $ytd }}">(%)</th>
                        <th class="{{ $mtd }}">Pax</th>
						<th>MTD Total Pax</th>
						<th class="{{ $ytd }}">YTD Total Pax</th>
                        <th class="{{ $mtd }}">Average-Rate</th>
                        <th>MTD AvrgRate</th>
                        <th class="{{ $ytd }}">YTD AvrgRate</th>
                        <th class="{{ $mtd }}">Room Lodging</th>
                        <th>MTD Lodging</th>
                        <th class="{{ $ytd }}">YTD Lodging</th>
                    </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>
                            <td class="{{ $mtd }}">{{ $guest_segments[$key_segmentation]['room'] }}</td>
                            <td class="{{ $mtd }}">{{ decimalWithDot($guest_segments[$key_segmentation]['percent'], 2) }}</td>
                            <td>{{ $guest_segments[$key_segmentation]['room_mtd'] }}</td>
                            <td>{{ decimalWithDot($guest_segments[$key_segmentation]['percent_mtd'], 2) }}</td>
                            <td class="{{ $ytd }}">{{ $guest_segments[$key_segmentation]['room_ytd'] }}</td>
                            <td class="{{ $ytd }}">{{ decimalWithDot($guest_segments[$key_segmentation]['percent_ytd'], 2) }}</td>
                            <td class="{{ $mtd }}">{{ $guest_segments[$key_segmentation]['pax'] }}</td>
                            <td>{{ $guest_segments[$key_segmentation]['pax_mtd'] }}</td>
                            <td class="{{ $ytd }}">{{ $guest_segments[$key_segmentation]['pax_ytd'] }}</td>
                            <td class="{{ $mtd }}">{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate']) }}</td>
                            <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate_mtd']) }}</td>
                            <td class="{{ $ytd }}">{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['average_rate_ytd']) }}</td>
                            <td class="{{ $mtd }}">{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue']) }}</td>
                            <td>{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue_mtd']) }}</td>
                            <td class="{{ $ytd }}">{{ ribuanDuaAngkaBelakangKoma($guest_segments[$key_segmentation]['room_revenue_ytd']) }}</td>
                        </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>
                            <td class="{{ $mtd }}">{{ $total_rev_room['room'] }}</td>
                            <td class="{{ $mtd }}">{{ decimalWithDot($total_rev_room['percent'], 2) }}</td>
                            <td>{{ $total_rev_room['room_mtd'] }}</td>
                            <td>{{ decimalWithDot($total_rev_room['percent_mtd'], 2)}}</td>
                            <td class="{{ $ytd }}">{{ $total_rev_room['room_ytd'] }}</td>
                            <td class="{{ $ytd }}">{{ decimalWithDot($total_rev_room['percent_ytd'], 2)}}</td>
                            <td class="{{ $mtd }}">{{ $total_rev_room['pax'] }}</td>
                            <td>{{ $total_rev_room['pax_mtd']}}</td>
                            <td class="{{ $ytd }}">{{ $total_rev_room['pax_ytd']}}</td>
                            <td class="{{ $mtd }}">{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate'])}}</td>
                            <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate_mtd'])}}</td>
                            <td class="{{ $ytd }}">{{ ribuanDuaAngkaBelakangKoma($total_rev_room['average_rate_ytd'])}}</td>
                            <td class="{{ $mtd }}">{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue'])}}</td>
                            <td>{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue_mtd'])}}</td>
                            <td class="{{ $ytd }}">{{ ribuanDuaAngkaBelakangKoma($total_rev_room['room_revenue_ytd'])}}</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></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>
                            <td class="{{ $mtd }}"></td>
                            <td class="{{ $mtd }}"></td>
                            <td></td>
                            <td></td>
                            <td class="{{ $ytd }}"></td>
                            <td class="{{ $ytd }}"></td>
                            <td class="{{ $mtd }}"></td>
                            <td></td>
                            <td class="{{ $ytd }}"></td>
                            <td class="{{ $mtd }}"></td>
                            <td></td>
                            <td class="{{ $ytd }}"></td>
                            <td class="{{ $mtd }}"></td>
                            <td></td>
                            <td class="{{ $ytd }}"></td>
                        </tr>
                        <tr>
                            <td></td>
                            <td>COMP</td>
                            <td class="{{ $mtd }}">{{ $total_complimentary['room'] }}</td>
                            <td class="{{ $mtd }}"></td>
                            <td>{{ $total_complimentary['room_mtd'] }}</td>
                            <td></td>
                            <td class="{{ $ytd }}">{{ $total_complimentary['room_ytd'] }}</td>
                            <td class="{{ $ytd }}"></td>
                            <td class="{{ $mtd }}">{{ $total_complimentary['pax'] }}</td>
                            <td>{{ $total_complimentary['pax_mtd'] }}</td>
                            <td class="{{ $ytd }}">{{ $total_complimentary['pax_ytd'] }}</td>
                            <td class="{{ $mtd }}"></td>
                            <td></td>
                            <td class="{{ $ytd }}"></td>
                            <td class="{{ $mtd }}"></td>
                            <td></td>
                            <td class="{{ $ytd }}"></td>
                        </tr>
                    @endif
                </tfoot>
			</table>
		</div>
		<!-- /hover rows -->

	</div>
	<!-- /content area -->

    <!-- Danger modal -->
	<div id="modal_theme_danger" class="modal fade" tabindex="-1">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header bg-danger" align="center">
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form action="" method="post" id="delform">
				    @csrf
				    @method('DELETE')
					<div class="modal-body" align="center">
						<h2> Hapus Data? </h2>
					</div>

					<div class="modal-footer">
						<button type="button" class="btn btn-link" data-dismiss="modal">Batal</button>
						<button type="submit" class="btn bg-danger">Hapus</button>
					</div>
				</form>
			</div>
		</div>
	</div>
	<!-- /default modal -->

@endsection

@section('js')
	<!-- Theme JS files -->
	<script src="{{asset('global_assets/js/plugins/notifications/pnotify.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/notifications/bootbox.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/tables/datatables/datatables.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/selects/select2.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/spin.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/buttons/ladda.min.js')}}"></script>

	<script src="{{asset('assets/js/app.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/components_modals.js')}}"></script>
	<script>
		//Data Filter
		//Data Filter
		// Ambil Data Filter Tanggal
		let tanggal = {!! json_encode(\Request::get('tanggal') ? formatDate(\Request::get('tanggal'), 'd-m-Y') : date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) ) !!}

		// Ambil Data Filter Tanggal
		let filter = "{{ \Request::get('filter') }}";
        if (filter) {
            $("#filter_inhouse").val(filter).select2();
        }

		// URL Export PDF dan URL Export Excel
		let base_url_pdf = "{{ url('walkin-list-pdf') }}?no_roomrate=1";

        //Single Date Picker
        $('.single-daterange').daterangepicker({
            singleDatePicker: true,
            showDropdowns: true,
            applyClass: 'btn-primary',
            cancelClass: 'btn-light',
            startDate:   tanggal,
            maxDate:"{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
            locale: {
            	format: 'DD-MM-YYYY'
            }
        });

        // Trigger Ketika Ganti Tanggal Checkin / Checkout
		$('#tanggal').on('apply.daterangepicker', (e, picker) => {
			//Hotel ID
			// let hotel_id = $("#hotel_id").val();

			//Menghitung jumlah malam, total biaya, dan ketersediaan kamar
			// var range = $('#tanggal').data('daterangepicker');

            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);

			let pdf_href = $('#download_pdf').attr('href');

            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);

            // menambahkan show pada url
            params.delete('show_filter');
            params.append('show_filter', document.getElementById("show_filter").value);

            document.location.href = "?" + params.toString();
	    });

        //show filter
		$(document).on("change", "#show_filter", function () {
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);

            // menambahkan tanggal pada url
            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);

            // menambahkan show pada url
            params.delete('show_filter');
            params.append('show_filter', document.getElementById("show_filter").value);

            document.location.href = "?" + params.toString();
		});

        // Trigger Ketika Ganti Filter
        function filtered() {
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);

			let pdf_href = $('#download_pdf').attr('href');

            params.delete('filter');
            params.append('filter', document.getElementById("filter_inhouse").value);
            document.location.href = "?" + params.toString();
        }

        //modal delete
		$(document).on("click", ".delbutton", function () {
		     var url = $(this).data('uri');
		     $("#delform").attr("action", url);
		});

		var DatatableBasic = function() {

		    // Basic Datatable examples
		    var _componentDatatableBasic = function() {
		        if (!$().DataTable) {
		            console.warn('Warning - datatables.min.js is not loaded.');
		            return;
		        }

		        // Setting datatable defaults
		        $.extend( $.fn.dataTable.defaults, {
		            autoWidth: false,
		            columnDefs: [{
		                orderable: false,
		                targets: [1]
		            }],
		            dom: '<"datatable-header"fl><"datatable-scroll"t><"datatable-footer"ip>',
		            language: {
		                search: '<span>Filter:</span> _INPUT_',
		                searchPlaceholder: 'Type to filter...',
		                lengthMenu: '<span>Show:</span> _MENU_',
		                paginate: { 'first': 'First', 'last': 'Last', 'next': $('html').attr('dir') == 'rtl' ? '&larr;' : '&rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr;' : '&larr;' }
		            }
		        });

		        // Basic datatable
		        $('.datatable-basic').DataTable({
                    paging: false,
                    bFilter: false
                });

		        // Alternative pagination
		        $('.datatable-pagination').DataTable({
		            pagingType: "simple",
		            language: {
		                paginate: {'next': $('html').attr('dir') == 'rtl' ? 'Next &larr;' : 'Next &rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr; Prev' : '&larr; Prev'}
		            }
		        });

		        // Datatable with saving state
		        $('.datatable-save-state').DataTable({
		            stateSave: true
		        });

		        // Scrollable datatable
		        var table = $('.datatable-scroll-y').DataTable({
		            autoWidth: true,
		            scrollY: 300
		        });

		        // Resize scrollable table when sidebar width changes
		        $('.sidebar-control').on('click', function() {
		            table.columns.adjust().draw();
		        });
		    };

		    // Select2 for length menu styling
		    var _componentSelect2 = function() {
		        if (!$().select2) {
		            console.warn('Warning - select2.min.js is not loaded.');
		            return;
		        }

		        // Initialize
		        $('.dataTables_length select').select2({
		            minimumResultsForSearch: Infinity,
		            dropdownAutoWidth: true,
		            width: 'auto'
		        });
		    };


		    //
		    // Return objects assigned to module
		    //

		    return {
		        init: function() {
		            _componentDatatableBasic();
		            _componentSelect2();
		        }
		    }
		}();


		// Initialize module
		// ------------------------------

		document.addEventListener('DOMContentLoaded', function() {
		    DatatableBasic.init();
		});
	</script>
	<script type="text/javascript">
		$( document ).ready(function() {
	        // Default style
	        @if(session('error'))
	            new PNotify({
	                title: 'Error',
	                text: '{{ session('error') }}.',
	                icon: 'icon-blocked',
	                type: 'error'
	            });
            @endif
            @if ( session('success'))
	            new PNotify({
	                title: 'Success',
	                text: '{{ session('success') }}.',
	                icon: 'icon-checkmark3',
	                type: 'success'
	            });
            @endif

		});
	</script>
@endsection