@php $qc_control_lot_sumx = \App\QualityControlLot::where('levey_jennings_qc_id', $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', $qc_id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $qc_monitoring_component_db->id) ->sum('result'); // ->get(); // dd($qc_control_result_sumx); $qc_control_result_countx = \App\QualityControlResult::where('levey_jennings_qc_id', $qc_id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $qc_monitoring_component_db->id) ->count('result'); // ->get() // dd($qc_control_result_countx); $qc_control_per_resultx = \App\QualityControlResult::select('result') ->where('levey_jennings_qc_id', $qc_id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $qc_monitoring_component_db->id) ->get(); $qc_control_per_resultxx = \App\QualityControlResult::where('levey_jennings_qc_id', $qc_id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $qc_monitoring_component_db->id) ->get(); // dd($qc_control_per_resultx); $qc_control_per_component_customs = \App\QualityControlCustom::where('levey_jennings_qc_id', $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 {{-- --}} @foreach ($qc_monitoring_component_db->results as $result) @endforeach {{-- @if ($chart != '') @else @endif --}}

{{ $meanx ? number_format($meanx, 2) : '' }}

{{ $sdx ? number_format($sdx, 2) : '' }}

{{ $plus_1sdx ? number_format($plus_1sdx, 2) : '' }}

{{ $plus_2sdx ? number_format($plus_2sdx, 2) : '' }}

{{ $plus_3sdx ? number_format($plus_3sdx, 2) : '' }}

{{ $minus_1sdx ? number_format($minus_1sdx, 2) : '' }}

{{ $minus_2sdx ? number_format($minus_2sdx, 2) : '' }}

{{ $minus_3sdx ? number_format($minus_3sdx, 2) : '' }}

{{ $qc_monitoring_component_db->component_name }}

Date

Result

Mean

SD

SD + 1

SD + 2

SD + 3

SD - 1

SD - 2

SD - 3

{{ $result->result_date }}

{{ $result->result }}

{{ $meanx ? number_format($meanx, 2) : '' }}

{{ $sdx ? number_format($sdx, 2) : '' }}

{{ $plus_1sdx ? number_format($plus_1sdx, 2) : '' }}

{{ $plus_2sdx ? number_format($plus_2sdx, 2) : '' }}

{{ $plus_3sdx ? number_format($plus_3sdx, 2) : '' }}

{{ $minus_1sdx ? number_format($minus_1sdx, 2) : '' }}

{{ $minus_2sdx ? number_format($minus_2sdx, 2) : '' }}

{{ $minus_3sdx ? number_format($minus_3sdx, 2) : '' }}