@extends('admin.layouts.app')

@section('title', 'Parcel Manifests')

@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="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 ($collectionByOfficeParcel as $x => $office)
                                <div class="col-sm-6 col-xl-4"><a href="{{ route('Office Parcels', $office->id) }}" >
                                        <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">
                                                {{--                                                    <a href="{{ route('Office Bookings', $office->id) }}">{{ $office->name }}</a>--}}
                                                {{ $office->location }}
                                            </div>
                                            <br>

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

                                                $today = $localTime->format('d-M-Y');
                                                $tomorrow = date("d-M-Y", strtotime("+1 day"));
                                                $yesterday = date("d-M-Y", strtotime("-1 day"));

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

                                                $yesterdayA = date("d-M-Y 00:01:00", strtotime("-1 day"));
                                                $yesterdayB = date("d-M-Y 23:59:00", strtotime("-1 day"));

                                                $prevYesterdayA = date("d-M-Y 00:01:00", strtotime("-2 day"));
                                                $prevYesterdayB = date("d-M-Y 23:59:00", strtotime("-2 day"));

                                                $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('dateSent', [$todayA, $todayB])
                                                ->where('parcels.status', '>', 0)
                                                ->where('parcels.sentOffice', '=', $office->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('dateSent', [$todayA, $todayB])
                                                ->where('parcels.status', '>', 0)
                                                ->where('parcels.sentOffice', '=', $office->id)
                                                ->select('parcels.parcel', 'parcels.collection', 'parcels.count')
                                                ->sum('parcels.collection');



                                                $parcelsY = \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('dateSent', [$yesterdayA, $yesterdayB])
                                                ->where('parcels.status', '>', 0)
                                                ->where('parcels.sentOffice', '=', $office->id)
                                                ->select('parcels.parcel', 'parcels.collection', 'parcels.count', 'parcels.dateSent', 'parcels.status')
                                                ->count();
                                                $mauzoY = \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('dateSent', [$yesterdayA, $yesterdayB])
                                                ->where('parcels.status', '>', 0)
                                                ->where('parcels.sentOffice', '=', $office->id)
                                                ->select('parcels.parcel', 'parcels.collection', 'parcels.count')
                                                ->sum('parcels.collection');


                                                echo 'Today# Parcels: '.$parcels.' Sales: '.number_format($mauzo);
                                                echo '<br>';
                                                echo 'Yesterday# Parcels: '.$parcelsY.' Sales: '.number_format($mauzoY);


                                            @endphp
                                        </button>
                                    </a>
                                </div>
                            @endforeach

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

    </div>


    <div class="main-card mb-3 card">
        <div class="card-body">
            <table style="width: 100%;"
                   class="table table-hover table-striped table-bordered">

                <thead>HESABU KWA AGENT
                <tr>
                    <th>SN</th>
                    <th>AGENT</th>
                    <th>OFFICE</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($agentParcels as $i => $parcel)
                    <tr>
{{--                        <td>{{$i+1}}</td>--}}
                        <td>{{$i + $agentParcels->firstItem()}}</td>
                        <td>
                            @if($parcel->senderAgent == 0)
                                TiketiGala
                            @else
                                {{ \App\Models\Agent::where(['id' => $parcel->senderAgent])->first()->name }}
                            @endif
                        </td>
                        <td>
                            {{ \App\Models\Office::where(['id' => $parcel->sentOffice])->first()->location }}
                        </td>
                        <td>
                            @php
                                $localTime = new \DateTime("now", new \DateTimeZone('Africa/Dar_es_Salaam'));
                                $todayA = $localTime->format('d-M-Y 00:00:00');
                                $todayB = $localTime->format('d-M-Y 23:59:00');
                                $fareT = \App\Models\Parcel::where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->whereBetween('dateSent', [$todayA, $todayB])
                                ->sum('collection');
                                echo $fareT;
                            @endphp
                        </td>
                        <td>
                            @php
                                $fareLD = \App\Models\Parcel::whereDate('created_at', \Illuminate\Support\Carbon::yesterday()->toDateString())
                                ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                echo $fareLD;
                            @endphp
                        </td>
                        <td>
                            @php
                                $fareW = \App\Models\Parcel::whereBetween('created_at', [\Illuminate\Support\Carbon::now()->startOfWeek(), \Illuminate\Support\Carbon::now()->endOfWeek()])
                                ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                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\Parcel::whereBetween('created_at', [$start_week, $end_week])
                                    ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                    echo $fareLW;
                            @endphp
                        </td>
                        <td>
                            @php
                                $fareM = \App\Models\Parcel::whereMonth('created_at', date('m'))
                                ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                echo $fareM;
                            @endphp
                        </td>
                        <td>
                            @php
                                $fareLM = \App\Models\Parcel::whereMonth('created_at', '=', \Illuminate\Support\Carbon::now()->subMonth()->month)
                                ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                echo $fareLM;
                            @endphp
                        </td>
                        <td>
                            @php
                                $fareW = \App\Models\Parcel::whereYear('created_at', date('Y'))
                                ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                echo $fareW;
                            @endphp
                        </td>
                        <td>
                            @php
                                $fareW = \App\Models\Parcel::whereYear('created_at', date('Y', strtotime('-1 year')))
                                ->where('senderAgent', '=', $parcel->senderAgent)
                                ->where('status', '>', 0)
                                ->where('is_deleted', '=', 0)
                                ->sum('collection');
                                echo $fareW;
                            @endphp
                        </td>
                    </tr>
                @endforeach
                </tbody>
            </table>
            {{ $agentParcels->links() }}
        </div>
    </div>

    <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">
                <div class="main-search-input">
                    <form action="{{url('/search-parcel')}}" method="get" role="search" >
                        <div class="main-search-input-item">
                            <input type="text" name="search" placeholder="Search for Parcel?">
                        </div>
                        <button style="background: #1b6d85" class="button" type="submit" >Search</button>
                        <button style="margin-left: 5px;" class="button" href="{{ url('/parcel-manifests') }}">Refresh</button>
                    </form>
                </div>
                <thead>
                <tr>
                    <th>No</th>
                    <th>Parcel</th>
                    <th>Worthy</th>
                    <th>Cash</th>
                    <th>Tracking#</th>
{{--                    <th>Origin</th>--}}
                    <th>Destination</th>
                    <th>Sender</th>
                    <th>Receiver</th>
                    <th>Contacts</th>
                    <th>Agent</th>
                    <th>Office</th>
                    <th>Date</th>
                </tr>
                </thead>
                <tbody>
                @foreach($manifests as $i => $manifest)
                    <tr>
                        <td>{{$i + $manifests->firstItem()}}</td>
                        <td>{{ $manifest->parcel }}</td>
                        <td>{{ $manifest->parcelWorth }}</td>
                        <td>{{ $manifest->collection }}</td>
                        <td>{{ $manifest->trackingNumber }}</td>
{{--                        <td>{{ $manifest->origin }} </td>--}}
                        <td>{{ $manifest->destination }} </td>
                        <td>{{ $manifest->sender }}</td>
                        <td>{{ $manifest->receiver }}</td>
                        <td>{{ $manifest->senderMsisdn }}</td>
                        <td>
                            @php
                                $agent = \App\Models\Agent::where(['id' => $manifest->senderAgent])->first()->name;
                                echo $agent;
                            @endphp
                        </td>
                        <td>
                            @php
                                $office = \App\Models\Office::where(['id' => $manifest->sentOffice])->first()->location;
                                echo $office;
                            @endphp
                        </td>
                        <td>{{ $manifest->dateSent }}</td>

                    </tr>
                @endforeach
                </tbody>
            </table>
            {{ $manifests->links() }}
{{--            @php--}}
{{--            $aaa = "15-Jan-2022 01:42:10";--}}
{{--            $bbb = "16-Jan-2022 22:42:29";--}}

{{--            $agentTotal = DB::table('parcels')--}}
{{--            ->where('parcels.senderAgent', '=', 21)--}}
{{--            ->where('parcels.status', '=', 1)--}}
{{--            ->whereBetween('parcels.dateSent', [$aaa, $bbb])--}}
{{--            ->sum('parcels.collection');--}}

{{--            echo "Ibra : ".$agentTotal;--}}
{{--            @endphp--}}
        </div>
    </div>
@endsection