@foreach ($all_dates_components as $key => $dateResult) {{-- @foreach($dateResult as $k) --}} {{-- @endforeach --}} @endforeach {{-- @foreach ($qc_monitoring_result_dbs as $dateResult) @endforeach --}} {{-- --}} @foreach ($qc_monitoring_component_db as $testComponent) @php $qc_control_lot_sumx = \App\QualityControlLot::where('levey_jennings_qc_id', $testComponent->levey_jennings_qc_id ) ->where('branch_id', session('branch_id')) ->count('lot_no'); // dd($qc_control_lot_sumx ); $qc_control_result_sumx = \App\QualityControlResult::where('levey_jennings_qc_id', $testComponent->levey_jennings_qc_id ) ->where('branch_id', session('branch_id')) ->where('test_component_id', $testComponent['id']) ->sum('result'); // ->get(); // dd($qc_control_result_sumx); $qc_control_result_countx = \App\QualityControlResult::where('levey_jennings_qc_id', $testComponent->levey_jennings_qc_id ) ->where('branch_id', session('branch_id')) ->where('test_component_id', $testComponent['id']) ->count('result'); // dd($qc_control_result_countx); $qc_control_per_resultx = \App\QualityControlResult::select('result') ->where('levey_jennings_qc_id', $testComponent->levey_jennings_qc_id ) ->where('branch_id', session('branch_id')) ->where('test_component_id', $testComponent['id']) ->get(); $qc_control_per_resultxx = \App\QualityControlResult::where('levey_jennings_qc_id', $testComponent->levey_jennings_qc_id ) ->where('branch_id', session('branch_id')) ->where('test_component_id', $testComponent['id']) ->get(); // dd($qc_control_per_resultx); $qc_control_per_component_customs = \App\QualityControlCustom::where('levey_jennings_qc_id', $testComponent->levey_jennings_qc_id ) ->where('branch_id', session('branch_id')) ->get(); $meanx = 0; if ($qc_control_result_sumx > 0) { $meanx = $qc_control_result_sumx / $qc_control_result_countx; } // dd($meanx); $sd_initialx = 0.0; foreach ($qc_control_per_resultx as $qccpsx) { $sd_initialx += pow(abs($qccpsx->result) - abs($meanx), 2); } // dd($sd_initialx); $sdx = 0; $plus_1sdx = 0; $minus_1sdx = 0; $plus_2sdx = 0; $minus_2sdx = 0; $plus_3sdx = 0; $minus_3sdx = 0; if ($sd_initialx > 0) { $sdx = sqrt($sd_initialx / ($qc_control_result_countx - 1)); $plus_1sdx = $meanx + $sdx; $minus_1sdx = $meanx - $sdx; $plus_2sdx = $meanx + $sdx * 2; $minus_2sdx = $meanx - $sdx * 2; $plus_3sdx = $meanx + $sdx * 3; $minus_3sdx = $meanx - $sdx * 3; } // {{-- // dd($qc_control_result_sumss); --}} @endphp @if(isset($temp[$testComponent->id])) @foreach($temp[$testComponent->id] as $key => $t) @endforeach @else @foreach ($all_dates_components as $key => $dateResult) @endforeach @endif {{-- @php $results_component_count++; @endphp --}} @endforeach

Component	{{ $dateResult }}	{{ $dateResult['result_date'] }}	Average	SD	CV	%Rel. Error	%Accuracy	Component	%Recovery	Abundance	SD Tolerance	Remarks	Action
{{ $testComponent->component_name }}	{{$t}}		@php $results = $testComponent->results->groupBy('result_date'); $average = 0; if ($results->isNotEmpty()) { foreach ($results as $result_date => $items) { $average += $items->avg('result'); } $average /= $results->count(); } // echo number_format($average, 2); @endphp {{ number_format($average, 2)}}	{{ $sdx ? number_format($sdx, 2) : '' }}	@php $results = $testComponent->results->groupBy('result_date'); $average = 0; if ($results->isNotEmpty()) { foreach ($results as $result_date => $items) { $average += $items->avg('result'); } $average /= $results->count(); } // echo round(($average*100)/$testComponent->qc_sd, 2); @endphp @if ($sdx!= null) {{ round(($average*100)/$sdx, 2)}} @endif	@if ($sdx != null) {{ ($average - ($average*100)/$sdx)*100/(($average*100)/$sdx) }} @endif	@if ($sdx != null) {{ 100 - (($average - ($average*100)/$sdx)*100/(($average*100)/$sdx)) }} @endif	{{ $testComponent->component_name }}	@if ($sdx != null) {{ 100 - (($average - ($average*100)/$sdx)*100/(($average*100)/$sdx)) }} @endif	{{ $testComponent->cert_value }}	{{ $testComponent->qc_sd_tol}}	{{ $testComponent->remarks}}