@php $test_results=\App\Models\InvoiceTestResult::whereHas('invoice_test',function($query)use($test){ $query->where('id',$test['id']) ->orWhereHas('parent',function($query)use($test){ $query->where('id',$test['id']); }); }) ->whereHas('component',function($query){ $query->where('history',true); }) ->where(function($query){ $query->where('result','!=',null) ->orWhere('result_to','!=',null) ->orWhere('note','!=',null); }) ->get(); $selected_tests=[]; foreach($test_results as $result) { $selected_tests[]=$result['test_id']; } $last_results_count=0; if(count($selected_tests)) { $components=$test['test']['components']->where('history',true) ->whereIn('id',$selected_tests); $count_components=count($components); $last_results=$test->last_results($selected_tests)->get(); $last_results_count=count($last_results); } @endphp @if($last_results_count) @foreach($components as $component) @endforeach @foreach($last_results as $last_result) @foreach($components as $component) @php $test_result=\App\Models\InvoiceTestResult::whereHas('invoice_test',function($query)use($last_result,$component){ $query->where('id',$last_result['id']) ->orWhereHas('parent',function($query)use($last_result,$component){ $query->where('id',$last_result['id']); }); }) ->where('test_id',$component['id']) ->first(); @endphp @endforeach @endforeach
▪ Patient History :
Date {{$component['result_history_name']}}
{{date('d-M-Y',strtotime($last_result['invoice']['created_at']))}} @if(isset($test_result)) {{$test_result['result']}} @endif
@endif