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'])){ $userID = mysql_escape_string($_POST['userActiveID']); $getUnpostedPO = mysql_query("SELECT * FROM `prf_purchase_order` WHERE `po_status` = 0 AND `date_created` < '$myDate'"); while($row = mysql_fetch_array($getUnpostedPO)){ $countDeleted = $countDeleted + 1; $poNumber = $row['po_number']; mysql_query("DELETE FROM `prf_purchase_order` WHERE `po_status` = 0 AND `date_created` < '$myDate' AND `po_number`='$poNumber'"); mysql_query("UPDATE `prf_request_detl` SET `po_code`='', `item_status`=7 WHERE `po_code` = '$poNumber'"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number) VALUES('Deleted Unposted PO','{$userID}','','','{$poNumber}')"); //AUDIT LOGS======================================================10000071 //AUDIT LOGS====================================================== 10000068 //AUDIT LOGS======================================================10000064 //AUDIT LOGS====================================================== } echo ''; } exit(); ?>