@extends('layouts.main-layout')
@section('title')
Forecast 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">Forecast Report</span>

                    </h3>


                </div>



                <div class="card-body py-3">

          </div>
          <div class="row">
            <div class="col-md-12">
              <div class="grid simple">
                <div class="container">
                  <h4 >Date <span class="semi-bold">Controls</span></h4>

                </div>

                    <form action="{{route('admin.forecast.report')}}" method="get" class="grey lighten-4 ">
                  <div class="row p-5">

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

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

                      </div>
                    <div class="col-md-6">
                    <input type="date" class="form-control" datePickerId id="end_date" name='end_date'>
                    </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 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 class="card-body py-3">

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

                  <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>Booked</th>
                            <th>Available</th>
                            <th>Occupancy(%)</th>
                            <th>Revenue</th>
                            <th>ADR</th>
                            <th>Rev Par</th>
                      </tr>
                    </thead>
                    <tbody>
                        @if (request()->start_date)
                        <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', [1,4,5,6])
                                    ->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', [1,4,5,6])
                                    ->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', [1,4,5,6])
                                    ->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', [1,4,5,6])
                                    ->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', [1,4,5,6])
                                    ->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', [1,4,5,6])
                                    ->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', [1,4,5,6])
                                    ->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
                                    @endif
                            @else
                   <tfoot>
                       <tr>
                        <h3 class="text-center">No record found.</h3>
                       </tr>
                   </tfoot>
                    @endif
                    </table>


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


// $('#start_date').datepicker({
//       format: "dd/mm/yyyy"
//     }).on('change', function(){
//         var start_date = $('#start_date').val();
//         var today = new Date();
//         var todays_date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+("0" + today.getDate()).slice(-2);
//         if(todays_date > start_date)
//         {
//             $('#start_date').val('');
//             makeToast("Please Select correct date for forecast", 5000);
//         }
//     });

//     $('#end_date').datepicker({
//       format: "dd/mm/yyyy"
//     }).on('change', function(){
//         var end_date = $('#end_date').val();
//         var today = new Date();
//         var todays_date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+("0" + today.getDate()).slice(-2);
//         if(todays_date > start_date)
//         {
//             $('#end_date').val('');
//             makeToast("Please Select correct date for forecast", 5000);
//         }
//     });


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