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

@section('title', 'FO Payment Journal By User')

@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 FO Payment Journal By User</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/fo-payment-journal-by-user/cetak-pdf')}}" target="_blank" class="btn btn-danger mr-2" id="btn-pdf">
                    <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                </a>
                <a href="{{url('reporting/fo-payment-journal-by-user/cetak-excel')}}" class="btn btn-success" id="btn-excel">
                    <i class="far fa-file-excel"></i>&nbsp;Download Excel
                </a>
            </div>
		</div>
	</div>
	<!-- /page header -->

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

		<!-- Hover rows -->
		<div class="card">
			<div class="card-body">
				<div class="row justify-content-center">

					<div class="col-md-3">
						<div class="form-group">
							<label for="filter_date_range" class="font-weight-bolder">Date:</label>
							<input type="text" name="filter_date_range" id="filter_date_range" class="form-control single-daterange">
						</div>
					</div>
					<div class="col-md-3">
						<div class="form-group">
							<label for="user_id" class="font-weight-bolder">User:</label>
							<select name="user_ids[]" id="user_id"
									class="form-control select"
									multiple="multiple"
									data-fouc
							>
								<option value="">** All User **</option>
								@foreach($users as $user)
								<option value="{{$user->id}}">{{$user->nama}}</option>
								@endforeach
							</select>
						</div>
					</div>
                    <div class="col-md-3">
                        <div class="form-group">
							<label for="filter" class="font-weight-bolder">Filter:</label>
                            <select name="filter"
                                    id="filter"
                                    class="form-control ml-1 form-control-select2"
                            >
                                <option value="">All</option>
                                @foreach(config('custom.jenis_pembayaran') as $key => $value)
                                    {{-- @if (in_array($key, [6,7,8]))
                                        @continue
                                    @endif --}}
                                    @if (in_array($key, [5]))
                                        <optgroup id="custom_filter" label="-- Ledger --">
                                            <option value="5-city">City Ledger</option>
                                            <option value="5-company">Company Ledger</option>
                                        </optgroup>
                                        @continue
                                    @endif
                                    <option value="{{$key}}">{{$value}}</option>
                                @endforeach
                            </select>
						</div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label for="shift" class="font-weight-bolder">Shift:</label>
                            <select name="shift" id="shift" class="form-control ml-1 form-control-select2">
                                <option value="">All</option>
                                @foreach($shiftFOs as $shiftFO)
								    <option value="{{$shiftFO->id}}">{{$shiftFO->shift}} ({{$shiftFO->tanggal_shift->format('d-m-Y')}})</option>
								@endforeach
                            </select>
                        </div>
                    </div>

				</div>
			</div>
		</div>

        {{-- Room sales --}}
		<div class="card table-responsive">
            <div class="card-header header-elements-inline">
                <div class="period">
                    <p>Period: {{$periode}}</p>
                </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 class="d-none">Number</th>
                        <th>Date</th>
                        <th style="width:30px; text-align:right">Room Number</th>
                        <th style="width:50px; text-align:right">Bill Number</th>
                        <th>Payment Method</th>
                        <th>Platform</th>
                        <th>Voucher</th>
                        <th>Shift</th>
                        <th>Department</th>
                        <th style="text-align:right">Local Amount</th>
                        <th>Guest Name</th>
                        <th style="width:45px">Time</th>
                    </tr>
				</thead>
				<tbody>
                    @php
                    $no = 1;
                    $grandtotal_qty = 0;
                    $grandtotal_amount = 0;
                    $summary = array();
                    @endphp

                    @if(count($transactions) > 0)
                        @foreach($transactions as $key_user => $group_users)
                            <tr>
                                <td class="d-none"></td>
                                <td >User: {{$group_users['user']->nama}}</td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                            </tr>
                            @foreach($group_users['data'] as $group_date => $group_metode)

								@foreach($group_metode as $key => $datas)
									@php
									$total_qty = 0;
									$total_amount = 0;
									@endphp

									@foreach($datas as $data)
	                                    <!-- Jika Transaksi Dari Deposit -->
	                                    @if($data->jenis_deposit)
	                                    <tr>
	                                        <td class="d-none"></td>
	                                        <td>{{$data->transaction_date->format('d-m-Y')}}</td>
	                                        <td style="text-align: right">{{@$invoice_array[$data->booking_id][$data->room_index]->nomor_kamar}}</td>
	                                        <td style="text-align: right">{{@$invoice_array[$data->booking_id][$data->room_index]->no_invoice ?? @$data->folioDummy->no_bill}}</td>
	                                        <td>{{ $data->jenis_deposit != 5 ? @config('custom.jenis_pembayaran')[$data->jenis_deposit] : @config('custom.jenis_pembayaran')[$data->jenis_deposit] }} (Payment / Deposit)</td>
	                                        <td>{{ @$data->platform->nama }}</td>
	                                        <td>{{ @$data->voucher }}</td>
                                            <td>{{ @$data->shiftFO->shift ? @$data->shiftFO->shift : "-" }}</td>
	                                        <td>FRONT OFFICE</td>
	                                        <td style="text-align: right">
	                                            @php
                                                if ($data->jenis_transaksi == 0) {
                                                    $total_amount += $data->nominal;
												    $grandtotal_amount += $data->nominal;
                                                }else {
                                                    $total_amount -= $data->nominal;
                                                    $grandtotal_amount -= $data->nominal;
                                                }
	                                            @endphp

												{{ ribuanWithComma(($data->jenis_transaksi == 0 ? 1 : -1) * ($data->nominal)) }}
	                                        </td>
	                                        <td>{{@$data->booking->nama ?? @$data->folioDummy->guestProfile->name}}</td>
	                                        <td>{{$data->created_at->format('H:i:s')}}</td>
	                                    </tr>
	                                    @endif

	                                    <!-- Jika Transaksi Dari Pembayaran -->
	                                    @if($data->jenis_pembayaran_id)
	                                    <tr>
	                                        <td class="d-none"></td>
	                                        <td>{{$data->transaction_date->format('d-m-Y')}}</td>
	                                        <td style="text-align: right">{{@$data->invoice->nomor_kamar}}</td>
	                                        <td style="text-align: right">{{@$data->invoice->no_invoice}}</td>
	                                        <td>{{ $data->jenis_pembayaran_id != 5 ? @config('custom.jenis_pembayaran')[$data->jenis_pembayaran_id] : @config('custom.jenis_pembayaran')[$data->jenis_pembayaran_id] }} {{$data->tipe_pembayaran == 2 ? '(Refund)' : '(Settlement)'}}</td>
	                                        <td>{{ @$data->platformPembayaran->nama }}</td>
	                                        <td>{{ @$data->voucher }}</td>
                                            <td>{{ @$data->shiftFO->shift ? @$data->shiftFO->shift : "-" }}</td>
	                                        <td>FRONT OFFICE</td>
	                                        <td style="text-align: right">
	                                            @php
	                                            if($data->tipe_pembayaran == 1){
	                                                $total_amount -= $data->nominal;
	                                                $grandtotal_amount -= $data->nominal;
	                                            }
	                                            else{
	                                                $total_amount += $data->nominal;
	                                                $grandtotal_amount += $data->nominal;
	                                            }
	                                            @endphp

	                                            @if($data->tipe_pembayaran == 1)
	                                            {{ ribuanWithComma(-1 * $data->nominal) }}
	                                            @else
	                                            {{ ribuanWithComma($data->nominal) }}
	                                            @endif

	                                        </td>
	                                        <td>{{@$data->booking->nama}}</td>
	                                        <td>{{$data->created_at->format('H:i:s')}}</td>
	                                    </tr>
	                                    @endif

	                                @endforeach
	                                <tr style="border-top: 2px solid #ddd;background-color:#f2f2f2">
	                                    <td class="d-none"></td>
	                                    <td></td>
	                                    <td></td>
	                                    <td></td>
	                                    <td></td>
	                                    <td></td>
	                                    <td></td>
	                                    <td></td>
	                                    <td style="font-weight: bold;">TOTAL</td>
	                                    <td style="text-align: right; font-weight: bold">
	                                        {{ ribuanWithComma($total_amount) }}
	                                        @php
	                                        $summary[$key] = $total_amount;
	                                        @endphp
	                                    </td>
	                                    <td></td>
	                                    <td></td>
	                                </tr>
								@endforeach

                            @endforeach
                        @endforeach
                    @else
                    <tr>
                        <td style="text-align:center" colspan="10">
                            <h4>Tidak Ada Transaksi Hari Ini</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') ?? $periode }}";
		//Ambil Data Filter User ID
		let array_user_ids = {!! json_encode(\Request::get('userid') ? explode(',', \Request::get('userid')) : '') !!}

        //Ambil Data Filter
		let select_filter = {!! json_encode(\Request::get('filter') ? explode(',', \Request::get('filter')) : '') !!}

		let select_shift = {!! json_encode(\Request::get('shift') ? explode(',', \Request::get('shift')) : '') !!}

		//URL Export PDF dan URL Export Excel
		let base_url_pdf = "{{url('reporting/fo-payment-journal-by-user/cetak-pdf')}}";
		let base_url_excel = "{{url('reporting/fo-payment-journal-by-user/cetak-excel')}}";

		//Ketika Multiple Select User Dipilih
		$('#user_id').on('select2:select', function(e){
			let user_ids = $(this).val();

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

			//Filter Tanggal
			params.delete('tanggal');
			params.append('tanggal', document.getElementById('filter_date_range').value);

			//Filter article
			params.delete('userid');
			params.append('userid', user_ids);

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

		//Ketika Multiple Select User Dihapus
		$('#user_id').on('select2:unselect', function(e) {
            let user_ids    = $(this).val();

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

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

            // filter article
            params.delete('userid');
            params.append('userid', user_ids);

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

        $('#filter').on('change', function (e) {
            let filter    = $(this).val();

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

            // filter article
            params.delete('filter');
            params.append('filter', filter);

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

        $('#shift').on('change', function (e) {
            let shift    = $(this).val();

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

            // filter article
            params.delete('shift');
            params.append('shift', shift);

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

		//Set User ID ketika dipilih
		$(document).ready(function(){
			$('#user_id').val(array_user_ids).trigger('change');
			$('#filter').val(select_filter).select2();
			$('#shift').val(select_shift).select2();

			//Replace PDF URL Download\
			let export_pdf_request = base_url_pdf.search;
			let export_pdf_params = new URLSearchParams(export_pdf_request);
			//--Tambah Filter Tanggal
			export_pdf_params.delete('tanggal');
			export_pdf_params.append('tanggal', document.getElementById("filter_date_range").value);
			//--Tambah Filter USer ID
			export_pdf_params.delete('userid');
			export_pdf_params.append('userid', array_user_ids);
            //--Tambah Filter ledger
            export_pdf_params.delete('filter');
			export_pdf_params.append('filter', document.getElementById("filter").value);
			base_url_pdf += "?" + export_pdf_params.toString();
			$('#btn-pdf').attr('href', base_url_pdf);

			// Replace Excel URL Download
			let export_excel_request = base_url_pdf.search;
			let export_excel_params = new URLSearchParams(export_excel_request);
			//--Tambah Filter Tanggal
			export_excel_params.delete('tanggal');
			export_excel_params.append('tanggal', document.getElementById("filter_date_range").value);
			// --Tambah Filter User ID
			export_excel_params.delete('user_id');
			export_excel_params.append('user_id', array_user_ids);
            //--Tambah Filter ledger
			export_excel_params.delete('filter');
			export_excel_params.append('filter', document.getElementById("filter").value);
			base_url_excel += "?" + export_excel_params.toString();
			$('#btn-excel').attr('href', base_url_excel);

            // toogleOption('')//toogle disable lodgin atau roomcharge
		});

		$('#filter_date_range').on('apply.daterangepicker', (e, picker) => {
            let user_ids = $('#user_id').val();

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

            params.delete('shift');
            $('#shift').val('').select2();

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

            // Filter Article
            params.delete('userid');
            params.append('userid', user_ids);

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

		//Select 2 Multiple Selection
		$('.select').select2({
            minimumResultsForSearch: Infinity
        });

        //Single Date Picker
        $('.single-daterange').daterangepicker({
            // singleDatePicker: true,
            showDropdowns: true,
            applyClass: 'btn-primary',
            cancelClass: 'btn-light',
            startDate: "{{ $start_date }}",
			endDate: "{{ $end_date }}",
            maxDate:"{{ date( 'd-m-Y', strtotime('-0 day', strtotime(getSystemDate()) ) ) }}",
            locale: {
            	format: 'DD-MM-YYYY'
            }
        });

		//Filter Daterange
		// $('#filter_date_range').daterangepicker(
		// 	maxDate: "{{ formatDate(getSystemDate()) }}",
		// 	startDate:
		// );

        // 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
                });

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