@extends('layouts.app') @section('title') {{ __('Show Quality Control') }} @endsection @section('breadcrumb')

{{ __('Quality Control') }}

@endsection @section('content')
{{--

{{ __('Edit Quality Control') }}

--}}
@if (isset($qc_monitoring))
{{ __('Quality Control Chart') }}
Control Details
@csrf @method('PUT') {{-- @endif --}} @if ($qc_control_lot_sum < 1) @endif
* {{ __('Lot number') }} {{ __('Date First Used') }} {{ __('Expiry Date') }} {{ __('Level') }}
@if (isset($qc_monitoring_lot_db)) {{-- @php dd($qc_monitoring_lot_db); @endphp --}} @foreach ($qc_monitoring_lot_db as $qc_monitoring_lot_db) {{-- --}} @endforeach
{{ $qc_monitoring_lot_db->lot_no }} {{ $qc_monitoring_lot_db->first_date_used }} {{ $qc_monitoring_lot_db->expiry_date }} {{ $qc_monitoring_lot_db->level }}
@else {{-- @php dd($qc_monitoring_lot_db); @endphp --}} @foreach ($qc_monitoring_lot_db as $qc_monitoring_lot_db) @endforeach
{{ $qc_monitoring_lot_db->lot_no }} {{ $qc_monitoring_lot_db->first_date_used }} {{ $qc_monitoring_lot_db->expiry_date }} {{ $qc_monitoring_lot_db->level }}
@endif

GCMS Parameters

@if(isset($qc_monitoring->gcms) && count($qc_monitoring->gcms) > 0) @else @endif
{{--
--}} {{-- --}} @foreach ($qc_monitoring->gcms as $gcms)

{{$gcms->date}}

{{-- @csrf --}} {{-- @php $gcms_count = 0; @endphp --}} {{-- --}} @foreach($gcms->gcms_items as $key => $gcms_items) @if($key == 0) @endif {{-- --}} @endforeach
{{ __('Date') }} {{ __('') }} {{ __('Acceptance Criteria') }} {{ __('Generated Value') }}
{{-- {{$gcms_items->acceptance_value}} --}}
{{-- {{$gcms_items->generated_value}} --}}
{{-- --}} {{-- --}}
@endforeach
{{-- @can('create_patient') @endcan --}}
@if ($qc_monitoring['components']) @php $results_component_count = 0; @endphp

Data Entry Component

@csrf {{-- @method('PUT') --}}
@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', $qc_monitoring->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_monitoring->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', $qc_monitoring->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', $qc_monitoring->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', $qc_monitoring->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', $qc_monitoring->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 {{-- @php dd($testComponent->results); @endphp --}} {{-- @foreach ($testComponent->results as $dateResult) @endforeach --}} {{-- @php $hhh = []; @endphp --}} {{-- @if($temp ) --}} {{-- {{$testComponent->levey_jennings_id}} --}} @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%Rel. Error %Accuracy Component %Recovery Certified Values SD Tolerance RemarksAction
{{ $testComponent->component_name }}{{ $dateResult ? $dateResult['result'] : "-" }}{{$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 @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 {{ $testComponent->component_name }}
{{-- --}} {{-- {{ __('Export') }} --}}
@endif
{{--
@csrf
{{ __('Download template') }}
@csrf @if (!$qc_monitoring['components']) @foreach ($qc_monitoring['components'] as $component) @endforeach @else @endif
{{ __('Import') }}
--}} @if ($qc_monitoring['components'])
@foreach ($qc_monitoring['components'] as $component) @php $qc_control_lot_sumx = \App\QualityControlLot::where('levey_jennings_qc_id', $qc_monitoring->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_monitoring->id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $component['id']) ->sum('result'); // ->get(); // dd($qc_control_result_sumx); $qc_control_result_countx = \App\QualityControlResult::where('levey_jennings_qc_id', $qc_monitoring->id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $component['id']) ->count('result'); // ->get() // dd($qc_control_result_countx); $qc_control_per_resultx = \App\QualityControlResult::select('result') ->where('levey_jennings_qc_id', $qc_monitoring->id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $component['id']) ->get(); $qc_control_per_resultxx = \App\QualityControlResult::where('levey_jennings_qc_id', $qc_monitoring->id) ->where('branch_id', session('branch_id')) ->where('test_component_id', $component['id']) ->get(); // dd($qc_control_per_resultx); $qc_control_per_component_customs = \App\QualityControlCustom::where('levey_jennings_qc_id', $qc_monitoring->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

Control Limits

@if (isset($qc_monitoring_result_db))
id) value="{{ $meanx ? number_format($meanx, 2) : '' }}" @endif readonly>
id) value="{{ $sdx ? number_format($sdx, 2) : '' }}" @endif readonly>
{{--
--}}
id) value="{{ $plus_1sdx ? number_format($plus_1sdx, 2) : '' }}" @endif readonly>
id) value="{{ $plus_2sdx ? number_format($plus_2sdx, 2) : '' }}" @endif readonly>
id) value="{{ $plus_3sdx ? number_format($plus_3sdx, 2) : '' }}" @endif readonly>
id) value="{{ $minus_1sdx ? number_format($minus_1sdx, 2) : '' }}" @endif readonly>
id) value="{{ $minus_2sdx ? number_format($minus_2sdx, 2) : '' }}" @endif readonly>
id) value="{{ $minus_3sdx ? number_format($minus_3sdx, 2) : '' }}" @endif readonly>
@endif
@php $customs_count = 0; @endphp
{{-- --}}
@csrf @method('PUT') {{-- @php dd($qc_monitoring->components); @endphp --}} @if (isset($qc_monitoring->data_customs)) {{-- @foreach ($qc_control_per_component_customs as $custom) --}} @foreach ($component->customs as $custom) {{-- @php dd($custom->id); @endphp --}} {{-- @php dd($component->customs); @endphp --}} @php $customs_count++; @endphp @endforeach @endif
{{ __('Custom Limits') }} {{ __('Custom Labels') }}
{{--
--}}
@php $results_count = 0; @endphp

Data Entry

{{-- --}}
@csrf @method('PUT') {{-- @php dd($qc_monitoring->id); @endphp --}} id) value="{{ $sdx ? number_format($sdx, 2) : '' }}" @endif id="qc_sd_formxs"> @if (isset($qc_monitoring->data_results)) @foreach ($component->results as $result) {{-- @foreach ($qc_control_per_resultxx as $keya => $result) --}} @php $results_count++; @endphp @endforeach @endif
{{ __('Date') }} {{ __('Result') }} {{ __('Analyst') }}
{{--
--}}

Data Result Chart

@if (isset($qc_monitoring_result_db)) @can('can_view_quality_control_result')
@endcan @endif
@endforeach
@endif
@endif
{{-- --}}
@include('admin.levey_jenning_qc_monitoring.modals.patient_modal') @endsection @section('scripts') {{-- --}} @endsection