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

@section('title', 'Competitor Report')

@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">Competitor Report</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> Add Competitor Report
                            </button>
                        </a>
                    </div>
                </div>
                {{--
                    <form action="{{url('reporting/hotcoms/print-pdf')}}" target="_blank">
                        <input type="hidden" name="date_filter" value="{{ \Request::get('date_filter') ?? date('d-m-Y', strtotime(getSystemDate()) ) }}">

                        <button id="btn_cetak_pdf" class="btn btn-danger">
                            <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                        </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">
                    <p class="mb-0">
                        <span class="float-left" style="font-size: 14px;">
                            <input type="text" id="date_filter" name="date_filter" class="form-control daterange-single date-filter" autocomplete="off" required>
                        </span>
                    </p>
                </div>
            </div>
        </div>

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

                    <table class="table datatable-basic table-hover">
						<thead>
							<tr>
								<th>Date</th>
                                <th>Hotel Name</th>
								<th>Saleable Room</th>
								<th>Room Occupied (Paying Only)</th>
								<th>Average Roomrate</th>
                                <th></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><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->room_sold }}</div></td>
                                    <td><div class="datatable-column-width">Rp. {{ ribuanDuaAngkaBelakangKoma($hotcom->average_room_rate) }}</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-success" align="center">
                    <h6 class="modal-title"><i class="fas fa-user mr-1"></i><span class="title-modal-create-edit">Add Competitor Report</span></h6>
					<button type="button" class="close" data-dismiss="modal">&times;</button>
				</div>

				<form class="form-validate-jquery"
					  action="{{ route('competitor-report.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">
                        <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>
                            </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">Average Roomrate</label>
                            <div class="col-lg-9">
                                <!-- <input type="text" id="room_revenue" name="average_room_rate" class="form-control border-teal border-1" min="0" required> -->
                                <input type="text" id="average_room_rate" name="average_room_rate" 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())) ) }}")
        initDateRangePickerModal("{{ \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);

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

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

            // countRevpar()
            this.value = this.value.replace(/[^0-9.]/g, '').replace(/(\..*?)\..*/g, '$1');
        })

        $('#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 initDateRangePickerModal(date = null){
            $('#date').daterangepicker({
                singleDatePicker: true,
                startDate: date ?? "{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
                // maxDate: "{{ date('d-m-Y', strtotime(getSystemDate()) ) }}",
                maxDate: "{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
                locale: {
                    format: 'DD-MM-YYYY'
                }
            });
        }

        // function init date picker
        function initDateRangePicker(date = null){
            $('#date_filter').daterangepicker({
                singleDatePicker: true,
                startDate: date ?? "{{ date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}",
                // maxDate: "{{ date('d-m-Y', 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('/reporting/hotcoms/')}}/"+id+"/edit",
                dataType: "json",
                success: function (data) {
                    console.log(data);
                    let hotcom = data.hotcom;
                    // console.log('coba berhasil', data);
                    $('#myform').attr("action", '/reporting/competitor-report/'+hotcom.id);
                    $('#method').val("put");
                    $('.title-modal-create-edit').text("Edit Competitor Report");
                    $('#date').val(moment(hotcom.date).format('DD-MM-YYYY'));
                    $('#hotel_name').val(hotcom.hotel_name);
                    $('#saleable_room').val(hotcom.saleable_room);
                    $('#room_sold').val(hotcom.room_sold);
                    $('#room_sold_plus_comp').val(hotcom.room_sold_plus_comp);
                    $('#average_room_rate').val(hotcom.average_room_rate).unmask();
					$('#hotel_competitor_list_id').val(hotcom.hotel_competitor_list_id);

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

                    $('#formtitle').html('Edit Competitor Report');
                }
            });
        }

        $('#form_create_edit_modal').on('hidden.bs.modal', function () {
                $(this).find('form').trigger('reset');
                $('#myform').attr("action", "{{ route('competitor-report.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'));
                $('.title-modal-create-edit').text("Add Competitor Report");

                initDateRangePickerModal("{{ \Request::get('date_filter') ?? date('d-m-Y', strtotime('-1 day', strtotime(getSystemDate())) ) }}")

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