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'])){ $MyActivePO = mysql_escape_string($_POST['MyActivePO']); $activeItem = mysql_escape_string($_POST['activeItem']); $getPRFNumber = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$activeItem'"),0); $chkIfWdPO = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_purchase_order` WHERE `po_status`> 4 AND `po_number`='$MyActivePO'"),0); if($chkIfWdPO > 0){ echo ''; }else{ mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number,item_id) VALUES('','Cancelled PO','{$activeID}','{$getPRFNumber}','{$activeItem}','{$MyActivePO}','{$activeItem}')"); mysql_query("UPDATE `prf_request_detl` SET `item_status`='7', `po_code`='',`po_code_posted`=0 WHERE `po_code`='$MyActivePO' AND `deleted`=0 AND `id`='$activeItem'"); echo ''; } echo ""; $getItems = mysql_query("SELECT * FROM `prf_request_detl` WHERE `po_code`='$MyActivePO'"); $poAmount = mysql_result(mysql_query("SELECT SUM(`approved_amount`) FROM `prf_request_detl` WHERE `po_code`='$MyActivePO' AND `deleted`= 0"),0); while($row=mysql_fetch_array($getItems)){ $counter = $counter + 1; ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo "

".$row['header_ref_code']."	".$row['item_description']."	".$row['approved_qty']."	".$row['approved_amount']."
AMOUNT: ".$poAmount."

"; exit; } ?>