";
echo "
";
echo "Rec.# | ";
echo "REF. # | ";
echo "TYPE | ";
echo "ITEM DESCRIPTION | ";
echo "UoM | ";
echo "QUANTITY | ";
echo "- | ";
echo "";
while($row=mysql_fetch_array($getItemDetl)){
$prfNumber = $row['header_ref_code'];
$count = $count + 1;
$itemStatusChk=$row['ahg_admin_id'];
$isDeleted = $row['deleted'];
if($itemStatusChk == 0){
if($isDeleted == 1){
$txtcolor='red';
$itemStatus='❌';
}else{
$txtcolor='black';
$itemStatus='❔';
}
}else{
$itemStatus='✅';
$txtcolor='black';
}
?>
".$row['id']."";
echo "| ".strtoupper($row['header_ref_code'])." | ";
echo "";
$getClass = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='".$row['item_class']."'"),0);
echo strtoupper($getClass);
echo" | ";
echo "".strtoupper($row['item_description'])." | ";
echo "".strtoupper($row['uom'])." | ";
echo "".strtoupper($row['quantity'])." | ";
echo "";
echo $itemStatus;
echo " | ";
echo "
";
}
echo "";
$chkAttachment = mysql_result(mysql_query("SELECT `attachment` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0);
if($chkAttachment == ""){
echo "
No attachment
";
}else{
echo "
📑";
}
?>