format("Y-m-d");
$myUID = $user_data['u_id'];
if(isset($_POST['done'])){
$itemRefCode = mysql_escape_string($_POST['itemRefCode']);
$myPONumberA = mysql_escape_string($_POST['myPONumber']);
$myPONumber = 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 = md5(md5($myTokenKey));
$valLink ="prfpovalidation.php";
$poChecker = mysql_result(mysql_query("SELECT `po_officer_id` FROM `prf_poapprover` WHERE `trans_type`='Checker' AND `deleted`=0"),0);
mysql_query("UPDATE `prf_request_detl` SET `po_code_posted`='1', `item_status`='8' WHERE `po_code`=$myPONumber");
mysql_query("UPDATE `prf_purchase_order` SET `token`='$myToken', `checked_by`='$poChecker', `date_posted`='$prfDate', `po_status`='1' WHERE `po_number`=$myPONumber");
$getPOApprovingOfficers=mysql_query("SELECT vts_users.`u_id`,vts_users.`u_fname`,vts_users.`u_lname`,vts_users.`usr_mobile`,vts_users.`email`,
prf_poapprover.`comp_id`,prf_poapprover.`po_officer_id`,prf_poapprover.`authority`
FROM prf_poapprover JOIN vts_users ON vts_users.`u_id` = prf_poapprover.`po_officer_id`
WHERE prf_poapprover.`deleted`=0 AND prf_poapprover.`trans_type`='Checker'");
while($xRow = mysql_fetch_array($getPOApprovingOfficers)){
$exID = $xRow['u_id'];
$randomCodeFinal = rand(10001,999999);
$randomCode = $randomCodeFinal."".$exID;
$SMSMessage = "Purchase Order (PO) has been routed to you for PO Validation prior to Approval. Click the link below to process the request:
https://autohub.ph/val.php?c=".$randomCode;
$myValidateLink = "https://autohub.ph/val.php?c=".$randomCode;
$empMobile = $xRow['usr_mobile'];
$empEmail = $xRow['email'];
$empFName = $xRow['u_fname'];
//$result = itexmo($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd);
$result = itexmoAA($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd);
if ($result == ""){
//echo '';
}else if ($result == 0){
//echo "SMS Sent!";
}
else{
//echo "Error Num ". $result . " was encountered!";
}
//#######################################################################
//#######################################################################
mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid,sms_link)
VALUES('{$randomCode}','{$valLink}','{$myPONumber}','{$exID}','{$myValidateLink}')");
//mysql_query("INSERT INTO prf_validate_links(code,link,po_code,uid)
//VALUES('{$randomCode}','{$valLink}','{$myPONumber}','{$exID}')");
//#######################################################################
//#######################################################################
//######################################PAGINATION#######################################################
//######################################PAGINATION#######################################################
$from = "support@autohub.ph";
$to = $empEmail;
$subject = "NEW PO FOR VALIDATION";
$msgBox = "Hi ".$empFName."!
New Purchase Order (PO) has been routed to you for PO Validation prior to Approval. Click the link below to process the request:
https://autohub.ph/val.php?c=".$randomCode;
$headers = "From:" . $from;
mail($to,$subject,$msgBox, $headers);
//######################################PAGINATION#######################################################
//######################################PAGINATION#######################################################
}
echo "";
?>
";
echo "";
echo "";
echo "";
//#######################################################################################################
//#######################################################################################################
$getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`='' ORDER BY `execom_approval_ts` DESC LIMIT $offSet, $noOfRecordPerPage ");
while($row=mysql_fetch_array($getItemHdr)){
$regHDRcode=$row['header_ref_code'];
$regCat=$row['category_id'];
$vendorID = $row['award_to_vendor_id'];
$vendorName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$vendorID'"),0);
$regCatName =mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$regCat'"),0);
$reqByID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0);
$reqCompID=$row['comp_id'];
$dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0);
$reqCompName = mysql_result(mysql_query("SELECT `comp_name` FROM vts_company WHERE comp_id='$reqCompID'"),0);
$reqByFName = mysql_result(mysql_query("SELECT u_fname FROM vts_users WHERE u_id='$reqByID'"),0);
$reqByLName = mysql_result(mysql_query("SELECT u_lname FROM vts_users WHERE u_id='$reqByID'"),0);
$fileCode = mysql_result(mysql_query("SELECT `file_code` FROM `prf_uploadedcanvass` WHERE `ref_code`='".$row['approved_proposal_code']."'"),0);
?>