File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_changePRFStatus.php

Back
<?php include 'core/database/connect.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); //$userID=$user_data['u_id']; $toDate = date_create() ->format("Y-m-d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $itemCode = mysql_escape_string($_POST['itemCode']); $actionNote = mysql_escape_string($_POST['actionNotes']); $actionNotes= "Return to Canvass: ".$actionNote; $newStat = mysql_escape_string($_POST['newStat']); $userID = mysql_escape_string($_POST['userID']); $prfCode = mysql_escape_string($_POST['prfCode']); $curStatusName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `id`='$newStat'"),0); $getItemPRFCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemCode'"),0); if(!empty($itemCode)){ if ($getItemPRFCode != $prfCode){ echo '<script>alert("ERROR: ITEM CODE and PRF NUMBER did not match. Please check your entry and try again. Thank you!")</script>'; exit(); }else{ $curItemStatus = mysql_result(mysql_query("SELECT `item_status` FROM `prf_request_detl` WHERE `id`='$itemCode'"),0); if($curItemStatus < 9){ mysql_query("UPDATE `prf_request_detl` SET `item_status`='$newStat', `approved_amount`= 0,`approved_qty`=0,`approved_proposal_code`=0,`award_to_vendor_id`=0,`awarded`=0,`canvass_sheet_creation_ts`='',`create_canvass_sheet`=0,`execom_approval_ts`='',`for_execom_canvass_approval`=0,`user_approval_ts`='',`user_canvass_approval`=0 WHERE `header_ref_code`='$prfCode' AND `deleted`=0 AND `id`='$itemCode'"); mysql_query("DELETE FROM `prf_execomcanvassapproval` WHERE `prf_ref_code` = '$prfCode' AND `item_code`='$itemCode'"); mysql_query("DELETE FROM `prf_validate_links` WHERE `po_code` = '$prfCode' AND `link` LIKE '%exapr%' AND `item_id`='$itemCode'"); }else{ echo '<script>alert("ERROR: Unable to update record due to current item status. Please contact your system administrator for assistance. Thank you!")</script>'; exit(); } } }else{ mysql_query("UPDATE `prf_request_detl` SET `item_status`='$newStat', `approved_amount`= 0,`approved_qty`=0,`approved_proposal_code`=0,`award_to_vendor_id`=0,`awarded`=0,`canvass_sheet_creation_ts`='',`create_canvass_sheet`=0,`execom_approval_ts`='',`for_execom_canvass_approval`=0,`user_approval_ts`='',`user_canvass_approval`=0 WHERE `header_ref_code`='$prfCode' AND `deleted`=0"); mysql_query("DELETE FROM `prf_execomcanvassapproval` WHERE `prf_ref_code` = '$prfCode'"); mysql_query("DELETE FROM `prf_validate_links` WHERE `po_code` = '$prfCode' AND `link` LIKE '%exapr%'"); } //mysql_query("UPDATE `prf_validate_links` SET `completed`='$newStat' WHERE `reference_code`='$prfCode'"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number,item_id) VALUES('{$actionNotes}','{$userID}','','{$newStat}','{$prfCode}','{$itemCode}')"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== echo "<p id='newAssValMSG' style='background:yellow;font-family:Calibri Light;font-size:12px;margin:0px;padding:1px;width:100%;float:left;color:blue'>Status: ".$curStatusName."</p>"; } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings