<?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 DISTINCT(employee_id),u_id, u_fname, u_lname, usr_mobile, u_position  FROM vts_users WHERE `u_status`='1'";
         
            
        	$sqlTable = mysql_query($sql, $conn);
        	while($row = mysql_fetch_assoc($sqlTable))
        	{ 
        	    $count = $count + 1;
                $activeUID = $row['u_id'];
                $activeUMobile = $row['usr_mobile'];
                $myUFName = $row['u_fname'];
                $myULName = $row['u_lname'];
                $getProspect = mysql_result(mysql_query("SELECT COUNT('id') FROM sales_prospecting WHERE sales_id = $activeUID AND status='open'"),0);
              //echo $activeUID. "<br>";
              //echo $activeUMobile. "<br>";
             // echo $myUFName. "<br>";
             // echo $myULName. "<br>My Propect: ";
             // echo $getProspect. "<br>My Count: ";
            //  echo $count. "<br>";
             if($getProspect > 0){
                   $MyMessage = "Hi ". $myUFName . " " . $myULName ."!   Your clients are waiting for your updates today.  Please login to your ASA to access your prospect information.  Thank you! ";
                   
                   itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd);
               }
        	}
          
 
    
}
 
 
?>