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

@section('title', 'Room Usage and Turnover Report')

@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;
    }

    .listtable td, .listtable th {
        text-align: right;
    }
</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> - Room Usage and Turnover Report</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">
                <!-- Button PDF -->
                <a href="{{url('reporting/room-usage-and-turnover-report/print-pdf')}}?{{ isset($_GET['tanggal']) ? "&tanggal=".$_GET['tanggal'] : ''}} {{ isset($_GET['filter_display_type']) ? "&filter_display_type=".$_GET['filter_display_type'] : ''}} {{ isset($_GET['filter_by']) ? "&filter_by=".$_GET['filter_by'] : ''}}  {{ isset($_GET['search_no']) ? "&search_no=".$_GET['search_no'] : ''}} {{ isset($_GET['show_revenue']) ? "&show_revenue=".$_GET['show_revenue'] : ''}}"
				   target="_blank"
				   class="btn btn-danger mr-2"
				   id="download_pdf"
				>
                    <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                </a>

                <!-- Button EXCEL -->
                <a href="{{url('reporting/room-usage-and-turnover-report/print-excel')}}?{{ isset($_GET['tanggal']) ? "&tanggal=".$_GET['tanggal'] : ''}} {{ isset($_GET['filter_display_type']) ? "&filter_display_type=".$_GET['filter_display_type'] : ''}} {{ isset($_GET['filter_by']) ? "&filter_by=".$_GET['filter_by'] : ''}}  {{ isset($_GET['search_no']) ? "&search_no=".$_GET['search_no'] : ''}} {{ isset($_GET['show_revenue']) ? "&show_revenue=".$_GET['show_revenue'] : ''}}" 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 -->

        {{-- Room Production Report --}}
		<div class="card table-responsive">
            <div class="card-header">
                <div class="row justify-content-start">

                    <div class="col-sm-2">
                        <p>Dispay Filter:
                            <select name="filter_display_type" id="filter_display_type" class="form-control form-control-select2" onchange="filter_display_type()">
                                <option value="2">Year-To-Date</option>
                                <option value="1">FromDate-ToDate</option>
                            </select>
                        </p>
                    </div>

                    <div class="col-sm-2">
                        @if ($filter_type_display == 1)

                            <p>Date Range: <input type="text"
                                id="tanggal"
                                name="tanggal"
                                class="form-control filter-daterange filter_tanggal"
                                value="{{ date('d-m-Y', strtotime(getSystemDate()) ) }}"
                                autocomplete="off"
                                required
                            >
                            </p>


                        @else

                            <p>Date: <input type="text"
                                id="tanggal"
                                name="tanggal"
                                class="form-control single-daterange filter_tanggal"
                                value="{{ date('d-m-Y', strtotime(getSystemDate()) ) }}"
                                autocomplete="off"
                                required
                            >
                            </p>

                        @endif
                    </div>

                    <div class="col-sm-2">
                        <p>Room No:
                            <input type="integer" name="search_no" id="search_no" class="form-control" placeholder="101...">
                        </p>
                    </div>

                    <div class="col-sm-2">
                        <p>Filter:
                            <select name="filter_by" id="filter_by" class="form-control form-control-select2" onchange="filter_by()">
                                <option value="2">By Category</option>
                                <option value="1">By RoomNo</option>
                            </select>
                        </p>
                    </div>

                    <div class="col-sm-2">
                        <p>Data display:

                            <div class="form-check">
                                <label class="form-check-label">
                                    <input class="form-check-input" type="checkbox" value="1" id="show_revenue" onchange="show_revenue()">
                                    Lodging Revenue
                                </label>
                            </div>

                        </p>
                    </div>

                </div>
            </div>
			<table class="table table-hover listtable">
                <thead>
                    <tr>

                        <th style="white-space: nowrap; text-align:left">RmNo</th>
                        <th style="white-space: nowrap; text-align:left">RmType</th>

                        <th>#Rm</th>
                        <th>Pax</th>
                        <th>Room-Revenue</th>
                        <th>(%)</th>

                        <th>MTD#Rm</th>
                        <th>Person</th>
                        <th>Room-Revenue</th>
                        <th>(%)</th>

                        <th>{{$filter_type_display == 1 ? 'FTD' : 'YTD'}}#Rm</th>
                        <th>Person</th>
                        <th>Room-Revenue</th>
                        <th>(%)</th>

                    </tr>
                </thead>
                <tbody>
                    @if (count($groupings) > 0)
                        @php
                            $total_all_perc_revenue_tdy = $total_all_perc_revenue_mtd = $total_all_perc_revenue_ytd = 0;
                            $total_all_pax_tdy = $total_all_pax_mtd = $total_all_pax_ytd = 0;
                            $total_all_qty_tdy = $total_all_qty_mtd = $total_all_qty_ytd = 0;
                        @endphp
                        @foreach ( $groupings as $akey => $grouping)
                            @php
                                $total_perc_revenue_tdy = $total_perc_revenue_mtd = $total_perc_revenue_ytd = 0;
                                $total_pax_tdy = $total_pax_mtd = $total_pax_ytd = 0;
                                $total_qty_tdy = $total_qty_mtd = $total_qty_ytd = 0;
                            @endphp
                            @foreach($grouping as $key => $room)

                                @php
                                    // Percent Revenue
                                    $perc_revenue_tdy = $total_room_all['revenue_tdy'] > 0 ? ( round( ((@$room['revenue_tdy'] ?? 0) / @$total_room_all['revenue_tdy'] * 100) , 2) ) : 0;
                                    $perc_revenue_mtd = $total_room_all['revenue_mtd'] > 0 ? ( round( ((@$room['revenue_mtd'] ?? 0) / @$total_room_all['revenue_mtd'] * 100) , 2) ) : 0;
                                    $perc_revenue_ytd = $total_room_all['revenue_ytd'] > 0 ? ( round( ((@$room['revenue_ytd'] ?? 0) / @$total_room_all['revenue_ytd'] * 100) , 2) ) : 0;

                                    // Total Percent Revenue
                                    $total_perc_revenue_tdy += $perc_revenue_tdy ?? 0 ;
                                    $total_perc_revenue_mtd += $perc_revenue_mtd ?? 0 ;
                                    $total_perc_revenue_ytd += $perc_revenue_ytd ?? 0 ;

                                    // Total Percent Revenue
                                    $total_pax_tdy += $room['pax_tdy'] ?? 0 ;
                                    $total_pax_mtd += $room['pax_mtd'] ?? 0 ;
                                    $total_pax_ytd += $room['pax_ytd'] ?? 0 ;

                                    // Total Percent Revenue
                                    $total_qty_tdy += $room['qty_tdy'] ?? 0 ;
                                    $total_qty_mtd += $room['qty_mtd'] ?? 0 ;
                                    $total_qty_ytd += $room['qty_ytd'] ?? 0 ;

                                @endphp
                                <tr>

                                    <td style="white-space: nowrap; text-align:left">{{$room['rmno']}}</td>
                                    <td style="white-space: nowrap; text-align:left">{{$room['rmtype']}}</td>

                                    <td>{{ @$room['qty_tdy'] ?? 0 }}</td>
                                    <td>{{ @$room['pax_tdy'] ?? 0 }}</td>
                                    <td>{{ ribuanWithComma(@$room['revenue_tdy']) ?? 0 }}</td>
                                    <td>{{ (($perc_revenue_tdy)) ?? 0.00 }}</td>

                                    <td>{{ @$room['qty_mtd'] ?? 0 }}</td>
                                    <td>{{ @$room['pax_mtd'] ?? 0 }}</td>
                                    <td>{{ ribuanWithComma(@$room['revenue_mtd']) ?? 0 }}</td>
                                    <td>{{ (($perc_revenue_mtd)) ?? 0.00 }}</td>

                                    <td>{{ @$room['qty_ytd'] ?? 0 }}</td>
                                    <td>{{ @$room['pax_ytd'] ?? 0 }}</td>
                                    <td>{{ ribuanWithComma(@$room['revenue_ytd']) ?? 0 }}</td>
                                    <td>{{ (($perc_revenue_ytd)) ?? 0.00 }}</td>

                                </tr>
                            @endforeach

                            @if ($filter_by == 2)
                            <tr style="background-color: #e0e0e0;">
                                <td style="font-weight:bold;"></td>
                                <td style="font-weight:bold; text-align:left">Total</td>
                                <td style="font-weight:bold;">{{ $total_qty_tdy }}</td>
                                <td style="font-weight:bold;">{{ $total_pax_tdy }}</td>
                                <td style="font-weight:bold;">{{ ribuanWithComma($total_room['revenue_tdy'][$akey]) }}</td>
                                <td style="font-weight:bold;">{{ (($total_perc_revenue_tdy)) }}</td>

                                <td style="font-weight:bold;">{{ $total_qty_mtd }}</td>
                                <td style="font-weight:bold;">{{ $total_pax_mtd }}</td>
                                <td style="font-weight:bold;">{{ ribuanWithComma($total_room['revenue_mtd'][$akey]) }}</td>
                                <td style="font-weight:bold;">{{ (($total_perc_revenue_mtd)) }}</td>

                                <td style="font-weight:bold;">{{ $total_qty_ytd }}</td>
                                <td style="font-weight:bold;">{{ $total_pax_ytd }}</td>
                                <td style="font-weight:bold;">{{ ribuanWithComma($total_room['revenue_ytd'][$akey]) }}</td>
                                <td style="font-weight:bold;">{{ (($total_perc_revenue_ytd)) }}</td>
                            </tr>
                            @endif

                            @php
                                // TOTAL ALL
                                   // Total Percent Revenue
                                    $total_all_perc_revenue_tdy += $total_perc_revenue_tdy;
                                    $total_all_perc_revenue_mtd += $total_perc_revenue_mtd;
                                    $total_all_perc_revenue_ytd += $total_perc_revenue_ytd;

                                    // Total Percent Revenue
                                    $total_all_pax_tdy += $total_pax_tdy ;
                                    $total_all_pax_mtd += $total_pax_mtd ;
                                    $total_all_pax_ytd += $total_pax_ytd ;

                                    // Total Percent Revenue
                                    $total_all_qty_tdy += $total_qty_tdy ;
                                    $total_all_qty_mtd += $total_qty_mtd ;
                                    $total_all_qty_ytd += $total_qty_ytd ;

                            @endphp
                        @endforeach
                        <tr>
                            <td colspan="14">&nbsp;</td>
                        </tr>
                        <tr style="background-color: #d6d6d6; font-weight:bold">
                            <th style="font-weight:bold; white-space: nowrap; text-align:left"></th>
                            <th style="font-weight:bold; white-space: nowrap; text-align:left">TOTAL</th>

                            <th style="font-weight:bold;">{{ ribuanWithComma($total_all_qty_tdy) }}</th>
                            <th style="font-weight:bold;">{{ ribuanWithComma($total_all_pax_tdy) }}</th>
                            <th style="font-weight:bold;">{{ ribuanWithComma($total_room_all['revenue_tdy']) }}</th>
                            <th style="font-weight:bold;">{{ decimalWithDot(round($total_all_perc_revenue_tdy), 2) }}</th>

                            <th style="font-weight:bold;">{{ ribuanWithComma($total_all_qty_mtd) }}</th>
                            <th style="font-weight:bold;">{{ ribuanWithComma($total_all_pax_mtd) }}</th>
                            <th style="font-weight:bold;">{{ ribuanWithComma($total_room_all['revenue_mtd']) }}</th>
                            <th style="font-weight:bold;">{{ decimalWithDot(round($total_all_perc_revenue_mtd), 2) }}</th>

                            <th style="font-weight:bold;">{{ ribuanWithComma($total_all_qty_ytd) }}</th>
                            <th style="font-weight:bold;">{{ ribuanWithComma($total_all_pax_ytd) }}</th>
                            <th style="font-weight:bold;">{{ ribuanWithComma($total_room_all['revenue_ytd']) }}</th>
                            <th style="font-weight:bold;">{{ decimalWithDot(round($total_all_perc_revenue_ytd), 2) }}</th>

                        </tr>
                    @else
                    <tr>
                        <td style="text-align:center" colspan="14">
                            <h4>No Data</h4>
                        </td>
                    </tr>
                    @endif
                </tbody>
			</table>
		</div>
		<!-- /hover rows -->

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

