@php $reservationId = $AnalysisPackage->END_USER_LAB_ORDER_ID; $identification = $AnalysisPackage->IDENTIFICATION; $labCategoryId = $AnalysisPackage->LAB_CATEGORY_PACKAGE_ID; // Expand IDs to check for test-specific questionnaires $idsToCheck = [$labCategoryId]; $package = \App\Models\LABCATEGORYPACKAGE::find($labCategoryId); if ($package && $package->IS_PACKAGE) { $itemIds = \App\Models\LABPACKAGEITEM::where('PACKAGE_ID', $labCategoryId)->pluck('LAB_CATEGORY_PACKAGE_ID')->toArray(); $idsToCheck = array_merge($idsToCheck, $itemIds); } $questionsWithAnswers = App\Models\ENDUSERPACKAGEQUESTIONNAIREANSWERS::where('END_USER_LAB_ORDER_ID', $reservationId) ->where('IDENTIFICATION', $identification) ->whereIn('LAB_CATEGORY_PACKAGE_ID', $idsToCheck) ->with(['question.options']) ->whereDoesntHave('question', function ($query) { $query->whereIn('TYPE', ['FILE', 'DOWNLOAD_FILE']) ->orWhere('HIDE_FROM_REPORT', 1); }) ->get(); foreach ($questionsWithAnswers as $item) { $item->SELECTED_OPTIONS = $item->selectedOptionsNames; } $LabCategoryPackageResults = App\Models\ENDUSERLABORDERPACKAGERESULT::where('END_USER_PACKAGE_ID',$Package->ID)->with('Option','Result')->get(); $chromosomes = []; $fetalFraction = null; $fetalRecommendation = null; $mdmi = null; $inf = null; $sex = null; $gender = 0; $resultDate = []; $sex_chromosomes = []; $syndrome = []; $resultDate = [ 'result' => 'No Result', 'isNormal' => null, 'code' => null, 'color' => '#767676FF' ]; foreach ($LabCategoryPackageResults as $key => $LabCategoryPackageResult) { if($LabCategoryPackageResult->Result->CODE == 'FF' && !empty($LabCategoryPackageResult->RESULT)) { $fetalFraction = $LabCategoryPackageResult->RESULT.'%'; } if($LabCategoryPackageResult->Result->CODE == 'SC' && $LabCategoryPackageResult->OPTION_ID) { $sex = $LabCategoryPackageResult->Option->NAME_EN; if ($sex == "Male, XY") $gender = 1; if ($sex == "Female, XX") $gender = 2; } if($LabCategoryPackageResult->Result->CODE == 'Result' && !empty($LabCategoryPackageResult->OPTION_ID)) { $resultDate['result'] = $LabCategoryPackageResult->Option->NAME_EN; $resultDate['isNormal'] = $LabCategoryPackageResult->Option->IS_NORMAL; $resultDate['code'] = $LabCategoryPackageResult->Option->CODE; $resultDate['isNormal'] == 1 ? $resultDate['color'] = '#29B637' : $resultDate['color'] = '#E9473A'; if (in_array($resultDate['code'],['Notested','Inconclusive'])) $resultDate['color'] = '#767676FF'; } if(in_array($LabCategoryPackageResult->Result->CODE, ['45X', '47XXX', '47XXY', '47XYY']) && !empty($LabCategoryPackageResult->OPTION_ID)) { $code = $LabCategoryPackageResult->Result->CODE; $sex_chromosomes[$code]['code'] = $LabCategoryPackageResult->Option->CODE; $sex_chromosomes[$code]['name'] = $LabCategoryPackageResult->Option->NAME_EN; } if($LabCategoryPackageResult->Result->CODE == 'T21' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['T21'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'T18' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['T18'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'T13' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['T13'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'bg13' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['bg13'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'bg18' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['bg18'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'bg21' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['bg21'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rc13' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['rc13'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rc18' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['rc18'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rc21' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['rc21'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'zs13' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['zs13'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'zs18' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['zs18'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'zs21' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['zs21'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'REPSUMREC' && !empty($LabCategoryPackageResult->RESULT)) { $fetalRecommendation = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'Microdeletionmicroduplication' && !empty($LabCategoryPackageResult->OPTION_ID)) { $mdmi['name'] = $LabCategoryPackageResult->Option->NAME_EN; $mdmi['code'] = $LabCategoryPackageResult->Option->CODE; $mdmi['isNormal'] = $LabCategoryPackageResult->Option->IS_NORMAL; $mdmi['isNormal'] == 1 ? $mdmi['color'] = '#29B637' : $mdmi['color'] = '#E9473A'; if (in_array($mdmi['code'],['Notested','Inconclusive'])) $mdmi['color'] = '#767676FF'; } if($LabCategoryPackageResult->Result->CODE == 'Incidentalfinding' && !empty($LabCategoryPackageResult->OPTION_ID)) { $inf['name'] = $LabCategoryPackageResult->Option->NAME_EN; $inf['code'] = $LabCategoryPackageResult->Option->CODE; $inf['isNormal'] = $LabCategoryPackageResult->Option->IS_NORMAL; $inf['isNormal'] == 1 ? $inf['color'] = '#29B637' : $inf['color'] = '#E9473A'; if (in_array($inf['code'],['Notested','Inconclusive'])) $inf['color'] = '#767676FF'; } if($LabCategoryPackageResult->Result->CODE == 'PKS' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['PKS'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'PKS' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['PKS'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'JS' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['JS'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'DWS' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['DWS'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'q26' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['q26'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'p36' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['p36'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'CDC' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['CDC'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'WAGRO' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['WAGRO'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'q21' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['q21'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'DGS2' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['DGS2'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'LGS' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['LGS'] = $LabCategoryPackageResult->Option->CODE; } if($LabCategoryPackageResult->Result->CODE == 'LGS' && !empty($LabCategoryPackageResult->OPTION_ID)) { $syndrome['LGS'] = $LabCategoryPackageResult->Option->CODE; } if(str_contains($LabCategoryPackageResult->Result->CODE,'Chromosome')) { for ($i = 1; $i <= 22; $i++) { $code = 'Chromosome'.$i; if($LabCategoryPackageResult->Result->CODE == $code && !empty($LabCategoryPackageResult->OPTION_ID)) { $chromosomes[$code] = $LabCategoryPackageResult->Option->CODE; } } } } $chromosomesRec = []; $sexChromosomesRec = []; $trisomyRec = []; foreach ($LabCategoryPackageResults as $key => $LabCategoryPackageResult) { if(str_contains($LabCategoryPackageResult->Result->CODE,'rcc')) { for ($i = 1; $i <= 22; $i++) { $code = 'rcc'.$i; if($LabCategoryPackageResult->Result->CODE == $code && !empty($LabCategoryPackageResult->RESULT)) { $chromosomesRec['Chromosome'.$i] = $LabCategoryPackageResult->RESULT; } } } // Sex chromosome recommendations if($LabCategoryPackageResult->Result->CODE == 'rc47XYY' && !empty($LabCategoryPackageResult->RESULT)) { $sexChromosomesRec['47XYY'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rc47XXY' && !empty($LabCategoryPackageResult->RESULT)) { $sexChromosomesRec['47XXY'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rc45X' && !empty($LabCategoryPackageResult->RESULT)) { $sexChromosomesRec['45X'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rc47XXX' && !empty($LabCategoryPackageResult->RESULT)) { $sexChromosomesRec['47XXX'] = $LabCategoryPackageResult->RESULT; } // Trisomy recommendations if($LabCategoryPackageResult->Result->CODE == 'rcT21' && !empty($LabCategoryPackageResult->RESULT)) { $trisomyRec['T21'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rcT18' && !empty($LabCategoryPackageResult->RESULT)) { $trisomyRec['T18'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'rcT13' && !empty($LabCategoryPackageResult->RESULT)) { $trisomyRec['T13'] = $LabCategoryPackageResult->RESULT; } if($LabCategoryPackageResult->Result->CODE == 'ACSCOM' && !empty($LabCategoryPackageResult->RESULT)) { $syndrome['ACSCOM'] = $LabCategoryPackageResult->RESULT; } } // Check if all recommendations in each table are empty $hasTrisomyRecommendations = !empty($trisomyRec['T21']) || !empty($trisomyRec['T18']) || !empty($trisomyRec['T13']); $hasSexChromosomeRecommendations = !empty($sexChromosomesRec['45X']) || !empty($sexChromosomesRec['47XXX']) || !empty($sexChromosomesRec['47XXY']) || !empty($sexChromosomesRec['47XYY']); $hasChromosomeRecommendations = false; foreach ($chromosomesRec as $rec) { if (!empty($rec)) { $hasChromosomeRecommendations = true; break; } } if ($gender == 1) { $color = "#D3EAFD"; $section_color = hexToRgb($Profile->REPORT_TITLE_COLOR,0.2) ?? 'rgba(244, 248, 255, 1)'; $img = url('/images/boy.png'); } elseif($gender == 2) { $color = "#FCECF6"; $section_color = hexToRgb($Profile->REPORT_TITLE_COLOR,0.2) ?? 'rgba(252, 236, 246, 0.5)'; $img = url('/images/girl.png'); } else{ $color = "#E5E2E2"; $section_color = hexToRgb($Profile->REPORT_TITLE_COLOR,0.2) ?? 'rgba(128, 128, 128, 0.1)'; $img = url('/img/gender_symbol.png'); } $bgExist = false; if(!empty($syndrome['bg13']) || !empty($syndrome['bg18']) || !empty($syndrome['bg21'])) $bgExist = true; @endphp @if($questionsWithAnswers->count() > 0)
| Result | {{$resultDate['result']}} | @if(!in_array($resultDate['code'],['Notested','Inconclusive'])) @if($resultDate['isNormal'] != 1) @else @endif @else @endif |
| Fetal Sex | @if($gender == 1) Male @elseif($gender == 2) Female @else {{$sex}} @endif |
@if($gender == 1)
|
| Fetal Fraction | {{$fetalFraction}} |
|
| Recommendation | {{$fetalRecommendation}} | |
| Microdeletion/ Microduplication | {{$mdmi['name'] ?? 'Low Risk'}} | @if(!empty($mdmi)) @else @endif |
| Incidental Finding | {{$inf['name'] ?? 'Low Risk'}} | @if(!empty($inf)) @else @endif |
| Syndrome | Background Risk | NIPTune RISK SCORE | Clinical Interpretation | Recommendation | @elseSyndrome | Background Risk | NIPTune RISK SCORE | Clinical Interpretation | @endif @else @if($hasTrisomyRecommendations)Syndrome | Clinical Interpretation | Recommendation | @elseSyndrome | Clinical Interpretation | @endif @endif
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Trisomy 21 | @if(!empty($syndrome['bg21'])) {{$syndrome['bg21']}} @endif | less than 1:100000 (< 0.01%) |
@if($syndrome['T21'] == 'low') Low Risk @elseif($syndrome['T21'] == 'high') High Risk @else {{$syndrome['T21']}} @endif | @php $recT21 = $trisomyRec['T21'] ?? null; @endphp {{ $recT21 }} | @elseTrisomy 21 | @if(!empty($syndrome['bg21'])) {{$syndrome['bg21']}} @endif | less than 1:100000 (< 0.01%) |
@if($syndrome['T21'] == 'low') Low Risk @elseif($syndrome['T21'] == 'high') High Risk @else {{$syndrome['T21']}} @endif | @endif @else @if($hasTrisomyRecommendations)Trisomy 21 | @if($syndrome['T21'] == 'low') Low Risk @elseif($syndrome['T21'] == 'high') High Risk @else {{$syndrome['T21']}} @endif | @php $recT21 = $trisomyRec['T21'] ?? null; @endphp {{ $recT21 }} | @elseTrisomy 21 | @if($syndrome['T21'] == 'low') Low Risk @elseif($syndrome['T21'] == 'high') High Risk @else {{$syndrome['T21']}} @endif | @endif @endif
| Trisomy 18 | @if(!empty($syndrome['bg18'])) {{$syndrome['bg18']}} @endif | less than 1:100000 (< 0.01%) |
@if($syndrome['T18'] == 'low') Low Risk @elseif($syndrome['T18'] == 'high') High Risk @else {{$syndrome['T18']}} @endif | @php $recT18 = $trisomyRec['T18'] ?? null; @endphp {{ $recT18 }} | @elseTrisomy 18 | @if(!empty($syndrome['bg18'])) {{$syndrome['bg18']}} @endif | less than 1:100000 (< 0.01%) |
@if($syndrome['T18'] == 'low') Low Risk @elseif($syndrome['T18'] == 'high') High Risk @else {{$syndrome['T18']}} @endif | @endif @else @if($hasTrisomyRecommendations)Trisomy 18 | @if($syndrome['T18'] == 'low') Low Risk @elseif($syndrome['T18'] == 'high') High Risk @else {{$syndrome['T18']}} @endif | @php $recT18 = $trisomyRec['T18'] ?? null; @endphp {{ $recT18 }} | @elseTrisomy 18 | @if($syndrome['T18'] == 'low') Low Risk @elseif($syndrome['T18'] == 'high') High Risk @else {{$syndrome['T18']}} @endif | @endif @endif
| Trisomy 13 | @if(!empty($syndrome['bg13'])) {{$syndrome['bg13']}} @endif | less than 1:100000 (< 0.01%) |
@if($syndrome['T13'] == 'low') Low Risk @elseif($syndrome['T13'] == 'high') High Risk @else {{$syndrome['T13']}} @endif | @php $recT13 = $trisomyRec['T13'] ?? null; @endphp {{ $recT13 }} | @elseTrisomy 13 | @if(!empty($syndrome['bg13'])) {{$syndrome['bg13']}} @endif | less than 1:100000 (< 0.01%) |
@if($syndrome['T13'] == 'low') Low Risk @elseif($syndrome['T13'] == 'high') High Risk @else {{$syndrome['T13']}} @endif | @endif @else @if($hasTrisomyRecommendations)Trisomy 13 | @if($syndrome['T13'] == 'low') Low Risk @elseif($syndrome['T13'] == 'high') High Risk @else {{$syndrome['T13']}} @endif | @php $recT13 = $trisomyRec['T13'] ?? null; @endphp {{ $recT13 }} | @elseTrisomy 13 | @if($syndrome['T13'] == 'low') Low Risk @elseif($syndrome['T13'] == 'high') High Risk @else {{$syndrome['T13']}} @endif | @endif @endif
Note:
Detected -high risk of Aneuploidy identified
Not Detected- Low risk of Aneuploidy identified
Note: {!! nl2br(e($syndrome['ACSCOM'])) !!}