@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_1" data-toggle="tab">Reservation</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($allReservation))
                                    
                                    
                                    <table id="example1"  class="table table-bordered table-striped table-responsive table-hover">
                                        <thead>
                                            <tr style="background-color:#D3D3D3; color:black">
                                               
                                                 <th>ID</th>  
                                                 <th>Date</th>  
                                                <th>Office</th>  
                                                <th>Company</th>  
                                                <th>Contact Details</th>  
                                                <th>Phone</th>
                                                <th>Trips</th>
                                                <th>Confirmed</th>
                                                <th>Canceled</th>
                                                <th>Closed</th>
                                                <th>Cost</th> 
                                                 <th>Status</th> 
                                                <th style="width:70px">Action</th>  

                                            </tr>

                                        </thead>

                                        <tbody id="icontract_list">

                                           
                                            
                                            @foreach($allReservation as $ireserve)
                                            
                                                                                       
                                            <tr style="">
                                                <td>{{ $ireserve->reservation_id }}</td>
                                                <td>{{ $ireserve->created_at }}</td>
                                                
                                                <td>{{ App\Office::where('office_id', $ireserve->office)->value('office_name') }}</td>
                                                <td>{{ App\Companies::where('companies_id', $ireserve->cid)->value('company_name') }}</td>
                                                <td>{{ $ireserve->contact_fullname }}</td>
                                                <td>{{ $ireserve->contact_phone_number }}</td>
                                                <td><a href="" class="badge badge-primary">{{ App\Trip::where("reservation_id", $ireserve->reservation_id)->count() }}<a/></td>
                                                <td><a href="" class="badge badge-primary">{{ App\Trip::where(["reservation_id"=> $ireserve->reservation_id, "trip_status"=> "confirmed"])->count() }}<a/></td>
                                                <td><a href="" class="badge badge-primary">{{ App\Trip::where(["reservation_id"=> $ireserve->reservation_id, "trip_status"=> "cancelled"])->count() }}<a/></td>
                                                 <td><a href="" class="badge badge-primary">{{ App\Trip::where(["reservation_id"=> $ireserve->reservation_id, "job_status"=> "2"])->count() }}<a/></td>
                                                
                                                <td>
                                                     {{ 
                                                     @number_format(App\Trip::where(['reservation_id' => $ireserve->reservation_id, "trip_status" => "confirmed"])->sum('total_cost') +
                                                     App\AdditionalServiceTrip::where('reservation_id', $ireserve->reservation_id)->sum('total_cost'), 2)
                                                     
                                                    }}
                                                </td>
                                                
                                               <!-- <td><a href="" class="badge {{ $status_reservation }}">{{ $ireserve->task_status }}</a></td>-->
                                                <td>{{ $ireserve->task_status }}</td>
                                                <td style="width:70px">