format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $selUOM = mysql_escape_string($_POST['selUOM']); $selQuantity = mysql_escape_string($_POST['selQuantity']); $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $selItemDesc = mysql_escape_string($_POST['selItemDesc']); $ActionReferenceIDDescXX = mysql_escape_string($_POST['ActionReferenceIDDescXX']); $getOldQTY = mysql_result(mysql_query("SELECT `quantity` FROM `prf_request_detl` WHERE `id`='$ActionReferenceIDDescXX'"),0); mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number) VALUES('','Change Item QTY','{$myUID}','{$getOldQTY}','{$selQuantity}','{$UpdatePRFReferenceNumber}')"); mysql_query("UPDATE `prf_request_detl` SET `item_description`='$selItemDesc',`uom`='$selUOM',`quantity`='$selQuantity' WHERE `id`='$ActionReferenceIDDescXX'"); //mysql_query("UPDATE `prf_request_hdr` SET `ahg_admin_id`='$myUID', `ahg_admin_date`='$myDate' WHERE `reference_code`='$UpdatePRFReferenceNumber'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber' AND `deleted`=0"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; $itemStatusChk=$row['ahg_admin_id']; if($itemStatusChk !=0){ $itemStatus='Ok'; }else{ $itemStatus='???'; } ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Rec.#	REF. #	TYPE	ITEM DESCRIPTION	UoM	QUANTITY	-
".strtoupper($row['header_ref_code'])."	"; $getClass = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='".$row['item_class']."'"),0); echo strtoupper($getClass); echo"	".strtoupper($row['item_description'])."	".strtoupper($row['uom'])."	".strtoupper($row['quantity'])."	"; echo $itemStatus; echo "

"; exit(); } ?>