@extends('admin.layouts.app')

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

@section('content')

    @include('admin.includes.alerts')

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


            <div class="col">
                <div class="main-card mb-3 card">
                    <div class="card-body"><h5 class="card-title">
                            {{--                            @php--}}
                            {{--                                if(!empty($class)){--}}
                            {{--                                    $x = $class;--}}
                            {{--                                    echo $x.' CLASS ';--}}
                            {{--                                }--}}
                            {{--                            @endphp--}}
                        </h5>
                        <div class="scroll-area-lg">
                            <div class="scrollbar-container">
                                <div
                                    class="vertical-time-icons vertical-timeline vertical-timeline--animate vertical-timeline--one-column">

                                    <br>
                                    <h5 class="card-title" style="margin-left: 40px; color: #0b5885">TRIPS</h5>
                                    <br>

                                    @foreach($trips as $i => $trip)

                                        <div class="vertical-timeline-item vertical-timeline-element">
                                            <div><span class="vertical-timeline-element-icon bounce-in"><div
                                                        class="timeline-icon border-dark"><i
                                                            class="fa fa-road icon-gradient bg-plum-plate"></i></div></span>
                                                <div class="vertical-timeline-element-content bounce-in">
                                                    <h4
                                                        class="timeline-title">
                                                        <form method="post" action="{{ route('Trip Records') }}">
                                                            @csrf
                                                            <input type="hidden" name="schedule"
                                                                   value="{{ $trip->id }}">
                                                            <input type="hidden" name="route"
                                                                   value="{{ $trip->route_id  }}">
                                                            <button type="submit"
                                                                    class="mb-2 mr-2 btn-xs btn-icon btn-shadow btn-outline-2x btn btn-outline-primary">
                                                                <i class="lnr-clock btn-icon-wrapper"> </i>
                                                                @php
                                                                    $start_point = \App\Models\Route::where(['id' => $trip->route_id])->first()->start_point;
                                                                    $end_point = \App\Models\Route::where(['id' => $trip->route_id])->first()->end_point;
                                                                @endphp
                                                                {{\App\Models\Cities::where(['id' => $start_point])->first()->city}}
                                                                - {{\App\Models\Cities::where(['id' => $end_point])->first()->city}}
                                                            </button>
                                                            <button type="submit"
                                                                    class="mb-2 mr-2 btn-xs btn-icon btn-shadow btn-outline-2x btn btn-outline-dark">
                                                                <i class="lnr-bus btn-icon-wrapper"> </i>
                                                                {{$trip->label}} - {{$trip->trip_date}} {{$trip->departure}}
                                                            </button>
                                                            @if(\Illuminate\Support\Facades\Auth::user()->role == 1)
                                                                {{\App\Models\Company::where(['id' => $trip->company])->first()->name}}
                                                            @endif
                                                        </form>
                                                    </h4>
                                                </div>
                                            </div>
                                        </div>
                                    @endforeach
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


        </div>


        <div class="col-md-7">


            <div class="mb-3 card">
                <div class="card-body">
                    <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">RIPOTI YA SAFARI</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">MAPATO</span>
                            </a>
                        </li>
                        <li class="nav-item">
                            <a role="tab" class="nav-link" id="tab-c1-2" data-toggle="tab" href="#tab-animated1-2">
                                <span class="nav-text">MATUMIZI</span>
                            </a>
                        </li>
                    </ul>
                    <div class="tab-content">
                        <div class="tab-pane active" id="tab-animated1-0" role="tabpanel">

                            <table style="width: 100%;" id="example"
                                   class="table table-hover table-striped table-bordered">
                                <thead>
                                <tr>

                                    <th>#</th>
                                    <th>Abiria</th>
                                    <th>Jinsia</th>
                                    <th>Mawasiliano</th>
                                    <th>Siti</th>
                                    <th>Nauli</th>
                                    <th>Amelipia</th>
                                    <th>Wakala</th>
                                </tr>
                                </thead>
                                <tbody>

                                @foreach($bookings ?? '' as $i => $booking)

                                    <tr>
                                        <form method="post" enctype="multipart/form-data"
                                              action="{{ route('Update Sub-Route') }}">
                                            @csrf
                                            <td>{{$i+1}}</td>
                                            <td width="10%">{{$booking->fullname}}</td>
                                            <td width="4%">{{$booking->gender}}</td>
                                            <td>{{$booking->msisdn}}</td>
                                            <td>{{ \App\Models\BusSeat::where(['id' => $booking->seat_id])->first()->naming }}</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;--}}

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

{{--                                                        $fare = \App\Models\SubRoute::where(['pointA' => $cA, 'pointB' => $cB, 'company' => $booking->company, 'route' => $route])->first()->fare;--}}

{{--                                                        echo $fare;--}}

{{--                                                        }else{--}}

{{--                                                        $fare = \App\Models\SubRoute::where(['id' => $booking->sub_route_id])->first()->fare;--}}
{{--                                                        echo $fare;--}}

{{--                                                        }--}}
{{--                                                @endphp--}}
                                                @php
                                                    $schedule = \App\Models\Booking::where(['id' => $booking->id])->first()->schedule_id;
                                                    $seat = \App\Models\Booking::where(['id' => $booking->id])->first()->seat_id;

                                                    $tnxExists = \Illuminate\Support\Facades\DB::table('transactions')->where('schedule_id', $schedule)->where('seat_id', $seat)->count();

                                                    if($tnxExists > 0){
                                                        $amount = \App\Models\Transaction::where(['seat_id' => $seat, 'schedule_id' => $schedule])->first()->amount_in;
                                                     echo $amount;
                                                    }else{
                                                        $amount = \App\Models\Booking::where(['seat_id' => $seat, 'schedule_id' => $schedule])->first()->fare;
                                                        echo $amount;
                                                    }
                                                @endphp
                                            </td>
                                            <td>{{$booking->booking_date}}</td>
                                            <td>

                                                @if($booking->agent_id == 0 || $booking->agent_id == 1)
                                                    website
                                                @else
                                                    {{ \App\Models\Agent::where(['id' => $booking->agent_id])->first()->name }}
                                                @endif
                                            </td>
                                        </form>
                                    </tr>

                                @endforeach
                                </tbody>
                            </table>


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


                        </div>

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

                        </div>

                    </div>
                </div>

                <div class="d-block text-center card-footer">
                    @if($schedule ?? '')
                    <p>Jumla ya Nauli : <strong>
                            @php

                                $bookIds = \Illuminate\Support\Facades\DB::table('bookings')->where('schedule_id', $schedule)->where('status', '>', '2')->pluck('id');
                                $sum = 0;
                                foreach ($bookIds as $bookId) {
                                   // $totalFare = \Illuminate\Support\Facades\DB::table('transactions')->where('schedule_id', $schedule)->value('amount_in');
                                     $totalFare = \Illuminate\Support\Facades\DB::table('bookings')->where('id', $bookId)->value('fare');
                                     $sum+= $totalFare;
                                }

                                echo $sum;

                            @endphp
                        </strong></p>
                        @endif
                </div>

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


@endsection