format("Y-m-d"); $prfTime = date('H:i:s'); $myDateD = date_create() ->format("Y-m-d"); $myDate = $myDateD ." ". $prfTime; //$myUID = $user_data['u_id']; if(isset($_POST['done'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $userID = mysql_escape_string($_POST['userID']); $DelActionReferenceID = mysql_escape_string($_POST['DelActionReferenceID']); $selItemDesc = mysql_escape_string($_POST['selItemDesc']); $ActionReferenceIDDescXX = mysql_escape_string($_POST['ActionReferenceIDDescXX']); mysql_query("UPDATE `prf_request_detl` SET `for_canvass`='1', `item_status`='4', `ahg_admin_id`='$userID', `ahg_admin_date`='$myDate' WHERE `header_ref_code`='$UpdatePRFReferenceNumber' AND `deleted`=0"); mysql_query("UPDATE `prf_request_hdr` SET `ahg_admin_id`='$userID', `ahg_admin_date`='$myDate' WHERE `reference_code`='$UpdatePRFReferenceNumber'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber'"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($getItemDetl)){ $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 ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Rec.#	REF. #	ITEM DESCRIPTION	UoM	QUANTITY	-
".strtoupper($row['header_ref_code'])."	".strtoupper($row['item_description'])."	".strtoupper($row['uom'])."	".strtoupper($row['quantity'])."	"; echo $itemStatus; echo "

"; exit(); } ?>