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

@section('title', 'Room Revenue Breakdown')

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

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

@section('content')

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

            <div class="float-right">
                <div class="form-inline">
					{{-- <div class="custom-control custom-checkbox mt-2 mr-3">
						<input name="excludeBtn" type="checkbox" class="custom-control-input" id="custom_checkbox_stacked_unchecked" value="1">
						<label class="custom-control-label" for="custom_checkbox_stacked_unchecked" style="width: max-content;"><small>Excluded tax & services</small></label>
					</div> --}}
                    <form method="post" target="_blank" action="{{ route('report.room-revenue-breakdown') }}" id="form_download_pdf">
                        @csrf
						<input type="hidden" name="excludebtn" value="{{ isset($_GET['excludeBtn']) ? $_GET['excludeBtn'] : 0 }}">
                        <input type="hidden" name="tanggal" value="{{ isset($_GET['tanggal']) ? $_GET['tanggal'] : date('d-m-Y', strtotime('-1 day', strtotime(formatDate(getSystemDate()))) ) }}">
						<input type="hidden" name="filter_display_type" value="{{ isset($_GET['filter_display_type']) ? $_GET['filter_display_type'] : 1 }}">
                        {{-- <input type="text"
                               name="tanggal"
                               id="tanggal"
                               class="form-control single-daterange" required
                               autocomplete="off"
                        > --}}
                        <button type="submit" class="btn btn-danger ml-2">
                            <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                        </button>
                    </form>

                    <form method="post" action="{{ route('reporting.export-excel-room-revenue-breakdown') }}" id="form_download_excel">
                        @csrf
						<input type="hidden" name="excludebtn" value="{{ isset($_GET['excludeBtn']) ? $_GET['excludeBtn'] : 0 }}">
						<input type="hidden" name="tanggal" value="{{ isset($_GET['tanggal']) ? $_GET['tanggal'] : date('d-m-Y', strtotime('-1 day', strtotime(formatDate(getSystemDate()))) ) }}">
                        <input type="hidden" name="filter_display_type" value="{{ isset($_GET['filter_display_type']) ? $_GET['filter_display_type'] : 1 }}">
                        <button type="submit" class="btn btn-success ml-2">
                            <i class="far fa-file-excel"></i>&nbsp;Download Excel
                        </button>
                    </form>
                </div>
            </div>
		</div>
	</div>
	<!-- /page header -->

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

		<!-- Hover rows -->

        {{-- Room sales --}}
		<div class="card">
            <div class="card-header row">
                <div class="col-sm-4">
                    <p>Dispay Filter:
                        <select name="filter_display_type" id="filter_display_type" class="form-control form-control-select2" onchange="filter_display_type()">
                            <option value="1">Single date</option>
                            <option value="2">Date range</option>
                        </select>
                    </p>
                </div>
                <div class="col-sm-4">
                    @if ($filter_type_display == 2)
                        <p>Date Range: <input type="text"
                            name="tanggal"
                            id="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"
                            name="tanggal"
                            id="tanggal"
                            class="form-control single-daterange filter_tanggal"
                            value="{{ date('d-m-Y', strtotime(getSystemDate()) ) }}"
                            autocomplete="off"
                            required
                        >
                        </p>

                    @endif

                </div>
                <div class="custom-control custom-checkbox mt-2 mr-3 col-sm-2">
                    &nbsp;
                    <br>
                    <input name="excludeBtn" type="checkbox" class="custom-control-input" id="custom_checkbox_stacked_unchecked" value="1">
                    <label class="custom-control-label" for="custom_checkbox_stacked_unchecked" style="width: max-content;"><small>Excluded tax & services</small></label>
                </div>
                {{-- <div class="form-inline">
                    <form method="post" target="_blank" action="{{ route('report.room-revenue-breakdown') }}" id="form_download_pdf">
                        @csrf
                        <input type="text"
                               name="tanggal"
                               id="tanggal"
                               class="form-control single-daterange" required
                               autocomplete="off"
                        >
                    </form>
                </div> --}}
            </div>
            {{-- <div class="table-responsive"> --}}
                <table class="table datatable-basic table-hover">
                    <thead>
                        <tr>
                            <th>No</th>
                            <th>Date</th>
                            <th>RmNo</th>
                            <th>Argt</th>
                            <th>RCode</th>
                            <th>Curr</th>
                            <th>Room Rate</th>
                            <th>Pax</th>
                            <th>Com</th>
                            <th>Lodging</th>

		                    @php
		                    $colspan_summary = 0;
		                    $summary_room_rate = 0;
		                    $summary_pax = 0;
		                    $summary_com = 0;
		                    $summary_lodging = 0;
		                    $summary_arrangement = 0;
		                    $summary_total_rate = 0;
                            $summary_total_room = 0;
		                    @endphp

							{{-- @foreach(config('custom.revenue_groups') as $revenue_group) --}}
							<th>Total Arrangement <br> (Breakfast, etc.)</th>
								{{-- @php
		                        $colspan_summary++
		                        @endphp
							@endforeach --}}

                            <th>Total Rate</th>
                            <th>Arrival</th>
                            <th>Depart</th>
                            <th>BillNum</th>
                            <th>Reservation Name</th>
                            <th>Guest Name</th>
                        </tr>
                    </thead>
                    <tbody>
                        {{-- @foreach($bookings as $booking) --}}
                            @foreach($booking_details as $booking_detail)
                            @php
                                $booking = $booking_detail->booking;
                                $summary_total_room +=1;
                            @endphp

                            <tr>
                                <td>{{ $loop->iteration }}</td>
                                <td style="white-space: nowrap">{{ $booking_detail->date_now }}</td>
                                <td>{{$booking_detail->nomor_kamar}}</td>
                                <td>{{$booking_detail->arrangement_codes}}</td>
                                <td>{{$booking_detail->rate_codes}}</td>
                                <td>Rp</td>
								<td style="text-align: right">
                                    @php
                                        $total_arr_sum = 0;
                                        if (isset($_GET['excludeBtn'])) {
                                            $total_arr_sum += @$booking_detail->per_item_arr;
                                        }else{
                                            $total_arr_sum += @$booking_detail->per_item_arr + @$booking_detail->per_item_arr_services + @$booking_detail->per_item_arr_tax;
                                        }
                                    @endphp
									@if(isset($_GET['excludeBtn']))
                                        @if (in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11]))
										{{ribuanWithComma(0)}}
										@php $summary_room_rate += 0 @endphp
                                        @else
										{{ribuanWithComma($booking_detail->per_item_real + $total_arr_sum)}}
										@php $summary_room_rate += $booking_detail->per_item_real + $total_arr_sum @endphp
                                        @endif
									@else
										{{ribuanWithComma($booking_detail->per_item)}}
										@php $summary_room_rate += $booking_detail->per_item @endphp
									@endif
		                        </td>
		                        <td style="text-align: center">
		                            {{$booking_detail->pax}}
		                            @php $summary_pax += $booking_detail->pax @endphp
		                        </td>

		                        {{-- Com --}}
		                        <td style="text-align: center">
		                            @php
		                            $summary_com += in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11]) ? 1 : 0;
		                            @endphp
		                            {{ in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11]) ? 1 : '' }}
		                        </td>

		                        {{-- Lodging --}}
		                        <td style="text-align: right">
									@if(isset($_GET['excludeBtn']))
										@php
                                        if (in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11])) {
                                            $lodging = 0;
                                        }else{
                                            $lodging = $booking_detail->per_item_real;
                                        }
										$summary_lodging += $lodging;
										@endphp
										{{ ribuanWithComma( $lodging ) }}
									@else
										@php
										$lodging = ($booking_detail->per_item_real + $booking_detail->per_item_tax + $booking_detail->per_item_services);
										$summary_lodging += $lodging;
										@endphp
										{{ ribuanWithComma( $lodging ) }}
									@endif
		                        </td>

								@php
								$total_arrangement = 0;
								@endphp
								{{-- @foreach(config('custom.revenue_groups') as $key => $revenue_group) --}}
		                        <td style="text-align: right">
                                    @php
                                        if (in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11])) {

                                        }else {
                                            if (isset($_GET['excludeBtn'])) {
                                                $summary_arrangement += @$booking_detail->per_item_arr;
                                                $total_arrangement += @$booking_detail->per_item_arr;
                                            }else {
                                                $summary_arrangement+= @$booking_detail->per_item_arr + @$booking_detail->per_item_arr_services + @$booking_detail->per_item_arr_tax;
                                                $total_arrangement += @$booking_detail->per_item_arr + @$booking_detail->per_item_arr_services + @$booking_detail->per_item_arr_tax;
                                            }
                                        }
                                    @endphp
                                    {{@ribuanWithComma(@$total_arrangement)}}
		                        </td>
		                        {{-- @endforeach --}}

		                        <td style="text-align: right">
									@if(isset($_GET['excludeBtn']))
										@php
                                        if (in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11])) {
                                            $summary_total_rate += 0;
                                        }else{
                                            $summary_total_rate += $booking_detail->per_item_real + $total_arrangement;
                                        }
										@endphp
                                        @if (in_array(@$booking_detail->rate_code->segment_ratecode, [10, 11]))
										{{ ribuanWithComma(0) }}
                                        @else
										{{ ribuanWithComma($booking_detail->per_item_real + $total_arrangement) }}
                                        @endif
									@else
										@php
										$summary_total_rate += $booking_detail->per_item;
										@endphp
										{{ ribuanWithComma($booking_detail->per_item) }}
									@endif
		                        </td>
                                <td style="white-space: nowrap;">
                                    {{-- {{ formatDate($booking_detail->checkin ?? $booking_detail->start_date) }}
                                    <br> --}}
                                    {{$booking_detail->checkin_real ? dateFormat($booking_detail->checkin_real, 'd-m-Y H:i:s') : ($booking_detail->checkin ? $booking_detail->checkin->format('d-m-Y H:i:s') : '-')}}
                                </td>
                                <td style="white-space: nowrap;">
                                    {{-- {{ formatDate($booking_detail->checkout ?? $booking_detail->end_date) }}
                                    <br> --}}
                                    {{$booking_detail->checkout_real ? dateFormat($booking_detail->checkout_real, 'd-m-Y H:i:s') : ($booking_detail->checkout ? $booking_detail->checkout->format('d-m-Y H:i:s') : '-')}}
                                </td>
                                <td>
									@if (array_key_exists($booking_detail->booking_id,$invoice_array))
										@if (array_key_exists($booking_detail->room_index,$invoice_array[$booking_detail->booking_id]))
											{{ $invoice_array[$booking_detail->booking_id][$booking_detail->room_index]->no_invoice }}
										@else
											-
										@endif
									@else
										-
									@endif
								</td>
                                <td>{{ $booking->title ? $booking->title.' ' : '' }}{{ $booking->nama }}</td>
                                <td>{{ $booking->company ? @$booking->company->name : ($booking_detail->guest_room ?? $booking->nama) }}{{ $booking->company ? ', '.@$booking->company->comp_title : '' }}</td>
                            </tr>
                            @endforeach
                        {{-- @endforeach --}}
						{{-- <tr>
		                    <td colspan="5" style="text-align: right">SUMMARY</td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                    <td colspan="4"></td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                </tr> --}}
                        <tr>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td style="text-align: right">SUMMARY</td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                            <td></td>
                        </tr>
		                <tr>
                            <td>{{$summary_total_room}}</td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
                            <td></td>
		                    <td>Rp</td>
		                    <td style="text-align: right">{{ ribuanWithComma($summary_room_rate) }}</td>
		                    <td style="text-align: center">{{ ribuanWithComma($summary_pax) }}</td>
		                    <td style="text-align: center">{{ ribuanWithComma($summary_com) }}</td> {{-- Com --}}
		                    <td style="text-align: right">{{ ribuanWithComma($summary_lodging) }}</td> {{-- Lodging --}}

		                    {{-- @foreach(config('custom.revenue_groups') as $key => $revenue_group) --}}
		                    <td style="text-align: right">
		                    {{ ribuanWithComma($summary_arrangement) }}
		                    </td>
		                    {{-- @endforeach --}}

		                    <td style="text-align: right">{{ ribuanWithComma($summary_total_rate) }}</td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                    <td></td>
		                </tr>
                    </tbody>
                </table>
            {{-- </div> --}}
		</div>
		<!-- /hover rows -->

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

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

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

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

