<html>
	<head>
	  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	</head>
	<body>
		@if ($user->hasRole(Role::ROLE_BUDGET))
			<?php $budgetCostsGroups = BudgetCostGroup::orderBy('name')->get(); ?>
			<table>
				<thead>
					<tr>
						<td style="font-size: 12; font-weight: bold; text-align: right">Общие расходы по проектам на дату {{ $endDate }}</td>
					</tr>
					<tr >
						<th> Группы расходов</th>
						<th class="text-right">Итого</th>
						@foreach ($user->notNullCostsBudjetProjects() as $project)
							<th class="text-right">{{ $project->name }}</th>
						@endforeach
					</tr>
				</thead>
				<tbody>
				@foreach ($budgetCostsGroups as $budgetCostsGroup)
						<tr style="font-size: 12; font-weight: bold;">
							<td style="font-size: 12; font-weight: bold;">
								{{ $budgetCostsGroup->name }}
							</td>
							<td>{{ round($budgetCostsGroup->getTotalGroupSumOutcome($endDate), 2) }}</td>
							@foreach ($user->notNullCostsBudjetProjects() as $project)
								<?php $groupFactSumOutcome = $budgetCostsGroup->getGroupSumOutcome($project->id, $endDate); ?>
								<td>{{ round($groupFactSumOutcome, 2) }}</td>
							@endforeach
						</tr>
						<?php
							$budgetCostsGroup->budgetCosts = $budgetCostsGroup->budgetCosts->sortBy(function ($budgetCost) {
								return $budgetCost->name;
							});
						?>
						@foreach ($budgetCostsGroup->budgetCosts as $budgetCost)
							<tr style="display: none;">
								<td>{{ str_replace($budgetCostsGroup->name . '. ', '', $budgetCost->name) }}</td>
								<td>{{ $budgetCost->getTotalSumOutcome($endDate) }}</td>
								@foreach ($user->notNullCostsBudjetProjects() as $project)
									<?php $costSumOutcome = $budgetCost->getSumOutcome($project->id, $endDate); ?>
									<td>{{ $costSumOutcome }}</td>
								@endforeach
							</tr>
						@endforeach
				@endforeach
					<tr style="font-size: 12; font-weight: bold;">
						<td>Без группы</td>
						<td>{{ $project->getTotalUnknownGroupSumOutcome($endDate) }}</td>
						@foreach ($user->notNullCostsBudjetProjects() as $project)
							<td>{{ $project->getUnknownGroupSumOutcome($endDate) }}</td>
						@endforeach
					</tr>
					<tr style="font-size: 12; font-weight: bold;">
						<td>Без категории</td>
						<td>{{ $project->getTotalUnknownSumOutcome($endDate) }}</td>
						@foreach ($user->notNullCostsBudjetProjects() as $project)
							<td>{{ $project->getUnknownSumOutcome($endDate) }}</td>
						@endforeach
					</tr>
					<tr style="font-size: 12; font-weight: bold;">
						<td>На долги (входит в сумму итога)</td>
						<td>{{ $project->getTotalUnknownDebtSumOutcome($endDate) }}</td>
						@foreach ($user->notNullCostsBudjetProjects() as $project)
							<td>{{ $project->getUnknownDebtSumOutcome($endDate) }}</td>
						@endforeach
					</tr>
					<tr style="font-size: 12; font-weight: bold;">
						<td>Итого</td>
						<td>
							{{ $project->getAllProjectsAllCostOutcome($endDate)}}
						</td>
						@foreach ($user->notNullCostsBudjetProjects() as $project)
							<td>
								{{ $project->getAllCostOutcome($endDate) }}
							</td>
						@endforeach
					</tr>
				</tbody>
			</table>
		@endif
	</body>
</html>