@if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code) @else @endif
Start Date {{ date('d-m-Y', strtotime($params['start_date'])) }} End Date {{ date('d-m-Y', strtotime($params['end_date'])) }} (Amounts are in {{ Auth::user()->franchise->countries->currency_code }})(Amounts are in TZS)
@foreach ($deptList as $dept) @endforeach @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach($dept->subdepts as $sub_dept) @endforeach @else @endif @endforeach @php $b2bSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $b2bSumTotal += $subDeptSums[$sub_dept->id]['b2bsum'] @endphp @endforeach @else @php $b2bSumTotal += $deptSums[$dept->id]['b2bsum'] @endphp @endif @endforeach @php $b2cSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $b2cSumTotal += $subDeptSums[$sub_dept->id]['b2csum'] @endphp @endforeach @else @php $b2cSumTotal += $deptSums[$dept->id]['b2csum'] @endphp @endif @endforeach @php $invoiceSumTotal = $b2bSumTotal + $b2cSumTotal @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @endforeach @else @endif @endforeach @php $deptTotalRevenue = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @isset($deptTotalRevenue[$dept->id]) @php $deptTotalRevenue[$dept->id] += $subDeptSums[$sub_dept->id]['total']; @endphp @else @php $deptTotalRevenue[$dept->id] = $subDeptSums[$sub_dept->id]['total']; @endphp @endisset @endforeach @endif @endforeach @php $cogsSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $cogsSumTotal += $accountSubDepts[$sub_dept->id]['cogs_total'] @endphp @endforeach @else @php $cogsSumTotal += $accountDepts[$dept->id]['cogs_total'] @endphp @endif @endforeach @php $cogsTotalRevenue = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @isset($cogsTotalRevenue[$dept->id]) @php $cogsTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['cogs_total']; @endphp @else @php $cogsTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['cogs_total']; @endphp @endisset @endforeach @endif @endforeach @php $grossMarginTotal = $b2bSumTotal + $b2cSumTotal - $cogsSumTotal @endphp @php $firstSubDeptGrossMargin = []; @endphp @php $firstDeptGrossMargin = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] = $subDeptSums[$sub_dept->id]['total'] - $accountSubDepts[$sub_dept->id]['cogs_total']; @endphp @endforeach @else @php $firstDeptGrossMargin[$dept->id] = $deptSums[$dept->id]['total'] - $accountDepts[$dept->id]['cogs_total']; @endphp @endif @endforeach @php $secSubdeptgrossMarginTotal = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @php $secSubdeptgrossMarginTotal[$dept->id] = (int)$deptTotalRevenue[$dept->id] - (int)$cogsTotalRevenue[$dept->id]; @endphp @endif @endforeach @php $firstSubDeptGrossMarginSales = []; @endphp @php $firstDeptGrossMarginSales = []; @endphp @if($grossMarginTotal && $grossMarginTotal != 0 && $invoiceSumTotal != 0) @php $firstGrossMarginSalesTotalPercentage = round(($grossMarginTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp @elseif($grossMarginTotal && $grossMarginTotal != 0 && $invoiceSumTotal == 0) @php $firstGrossMarginSalesTotalPercentage = 'N/A'; @endphp @else @php $firstGrossMarginSalesTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($firstSubDeptGrossMargin[$dept->id][$sub_dept->id]) && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0) @php $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] = round(($firstSubDeptGrossMargin[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp @elseif($firstSubDeptGrossMargin[$dept->id][$sub_dept->id] && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0) @php $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($firstDeptGrossMargin[$dept->id]) && $firstDeptGrossMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0) @php $firstDeptGrossMarginSales[$dept->id] = round(($firstDeptGrossMargin[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp @elseif($firstDeptGrossMargin[$dept->id] && $firstDeptGrossMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptGrossMarginSales[$dept->id] = 'N/A'; @endphp @else @php $firstDeptGrossMarginSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptGrossMarginSales = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($secSubdeptgrossMarginTotal[$dept->id]) && $secSubdeptgrossMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0) @php $secSubDeptGrossMarginSales[$dept->id] = round(($secSubdeptgrossMarginTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp @elseif($secSubdeptgrossMarginTotal[$dept->id] && $secSubdeptgrossMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0) @php $secSubDeptGrossMarginSales[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptGrossMarginSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $hmcSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $hmcSumTotal += $accountSubDepts[$sub_dept->id]['hmc_total'] @endphp @endforeach @else @php $hmcSumTotal += $accountDepts[$dept->id]['hmc_total'] @endphp @endif @endforeach @php $hmcsTotalRevenue = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @isset($hmcsTotalRevenue[$dept->id]) @php $hmcsTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['hmc_total']; @endphp @else @php $hmcsTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['hmc_total']; @endphp @endisset @endforeach @endif @endforeach @php $contMarginTotal = $grossMarginTotal - $hmcSumTotal @endphp @php $firstSubDeptContMargin = []; @endphp @php $firstDeptContMargin = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $firstSubDeptContMargin[$dept->id][$sub_dept->id] = $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] - $accountSubDepts[$sub_dept->id]['hmc_total']; @endphp @endforeach @else @php $firstDeptContMargin[$dept->id] = $firstDeptGrossMargin[$dept->id] - $accountDepts[$dept->id]['hmc_total']; @endphp @endif @endforeach @php $secSubdeptContMarginTotal = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @php $secSubdeptContMarginTotal[$dept->id] = $secSubdeptgrossMarginTotal[$dept->id] - $hmcsTotalRevenue[$dept->id]; @endphp @endif @endforeach @php $firstSubDeptContMarginSales = []; @endphp @php $firstDeptContMarginSales = []; @endphp @if($contMarginTotal && $contMarginTotal != 0 && $invoiceSumTotal != 0) @php $firstContMarginSalesTotalPercentage = round(($contMarginTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp @elseif($contMarginTotal && $contMarginTotal != 0 && $invoiceSumTotal == 0) @php $firstContMarginSalesTotalPercentage = 'N/A'; @endphp @else @php $firstContMarginSalesTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($firstSubDeptContMargin[$dept->id][$sub_dept->id]) && $firstSubDeptContMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0) @php $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] = round(($firstSubDeptContMargin[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp @elseif($firstSubDeptContMargin[$dept->id][$sub_dept->id] && $firstSubDeptContMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0) @php $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($firstDeptContMargin[$dept->id]) && $firstDeptContMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0) @php $firstDeptContMarginSales[$dept->id] = round(($firstDeptContMargin[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp @elseif(isset($firstDeptContMargin[$dept->id]) && $firstDeptContMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptContMarginSales[$dept->id] = 'N/A'; @endphp @else @php $firstDeptContMarginSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptContMarginSales = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($secSubdeptContMarginTotal[$dept->id]) && $secSubdeptContMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0) @php $secSubDeptContMarginSales[$dept->id] = round(($secSubdeptContMarginTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp @elseif(isset($secSubdeptContMarginTotal[$dept->id]) && $secSubdeptContMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0) @php $secSubDeptContMarginSales[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptContMarginSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $opeSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $opeSumTotal += $accountSubDepts[$sub_dept->id]['ope_total'] @endphp @endforeach @else @php $opeSumTotal += $accountDepts[$dept->id]['ope_total'] @endphp @endif @endforeach @php $opeTotalRevenue = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @isset($opeTotalRevenue[$dept->id]) @php $opeTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['ope_total']; @endphp @else @php $opeTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['ope_total']; @endphp @endisset @endforeach @endif @endforeach @php $firstSubDeptOpeSales = []; @endphp @php $firstDeptOpeSales = []; @endphp @if($opeSumTotal && $opeSumTotal != 0 && $invoiceSumTotal != 0) @php $firstOpeSalesTotalPercentage = round(($opeSumTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp @elseif($opeSumTotal && $opeSumTotal != 0 && $invoiceSumTotal == 0) @php $firstOpeSalesTotalPercentage = 'N/A'; @endphp @else @php $firstOpeSalesTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($accountSubDepts[$sub_dept->id]['ope_total']) && $accountSubDepts[$sub_dept->id]['ope_total'] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0) @php $firstSubDeptOpeSales[$dept->id][$sub_dept->id] = round(($accountSubDepts[$sub_dept->id]['ope_total'] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) .'%'; @endphp @elseif(isset($accountSubDepts[$sub_dept->id]['ope_total']) && $accountSubDepts[$sub_dept->id]['ope_total'] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0) @php $firstSubDeptOpeSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptOpeSales[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($accountDepts[$dept->id]['ope_total']) && $accountDepts[$dept->id]['ope_total'] != 0 && $deptSums[$dept->id]['total'] != 0) @php $firstDeptOpeSales[$dept->id] = round(($accountDepts[$dept->id]['ope_total'] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp @elseif(isset($accountDepts[$dept->id]['ope_total']) && $accountDepts[$dept->id]['ope_total'] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptOpeSales[$dept->id] = 'N/A'; @endphp @else @php $firstDeptOpeSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptOpeSales = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($opeTotalRevenue[$dept->id]) && $opeTotalRevenue[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0) @php $secSubDeptOpeSales[$dept->id] = round(($opeTotalRevenue[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp @elseif(isset($opeTotalRevenue[$dept->id]) && $opeTotalRevenue[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0) @php $secSubDeptOpeSales[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptOpeSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $netOpeIncomeTotal = $contMarginTotal - $opeSumTotal @endphp @php $firstSubDeptNetOpeIncome = []; @endphp @php $firstDeptNetOpeIncome = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] = $firstSubDeptContMargin[$dept->id][$sub_dept->id] - $accountSubDepts[$sub_dept->id]['ope_total']; @endphp @endforeach @else @php $firstDeptNetOpeIncome[$dept->id] = $firstDeptContMargin[$dept->id] - $accountDepts[$dept->id]['ope_total']; @endphp @endif @endforeach @php $secSubdeptNetOpeIncomeTotal = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @php $secSubdeptNetOpeIncomeTotal[$dept->id] = $secSubdeptContMarginTotal[$dept->id] - $opeTotalRevenue[$dept->id]; @endphp @endif @endforeach @php $firstSubDeptNetOpeIncomeSales = []; @endphp @php $firstDeptNetOpeIncomeSales = []; @endphp @if($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $invoiceSumTotal != 0) @php $firstNetOpeIncomeSalesTotalPercentage = round(($netOpeIncomeTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp @elseif($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $invoiceSumTotal == 0) @php $firstNetOpeIncomeSalesTotalPercentage = 'N/A'; @endphp @else @php $firstNetOpeIncomeSalesTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0) @php $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] = round(($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp @elseif(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0) @php $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0) @php $firstDeptNetOpeIncomeSales[$dept->id] = round(($firstDeptNetOpeIncome[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp @elseif(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptNetOpeIncomeSales[$dept->id] = 'N/A'; @endphp @else @php $firstDeptNetOpeIncomeSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptNetOpeIncomeSales = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0) @php $secSubDeptNetOpeIncomeSales[$dept->id] = round(($secSubdeptNetOpeIncomeTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp @elseif(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0) @php $secSubDeptNetOpeIncomeSales[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptNetOpeIncomeSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $firstSubDeptNetOpeIncomeGm = []; @endphp @php $firstDeptNetOpeIncomeGm = []; @endphp @if($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $grossMarginTotal != 0) @php $firstNetOpeIncomeGmTotalPercentage = round(($netOpeIncomeTotal * 100) / $grossMarginTotal, 2) . '%'; @endphp @elseif($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $grossMarginTotal == 0) @php $firstNetOpeIncomeGmTotalPercentage = 'N/A'; @endphp @else @php $firstNetOpeIncomeGmTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0) @php $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] = round(($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] * 100) / $firstSubDeptGrossMargin[$dept->id][$sub_dept->id], 2) . '%'; @endphp @elseif(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] == 0) @php $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $firstDeptGrossMargin[$dept->id] != 0) @php $firstDeptNetOpeIncomeGm[$dept->id] = round(($firstDeptNetOpeIncome[$dept->id] * 100) / $firstDeptGrossMargin[$dept->id], 2) . '%'; @endphp @elseif(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptNetOpeIncomeGm[$dept->id] = 'N/A'; @endphp @else @php $firstDeptNetOpeIncomeGm[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptNetOpeIncomeGm = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] != 0) @php $secSubDeptNetOpeIncomeGm[$dept->id] = round(($secSubdeptNetOpeIncomeTotal[$dept->id] * 100) / (int)$secSubdeptgrossMarginTotal[$dept->id], 2) . '%'; @endphp @elseif(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] == 0) @php $secSubDeptNetOpeIncomeGm[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptNetOpeIncomeGm[$dept->id] = ''; @endphp @endif @endif @endforeach @php $investmentSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $investmentSumTotal += $accountSubDepts[$sub_dept->id]['inst_total'] @endphp @endforeach @else @php $investmentSumTotal += $accountDepts[$dept->id]['inst_total'] @endphp @endif @endforeach @php $investmentTotalRevenue = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @isset($investmentTotalRevenue[$dept->id]) @php $investmentTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['inst_total']; @endphp @else @php $investmentTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['inst_total']; @endphp @endisset @endforeach @endif @endforeach @php $netIncomeTotal = $netOpeIncomeTotal - $investmentSumTotal @endphp @php $firstSubDeptNetIncome = []; @endphp @php $firstDeptNetIncome = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $firstSubDeptNetIncome[$dept->id][$sub_dept->id] = $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] - $accountSubDepts[$sub_dept->id]['inst_total']; @endphp @endforeach @else @php $firstDeptNetIncome[$dept->id] = $firstDeptNetOpeIncome[$dept->id] - $accountDepts[$dept->id]['inst_total']; @endphp @endif @endforeach @php $secSubdeptNetIncomeTotal = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @php $secSubdeptNetIncomeTotal[$dept->id] = $secSubdeptNetOpeIncomeTotal[$dept->id] - $investmentTotalRevenue[$dept->id]; @endphp @endif @endforeach @php $firstSubDeptNetIncomeSales = []; @endphp @php $firstDeptNetIncomeSales = []; @endphp @if($netIncomeTotal && $netIncomeTotal != 0 && $invoiceSumTotal != 0) @php $firstNetIncomeSalesTotalPercentage = round(($netIncomeTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp @elseif($netIncomeTotal && $netIncomeTotal != 0 && $invoiceSumTotal == 0) @php $firstNetIncomeSalesTotalPercentage = 'N/A'; @endphp @else @php $firstNetIncomeSalesTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0) @php $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] = round(($firstSubDeptNetIncome[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp @elseif(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0) @php $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0) @php $firstDeptNetIncomeSales[$dept->id] = round(($firstDeptNetIncome[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp @elseif(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptNetIncomeSales[$dept->id] = 'N/A'; @endphp @else @php $firstDeptNetIncomeSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptNetIncomeSales = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0) @php $secSubDeptNetIncomeSales[$dept->id] = round(($secSubdeptNetIncomeTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp @elseif(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0) @php $secSubDeptNetIncomeSales[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptNetIncomeSales[$dept->id] = ''; @endphp @endif @endif @endforeach @php $firstSubDeptNetIncomeGm = []; @endphp @php $firstDeptNetIncomeGm = []; @endphp @if($netIncomeTotal && $netIncomeTotal != 0 && $grossMarginTotal != 0) @php $firstNetIncomeGmTotalPercentage = round(($netIncomeTotal * 100) / $grossMarginTotal, 2) . '%'; @endphp @elseif($netIncomeTotal && $netIncomeTotal != 0 && $grossMarginTotal == 0) @php $firstNetIncomeGmTotalPercentage = 'N/A'; @endphp @else @php $firstNetIncomeGmTotalPercentage = ''; @endphp @endif @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @if(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0) @php $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] = round(($firstSubDeptNetIncome[$dept->id][$sub_dept->id] * 100) / $firstSubDeptGrossMargin[$dept->id][$sub_dept->id], 2) . '%'; @endphp @elseif(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] == 0) @php $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] = 'N/A'; @endphp @else @php $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] = ''; @endphp @endif @endforeach @else @if(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $firstDeptGrossMargin[$dept->id] != 0) @php $firstDeptNetIncomeGm[$dept->id] = round(($firstDeptNetIncome[$dept->id] * 100) / $firstDeptGrossMargin[$dept->id], 2) . '%'; @endphp @elseif(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0) @php $firstDeptNetIncomeGm[$dept->id] = 'N/A'; @endphp @else @php $firstDeptNetIncomeGm[$dept->id] = ''; @endphp @endif @endif @endforeach @php $secSubDeptNetIncomeGm = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @if(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] != 0) @php $secSubDeptNetIncomeGm[$dept->id] = round(($secSubdeptNetIncomeTotal[$dept->id] * 100) / (int)$secSubdeptgrossMarginTotal[$dept->id], 2) . '%'; @endphp @elseif(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] == 0) @php $secSubDeptNetIncomeGm[$dept->id] = 'N/A'; @endphp @else @php $secSubDeptNetIncomeGm[$dept->id] = ''; @endphp @endif @endif @endforeach @php $taxSumTotal = '0' @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @php $taxSumTotal += $accountSubDepts[$sub_dept->id]['tax_total'] @endphp @endforeach @else @php $taxSumTotal += $accountDepts[$dept->id]['tax_total'] @endphp @endif @endforeach @php $taxTotalRevenue = []; @endphp @foreach ($deptList as $dept) @if($dept->subdepts_count > 0) @foreach ($dept->subdepts as $sub_dept) @isset($taxTotalRevenue[$dept->id]) @php $taxTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['tax_total']; @endphp @else @php $taxTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['tax_total']; @endphp @endisset @endforeach @endif @endforeach
subdepts_count > 0) colspan="{{ $dept->subdepts_count }}" @endif style="text-align:center; width: 18px; height: 20px; border: 1px solid black; background-color:@if($loop->odd) #CCB2FF @elseif($loop->even) #FFE6AB @endif">{{ $dept->name }} Total
{{ $sub_dept->name }}-
B2B{{ $subDeptSums[$sub_dept->id]['b2bsum'] ? round($subDeptSums[$sub_dept->id]['b2bsum'], 2) : '' }}{{ $deptSums[$dept->id]['b2bsum'] ? round($deptSums[$dept->id]['b2bsum'], 2) : ''}} {{ $b2bSumTotal ? round($b2bSumTotal, 2) : '' }}
B2C{{ $subDeptSums[$sub_dept->id]['b2csum'] ? round($subDeptSums[$sub_dept->id]['b2csum'], 2) : '' }}{{ $deptSums[$dept->id]['b2csum'] ? round($deptSums[$dept->id]['b2csum'], 2) : ''}} {{ $b2cSumTotal ? round($b2cSumTotal, 2) : '' }}
Total Revenue{{ $subDeptSums[$sub_dept->id]['total'] ? round($subDeptSums[$sub_dept->id]['total'], 2) : '' }}{{ $deptSums[$dept->id]['total'] ? round($deptSums[$dept->id]['total'], 2) : ''}} {{ $invoiceSumTotal ? round($invoiceSumTotal, 2) : '' }}
{{ $deptTotalRevenue[$dept->id] ? round($deptTotalRevenue[$dept->id], 2) : '' }}
Cost of Goods Sold{{ $accountSubDepts[$sub_dept->id]['cogs_total'] ? round($accountSubDepts[$sub_dept->id]['cogs_total'], 2) : '' }}{{ $accountDepts[$dept->id]['cogs_total'] ? round($accountDepts[$dept->id]['cogs_total'], 2) : ''}} {{ $cogsSumTotal ? round($cogsSumTotal, 2) : '' }}
{{ $cogsTotalRevenue[$dept->id] ? round($cogsTotalRevenue[$dept->id], 2) : '' }}
Gross Margin{{ $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] ? round($firstSubDeptGrossMargin[$dept->id][$sub_dept->id], 2) : '' }}{{ $firstDeptGrossMargin[$dept->id] ? round($firstDeptGrossMargin[$dept->id], 2) : ''}} {{ $grossMarginTotal ? round($grossMarginTotal, 2) : '' }}
{{ $secSubdeptgrossMarginTotal[$dept->id] ? round($secSubdeptgrossMarginTotal[$dept->id], 2) : '' }}
as % of Sales{{ $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptGrossMarginSales[$dept->id] ?? ''}} {{ $firstGrossMarginSalesTotalPercentage ?? '' }}
{{ $secSubDeptGrossMarginSales[$dept->id] ?? '' }}
Human Capital{{ $accountSubDepts[$sub_dept->id]['hmc_total'] ? round($accountSubDepts[$sub_dept->id]['hmc_total'], 2) : '' }}{{ $accountDepts[$dept->id]['hmc_total'] ? round($accountDepts[$dept->id]['hmc_total'], 2) : ''}} {{ $hmcSumTotal ? round($hmcSumTotal, 2) : '' }}
{{ $hmcsTotalRevenue[$dept->id] ? round($hmcsTotalRevenue[$dept->id], 2) : '' }}
Contribution Margin{{ $firstSubDeptContMargin[$dept->id][$sub_dept->id] ? round($firstSubDeptContMargin[$dept->id][$sub_dept->id], 2) : '' }}{{ $firstDeptContMargin[$dept->id] ? round($firstDeptContMargin[$dept->id], 2) : ''}} {{ $contMarginTotal ? round($contMarginTotal, 2) : '' }}
{{ $secSubdeptContMarginTotal[$dept->id] ? round($secSubdeptContMarginTotal[$dept->id], 2) : '' }}
as % of Sales{{ $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptContMarginSales[$dept->id] ?? ''}} {{ $firstContMarginSalesTotalPercentage ?? '' }}
{{ $secSubDeptContMarginSales[$dept->id] ?? '' }}
Operating Expense{{ $accountSubDepts[$sub_dept->id]['ope_total'] ? round($accountSubDepts[$sub_dept->id]['ope_total'], 2) : '' }}{{ $accountDepts[$dept->id]['ope_total'] ? round($accountDepts[$dept->id]['ope_total'], 2) : ''}} {{ $opeSumTotal ? round($opeSumTotal, 2) : '' }}
{{ $opeTotalRevenue[$dept->id] ? round($opeTotalRevenue[$dept->id], 2) : '' }}
as % of Sales{{ $firstSubDeptOpeSales[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptOpeSales[$dept->id] ?? ''}} {{ $firstOpeSalesTotalPercentage ?? '' }}
{{ $secSubDeptOpeSales[$dept->id] ?? '' }}
Net Operating Income{{ $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] ? round($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id], 2) : '' }}{{ $firstDeptNetOpeIncome[$dept->id] ? round($firstDeptNetOpeIncome[$dept->id], 2) : ''}} {{ $netOpeIncomeTotal ? round($netOpeIncomeTotal, 2) : '' }}
{{ $secSubdeptNetOpeIncomeTotal[$dept->id] ? round($secSubdeptNetOpeIncomeTotal[$dept->id], 2) : '' }}
as % of Sales{{ $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptNetOpeIncomeSales[$dept->id] ?? ''}} {{ $firstNetOpeIncomeSalesTotalPercentage ?? '' }}
{{ $secSubDeptNetOpeIncomeSales[$dept->id] ?? '' }}
as % of GM{{ $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptNetOpeIncomeGm[$dept->id] ?? ''}} {{ $firstNetOpeIncomeGmTotalPercentage ?? '' }}
{{ $secSubDeptNetOpeIncomeGm[$dept->id] ?? '' }}
Investment{{ $accountSubDepts[$sub_dept->id]['inst_total'] ? round($accountSubDepts[$sub_dept->id]['inst_total'], 2) : '' }}{{ $accountDepts[$dept->id]['inst_total'] ? round($accountDepts[$dept->id]['inst_total'], 2) : ''}} {{ $investmentSumTotal ? round($investmentSumTotal, 2) : '' }}
{{ $investmentTotalRevenue[$dept->id] ? round($investmentTotalRevenue[$dept->id], 2) : '' }}
Net Income{{ $firstSubDeptNetIncome[$dept->id][$sub_dept->id] ? round($firstSubDeptNetIncome[$dept->id][$sub_dept->id], 2) : '' }}{{ $firstDeptNetIncome[$dept->id] ? round($firstDeptNetIncome[$dept->id], 2) : ''}} {{ $netIncomeTotal ? round($netIncomeTotal, 2) : '' }}
{{ $secSubdeptNetIncomeTotal[$dept->id] ? round($secSubdeptNetIncomeTotal[$dept->id], 2) : '' }}
as % of Sales{{ $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptNetIncomeSales[$dept->id] ?? ''}} {{ $firstNetIncomeSalesTotalPercentage ?? '' }}
{{ $secSubDeptNetIncomeSales[$dept->id] ?? '' }}
as % of GM{{ $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] ?? '' }}{{ $firstDeptNetIncomeGm[$dept->id] ?? ''}} {{ $firstNetIncomeGmTotalPercentage ?? '' }}
{{ $secSubDeptNetIncomeGm[$dept->id] ?? '' }}
Tax{{ $accountSubDepts[$sub_dept->id]['tax_total'] ? round($accountSubDepts[$sub_dept->id]['tax_total'], 2) : '' }}{{ $accountDepts[$dept->id]['tax_total'] ? round($accountDepts[$dept->id]['tax_total'], 2) : ''}} {{ $taxSumTotal ? round($taxSumTotal, 2) : '' }}
{{ $taxTotalRevenue[$dept->id] ? round($taxTotalRevenue[$dept->id], 2) : '' }}