@php $currencySums = []; @endphp @forelse ($projections as $projection) @php if (!isset($currencySums[$projection->currency])) { $currencySums[$projection->currency] = [ 'salesExpectedConversion' => 0, 'salesRevenue' => 0, 'salesTotalRevenue' => 0, 'salesRevenueThisMonth' => 0, 'deliveryExpectedConversion' => 0, 'deliveryTotalRevenue' => 0, 'deliveryRevenueThisMonth' => 0, 'volumeDeal' => 0, ]; } $currencySums[$projection->currency]['salesExpectedConversion'] += floatval($projection->salesExpectedConversion ?? 0); $currencySums[$projection->currency]['salesRevenue'] += floatval($projection->salesRevenue ?? 0); $currencySums[$projection->currency]['salesTotalRevenue'] += floatval($projection->salesTotalRevenue ?? 0); $currencySums[$projection->currency]['salesRevenueThisMonth'] += floatval($projection->salesRevenueThisMonth ?? 0); $currencySums[$projection->currency]['deliveryExpectedConversion'] += floatval($projection->deliveryExpectedConversion ?? 0); $currencySums[$projection->currency]['deliveryTotalRevenue'] += floatval($projection->deliveryTotalRevenue ?? 0); $currencySums[$projection->currency]['deliveryRevenueThisMonth'] += floatval($projection->deliveryRevenueThisMonth ?? 0); $currencySums[$projection->currency]['volumeDeal'] += floatval($projection->volumeDeal ?? 0); @endphp @php $status = ''; $color = 'success'; if ($projection->cpStatus === 'salesCreated') { $status = 'Delivery Pending'; $color = 'warning'; } if ($projection->cpStatus === 'deliveryUpdated') { $status = 'Sales Pending'; $color = 'secondary'; } if ($projection->cpStatus === 'escalatedSubmit') { $status = 'Submitted'; $color = 'success'; } if ($projection->cpStatus === 'escalated') { $status = 'In-Escalation'; $color = 'danger'; } if ($projection->cpStatus === 'submitted' || $projection->cpStatus === 'presubmitted') { $status = 'Submitted'; } @endphp @empty @endforelse @foreach ($currencySums as $key => $curr) @endforeach