@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/plugins/forms/styling/uniform.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/styling/switchery.min.js')}}"></script>
	<script src="{{asset('global_assets/js/plugins/forms/styling/switch.min.js')}}"></script>

	<script>
		//Data Filter
        $( document ).ready(function() {



            var queryString = window.location.search;
            var urlParams = new URLSearchParams(queryString);
            var filter_display_type   = urlParams.get('filter_display_type');
            var filter_by             = urlParams.get('filter_by');
            var search_no             = urlParams.get('search_no');
            var show_revenue          = urlParams.get('show_revenue');

            if (filter_display_type == 1) {

                // Ambil Data Filter Tanggal
		        let tanggal = {!! json_encode((\Request::get('tanggal') ? \Request::get('tanggal') : date('d-m-Y', strtotime((getSystemDate())) ))  ) !!}

                console.log(tanggal);
                tanggal = tanggal.split(" - ");
                //Single Date Picker
                $('.filter-daterange').daterangepicker({
                    showDropdowns: true,
                    applyClass: 'btn-primary',
                    cancelClass: 'btn-light',
                    startDate: tanggal[0],
                    endDate: tanggal[1],
                    maxDate:"{{ date('d-m-Y', strtotime((getSystemDate())) ) }}",
                    locale: {
                        format: 'DD-MM-YYYY'
                    }
                });
            }else if(filter_display_type == 2){

                // Ambil Data Filter Tanggal
		        let tanggal = {!! json_encode((\Request::get('tanggal') ? formatDate(\Request::get('tanggal'), 'd-m-Y') : date('d-m-Y', strtotime((getSystemDate())) ))  ) !!}

                //Single Date Picker
                $('.single-daterange').daterangepicker({
                    singleDatePicker: true,
                    showDropdowns: true,
                    applyClass: 'btn-primary',
                    cancelClass: 'btn-light',
                    startDate:   tanggal,
                    maxDate:"{{ date('d-m-Y', strtotime((getSystemDate())) ) }}",
                    locale: {
                        format: 'DD-MM-YYYY'
                    }
                });
            }else{
                // Ambil Data Filter Tanggal
		        let tanggal = {!! json_encode((\Request::get('tanggal') ? formatDate(\Request::get('tanggal'), 'd-m-Y') : date('d-m-Y', strtotime((getSystemDate())) ))  ) !!}

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

            // show data filter
            if (filter_display_type) {
                $('#filter_display_type').val(filter_display_type).select2()
            }

            // show data filter
            if (filter_by) {
                $('#filter_by').val(filter_by).select2()
            }

            // show data search
            if (search_no) {
                $('#search_no').val(search_no)
            }

            // show data revenue
            if (show_revenue == 1) {
                $('#show_revenue').attr('checked', true)
            }

        })

        // CHECKBOX CONFIG
        $('#show_revenue').on('click', function(){
            let is_checked = $('#show_revenue').is(':checked');
            if(is_checked){
                $('#show_revenue').val(1);
            }
            else{
                $('#show_revenue').val(0);
            }
        });

        // Trigger Ketika Ganti Tanggal Checkin / Checkout
		$('.filter_tanggal').on('apply.daterangepicker', (e, picker) => {
            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);

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

        // Trigger Ketika Ganti Tanggal Checkin / Checkout
		$('#search_no').on('change', function(){
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);

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

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

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

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

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

            params.delete('filter_by');

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

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

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

            params.delete('filter_display_type');
            params.delete('filter_by');
            params.delete('show_revenue');
            params.delete('tanggal');
            params.delete('search_no');

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

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

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

            params.delete('show_revenue');

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

        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,
		                width: 150,
		                targets: [15]
		            }],
		            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