<?php
 ini_set('max_execution_time', 300); //300 seconds = 5 minutes
 $domain ="247sms.com";
// $sender ="247sms";
 $mfrom ="no-reply@247sms.com";
 $mfromname=" Support 247sms.com";

  date_default_timezone_set('Africa/Lagos');
 
 

  
  function generateTransID()
   {
      $today = date("Ymds");
      $rand = strtoupper(substr(uniqid(sha1(time())),0,4));
      $rand = str_replace("A","1",$rand);
      $rand = str_replace("B","2",$rand);
      $rand = str_replace("C","3",$rand);
      $rand = str_replace("D","4",$rand);
      $rand = str_replace("E","5",$rand);
      $rand = str_replace("F","6",$rand);
      $unique = $today  . $rand;
      return $unique;
}


 
function removePosion($mstr)
{
      $mstring = str_replace("'","^",$mstr);
      return $mstring;
}

 function sendSMS( $username,$phonenumber, $transid, $domain,$mess,$sender,$mtype)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $mess= removePosion($mess);
 $sender= removePosion($sender);
 $cnt ="";
   

 $query="insert messagesentsingle(transid,username,phonenumber,message,sender,status,domain,dateused) values ('".$transid."','".$username."','".$phonenumber. "','". $mess. "','". $sender. "','0','". $domain. "','".  date('Y-m-d H:i:s')."')";
  
  
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   $cnt = "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			

//$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$





function sendSMSAddressbook( $username,$addressbook, $transid, $domain,$mess,$sender,$mtype,$flag)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

$mess= removePosion($mess);
 $sender= removePosion($sender);
 $cnt ="";
   
 $query="insert messagesentaddressbook(transid,username,bookname,message,sender,status,flag,domain,dateused) values ('".$transid."','".$username."','".$addressbook. "','". $mess. "','". $sender. "','0','".$flag."','". $domain. "','".  date('Y-m-d H:i:s')."')";
  

  
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   $cnt= "-1";
     
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

die();

}			


 function sendSMSscheduleAddress( $username,$addressbook, $transid, $domain,$mess,$sender,$mtype,$datedue,$flag)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}
$mess= removePosion($mess);
 $sender= removePosion($sender);
 $cnt ="";
 //$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 //if (mysqli_connect_errno())
   //{
   // echo mysqli_error($con);
   //echo "-1";
  // die();
  // }

// insert schedule(transid,username,bookname,message,sender,status,domain,messtype,datedue,dateused) values ('38382838','nosa','2348022225545,2348138884002,2347062012965,2348029995545','Test message and billing on new platform','Test','0','247sms.com','1','2014/12/08 00:30','2014/12/07');


 $query="insert schedule(transid,username,bookname,message,sender,status,flag,domain,messtype,datedue,dateused) values ('".$transid."','".$username."','".$addressbook. "','". $mess. "','". $sender. "','0','".$flag."','". $domain. "','2','".$datedue."','".  date('Y-m-d H:i:s')."')";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  echo "Database error please try again";
   mysqli_close($con);
   return "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);
return $cnt;
}

}			


//$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$





//***********************************************
function getUsernamekey( $musername,$pass,$skey,$domain)
{
 include "connect.php";
 $cnt= "0";
 $query ="select * from cellcastlogin where username='". $musername ."' and pass='".$pass."' and skey= password('". $skey ."')";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
//  echo mysqli_error($con);
  //return "Database error please try again";
   mysqli_close($con);
   return "-1";
   exit();
}


while($row = mysqli_fetch_array($result))
{
	$cnt = "1";
	//return $cnt;
}

//echo $cnt;
mysqli_close($con);
return $cnt;
}			





//***********************************************
function getDeliveryStatus($musername,$transid,$domain)
{
 include "connect.php";
 $cnt= "#";
 $query ="select status from messagesent where username='". $musername ."' and transid='".$transid."'  and domain ='". $domain ."'";
 //echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //return "Database error please try again";
   mysqli_close($con);
   return "-1";
   exit();
}


while($row = mysqli_fetch_array($result))
{
	$cnt = $row["status"];
	//return $cnt;

}




if ($cnt =="#"){
   $query ="select status from messagesentbackup where username='". $musername ."' and transid='".$transid."'  and domain ='". $domain ."'";
// echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //return "Database error please try again";
   mysqli_close($con);
   return "-1";
   exit();
}


while($row = mysqli_fetch_array($result))
{
	$cnt =$row["status"] ;
	//return $cnt;
}

}

   



//echo $cnt;
mysqli_close($con);
return $cnt;
}			






 function apilogs( $username, $pass, $phonenumber,$mess, $transid, $domain,$sender,$skey,$response)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="0";

 $mess= removePosion($mess);
 $sender= removePosion($sender);
 $username= removePosion($username);
 $pass= removePosion($pass);


 $query="insert apilogs(transid,username,pass,phonenumber,skey,message,sender,response,domain,dateused) values ('".$transid."','".$username."','".$pass. "','". $phonenumber. "','". $skey. "','". $mess. "','". $sender. "','". $response. "','". $domain. "','".  date('Y-m-d H:i:s')."')";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   $cnt =  "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);

}

return $cnt;
}			


 function apilogs2( $username, $pass, $phonenumber,$productid, $transid, $skey,$response)
{
 include "connect.php";
if ($mtype =="1"){
    $username="system";
}

 $cnt ="0";

 $mess= removePosion($mess);
 $sender= removePosion($sender);
 $username= removePosion($username);
 $pass= removePosion($pass);


 $query="insert apilogs2(transid,username,pass,phonenumber,skey,productID,response) values ('".$transid."','".$username."','".$pass. "','". $phonenumber. "','". $skey. "','". $productid. "','". $response. "')";
  
  
// $query ="select * from userlogin where email='". $memail ."' and domain='". $domain."'";
//echo $query;
if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   $cnt =  "-1";
  
}
else
{
$cnt= "0";
mysqli_close($con);

}

return $cnt;
}			



function ApiNewSub( $transid,$errorCode,$errorMsg,$temp1,$temp2,$temp3,$lowBalance,$amount,$chargigTime,$msisdn,$productId)
{
 include "connect.php";
 
 
$cnt= "1";
 $errorMsg= removePosion($errorMsg);
 $temp1= removePosion($temp1);
 $temp2= removePosion($temp2);
 $temp3= removePosion($temp3);
 $msisdn= removePosion($msisdn);
 $productId= removePosion($productId);

  $sql ="";
   $sql="insert CellCastAPINewSub(transid,errorCode,errorMsg,temp1,temp2,temp3,lowBalance,amount,chargeTime,msisdn,productId) values ('".$transid."','".$errorCode."','".$errorMsg. "','". $temp1. "','". $temp2. "','". $temp3. "','". $lowBalance. "','". $amount. "','". date('Y-m-d H:i:s') ."','".$msisdn. "','". $productId. "')";
 // print_r($sql);
if(!$result= mysqli_query($con,$sql))
{
  //echo mysqli_error($con);
  //echo "Database error please try again";
   mysqli_close($con);
   $cnt =  "-1";
  
}
else
{
$cnt= "1";
mysqli_close($con);

}

return $cnt;
}



?>