@php
    $from = $widget['date_from'];
    $to = $widget['date_to'];
@endphp
<div class="container">
    <div class="widget-view row mb-3">
        <div class="col-md-12 text-center mb-3">
            <h2 class="mt-5 mb-0">Year to date Sales</h2>
            <small>{{$from}} - {{$to}}</small>
        </div>
        @php
            $groups = \App\Models\CompanyGroup::with([
                'companies' => function ($company) use ($from, $to) {
                    $company->with([
                        'projects' => function($query) use  ($from, $to) {
                            $query->where('is_confirmed', true);
                            $query->whereBetween('created_at', [$from, $to]);
                        }
                    ]);
                },
            ])->get();
        @endphp
        @foreach ($groups as $group)
            @php

                $companyAmountTotal = 0;
                $companyArray = array();
                $loopNumber = 0;

                foreach ($group->companies as $company) {

                    $companyAmount = 0;

                    $agreements = \App\Models\Agreement::where('company_id', $company->id)
                                    ->where('is_approved', true)
                                    ->where('approved_by', '!=', null)
                                    ->whereBetween('created_at', [$from, $to])
                                    ->get();

                    $variationOrders = \App\Models\VariationOrder::where('company_id', $company->id)
                                    ->whereBetween('created_at', [$from, $to])
                                    ->get();

                    foreach ($agreements as $agreement) {
                        $agreementItem = \App\Models\AgreementItem::where('agreement_id', $agreement->id)->limit(1)->orderBy('id', 'desc')->first();
                        if ($agreementItem) {
                            $agreementItemLists = \App\Models\AgreementItemList::where('agreement_id', $agreement->id)->where('agreement_item_id', $agreementItem->id)->where('tier_level', 1)->get();
                            foreach ($agreementItemLists as $agreementItemList) {
                                $companyAmount += $agreementItemList->amount;
                            }
                        }
                    }

                    foreach ($variationOrders as $variationOrder) {
                        $variationOrderItem = \App\Models\VariationOrderItem::where('variation_order_id', $variationOrder->id)->limit(1)->orderBy('id', 'desc')->first();
                        if ($variationOrderItem) {
                            $variationOrderItemLists = \App\Models\VariationOrderItemList::where('variation_order_id', $variationOrder->id)->where('variation_order_item_id', $variationOrderItem->id)->where('tier_level', 1)->get();
                            foreach ($variationOrderItemLists as $variationOrderItemList) {
                                $companyAmount += $variationOrderItemList->amount;
                            }
                        }
                    }

                    $companyArray[$loopNumber]['company_name'] = $company->name;
                    $companyArray[$loopNumber]['company_amount'] = $companyAmount;
                    $companyAmountTotal += $companyAmount;
                    $loopNumber++;
                }

            @endphp
            <div class="col-md-4">
                <div class="row ytd-sales px-4 pt-4 pb-3">
                    <div class="col-md-6 text-left heading mt-2">
                        <b>{{$group->name}}</b>
                    </div>
                    <div class="col-md-6 text-right heading mt-1">
                        <h3 class='mb-0'>${{number_format($companyAmountTotal)}}</h3>
                    </div>
                    <div class="col-md-12">
                        <hr/>
                        <table class="table table-sm table-borderless">
                            <tbody>
                                @foreach ($companyArray as $key => $company)
                                    <tr>
                                        <td>{{$company['company_name']}}</td>
                                        <td>${{number_format($company['company_amount'])}}</td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        @endforeach
    </div>
</div>