format("Y-m-d"); $signedTime =date('H:i:s'); $dateSent = $prfDate . " " .$signedTime; $myUID = $user_data['u_id']; if(isset($_POST['done'])){ //$itemRefCode = mysql_escape_string($_POST['itemRefCode']); $myPONumberA = mysql_escape_string($_POST['myPONumber']); $myPONumber = trim(str_replace(' ', '', $myPONumberA)); $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); $myTokenKey = $myPONumber ."-".$myPONumber; $myToken = mysql_result(mysql_query("SELECT `token` FROM `prf_purchase_order` WHERE `po_number`=$myPONumber"),0); $randomCode = rand(1001,9999999)."".$myUID; $vendorID = mysql_result(mysql_query("SELECT `vendor_id` FROM `prf_purchase_order` WHERE `po_number`='$myPONumber'"),0); $vendorEmail = mysql_result(mysql_query("SELECT `contact_person_email` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $vendorMobile = mysql_result(mysql_query("SELECT `contact_person_mobile` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $vendorContactName = mysql_result(mysql_query("SELECT `contact_person` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0); $valLink ="prfvendorview.php?vid=".$vendorID."&pid=".$myPONumber."&key=".$randomCode."&token=".$myToken; mysql_query("UPDATE `prf_request_detl` SET `item_status`='9' WHERE `po_code`=$myPONumber"); mysql_query("UPDATE `prf_purchase_order` SET `date_forwarded_to_vendor`='$dateSent',`po_status`='4' WHERE `po_number`=$myPONumber"); $SMSMessage = "New Purchase Order has been awarded to you. please click the link below and type the (".$randomCode.") OTP code to access the PO https://autohub.ph/ven.php?c=".$randomCode; $myPostLink = "https://autohub.ph/ven.php?c=".$randomCode; //####################################################################### //####################################################################### //mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid) //VALUES('{$randomCode}','{$valLink}','{$myPONumber}','{$vendorID}')"); mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid,sms_link) VALUES('{$randomCode}','{$valLink}','{$myPONumber}','{$vendorID}','{$myPostLink}')"); //####################################################################### //####################################################################### //############################################################################################# //############################################################################################# $from = "support@autohub.ph"; $to = $vendorEmail; $subject = "PO AWARDED"; $msgBox = "Hi ".$vendorContactName."! New P.O Has been awarded to you by Autohub Group. Download the PO by clicking the link below https://autohub.ph/ven.php?c=".$randomCode; $headers = "From:" . $from; mail($to,$subject,$msgBox, $headers); //############################################################################################# //$SMSMessage = "Purchase Order has been routed to you for your Approval //https://www.autohub.ph/connect/home/prfpoapproval.php?uid=".$exID."&id=".$myPONumber."&token=".$tokenKey; //$result = itexmo($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); $result = itexmoAA($vendorMobile, $msgBox,$MyAPIcode,$MyPasswd); if ($result == ""){ //echo ''; }else if ($result == 0){ //echo "SMS Sent!"; } else{ //echo "Error Num ". $result . " was encountered!"; } //############################################################################################# //echo "PO has been routed to supplier. You will be notified once the supplier read and download the Purchase Order using the link provided via e-mail and SMS."; echo ''; ?>

REC.#	PO NUMBER	DATE POSTED	COMPANY	DEALER	VENDOR	TERMS	STATUS	REMARKS	...

".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

".$row['po_number']."

".$row['date_posted']."

".$reqCompName."

".$reqDealName."

".$vendorName."

".$row['terms']." Days

"; $poStat = mysql_result(mysql_query("SELECT `po_status` FROM `prf_po_status` WHERE `po_code`='".$row['po_status']."'"),0); echo $poStat; echo"

".$row['remarks']."

📑