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

@section('title', 'Complimentary Control 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;
    }

    .custom_select .select2-container {
        height: 75px;
        overflow: auto;
    }
</style>
@endsection

@section('content')
    <!-- Page header -->
	<div class="page-header page-header-light">
		<div class="page-header-content header-elements-md-inline">
            <div class="col-md-6">
                <div class="page-title d-flex">
                    <h4>  <span class="font-weight-semibold">Home</span> - Data Complimentary Control Report</h4>
                    <a href="#" class="header-elements-toggle text-default d-md-none"><i class="icon-more"></i></a>
                </div>
            </div>

            <div class="col-md-6 my-3">
                {{-- <div class="d-flex justify-content-end"> --}}
                    <div class="">

                    </div>
                {{-- </div> --}}
            </div>
		</div>
	</div>
	<!-- /page header -->

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

		<!-- Hover rows -->

        <div class="card">
            <div class="card-header font-weight-bold">
                Filter:
            </div>
            <div class="card-body">
                <form class="row" target="_blank" >
                    <!--Filter by Shop-->
                    <div class="col-md-3 custom_select">
                        <span>Shop<span class="text-danger">*</span> : </span>
                        <select name="shops[]"
                                id="shop_multiselect"
                                class="form-control select"
                                multiple="multiple"
                                data-fouc
                        >
                            <option value="">** Select All Shop **</option>
                            @foreach ($in_pos_shops as $shop)
                                <option value="{{$shop->id}}">{{$shop->nama}}</option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-3">
                        <span>Date : </span>
                        <input type="text"
                               name="tanggal"
                               id="tanggal"
                               class="form-control single-daterange" required
                               autocomplete="off"
                        >
                    </div>

                    <div class="col-md-6 mt-3">
                        <button type="submit" class="btn btn-danger" formaction="{{route('complimentary-control-report.cetak-pdf')}}">
                            <i class="far fa-file-pdf"></i>&nbsp;Download PDF
                        </button>
                        <button type="submit" class="btn btn-success" formaction="{{route('complimentary-control-report.cetak-excel')}}">
                            <i class="far fa-file-pdf"></i>&nbsp;Download Excel
                        </button>
                    </div>
                </form>
            </div>
        </div>

        {{-- Room sales --}}
		<div class="card">
            <div class="table-responsive">
                <table class="table table-hover">
                    <thead>
                        <tr>
                            <th class="d-none"></th>
                            <th style="white-space: nowrap; text-align:center; width:100px">Date</th>
                            <th style="width:50px; text-align:left">Outlet/Shop</th>
                            <th style="width:50px; ">No. Bill</th>
                            <th style="width:100px; ">Guest Name</th>
                            <th style="width:100px; ">Description</th>
                            <th style="width:100px; text-align:right">Bill Amount</th>
                            <th style="width:100px; text-align:right">Food Amount</th>
                            <th style="width:100px; text-align:right">Food Cost</th>
                            <th style="width:100px; text-align:right">Beverage Amount</th>
                            <th style="width:100px; text-align:right">Beverage Cost</th>
                            <th style="width:100px; text-align:right">Other Amount</th>
                            <th style="width:100px; text-align:right">Other Cost</th>
                            <th style="width:100px; text-align:right">Cost of Sales</th>
                        </tr>
                    </thead>
                    <tbody>
                        @if(!$shops->isEmpty())
                            {{-- set variable dengan nilai 0 untuk grand total --}}
                            @php
                                // Amount
                                $grand_total_bill_amount = 0;
                                $grand_total_food_amount = 0;
                                $grand_total_beverage_amount = 0;
                                $grand_total_other_amount = 0;

                                // Cost
                                $grand_total_food_cost = 0;
                                $grand_total_beverage_cost = 0;
                                $grand_total_other_cost = 0;
                                $grand_total_cost_of_sales = 0;
                            @endphp

                            {{-- Data Array shops --}}
                            @foreach ($shops as $shop)
                                {{-- set variable dengan nilai 0 untuk total --}}
                                @php
                                    $total_bill_amount = 0;
                                    $total_food_amount = 0;
                                    $total_food_cost = 0;
                                    $total_beverage_amount = 0;
                                    $total_beverage_cost = 0;
                                    $total_other_amount = 0;
                                    $total_other_cost = 0;
                                    $total_cost_of_sales = 0;
                                @endphp

                                {{-- Data Array Cart Resto --}}
                                @foreach (@$shop->carts as $cart)
                                    {{-- set variable dengan nilai 0 --}}
                                    @php
                                        // Amount
                                        $bill_amount = 0;
                                        $food_amount = 0;
                                        $beverage_amount = 0;
                                        $other_amount = 0;

                                        // Cost (complimentary)
                                        $cost_of_sales = 0;
                                        $food_cost = 0;
                                        $beverage_cost = 0;
                                        $other_cost = 0;
                                    @endphp

                                    {{-- Data Array Shop Transactions --}}

                                    @foreach (@$cart->menu as $menu)
                                        {{-- Kalkulasi Amount & cost (complimentary) --}}
                                        @php
                                            if (@$menu->menu->tipeMenu->type_category_id == 1 || @$menu->custom_tipe_kategori == 1) {
                                                $food_amount += $menu->total_biaya;
                                                $food_cost += $menu->grand_total_complimentary;
                                            }

                                            if (@$menu->menu->tipeMenu->type_category_id == 2 || @$menu->custom_tipe_kategori == 2) {
                                                $beverage_amount += $menu->total_biaya;
                                                $beverage_cost += $menu->grand_total_complimentary;
                                            }

                                            if (@$menu->menu->tipeMenu->type_category_id == 3 || @$menu->custom_tipe_kategori == 3) {
                                                $other_amount += $menu->total_biaya;
                                                $other_cost += $menu->grand_total_complimentary;
                                            }

                                            $bill_amount = $food_amount + $beverage_amount + $other_amount;
                                            $cost_of_sales = $food_cost + $beverage_cost + $other_cost;
                                        @endphp
                                    @endforeach

                                    <tr>
                                        <td class="d-none"></td>
                                        <td class="text-center">{{ formatDate($cart->transaction_date) }}</td>
                                        <td>{{ $shop->nama }}</td>
                                        <td>{{ $cart->order_flag }}</td>
                                        <td>{{ $cart->nama_pelanggan}} - {{ @$cart->complimentary->department->name}}</td>
                                        <td>{{ @$cart->coa->description}}</td>
                                        {{-- <td class="text-right">{{ ribuan($bill_amount) }}</td>
                                        <td class="text-right">{{ ribuan($food_amount) }}</td>
                                        <td class="text-right">{{ ribuan($food_cost) }}</td>
                                        <td class="text-right">{{ ribuan($beverage_amount) }}</td>
                                        <td class="text-right">{{ ribuan($beverage_cost) }}</td>
                                        <td class="text-right">{{ ribuan($cost_of_sales) }}</td> --}}
                                        <td class="text-right">{{ ribuanWithComma($bill_amount) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($food_amount) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($food_cost) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($beverage_amount) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($beverage_cost) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($other_amount) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($other_cost) }}</td>
                                        <td class="text-right">{{ ribuanWithComma($cost_of_sales) }}</td>
                                    </tr>

                                    {{-- Kalkulasi total amount & cost(complimentary) --}}
                                    @php
                                        $total_bill_amount += $bill_amount;
                                        $total_cost_of_sales += $cost_of_sales;
                                        $total_food_amount += $food_amount;
                                        $total_beverage_amount += $beverage_amount;
                                        $total_other_amount += $other_amount;
                                        $total_food_cost += $food_cost;
                                        $total_beverage_cost += $beverage_cost;
                                        $total_other_cost += $other_cost;
                                    @endphp
                                @endforeach

                                <tr>
                                    <td colspan="5" class="text-right">Total</td>
                                    {{-- <td class="text-right">{{ ribuan($total_bill_amount) }}</td>
                                    <td class="text-right">{{ ribuan($total_food_amount) }}</td>
                                    <td class="text-right">{{ ribuan($total_food_cost) }}</td>
                                    <td class="text-right">{{ ribuan($total_beverage_amount) }}</td>
                                    <td class="text-right">{{ ribuan($total_beverage_cost) }}</td>
                                    <td class="text-right">{{ ribuan($total_cost_of_sales) }}</td> --}}
                                    <td class="text-right">{{ ribuanWithComma($total_bill_amount) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_food_amount) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_food_cost) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_beverage_amount) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_beverage_cost) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_other_amount) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_other_cost) }}</td>
                                    <td class="text-right">{{ ribuanWithComma($total_cost_of_sales) }}</td>
                                </tr>

                                {{-- Kalkulasi grand total amount & cost(complimentary)  --}}
                                @php
                                    $grand_total_bill_amount += $total_bill_amount;
                                    $grand_total_food_amount += $total_food_amount;
                                    $grand_total_beverage_amount += $total_beverage_amount;
                                    $grand_total_other_amount += $total_other_amount;
                                    $grand_total_food_cost += $total_food_cost;
                                    $grand_total_beverage_cost += $total_beverage_cost;
                                    $grand_total_other_cost += $total_other_cost;
                                    $grand_total_cost_of_sales += $total_cost_of_sales;
                                @endphp
                            @endforeach

                            <tr>
                                <td colspan="5" class="text-right">Grand Total</td>
                                {{-- <td class="text-right">{{ ribuan($grand_total_bill_amount) }}</td>
                                <td class="text-right">{{ ribuan($grand_total_food_amount) }}</td>
                                <td class="text-right">{{ ribuan($grand_total_food_cost) }}</td>
                                <td class="text-right">{{ ribuan($grand_total_beverage_amount) }}</td>
                                <td class="text-right">{{ ribuan($grand_total_beverage_cost) }}</td>
                                <td class="text-right">{{ ribuan($grand_total_cost_of_sales) }}</td> --}}
                                <td class="text-right">{{ ribuanWithComma($grand_total_bill_amount) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_food_amount) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_food_cost) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_beverage_amount) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_beverage_cost) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_other_amount) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_other_cost) }}</td>
                                <td class="text-right">{{ ribuanWithComma($grand_total_cost_of_sales) }}</td>
                            </tr>
                        @else
                            <tr>
                                <td style="text-align:center" colspan="15">
                                    <h4>No Transactions</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) !!}

        // ambil data array shops dari request url
        let array_shops = {!! json_encode(\Request::get('shops') ? explode(',', \Request::get('shops')) : 'Belum Memilih Shop') !!}

        let user_shop_id    = {!! json_encode($user_shop_id) !!}
        let current_shop_id = {!! json_encode(\Request::get('shops') ?? null) !!}
        if(current_shop_id == null) {
            if (user_shop_id) {
                $('#shop_multiselect').val(user_shop_id).prop('disabled', true)
                selectShopID();
            }
        }else if(user_shop_id != null){
            $('#shop_multiselect').prop('disabled', true)
        }

        // init select2
        $('.select').select2({
            minimumResultsForSearch: Infinity
        });

        // Set Value di pilih shop dan pilih user
        $(document).ready(function() {
            $('#shop_multiselect').val(array_shops).trigger('change');
        });

        // ketika multiple select shop di pilih
        $('#shop_multiselect').on('select2:select', function(e) {
            let shops    = $('#shop_multiselect').val();

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

            // menambahkan tanggal pada url
            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);

            // menambahkan shop pada url
            params.delete('shops');
            params.append('shops', shops);

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

        function selectShopID(){
            let shops    = $('#shop_multiselect').val();

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

            // menambahkan tanggal pada url
            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);

            // menambahkan shop pada url
            params.delete('shops');
            params.append('shops', shops);

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

        // ketika multiple select shop Tidak jadi di pilih
        $('#shop_multiselect').on('select2:unselect', function(e) {
            let shops    = $('#shop_multiselect').val();
            let complimentary_checked = $('#complimentary').is(':checked')

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

            // menambahkan tanggal pada url
            params.delete('tanggal');
            params.append('tanggal', document.getElementById("tanggal").value);

            // menambahkan shop pada url
            params.delete('shops');
            params.append('shops', shops);

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

        //Single Date Picker
        $('#tanggal').daterangepicker({
            maxDate:    "{{ formatDate(getSystemDate()) }}",
            startDate:   tanggal[0],
            endDate:    tanggal[1],
            applyClass: 'btn-primary',
            cancelClass: 'btn-light',
            locale: {
                format: 'DD-MM-YYYY'
            }
        });

        // Trigger Ketika Ganti Tanggal Checkin / Checkout
		$('#tanggal').on('apply.daterangepicker', (e, picker) => {
            let newRequest = window.location.search;
            let params = new URLSearchParams(newRequest);

            // Menambahkan request tanggal pada url
            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