{{--@extends('admin.layouts.app')--}}

{{--@section('title', 'Bus Manifests')--}}

{{--@section('content')--}}

{{--    @include('admin.includes.alerts')--}}
{{--    <div class="main-card mb-3 card">--}}
{{--        <div class="card-body">--}}
{{--            <table style="width: 100%;" class="table table-responsive table-hover table-striped table-bordered">--}}
{{--                <thead>--}}
{{--                <tr>--}}
{{--                    <th>SN</th>--}}
{{--                    <th width="10%">Bus</th>--}}
{{--                    <th width="15%">Schedule</th>--}}
{{--                    <th>Tickets</th>--}}
{{--                    <th width="25%">Route</th>--}}
{{--                    <th>Class</th>--}}
{{--                    <th width="10%">Label</th>--}}
{{--                    <th>Status</th>--}}
{{--                    <th width="10%">Company</th>--}}
{{--                    <th>Action</th>--}}
{{--                </tr>--}}
{{--                </thead>--}}
{{--                <tbody>--}}
{{--                @foreach($bookings as $i => $booking)--}}
{{--                    <tr>--}}
{{--                        <td>{{$i + $bookings->firstItem()}}</td>--}}
{{--                        <td>--}}
{{--                        @php--}}
{{--                            $bus = \App\Models\Bus::where(['id' => $booking->schedule->bus_id])->first()->bus_reg_no;--}}
{{--                            echo $bus;--}}
{{--                            @endphp--}}
{{--                        </td>--}}
{{--                        <td>{{$booking->schedule->trip_date}} {{$booking->schedule->departure}}</td>--}}
{{--                        <td>--}}
{{--                            @php--}}
{{--                                $tickets = \Illuminate\Support\Facades\DB::table('bookings')->where('status', '>', '2')->where('schedule_id', $booking->schedule_id)->get()->count();--}}
{{--                                echo $tickets;--}}
{{--                            @endphp--}}
{{--                        </td>--}}
{{--                        <td>--}}
{{--                            @php--}}

{{--                                if($booking->schedule->route_id != null || $booking->schedule->route_id != 'NULL'){--}}



{{--    $pA = \App\Models\Route::where(['id' => $booking->schedule->route_id])->first()->start_point;--}}
{{--                                $pB = \App\Models\Route::where(['id' => $booking->schedule->route_id])->first()->end_point;--}}

{{--                                $pointA = \App\Models\Cities::where(['id' => $pA])->first()->city;--}}
{{--                                $pointB = \App\Models\Cities::where(['id' => $pB])->first()->city;--}}

{{--                                echo $pointA .' - '.$pointB;--}}



{{--                                }else{--}}

{{--                                $from = \App\Models\SubRoute::where(['id' => $booking->sub_route_id])->first()->start_point;--}}
{{--                                $to = \App\Models\SubRoute::where(['id' => $booking->sub_route_id])->first()->end_point;--}}

{{--                                echo $from .' - '.$to;--}}

{{--                                }--}}
{{--                            @endphp--}}
{{--                        </td>--}}
{{--                        <td>--}}
{{--                            @if(\App\Models\Route::where(['id' => $booking->schedule->route_id])->first()->class == 1)--}}
{{--                                <span class="mb-2 mr-2 badge badge-primary">VVIP</span>--}}
{{--                            @elseif(\App\Models\Route::where(['id' => $booking->schedule->route_id])->first()->class == 2)--}}
{{--                                <span class="mb-2 mr-2 badge badge-success">VIP</span>--}}
{{--                            @elseif(\App\Models\Route::where(['id' => $booking->schedule->route_id])->first()->class == 3)--}}
{{--                                <span class="mb-2 mr-2 badge badge-info">LUXURY</span>--}}
{{--                            @elseif(\App\Models\Route::where(['id' => $booking->schedule->route_id])->first()->class == 4)--}}
{{--                                <span class="mb-2 mr-2 badge badge-warning">SEMI-LUXURY</span>--}}
{{--                            @else--}}
{{--                                <span class="mb-2 mr-2 badge badge-dark">ORDINARY</span>--}}
{{--                            @endif--}}
{{--                        </td>--}}
{{--                        <td>{{$booking->schedule->label}}</td>--}}
{{--                        <td>--}}
{{--                            @if($booking->status == 2)--}}
{{--                                <span class="mb-2 mr-2 badge badge-warning">Booking</span>--}}
{{--                            @elseif($booking->status == 3)--}}
{{--                                <span class="mb-2 mr-2 badge badge-success">Booking</span>--}}
{{--                            @elseif($booking->status == 4)--}}
{{--                                <span class="mb-2 mr-2 badge badge-info">Borded</span>--}}
{{--                            @else--}}
{{--                                <span class="mb-2 mr-2 badge badge-danger">N/A</span>--}}
{{--                            @endif--}}
{{--                        </td>--}}

