@extends('admin.layouts.app')
@section('title', 'Tickets')
@section('content')
    @include('admin.includes.alerts')
    <style>
        @import url('https://fonts.googleapis.com/css?family=Raleway:500');

        /*body {*/
        /*    background-image: url(https://images.pexels.com/photos/735911/pexels-photo-735911.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940);*/
        /*    font-family: 'Raleway', sans-serif;*/
        /*}*/

        .main-search-input {
            margin: 20px auto;
            border-radius: 50px;
            max-width:1000px;
            width: 100%;
            background-color: #fff;
            box-shadow: 0 0 8px 0 rgba(0,0,0,.12);
            display: flex;
            flex-wrap: wrap;
            align-items: flex-start;
            padding: 9px;
            max-height: 68px;
        }

        .main-search-input-item {
            flex: 1;
            border-right: 1px solid #e9e9e9;
            margin-top: 3px;
            position: relative;
            padding-left: 30px;
            padding-right: 30px;
        }

        .main-search-input .main-search-input-item:nth-last-child(2) {
            border-right: 0;
            padding-left: 15px;
            padding-right: 15px;
        }

        .main-search-input input, .main-search-input input:focus {
            font-size: 16px;
            border: 0;
            background: #fff;
            margin: 0;
            padding: 0;
            height: 44px;
            line-height: 44px;
            box-shadow: none;
            max-width: 100%;
            width: 100%;
            font-family: 'Raleway', sans-serif;
            outline:none !important;
        }

        .main-search-input select {
            border: 0;
            padding-top: 2px;
            padding-bottom: 0;
            height: 44px;
            box-shadow: none;
            max-width: 100%;
            font-size: 16px;
            width: 100%;
            font-family: 'Raleway', sans-serif;
            outline:none !important;
        }

        .main-search-input button.button {
            font-family: 'Raleway', sans-serif;
            font-size: 16px;
            font-weight: 500;
            padding: 0 40px;
            margin-right: 1px;
            height: 50px;
            outline: 0;
            background-color: #f91942;
            color: #fff;
            position: relative;
            overflow: hidden;
            border: 0;
            border-radius: 50px;
        }
    </style>
    <div class="main-card mb-3 card">
        <div class="card-body">
            <table style="width: 100%;" class="table table-responsive table-hover table-striped table-bordered">
                <div class="main-search-input">
                    <form action="{{url('/search-tickets')}}" method="get" role="search" >
                        <div class="main-search-input-item">
                            <input type="text" name="search"
                                   placeholder="Search for Ticket#, Fiscal,Issued date">
                        </div>
                        <button style="background: #1b6d85" class="button" type="submit" >Search</button>
                        <button style="margin-left: 5px;" class="button" href="{{ url('/tickets') }}">Refresh</button>
                    </form>
                </div>
                <thead>
                <tr>
                    <th width="2%">SN</th>
                    <th width="11%">Passenger Name</th>
                    <th width="6%">Contact</th>
                    <th width="3%">Seat</th>
                    <th width="5%">Bus</th>
                    <th width="5%">Label</th>
                    <th width="6%">Date</th>
                    <th width="10%">Route</th>
                    <th width="6%">Amount</th>
                    <th width="10%">Issued at</th>
                    <th width="6%">Ticket#</th>
                    <th width="6%">Fiscal</th>
                    <th width="8%">Agent</th>
                    <th width="9%">Company</th>
                    <th width="4%">Board(&#10004;)</th>
                    <th width="5%">Action</th>
                </tr>
                </thead>
                <tbody>
                @foreach($tickets as $i => $ticket)
                    <tr>
                        <td>{{$i + $tickets->firstItem()}}</td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $passenger = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname;
                                    echo $passenger;
                                    }else{
                                    echo "";
                                    }
                            @endphp
                        </td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $contact = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->msisdn;
                                    echo $contact;
                                    }else{
                                    echo "";
                                    }
                            @endphp
                        </td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $seat = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->seat_id;
                                    $sn = \App\Models\BusSeat::where(['id' => $seat])->first()->naming;
                                    echo $sn;
                                    }else{
                                    }
                            @endphp
                        </td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $schedule = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->schedule_id;
                                    $bus_id = \App\Models\Schedule::where(['id' => $schedule])->first()->bus_id;
                                    $bus = \App\Models\Bus::where(['id' => $bus_id])->first()->bus_reg_no;
                                    echo $bus;
                                    }else{

                                    }
                            @endphp
                        </td>
                        <td width="6%">
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $schedule = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->schedule_id;
                                    $label = \App\Models\Schedule::where(['id' => $schedule])->first()->label;
                                    echo $label;
                                    }else{

                                    }
                            @endphp
                        </td>
                        <td width="7%">
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $schedule = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->schedule_id;
                                    $tDate = \App\Models\Schedule::where(['id' => $schedule])->first()->trip_date;
                                    echo $tDate;
                                    }else{
                                    echo '';
                                    }
                            @endphp
                        </td>
                        <td width="15%">@php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $schedule = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->schedule_id;
                                    $route = \App\Models\Schedule::where(['id' => $schedule])->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;
                                    echo $cA.' - '.$cB;
                                    }else{
                                    echo '';
                                    }
                            @endphp
                        </td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $schedule = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->schedule_id;
                                    $seat = \App\Models\BookingHistory::where(['id' => $ticket->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\BookingHistory::where(['seat_id' => $seat, 'schedule_id' => $schedule])->first()->fare;
                                        echo $amount;
                                    }
                                    }else{

                                    }
                            @endphp
                        </td>
                        <td>{{$ticket->printed_date}}</td>
                        <td>{{$ticket->qr_code}}</td>
                        <td>{{$ticket->fiscal_code}}</td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $agent = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->agent_id;
                                    if($agent == 0){
                                        $name = 'TiketiGala';
                                    }else{
                                        $name = \App\Models\Agent::where(['id' => $agent])->first()->name;
                                    }
                                    echo $name;
                                    }else{

                                    }
                            @endphp
                        </td>
                        <td>
                            @php
                                if((\App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->fullname) ?? ''){
                                    $compId = \App\Models\BookingHistory::where(['id' => $ticket->booking_id])->first()->company;
                                    $company = \App\Models\Company::where(['id' => $compId])->first()->name;
                                    echo $company;
                                    }else{

                                    }
                            @endphp
                        </td>
                        <td>
                            @if($ticket->status == 1)
                                No
                            @else
                                Yes
                            @endif
                        </td>
                        <td>
                            <a class="btn-icon btn-sm btn-primary" href="{{action('TicketController@reviewTicket', $ticket->id)}}">Print</a>
                        </td>
                    </tr>
                @endforeach
                </tbody>
            </table>
            {{ $tickets->links() }}
        </div>
    </div>
@endsection