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

@section('title', 'Data Guest List Report')

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

    .tebal {
        font-weight:bold;
        font-size:12px;
        background-color: #f2f2f2;
        border-top:1px solid black !important;
        border-bottom:1px solid black !important;
    }
</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 Guest List Report</h4>
				<a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
			</div>

            <div class="print" class="float-right">
                <a href="{{url('reporting/in-house-guest-list-report/cetak-pdf')}}?no_roomrate=1{{ isset($_GET['tanggal']) ? "&tanggal=".$_GET['tanggal'] : ''}}&filter={{ isset($_GET['filter']) ? $_GET['filter'] : ''}}&status={{ isset($_GET['status']) ? $_GET['status'] : ''}}"
				   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/in-house-guest-list-report/cetak-excel')}}?no_roomrate=1{{ isset($_GET['tanggal']) ? "&tanggal=".$_GET['tanggal'] : '' }}&filter={{ isset($_GET['filter']) ? $_GET['filter'] : ''}}&status={{ isset($_GET['status']) ? $_GET['status'] : ''}}" class="btn btn-success"><i class="far fa-file-excel"></i>&nbsp;Download Excel</a>
            </div>
		</div>
	</div>
	<!-- /page header -->

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

		<!-- Hover rows -->

        {{-- Room sales --}}
		<div class="card table-responsive">
            <div class="card-header">
                <div class="row justify-content-start">
                    <div class="period col-sm-2">
                        <p>Period: <input type="text"
                                          id="tanggal"
                                          name="tanggal"
                                          class="form-control single-daterange"
                                          value="{{ date('d-m-Y', strtotime(getSystemDate()) ) }}"
                                          autocomplete="off"
                                          required
                                    >
                        </p>
                    </div>
                    <div class=" col-sm-2">
                        <p>Status:
                            <select name="filter_status" id="filter_status" onchange="filtered()" class="form-control form-control-select2">
                                <option value="">-- Show All Status --</option>
                                <option value="1_1">In House</option>
                                @foreach (config('custom.status_booking') as $key=>$item)
                                    @if (in_array($key,[1,2]))
                                    <option value="{{$key}}">{{$item}}</option>
                                    @endif
                                @endforeach
                            </select>
                        </p>
                    </div>
                    <div class=" col-sm-2">
                        <p>Filter:
                            <select name="filter_inhouse" id="filter_inhouse" onchange="filtered()" class="form-control form-control-select2">
                                <option value="">-- Show All --</option>
                                <option value="1">Breakfast</option>
                                <option value="2">Room Only</option>
                            </select>
                        </p>
                    </div>
                </div>
                {{-- <div class="print" class="float-right">
                    <a href="{{url('reporting/in-house-guest-list-report/cetak-pdf')}}?no_roomrate=1" target="_blank" class="btn btn-danger mr-2">
                        <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                    </a>

                    <a href="{{url('reporting/in-house-guest-list-report/cetak-excel')}}?no_roomrate=1" class="btn btn-success" download><i class="far fa-file-excel"></i>&nbsp;Download Excel</a>
                </div> --}}
            </div>

			<table class="table table-hover">
				<thead>
					<tr>
                        <th>No</th>
                        <th>RmNo</th>
                        <th>RmType/Arrangement</th>
                        {{-- <th>Arrangement</th> --}}
                        <th>Name</th>
                        <th>License plate</th>
                        <th>Rate Code</th>
                        <th>RmRate</th>
						<th>Incl. Breakfast</th>
                        <th>Deposit</th>
                        <th>Night</th>
                        <th>Bill</th>
                        <th>A/Ch</th>
                        <th>ResNo</th>
                        <th>C/I</th>
                        <th>C/O</th>
                        <th>Email</th>
                        <th>Nat</th>
                        <th>Company/TA</th>
                        <th>Segment</th>
                    </tr>
				</thead>
				<tbody>
                    @php
                        $no = 1;
						$total_breakfast = 0;
						$total_room_have_breakfast = 0;
                    @endphp
                    @if (count($guests) > 0)
						@foreach($guests as $key => $id_guests)
                            @foreach ($id_guests as $guest)

                                {{-- cek data --}}
                                {{-- @php
                                $tanggal = date('Y-m-d', strtotime(getSystemDate()) );
                                if (app('request')->input('tanggal')) {
                                    $tanggal = date('Y-m-d', strtotime(app('request')->input('tanggal')));
                                }
                                    $datenow = date('Y-m-d', strtotime($guest['detail']->date_now));
                                    $datenowbefore = date('Y-m-d', strtotime('-1 day', strtotime($tanggal)));
                                    $datecheckout = date('Y-m-d', strtotime($guest['detail']->booking->end_date));
                                @endphp
                                --}}
                                {{-- {{$key}} <br>
                                nama {{$guest['guest']->nama}} <br>
                                tg bd {{$datenow}} <br>
                                tg bd before {{$datenowbefore}} <br>
                                co {{$datecheckout}} <br>
                                tg {{$tanggal}} <br>
                                @if ($datecheckout > $tanggal)
                                    @if ($datenow >= $datenowbefore)
                                    checkout {{$datecheckout}} lebih dari datenow : {{$tanggal}} <br>
                                    @continue

                                    @endif
                                @endif --}}

                                <tr style="white-space: nowrap;">
                                    <td>{{$no}}</td>
                                    <td>{{$guest['roomcurrent']}}</td>
                                    <td>
                                        {{
                                            array_key_exists($guest['detail']->jns_kamar, $roomtag)
                                            ?
                                            ($roomtag[$guest['detail']->jns_kamar] == "" ? initial($guest['detail']->jns_kamar) : $roomtag[$guest['detail']->jns_kamar]) : initial($guest['detail']->jns_kamar)
                                        }}/{{$guest['detail']->arrangement_codes}}
                                    </td>
                                    {{-- <td>{{$guest['detail']->arrangement_codes}}</td> --}}
                                    <td>
                                        {{-- {{strtoupper($guest['guest']->title)}} --}}
                                        {{$guest['detail']->guest_room}}</td>

                                    <td>{{$guest['guest']->plat_nomor ?? '-'}}</td>
                                    <td>{{$guest['detail']->rate_codes}}</td>
                                    <td>{{ribuan($guest['detail']->per_item)}}</td>
                                    <td>
                                        {!!
                                            array_key_exists($guest['detail']->arrangement_id, $room_breakfast)
                                            ?
                                            ($room_breakfast[$guest['detail']->arrangement_id] == "" ? '-' : '<b>Yes</b>') : '-'
                                        !!}
                                        @if(array_key_exists($guest['detail']->arrangement_id, $room_breakfast))
                                            @if($room_breakfast[$guest['detail']->arrangement_id] != "")
                                                @php
                                                $total_room_have_breakfast += 1
                                                @endphp
                                            @endif
                                        @endif
                                    </td>
                                    <td>{{($guest['invoice_payment']?ribuanWithComma($guest['invoice_payment']) :'-') ?? '-'}}</td>
                                    <td>{{($guest['night']? ribuanWithComma($guest['night']) :' ') ?? ' '}} Night</td>
                                    <td>{{($guest['invoice_bill']? ribuanWithComma($guest['invoice_bill']) :'-') ?? '-'}}</td>
                                    <td>
                                        {{$guest['detail']->pax}}/{{$guest['guest']->jml_anak}}
                                        @if(array_key_exists($guest['detail']->arrangement_id, $room_breakfast))
                                            @if($room_breakfast[$guest['detail']->arrangement_id] != "")
                                                @php
                                                $total_breakfast += $guest['detail']->pax
                                                @endphp
                                            @endif
                                        @endif
                                    </td>
                                    <td>{{$guest['guest']->kode_booking}}</td>
                                    <td style="white-space: nowrap;">
                                        {{$guest['detail']->checkin_real ? dateFormat($guest['detail']->checkin_real, 'd-m-Y') : ($guest['detail']->checkin ? $guest['detail']->checkin->format('d-m-Y') : '-')}}
                                        <br>
                                        {{$guest['detail']->checkin_real ? dateFormat($guest['detail']->checkin_real, 'H:i:s') : ($guest['detail']->checkin ? $guest['detail']->checkin->format('H:i:s') : null)}}
                                    </td>
                                    <td style="white-space: nowrap;">
                                        {{$guest['detail']->checkout_real ? dateFormat($guest['detail']->checkout_real, 'd-m-Y') : ($guest['detail']->checkout ? $guest['detail']->checkout->format('d-m-Y') : '-')}}
                                        <br>
                                        {{$guest['detail']->checkout_real ? dateFormat($guest['detail']->checkout_real, 'H:i:s') : ($guest['detail']->checkout ? $guest['detail']->checkout->format('H:i:s') : null)}}
                                    </td>

                                    <td>{{$guest['guest']->email}}</td>
                                    <td>{{$guest['guest']->kewarganegaraan}}</td>
                                    <td>{{$guest['guest']->company ? $guest['guest']->company->name : ($guest['guest']->segmentasi_rate_code == 7 ? '[WALK IN GUEST]' : '[INDIVIDUAL RESERVATION]')}}</td>
                                    <td><b>{{config('custom.segment_ratecodes')[$guest['detail']->segment_rate_code_drop_id]}}</b></td>
                                </tr>
                                @php $no++; @endphp
                            @endforeach
						@endforeach
					<tr>
						<td></td>
						<td></td>
						<td></td>
						<td></td>
                        <td></td>
						<td></td>
                        <td style="white-space:nowrap;"><small>Total Breakfast | Room/Pax</small></td>
						<td>{{$total_room_have_breakfast}}/{{$total_breakfast}}</td>


						@if(null === $no_roomrate)
						@endif

						<td colspan="5"></td>

						<td></td>
						<td></td>
						<td></td>
						<td></td>
						<td></td>
						<td></td>
					</tr>
                    @else
                    <tr>
                        <td style="text-align:center" colspan="{{ null === $no_roomrate ? '16' : '15' }}">
                            <h4>No Data</h4>
                        </td>
                    </tr>
                    @endif
				</tbody>
			</table>
		</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>
		//Data Filter
		// Ambil Data Filter Tanggal
		let tanggal = "{{ \Request::get('tanggal') ?? date('d-m-Y', strtotime(getSystemDate())) }}";

		// Ambil Data Filter Tanggal
		let filter = "{{ \Request::get('filter') }}";
		let status = "{{ \Request::get('status') }}";
        if (filter) {
            $("#filter_inhouse").val(filter).select2();
        }

        if (status) {
            $("#filter_status").val(status).select2();
        }


		// URL Export PDF dan URL Export Excel
		let base_url_pdf = "{{ url('reporting/in-house-guest-list-report/cetak-pdf') }}?no_roomrate=1";

        //Single Date Picker
        $('.single-daterange').daterangepicker({
            singleDatePicker: true,
            showDropdowns: true,
            applyClass: 'btn-primary',
            cancelClass: 'btn-light',
            startDate: "{{ \Request::get('tanggal') ? date('d-m-Y', strtotime(\Request::get('tanggal')) ) : date('d-m-Y', strtotime(getSystemDate()) ) }}",
            maxDate:"{{ date('d-m-Y', strtotime(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);

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

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

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

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

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

            params.delete('status');
            params.append('status', document.getElementById("filter_status").value);
            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,
		            columnDefs: [{
		                orderable: false,
		                width: 150,
		                targets: [15]
		            }],
		            dom: '<"datatable-header"fl><"datatable-scroll"t><"datatable-footer"ip>',
		            language: {
		                search: '<span>Filter:</span> _INPUT_',
		                searchPlaceholder: 'Type to filter...',
		                lengthMenu: '<span>Show:</span> _MENU_',
		                paginate: { 'first': 'First', 'last': 'Last', 'next': $('html').attr('dir') == 'rtl' ? '&larr;' : '&rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr;' : '&larr;' }
		            }
		        });

		        // Basic datatable
		        $('.datatable-basic').DataTable({
                    paging: false,
                    bFilter: false
                });

		        // Alternative pagination
		        $('.datatable-pagination').DataTable({
		            pagingType: "simple",
		            language: {
		                paginate: {'next': $('html').attr('dir') == 'rtl' ? 'Next &larr;' : 'Next &rarr;', 'previous': $('html').attr('dir') == 'rtl' ? '&rarr; Prev' : '&larr; Prev'}
		            }
		        });

		        // Datatable with saving state
		        $('.datatable-save-state').DataTable({
		            stateSave: true
		        });

		        // Scrollable datatable
		        var table = $('.datatable-scroll-y').DataTable({
		            autoWidth: true,
		            scrollY: 300
		        });

		        // Resize scrollable table when sidebar width changes
		        $('.sidebar-control').on('click', function() {
		            table.columns.adjust().draw();
		        });
		    };

		    // Select2 for length menu styling
		    var _componentSelect2 = function() {
		        if (!$().select2) {
		            console.warn('Warning - select2.min.js is not loaded.');
		            return;
		        }

		        // Initialize
		        $('.dataTables_length select').select2({
		            minimumResultsForSearch: Infinity,
		            dropdownAutoWidth: true,
		            width: 'auto'
		        });
		    };


		    //
		    // Return objects assigned to module
		    //

		    return {
		        init: function() {
		            _componentDatatableBasic();
		            _componentSelect2();
		        }
		    }
		}();


		// Initialize module
		// ------------------------------

		document.addEventListener('DOMContentLoaded', function() {
		    DatatableBasic.init();
		});
	</script>
	<script type="text/javascript">
		$( document ).ready(function() {
	        // Default style
	        @if(session('error'))
	            new PNotify({
	                title: 'Error',
	                text: '{{ session('error') }}.',
	                icon: 'icon-blocked',
	                type: 'error'
	            });
            @endif
            @if ( session('success'))
	            new PNotify({
	                title: 'Success',
	                text: '{{ session('success') }}.',
	                icon: 'icon-checkmark3',
	                type: 'success'
	            });
            @endif

		});
	</script>
@endsection