@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="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_1" data-toggle="tab">MONTH END REPORT</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 active" id="tab_1">
                                    
                                     @if(isset($tripsbycid))
                                    
                                    <div class="table-responsive">
                                    <table id="example1" class="table table-bordered table-striped table-responsive table-hover">
                                        <thead>
                                            <tr style="background-color:#D3D3D3; color:black">
                                               
                                                 <th>Task ID</th>  
                                                 <th>Date Created</th>  
                                                  <th>Office</th>  
                                                 <th>Pickup Date</th>  
                                                 <th>Pickup Time</th>  
                                                <th>End Date</th>  
                                                <th>End Time</th>  
                                                 <th>Days</th>  
                                                <th>Client</th>  
                                                <th>Passenger Name</th>
                                                 <th>From</th>
                                                <th>To</th> 
                                                <th>Vehicle</th>
                                                <th>Driver</th>
                                                <th>Trip Type</th>
                                                <th>Amount Charged</th>
                                                <th>Fuel</th>
                                                <th>Escort Service (Same Car)</th>
                                                <th>Escort Service (Different Car)</th>
                                                <th>Protocol Service</th>
                                                <th>Chauffeurs Service</th>
                                                <th>Total Amount</th>
                                                <th>Status</th>

                                            </tr>

                                        </thead>

                                        <tbody id="icontract_list">

                                           
                                            
                                            @foreach($tripsbycid as $get)
                                            
                                          
                                            
                                            <tr>
                                                <td>{{ $get->reservation_id }}</td>
                                                <td>{{ $get->created_at }}</td>
                                                <td>{{ App\Office::where("office_id", $get->office)->value("office_name") }}</td>
                                                <td>{{ $get->pick_up_date }}</td>
                                                <td>{{ $get->pickup_time }}</td>
                                                <td>{{ $get->end_date }}</td>
                                                <td>{{ $get->end_time }}</td>
                                                <td>{{ $get->number_of_days }}</td>
                                                <td>{{  App\Companies::where("companies_id", $get->cid)->value("company_name") }}</td>
                                                <td>{{ $get->passenger_names }}</td>
                                                <td>{{ $get->pickup_street }}</td>
                                                <td>{{ $get->actual_street }}</td>
                                                <td>{{ $get->vehicle_id }}</td>
                                                <td>{{ App\Drivers::where("driver_id", $get->driver)->value("name") }}</td>
                                                <td>{{ $get->service_type }}</td>
                                               <td>{{ @number_format($get->total_cost, 2) }}</td>
                                               <td>{{ App\AdditionalServiceTrip::where(["service" => '5', "trip_id" => $get->id])->value("total_cost") }}</td>
                                               
                                               <td>{{ @number_format(App\AdditionalServiceTrip::where(["service" => '2', "trip_id" => $get->id])->value("total_cost"), 2) }}</td>
                                               <td>{{ @number_format(App\AdditionalServiceTrip::where(["service" => '3', "trip_id" => $get->id])->value("total_cost"), 2) }}</td>
                                               <td>{{ @number_format(App\AdditionalServiceTrip::where(["service" => '4', "trip_id" => $get->id])->value("total_cost"), 2) }}</td>
                                               <td>{{ @number_format(App\AdditionalServiceTrip::where(["service" => '1', "trip_id" => $get->id])->value("total_cost"), 2) }}</td>
                                                <td>
                                                     {{ 
                                                     @number_format(
                                                        $get->total_cost +
                                                        App\AdditionalServiceTrip::where(["service" => '5', "trip_id" => $get->id])->value("total_cost") +     
                                                        App\AdditionalServiceTrip::where(["service" => '2', "trip_id" => $get->id])->value("total_cost") +
                                                        App\AdditionalServiceTrip::where(["service" => '3', "trip_id" => $get->id])->value("total_cost") +
                                                       App\AdditionalServiceTrip::where(["service" => '4', "trip_id" => $get->id])->value("total_cost") +
                                                       App\AdditionalServiceTrip::where(["service" => '1', "trip_id" => $get->id])->value("total_cost")
                                                        
                                                        
                                                        , 2)
                                                    }}
                                                 
                                                 </td>
                                                 
                                                  <td>{{ App\Jobmodel::where("id", $get->job_status)->value("name") }}</td>
                                                
                                            </tr>  
                                            @endforeach
                                        </tbody>


                                    </table>
                                    
                                </div>
                                 @endif
                                   

                                  
                                    
                                </div><!--  <div class="tab-pane active" id="tab_1"> -->
                               
                                
                                
                                <!-- /.tab-content -->
                            </div>
                            <!-- nav-tabs-custom -->
                        </div>
                        <!-- /.col -->

                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->
            </div>
        </div>




</section>


<script src="{{ URL::asset('js/global.js') }}"></script>
<script src="{{ URL::asset('js/ajax.js') }}"></script>


   

@endsection