@extends('pages.admin.layout')

@section('content')
<!-- Main content -->
<section class="content">
    <div class="az-content-body az-contact-info-body">


        @php
        $now = \Carbon\Carbon::now();
        if($now->format('l') !== "Wednesday" || $now->format('l') !== "Friday")
        $now = \Carbon\Carbon::parse('last friday');
        $prevWeek = App\OrderAvailablity::where("week_year",
        ($now->weekOfYear).$now->year)->first();
        $selected = Request::query('weekID') ?? false;
        $currentWeekID = ($selected) ? App\OrderAvailablity::where("id",$selected)->first() : $prevWeek;
        $type = Request::query('type') ?? false;
        $orderArea = Request::query('orderArea') ?? false;

        @endphp

        <form role="form" enctype="multipart/form-data" method="get" id="formDetails"
              action="{{ route('admin.delivery.supplierbreakdown') }}" autocomplete="nope">
            {{ method_field('get') }}
            @csrf
            <div class="card card-invoice">
                <div class="card-body">

                    <div class="row gutters-tiny">
                        <div class="col-12">

                            <div class="font-size-lg font-w600 text-uppercase text-muted mb-2">Supplier Costings for:
                                {{$currentWeekID->title}} - Type: {{$type}}
                            </div>
                        </div>
                        <div class="col-md-6 col-xl-4">
                            <div class="block">
                                <div class="block-content block-content-full text-left">
                                    <div class="input-group">

                                        <select name="orderArea" id="orderArea" class="form-control form-control-lg">
                                            <option value="Edible16" @if($orderArea==
                                            'Edible16') selected="selected" @endif>Area: Edible16</option>
                                            <option value="Waterloo" @if($orderArea==
                                            'Waterloo') selected="selected" @endif>Area: Waterloo Cottage</option>
                                            <option value="Pearmans" @if($orderArea==
                                            'Pearmans') selected="selected" @endif>Area: Pearmans</option>
                                        </select>
                                        <select name="weekID" id="weekID"
                                                class="form-control form-control-lg pull-left">
                                            @foreach(App\OrderAvailablity::where("end_date","<=",
                                            $prevWeek->end_date)->orderBy("end_date", "desc")->limit(6)->get()
                                            as $week)
                                            <option value="{{$week->id}}" @if($currentWeekID->id == $week->id) selected="selected"
                                                @endif >
                                                {{str_replace("Delivery/Collection on", "",
                                                $week->title)}}
                                            </option>
                                            @endforeach
                                        </select>
                                        <div class="input-group-append">
                                            <button type="submit"
                                                    class="btn btn-primary btn-lg loadDeliveryCost">Filter
                                            </button>
                                        </div>
                                    </div>

                                </div>
                            </div>
                        </div>
                        <div class="col-md-6 col-xl-2">
                            <a class="block block-link-shadow" href="javascript:void(0)">
                                <div class="block-content block-content-full text-right">
                                    <div class="font-size-h2 font-w700">{{ $supplierDetails->totalsowed['count']}}
                                    </div>
                                    <div class="font-size-sm font-w600 text-uppercase text-muted">Total Orders</div>
                                </div>
                            </a>
                        </div>
                        <div class="col-md-6 col-xl-2">
                            <a class="block block-link-shadow" href="javascript:void(0)">
                                <div class="block-content block-content-full text-right">
                                    <div class="font-size-h2 font-w700">&pound;{{
                                        number_format($supplierDetails->totalsowed['income'],
                                        2)}}
                                    </div>
                                    <div class="font-size-sm font-w600 text-uppercase text-muted">Total Income</div>
                                </div>
                            </a>
                        </div>
                        <div class="col-md-6 col-xl-2">
                            <a class="block block-link-shadow" href="javascript:void(0)">
                                <div class="block-content block-content-full text-right">
                                    <div class="font-size-h2 font-w700">&pound;{{
                                        number_format($supplierDetails->totalsowed['suppliers'],
                                        2)}}
                                    </div>
                                    <div class="font-size-sm font-w600 text-uppercase text-muted">Total Owed</div>
                                </div>
                            </a>
                        </div>
                        <div class="col-md-6 col-xl-2">
                            <a class="block block-link-shadow" href="javascript:void(0)">
                                <div class="block-content block-content-full text-right">
                                    <div class="font-size-h2 font-w700">&pound;{{
                                        number_format($supplierDetails->totalsowed['commission'],
                                        2)}}
                                    </div>
                                    <div class="font-size-sm font-w600 text-uppercase text-muted">Total Commission</div>
                                </div>
                            </a>
                        </div>
                    </div>
                </div>
                @if($suppliers->count() > 0)

                <div class="card-body pt-15">
                    <table class="js-table-sections table table-hover">
                        <thead>
                        <tr>
                            <th>Name</th>
                            <th class="text-center">Products Picked</th>
                            <th class="text-center">Sales by Supplier</th>
                            <th class="text-center">Sales - Delivery</th>
                            <th class="text-center">Sales - Collection (Waterloo)</th>
                            <th class="text-center">Sales - Collection (EcoVillage)</th>
                            <th class="text-center">Commision Rate</th>
                            <th class="text-center">Commission Earned</th>
                        </tr>
                        </thead>
                        @foreach($suppliers->sortByDesc("totalPicked") as $supplier)
                            <tbody class="table-active">
                            <tr>
                                <td class="font-w600" style="font-size: 13pt;">{{$supplier->name}} (ID: {{$supplier->id}})</td>
                                <td class="text-center">{{$supplier->totalPicked}}</td>
                                <td class="text-center"><strong style="font-size: 12pt;">&pound;{{ number_format($supplier->totalSales, 2)}}</strong></td>
                                <td class="text-center"><strong style="font-size: 12pt;">&pound;{{ ($supplier->orderItems->where("LocationID", null)->count() > 0) ? number_format($supplier->orderItems->where("LocationID", null)->first()->cost, 2) : 0}}</strong></td>
                                <td class="text-center"><strong style="font-size: 12pt;">&pound;{{ ($supplier->orderItems->where("LocationID", 5)->count() > 0) ? number_format($supplier->orderItems->where("LocationID", 5)->first()->cost, 2): 0}}</strong></td>
                                <td class="text-center"><strong style="font-size: 12pt;">&pound;{{ ($supplier->orderItems->where("LocationID", 6)->count() > 0) ? number_format($supplier->orderItems->where("LocationID", 6)->first()->cost, 2): 0}}</strong></td>
                                <td class="text-center">{{number_format($supplier->fee_percentage, 2)}}%</td>
                                <td class="text-center">&pound;{{ number_format(($supplier->totalSales/100)*$supplier->fee_percentage, 2)}}</td>
                            </tr>
                            </tbody>

                        @endforeach
                    </table>
                </div>
                <div class="row gutters-tiny">
                    <div class="col-md-6 col-xl-6">
                        &nbsp;
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <a class="block block-link-shadow" href="javascript:void(0)">
                            <div class="block-content block-content-full text-right">
                                <div class="font-size-h2 font-w700">&pound;{{
                                    number_format($supplierDetails->totalsowed['income'],
                                    2)}}
                                </div>
                                <div class="font-size-sm font-w600 text-uppercase text-muted">Total Income</div>
                            </div>
                        </a>
                    </div>
                    <div class="col-md-6 col-xl-3">
                        <a class="block block-link-shadow" href="javascript:void(0)">
                            <div class="block-content block-content-full text-right">
                                <div class="font-size-h2 font-w700">&pound;{{
                                    number_format($supplierDetails->totalsowed['suppliers'],
                                    2)}}
                                </div>
                                <div class="font-size-sm font-w600 text-uppercase text-muted">Total Owed</div>
                            </div>
                        </a>
                    </div>
                </div>

            </div>
        </form>
        @endif
    </div>
</section>
@endsection
@section('scripts')
<script>
    jQuery(function () {
        Codebase.helpers('table-tools');
    });
</script>
<script>
    // $('#productsTable').DataTable()
</script>
@endsection