@extends('admin.layouts.app')
@section('title', 'Booking Report')
@section('content')
    <div class="row">
        <div class="col-md-12">
            <div class="main-card mb-3 card">
                <div class="card-body"><h5 class="card-title">BOOKINGS ANALYTICS</h5>
                </div>
                <div class="row">
                    <div class="col-md-1"></div>
                    <div class="col-md-10">

                        {!! $bookingHistory->html() !!}

                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="main-card mb-3 card">
                <div class="card-body"><h5 class="card-title">BOOKINGS REPORTS</h5>
                </div>
                <div class="row">
                    <div class="col-md-1"></div>
                    <div class="col-md-2">
                        <ul class="todo-list-wrapper list-group list-group-flush">
                            <li class="list-group-item">
                                <div class="todo-indicator bg-warning"></div>
                                <div class="widget-content p-0">
                                    <div class="widget-content-wrapper">
                                        <div class="widget-content-left">
                                            <div class="widget-heading">Today Bookings</div>
                                        </div>

                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $tBookings }}</strong></div>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="list-group-item">
                                <div class="todo-indicator bg-info"></div>
                                <div class="widget-content p-0">
                                    <div class="widget-content-wrapper">
                                        <div class="widget-content-left">
                                            <div class="widget-heading">@php
                                                    $localTime = new \DateTime("now", new \DateTimeZone('Africa/Dar_es_Salaam'));
                                                    $month = $localTime->format('M');
                                                echo $month;
                                                @endphp Month's Bookings
                                            </div>
                                        </div>
                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $mBookings }}</strong></div>
                                        </div>
                                    </div>
                                </div>
                            </li>
                            <li class="list-group-item">
                                <div class="todo-indicator bg-success"></div>
                                <div class="widget-content p-0">
                                    <div class="widget-content-wrapper">
                                        <div class="widget-content-left">
                                            <div class="widget-heading">Yearly Bookings</div>
                                        </div>
                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $yBookings }}</strong></div>
                                        </div>
                                    </div>
                                </div>
                            </li>
                        </ul>
                    </div>
                    <div class="col-md-1"></div>
                    <div class="col-md-6">

                        <ul class="todo-list-wrapper list-group list-group-flush">
                            @foreach ($routes as $x => $route)
                                <li class="list-group-item">
                                    <div class="todo-indicator bg-focus"></div>
                                    <div class="widget-content p-0">
                                        <div class="widget-content-wrapper">
                                            <div class="widget-content-left">
                                                <div class="widget-heading">
                                                    @php
                                                        $pA = \App\Models\Route::where(['id' => $route->id])->first()->start_point;
                                                        $pB = \App\Models\Route::where(['id' => $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;
                                                    @endphp
                                                </div>
                                            </div>
                                            <div class="widget-content-right">
                                                <div class="widget-subheading">
                                                    <div><strong>

                                                            @php
                                                                $localTime = new \DateTime("now", new \DateTimeZone('Africa/Dar_es_Salaam'));
                                                                $kifuaDate = $localTime->format('Y-m-d');

                                                                $today = $localTime->format('Y-m-d');

                                                                $bookings = \Illuminate\Support\Facades\DB::table('booking_histories')
                                                                ->leftJoin('sub_routes', function ($join) {
                                                                    $join->on('sub_routes.id', '=', 'booking_histories.sub_route_id');
                                                                })
                                                                ->leftJoin('routes', function ($join) {
                                                                    $join->on('routes.id', '=', 'sub_routes.route');
                                                                })
                                                                ->where('booking_histories.company', '=', \Illuminate\Support\Facades\Auth::user()->company)
                                                                ->where('booking_histories.booking_date', $today)
                                                                ->where('booking_histories.status', '>', 2)
                                                                ->where('routes.id', '=', $route->id)
                                                                ->select('booking_histories.fullname as passenger', 'booking_histories.msisdn', 'booking_histories.status',
                                                                'booking_histories.booking_date')
                                                                ->count();

                                                                $mauzo = \Illuminate\Support\Facades\DB::table('booking_histories')
                                                                ->leftJoin('sub_routes', function ($join) {
                                                                    $join->on('sub_routes.id', '=', 'booking_histories.sub_route_id');
                                                                })
                                                                ->leftJoin('routes', function ($join) {
                                                                    $join->on('routes.id', '=', 'sub_routes.route');
                                                                })
                                                                ->where('booking_histories.company', '=', \Illuminate\Support\Facades\Auth::user()->company)
                                                                ->where('booking_histories.booking_date', $today)
                                                                ->where('booking_histories.status', '>', 2)
                                                                ->where('routes.id', '=', $route->id)
                                                                ->select('booking_histories.fullname as passenger', 'booking_histories.msisdn', 'booking_histories.status',
                                                                'booking_histories.booking_date')
                                                                ->sum('booking_histories.fare');


                                                                echo 'Tickets: '.$bookings.' Sales: '.number_format($mauzo);
                                                            @endphp
                                                        </strong>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </li>
                            @endforeach
                        </ul>

                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">

            <div class="main-card mb-3 card">
                <div class="card-body">
                    <table style="width: 100%;" id="example" class="table table-hover table-striped table-bordered">
                        <thead>
                        <tr>
                            <th>SN</th>
                            <th>Full Name</th>
                            <th>Mobile</th>
                            <th>Gender</th>
                            <th>Schedule</th>
                            <th>Seat</th>
                            <th>Agent</th>
                            <th>Status</th>
                            <th>Route</th>
                            <th>Class</th>
                            <th>Booking Date</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach($bs as $i => $booking)
                            <tr>
                                <td>{{$i+1}}</td>
                                <td>{{$booking->fullname}}</td>
                                <td>{{$booking->msisdn}}</td>
                                <td>{{$booking->gender}}</td>
                                <td>
                                    @php
                                        $trip_date = \App\Models\Schedule::where(['id' => $booking->schedule_id])->first()->trip_date;

                                            echo $trip_date;
                                    @endphp
                                </td>
                                <td>{{ \App\Models\BusSeat::where(['id' => $booking->seat_id])->first()->naming }}</td>
                                <td>
                                    @if($booking->agent_id == 0)
                                        WEB TECHNOLOGIES
                                    @else
                                        {{ \App\Models\Agent::where(['id' => $booking->agent_id])->first()->name }}
                                    @endif
                                </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">PAID CASH</span>
                                    @elseif($booking->status == 4)
                                        <span class="mb-2 mr-2 badge badge-info">PAID ONLINE</span>
                                    @else
                                        <span class="mb-2 mr-2 badge badge-danger">N/A</span>
                                    @endif
                                </td>
                                <td>
                                    @php
                                        if($booking->sub_route_id == null){
                                        $route = \App\Models\Schedule::where(['id' => $booking->schedule_id])->first()->route_id;
                                        $pA = \App\Models\Route::where(['id' => $route])->first()->start_point;
                                        $pB = \App\Models\Route::where(['id' => $route])->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()->pointA;
                                        $to = \App\Models\SubRoute::where(['id' => $booking->sub_route_id])->first()->pointB;

                                        echo $from .' - '.$to;

                                        }
                                    @endphp
                                </td>
                                <td>
                                    @php
                                        $route = \App\Models\Schedule::where(['id' => $booking->schedule_id])->first()->route_id;
                                            $class = \App\Models\Route::where(['id' => $route])->first()->class;
                                    @endphp
                                    @if($class == 1)
                                        <span class="mb-2 mr-2 badge badge-primary">VVIP</span>
                                    @elseif($class == 2)
                                        <span class="mb-2 mr-2 badge badge-success">VIP</span>
                                    @elseif($class == 3)
                                        <span class="mb-2 mr-2 badge badge-info">LUXURY</span>
                                    @elseif($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->booking_date}}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    {!! \ConsoleTVs\Charts\Facades\Charts::scripts() !!}
    {!! $bookingHistory->script() !!}
@endsection