{{--                        <td>{{ \App\Models\Company::where(['id' => $booking->company])->first()->name }}</td>--}}
{{--                        <td width="20%">{!! Form::open(array(--}}
{{--                                 'style' => 'display: inline-block;',--}}
{{--                                 'method' => 'GET',--}}
{{--                                 'route' => ['Print Manifest', $booking->schedule_id])) !!}--}}
{{--                            {!! Form::submit('Print Manifest', array('class' => 'btn btn-sm btn-dark')) !!}--}}
{{--                            {!! Form::close() !!}--}}

{{--                            {!! Form::open(array(--}}
{{--                                 'style' => 'display: inline-block;',--}}
{{--                                 'method' => 'GET',--}}
{{--                                 'route' => ['View Manifest', $booking->schedule_id])) !!}--}}
{{--                            {!! Form::submit('View', array('class' => 'btn btn-sm btn-info')) !!}--}}
{{--                            {!! Form::close() !!}--}}
{{--                        </td>--}}
{{--                    </tr>--}}
{{--                @endforeach--}}
{{--                </tbody>--}}
{{--            </table>--}}
{{--            {{ $bookings->links() }}--}}
{{--        </div>--}}
{{--    </div>--}}
{{--@endsection--}}
@extends('admin.layouts.app')
@section('title', 'Bus Manifests')
@section('content')
    @include('admin.includes.alerts')
    <style>
        @import url('https://fonts.googleapis.com/css?family=Raleway:500');

        /*body {*/
        /*    background-image: url(https://images.pexels.com/photos/735911/pexels-photo-735911.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940);*/
        /*    font-family: 'Raleway', sans-serif;*/
        /*}*/

        .main-search-input {
            margin: 20px auto;
            border-radius: 50px;
            max-width:1000px;
            width: 100%;
            background-color: #fff;
            box-shadow: 0 0 8px 0 rgba(0,0,0,.12);
            display: flex;
            flex-wrap: wrap;
            align-items: flex-start;
            padding: 9px;
            max-height: 68px;
        }

        .main-search-input-item {
            flex: 1;
            border-right: 1px solid #e9e9e9;
            margin-top: 3px;
            position: relative;
            padding-left: 30px;
            padding-right: 30px;
        }

        .main-search-input .main-search-input-item:nth-last-child(2) {
            border-right: 0;
            padding-left: 15px;
            padding-right: 15px;
        }

        .main-search-input input, .main-search-input input:focus {
            font-size: 16px;
            border: 0;
            background: #fff;
            margin: 0;
            padding: 0;
            height: 44px;
            line-height: 44px;
            box-shadow: none;
            max-width: 100%;
            width: 100%;
            font-family: 'Raleway', sans-serif;
            outline:none !important;
        }

        .main-search-input select {
            border: 0;
            padding-top: 2px;
            padding-bottom: 0;
            height: 44px;
            box-shadow: none;
            max-width: 100%;
            font-size: 16px;
            width: 100%;
            font-family: 'Raleway', sans-serif;
            outline:none !important;
        }

        .main-search-input button.button {
            font-family: 'Raleway', sans-serif;
            font-size: 16px;
            font-weight: 500;
            padding: 0 40px;
            margin-right: 1px;
            height: 50px;
            outline: 0;
            background-color: #f91942;
            color: #fff;
            position: relative;
            overflow: hidden;
            border: 0;
            border-radius: 50px;
        }
    </style>
    <div class="main-card mb-3 card">
        <div class="card-body">
            <table style="width: 100%;" class="table table-responsive table-hover table-striped table-bordered">
                <div class="main-search-input">
                    <form action="{{url('/search-manifest')}}" method="get" role="search" >
                        <div class="main-search-input-item">
                            <input type="text" name="search" placeholder="Search for Trip Date?">
                        </div>
                        <button style="background: #1b6d85" class="button" type="submit" >Search</button>
                        <button style="margin-left: 5px;" class="button" href="{{ url('/manifest') }}">Refresh</button>
                    </form>
                </div>
                <thead>
                <tr>
                    <th>SN</th>
                    <th width="10%">Bus</th>
                    <th width="15%">Schedule</th>
                    <th>Tickets</th>
                    <th width="25%">Route</th>
                    <th>Class</th>
                    <th width="10%">Label</th>
                    <th>Status</th>
                    <th width="10%">Company</th>
                    <th>Action</th>
                </tr>
                </thead>
                <tbody>
                @foreach($schedules as $i => $schedule)
                    <tr>
                        <td>{{$i + $schedules->firstItem()}}</td>
                        <td>
                            @php
                                $bus = \App\Models\Bus::where(['id' => $schedule->bus_id])->first()->bus_reg_no;
                                echo $bus;
                            @endphp
                        </td>
                        <td>{{$schedule->trip_date}} {{$schedule->departure}}</td>
                        <td>
                            @php
                                $tickets = \Illuminate\Support\Facades\DB::table('booking_histories')->where('status', '>', '2')->where('schedule_id', $schedule->id)->get()->count();
                                echo $tickets;
                            @endphp
                        </td>
                        <td>
                            @php

                                if($schedule->route_id != null || $schedule->route_id != 'NULL'){



                                $pA = \App\Models\Route::where(['id' => $schedule->route_id])->first()->start_point;
                                $pB = \App\Models\Route::where(['id' => $schedule->route_id])->first()->end_point;

                                $pointA = \App\Models\Cities::where(['id' => $pA])->first()->city;
                                $pointB = \App\Models\Cities::where(['id' => $pB])->first()->city;

                                echo $pointA .' - '.$pointB;



                                }else{

                                $from = \App\Models\SubRoute::where(['id' => $schedule->bookings->sub_route_id])->first()->start_point;
                                $to = \App\Models\SubRoute::where(['id' => $schedule->bookings->sub_route_id])->first()->end_point;

                                echo $from .' - '.$to;

                                }
                            @endphp
                        </td>
                        <td>
                            @if(\App\Models\Route::where(['id' => $schedule->route_id])->first()->class == 1)
                                <span class="mb-2 mr-2 badge badge-primary">VVIP</span>
                            @elseif(\App\Models\Route::where(['id' => $schedule->route_id])->first()->class == 2)
                                <span class="mb-2 mr-2 badge badge-success">VIP</span>
                            @elseif(\App\Models\Route::where(['id' => $schedule->route_id])->first()->class == 3)
                                <span class="mb-2 mr-2 badge badge-info">LUXURY</span>
                            @elseif(\App\Models\Route::where(['id' => $schedule->route_id])->first()->class == 4)
                                <span class="mb-2 mr-2 badge badge-warning">SEMI-LUXURY</span>
                            @else
                                <span class="mb-2 mr-2 badge badge-dark">ORDINARY</span>
                            @endif
                        </td>
                        <td>{{$schedule->label}}</td>
                        <td>
                            @if($schedule->boarding_status == 'Booking is CLOSED')
                                <span class="mb-2 mr-2 badge badge-danger">CLOSED</span>
                            @elseif($schedule->boarding_status == 'Booking is OPEN')
                                <span class="mb-2 mr-2 badge badge-success">OPEN</span>
                            @elseif($schedule->boarding_status == 'On Journey')
                                <span class="mb-2 mr-2 badge badge-info">BOARDING-JOURNEY</span>
                            @else
                                <span class="mb-2 mr-2 badge badge-dark"> </span>
                            @endif
                        </td>

                        <td>{{ \App\Models\Company::where(['id' => $schedule->company])->first()->name }}</td>
                        <td width="20%">{!! Form::open(array(
                                 'style' => 'display: inline-block;',
                                 'method' => 'GET',
                                 'route' => ['Print Manifest', $schedule->id])) !!}
                            {!! Form::submit('Print Manifest', array('class' => 'btn btn-sm btn-dark')) !!}
                            {!! Form::close() !!}

                            {!! Form::open(array(
                                 'style' => 'display: inline-block;',
                                 'method' => 'GET',
                                 'route' => ['View Manifest', $schedule->id])) !!}
                            {!! Form::submit('View', array('class' => 'btn btn-sm btn-info')) !!}
                            {!! Form::close() !!}
                        </td>
                    </tr>
                @endforeach
                </tbody>
            </table>
            {{ $schedules->links() }}
        </div>
    </div>
@endsection