@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"> 
                    <!-- <div class="tab-pane active" id="audit_trial"> -->
<!--                         <div class="col-2 ml-8 pl-8" style="padding-top : 10px; padding-left: 30px; margin-top: 15px">
                            <button type="" name="" id="downloadexcel" class="btn btn-success" style="float: left;padding-right: 20px;padding-left: 20px;margin-right: 10px;">EXCEL</button>
                                
                        </div> -->
                        <!-- </div> -->
                        <form method="POST" enctype="multipart/form-data" action="{{route('getAuditTrial')}}">
                          {{ 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-2 form-label pt-1 text-left"><b>Booking Date:</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>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="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-2 form-label pt-1 text-left"><b>Booking No. :</b></label>
                                    <div class="col-sm-3">
                                        <input autocomplete="off" type="text" name="booking_no" id="booking_no" class="form-control" value="">
                                      <!-- <select  id="group" class="form-control" name="agent">
                                        <input style="" type="text" id="book_no" name="book_no" value="" list="typelist">
                                        <option value="" selected disabled="">Select Booking No</option>
                                        @foreach ($booking as $key => $value)
                                        <option value="{{$value->id}}">{{$value->booking_id}}</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="#" class="btn btn-danger" style="float: left;margin-right: 30px;">DISCARD</a></div> -->
                                </div>
                                    
                            </div>
                        </form>


                        <div class="table-container" style="margin-top: 30px;"> 
                            <table class="table table-striped table-hover" id ="datatable-setting-audit_trial" style="font-size: 12px"> 
                                <thead> 
                                    <tr role="row" class="heading"> 
                                        <th class="text-center"><b>No</b></th> 
                                        <th class="text-center" style="text-align:center;"><b>Booking Date</b></th> 
                                        <th class="text-center" style="text-align:center;"><b>Check-in</b></th> 
                                        <th class="text-center" style="text-align:center;"><b>Check-out</b></th> 
                                        <th class="text-center" style="text-align:center;"><b>Booking No</b></th> 
                                        <th class="text-center"><b>Guest Name</b></th> 
                                        <th class="text-center"><b>Hotel</b></th> 
                                        <th class="text-center"><b>Cost</b></th> 
                                        <th class="text-center"><b>Agent</b></th> 
                                        <th class="text-center"><b>Staff</b></th> 
                                        <th class="text-center"><b>Status</b></th> 
                                        <th class="text-center"><b>Modified</b></th>
                                        <th class="text-center"><b>Modified by</b></th>
                                        <th class="text-center"><b>Created</b></th>
                                        <th class="text-center"><b>Created by</b></th>
                                    </tr> 
                                    @php $i=1; @endphp
                                        @foreach($damage as $items)
                                            <tr>
                                                <td>{{$i}}</td>
                                                <td style="text-align:center;">@if($items->created == '0000-00-00' || is_null($items->created)) - @else {{date('d/m/Y', strtotime($items->created))}}  @endif</td>
                                                <td style="text-align:center;">@if($items->check_in == '0000-00-00' || is_null($items->check_in)) - @else {{date('d/m/Y', strtotime($items->check_in))}} @endif</td>
                                                <td style="text-align:center;">@if($items->check_out == '0000-00-00' || is_null($items->check_out)) - @else {{date('d/m/Y', strtotime($items->check_out))}} @endif</td>
                                                <td style="text-align:center;">{{$items->booking_id}}</td>
                                                <td>
                                                    @php

                                                        $guest = DB::table('guests')->where('booking_id',$items->booking_id)->get();
                                                    @endphp
                                                    {{$guest[0]->first_name}}
                                                </td>
                                                <td>{{$items->hotelName}}</td>
                                                <td>RM {{ number_format((float)$items->total, 2, '.', '') }} </td>
                                                <td>{{$items->agentName}}</td>
                                                <td>{{$items->staffName}}</td>
                                                @if($items->status == 'true')
                                                    <td>Pending</td>
                                                @elseif($items->status == 'Confirmed')
                                                    <td>Confirmed</td>
                                                @elseif($items->status == 'Cancelled')
                                                    <td>Cancelled</td>
                                                @endif
                                                <td>@if($items->modified == '0000-00-00' || is_null($items->modified)) - @else {{ date('d/m/Y H:i:s', strtotime($items->modified))}} @endif</td>
                                                <td>@if(is_null($items->modified_by)) - @else {{ $items->modName }} @endif</td>
                                                <td>@if($items->created == '0000-00-00' || is_null($items->created)) - @else {{ date('d/m/Y H:i:s', strtotime($items->created))}} @endif</td>
                                                <td>@if(is_null($items->first_name)) - @else {{ $items->first_name }} @endif</td>
                                            </tr>
                                        @php $i++; @endphp
                                    @endforeach
                                </thead>
                                <tbody>
                                </tbody> 
                            </table>       
                        </div>
                    </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("#datatable-setting-audit_trial"));
});
    </script>    
@endsection