@extends('layouts.main-layout')
@section('title')
History Report | Dashboard
@endsection

@section('styles')

{{-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.8.1/css/bootstrap-select.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.8.1/js/bootstrap-select.js"></script> --}}

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.13.1/css/bootstrap-select.css" />
@endsection

@section('content')
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
    <!--begin::Post-->
    <div class="post d-flex flex-column-fluid" id="kt_post">
        <!--begin::Container-->
        <div id="kt_content_container" class="container-xxl">
            <div class="card mb-5 mb-xl-8">

                <!--begin::Header-->
                <div class="card-header border-0 pt-5">
                    <p class="alert alert-success" id="msg" style="display: none;"></p>
                    <h3 class="card-title atrgn-items-start flex-column">
                        <span class="text-center card-label fw-bolder fs-3 mb-1">History Report</span>

                    </h3>


                </div>



                <div class="card-body py-3">
          <div class="row">
            <div class="col-md-12">
              <div class="grid simple">
                <div class="grid-title no-border">
                  <h4>Date <span class="semi-bold">Controls</span></h4>

                </div>

                <form action="{{route('admin.occupancy.reports')}}" method="get" class="grey lighten-4 ">
                  <div class="row">

                    <div class="col-md-6">

                        <input type="date" class="form-control" datePickerId name='start_date'>

                      </div>


                    <div class="col-md-6">
                    <input type="date" class="form-control" datePickerId name='end_date'>
                    </div>
                </div>

                <div class="row mt-5">

                    <div class="col-md-4">
                        <select class="form-select" name="source" id="source" tabindex="-1">
                            <option disabled selected="">Source</option>
                            <option value="website">Website</option>
                            <option value="email">Email</option>
                            <option value="telephone">Telephone</option>
                            <option value="walk_in">Walk In</option>
                        </select>
                    </div>

                    {{-- <div class="col-md-4">
                        <select name="country_name" id="country_name">
                            <option disabled selected>Select Country</option>
                            @foreach ($countries as $country)
                            <option value="{{ $country->CountryId }}">{{ $country->CountryName }}</option>
                       @endforeach
                        </select>
                    </div> --}}

                    {{-- <div class="col-md-4">
                        <select name="city[]" id="city" multiple data-live-search="true">
                            <option disabled selected>Select City</option>
                        </select>
                    </div> --}}

                    <div class="col-md-4">
                        <select name="company" class="form-select">
                            <option disabled selected>Choose Company</option>
                            @foreach ($companies as $company)
                                 <option value="{{ $company->CompanyId }}">{{ $company->CompanyName }}</option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-4">
                        <select name="travel_agent" id="travel_agent" tabindex="-1" class="form-select">
                            <option disabled selected>Choose Travel Agent</option>
                            @foreach ($travel_agents as $agent)
                                 <option value="{{ $agent->AgentId }}">{{ $agent->AgentName }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>


                    <div class="col-md-6">
                    <button type="submit" style="float: right;margin: 30px;" id="modal-submit" class="btn btn-success s8 offset-s2 m2 offset-m5">Submit</button>
                    </div>
                  </form>
                  </div>
            </div>



                        <div class="card-body py-3">
        <div class="row-fluid">
            <div class="span12">
              <div class="grid simple ">

                  <div class="tools">
                    <a href="javascript:;" class="collapse"></a>
                    <a href="#grid-config" data-toggle="modal" class="config"></a>
                    <a href="javascript:;" class="reload"></a>
                    <a href="javascript:;" class="remove"></a>
                  </div>
                </div>
                <div class="grid-body ">
                    <table class="table mt-10 table-row-bordered table-row-gray-100 align-middle gs-0 gy-3 " id="myTable">
                        <thead>
                        <tr class="fw-bolder text-muted ">
                            <th>Date</th>
                            <th>Total Rooms</th>
                            <th>Occupied</th>
                            <th>Available</th>
                            <th>Occupancy(%)</th>
                            <th>Revenue</th>
                            <th>ADR</th>
                            <th>Rev Par</th>
                      </tr>
                    </thead>
                    <tbody>

                        <tr>
                        @if($bookingDetail->count() > 0)
                            @foreach ($bookingDetail as $booking)
                                @php
                                $bookings = null;
                                if( request()->source == null && request()->travel_agent == null && request()->company == null ){

                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->get();
                                }
                                else if(request()->source !=  null && request()->travel_agent != null ){
                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->where('BookingSource', request()->source )
                                    ->where('AgentId', request()->travel_agent )
                                    ->get();
                                }

                                else if(request()->source !=  null && request()->company != null ){
                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->where('BookingSource', request()->source )
                                    ->where('CompanyId', request()->company )
                                    ->get();
                                }

                                else if(request()->travel_agent !=  null && request()->company != null ){
                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->where('CompanyId', request()->company )
                                    ->where('AgentId', request()->travel_agent )
                                    ->get();
                                }

                                else if(request()->source !=  null ){
                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->where('BookingSource', request()->source )
                                    ->get();
                                }

                                else if(request()->company !=  null){
                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->where('CompanyId', request()->company )
                                    ->get();
                                }

                                else if(request()->travel_agent !=  null){
                                    $bookings = $booking->whereBetween('BeginDate', array(request()->start_date, request()->end_date))
                                    ->where('BeginDate', $booking->BeginDate)
                                    ->whereIn('BookingStatusId', [6,7])
                                    ->where('AgentId', request()->travel_agent )
                                    ->get();
                                }



                                $date = strtotime($booking->BeginDate);

                                $final_date = date('d-m-Y', $date);

                                @endphp
                                <td>{{ $final_date }}</td>
                                <td>{{ $totalRooms }}</td>
                                <td>
                                    @php

                                        $occupiedRooms = $bookings->count();
                                        echo $occupiedRooms;
                                    @endphp
                                </td>
                                 <td>{{ $totalRooms - $occupiedRooms }}</td>
                                <td>{{ number_format((float) ($occupiedRooms/$totalRooms)*100, 2, '.', '' ) }}</td>
                                <td>
                                    @php
                                        $perDateTotal = null;
                                        foreach($bookings as $booking){
                                            $perDateTotal += $booking->TotalPrice;
                                        }
                                        echo $perDateTotal;
                                    @endphp
                                </td>

                                 <td>
                                    @if ($perDateTotal != '' && $occupiedRooms != '')
                                    {{ number_format((float) $perDateTotal/$occupiedRooms, 2, '.', '' ) }}
                                    @else
                                        No rooms.
                                    @endif
                                </td>

                                <td>
                                    @if ($perDateTotal != '' && $totalRooms != '')
                                        {{ number_format((float) $perDateTotal/$totalRooms, 2, '.', '' ) }}
                                    @else
                                        No rooms.
                                    @endif
                                </td>
                                    </tr>
                            @endforeach
                            @else
                   <tfoot>
                       <tr>
                        <h3 class="text-center">No record found.</h3>
                       </tr>
                   </tfoot>
                    @endif
                    </table>


    </div>
              </div>
            </div></div></div></div></div></div></div></div>
    <!-- @hasAccess('Create Rate Plan')
        <div class="fixed-action-btn">
            <a href="{{route('admin.rate-plans.create')}}" class="btn-floating btn-large red waves-effect waves-light">
                <i class="material-icons">add</i>
            </a>
        </div>
    @endhasAccess -->
    @component('admin.includes.loader')
    @endcomponent
@endsection

@section('scripts')

<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-select/1.13.1/js/bootstrap-select.min.js"></script>
<script>
    datePickerId.max = new Date().toISOString().split("T")[0];
    $('document').ready(function() {

        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': jQuery('meta[name="csrf-token"]').attr('content')
            }
        });

        $('#country_name').change(function() {
            var countryId = $(this).val()
            // console.log(countryId);
            $.ajax({
                type: 'get',
                url: "{{ url('admin/accommodations') }}" +  "/" + countryId + '/cities',
                data: countryId,
                dataType: 'json',
                success: function (data) {

                    // data = JSON.parse(data);
                    // var options;
                    // for (var i = 0; i < data['length']; i++) {
                    //     options += "<option value='"+data[i]['CityId']+"'>"+data[i]['CityName']+"</option>";
                    // }
                    // $("#city").append(options);

                    // $.each(data, function( index, value ) {
                    //     var array =  $.map(value, function(val){
                    //         console.log('reading data');
                    //         $(new Option('myText', 'val')).appendTo('#city');
                    //     })
                    // })

                    // console.log('aaaa');


                    var $cities = $("#city");
                    // var val[]
                    $.each(data, function(index, value){
                        $.each(value, function(key, val) {
                           val = $('#city').append(
                                $("<option />").val('1').text('Hadi' + " " + 'eeee')
                                    );
                        });
                        // $('.selectpicker').selectpicker('val', val);
                        // $('.selectpicker').selectpicker('refresh')

                    });


                // })
                //     })






                },
                error: function (data) {
                    console.log(data);
                }
        });

        })
    })
</script>
@endsection