@php $reservationId = $AnalysisPackage->END_USER_LAB_ORDER_ID; $identification = $AnalysisPackage->IDENTIFICATION; $labCategoryId = $AnalysisPackage->LAB_CATEGORY_PACKAGE_ID; $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(); foreach ($questionsWithAnswers as $item) { if (!empty($item->OPTION_ID)) { $item->SELECTED_OPTIONS = $item->options()->pluck('NAME_EN'); } } $LabCategoryPackageResults = collect($PackageResultsByPackage[$Package->ID] ?? []); $fetalFraction = null; $sex = 'Unknown'; $gender = 0; 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 ($gender == 1) { $color = "#D3EAFD"; $section_color = hexToRgb($Profile->COLOR,0.2) ?? 'rgba(244, 248, 255, 1)'; $img = url('/img/boy-2.png'); } elseif($gender == 2) { $color = "#FCECF6"; $section_color = hexToRgb($Profile->COLOR,0.2) ?? 'rgba(252, 236, 246, 0.5)'; $img = url('/img/girl-2.png'); } else{ $color = "#E5E2E2"; $section_color = hexToRgb($Profile->COLOR,0.2) ?? 'rgba(128, 128, 128, 0.1)'; $img = url('/img/gender_symbol.png'); } @endphp