Offer Name	Source	Vertical & Region	Sales Revenue Projection			Volume Deal (VD)	Delivery Revenue Projection		Status
			Conversions/Day	Unit Cost	Remaining This Month		Conversions/Day	Remaining This Month
{{ $projection->campaignName ?? $projection->campName }} (#{{ $projection->campId }}) {{ $projection->userFullName }} {{ $projection->submittedByUser ? ' / ' . $projection->submittedByUser : '' }} @if($projection->campLiveStatus) {{ ucfirst($projection->campLiveStatus) }} @endif	{{ ucwords($projection->campSource) }}	{{-- {{ $projection->campRegion }} --}} {{ $projection->campVertical }} {{ $projection->regionName }}	{{ $projection->salesExpectedConversion }}	{{ $projection->currency }} {{ sprintf("%0.2f", $projection->salesRevenue) }}	{{ $projection->currency }} {{ sprintf("%0.2f", $projection->salesRevenueThisMonth) }}	{{ $projection->currency }} {{ sprintf("%0.2f", $projection->volumeDeal) }}	{{ $projection->deliveryExpectedConversion ?? "-" }}	{{ $projection->currency }} {{ sprintf("%0.2f", $projection->deliveryRevenueThisMonth) }}	{{ $status }} {{ $status == "Submitted" || $status == "Sales Pending" ? "" : $projection->pendingForDeliveryUser }}
Total
	Conversions/Day	Unit Cost	Remaining This Month	Volume Deal (VD)	Conversions/Day	Remaining This Month
{{ $key }}	{{ number_format($curr['salesExpectedConversion'], 2) }}	{{ number_format($curr['salesRevenue'], 2) }}	{{ number_format($curr['salesRevenueThisMonth'], 2) }}	{{ number_format($curr['volumeDeal'], 2) }}	{{ number_format($curr['deliveryExpectedConversion'], 2) }}	{{ number_format($curr['deliveryRevenueThisMonth'], 2) }}

@php $currencySums = []; @endphp @forelse ($projections as $projection) @php $salesExpectedConversion1 = $projection->salesExpectedConversion ?? 0; $salesRevenue1 = $projection->salesRevenue ?? 0; $salesRevenueThisMonth1 = $projection->salesRevenueThisMonth ?? 0; $salesTotalRevenue1 = $projection->salesTotalRevenue ?? 0; $deliveryExpectedConversion1 = $projection->deliveryExpectedConversion ?? 0; $deliveryTotalRevenue1 = $projection->deliveryTotalRevenue ?? 0; $deliveryRevenueThisMonth1 = (isset($projection->newAmount) && $projection->newAmount > 0) ? $projection->newAmount : $projection->deliveryRevenueThisMonth; $trackedRevenue1 = $projection->trackedRevenue ?? 0; $revenueTillDate1 = $projection->revenueTillDate ?? 0; $actualClientRevenue1 = $projection->actualClientRevenue ?? 0; $volumeDeal1 = $projection->volumeDeal ?? 0; if (!isset($currencySums[$projection->currency])) { $currencySums[$projection->currency] = [ "salesExpectedConversion" => 0, "salesRevenue" => 0, "salesTotalRevenue" => 0, "salesRevenueThisMonth" => 0, "deliveryExpectedConversion" => 0, "deliveryTotalRevenue" => 0, "deliveryRevenueThisMonth" => 0, "trackedRevenue" => 0, "revenueTillDate" => 0, "actualClientRevenue" => 0, "volumeDeal" => 0 ]; } $currencySums[$projection->currency]["salesExpectedConversion"] += floatval($salesExpectedConversion1); $currencySums[$projection->currency]["salesRevenue"] += floatval($salesRevenue1); $currencySums[$projection->currency]["salesTotalRevenue"] += floatval($salesTotalRevenue1); $currencySums[$projection->currency]["salesRevenueThisMonth"] += floatval($salesRevenueThisMonth1); $currencySums[$projection->currency]["deliveryExpectedConversion"] += floatval($deliveryExpectedConversion1); $currencySums[$projection->currency]["deliveryTotalRevenue"] += floatval($deliveryTotalRevenue1); $currencySums[$projection->currency]["deliveryRevenueThisMonth"] += floatval($deliveryRevenueThisMonth1); $currencySums[$projection->currency]["trackedRevenue"] += floatval($trackedRevenue1); $currencySums[$projection->currency]["revenueTillDate"] += floatval($revenueTillDate1); $currencySums[$projection->currency]["actualClientRevenue"] += floatval($actualClientRevenue1); $currencySums[$projection->currency]["volumeDeal"] += floatval($volumeDeal1); @endphp @php $changesAbs = $projection->changes ? abs(round($projection->changes)) : 0; $changes = $projection->changes ? round($projection->changes) : 0; @endphp @empty @endforelse @foreach ($currencySums as $key => $curr) @endforeach

Offer Name	Vertical & Region	Projected Rev. for the Month	Volume Deal (VD)	Expected Rev. Till Date	Tracked Rev. till Date	Actual/Client Rev	Diff./Day (%)
{{ $projection->campaignName ?? $projection->campName }} (#{{ $projection->campId }}) {{ $projection->userFullName }} {{ $projection->submittedByUser ? ' / ' . $projection->submittedByUser : '' }} @if($projection->campLiveStatus) {{ ucfirst($projection->campLiveStatus) }} @endif	{{-- {{ $projection->campRegion }} --}} {{ $projection->campVertical }} {{ $projection->regionName }}	{{ $projection->currency }} {{ sprintf("%0.2f", $deliveryRevenueThisMonth1) }}	{{ $projection->currency }} {{ sprintf("%0.2f", $projection->volumeDeal) }}	{{ $projection->currency }} {{ $projection->revenueTillDate }}	{{ $projection->currency }} {{ $projection->trackedRevenue ?? '0.00' }}	{{ $projection->currency }} {{ $projection->actualClientRevenue ?? '0.00' }}	{{ $changesAbs }}%
Total
	P.R.F.M	Volume Deal (VD)	E.R.T.D	T.R.T.D	Actual/Client Rev
{{ $key }}	{{ number_format($curr['deliveryRevenueThisMonth'], 2) }}	{{ number_format($curr['volumeDeal'], 2) }}	{{ number_format($curr['revenueTillDate'], 2) }}	{{ number_format($curr['trackedRevenue'], 2) }}	{{ number_format($curr['actualClientRevenue'], 2) }}