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

@section('title', 'HotCom')

@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">
                    HotCom
                </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 target="_blank">
                    <input type="hidden" name="date_filter" value="{{ \Request::get('date_filter') ?? date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}">
                    <input type="hidden" name="show_filter" value="{{ \Request::get('show_filter') ?? 'mtd' }}">

                    <button type="submit" id="btn_cetak_pdf" class="btn btn-danger" formaction="{{url('reporting/hotcoms/print-pdf')}}">
                        <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                    </button>
                    <button type="submit" id="btn_cetak_excel" class="btn btn-success" formaction="{{url('reporting/hotcoms/print-excel')}}">
                        <i class="far fa-file-excel"></i>&nbsp;Download Excel
                    </button>
                </form>
            </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="date_filter" name="date_filter" 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('hotcoms.print_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 -->

    <!-- Form modal -->
	<div id="form_create_edit_modal" class="modal fade">
		<div class="modal-dialog modal-lg">
			<div class="modal-content">
				<div class="modal-header bg-primary" align="center">
                    <h6 class="modal-title"><i class="fas fa-user mr-1"></i>Form HotCom</h6>
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form class="form-validate-jquery" action="{{ route('hotcoms.store')}}" method="post" id="myform" enctype="multipart/form-data">
                    @csrf
                    <input type="hidden" name="_method" id="method" value="post">
                    <input type="hidden" name="hotel_competitor_list_id" id="hotel_competitor_list_id">

                    <div class="modal-body">
                        <legend class="text-uppercase font-size-sm font-weight-bold" id="formtitle">Tambah Hotel Competitor</legend>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">Date</label>
                            <div class="col-lg-9">
                                <input type="text" id="date" name="date" class="form-control" autocomplete="off" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">Hotel Name</label>
                            <div class="col-lg-9">
                                <input type="text" id="hotel_name" name="hotel_name" class="form-control border-teal border-1" placeholder="Hotel Name" required autocomplete="off" list="hotel_competitor_lists">
                                <datalist id="hotel_competitor_lists">
                                    @php
                                        $idx = 1;
                                    @endphp

                                    @foreach($hotel_competitor_lists as $hotel_competitor_list)
                                        <option value="{{ $idx }} - {{ $hotel_competitor_list->hotel_name }}" data-id="{{ $hotel_competitor_list->id }}" data-hotel_name="{{ $hotel_competitor_list->hotel_name }}"></option>

                                        @php
                                            $idx++;
                                        @endphp
                                    @endforeach
                                </datalist>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">Room Available</label>
                            <div class="col-lg-9">
                                <input type="number" id="saleable_room" name="saleable_room"
									   class="form-control border-teal border-1" min="0"
									    required oninput="countOCC(), countOCCPlusComp()">
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">Room Occupied (Paying Only)</label>
                            <div class="col-lg-9">
                                <input type="number" id="room_sold" name="room_sold"
									   class="form-control border-teal border-1" min="0"
									    required oninput="countOCC(), countRoomRevenue()">
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">Room Occupied</label>
                            <div class="col-lg-9">
                                <input type="number" id="room_sold_plus_comp" name="room_sold_plus_comp"
									   class="form-control border-teal border-1" min="0"
									    required  oninput="countOCCPlusComp()">
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">% Occ </label>
                            <div class="col-lg-9">
                                <input type="text" id="occupied_room" name="occupied_room"
									   class="form-control border-teal border-1"
									   required>

                                <input type="hidden" id="occupied_room_before_simplify">
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">% Occ + Comp</label>
                            <div class="col-lg-9">
                                <input type="text" id="occupied_plus_comp" name="occupied_plus_comp"
									   class="form-control border-teal border-1"
									   required>

                                <input type="hidden" id="occupied_plus_comp_before_simplify">
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">ARR</label>
                            <div class="col-lg-9">
                                <input type="text" id="average_room_rate" name="average_room_rate" class="form-control border-teal border-1" min="0" required oninput="countRoomRevenue()">
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">REVPAR</label>
                            <div class="col-lg-9">
                                <input type="text" id="revpar" name="revpar" class="form-control border-teal border-1" min="0" required>
                            </div>
                        </div>

                        <div class="form-group row">
                            <label class="col-form-label col-lg-3">Room Revenue</label>
                            <div class="col-lg-9">
                                <input type="text" id="room_revenue" name="room_revenue" class="form-control border-teal border-1" min="0" required>
                            </div>
                        </div>
                    </div>

                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                        <button type="submit" class="btn btn-primary">Simpan <i class="icon-paperplane ml-2"></i></button>
                    </div>
                </form>

			</div>
		</div>
	</div>
	<!-- /Form modal -->

    <!-- 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('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>
        initDateRangePicker("{{ \Request::get('date_filter') ?? date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}")

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

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

            // menambahkan tanggal pada url
            params.delete('date_filter');
            params.append('date_filter', document.getElementById("date_filter").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('date_filter');
            params.append('date_filter', document.getElementById("date_filter").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('-1 day', strtotime(getSystemDate())) ) }}",
                // maxDate: "{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
                locale: {
                    format: 'DD-MM-YYYY'
                }
            });

            $('#date_filter').daterangepicker({
                singleDatePicker: true,
                startDate: date ?? "{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
                maxDate: "{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
                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