<?php

include "general.php";
include "connect.php";


if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    header('Access-Control-Allow-Origin : *');
    header('Access-Control-Allow-Methods : POST, GET, OPTIONS, PUT, DELETE');
    header('Access-Control-Allow-Headers : *');
    exit;
}


//****************** Function starts


function penpalActiveUsers ( $email,$domain){


    $query ="select email from penpalActiveUsers where email ='$email' and domain ='$domain'";
    $response = getQuery1($query);
    
   

    if($response =="#"){
        //get gender
        $query ="select gender from penpal where email ='$email' and domain ='$domain'";
        $response = getQuery1($query);
        $gender = $response;
       $query ="insert into penpalActiveUsers(email,gender,domain) values ('$email','$gender','$domain')";	
       $queryresponse = updateQuery($query); 
  
    }

    
  }
  
function getUserJSON( $email_friend,$domain)
{
 $query= "select name,country,email,gender,phonenumber,location,profileMessage,birthDate,photo_url1,photo_url2,photo_url3,photo_url4,photo_url5,photo_url6,userType,lastSeen,usertoken,photoUpload,userStatus from penpal where email ='$email_friend' and domain ='$domain' and photoUpload='true' and deleteaccount='0'";
 //echo $query;
 $cnt ="#";

       $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
 if (mysqli_connect_errno())
 {
         // //echo mysqli_error($con);
         //echo "-1";
         return '#';
         die();
 }
 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {
    $photo_number=0;
    $items= [];
   while($row = mysqli_fetch_array($result))
   {
     	if($row[8]  !=""){
        	$photo_number++;
        }

        if($row[9]  !=""){
        	$photo_number++;
        }

 	if($row[10]  !=""){
        	$photo_number++;
        }

 	if($row[11]  !=""){
        	$photo_number++;
        }

 	if($row[12]  !=""){
        	$photo_number++;
        }

 	if($row[13]  !=""){
        	$photo_number++;
        }
       

	
        $items[] = [
       'name' => $row[0],
	'country' => $row[1],	
	'email' =>  $row[2],	
	'gender' => $row[3],
	'phonenumber' => $row[4],
	'location' =>  $row[5],
	'profileMessage' => $row[6],
	'birthDate' => $row[7],
        'photo_url1' =>  $row[8],
        'photo_url2' =>  $row[9],
        'photo_url3' =>  $row[10],
	'photo_url4' =>  $row[11],
	'photo_url5' =>  $row[12],
	'photo_url6' =>  $row[13],
	'photo_number' => $photo_number,
         'userType' => $row[14],
        'lastSeen' =>  $row[15],
        'usertoken' =>$row[16],
        'photoUpload' =>$row[17],
	'userStatus' =>$row[18]
    ];

	

   }
   echo json_encode($items);

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





function getPenpalFriends($email,$gender,$domain){
//check if user has been picked and if so display he to the current user if he likes him 

$query = "select email_u from penpalfriendmatch where  email_f='$email' and response_u='1' and response_f='0' and deleteaccount='0' and domain='$domain' limit 1";
//echo $query;

//die();
$response = getQuery1($query);


  
//echo $response;

if ($response !="#"){
    //return "fopagan@gmail.com";
   //echo "Nosa ksksks ****";
  return $response; 
   exit();

}






//check penpalactiveusers



if (($email !="") && ($gender != "")){
  $lastSearchID = "";
 //get user's last search 

$query ="select lastsearchID from  penpalActiveUserssearch where email = '$email' and gender ='$gender' and domain ='$domain'";
//echo $query;
//die();

  $resSearch = getQuery1($query);
  if ($resSearch =="#"){

           
              $lastSearchID = "1";
              $query ="select sn from penpalActiveUsers where gender ='$gender' and domain ='$domain'  order by sn desc limit 1";
              $totalRecord = getQuery1($query);

  }else{

       //get the total records
       $query ="select sn from penpalActiveUsers where gender ='$gender' and domain ='$domain'  order by sn desc limit 1";
       //echo $query;
       //die();

       $totalRecord = getQuery1($query);

     if (($resSearch+1) < $totalRecord){
      // echo "nosa";
     $lastSearchID = $resSearch+1;
     }else{
       //echo "moses";
       //end of record reached pls check penpal for new records
       $lastSearchID =  $totalRecord;
     }

  }

//die();
  
  
while( $lastSearchID <  $totalRecord) {
      //echo "lastSearchID ". $lastSearchID;
      //echo "totalRecord ".  $totalRecord;

      //$query ="select sn,uid from penpalprofile where uid !='$email' and gender ='$gender'and sn >$sn order by sn asc limit 1";    

      $query = "select sn, email from penpalActiveUsers where email  != '$email' and gender ='$gender' and sn >= $lastSearchID and domain ='$domain'  and deleteaccount='0' order by sn  limit 1";
     
      //echo $query;
      //die();
      $response = getQuery2($query);
      
      if($response !="#"){
          $splitResponse = explode(",", $response);
          $nextSN = $splitResponse[0];
          $frdEmail = $splitResponse[1];
      
          //check if email is in the friendlist
          $query ="select email_f from penpalFriends where email_u='$email' and email_f='$frdEmail' and domain ='$domain' and deleteaccount='0'";
          $queryFriend = getQuery2($query);
          if($queryFriend=="#"){
              
             //update 
             //updateQuery("update penpalprofile set last_sn ='$nextSN' where uid ='$email'");
            // $query=  "select lastsearchID from penpallastsearch where email = '$email' and gender ='$gender'
            if ($resSearch=="#"){
               //echo "james";
                  $query ="Insert into  penpalActiveUserssearch( email,gender, lastsearchID,domain) values ('$email','$gender','$nextSN','$domain')";   
            }else{
              //echo "nosa";
               $query = "update  penpalActiveUserssearch set lastsearchID ='$nextSN' where email = '$email' and gender ='$gender' and domain ='$domain'";
            }
            $updateResponse = updateQuery($query);
            return $frdEmail; 
              
          
          }else{
           
            $lastSearchID++;
            
            }//
      
      }else{
          //no record found  . Move record to last point
         
         // $query = "update  penpalActiveUserssearch set lastsearchID ='$lastSearchID' where email = '$email' and gender ='$gender' and domain ='$domain'";
         // $updateResponse = updateQuery($query);
          //echo "#";

	 $lastSearchID =  $totalRecord+1;

        
      }
  
} ;//end of while
}

//echo "last record";
//die();



// check penpal for any pal.



if (($email !="") && ($gender != "")){
    $lastSearchID = "";
   //get user's last search 

  $query ="select lastsearchID from penpallastsearch where email = '$email' and gender ='$gender' and domain ='$domain'";

  
    $resSearch = getQuery1($query);
    if ($resSearch =="#"){

              //get the total records
    		$query ="select sn from penpal where gender ='$gender' and domain ='$domain' and photoUpload='true' order by sn  desc limit 1";
    		$totalRecord = getQuery1($query);
                $lastSearchID = $totalRecord;
 
    }else{
       if (($resSearch-1) > 0){
       $lastSearchID = $resSearch-1;
     //  echo "yes";
       }else{
          $query ="select sn from penpal where gender ='$gender' and domain ='$domain' and photoUpload='true'  order by sn  desc limit 1";
       // echo "no";
    		$totalRecord = getQuery1($query);
                $lastSearchID = $totalRecord;
       }
       
      
    }


  //echo "am here";
 // die();  
   // $cnt=0;
do {
     //$cnt++;
        //$query ="select sn,uid from penpalprofile where uid !='$email' and gender ='$gender'and sn >$sn order by sn asc limit 1";    

        $query = "select sn, email from penpal where email  != '$email' and gender ='$gender' and sn <= $lastSearchID and domain ='$domain' and photoUpload='true' and deleteaccount='0' order by sn desc limit 1";
         
        $response = getQuery2($query);
        
        if($response !="#"){
            $splitResponse = explode(",", $response);
            $nextSN = $splitResponse[0];
            $frdEmail = $splitResponse[1];
        
            //check if email is in the friendlist
            $query ="select email_f from penpalFriends where email_u='$email' and email_f='$frdEmail' and domain ='$domain' and deleteaccount='0'";
           
            $queryFriend = getQuery2($query);
            if($queryFriend=="#"){
                
               //update 
               //updateQuery("update penpalprofile set last_sn ='$nextSN' where uid ='$email'");
              // $query=  "select lastsearchID from penpallastsearch where email = '$email' and gender ='$gender'
              if ($resSearch=="#"){
                 //echo "james";
                $query ="Insert into penpallastsearch( email,gender, lastsearchID,domain) values ('$email','$gender','$nextSN','$domain')";   
                //echo $query;
	              }else{
                //echo "nosa";
		                 $query = "update penpallastsearch set lastsearchID ='$nextSN' where email = '$email' and gender ='$gender' and domain ='$domain'";
               // echo $query;    
            		}
	              $updateResponse = updateQuery($query);
               // echo $updateResponse;
                return $frdEmail; 
                
                exit();
            }else{
             
              $lastSearchID--;
              
            // if($cnt >1500){
              //echo "am here ". $lastSearchID;
             // die();
            // }
              
              
              
            }//
        
        }else{

         // echo "am here ". $lastSearchID;
           //   die();
            //no record found  . Move record to last point
             $query ="select sn from penpal where gender ='$gender' and domain ='$domain' and photoUpload='true' and deleteaccount='0' order by sn  desc limit 1";
    		$totalRecord = getQuery1($query);
                $lastSearchID = $totalRecord;

            //echo "#";
            //exit();
        }
    
} while ( $lastSearchID >= 1);

echo "#";

}



}
//********************** Function ends

date_default_timezone_set('Africa/Lagos'); 

//$response = array();

$gender =$_POST["genderSearch"];
$email=$_POST["email"];
$domain =$_POST["domain"];




$tempfilename = time() . '_' .  uniqid(rand(), true);
$tempfilename = str_replace('.', '1', $tempfilename);

$query = "insert into penpalcrashlogs (email,logID) values ('$email','$tempfilename')";
$updateResponse = updateQuery($query);



penpalActiveUsers($email,$domain);

$end_date = date("Y-m-d H:i:s");  
$query = "update penpalcrashlogs set end_date1= '$end_date' where logID ='$tempfilename'";
$updateResponse = updateQuery($query);

$friendemail=getPenpalFriends($email,$gender,$domain);

$end_date = date("Y-m-d H:i:s");  
$query = "update penpalcrashlogs set end_date2= '$end_date' where logID ='$tempfilename'";
$updateResponse = updateQuery($query);

//echo "outside" . $friendemail;
getUserJSON ($friendemail,$domain);

$end_date = date("Y-m-d H:i:s");  
$query = "update penpalcrashlogs set end_date3= '$end_date' where logID ='$tempfilename'";
$updateResponse = updateQuery($query);


?>