File manager - Edit - /home/autoph/public_html/connect/api/prf/PRF_PRFRecanvassItem.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $prfTime = date('H:i:s'); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $ApiKey= $_REQUEST['keyID']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == 'AAA1024197710262009EEE_RECAN'){ $userID = $_REQUEST['userID']; $itemID = $_REQUEST['itemID']; $prfNumber = $_REQUEST['prfNumber']; $reason='Re-Canvass'; $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$prfNumber'"),0); mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$prfNumber}','{$userID}','{$reason}','{$requestorID}','{$toDate}','{$prfTime}'"); mysql_query("UPDATE `prf_request_detl` SET `canvass_sheet_creation_ts`='',`create_canvass_sheet`='1',`for_execom_canvass_approval`='0', `awarded`='0',`award_to_vendor_id`='',`approved_proposal_code`='',`approved_qty`='0',`approved_amount`='0',`execom_approval_ts`='',`user_canvass_approval`='',`user_approval_ts`='',`create_canvass_sheet`='',`item_status`='4' WHERE `id`='$itemID'"); mysql_query("UPDATE `prf_request_hdr` SET `current_status`='4' WHERE `reference_code`='$prfNumber'"); mysql_query("DELETE FROM `prf_execomcanvassapproval` WHERE `item_code` = '$itemID'"); mysql_query("UPDATE `prf_validate_links` SET `completed`='1' WHERE `po_code`='$prfNumber' AND `link` LIKE '%exapr.php%'"); $messageToReqB ="Your item #".$itemID." request has been returned by EXECOM to procurement for re-canvass. "; $json = json_encode(["message" => $messageToReqB, "status" => "Completed"]); } echo $json; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings