{{-- @foreach ($qc_monitoring_result_dbs as $dateResult) @endforeach --}} @foreach ($qc_monitoring_result_dbs as $dateResult) @if (is_array($dateResult) && array_key_exists('result_date', $dateResult)) @endif @endforeach {{-- @foreach($components as $component) @php dd($component->component_name); @endphp @if(isset($component)) @foreach ($component->results as $result) @endforeach @endif @endforeach --}} @foreach($qc_monitoring_result_dbs as $result) @if(is_object($result) && isset($result->component_id) && $result->component_id == $components->id) @endif @endforeach

Component Name	Certified values	SD Tolerance	{{ $dateResult['result_date'] }}	{{ $dateResult['result_date'] }}	Average	SD	CV	%Rel. Error	%Accuracy	Component Name	%Recovery	Remarks
{{ $component->component_name}}	{{ $component->cert_value }}	{{ $component->qc_sd_tol }}	{{ $result->result }}	@php $results = $component->results->groupBy('result_date'); $average = 0; if ($results->isNotEmpty()) { foreach ($results as $result_date => $items) { $average += $items->avg('result'); } $average /= $results->count(); } @endphp {{ $component->average }}	{{ $component->qc_sd }}	{{ $component->cv_average }}	{{ $component->rel_error }}	{{ $component->accuracy }}	{{ $component->component_name }}	{{ $component->recovery }}	{{ $component->remarks }}
{{ $components->component_name }}	{{ $components->certified_values }}	{{ $components->sd_tolerance }}	{{ $result->result }}	{{ $result->average }}	{{ $result->standard_deviation }}	{{ $result->coefficient_variation }}	{{ $result->relative_error_percentage }}	{{ $result->accuracy_percentage }}	{{ $result->component_name }}	{{ $result->recovery_percentage }}	{{ $result->remarks }}