@php $reservationId = $AnalysisPackage->END_USER_LAB_ORDER_ID; $identification = $AnalysisPackage->IDENTIFICATION; $labCategoryId = $AnalysisPackage->LAB_CATEGORY_PACKAGE_ID; $FetalFraction = null; $LabCategoryPackageHospital = new App\Models\LABCATEGORYPACKAGEHOSPITAL(); $LabCategoryPackageHospital = $LabCategoryPackageHospital ->where('LAB_CATEGORY_PACKAGE_ID', '=', $labCategoryId) ->where('HOSPITAL_ID', '=', $Package->eNDUSERLABORDER->HOSPITAL_ID) ->with('PROFILEREFERENCERANGE') ->first(); $LabCategoryPackageResults = App\Models\ENDUSERLABORDERPACKAGERESULT::where('END_USER_PACKAGE_ID', $Package->ID) ->with('Option', 'Result') ->get(); $questionsWithAnswers = App\Models\ENDUSERPACKAGEQUESTIONNAIREANSWERS::where('END_USER_LAB_ORDER_ID', $reservationId) ->where('IDENTIFICATION', $identification) ->where('LAB_CATEGORY_PACKAGE_ID', $labCategoryId) ->with(['question']) ->whereDoesntHave('question', function ($query) { $query->where('HIDE_FROM_REPORT', 1); }) ->get(); $ST = null; $T21 = null; $T18 = null; $T13 = null; $Tsc = null; $OAC = null; $FetalFraction = null; $gender = null; $IN = null; $No = null; $GA = null; $MD = null; $RE = null; foreach ($questionsWithAnswers as $item) { if (!empty($item->OPTION_ID)) { $item->SELECTED_OPTIONS = $item->options()->pluck('NAME_EN'); } } foreach ($LabCategoryPackageResults as $key => $LabCategoryPackageResult) { if ($LabCategoryPackageResult->Result->CODE == 'ST' && !empty($LabCategoryPackageResult->RESULT)) { $ST['NAME_EN'] = $LabCategoryPackageResult->RESULT; } if ($LabCategoryPackageResult->Result->CODE == 'Trisomy21' && $LabCategoryPackageResult->OPTION_ID) { $T21['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $T21['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if ($LabCategoryPackageResult->Result->CODE == 'Trisomy18' && $LabCategoryPackageResult->OPTION_ID) { $T18['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $T18['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if ($LabCategoryPackageResult->Result->CODE == 'Trisomy13' && $LabCategoryPackageResult->OPTION_ID) { $T13['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $T13['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if ($LabCategoryPackageResult->Result->CODE == 'SCAs' && $LabCategoryPackageResult->OPTION_ID) { $Tsc['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $Tsc['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if ($LabCategoryPackageResult->Result->CODE == 'MICRODU' && $LabCategoryPackageResult->OPTION_ID) { $MD['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $MD['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if ($LabCategoryPackageResult->Result->CODE == 'FetalFraction' && !empty($LabCategoryPackageResult->RESULT)) { $FetalFraction['NAME_EN'] = $LabCategoryPackageResult->RESULT; } if ($LabCategoryPackageResult->Result->CODE == 'FetalSex' && $LabCategoryPackageResult->OPTION_ID) { $FetalS['NAME_EN'] = $LabCategoryPackageResult->Option->CODE; if ($FetalS['NAME_EN'] == 'female') $gender = 'Female'; elseif ($FetalS['NAME_EN'] == 'male') $gender = 'Male'; else $gender = 'Unknown'; } if ($LabCategoryPackageResult->Result->CODE == 'In' && !empty($LabCategoryPackageResult->RESULT)) { $IN['NAME_EN'] = $LabCategoryPackageResult->RESULT; } if ($LabCategoryPackageResult->Result->CODE == 'GA' && !empty($LabCategoryPackageResult->RESULT)) { $GA['NAME_EN'] = $LabCategoryPackageResult->RESULT; } if ($LabCategoryPackageResult->Result->CODE == 'NOFETUS' && !empty($LabCategoryPackageResult->RESULT)) { $No['NAME_EN'] = $LabCategoryPackageResult->RESULT; } if ($LabCategoryPackageResult->Result->CODE == 'OAC' && !empty($LabCategoryPackageResult->RESULT)) { $OAC['NAME_EN'] = $LabCategoryPackageResult->RESULT; } if ($LabCategoryPackageResult->Result->CODE == 'Result' && $LabCategoryPackageResult->OPTION_ID) { $RE['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $RE['CODE'] = $LabCategoryPackageResult->Option->CODE; $RE['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; if ($RE['CODE'] == 'NotDetected') $gender = 'Female'; elseif ($RE['CODE'] == 'Detected') $gender = 'Male'; else $gender = 'Unknown'; } } @endphp
{{ $ST['NAME_EN'] }}
Trisomy 21 (Down’s Syndrome)
@endif @if(!empty($T18['NAME_EN']))Trisomy 18 (Edward’s Syndrome)
@endif @if(!empty($T13['NAME_EN']))Trisomy 13 (Patau’s Syndrome)
@endif @if(!empty($Tsc['NAME_EN']))Sex Chromosomal Aneuploidies (SCAs)
@endif @if($Package->lABCATEGORYPACKAGE->CODE == 'NIPT-PRO') @if(!empty($MD['NAME_EN']))Microdeletion syndromes
@endif @endif @if($Package->lABCATEGORYPACKAGE->CODE == 'NIPT-PRO') @if(!empty($OAC['NAME_EN']))Other Autosomal Chromosomes
@endif @endif{{$T21['NAME_EN']}}
@endif @if(!empty($T18['NAME_EN'])){{$T18['NAME_EN']}}
@endif @if(!empty($T13['NAME_EN'])){{$T13['NAME_EN']}}
@endif @if(!empty($Tsc['NAME_EN'])){{$Tsc['NAME_EN']}}
@endif @if(!empty($MD['NAME_EN'])){{$MD['NAME_EN']}}
@endif @if(!empty($OAC['NAME_EN'])){{$OAC['NAME_EN']}}
@endif{{ $LabCategoryPackageHospital->PROFILEREFERENCERANGE->SECOND_TEXT }}
| Detection | T21 | T18 | T13 | SCAs |
|---|---|---|---|---|
| Sensitivity | 100.00% | 100.00% | 100.00% | 97.93% |
| Specificity | 99.94% | 99.98% | 99.95% | 99.73% |
{{ $LabCategoryPackageHospital->PROFILEREFERENCERANGE->THIRD_TEXT }}
{{ $LabCategoryPackageHospital->PROFILEREFERENCERANGE->FOURTH_TEXT }}
| CNVID | Syndrome | CNV Size (Mb) |
| CNV01 | 7q deletion | 105.14 |
| CNV02 | 18q microdeletion syndrome | 60.88 |
| CNV03 | 9p microdeletion syndrome | 47.30 |
| CNV04 | 14q11-q22 deletion syndrome | 40.50 |
| CNV05 | Pallister-Killian syndrome (PKS) | 35.80 |
| CNV06 | 16p deletion syndrome | 34.60 |
| CNV07 | 1p32-p31 microdeletion syndrome | 34.20 |
| CNV08 | 6q11-q14 microdeletion syndrome | 31.00 |
| CNV09 | Homozygous 11p15-p14 deletion | 31.00 |
| CNV10 | 8q12.1-q21.2 deletion syndrome | 25.30 |
| CNV11 | Xq21 deletion syndrome | 22.30 |
| CNV12 | 1q41-q42 microdeletion syndrome | 22.10 |
| CNV13 | 6q24-q25 microdeletion syndrome | 22.00 |
| CNV14 | 2q34-q36 duplication syndrome | 22.00 |
| CNV15 | Jacobsen syndrome | 20.51 |
| CNV16 | Dandy-Walker syndrome | 19.70 |
| CNV17 | 14q32 microduplication syndrome | 17.55 |
| CNV18 | 18p microdeletion syndrome | 17.20 |
| CNV19 | 10q26 microdeletion syndrome | 16.43 |
| CNV20 | 2p12-p11.2 microdeletion syndrome | 15.50 |
| CNV21 | 5q14.3 microdeletion syndrome | 15.40 |
| CNV22 | 13q14 microdeletion syndrome | 15.20 |
| CNV23 | 10q22.3-q23.2 microdeletion syndrome | 15.00 |
| CNV24 | 5p13 microduplication syndrome | 13.60 |
| CNV25 | 15q26-qter deletion syndrome | 13.42 |
| CNV26 | 15q26-qter Levy-Shanske syndrome | 13.42 |
| CNV27 | 6pter-p24 microdeletion syndrome | 13.40 |
| CNV28 | Split-hand or foot | 13.30 |
| CNV29 | Xq27.3-q28 duplication syndrome | 13.17 |
| CNV30 | 1p36 microdeletion syndrome | 12.84 |
| CNVID | Syndrome | CNV Size (Mb) |
| CNV31 | Xp21 deletion syndrome | 12.70 |
| CNV32 | Cri-du-chat syndrome | 12.53 |
| CNV33 | WAGRO syndrome | 12.50 |
| CNV34 | Holoprosencephaly 6 | 12.20 |
| CNV35 | 4q21 microdeletion syndrome | 11.70 |
| CNV36 | 17p12-p11.2 Yuan-Harel-Lupski syndrome | 11.50 |
| CNV37 | 11q23 deletion syndrome | 10.80 |
| CNV38 | 15q25 deletion syndorme | 10.80 |
| CNV39 | DiGeorge syndrome 2 | 10.70 |
| CNV40 | Langer-Giedion syndrome | 9.60 |
| CNV41 | 2p16.1-p15 deletion syndrome | 9.10 |
| CNV42 | Terminal 6q Microdeletion | 9.00 |
| CNV43 | 4q32.1-q32.2 triplication syndrome | 8.90 |
| CNV44 | 16p12.2-p11.2 microdeletion syndrome | 8.69 |
| CNV45 | Xp11.23-p11.22 duplication syndrome | 8.40 |
| CNV46 | 2q31.1 duplication syndrome | 8.30 |
| CNV47 | 2q33.1 microdeletion syndrome | 8.28 |
| CNV48 | Xq28 deletion syndrome | 8.17 |
| CNV49 | 16p13.3 deletion syndrome | 7.90 |
| CNV50 | 16p13.3 duplication syndrome | 7.90 |
| CNV51 | 16p11.2-p12.2 microduplication syndrome | 7.81 |
| CNV52 | 5q12 microdeletion syndrome | 7.80 |
| CNV53 | 3pter-p25 deletion Syndrome | 7.70 |
| CNV54 | 1p31 microduplication syndrome | 7.60 |
| CNV55 | 16q22 deletion syndrome | 7.40 |
| CNV56 | Frias syndrome | 7.20 |
| CNV57 | 19p13.13 microdeletion syndrome | 6.90 |
| CNV58 | CHDM (chordoma) | 6.62 |
| CNV59 | 17q12 deletion syndrome | 6.30 |
| CNV60 | 17q12 duplication syndrome | 6.30 |