format("Y-m-d");
$prfTime = date('H:i:s');
$myDate = date_create() ->format("Y-m-d");
$activeID=$user_data['u_id'];
if(isset($_POST['done'])){
$DelActionReferenceID = mysql_escape_string($_POST['DelActionReferenceID']);
$DeletedPRFReferenceNumber = mysql_result(mysql_query("SELECT header_ref_code FROM prf_request_detl WHERE id='$DelActionReferenceID'"),0);
mysql_query("UPDATE prf_request_detl SET deleted = 1 WHERE id='$DelActionReferenceID'");
}
?>
";
echo "";
echo "| NO | ";
echo "REF. # | ";
echo "ITEM TYPE | ";
echo "ITEM DESCRIPTION | ";
echo "UoM | ";
echo "QUANTITYx | ";
echo "";
while($row=mysql_fetch_array($getItemDetl)){
$count = $count + 1;
$itemClassID = $row['item_class'];
$itemClassDes = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='$itemClassID'"),0);
?>".$row['id']."";
echo "| ".strtoupper($row['header_ref_code'])." | ";
echo "".strtoupper($itemClassDes)." | ";
echo "".strtoupper($row['item_description'])." | ";
echo "".strtoupper($row['uom'])." | ";
echo "".$row['quantity']." | ";
echo "
";
}
echo "";
?>