@extends('layouts.admin')
@section('header_style')
    <link href="{{asset('assets/plugins/datatables/datatables.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('assets/plugins/datatables/plugins/bootstrap/datatables.bootstrap.css')}}" rel="stylesheet"      type="text/css"/>
    <link href="{{asset('assets/plugins/bootstrap-datepicker/css/bootstrap-datepicker3.min.css')}}" rel="stylesheet"      type="text/css"/>
    <style type="text/css">
        td { 
            font-size: 14px !important; 
        }
    </style>
@endsection
@section('content')
<div style="min-height: 75vh; max-height: 75vh; height: 75vh; overflow: auto;">
    <div class="page-content-body-wrapper no-padding">
        <div class="page-content-body no-padding"> 
            <div class="portlet light">
                <div class="portlet-body no-padding"> 
                    <div class="tabbable-custom tabbable-parallel"> 
                        <div class ="tab-content no-padding"> 
                        <form method="POST" enctype="multipart/form-data" action="{{route('getBookingReport')}}">
                          {{ csrf_field() }}
                            <div class="col-2 ml-8 pl-8" style="padding-top : 10px; padding-left: 30px; margin-top: 15px">
                                <div class="form-group row my-0 pt-5">
                                    <label class="col-sm-1 form-label pt-1 text-left"><b>Date From :</b></label>
                                    <div class="col-sm-3">
                                        <input autocomplete="off" type="date" name="date_from" id="date_from" class="form-control" value="">
                                    </div>
                                    <div class="mx-3">  
                                    </div>
                                    <label class="col-sm-1 form-label pt-1 text-left"><b>Date To :</b></label>
                                    <div class="col-sm-3">
                                        <input autocomplete="off" type="date" name="date_to" id="date_to" class="form-control" value="">
                                    </div>
                                    <div class="mx-3">  
                                    </div>                                
                                    <label class="col-sm-1 form-label pt-1 text-left"><b>Hotel :</b></label>
                                    <div class="col-sm-3">
                                      <select  id="group" class="form-control" name="hotel">
                                        <option value="" selected disabled="">Select Hotel</option>
                                        @foreach ($hotel as $key => $value)
                                        <option value="{{$value->id}}">{{$value->name}}</option>
                                        @endforeach   
                                      </select>
                                    </div>
                                    <div class="mx-3">  
                                    </div>
                                    
                                    <!-- <div class="Discard"><a href="#" class="btn btn-danger" style="float: left;margin-right: 30px;">DISCARD</a></div> -->
                                </div>                            
                                <div class="form-group row my-0 pt-5">
                                    <label class="col-sm-1 form-label pt-1 text-left"><b>Agent :</b></label>
                                    <div class="col-sm-3">
                                      <select  id="group" class="form-control" name="agent">
                                        <option value="" selected disabled="">Select Agent</option>
                                        @foreach ($agent as $key => $value)
                                        <option value="{{$value->id}}">{{$value->name}}</option>
                                        @endforeach   
                                      </select>
                                    </div>
                                    <div class="mx-3">  
                                    </div>
                                    <label class="col-sm-1 form-label pt-1 text-left"><b>Staff :</b></label>
                                    <div class="col-sm-3">
                                      <select  id="group" class="form-control" name="staff">
                                        <option value="" selected disabled="">Select Staff</option>
                                        @foreach ($staff as $key => $value)
                                        <option value="{{$value->id}}">{{$value->first_name}}</option>
                                        @endforeach   
                                      </select>
                                    </div>
                                    <div class="mx-3">  
                                    </div>
                                    <div class="Save"><button type="buttton" name="submit" id="submit" class="btn btn-success" style="float: left;padding-right: 20px;padding-left: 20px;margin-right: 10px;">SEARCH</button></div>
                                    <button type="" name="" id="downloadexcel" class="btn btn-success" style="float: left;padding-right: 20px;padding-left: 20px;margin-right: 10px;">EXCEL</button>
                                    <div class="Discard"><a href="{{route('report.index')}}" class="btn btn-danger" style="float: left;margin-right: 30px;">DISCARD</a></div>
                                </div>
                                    
                            </div>
                        </form>
                            <div class="table-container" style="margin-top: 30px; margin-bottom: 100px">
                                <table class="table table-striped table-hover" id ="test"> 
                                    <thead> 
                                        <tr role="row" class="heading"> 
                                            <th class="text-center"><b>No</b></th> 
                                            <th class="text-center"><b>Booking Date</b></th> 
                                            <th class="text-center"><b>Check-in</b></th> 
                                            <th class="text-center"><b>Check-out</b></th>
                                            <th class="text-center"><b>Night</b></th>  
                                            <th class="text-center"><b>Booking No</b></th> 
                                            <th class="text-center"><b>Hotel</b></th> 
                                            <th class="text-center"><b>Guest Name</b></th> 
                                            <th class="text-center"><b>Price</b></th> 
                                            <th class="text-center"><b>Agent</b></th> 
                                            <th class="text-center"><b>Staff</b></th> 
                                        </tr> 
                                    </thead>
                                    <tbody>
                                       @php $i=1; $total = 0;@endphp
                                        @foreach($damage as $items)
                                          <tr>
                                              <td>{{$i}}</td>
                                              <td>@if($items->created == '0000-00-00' || is_null($items->created)) - @else {{date('d/m/Y', strtotime($items->created))}}  @endif</td>
                                              <td>@if($items->check_in == '0000-00-00' || is_null($items->check_in)) - @else {{date('d/m/Y', strtotime($items->check_in))}}  @endif</td>
                                              <td>@if($items->check_out == '0000-00-00' || is_null($items->check_out)) - @else {{date('d/m/Y', strtotime($items->check_out))}}  @endif</td>
                                              <td>
                                                  @php
                                                    $diffTime = (strtotime($items->check_out)) - (strtotime($items->check_in));
                                                    $diffDays = $diffTime / (60 * 60 * 24);
                                                  @endphp
                                                    {{ $diffDays }}
                                              </td>
                                              <td>{{$items->booking_id}}</td>
                                              <td>{{$items->hotelName}}</td>
                                              <td>{{$items->first_name}}</td>
                                              <td>RM {{ number_format(round((float)$items->total,0), 2) }}</td>
                                              <td>{{$items->agentName}}</td>
                                              <td>{{$items->staffName}}</td>
                                          </tr>
                                          @php $i++; @endphp
                                          @php $total += (float)$items->total; @endphp
                                        @endforeach
                                        <tr>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td></td>
                                            <td><b>Total</b></td>
                                            <td><b>RM {{ number_format(round((float)$total,0), 2) }}</b></td>
                                            <td></td>
                                            <td></td>
                                        </tr>
                                    </tbody> 
                                </table>       
                            </div>
                        </div> 
                    </div>
                </div>
            </div> 
        </div> 
    </div> 
</div>
     
@endsection
@section('footer_script')
    <script src="{{asset('assets/scripts/datatable.js' )}}" type="text/javascript"></script>
    <script src="{{asset('assets/plugins/datatables/datatables.min.js' )}}" type="text/javascript"></script>
    <script src="{{asset('assets/plugins/datatables/plugins/bootstrap/datatables.bootstrap.js' )}}"
            type="text/javascript"></script>
    <script src="{{asset('assets/plugins/jquery-validation/js/jquery.validate.min.js') }}"
            type="text/javascript"></script>
    <script src="{{asset('assets/plugins/jquery-validation/js/additional-methods.min.js') }}"
            type="text/javascript"></script>
    <script src="{{asset('assets/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js' )}}"
            type="text/javascript"></script>    
    <script src="{{asset('assets/scripts/pages/table2excel.js' )}}"
            type="text/javascript"></script>

    <script type="text/javascript">
      document.getElementById('downloadexcel').addEventListener('click',function(){
  var table2excel = new Table2Excel();
  table2excel.export(document.querySelectorAll("#test"));
});
    </script>
@endsection