@extends('admin.layouts.app')

@section('title', 'Office Route Parcel')

@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 Vifirushi(Parcel)</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">

                                        <button class="btn-icon-vertical btn-square btn-transition btn btn-outline-link" >
                                            <div class="widget-subheading fsize-1 pt-2 opacity-10 text-danger font-weight-bold">
                                                @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>
                                            <br>

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

                                                $today = $localTime->format('Y-m-d');
                                                $todayA = $localTime->format('d-M-Y 00:01:00');
                                                $todayB = $localTime->format('d-M-Y 23:59:00');

                                            $parcels = \Illuminate\Support\Facades\DB::table('parcels')
                                            ->leftJoin('agents', function ($join) {
                                                $join->on('agents.id', '=', 'parcels.senderAgent');
                                            })
                                            ->leftJoin('agent_companies', function ($join) {
                                                $join->on('agent_companies.agent', '=', 'agents.id');
                                            })
                                            ->leftJoin('companies', function ($join) {
                                                $join->on('companies.id', '=', 'parcels.company');
                                            })
                                            ->whereBetween('parcels.dateSent', [$todayA, $todayB])
                                            ->where('parcels.status', '>', 0)
                                            ->where('parcels.route_id', '=', $route->id)
                                            ->where('parcels.sentOffice', '=', $id)
                                            ->select('parcels.parcel', 'parcels.collection', 'parcels.count', 'parcels.dateSent', 'parcels.status')
                                            ->count();

                                                $mauzo = \Illuminate\Support\Facades\DB::table('parcels')
                                            ->leftJoin('agents', function ($join) {
                                                $join->on('agents.id', '=', 'parcels.senderAgent');
                                            })
                                            ->leftJoin('agent_companies', function ($join) {
                                                $join->on('agent_companies.agent', '=', 'agents.id');
                                            })
                                            ->leftJoin('companies', function ($join) {
                                                $join->on('companies.id', '=', 'parcels.company');
                                            })
                                            ->whereBetween('parcels.dateSent', [$todayA, $todayB])
                                            ->where('parcels.status', '>', 0)
                                            ->where('parcels.route_id', '=', $route->id)
                                            ->where('parcels.sentOffice', '=', $id)
                                            ->select('parcels.parcel', 'parcels.collection', 'parcels.count')
                                            ->sum('parcels.collection');

                                                echo 'Parcels: '.$parcels.' Sales: '.number_format($mauzo);
                                            @endphp

                                            <br>
                                            {!! Form::open(array(
                                 'style' => 'display: inline-block;',
                                 'method' => 'GET',
                                 'route' => ['Print Cargo Manifest', $route->id, $id])) !!}
                                            {!! Form::submit('Print Manifest', array('class' => 'btn btn-sm btn-dark', 'rel' => 'Alternate', 'media' => 'print')) !!}
                                            {!! Form::close() !!}

                                            {!! Form::open(array(
                                                 'style' => 'display: inline-block;',
                                                 'method' => 'GET',
                                                 'route' => ['Office Manifest By Route', $route->id, $id])) !!}
                                            {!! Form::submit('View', array('class' => 'btn btn-sm btn-info')) !!}
                                            {!! Form::close() !!}

                                        </button>


                                </div>


                            @endforeach

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










    </div>



@endsection