<?php
class serverFunctions
{ 

		  private $db;
		  private $con;
		  

    //put your code here
    // constructor
    function __construct() { 
        require_once 'DB_Connect.php';
        // connecting to database
        $this->db = new DB_Connect();
        $this->con=$this->db->connect();
        // print_r($this->db);
    }
    // destructor
    function __destruct() {
        
    }
    
   function full_copy( $source, $target ) {
    if ( is_dir( $source ) ) {
        @mkdir( $target );
        $d = dir( $source );
        while ( FALSE !== ( $entry = $d->read() ) ) {
            if ( $entry == '.' || $entry == '..' ) {
                continue;
            }
            $Entry = $source . '/' . $entry; 
            if ( is_dir( $Entry ) ) {
                full_copy( $Entry, $target . '/' . $entry );
                continue;
            }
            copy( $Entry, $target . '/' . $entry );
        }

        $d->close();
    }else {
        copy( $source, $target );
    }
}



/*  $DB_SRC_HOST='localhost';
$DB_SRC_USER='root';
$DB_SRC_PASS='';
$DB_SRC_NAME='superAdmin';
$DB_DST_HOST='localhost';
$DB_DST_USER='root';
$DB_DST_PASS='';
$DB_DST_NAME='dateabase2';*/

public function copyDatabase($DB_SRC_NAME,$DB_DST_NAME)
{
$DB_SRC_HOST='localhost';
$DB_SRC_USER='raghu80504822';
$DB_SRC_PASS='5EqjoMZIm2*b';
//$DB_SRC_NAME='superAdmin';
$DB_DST_HOST='localhost';
$DB_DST_USER='raghu80504822';
$DB_DST_PASS='5EqjoMZIm2*b';
// $DB_DST_NAME='dateabase2';

/*********************** GRAB OLD SCHEMA ***********************/
$db1 = new mysqli ($DB_SRC_HOST,$DB_SRC_USER,$DB_SRC_PASS) or die($db1->error);
mysqli_select_db($db1,$DB_SRC_NAME) or die($db1->error);
$result = mysqli_query($db1,"SHOW TABLES;") or die($db1->error);
$buf="set foreign_key_checks = 0;\n";
$constraints='';
while($row = mysqli_fetch_array($result))
{
    $result2 = mysqli_query($db1,"SHOW CREATE TABLE ".$row[0].";") or die($db1->error);
    $res = mysqli_fetch_array($result2);
    if(preg_match("/[ ]*CONSTRAINT[ ]+.*\n/",$res[1],$matches))
    {
        $res[1] = preg_replace("/,\n[ ]*CONSTRAINT[ ]+.*\n/","\n",$res[1]);
        $constraints.="ALTER TABLE ".$row[0]." ADD ".trim($matches[0]).";\n";
    }
    $buf.=$res[1].";\n";
}
$buf.=$constraints;
$buf.="set foreign_key_checks = 1";
/**************** CREATE NEW DB WITH OLD SCHEMA ****************/
$db2 = new mysqli($DB_DST_HOST,$DB_DST_USER,$DB_DST_PASS) or die($db2->error);
//$sql = 'CREATE DATABASE '.$DB_DST_NAME;
//if(!mysqli_query($db2,$sql)) die($db2->error);
mysqli_select_db($db2,$DB_DST_NAME) or die($db2->error);
$queries = explode(';',$buf);
foreach($queries as $query)
{
    if(!mysqli_query($db2,$query)) die($db2->error);
}

    }
    
    
 public function backup_old()
 {
     $res=mysqli_query($this->con,"SELECT * FROM `schools`")or die(mysqli_error($this->con));
     while($data=mysqli_fetch_array($res))
     {
      $dbs_res=mysqli_query($this->con,"SELECT `schoolCode`,`dbFees`,`dbStudent`,`dbLibrary` FROM `schools` WHERE `id` = '$data[id]'")or die(mysqli_error($this->con));   
      while($dbs=mysqli_fetch_array($dbs_res))
      {
          
          
          
          
          
        
        $fees=$dbs['0'].'_dbFees'.'.sql';
         $student=$dbs['0'].'_dbstudent'.'.sql';
          $library=$dbs['0'].'_dblibrary'.'.sql';
          
          mkdir("/home/ek439kzey1c5/public_html/admin/backup/".$dbs['0'], 0700);
        $result=exec("mysqldump $dbs[1] --password=5EqjoMZIm2*b --user=raghu80504822  --single-transaction >/home/ek439kzey1c5/public_html/admin/backup/$dbs[0]/".$fees,$output1);
        $result=exec("mysqldump $dbs[2] --password=5EqjoMZIm2*b --user=raghu80504822  --single-transaction >/home/ek439kzey1c5/public_html/admin/backup/$dbs[0]/".$student,$output2);
        $result=exec("mysqldump $dbs[3] --password=5EqjoMZIm2*b --user=raghu80504822  --single-transaction >/home/ek439kzey1c5/public_html/admin/backup/$dbs[0]/".$library,$output3);
    }
 
     }
 }
 
