@extends('admin.layouts.app')

@section('title', 'Today Online Booking')

@section('content')

    @include('admin.includes.alerts')

    <div class="row">

        <div class="col-lg-12 col-xl-12">
            <div class="main-card mb-3 card">
                <div class="card-body">
                    <h5 class="card-title">Mauzo Mtandaoni<a href="#">
                                <span><h2>@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');
                                                                    })
                                                                    ->leftJoin('schedules', function ($join) {
                                                                        $join->on('schedules.id', '=', 'booking_histories.schedule_id');
                                                                    })
                                                                    ->where('booking_histories.company', '=', \Illuminate\Support\Facades\Auth::user()->company)
                                                                    ->where('schedules.trip_date', $today)
                                                                    ->where('booking_histories.status', '=', 4)
                                                                    ->select('booking_histories.fullname as passenger', 'booking_histories.msisdn', 'booking_histories.status',
                                                                    'booking_histories.booking_date')
                                                                    ->count();

                                        echo $bookings;

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

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

                                                            $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');
                                            })
                                            ->leftJoin('schedules', function ($join) {
                                                                        $join->on('schedules.id', '=', 'booking_histories.schedule_id');
                                            })
                                            ->where('booking_histories.company', '=', \Illuminate\Support\Facades\Auth::user()->company)
                                            ->where('schedules.trip_date', $today)
                                            ->where('booking_histories.status', '=', 4)
                                            ->select('booking_histories.fullname as passenger', 'booking_histories.msisdn', 'booking_histories.status',
                                            'booking_histories.booking_date')
                                            ->sum('booking_histories.fare');

                                echo number_format($mauzo);

                                @endphp TZs</h2></span>
                        </a></h5>
                    <div class="grid-menu grid-menu-3col">
                        <div class="no-gutters row">
                            @foreach ($routesReport as $x => $route)
                                <div class="col-sm-6 col-xl-4">
                                    <a href="{{ route('Route Online Bookings for Today', $route->id) }}"><button
                                            class="btn-icon-vertical btn-square btn-transition btn btn-outline-link">
                                            @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
                                            <br>
                                            <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');
                                                    })
                                                    ->leftJoin('schedules', function ($join) {
                                                                        $join->on('schedules.id', '=', 'booking_histories.schedule_id');
                                                    })
                                                    ->where('booking_histories.company', '=', \Illuminate\Support\Facades\Auth::user()->company)
                                                    ->where('schedules.trip_date', $today)
                                                    ->where('booking_histories.status', '>', 3)
                                                    ->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');
                                                    })
                                                    ->leftJoin('schedules', function ($join) {
                                                                        $join->on('schedules.id', '=', 'booking_histories.schedule_id');
                                                                    })
                                                    ->where('booking_histories.company', '=', \Illuminate\Support\Facades\Auth::user()->company)
                                                    ->where('schedules.trip_date', $today)
                                                    ->where('booking_histories.status', '>', 3)
                                                    ->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>

                                        </button></a>
                                </div>

                            @endforeach
                        </div>
                    </div>
                    {{--                            <div class="divider"></div>--}}
                </div>
            </div>
        </div>

    </div>

{{--    <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>No</th>--}}
{{--                    <th>Parcel</th>--}}
{{--                    <th>Worthy</th>--}}
{{--                    <th>Cash</th>--}}
{{--                    <th>Tracking#</th>--}}
{{--                    <th>Destination</th>--}}
{{--                    <th>Sender</th>--}}
{{--                    <th>Receiver</th>--}}
{{--                    <th>Contacts</th>--}}
{{--                    <th>Agent</th>--}}
{{--                    <th>Office</th>--}}
{{--                    <th>Date</th>--}}
{{--                </tr>--}}
{{--                </thead>--}}
{{--                <tbody>--}}
{{--                @foreach($manifests as $i => $manifest)--}}
{{--                    <tr>--}}
{{--                        <td>{{$i+1}}</td>--}}
{{--                        <td>{{ $manifest->parcel }}</td>--}}
{{--                        <td>{{ $manifest->parcelWorth }}</td>--}}
{{--                        <td>{{ $manifest->collection }}</td>--}}
{{--                        <td>{{ $manifest->trackingNumber }}</td>--}}
{{--                        <td>{{ $manifest->destination }} </td>--}}
{{--                        <td>{{ $manifest->sender }}</td>--}}
{{--                        <td>{{ $manifest->receiver }}</td>--}}
{{--                        <td>{{ $manifest->senderMsisdn }}</td>--}}
{{--                        <td>--}}
{{--                            @php--}}
{{--                                $agent = \App\Models\Agent::where(['id' => $manifest->senderAgent])->first()->name;--}}
{{--                                echo $agent;--}}
{{--                            @endphp--}}
{{--                        </td>--}}
{{--                        <td>--}}
{{--                            @php--}}
{{--                                $office = \App\Models\Office::where(['id' => $manifest->sentOffice])->first()->location;--}}
{{--                                echo $office;--}}
{{--                            @endphp--}}
{{--                        </td>--}}
{{--                        <td>{{ $manifest->dateSent }}</td>--}}

{{--                    </tr>--}}
{{--                @endforeach--}}
{{--                </tbody>--}}
{{--            </table>--}}
{{--        </div>--}}
{{--    </div>--}}
@endsection