format("Y-m-d");
$prfTime = date('H:i:s');
$fullDateTime = $prfDate . " ".$prfTime;
$myDate = date_create() ->format("Y-m-d");
$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);
$toDate = date_create() ->format("Y-m-d");
$MyApicode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `ver_id`=1"),0);
$MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `ver_id`=1"),0);
if(isset($_POST['done'])){
$getLastFollowup = mysql_result(mysql_query("SELECT `last_xcom_ffup` FROM `asa_versioning_db` WHERE 1"),0);
//echo $toDate . " - ".$getLastFollowup;
if($toDate != $getLastFollowup){
$sql = mysql_query("SELECT * FROM `prf_validate_links` WHERE `deleted`=0 AND `completed`=0 AND `sms_link`!='' AND `sms_link` LIKE '%xcom%' AND `matrix_level` < 5 GROUP BY `uid`");
while($row = mysql_fetch_array($sql))
{
$count = $count + 1;
$activeUID = $row['uid'];
$activeUMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE u_id = '$activeUID'"),0);
$myUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE u_id = '$activeUID'"),0);
$myULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE u_id = '$activeUID'"),0);
$MyMessage = "GOOD DAY AHG OFFICERS! There are pending PURCHASE REQUEST items waiting for GMs / AVPs and EXECOM Approval. Please check your ASA App to process this request. Thank you!";
itexmoAA($activeUMobile,$MyMessage,$MyApicode,$MyPasswd);
}
echo "".$count." SMS Notification has been sent to all OFFCIERS with pending Approval
";
mysql_query("UPDATE `asa_versioning_db` SET `last_rqtr_ffup` = '$toDate' WHERE 1");
}else{
echo "SMS Failed due to multiple attempt. You can only send follow once every day. Please try again tomorrow
";
}
}
?>