@extends('admin.layouts.app')

@section('title', 'Agents Report')

@section('content')

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


            <ul class="tabs-animated-shadow nav-justified tabs-animated nav">
                <li class="nav-item">
                    <a role="tab" class="nav-link active" id="tab-c1-0" data-toggle="tab"
                       href="#tab-animated1-0">
                        <span class="nav-text">AGENTS SUMMARY REPORT</span>
                    </a>
                </li>
                <li class="nav-item">
                    <a role="tab" class="nav-link" id="tab-c1-1" data-toggle="tab" href="#tab-animated1-1">
                        <span class="nav-text">AGENTS CUSTOM REPORT</span>
                    </a>
                </li>
            </ul>
            <div class="tab-content">
                <div class="tab-pane active" id="tab-animated1-0" role="tabpanel">


                    <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>AGENT</th>
                                    <th>TODAY</th>
                                    <th>YESTERDAY</th>
                                    <th>THIS WEEK</th>
                                    <th>LAST WEEK</th>
                                    <th>THIS MONTH</th>
                                    <th>LAST MONTH</th>
                                    <th>YEAR</th>
                                    <th>LAST YEAR</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($bs as $i => $booking)
                                    <tr>
                                        <td>{{$i+1}}</td>
                                        <td>
                                            @if($booking->agent_id == 0)
                                                 TiketiGala
                                            @else
                                                {{ \App\Models\Agent::where(['id' => $booking->agent_id])->first()->name }}
                                            @endif
                                        </td>
                                        <td>
                                            @php
                                                $fareT = \App\Models\Booking::whereDate('created_at', \Illuminate\Support\Carbon::today())
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareT;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $fareLD = \App\Models\Booking::whereDate('created_at', \Illuminate\Support\Carbon::yesterday()->toDateString())
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareLD;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $fareW = \App\Models\Booking::whereBetween('created_at', [\Illuminate\Support\Carbon::now()->startOfWeek(), \Illuminate\Support\Carbon::now()->endOfWeek()])
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareW;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $previous_week = strtotime("-1 week +1 day");
                                                $start_week = strtotime("last sunday midnight",$previous_week);
                                                $end_week = strtotime("next saturday",$start_week);
                                                $start_week = date("Y-m-d",$start_week);
                                                $end_week = date("Y-m-d",$end_week);

                                                    $fareLW = \App\Models\Booking::whereBetween('created_at', [$start_week, $end_week])
                                                    ->where('agent_id', '=', $booking->agent_id)
                                                    ->where('status', '>', 2)
                                                    ->sum('fare');
                                                    echo $fareLW;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $fareM = \App\Models\Booking::whereMonth('created_at', date('m'))
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareM;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $fareLM = \App\Models\Booking::whereMonth('created_at', '=', \Illuminate\Support\Carbon::now()->subMonth()->month)
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareLM;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $fareW = \App\Models\Booking::whereYear('created_at', date('Y'))
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareW;
                                            @endphp
                                        </td>
                                        <td>
                                            @php
                                                $fareW = \App\Models\Booking::whereYear('created_at', date('Y', strtotime('-1 year')))
                                                ->where('agent_id', '=', $booking->agent_id)
                                                ->where('status', '>', 2)
                                                ->sum('fare');
                                                echo $fareW;
                                            @endphp
                                        </td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>

                </div>
                <div class="tab-pane" id="tab-animated1-1" role="tabpanel">

                    <div class="main-card mb-3 card">
                        <div class="card-body">

                            <form method="POST" action="{{ route('Report By Date') }}" class="pull-left">
                                @csrf
                                <div class="row">

                                    <div class="col-md-3">
                                        <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-3">
                                        <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-4">
                                        <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-2">
                                        <button type="submit" name="export" value="export"
                                                class="btn text-white"
                                                style="background-color: #2b7895; color: white;">
                                            {{ __('EXPORT') }}
                                        </button>

                                    </div>

                                </div>
                            </form>


                            <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-success"></div>
                                            <div class="widget-content p-0">
                                                <div class="widget-content-wrapper">
                                                    <div class="widget-content-left">
                                                        <div class="widget-heading">Total Ticket Sold</div>
                                                    </div>

                                                    <div class="widget-content-right">
                                                        <div class="widget-subheading"><strong>{{ $totalAgents }}</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 ($trips as $x => $trip)--}}
{{--                                            <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' => $trip->route_id])->first()->start_point;--}}
{{--                                                                    $pB = \App\Models\Route::where(['id' => $trip->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');--}}

{{--                                                                            $bookings = \Illuminate\Support\Facades\DB::table('bookings')--}}
{{--                                                                            ->selectRaw('DATE_FORMAT(updated_at, "Y-m-d") as day, count(id) as count')--}}
{{--                                                                            ->whereDate('updated_at', $kifuaDate)--}}
{{--                                                                            ->where('schedule_id', $trip->id)--}}
{{--                                                                            ->where('status', '>', '1')--}}
{{--                                                                            ->count();--}}

{{--                                                                            echo $bookings;--}}
{{--                                                                        @endphp--}}
{{--                                                                    </strong>--}}
{{--                                                                </div>--}}
{{--                                                            </div>--}}
{{--                                                        </div>--}}
{{--                                                    </div>--}}
{{--                                                </div>--}}
{{--                                            </li>--}}
{{--                                        @endforeach--}}
{{--                                    </ul>--}}


                                </div>
                            </div>


                        </div>
                    </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">AGENTS</h5>
                </div>
                <div class="row">
                    <div class="col-md-1"></div>
                    <div class="col-md-10">


                        <div class="chart-container">
                            <div class="pie-chart-container">
                                <canvas id="pie-chart"></canvas>
                            </div>
                        </div>

                    </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">AGENTS REPORTS TODAY @php
                            $localTime = new \DateTime("now", new \DateTimeZone('Africa/Dar_es_Salaam'));
        $today = $localTime->format('d-M-Y');
        echo $today;
                        @endphp SALES</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">Total Agents</div>
                                        </div>

                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $totalAgents }}</strong></div>
                                        </div>
                                    </div>
                                </div>
                            </li>

                            <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">Non-commission Agents</div>
                                        </div>

                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $nonCommisionAgents }}</strong>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </li>


                            <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">Commission Agents</div>
                                        </div>

                                        <div class="widget-content-right">
                                            <div class="widget-subheading"><strong>{{ $commisionAgents }}</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 ($agents as $x => $agent)
                                <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
                                                        $name = \App\Models\Agent::where(['id' => $agent->agent])->first()->name;
                                                        echo $name;
                                                    @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');

                                                                $bookings = \Illuminate\Support\Facades\DB::table('bookings')
                                                                ->selectRaw('DATE_FORMAT(updated_at, "Y-m-d") as day, count(id) as count')
                                                                ->whereDate('updated_at', $kifuaDate)
                                                                ->where('agent_id', $agent->agent)
                                                                ->where('status', '>', '2')
                                                                ->count();

                                                                echo $bookings;
                                                            @endphp
                                                        </strong>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </li>
                            @endforeach
                        </ul>


                    </div>
                </div>

            </div>
        </div>
    </div>






@endsection