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");
//##########################################################################
// ITEXMO SEND SMS API - PHP - CURL METHOD
// Visit www.itexmo.com/developers.php for more info about this API
//##########################################################################
//##########################################################################
// ITEXMO SEND SMS API - PHP - CURL-LESS METHOD
// Visit www.itexmo.com/developers.php for more info about this API
//##########################################################################
//======================================================================
if(isset($_POST['done'])){
$getLastFollowup = mysql_result(mysql_query("SELECT `last_rqtr_ffup` FROM `asa_versioning_db` WHERE 1"),0);
//echo $toDate . " - ".$getLastFollowup;
if($toDate != $getLastFollowup){
$sql = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval` = 1 AND `user_approval_ts` ='' AND `create_canvass_sheet`=0 GROUP BY `header_ref_code`");
while($row = mysql_fetch_array($sql))
{
$count = $count + 1;
$myPRF = $row['header_ref_code'];
$activeUID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$myPRF'"),0);
$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 = "Hi " .$myUFName. "! You have pending Purchase Request waiting for your confirmation. Go to USER APPROVAL under your account to process this request";
itexmoAA($activeUMobile,$MyMessage,$MyApicode,$MyPasswd);
}
echo "".$count." SMS Notification has been sent to all users with pending PRF
";
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
";
}
}
?>