@extends('layouts.layout')

@section('content')


<!-- Bootstrap 3.3.7 -->
<link rel="stylesheet" href="{{ URL::asset('css/popup.css') }}">
<style type="text/css">
    .badge-danger {
        background-color:red;
    }
    .increaseme{
        width:100px;
    }
</style>
<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>
         {{ ucwords(str_replace('_', ' ', $url)) }} 
        <small>Version 2.0</small>
    </h1>
    <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> SysManager</a></li>
        <!--<li class="active">{{ ucwords(str_replace('_', ' ', $url)) }}</li>-->
    </ol>
</section>


<!-- Main content -->
<section class="content">

    <div class="btn-group">
        <!--<a href="{{ route('form.url', ['url' => $url]) }}"><button type="button" class="btn bg-maroon btn-flat margin">Add</button></a>
        <a href=""><button type="button" class="btn bg-purple btn-flat margin">Export</button></a>-->
        <!--     <button type="button" class="btn bg-navy btn-flat margin">.btn.bg-navy.btn-flat</button>
                <button type="button" class="btn bg-orange btn-flat margin">.btn.bg-orange.btn-flat</button>
                <button type="button" class="btn bg-olive btn-flat margin">.btn.bg-olive.btn-flat</button> -->
    </div>
    <!-- /.row -->



