File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_sendREQUESTORSMSFF.php

Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); 193 * 1067 * 215 $prfDate = date_create() ->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 "<p style='padding:10px;font-family:Calibri;font-size:14px;font-weight:normal'>".$count." SMS Notification has been sent to all users with pending PRF</p>"; mysql_query("UPDATE `asa_versioning_db` SET `last_rqtr_ffup` = '$toDate' WHERE 1"); }else{ echo "<p style='padding:10px;font-family:Calibri;font-size:14px;font-weight:normal'>SMS Failed due to multiple attempt. You can only send follow once every day. Please try again tomorrow</p>"; } } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings