@php $LabCategoryPackageResults = App\Models\ENDUSERLABORDERPACKAGERESULT::where('END_USER_PACKAGE_ID',$Package->ID)->with('Option','Result.NormalOption')->get(); $CrystalTypes = []; $CastTypes = []; $AmorphousMaterials = []; $Others = []; foreach($LabCategoryPackageResults as $LabCategoryPackageResult){ if($LabCategoryPackageResult->Result->CODE == 'COLOR' && $LabCategoryPackageResult->OPTION_ID) { $Color['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $Color['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $Color['HEX_CODE'] = $LabCategoryPackageResult->Option->HEX_CODE; $Color['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $Color['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'CLARITY' && $LabCategoryPackageResult->OPTION_ID) { $Clarity['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $Clarity['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $Clarity['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $Clarity['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'SG'){ if(!empty($LabCategoryPackageResult->Option)){ $SG['NORMAL'] = "1.005 - 1.030"; $SG['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $SG['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $SG['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } else if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){ $SG['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $SG['DESC_AR'] = $LabCategoryPackageResult->Result->DESC_AR; $SG['DESC_EN'] = $LabCategoryPackageResult->Result->DESC_EN; $SG['NAME_EN'] = $LabCategoryPackageResult->RESULT; $SG['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $SG['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $SG['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $SG['NORMAL'] = "1.005 - 1.030"; if($LabCategoryPackageResult->RESULT >= 1.005 && $LabCategoryPackageResult->RESULT<=1.030) $SG['IS_NORMAL'] = 1; } } if($LabCategoryPackageResult->Result->CODE == 'PH'){ if(!empty($LabCategoryPackageResult->Option)){ $PH['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $PH['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $PH['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $PH['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; $PH['MAX_NORMAL'] = $LabCategoryPackageResult->MAX_NORMAL; $PH['MIN_NORMAL'] = $LabCategoryPackageResult->MIN_NORMAL; } else if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){ $PH['DESC_AR'] = $LabCategoryPackageResult->Result->DESC_AR; $PH['NAME_EN'] = $LabCategoryPackageResult->RESULT; $PH['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $PH['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $PH['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $PH['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $PH['IS_NORMAL'] = 1; } } if($LabCategoryPackageResult->Result->CODE == 'UR'){ if(!empty($LabCategoryPackageResult->Option)){ $UR['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $UR['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $UR['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $UR['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } elseif(!empty($LabCategoryPackageResult->RESULT)){ $UR['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $UR['RESULT'] = $LabCategoryPackageResult->RESULT; $UR['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $UR['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $UR['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; } } if($LabCategoryPackageResult->Result->CODE == 'PC'){ if(!empty($LabCategoryPackageResult->RESULT)){ $PC['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $PC['RESULT'] = $LabCategoryPackageResult->RESULT; $PC['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $PC['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $PC['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; }elseif(!empty($LabCategoryPackageResult->Option)){ $PC['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $PC['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $PC['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $PC['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $PC['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } } if($LabCategoryPackageResult->Result->CODE == 'URBC'){ if(!empty($LabCategoryPackageResult->RESULT)){ $RBC['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $RBC['RESULT'] = $LabCategoryPackageResult->RESULT; $RBC['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $RBC['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $RBC['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $RBC['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption?$LabCategoryPackageResult->Result->NormalOption->NAME_EN:null; }elseif(!empty($LabCategoryPackageResult->Option)){ $RBC['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $RBC['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $RBC['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $RBC['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $RBC['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } } if($LabCategoryPackageResult->Result->CODE == 'EP'){ if(!empty($LabCategoryPackageResult->RESULT)){ $EP['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $EP['RESULT'] = $LabCategoryPackageResult->RESULT; $EP['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $EP['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $EP['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $EP['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption?$LabCategoryPackageResult->Result->NormalOption->NAME_EN:null; }elseif(!empty($LabCategoryPackageResult->Option)){ $EP['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $EP['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $EP['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $EP['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } } if($LabCategoryPackageResult->Result->CODE == 'GC'){ if(!empty($LabCategoryPackageResult->RESULT)){ $GC['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $GC['RESULT'] = $LabCategoryPackageResult->RESULT; $GC['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $GC['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $GC['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $GC['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption?$LabCategoryPackageResult->Result->NormalOption->NAME_EN:null; }elseif(!empty($LabCategoryPackageResult->Option)){ $GC['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $GC['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $GC['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $GC['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } } if($LabCategoryPackageResult->Result->CODE == 'LEU' && $LabCategoryPackageResult->Option){ $LEU['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $LEU['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $LEU['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $LEU['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $LEU['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $LEU['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $LEU['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'NIT' && $LabCategoryPackageResult->Option){ $NIT['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $NIT['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $NIT['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $NIT['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $NIT['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $NIT['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $NIT['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'PRO' && $LabCategoryPackageResult->Option){ $PRO['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $PRO['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $PRO['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $PRO['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $PRO['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $PRO['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $PRO['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'KET' && $LabCategoryPackageResult->Option){ $KET['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $KET['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $KET['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $KET['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $KET['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $KET['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $KET['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'BIL' && $LabCategoryPackageResult->Option){ $BIL['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $BIL['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $BIL['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $BIL['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $BIL['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $BIL['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $BIL['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'BLD' && $LabCategoryPackageResult->Option){ $BLD['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $BLD['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $BLD['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $BLD['MAX_NORMAL'] = $LabCategoryPackageResult->Result->MAX_NORMAL; $BLD['MIN_NORMAL'] = $LabCategoryPackageResult->Result->MIN_NORMAL; $BLD['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $BLD['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'CST' && $LabCategoryPackageResult->OPTION_ID) { $CST['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $CST['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $CST['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $CST['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $CST['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'CRS' && $LabCategoryPackageResult->OPTION_ID ) { $CRS['CODE'] = $LabCategoryPackageResult->Result->NAME_EN; $CRS['NAME_EN'] = $LabCategoryPackageResult->Option->NAME_EN; $CRS['UNIT'] = $LabCategoryPackageResult->Result->UNIT; $CRS['NORMAL'] = $LabCategoryPackageResult->Result->NormalOption->NAME_EN; $CRS['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL; } if($LabCategoryPackageResult->Result->CODE == 'UAM' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){ $ResultOptions = new App\Models\LABCATEGORYPACKAGERESULTOPTIONS(); $AmorphousMaterials = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID); $AmorphousMaterials = $ResultOptions->whereIn('ID',$AmorphousMaterials)->get(); $UAM['NAME_AR'] = $LabCategoryPackageResult->Result->NAME_AR; $UAM['NAME_EN'] = $LabCategoryPackageResult->Result->NAME_EN; } if($LabCategoryPackageResult->Result->CODE == 'OT' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){ $ResultOptions = new App\Models\LABCATEGORYPACKAGERESULTOPTIONS(); $Others = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID); $Others = $ResultOptions->whereIn('ID',$Others)->get(); $OT['NAME_AR'] = $LabCategoryPackageResult->Result->NAME_AR; $OT['NAME_EN'] = $LabCategoryPackageResult->Result->NAME_EN; } if($LabCategoryPackageResult->Result->CODE == 'UCRT' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){ $ResultOptions = new App\Models\LABCATEGORYPACKAGERESULTOPTIONS(); $CrystalTypes = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID); $CrystalTypes = $ResultOptions->whereIn('ID',$CrystalTypes)->get(); $UCRT['NAME_AR'] = $LabCategoryPackageResult->Result->NAME_AR; $UCRT['NAME_EN'] = $LabCategoryPackageResult->Result->NAME_EN; } if($LabCategoryPackageResult->Result->CODE == 'UCAT' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){ $ResultOptions = new App\Models\LABCATEGORYPACKAGERESULTOPTIONS(); $CastTypes = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID); $CastTypes = $ResultOptions->whereIn('ID',$CastTypes)->get(); $UCAT['NAME_AR'] = $LabCategoryPackageResult->Result->NAME_AR; $UCAT['NAME_EN'] = $LabCategoryPackageResult->Result->NAME_EN; } } @endphp