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'])){ $activePRF = mysql_escape_string($_POST['activePRF']); $reasonForCancellation = mysql_escape_string($_POST['reasonForCancellation']); $activeItem = mysql_escape_string($_POST['activeItem']); $chkIfWdPO = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `header_ref_code`='$activePRF' AND `po_code`!='' AND `id`='$activeItem'"),0); if($chkIfWdPO > 0){ echo ''; }else{ //mysql_query("UPDATE `prf_request_hdr` SET `current_status`='93', `deleted`=1 WHERE `reference_code`='$activePRF'"); mysql_query("UPDATE `prf_request_detl` SET `item_status`='93', `deleted`=1,`notes`='$reasonForCancellation' WHERE `header_ref_code`='$activePRF' AND `id`='$activeItem'"); mysql_query("UPDATE `prf_validate_links` SET `completed`='1' WHERE `item_id`='$activeItem'"); echo ''; mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number) VALUES('','{$reasonForCancellation}','{$activeID}','{$activeItem}','','{$activePRF}')"); } echo ""; $getItems = mysql_query("SELECT * FROM `prf_request_detl` WHERE `header_ref_code`='$activePRF'"); while($row=mysql_fetch_array($getItems)){ ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

".$row['date_created']."

".$row['item_description']."

".$row['quantity']."

"; $stat=$row['item_status']; $staName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `sequence`='$stat'"),0); echo $staName; echo "

"; exit; } ?>