@php $from = $widget['date_from']; $to = $widget['date_to']; @endphp

Year to date Sales

{{$from}} - {{$to}}
@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
{{$group->name}}

${{number_format($companyAmountTotal)}}


@foreach ($companyArray as $key => $company) @endforeach
{{$company['company_name']}} ${{number_format($company['company_amount'])}}
@endforeach