@endsection

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

	<script src="{{asset('assets/js/app.js')}}"></script>
	<script src="{{asset('global_assets/js/demo_pages/components_modals.js')}}"></script>
	<script>

		let excludeBtn = {{ isset($_GET['excludeBtn']) ? $_GET['excludeBtn'] : 0 }};
		let total_records = {!! json_encode($summary_total_room) !!};

		$(document).ready(function(){
			if(excludeBtn){
				$('#custom_checkbox_stacked_unchecked').prop('checked', true).val(1);
			}else{
				$('#custom_checkbox')
			}

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

            if (filter_display_type == 2) {
                // 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 == 1){

                // 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: "{{ \Request::get('tanggal') ? formatDate(\Request::get('tanggal')) : date('d-m-Y', strtotime('-1 day', strtotime(formatDate(getSystemDate()))) ) }}",
                    maxDate:"{{ date('d-m-Y', strtotime('-1 day', strtotime(formatDate(getSystemDate()))) ) }}",
                    locale: {
                        format: 'DD-MM-YYYY'
                    }
                });
            }

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

		$('#custom_checkbox_stacked_unchecked').on('change', function(e) {

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

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

            // filter exclude tax and srevices
            let checked = $("#custom_checkbox_stacked_unchecked:checked").length > 0;
            if(checked){
                let custom_checkbox_stacked_unchecked = $(this).val();
                params.delete('excludeBtn');
                params.append('excludeBtn', custom_checkbox_stacked_unchecked);
            }else{
                params.delete('excludeBtn');
            }

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

		console.log(excludeBtn);

        // // Function ketika button download pdf di klik
        // function downloadPDF() {
        //     $('#form_download_pdf').submit()
        // }

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

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

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

            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);
            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);

			// filter exclude tax and srevices
            let checked = $("#custom_checkbox_stacked_unchecked:checked").length > 0;
            if(checked){
                params.delete('excludeBtn');
                params.append('excludeBtn', 1);
            }else{
                params.delete('excludeBtn');
            }

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

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

		var DatatableBasic = function() {

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

		        // Setting datatable defaults
		        $.extend( $.fn.dataTable.defaults, {
		            autoWidth: false,
                    scrollX:true,
		            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;' },
                        info: "Total: " + total_records,
		            }
		        });

		        // Basic datatable
		        $('.datatable-basic').DataTable({
                    "ordering": false,
                    "paging": false,
                    "scrollCollapse": true,
                    "scrollY": '600px'
                });

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

		});

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

            params.delete('filter_display_type');
            params.delete('tanggal');

            params.append('filter_display_type', document.getElementById("filter_display_type").value);
            document.location.href = "?" + params.toString();
        }
	</script>
@endsection