id, 0)) ->orderBy('name') ->get(); $groupPercentTotal = 0; // сумма процентов всех групп $groupPercentSumTotal = 0; // сумма бюджетов групп $noDebtNoPlanGroups = ''; // часть таблицы с группами без плана и расходов $noDebtOrNoPlanGroups = ''; // часть таблицы с группами c планом и без расходов (+ есть расход, нет плана) ?> @foreach ($budgetCostsGroups as $budgetCostsGroup) getGroupSum($workProject->id, $endDate); $groupPercent = $budgetCostsGroup->getGroupPercent($workProject->id); $groupPercentAmount = round($groupPercent['amount'] / 100, 2); // бюджет группы в процентах $groupPercentId = $groupPercent['id']; $groupPercentSum = round($workProject->getCurrentBudgetMonthPlan()*$groupPercentAmount / 100, 2); // бюджет группы в руб. $groupPercentTotal += $groupPercentAmount; // сумма процентов всех групп $groupPercentSumTotal += $groupPercentSum; ?> @if($groupFactSum && $groupPercentAmount) 0){ $cellBgColor = '#99FFCC;'; }elseif ($relDivergence < 0) { $cellBgColor = '#FF6666;'; }else{ $cellBgColor = '#CCCCCC;'; } ?> budgetCosts = $budgetCostsGroup->budgetCosts->sortBy(function ($budgetCost) { return $budgetCost->name; }); ?> @foreach ($budgetCostsGroup->budgetCosts as $budgetCost) getSum($workProject->id, $endDate); ?> @if($costSum) @endif @if(!$costSum) '; ?> @endif @endforeach {{ $noDebtCosts }} @endif @if( (!$groupFactSum && $groupPercentAmount) || ($groupFactSum && !$groupPercentAmount)) 0){ $cellBgColor = '#99FFCC;'; }elseif ($relDivergence < 0) { $cellBgColor = '#FF6666;'; }else{ $cellBgColor = '#CCCCCC;'; } $noDebtCosts = ''; // часть группы без расходов $noDebtOrNoPlanGroups .= ''; $budgetCostsGroup->budgetCosts = $budgetCostsGroup->budgetCosts->sortBy(function ($budgetCost) { return $budgetCost->name; }); ?> @foreach ($budgetCostsGroup->budgetCosts as $budgetCost) getSum($workProject->id, $endDate); ?> @if($costSum) '; ?> @endif @if(!$costSum) '; ?> @endif @endforeach @endif @if(!$groupFactSum && !$groupPercentAmount) '; ?> @endif @endforeach {{ $noDebtOrNoPlanGroups }} {{ $noDebtNoPlanGroups }} id, 0)) ->whereBudgetCostGroupId(0) ->orderBy('name') ->get(); ?> @if ($budgetCostsUnknown) @foreach ($budgetCostsUnknown as $budgetCostUnknown) @endforeach @endif getAllCost($endDate) - $workProject->getUnknownDebtSum($endDate)); if($relTotalDivergence > 0){ $cellBgColor = '#99FFCC;'; }elseif ($relTotalDivergence < 0) { $cellBgColor = '#FF6666;'; }else{ $cellBgColor = '#CCCCCC;'; } ?>

Проект {{ $workProject->name }}
План-фактный анализ движения денежных средств на дату {{ $endDate }}
Бюджет	Статья	% в бюджете	План	Факт	Отклонение аб., руб.	Отклонение относ., %
{{ $workProject->getCurrentBudgetMonthPlan() }}
	{{ $budgetCostsGroup->name }}	{{ ($groupPercentAmount)? round($groupPercentAmount, 2):0 }}	{{ ($groupPercentSum)? round($groupPercentSum, 2):0 }}	{{ round($groupFactSum, 2) }}	{{ round( ($groupPercentSum-$groupFactSum), 2) }}	{{ round($relDivergence, 1) }}
	{{ str_replace($budgetCostsGroup->name . '. ', '', $budgetCost->name) }}			{{ $costSum }}
	'. str_replace($budgetCostsGroup->name . '. ', '', $budgetCost->name).'			'. $costSum .'
	'. $budgetCostsGroup->name .'	'. round($groupPercentAmount, 2) .'	'. round($groupPercentSum, 2) .'	'. round($groupFactSum, 2) .'	'. round( ($groupPercentSum-$groupFactSum), 2 ) .'	'.$relDivergence.'
	'. str_replace($budgetCostsGroup->name . '. ', '', $budgetCost->name) .'			'. $costSum .'
	'. str_replace($budgetCostsGroup->name . '. ', '', $budgetCost->name).'			'. $costSum .'
	'.$budgetCostsGroup->name.'	'. round($groupPercentAmount, 2).'	'. round($groupPercentSum, 2).'	'. round($groupFactSum, 2) .'	'. round(($groupPercentSum-$groupFactSum), 2) .'
	Без группы			{{ $workProject->getUnknownGroupSum($endDate) }}
	{{ $budgetCostUnknown->name }}			{{ $budgetCostUnknown->getSum($workProject->id, $endDate) }}
	Без категории			{{ $workProject->getUnknownSum($endDate) }}
	На долги			{{ $workProject->getUnknownDebtSum($endDate) }}
Всего			{{ $groupPercentSumTotal }}	{{ $workProject->getAllCost($endDate) - $workProject->getUnknownDebtSum($endDate)}}	{{ $groupPercentSumTotal - ($workProject->getAllCost($endDate) - $workProject->getUnknownDebtSum($endDate)) }}	{{ ($groupPercentSumTotal)? round( (100 - 100*($workProject->getAllCost($endDate)- $workProject->getUnknownDebtSum($endDate))/$groupPercentSumTotal), 2 ):0 }}
К выводу						{{ round( $relTotalDivergence, 2 ) }}