File manager

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

Back
<?php date_default_timezone_set('Asia/Manila'); //header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $keyCode= $_REQUEST['token']; $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); //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## function itexmoCGlobal($number,$message,$apicode,$passwd){ $ch = curl_init(); $itexmo = array('1' => $number, '2' => $message, '3' => $apicode, 'passwd' => $passwd); curl_setopt($ch, CURLOPT_URL,"https://www.itexmo.com/php_api/api.php"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($itexmo)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); return curl_exec ($ch); curl_close ($ch); } //########################################################################## // ITEXMO SEND SMS API - PHP - CURL-LESS METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## //====================================================================== if($keyCode == 10090706){ $sql = "SELECT * FROM `cl_approving_officers` WHERE `cl_status`=1 GROUP BY `cl_emp_id_a`"; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { $approverA = $row['cl_emp_id_a']; $chkIfPendingExist=mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_approver_id_a` ='$approverA' AND `cl_status` !='Cleared' AND `cl_approved_by_id` = 0 AND `hdr_status` != 0 \|\| `cl_approver_id_b`='$approverA' AND `cl_status` !='Cleared' AND `cl_approved_by_id` = 0 AND `hdr_status` != 0"),0); if($chkIfPendingExist > 0){ $activeUID = $approverA; $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); $MyMessage = "Hi ". $myUFName . "! You have pending employee clearance form waiting for your signature. Please login at https://autohub.ph/connect or to your ASA App. Thank you! "; itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } } //Notify Approving Officers $sql = "SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `cl_recommender_a_timestamp`!='' AND `cl_recommender_b_id` !='' AND `cl_status` = 1 AND `cl_approver_id_timestamp` ='' AND `cl_h_hr_approval`='FINAL APPROVAL' GROUP BY `cl_approver_id`"; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $activeUID = $row['cl_approver_id']; $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); $MyMessage = "Hi ". $myUFName . "! You have pending employee clearance form waiting for your Final Approval. Please login to your ASA Mobile APP to process clearance approval. Thank you! "; itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } //Notify Approving Officers $sql = "SELECT `cl_approver_id_b` FROM `cl_clearance_header` WHERE `cl_recommender_a_timestamp`!='' AND `cl_recommender_b_id` !='' AND `cl_status` = 1 AND `cl_approver_id_timestamp` ='' AND `cl_h_hr_approval`='FINAL APPROVAL' GROUP BY `cl_approver_id_b`"; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $activeUID = $row['cl_approver_id_b']; $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); $MyMessage = "Hi ". $myUFName . "! You have pending employee clearance form waiting for your Final Approval. Please login to your ASA to process clearance approval. Thank you! "; itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } //Notify endorsing Officers A $sql = "SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `cl_recommender_a_timestamp` = '' AND `cl_status` = 1 AND `cl_h_hr_approval`='FOR ENDORSEMENT' GROUP BY `cl_recommender_a_id`"; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { if ($row['cl_recommender_a_timestamp']=''){ $activeUID = $row['cl_recommender_a_id']; $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); $MyMessage = "Hi ". $myUFName . "! You have pending employee clearance form waiting to be endorsed. Please login to your ASA Mobile APP to process pending clearance. Thank you! "; itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } } //Notify endorsing Officers B $sql = "SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `cl_recommender_b_timestamp` = '' AND `cl_status` = 1 AND `cl_h_hr_approval`='FOR ENDORSEMENT' GROUP BY `cl_recommender_b_id`"; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { if ($row['cl_recommender_b_timestamp']=''){ $activeUID = $row['cl_recommender_b_id']; $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); $MyMessage = "Hi ". $myUFName . "! You have pending employee clearance form waiting to be endorsed. Please login to your ASA Mobile APP to process pending clearance. Thank you! "; itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } } } ?>

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