format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$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'])){ $UpdateReferenceHeaderCode = mysql_escape_string($_POST['UpdateReferenceHeaderCode']); $exID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); //get approving head before GM $myTokenKey = $UpdateReferenceHeaderCode ."-".$UpdateReferenceHeaderCode; $myToken = md5(md5($myTokenKey)); $valLink ="prfHeadApproval.php"; $randomCodeFinal = rand(1001,99999); $randomCode = $randomCodeFinal."".$activeID; $chkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM prf_request_detl WHERE header_ref_code='$UpdateReferenceHeaderCode'"),0); if($chkIfExist > 0){ mysql_query("UPDATE prf_request_hdr SET current_status = 1 WHERE reference_code='$UpdateReferenceHeaderCode'"); $deptHeadID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$UpdateReferenceHeaderCode'"),0); $empUFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $empULname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $deptheadMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); $deptHeadEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0); //######################################################################################################################### //######################################################################################################################### $SMSMessage = "New purchase request has been routed to your for your approval. https://autohub.ph/prfnew.php?c=".$randomCode; $result = itexmoAA($deptheadMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ echo ''; }else if ($result == 0){ echo "SMS Sent!"; } else{ echo "Error Num ". $result . " was encountered!"; } //######################################################################################################################### //######################################################################################################################### $from = "support@autohubgroup.com"; $to = $deptHeadEmail; $subject = "NEW PURCHASE REQUEST"; $msgBox = "Hi ".$empUFname."! New purchase request has been routed to you for your approval. You can access the PRF by clicking the link below. https://autohub.ph/prfnew.php?c=".$randomCode." Autohub Support"; $headers = "From:" . $from; mail($to,$subject,$msgBox, $headers); //######################################################################################################################### //######################################################################################################################### }else{ echo""; } //####################################################################### //####################################################################### mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid) VALUES('{$randomCode}','{$valLink}','{$UpdateReferenceHeaderCode}','{$exID}')"); //####################################################################### //####################################################################### } ?>
NO REF. CODE DATE COMPANY DEALER REQ. CATEGOY REQ. TYPE APPROVED BY STATUS
".$count.""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
".strtoupper($row['reference_code'])."".strtoupper($row['date_created'])."".strtoupper($prfCompName)."".strtoupper($prfDealName)."".strtoupper($prfCatName)."".strtoupper($prfSubCatName)."".strtoupper($prfDeptApproverLName).", ".strtoupper($prfDeptApproverFName).""; $status = $row['current_status']; $statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0); echo $statusName; echo"
Selected Record: