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

@section('title', 'Monthly Room Occupancy Forecast')

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

</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">
                    Monthly Room Occupancy Forecast
                </span></h4>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>

            <span class="float-right row">
				{{--
					<div class="form-group mr-2">
	                    <div id="btn_form_create_edit" >
	                        <a  data-toggle="modal"
	                            data-target="#form_create_edit_modal">
	                            <button type="button" class="btn btn-success">
	                                <i class="icon-add mr-2"></i> Tambah
	                            </button>
	                        </a>
	                    </div>
	                </div>
				--}}
                {{-- <form action="{{url('reporting/monthly-room-occupancy-forecast-pdf')}}" target="_blank">
                    <input type="hidden" name="period" value="{{ \Request::get('period') ?? getSystemDate().' - '.formatDate('+29 day '.getSystemDate()) }}">

                    <button id="btn_cetak_pdf" class="btn btn-danger">
                        <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                    </button>
                </form> --}}

                <a href="{{url('reporting/monthly-room-occupancy-forecast-pdf')}}?{{ isset($_GET['period']) ? "period=".$_GET['period'] : formatDate(getSystemDate()).' - '.formatDate('+29 day '.getSystemDate())}}"
				   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/monthly-room-occupancy-forecast-excel')}}?{{ isset($_GET['period']) ? "period=".$_GET['period'] : formatDate(getSystemDate()).' - '.formatDate('+29 day '.getSystemDate())}}" class="btn btn-success"><i class="far fa-file-excel"></i>&nbsp;Download Excel</a>
            </span>
		</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="col-lg-3">
                                <input type="text" id="period" name="period" class="form-control daterange-single date-filter" autocomplete="off" required>
                            </div>

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

		<div class="row">
			<div class="col-md-12">
				<!-- Hover rows -->
				<div class="card">

                    {{-- <div class="card-header">

                        <div class="form-group row">
                            <div id="btn_form_create_edit" class="col-sm-8">
                                <a  data-toggle="modal"
                                    data-target="#form_create_edit_modal">
                                    <button type="button" class="btn btn-success rounded-round">
                                        <i class="icon-add mr-2"></i> Tambah
                                    </button>
                                </a>
                            </div>
                        </div>

                    </div> --}}

                    <div class="card-body">
                        <div class="scroll-horizontal" style="width: 100%">
                            <div style="width:150%">
                                @include('report.monthly_room_occupancy_forecast_pdf')
                            </div>
                        </div>
                    </div>

                    {{-- <table class="table datatable-basic table-hover">
						<thead>
							<tr>
								<th>Date</th>
								<!-- <th>HNo</th> -->
                                <th>Hotel Name</th>
								<th>Sold Room</th>
								<th>Occupancy</th>
								<th>Average Roomrate</th>
								<th width="100px">Room Revenue</th>
								<th class="text-center">Actions</th>
							</tr>
						</thead>
						<tbody>
                            @if(!$hotcoms->isEmpty())
    							@foreach($hotcoms as $hotcom)
    							<tr>
    								<td><div class="datatable-column-width">{{ date('d-m-Y', strtotime($hotcom->date)) }}</div></td>
    								<!-- <td>{{ $loop->iteration }}</td> -->
                                    <td><div class="datatable-column-width">{{ $hotcom->hotel_name }}</div></td>
    								<td><div class="datatable-column-width">{{ $hotcom->saleable_room }}</div></td>
    								<td><div class="datatable-column-width">{{ $hotcom->occupied_room }} %</div></td>
    								<td><div class="datatable-column-width">Rp. {{ ribuan($hotcom->average_room_rate) }}</div></td>
    								<td><div class="datatable-column-width">Rp. {{ ribuan($hotcom->room_revenue) }}</div></td>
    								<td align="center">
    									<button type="button"
                                                class="btn btn-primary btn-icon editbutton"
                                                title="Ubah"
                                                data-target="#form_create_edit_modal"
                                                data-toggle="modal"
                                                onclick="edit({{$hotcom->id}});"
                                        >
                                            <i class="icon-pencil7"></i>
                                        </button>
    								</td>
    							</tr>
    							@endforeach
    						@endif
						</tbody>
					</table> --}}
				</div>
				<!-- /hover rows -->
			</div>
		</div>

	</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 -->

    {{-- get tanggal --}}
        @php
            $period = explode(' - ', \Request::get('period') ?? getSystemDate().' - '.formatDate('+29 day '.getSystemDate()));
            $period[0] = formatDate($period[0]);
            $period[1] = formatDate($period[1]);
        @endphp
    {{-- closing get tanggal --}}

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

	<script src="{{asset('assets/js/app.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/components_modals.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/form_inputs.js')}}"></script>
	<script>
        let period = {!! json_encode($period) !!}
        initDateRangePicker(period)

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

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

            // menambahkan tanggal pada url
            params.delete('period');
            params.append('period', document.getElementById("period").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('period');
        //     params.append('period', document.getElementById("period").value);

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

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

        $('#average_room_rate').on('input', function(){
            $(this).mask("#,##0.00", {reverse: true});//set separator number

            countRevpar()
        })

        $('#revpar').on('input', function(){
            $(this).mask("#,##0.00", {reverse: true});//set separator number
        })

        $('#room_revenue').on('input', function(){
            $(this).mask("#,##0.00", {reverse: true});//set separator number
        })

        $('#occupied_room').on('input', function(){
            $(this).mask("###.#0", {reverse: true});//set separator number

            countRevpar()
        })

        $('#occupied_plus_comp').on('input', function(){
            $(this).mask("###.#0", {reverse: true});//set separator number
        })

        $('#hotel_name').on('change', function(){
            let id = $('#hotel_competitor_lists').find('option[value="'+$(this).val()+'"]')
										    .attr('data-id');

            let hotel_name = $('#hotel_competitor_lists').find('option[value="'+$(this).val()+'"]')
										    .attr('data-hotel_name');

            if (id && hotel_name) {
                $('#hotel_name').val(hotel_name)
                $('#hotel_competitor_list_id').val(id)
            }
        })

        // function count room revenue
        function countRoomRevenue(){
            var average_room_rate = ($('#average_room_rate').val()).replace(',', '');
                average_room_rate = average_room_rate * 10;
            var room_sold = $('#room_sold').val();
            var room_revenue = average_room_rate * room_sold;

            // console.log(average_room_rate, room_sold, room_revenue, 'ini count room revenue');

            // check room reveue isNan false
            if (!isNaN(room_revenue)) {
                room_revenue = room_revenue.toFixed(0) * 100
                $('#room_revenue').mask("#,##0.00", {reverse: true}).val(room_revenue).trigger('input');
            }
        }

        // function count OCC
        function countOCC(){
            var room_sold = $('#room_sold').val();
            var saleable_room = $('#saleable_room').val();
            var occ = room_sold / saleable_room;

            if (!isNaN(occ)) {
                $('#occupied_room').val((occ * 100).toFixed(2));
                $('#occupied_room_before_simplify').val(occ);
            }

            countRevpar()

            // console.log(room_sold, saleable_room, occ, 'occupied room');
        }

        // function count OCC + Comp
        function countOCCPlusComp(){
            var room_sold_plus_comp = $('#room_sold_plus_comp').val();
            var saleable_room = $('#saleable_room').val();
            var occ_plus_comp = room_sold_plus_comp / saleable_room;

            if (!isNaN(occ_plus_comp)) {
                $('#occupied_plus_comp').val((occ_plus_comp * 100).toFixed(2));
                $('#occupied_plus_comp_before_simplify').val(occ_plus_comp);
            }

            // console.log(room_sold_plus_comp, saleable_room, occ_plus_comp, 'occupied room + comp');
        }

        // function count revpar
        function countRevpar(){
            var occupied_room_before_simplify = $('#occupied_room_before_simplify').val();
            var average_room_rate = ($('#average_room_rate').val()).replace(',', '');
                average_room_rate = average_room_rate * 10;
            var revpar = occupied_room_before_simplify * average_room_rate

            if (!isNaN(revpar)) {
                $('#revpar').mask("#,##0.00", {reverse: true}).val(revpar.toFixed(2)).trigger('input');
            }

            // console.log(occupied_room_before_simplify, average_room_rate, revpar, 'ini revpar')
        }

        // function init date picker
        function initDateRangePicker(date = null){
            $('#date').daterangepicker({
                singleDatePicker: true,
                startDate: "{{ date('d-m-Y', strtotime(getSystemDate()) ) }}",
                // maxDate: "{{ date('d-m-Y', strtotime(getSystemDate()) ) }}",
                locale: {
                    format: 'DD-MM-YYYY'
                }
            });

            $('#period').daterangepicker({
                // singleDatePicker: true,
                startDate: date[0] ?? "{{ date('d-m-Y', strtotime(getSystemDate()) ) }}",
                endDate:    date[1] ?? "{{ date('d-m-Y', strtotime('+29 day '.getSystemDate()) ) }}",
                // maxDate: "{{ date('d-m-Y', strtotime('+30 day '.getSystemDate()) ) }}",
                applyClass: 'btn-primary',
                cancelClass: 'btn-light',
                locale: {
                    format: 'DD-MM-YYYY'
                }
            });
        }

		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: 200,
		                targets: [ 6 ]
		            }],
		            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;' },
                        emptyTable: "No Data"
		            }
		        });

		        // Basic datatable
		        $('.datatable-basic').DataTable({

				});

		        // 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'},
                        emptyTable: "No Data"
		            }
		        });

		        // 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() {

			$('.form-control-select2').select2();

	        // 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
		});

        function edit(id){

                $.ajax({
                    type: "get",
                    url: "{{ url('/running-audit/hotcoms/')}}/"+id+"/edit",
                    dataType: "json",
                    success: function (data) {
                        let hotcom = data.hotcom;
                        // console.log('coba berhasil', data);
                        $('#myform').attr("action", '/running-audit/hotcom/'+hotcom.id);
                        $('#method').val("put");
                        $('#hotel_name').val(hotcom.hotel_name);
                        $('#saleable_room').val(hotcom.saleable_room);
                        $('#occupied_room').val(hotcom.occupied_room);
                        $('#average_room_rate').val((hotcom.average_room_rate).toLocaleString('ID'));
                        $('#room_revenue').val((hotcom.room_revenue).toLocaleString('ID'));

                        initDateRangePicker(moment(hotcom.date).format('DD-MM-YYYY'))

                        $('#formtitle').html('Edit HotCom');
                    }
                });

        }

        $('#form_create_edit_modal').on('hidden.bs.modal', function () {
                $(this).find('form').trigger('reset');
                $('#myform').attr("action", "{{ route('hotcoms.store')}}");
                $('#method').val("post");
                $('#saleable_room').val(0);
                $('#occupied_room').val(0);
                $('#average_room_rate').val((0).toLocaleString('ID'));
                $('#room_revenue').val((0).toLocaleString('ID'));

                initDateRangePicker()

                $('#formtitle').html('Tambah HotCom');
        })
    </script>
@endsection