@foreach($group_data as $group_key => $group) {{-- Filter indicators for this group --}} @php $groupIndicators = collect($data)->filter(function($item) use ($group_key) { return isset($item['group_key']) && $item['group_key'] === $group_key && !isset($item['is_empty']); }); @endphp @if($groupIndicators->isNotEmpty()) {{-- Group header row --}} {{-- Indicators for this group --}} @foreach($groupIndicators as $indicator) @if(!isset($indicator['is_total']) && !isset($indicator['is_action'])) {{-- Estimations for Q1-Q4 --}} @foreach($indicator['indicator_logs'] ?? [] as $log) @endforeach {{-- Q1 Evaluations --}} @php $q1 = ($indicator['indicator_logs'][0] ?? null); @endphp {{-- Q2 Evaluations + Q1 Recovery --}} @php $q2 = ($indicator['indicator_logs'][1] ?? null); @endphp {{-- Q3 Evaluations + Q2 Recovery --}} @php $q3 = ($indicator['indicator_logs'][2] ?? null); @endphp {{-- Q4 Evaluations + Q3 Recovery --}} @php $q4 = ($indicator['indicator_logs'][3] ?? null); @endphp @endif @endforeach {{-- Total row for this group --}} @foreach($groupIndicators as $indicator) @if(isset($indicator['is_total'])) {{-- Q1 CEO Evaluation --}} {{-- Q2 CEO Evaluation --}} {{-- Q3 CEO Evaluation --}} {{-- Q4 CEO Evaluation --}} @endif @endforeach @endif @endforeach
{{ __('general.evaluation_sheet_header.indicator_description') }} {{ __('general.evaluation_sheet_header.indicator_type') }} {{ __('general.evaluation_sheet_header.weight') }} {{ __('general.evaluation_sheet_header.measurement') }} {{ __('general.evaluation_sheet_header.u_m') }} {{ __('general.evaluation_sheet_header.estimation') }} Q1 {{ __('general.evaluation_sheet_header.estimation') }} Q2 {{ __('general.evaluation_sheet_header.estimation') }} Q3 {{ __('general.evaluation_sheet_header.estimation') }} Q4 {{ __('general.evaluation_sheet_header.self_evaluation') }} Q1 {{ __('general.evaluation_sheet_header.manager_evaluation') }} Q1 {{ __('general.evaluation_sheet_header.ceo_evaluation') }} Q1 {{ __('general.evaluation_sheet_header.self_evaluation') }} Q2 {{ __('general.evaluation_sheet_header.manager_evaluation') }} Q2 {{ __('general.evaluation_sheet_header.recovery') }} Q1 {{ __('general.evaluation_sheet_header.ceo_evaluation') }} Q2 {{ __('general.evaluation_sheet_header.self_evaluation') }} Q3 {{ __('general.evaluation_sheet_header.manager_evaluation') }} Q3 {{ __('general.evaluation_sheet_header.recovery') }} Q2 {{ __('general.evaluation_sheet_header.ceo_evaluation') }} Q3 {{ __('general.evaluation_sheet_header.self_evaluation') }} Q4 {{ __('general.evaluation_sheet_header.manager_evaluation') }} Q4 {{ __('general.evaluation_sheet_header.recovery') }} Q3 {{ __('general.evaluation_sheet_header.ceo_evaluation') }} Q4
{{ $group['name'] ?? '' }}
{{ $indicator['name'] ?? '' }} {{ $indicator['type'] ? __('general.' . $indicator['type']) : '' }} {{ $indicator['percent'] ?? 0 }} {{ $indicator['frequency'] ? __('general.' . $indicator['frequency']) : '' }} {{ $indicator['currency'] ?? '' }}{{ $log['estimation'] ?? '' }}{{ $q1['self_evaluation'] ?? '' }} {{ $q1['manager_evaluation'] ?? '' }} {{ $q1['ceo_percent_evaluation'] ?? '' }}{{ $q2['self_evaluation'] ?? '' }} {{ $q2['manager_evaluation'] ?? '' }} {{ $q1['total_recoveries'] ?? '' }} {{ $q2['ceo_percent_evaluation'] ?? '' }}{{ $q3['self_evaluation'] ?? '' }} {{ $q3['manager_evaluation'] ?? '' }} {{ $q2['total_recoveries'] ?? '' }} {{ $q3['ceo_percent_evaluation'] ?? '' }}{{ $q4['self_evaluation'] ?? '' }} {{ $q4['manager_evaluation'] ?? '' }} {{ $q3['total_recoveries'] ?? '' }} {{ $q4['ceo_percent_evaluation'] ?? '' }}
{{ $indicator['name'] ?? 'Total' }} {{ ($indicator['indicator_logs'][0]['ceo_percent_evaluation'] ?? '') }} {{ ($indicator['indicator_logs'][1]['ceo_percent_evaluation'] ?? '') }} {{ ($indicator['indicator_logs'][2]['ceo_percent_evaluation'] ?? '') }} {{ ($indicator['indicator_logs'][3]['ceo_percent_evaluation'] ?? '') }}