format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; $uniqueRefID=$user_data['u_id']; $MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); $ExecomSelectedCanvassID = mysql_escape_string($_POST['ExecomSelectedCanvassID']); $PRFRefCodeID = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $requestorID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$PRFRefCodeID'"),0); 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`='$PRFRefCodeID'"); mysql_query("DELETE FROM `prf_execomcanvassapproval` WHERE `item_code` = '$itemID'"); mysql_query("UPDATE `prf_validate_links` SET `completed`='1' WHERE `po_code`='$PRFRefCodeID' AND `link` LIKE '%exapr.php%'"); $messageToReqB ="You ".$itemDes." request has been returned by EXECOM to procurement for re-canvass. "; mysql_query("INSERT INTO `prf_ff_message`(ref_code,sender_id,message,send_to,date,time) VALUES('{$PRFRefCodeID}','{$uniqueRefID}','{$messageToReqB}','{$requestorID}','{$myDate}','{$prfTime}')"); } ?> "; echo "

"; echo "

Record ID:

"; echo "

Requestor:

"; echo "

Date Needed:

"; echo "

Item Description:

"; echo "

Category:

"; echo "

Quantity:

"; echo "

Proposal:

"; echo "

"; echo ""; echo ""; echo ""; } ?>

View Request