@php
$ProfileID = $Profile->ID;
$LabCategoryPackageResults = \App\Models\ENDUSERLABORDERPACKAGERESULT::where('END_USER_PACKAGE_ID',$Package->ID)->with('Option','Result')
->join("PROFILE_ENABLE_RESULT", function ($join) use($ProfileID){
$join->on("PROFILE_ENABLE_RESULT.RESULT_ID", "=", "END_USER_LAB_ORDER_PACKAGE_RESULT.RESULT_ID");
$join->on("PROFILE_ENABLE_RESULT.PROFILE_ID", "=", \DB::raw($ProfileID));
$join->whereNull("PROFILE_ENABLE_RESULT.HOSPITAL_ID");
})
->select("END_USER_LAB_ORDER_PACKAGE_RESULT.*","PROFILE_ENABLE_RESULT.NAME_EN")
->get();
$Sensitive = [];
$Intermediate = [];
$Resistant = [];
$UPUC = $UEPC = $URBC = $UYES = $CLUE = $BACT = null;
$UPUCG = $UEPCG = $URBCG = $UYESG = $SkinS = null;
$SITE = $REVERSE = $MACRO = $MACROE = $ORGA = $ColonyCount = null;
foreach($LabCategoryPackageResults as $LabCategoryPackageResult){
if($LabCategoryPackageResult->Result->CODE == 'UCST'){
if(!empty($LabCategoryPackageResult->Option)){
$SpecimenType['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$SpecimenType['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
}elseif($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$SpecimenType['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$SpecimenType['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'ORG'){
if(!empty($LabCategoryPackageResult->Option)){
$OrganismText['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$OrganismText['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$OrganismIsNormal['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}elseif($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$OrganismText['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$OrganismText['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'ORGT'){
if(!empty($LabCategoryPackageResult->Option)){
$OrgansimType['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$OrgansimType['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
}
}
if($LabCategoryPackageResult->Result->CODE == 'SkinS'){
if(!empty($LabCategoryPackageResult->Option)){
$SkinS['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$SkinS['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UPUC'){
if(!empty($LabCategoryPackageResult->Option)){
$UPUC['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UPUC['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UPUC['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UEPC'){
if(!empty($LabCategoryPackageResult->Option)){
$UEPC['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UEPC['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UEPC['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'URBC'){
if(!empty($LabCategoryPackageResult->Option)){
$URBC['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$URBC['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$URBC['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UYES'){
if(!empty($LabCategoryPackageResult->Option)){
$UYES['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UYES['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UYES['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'ClueCell'){
if(!empty($LabCategoryPackageResult->Option)){
$CLUE['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$CLUE['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$CLUE['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'Bacteria' || $LabCategoryPackageResult->Result->CODE == 'SBacteria'){
if(!empty($LabCategoryPackageResult->Option)){
$BACT['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$BACT['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$BACT['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UPUCG'){
if(!empty($LabCategoryPackageResult->Option)){
$UPUCG['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UPUCG['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UPUCG['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UEPCG'){
if(!empty($LabCategoryPackageResult->Option)){
$UEPCG['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UEPCG['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UEPCG['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'URBCG'){
if(!empty($LabCategoryPackageResult->Option)){
$URBCG['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$URBCG['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$URBCG['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UYESG'){
if(!empty($LabCategoryPackageResult->Option)){
$UYESG['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UYESG['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UYESG['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'UGROW'){
if(!empty($LabCategoryPackageResult->Option)){
$UGROW['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$UGROW['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$UGROW['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'ColonyCount'){
if(!empty($LabCategoryPackageResult->Option)){
$ColonyCount['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$ColonyCount['RESULT'] = $LabCategoryPackageResult->Option->NAME_EN;
$ColonyCount['IS_NORMAL'] = $LabCategoryPackageResult->Option->IS_NORMAL;
}
}
if($LabCategoryPackageResult->Result->CODE == 'CCC'){
if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$ColoniesCount['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$ColoniesCount['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'SITE'){
if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$SITE['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$SITE['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'MACRO'){
if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$MACRO['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$MACRO['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'REVERSE'){
if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$REVERSE['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$REVERSE['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'MACROE'){
if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$MACROE['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$MACROE['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'ORGA'){
if($LabCategoryPackageResult->RESULT == 0 || !empty($LabCategoryPackageResult->RESULT)){
$ORGA['NAME_EN'] = !empty($LabCategoryPackageResult->NAME_EN) ? $LabCategoryPackageResult->NAME_EN : $LabCategoryPackageResult->Result->NAME_EN;
$ORGA['RESULT'] = $LabCategoryPackageResult->RESULT;
}
}
if($LabCategoryPackageResult->Result->CODE == 'OSTO' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){
$ResultOptions = new \App\Models\LABCATEGORYPACKAGERESULTOPTIONS();
$Sensitive = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID);
$Sensitive = $ResultOptions->whereIn('ID',$Sensitive)->get();
$optionValuesArray = json_decode($LabCategoryPackageResult->MULTIPLE_OPTION_VALUES);
if(!empty($optionValuesArray)){
$Sensitive = $Sensitive->map(function($item) use ($optionValuesArray) {
foreach ($optionValuesArray as $option) {
if ($option->option_id == $item->ID) {
$item->MC_VALUE = $option->option_value;
break;
}
}
return $item;
});
}
}elseif($LabCategoryPackageResult->Result->CODE == 'OIM' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){
$ResultOptions = new \App\Models\LABCATEGORYPACKAGERESULTOPTIONS();
$Intermediate = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID);
$Intermediate = $ResultOptions->whereIn('ID',$Intermediate)->get();
$optionValuesArray = json_decode($LabCategoryPackageResult->MULTIPLE_OPTION_VALUES);
if(!empty($optionValuesArray)){
$Intermediate = $Intermediate->map(function($item) use ($optionValuesArray) {
foreach ($optionValuesArray as $option) {
if ($option->option_id == $item->ID) {
$item->MC_VALUE = $option->option_value;
break;
}
}
return $item;
});
}
}elseif($LabCategoryPackageResult->Result->CODE == 'ORE' && !empty($LabCategoryPackageResult->MULTIPLE_OPTION_ID)){
$ResultOptions = new \App\Models\LABCATEGORYPACKAGERESULTOPTIONS();
$Resistant = explode(",",$LabCategoryPackageResult->MULTIPLE_OPTION_ID);
$Resistant = $ResultOptions->whereIn('ID',$Resistant)->get();
$optionValuesArray = json_decode($LabCategoryPackageResult->MULTIPLE_OPTION_VALUES);
if(!empty($optionValuesArray)){
$Resistant = $Resistant->map(function($item) use ($optionValuesArray) {
foreach ($optionValuesArray as $option) {
if ($option->option_id == $item->ID) {
$item->MC_VALUE = $option->option_value;
break;
}
}
return $item;
});
}
}
}
$all = array(
$Sensitive,
$Intermediate,
$Resistant
);
$largestArray = max($all);
@endphp
@if (!empty($OrganismText) && empty($OrganismIsNormal['IS_NORMAL']) && empty($Profile->ENABLE_TABLE_CULTURE))
Sensitivity Testing
@php
$labels = ['Sensitive to' => 20, 'Intermediate' => 87, 'Resistant' => 154];
foreach ($labels as $label => $positionX) {
if (!empty($$label)) {
echo "
{$label}
";
}
}
@endphp
{{ $SpecimenType['NAME_EN'] }}:
{{ $SpecimenType['RESULT'] }}
@endif
@php $DirectExamination = false; @endphp
@if(!empty($UPUC) || !empty($UEPC) || !empty($URBC) || !empty($UYES) || !empty($CLUE) || !empty($BACT))
@php $DirectExamination = true; @endphp
Direct Examination:
@endif
@if(!empty($UPUC))
{{ $UPUC['NAME_EN'] }}:
{{ $UPUC['RESULT'] }} /HPF
@endif
@if(!empty($UEPC))
{{ $UEPC['NAME_EN'] }}:
{{ $UEPC['RESULT'] }} /HPF
@endif
@if(!empty($URBC))
{{ $URBC['NAME_EN'] }}:
{{ $URBC['RESULT'] }} /HPF
@endif
@if(!empty($UYES))
{{ $UYES['NAME_EN'] }}:
{{ $UYES['RESULT'] }}
@endif
@if(!empty($CLUE))
{{ $CLUE['NAME_EN'] }}:
{{ $CLUE['RESULT'] }}
@endif
@if(!empty($BACT))
{{ $BACT['NAME_EN'] }}:
{{ $BACT['RESULT'] }}
@endif
@if (!empty($OrganismText) || !empty($OrgansimType))
Culture Result:
{{ $OrganismText['NAME_EN'].':'}}
{{ $OrganismText['RESULT']}}
@endif
@if (!empty($SkinS))
{{ $SkinS['NAME_EN'].':'}}
{{ $SkinS['RESULT']}}
@endif
@if(empty($DirectExamination))
@if(!empty($UPUCG) || !empty($UEPCG) || !empty($URBCG) || !empty($UYESG))
Gram Stain:
@endif
@foreach(['UPUCG', 'UEPCG', 'URBCG', 'UYESG'] as $item)
@php $data = $$item; @endphp
@if(!empty($data) && !empty($data['RESULT']))
{{ $data['NAME_EN'] }}:
{{ $data['RESULT'] }}
@endif
@endforeach
@foreach(['SITE', 'REVERSE', 'MACRO', 'MACROE', 'ORGA'] as $item)
@php $data = $$item; @endphp
@if(!empty($data) && !empty($data['RESULT']))
{{ $data['NAME_EN'] }}:
{{ $data['RESULT'] }}
@endif
@endforeach
@endif
@if (!empty($OrgansimType))
{{ $OrgansimType['NAME_EN'].':'}}
{{ $OrgansimType['RESULT']}}
@endif
@if (!empty($ColoniesCount) && !empty($ColoniesCount['RESULT']))
{{ $ColoniesCount['NAME_EN'].':'}}
{{ $ColoniesCount['RESULT']}}
@endif
@if (!empty($UGROW) && !empty($UGROW['RESULT']))
{{ $UGROW['NAME_EN'].':'}}
{{ $UGROW['RESULT']}}
@endif
@if (!empty($ColonyCount) && !empty($ColonyCount['RESULT']))
{{ $ColonyCount['NAME_EN'].':'}}
{{ $ColonyCount['RESULT']}}
@endif
@if(!empty($DirectExamination))
@if(!empty($UPUCG) || !empty($UEPCG) || !empty($URBCG) || !empty($UYESG))
Gram Stain:
@endif
@if(!empty($UPUCG) && !empty($UPUCG['RESULT']))
{{ $UPUCG['NAME_EN'] }}: {{ $UPUCG['RESULT'] }}
@endif
@if(!empty($UEPCG) && !empty($UEPCG['RESULT']))
{{ $UEPCG['NAME_EN'] }}: {{ $UEPCG['RESULT'] }}
@endif
@if(!empty($URBCG) && !empty($URBCG['RESULT']))
{{ $URBCG['NAME_EN'] }}: {{ $URBCG['RESULT'] }}
@endif
@if(!empty($UYESG) && !empty($UYESG['RESULT']))
{{ $UYESG['NAME_EN'] }}: {{ $UYESG['RESULT'] }}
@endif
@if(!empty($SITE) && !empty($SITE['RESULT']))
{{ $SITE['NAME_EN'] }}: {{ $SITE['RESULT'] }}
@endif
@if(!empty($REVERSE) && !empty($REVERSE['RESULT']))
{{ $REVERSE['NAME_EN'] }}: {{ $REVERSE['RESULT'] }}
@endif
@if(!empty($MACRO) && !empty($MACRO['RESULT']))
{{ $MACRO['NAME_EN'] }}: {{ $MACRO['RESULT'] }}
@endif
@if(!empty($MACROE) && !empty($MACROE['RESULT']))
{{ $MACROE['NAME_EN'] }}: {{ $MACROE['RESULT'] }}
@endif
@if(!empty($ORGA) && !empty($ORGA['RESULT']))
{{ $ORGA['NAME_EN'] }}: {{ $ORGA['RESULT'] }}
@endif
@if(count($Sensitive) > 0)
Sensitive to:
@endif
@if(count($Intermediate) > 0)
Intermediate:
@endif
@if(count($Resistant) > 0)
Resistant:
@endif
@endif
@if(!empty($largestArray))
@if(!empty($Profile->ENABLE_TABLE_CULTURE))
@php
$AllABArray = [];
foreach($Sensitive as $Sens) {
$AllABArray[$Sens->NAME_EN]['TEXT'] = "S";
$AllABArray[$Sens->NAME_EN]['VALUE'] = !empty($Sens->MC_VALUE) ? $Sens->MC_VALUE : '';
}
foreach($Intermediate as $Int) {
$AllABArray[$Int->NAME_EN]['TEXT'] = "I";
$AllABArray[$Int->NAME_EN]['VALUE'] = !empty($Int->MC_VALUE) ? $Int->MC_VALUE : '';
}
foreach($Resistant as $Res) {
$AllABArray[$Res->NAME_EN]['TEXT'] = "R";
$AllABArray[$Res->NAME_EN]['VALUE'] = !empty($Res->MC_VALUE) ? $Res->MC_VALUE : '';
}
$AbCount = 0;
$c = 0;
@endphp
Sensitivity Testing
R Resistant
I Intermediate
S Sensitive
@php
$AbCount = 0;
$c = 0;
$totalItems = count($AllABArray);
@endphp
@foreach($AllABArray as $Antibiotic => $Sensitivity)
@php
$AbCount++;
$c++;
@endphp
{{ str_replace('/', ' / ', $Antibiotic) }}
@if(!empty($Sensitivity['VALUE']))
{{ $Sensitivity['TEXT'] }}
({!! $Sensitivity['VALUE'] !!})
@else
{{ $Sensitivity['TEXT'] }}
@endif
@if($AbCount == 3 || $c == $totalItems)
@if($c == $totalItems && $AbCount < 3)
@for($i = $AbCount; $i < 3; $i++)
@endfor
@endif
@if($c != $totalItems)
@endif
@php $AbCount = 0; @endphp
@endif
@endforeach
@endif
@endif
@include('pdf.normal_report.components.analysis_tests.layout.comment')