 public function backup()
 {
     $res=mysqli_query($this->con,"SELECT * FROM `schools` WHERE IsActive=1")or die(mysqli_error($this->con));
     while($data=mysqli_fetch_array($res))
     {
         $fees=$data['schoolCode'].'_dbFees'.'.sql';
         $student=$data['schoolCode'].'_dbstudent'.'.sql';
         $library=$data['schoolCode'].'_dblibrary'.'.sql';
         
         $bkpPath="backup/".$data['schoolCode'];
         mkdir($bkpPath);
         
         $dbpassword=$data['dbPassword'];
         $dbFees=$data['dbFees'];
         $dbUsernameFees=$data['dbUsernameFees'];
         $dbStudent=$data['dbStudent'];
         $dbUsernameStudent=$data['dbUsernameStudent'];
         $dbLibrary=$data['dbLibrary'];
         $dbUsernameLibrary=$data['dbUsernameLibrary'];
         
         
        $result=exec("mysqldump $dbFees --password=$dbpassword --user=$dbUsernameFees  --single-transaction >$bkpPath/".$fees,$output1);
        $result=exec("mysqldump $dbStudent --password=$dbpassword --user=$dbUsernameStudent  --single-transaction >$bkpPath/".$student,$output2);
        $result=exec("mysqldump $dbLibrary --password=$dbpassword --user=$dbUsernameLibrary  --single-transaction >$bkpPath/".$library,$output3);
     }
 }
 
 
 public function count()
 {
     $count_var=0;
     $res=mysqli_query($this->con,"SELECT * FROM `schools`")or die(mysqli_error($this->con));
     while($data=mysqli_fetch_array($res))
     {
        // print_r($data);
      $dbs_res=mysqli_query($this->con,"SELECT `schoolCode`,`dbFees`,`dbStudent`,`dbLibrary` FROM `schools` WHERE `id` = '$data[id]'")or die(mysqli_error($this->con));   
      while($dbs=mysqli_fetch_array($dbs_res))
      {
          if($dbs['dbStudent'] != ""){
            
            $username = "raghu80504822";
            $password = "5EqjoMZIm2*b";   
          $coo = mysqli_connect("localhost", $username,$password, $dbs['dbStudent']);
        $count_res=mysqli_query($coo,"SELECT count(`S_id`) FROM `student_registration`")or die(mysqli_error($coo));  
          $count=mysqli_fetch_array($count_res);
          echo $count_var+=$count['0'];
          echo "<br>";
          }
         
    }
 
     }
 
     echo  $count_var;
 }
 
 
    public function feesSms()
    {
     $count_var=0;
     $res=mysqli_query($this->con,"SELECT * FROM `schools`")or die(mysqli_error($this->con));
     while($data=mysqli_fetch_array($res))
     {
        // print_r($data);
      $dbs_res=mysqli_query($this->con,"SELECT `schoolname`,`schoolCode`,`dbFees`,`smsId`,`smsAPI`,`feesAlertNumbers` FROM `schools` WHERE `id` = '$data[id]'")or die(mysqli_error($this->con));   
      while($dbs=mysqli_fetch_array($dbs_res))
      {
          if($dbs['dbFees'] != ""){
              date_default_timezone_set('Asia/Calcutta'); 
            $today=date("Y-m-d");
            $username = "raghu80504822";
            $password = "5EqjoMZIm2*b";   
            $coo = mysqli_connect("localhost", $username,$password, $dbs['dbFees']);
            $count_res=mysqli_query($coo,"SELECT SUM(`Grand_Total`) as amount FROM `paid_fees` WHERE `Paid_date` = '$today' and `flag` = '1'")or die(mysqli_error($coo));  
            $count=mysqli_fetch_assoc($count_res);
         
          if($count['amount'] != ''){
            echo $dbs['schoolCode']."-".$count['amount']."<br>";
            $message="Today Collected Amount is " . $count['amount'] ." in ". $dbs['schoolname'] ." Thank You..";
            if($count['amount'] != 0){
                
                //echo $dbs['feesAlertNumbers'].$message.$dbs['smsAPI'].$dbs['smsId'];
                $this->message_alert($dbs['feesAlertNumbers'],$message,$dbs['smsAPI'],$dbs['smsId']);
            }
          }
          
          
          }
          
          
    }
 
     }
 }
 

public function message_alert($mobile,$message,$API,$sender)
	{


$url = "https://api-alerts.kaleyra.com/v4/?api_key=$API&method=sms&message=$message&to=$mobile&sender=$sender";

        $fields = array(
            'registration_ids' => $registatoin_ids,
            'data' => $message,
        );

        $headers = array(
            'Authorization: key=' . $API,
            'Content-Type: application/json'
        );
        // Open connection
        $ch = curl_init();

        // Set the url, number of POST vars, POST data
        curl_setopt($ch, CURLOPT_URL, $url);

        curl_setopt($ch, CURLOPT_POST, true);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

        // Disabling SSL Certificate support temporarly
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

        curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($fields));

        // Execute post
        $result = curl_exec($ch);
        if ($result === FALSE) {
            die('Curl failed: ' . curl_error($ch));
        }

        // Close connection
        curl_close($ch);
   // echo $result;
        $resultl=json_decode($result);
      //print_r($resultl);
 	}
    
 
    public function schoolsList()
 {
     $schools=array();
      $res=mysqli_query($this->con,"SELECT * FROM `schools` ORDER BY `schoolname` ASC")or die(mysqli_error($this->con));
     while($data=mysqli_fetch_array($res))
     {
         $id=$data['id'];
         $schools[$id]=$data['schoolname'];
     }
     return $schools;
 }
 
    
    
    

}

?>