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

@section('title', 'Booking Journal By Bill Number')

@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;
    }
    .font_head_title_column{
        font-size: 14px;
    }
</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 Booking Journal By Bill Number</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">
                    <form method="post" target="_blank" id="form_download_pdf">
                        @csrf
                        <input type="text"
                               name="tanggal"
                               id="tanggal"
                               class="form-control single-daterange" required
                               autocomplete="off"
                        >
                        <button type="submit" class="btn btn-danger ml-2" formaction="{{ route('report.booking-journal-by-billno') }}">
                            <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                        </button>
                        <button type="submit" class="btn btn-success ml-2" formaction="{{ route('report.excel-booking-journal-by-billno') }}">
                            <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 header-elements-inline">
                {{-- <div class="form-inline">
                    <form method="post" target="_blank" action="{{ route('report.booking-journal-by-billno') }}" 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 table-responsive">
                <table class="table datatable-basic table-hover">
                    <thead>
                        <tr class="font_head_title_column">
                            <th style="text-align:center" class="d-none">no</th>
                            <th style="text-align:center">Date</th>
                            <th style="text-align:center">Room No</th>
                            <th>No. Bill</th>
                            <th>Department</th>
                            <th>Description</th>
                            <th style="text-align:center">Qty</th>
                            <th style="text-align:right">Sales</th>
                            <th style="text-align:right">Payment</th>
                            <th style="text-align:center">Time</th>
                            <th>GuestName</th>
                        </tr>
                    </thead>
                    <tbody>
                        @if(count($bills) > 0)
                            @php
                            $total_qty = 0;
                            $total_sales = 0;
                            $total_payment = 0;
                            @endphp

                            @foreach($bills as $bill)
                                @foreach($bill as $key => $item_bill)
                                    <!-- Jika Data Yang Difetch Roomrate -->
                                    @if($item_bill->booking_detail_id)
                                    <tr>
                                        <td class="d-none">&nbsp;</td>
                                        <td style="text-align: center">{{ formatDate($item_bill->date) }}</td>
                                        <td style="text-align: center">{{ $item_bill->room_no }}</td>
                                        @if($item_bill->folio_dummy_id)
                                        <td>{{ @$item_bill->foliodummy->no_bill }}</td>
                                        @else
                                        <td>{{ @$item_bill->invoice->no_invoice }}</td>
                                        @endif
                                        <td>FO</td>
                                        <td>{{ $item_bill->description }}</td>
                                        <td style="text-align: center">{{ $item_bill->qty }}</td>
                                        <td style="text-align: right">{{ ribuanWithComma($item_bill->total) }}</td>
                                        <td style="text-align: right">0</td>
                                        <td style="text-align: center">{{ $item_bill->created_at ? $roomrate->created_at->format('H:i:s') : '' }}</td>
                                        @if($item_bill->folio_dummy_id)
                                        <td>{{ @$item_bill->foliodummy->guestProfile->name }}</td>
                                        @else
                                        <td>{{ @$item_bill->invoice->nama_pelanggan }}</td>
                                        @endif
                                    </tr>
                                        @php
                                        $total_qty += $item_bill->qty;
                                        $total_sales += $item_bill->total;
                                        $total_payment += 0;
                                        @endphp
                                    @endif

                                    <!-- Jika Data Yang Difetch Shop Transaction -->
                                    @if($item_bill->menu_id)
                                    <tr>
                                        <td class="d-none">&nbsp;</td>
                                        <td style="text-align: center">{{ formatDate($item_bill->transaction_date) }}</td>
                                        <td style="text-align: center">{{ @$item_bill->kamar->no_kamar }}</td>
                                        <td>{{ @$item_bill->main_invoice->no_invoice }}</td>
                                        <td>FO</td>
                                        <td>{{ @$item_bill->menu->nama }}</td>
                                        <td style="text-align: center">{{ $item_bill->jenis_transaksi == 1 ? '' : '-' }}{{ $item_bill->jumlah }}</td>
                                        <td style="text-align: right">{{ $item_bill->jenis_transaksi == 1 ? '' : '-' }}{{ ribuanWithComma($item_bill->grand_total) }}</td>
                                        <td style="text-align: right">0</td>
                                        <td style="text-align: center">{{ $item_bill->created_at ? $item_bill->created_at->format('H:i:s') : '' }}</td>
                                        <td>{{ @$item_bill->main_invoice->nama_pelanggan }}</td>
                                    </tr>
                                        @php
                                        if ($item_bill->jenis_transaksi == 1) {
                                            $total_qty += $item_bill->jumlah;
                                            $total_sales += $item_bill->grand_total;
                                            $total_payment += 0;
                                        }else {
                                            $total_qty -= $item_bill->jumlah;
                                            $total_sales -= $item_bill->grand_total;
                                            $total_payment -= 0;
                                        }
                                        @endphp
                                    @endif

                                    <!-- Jika Data Yang Difetch Bill POS -->
                                    @if($item_bill->cart_id)
                                    <tr>
                                        <td class="d-none">&nbsp;</td>
                                        <td style="text-align: center">{{ formatDate($item_bill->transaction_date) }}</td>
                                        <td style="text-align: center">{{ @$invoice_array[$item_bill->booking_id][$item_bill->room_index]->nomor_kamar }}</td>
                                        <td>{{ @$invoice_array[$item_bill->booking_id][$item_bill->room_index]->no_invoice }}</td>
                                        <td>POS</td>
                                        <td>Outlet Bill : {{ @$item_bill->cart->order_flag }}</td>
                                        <td style="text-align: center">1</td>
                                        <td style="text-align: right">{{ ribuanWithComma($item_bill->nominal) }}</td>
                                        <td style="text-align: right">0</td>
                                        <td style="text-align: center">{{ $item_bill->created_at ? $item_bill->created_at->format('H:i:s') : '' }}</td>
                                        <td>{{ @$item_bill->main_invoice->nama_pelanggan }}</td>
                                    </tr>
                                        @php
                                        $total_qty += $item_bill->jumlah;
                                        $total_sales += $item_bill->nominal;
                                        $total_payment += 0;
                                        @endphp
                                    @endif

                                    <!-- Jika Data Yang Difetch Booking Deposit -->
                                    @if($item_bill->jenis_deposit)
                                    <tr>
                                        <td class="d-none">&nbsp;</td>
                                        <td style="text-align: center">{{ formatDate($item_bill->transaction_date) }}</td>
                                        <td style="text-align: center">{{ @$invoice_array[$item_bill->booking_id][$item_bill->room_index]->nomor_kamar }}</td>
                                        <td>{{ @$invoice_array[$item_bill->booking_id][$item_bill->room_index]->no_invoice }}</td>
                                        <td>FO</td>
                                        <td>Pembayaran {{ @config('custom.jenis_deposit')[$item_bill->jenis_deposit].' '.$item_bill->bank }} A.N. {{ $item_bill->nama }}</td>
                                        <td style="text-align: center">{{ $item_bill->jenis_transaksi == 1 ? '' : '-' }}1</td>
                                        <td style="text-align: right">0</td>
                                        <td style="text-align: right">{{ $item_bill->jenis_transaksi == 1 ? '-' : '' }}{{ ribuanWithComma($item_bill->nominal) }}</td>
                                        <td style="text-align: center">{{ $item_bill->created_at ? $item_bill->created_at->format('H:i:s') : '' }}</td>
                                        <td>{{ @$item_bill->booking->nama }}</td>
                                    </tr>
                                        @php
                                        if ($item_bill->jenis_transaksi == 1) {
                                            $total_qty += 1;
                                            $total_sales += 0;
                                            $total_payment -= $item_bill->nominal;
                                        }else {
                                            $total_qty -= 1;
                                            $total_sales -= 0;
                                            $total_payment += $item_bill->nominal;
                                        }
                                        @endphp
                                    @endif

                                    <!-- Jika Data Yang Difetch Pembayaran Pelunasan -->
                                    @if($item_bill->jenis_pembayaran_id)
                                    <tr>
                                        <td class="d-none">&nbsp;</td>
                                        <td style="text-align: center">{{ formatDate($item_bill->transaction_date) }}</td>
                                        <td style="text-align: center">{{ @$item_bill->invoice->nomor_kamar }}</td>
                                        <td>{{ @$item_bill->invoice->no_invoice }}</td>
                                        <td>FO</td>
                                        <td>{{$item_bill->tipe_pembayaran == 1 ? 'Pembayaran' : 'Refund'}} {{ config('custom.jenis_pembayaran')[$item_bill->jenis_pembayaran_id].' '.$item_bill->bank }} A.N. {{ @$item_bill->booking->nama }}</td>
                                        <td style="text-align: center">1</td>
                                        <td style="text-align: right">0</td>
                                        <td style="text-align: right">{{$item_bill->tipe_pembayaran == 1 ? '-' : ''}}{{ ribuanWithComma($item_bill->nominal) }}</td>
                                        <td style="text-align: center">{{ $item_bill->created_at ? $item_bill->created_at->format('H:i:s') : '' }}</td>
                                        <td>{{ @$item_bill->booking->nama }}</td>
                                    </tr>
                                        @php
                                        if($item_bill->tipe_pembayaran == 1){
                                            $total_qty += 1;
                                            $total_sales += 0;
                                            $total_payment -= $item_bill->nominal;
                                        }
                                        else{
                                            $total_qty += 1;
                                            $total_sales += 0;
                                            $total_payment += $item_bill->nominal;
                                        }
                                        @endphp
                                    @endif
                                @endforeach
                            @endforeach
                            <tr style="font-weight: bolder">
                                <td class="d-none">&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                                <td style="text-align: right">TOTAL</td>
                                <td style="text-align: center">{{ribuanWithComma($total_qty)}}</td>
                                <td style="text-align: right">{{ribuanWithComma($total_sales)}}</td>
                                <td style="border-right: 0px; text-align: right">{{ribuanWithComma($total_payment)}}</td>
                                <td>&nbsp;</td>
                                <td>&nbsp;</td>
                            </tr>
                        @else
                            <tr>
                                <td style="text-align:center" colspan="15">
                                    <h4>NO DATA</h4>
                                </td>
                            </tr>
                        @endif
                    </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 -->

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

@endsection

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

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

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

        //Single Date Picker
        $('.single-daterange').daterangepicker({
            maxDate:    "{{ formatDate(getSystemDate()) }}",
            startDate:   tanggal[0],
            endDate:    tanggal[1],
            opens: "left",
            applyClass: 'btn-primary',
            cancelClass: 'btn-light',
            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);
            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: [ 10 ]
		            }],
		            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,
                    bSortable: false,// disable sort table
                });

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