@extends('admin.layouts.app')
@section('title', 'Sales Report')
@section('content')
    <div class="row">
        <div class="col-md-8">
            <div class="main-card mb-3 card">
                <div class="card-body"><h5 class="card-title">SALES ANALYTICS</h5>
                </div>
                <div class="row">
                    <div class="col-md-1"></div>
                    <div class="col-md-10">
                        {!! $salesHistory->html() !!}
                    </div>
                </div>
            </div>
        </div>
        <div class="col-md-4">
            <div class="main-card mb-3 card">
                <div class="card-body"><h5 class="card-title">SALES CHANNELS</h5>
                </div>
                <div class="row">
                    <div class="col-md-1"></div>
                    <div class="col-md-10">
                        {!! $salesChannel->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">SALES REPORTS</h5>
                </div>
                <div class="row">
                    <div class="col-md-1"></div>
                    <div class="col-md-3">
                        <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 Sales</div>
                                        </div>

                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $todaySales }}
                                                    Tickets {{number_format($cTotalCollectionToday)}} /=</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 Sales
                                            </div>
                                        </div>
                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $mSales }}
                                                    Tickets {{number_format($cTotalCollectionMonth)}} /=</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">@php
                                                    $localTime = new \DateTime("now", new \DateTimeZone('Africa/Dar_es_Salaam'));
                                                    $month = $localTime->format('Y');

                                                echo $month;
                                                @endphp Year Sales
                                            </div>
                                        </div>
                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $ySales }}
                                                    Tickets {{number_format($cTotalCollectionYear)}} /=</strong></div>
                                        </div>
                                    </div>
                                </div>
                            </li>
                        </ul>
                    </div>
                    <div class="col-md-4">
                        <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 class="col-md-3">
                        <div class="main-card mb-3 card">
                            <div class="card-body"><h5 class="card-title">GENERATE REPORT</h5>

                                <form method="POST" action="{{ route('Report By Date') }}"
                                      enctype="multipart/form-data">
                                    @csrf
                                    <div class="row">
                                        <div class="col-md-12" style="margin-bottom: 4px;">
                                            <select class="form-control select" name="route">
                                                <option value="allRoutes">All Routes</option>
                                                @foreach($routes as $i => $route)
                                                    <option value="{{ $route->id }}">
                                                        {{\App\Models\Cities::where(['id' => $route->start_point])->first()->city}}
                                                        - {{\App\Models\Cities::where(['id' => $route->end_point])->first()->city}}
                                                        @if(\Illuminate\Support\Facades\Auth::user()->role == 1)
                                                            {{\App\Models\Company::where(['id' => $route->company])->first()->name}}
                                                        @endif
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-12" style="margin-bottom: 4px;">
                                            <input id="from_date" type="text" data-toggle="datepicker"
                                                   class="form-control{{ $errors->has('from_date') ? ' is-invalid' : '' }}"
                                                   name="from_date" value="{{ old('from_date') }}"
                                                   placeholder="From date">
                                        </div>
                                        <div class="col-md-12" style="margin-bottom: 4px;">
                                            <input id="to_date" type="text" data-toggle="datepicker"
                                                   class="form-control{{ $errors->has('to_date') ? ' is-invalid' : '' }}"
                                                   name="to_date" value="{{ old('to_date') }}" placeholder="To date">
                                        </div>
                                        <div class="col-md-12" style="margin-bottom: 4px;">
                                            <select class="form-control select" name="agent">
                                                <option value="All">All Agents</option>
                                                @foreach($agents as $i => $agent)
                                                    <option
                                                        value="{{ $agent->agent }}">{{ \App\Models\Agent::where(['id' => $agent->agent])->first()->name }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                        <div class="col-md-12" style="margin-bottom: 10px;">
                                            <select class="form-control select" name="queryOpt">
                                                <option value="tripDate">Trip Date</option>
                                                <option value="bookingDate">Sales Date</option>
                                            </select>
                                        </div>

                                        <div class="col-md-12 pull-right" style="margin-bottom: 4px;">
                                            <button type="submit" name="export" value="export" class="btn text-white"
                                                    style="background-color: #2b7895; color: white;">
                                                {{ __('EXPORT') }}
                                            </button>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    {!! \ConsoleTVs\Charts\Facades\Charts::scripts() !!}
    {!! $salesHistory->script() !!}
    {!! $salesChannel->script() !!}
@endsection