<!--
    <div class="row">
        <div class="col-md-12">
            <div class="box">
                <div class="box-header with-border">
                    <h3 class="box-title">Advance Search </h3>

                    <div class="box-tools pull-right">
                        <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                        </button>

                        <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
                    </div>
                </div>
               
                <div class="box-body">
                    <div class="row">
                        <div class="col-md-12">
                            <p class="text-left">
                             
                            </p>
                            <div class="advance">

                            </div>
                        </div>

                    </div>
                   
                </div>


            </div>
           
        </div>
        
    </div>
    <!-- /.row -->



    <div class="row">
        <div class="col-xs-12">
            <div class="box" style="padding:10px">

                <!-- /.box-header -->
                <div class="box-body table-responsive no-padding">

                    <div class="col-md-12">
                        <!-- Custom Tabs -->
                        <div class="nav-tabs-custom">
                            <ul class="nav nav-tabs">
                                <!--<li class="active"><a href="#tab_2" data-toggle="tab">Completed Trips</a></li>-->
                                <li class="active"><a href="#tab_3" data-toggle="tab">Vehicle Utilization Report</a></li>
                                 <li class=""><a href="#tab_4" data-toggle="tab">Downtime</a></li>
                                  <li class=""><a href="#tab_5" data-toggle="tab">Downtime Summary</a></li>
                                <li class="pull-right"><a href="#" class="text-muted"><i class="fa fa-gear"></i></a></li>
                            </ul>
                            <div class="tab-content">
                              
                                
                                <div class="tab-pane" id="tab_2">
                                    
                                  <div style="border:2px solid #a6a1a1; padding-top:10px; margin-bottom: 20px; height:50px;">
                                    
                                    <form action="{{ route('completedsearch') }}" method="POST" name="formGet">
                                        {{ csrf_field() }}
                                        <table style="float:right">
                                            <tr>
                                                <td> 
                                                    SEARCH:: &nbsp;&nbsp;&nbsp;
                                                    Res ID:  <input class="" placeholder="Enter Reservation ID" type="text" name="search" id="search" />
                                                    Pickup Date:  <input class="" placeholder="Pickup Date" type="text" name="pickupdate" id="search" />
                                                    <input class="" placeholder="End Date" type="text" name="endate" id="search" />
                                                   
                                                      &nbsp;<b>Office</b>
                                                    @if($office)
                                                        <select name="office" id="office">
                                                        <option value="">Select Office</office>
                                                       @foreach($office as $off)
                                                      
                                                       <option value="{{ $off->office_id }}">{{ $off->office_name }} </office>
                                                       @endforeach
                                                       
                                                        </select>
                                                    @endif
                                                    
                                                      &nbsp;<b>Client</b>
                                                      @if($companies)
                                                        <select name="cid" id="cid" style="width:100px">
                                                         <option value="">Select Client</office>
                                                       @foreach($companies as $ccid)
                                                      
                                                       <option value="{{ $ccid->companies_id }}">{{ $ccid->company_name }} </office>
                                                       @endforeach
                                                       
                                                        </select>
                                                    @endif
                                                  
                                                    
                                                    <button type="submit" class="btn-danger btn-xs">Search</button> 
                                                </td>
                                            </tr>
                                        </table>
                                       
                                       
                                    </form>                 
                                  </div>
                                     
                                    @if(isset($tripsbycid))
                                    <table id="example1"  class="table table-bordered table-striped table-responsive table-hover">
                                        <thead>
                                            <tr style="background-color:#D3D3D3; color:black">
                                                <th>Res ID</th>  
                                                <th>Office</th>  
                                                <th>Company</th>  
                                                <th>Passenger Name</th>  
                                                <th>Departure</th>
                                                <th>Destination</th>
                                                <th>Pickup Date</th>
                                                <th>End Date</th>
                                                <th>Resources</th>  
                                                <th>Status</th> 
                                                <th>Total</th>  
                                                <th>Action</th>  

                                            </tr>

                                        </thead>

                                        <tbody id="contract_list">



                                            @foreach($tripsbycid as $trips)
                                            
                                            
                                            <tr>
                                                <td>{{ $trips->reservation_id }}</td>
                                                <td>{{ App\Office::where('office_id', $trips->office)->value('office_name') }}</td>
                                                <td>{{ App\Companies::where('companies_id', $trips->cid)->value('company_name') }}</td>
                                                <td style="width:30px">{{ $trips->passenger_names }}</td>
                                                <td>{{ $trips->pickup_street }}</td>
                                                <td>{{ $trips->actual_street }}</td>
                                                <td>
                                                    {{ $trips->pick_up_date }}   {{ $trips->pickup_time }}

                                                </td>
                                                <td>
                                                    {{ $trips->end_date }}   {{ $trips->end_time }}

                                                </td>
                                                <td><b>{{ $trips->vehicle_id }}
                                                    <br/>
                                                    {{ App\Drivers::where("driver_id", $trips->driver)->value("name") }}
                                                    </b>
                                                </td>
                                                
                                                @if($trips->job_status == '2')
                                                 <td>completed</td>
                                                @else
                                                 <td></td>
                                                @endif
                                               
                                                <td>{{ $trips->total_cost + App\AdditionalServiceTrip::where('trip_id', $trips->id)->sum('total_cost') }}</td>

                                                <td style="width:100px">
                                                    <div class='btn-group'>
                                                        <button type='button' class='btn btn-xs btn-default'>Action</button>
                                                        <button type='button' class='btn btn-xs btn-default dropdown-toggle' data-toggle='dropdown'>
                                                          <span class='caret'></span>
                                                          <span class='sr-only'>Toggle Dropdown</span>
                                                        </button>
                                                        <ul class='dropdown-menu' role='menu'>
                                                          <li><a title="View Details" href="{{ route('trip_details',  ["id" =>$trips->id]) }}">View</a></li>
                                                        </ul>
                                                      </div>
                                                    
                                                </td>

                                            </tr>  
                                            @endforeach
                                        </tbody>


                                    </table>
                                    {!! $tripsbycid->render() !!}

                                    @else

                                    {{ $message }}
                                    @endif

                                </div><!-- End of id="tab_2" -->
                                      
                                      
                                      
                                      
                                <div class="tab-pane active" id="tab_3">
                                 
                                    <hr/>
                                    @if($monthendreview)
                                        <form>
                                            <table id="example4" class="table table-responsive table-bordered table-striped table-hover table-primary">
                                               <thead>
                                                <tr style="background-color:#002752; color:#D3D3D3">
                                                    
                                                    <!--<th>ID</th>-->
                                                    <th>Year</th>
                                                    <th>Month</th>
                                                    <th style="width:20px">Contract</th>
                                                    <th style="width:20px">Location</th>
                                                    <th style="width:20px">Vehicle</th>
                                                    <th>Vehicle Type</th>
                                                    
                                                    <th style="width:20px">Drivers</th>
                                                   
                                                   
                                                    
                                                    <th>Occurence</th>
                                                    <th>Expected Work Days</th>
                                                    <th>Days Worked(closed)</th>
                                                    <th>Unclosed Jobs</th>
                                                    <th>Downtime Days</th>
                                                    <th>Downtime Percent(%)</th>
                                                     <th>% of Utilization</th>
                                                     <th>Rate</th>
                                                    <th>Revenue Loss</th>
                                                     <th>Reason for Downtime</th>
                                                     <!--<th>Workshop Name</th>
                                                     <th>Replacement Vehicle</th>
                                                     <th>Date In</th>
                                                     <th>Date Out</th>  
                                                     <th>Days In Workshop</th>  
                                                    <th>Replacement Vehicle Number</th>  
                                                     <th>Replacement Vehicle Make</th>
                                                     <th>Days Replacement Vehicle Was Utilized</th>-->
                                                    <th>Job Status</th>
                                                    <th>View Details</th>
                                                   
                                                </tr>
                                                </thead> 
                                                  <tbody id="contract_list">
                                                                                       
                                       @foreach($monthendreview as $iget)