File manager - Edit - /home/autoph/public_html/connect/home/deleteUnPostedPO.php
Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->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 '<script>alert("Total of '.$countDeleted.' abandoned PO since Yesterday has been removed.")</script>'; } exit(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings