1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / public_html / shubhamangal.co.in / restapi /
Filename : home.php
back
<?php
require_once "Core/Config.php";

$userid=isset($_POST['userid']) ? $_POST['userid'] : '';
$user_gender=isset($_POST['gender']) ? $_POST['gender'] : '';
$result=array();

if($userid!="")
{
	$userid=$db->escap($userid);
	
	
$prefer=$db->fetch("select * from partnerprofile where userid='$userid'");
//echo "select materialstatus from partnerprofile where userid='$userid'"; exit;
//print_r($prefer);exit;

$gender=$prefer['gender'];
$agefrom=$prefer['age'];
$ageto=$prefer['toage'];
$caste=$prefer['caste'];
$religion=$prefer['religion']; //echo $religion; exit;
$country=$prefer['residencecountry'];
$marital_status=$prefer['materialstatus'];
//$education=$prefer['materialstatus'];
$pro_id=$prefer['profession']; 
$education_id=$prefer['education'];

$rawqry = "select * from memberprofile,memberregister where memberregister.activestatus='0' and memberprofile.userid!='$userid' and memberregister.email!='' and memberregister.id=memberprofile.userid and memberregister.gender!='$user_gender'"; 

if($agefrom!="" && $ageto!="")
		{
			$rawqry .= " and (memberregister.age >='$agefrom' and memberregister.age <= '$ageto')";
		}
		if($religion!="")
		{
		    //$get_religion=$db->fetch("select * from community where community='$religion'");
	       // $religion=$get_religion['id'];
			$rawqry.= " and memberprofile.religion='$religion'";
		}
		if($caste!="")
		{
		    $get_caste=$db->fetch("select * from caste where caste='$caste'");
         	$caste=$get_caste['id'];
			$rawqry.= " and memberprofile.caste='$caste'";
		}
		if($country!="")
		{
		    $getcountry = $db->fetch("select * from `skadate_location_country` where Country_str_name='$country'");
        	$country = $getcountry['Country_str_code'];
			$rawqry .= " and memberprofile.country_residence='$country'";
		}
		if($marital_status!="")
		{ 
			$rawqry.= " and memberprofile.marital_status='$marital_status'";
		}
		
	    if($education_id!="")
 		{
       		$rawqry.= " and FIND_IN_SET(memberprofile.education,'$education_id')";
		}
		
		if($pro_id!="")
		{   
			$rawqry.= " and FIND_IN_SET(memberprofile.educationin,'$pro_id')";
		}
		
		

		
		
		
    $rawqry .= "group by memberprofile.userid order by featuredprofile_status desc";
  // echo $rawqry;
  //exit;
	$nom_rows_matches=$db->num_rows($rawqry);
	$selectprofiles=$db->fetch_all("$rawqry");
	$i=1;
	if($nom_rows_matches > 0)
	{
		foreach($selectprofiles as $i => $profile){
			$name=$profile['fname'].' '.$profile['lname'];
			$pid=$profile['userid'];
			$profileid=$profile['profileid'];
			$age=$profile['age'];
			$maritalstatus=$profile['marital_status'];
			$height=$profile['height'];
			$weight=$profile['weight'];
			$religion=$profile['religion'];
			$get_religion=$db->fetch("select * from community where id='$religion'");
        	$religion=$get_religion['community'];
			$caste=$profile['caste'];
 			$get_caste=$db->fetch("select * from caste where id='$caste'");
         	$caste=$get_caste['caste'];
         	$profession=$profile['occupation'];
         	$getprofession=$db->fetch("SELECT * FROM profession WHERE pro_id='$profession'");
         	$profession=$getprofession['pro_name'];
         	$education=$profile['education'];
         	$geteducation=$db->fetch("SELECT * FROM education WHERE edu_id='$education'");
			$education=$geteducation['edu_name'];
          	$country=$profile['country']; 
          	$getcountry = $db->fetch("select * from `skadate_location_country` where Country_str_code='$country'");
        	$country = $getcountry['Country_str_name'];
			$state=$profile['state'];
			$getstate = $db->fetch("select * from `skadate_location_state` where Admin1_str_code='$state'");
        	$state = $getstate['Admin1_str_name'];
			$city=$profile['city'];
			$photo=$profile['photo'];
			$mail_url1 = "http://$_SERVER[HTTP_HOST]".dirname($_SERVER["PHP_SELF"]) ;
					//	$mail_url =rtrim($mail_url1,"/restapi");
			if($photo != "")
			{
			    $photo="$mail_url/uploads/$photo";
			}
			
			if($photo == "" && $gender= "Female")
			{
			   	$photo="$mail_url/assets/images/avatar_female.png";
			}
			if($photo == "" && $gender= "Male")
			{
			   	$photo="$mail_url/assets/images/avatar_male.png";
			}
			$sql_expCheck1=$db->num_rows("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			$sql_expCheck2=$db->num_rows("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			if(($sql_expCheck1 >0) || ($sql_expCheck2 >0))
			{
			    if($sql_expCheck1 >0)
			    {
			       	$sql_status=$db->fetch("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="1";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			    elseif($sql_expCheck2 >0)
			    {
			        $sql_status=$db->fetch("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="2";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			}
			else{
			    $interest="0"; 
			}


		
			$rawdata[$i]['gender']=$profile['gender'];
			
			$rawdata[$i]['name']=$name;
			$rawdata[$i]['userid']=$pid;
			$rawdata[$i]['profileid']=$profileid;
			$rawdata[$i]['age']=$age;
			$rawdata[$i]['marital_status']=$maritalstatus;
			$rawdata[$i]['height']=$height;
			$rawdata[$i]['religion']=$religion;
			$rawdata[$i]['caste']=$caste;
			$rawdata[$i]['profession']=$profession;
 			$rawdata[$i]['education']=$education;
 			$rawdata[$i]['country']=$country;
 			$rawdata[$i]['state']=$state;
 			$rawdata[$i]['city']=$city;
 			$rawdata[$i]['photo']=$photo;
 			$rawdata[$i]['interest_status']=$interest;
		}
	}
	else{
		$raw=array("Result"=>"No record found");
		$rawdata=array($raw);
	}
	
	
	$query_part =$db->fetch_all("select * from shortlist where shortlist_userid='$userid' and shortlist_status='0'  group by shortlist_partnerid");
					
				$user_ids=array();
				
foreach($query_part as $query_row)
{
$user_ids[]=$query_row['shortlist_partnerid'];
}
$search_ids=implode(',',$user_ids);
				
if($search_ids!='')
{
$search_ids=$search_ids;
}
else
{
$search_ids='0';
}
				
$sql="SELECT * FROM memberregister,memberprofile WHERE memberprofile.userid in ($search_ids) and memberregister.id=memberprofile.userid group by memberprofile.userid";
$shortlist=$db->fetch_all($sql);
$nom_rows_short=$db->num_rows($sql);
	if($nom_rows_short > 0)
	{
		foreach($shortlist as $i => $profile){
			$name=$profile['fname'].' '.$profile['lname'];
			$pid=$profile['userid'];
			$profileid=$profile['profileid'];
			$age=$profile['age'];
			$maritalstatus=$profile['marital_status'];
			$height=$profile['height'];
			$weight=$profile['weight'];
			$religion=$profile['religion'];
			$get_religion=$db->fetch("select * from community where id='$religion'");
        	$religion=$get_religion['community'];
			$caste=$profile['caste'];
 			$get_caste=$db->fetch("select * from caste where id='$caste'");
         	$caste=$get_caste['caste'];
         	$profession=$profile['occupation'];
         	$getprofession=$db->fetch("SELECT * FROM profession WHERE pro_id='$profession'");
         	$profession=$getprofession['pro_name'];
         	$education=$profile['education'];
         	$geteducation=$db->fetch("SELECT * FROM education WHERE edu_id='$education'");
			$education=$geteducation['edu_name'];
          	$country=$profile['country']; 
          	$getcountry = $db->fetch("select * from `skadate_location_country` where Country_str_code='$country'");
        	$country = $getcountry['Country_str_name'];
			$state=$profile['state'];
			$getstate = $db->fetch("select * from `skadate_location_state` where Admin1_str_code='$state'");
        	$state = $getstate['Admin1_str_name'];
			$city=$profile['city'];
			$photo=$profile['photo'];
			$mail_url1 = "http://$_SERVER[HTTP_HOST]".dirname($_SERVER["PHP_SELF"]) ;
						//$mail_url =rtrim($mail_url1,"/restapi");
			if($photo != "")
			{
			    $photo="$mail_url/uploads/$photo";
			}
			
			if($photo == "" && $gender= "Female")
			{
			   	$photo="$mail_url/assets/images/avatar_female.png";
			}
			if($photo == "" && $gender= "Male")
			{
			   	$photo="$mail_url/assets/images/avatar_male.png";
			}
			$sql_expCheck1=$db->num_rows("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			$sql_expCheck2=$db->num_rows("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			if(($sql_expCheck1 >0) || ($sql_expCheck2 >0))
			{
			    if($sql_expCheck1 >0)
			    {
			       	$sql_status=$db->fetch("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="1";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			    elseif($sql_expCheck2 >0)
			    {
			        $sql_status=$db->fetch("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="2";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			}
			else{
			    $interest="0"; 
			}


		
			$short[$i]['gender']=$profile['gender'];
			
			$short[$i]['name']=$name;
			$short[$i]['userid']=$pid;
			$short[$i]['profileid']=$profileid;
			$short[$i]['age']=$age;
			$short[$i]['marital_status']=$maritalstatus;
			$short[$i]['height']=$height;
			$short[$i]['religion']=$religion;
			$short[$i]['caste']=$caste;
			$short[$i]['profession']=$profession;
 			$short[$i]['education']=$education;
 			$short[$i]['country']=$country;
 			$short[$i]['state']=$state;
 			$short[$i]['city']=$city;
 			$short[$i]['photo']=$photo;
 			$short[$i]['interest_status']=$interest;
		}
	}
	else{
		$raw=array("Result"=>"No record found");
		$short=array($raw);
	}
	
	$query_part =$db->fetch_all("select * from membership_count where viewcount_userid='$userid' order by viewcount_date desc limit 4");
	
	$user_ids=array();
				
foreach($query_part as $query_row)
{
$user_ids[]=$query_row['viewcount_partnerid'];
}
$search_ids=implode(',',$user_ids);
				
if($search_ids!='')
{
$search_ids=$search_ids;
}
else
{
$search_ids='0';
}


$sql="SELECT * FROM memberregister,memberprofile WHERE memberprofile.userid in ($search_ids) and memberregister.id=memberprofile.userid group by memberprofile.userid";
$shortlist=$db->fetch_all($sql);
$nom_rows_recent=$db->num_rows($sql);
	if($nom_rows_recent > 0)
	{
		foreach($shortlist as $i => $profile){
			$name=$profile['fname'].' '.$profile['lname'];
			$pid=$profile['userid'];
			$profileid=$profile['profileid'];
			$age=$profile['age'];
			$maritalstatus=$profile['marital_status'];
			$height=$profile['height'];
			$weight=$profile['weight'];
			$religion=$profile['religion'];
			$get_religion=$db->fetch("select * from community where id='$religion'");
        	$religion=$get_religion['community'];
			$caste=$profile['caste'];
 			$get_caste=$db->fetch("select * from caste where id='$caste'");
         	$caste=$get_caste['caste'];
         	$profession=$profile['occupation'];
         	$getprofession=$db->fetch("SELECT * FROM profession WHERE pro_id='$profession'");
         	$profession=$getprofession['pro_name'];
         	$education=$profile['education'];
         	$geteducation=$db->fetch("SELECT * FROM education WHERE edu_id='$education'");
			$education=$geteducation['edu_name'];
          	$country=$profile['country']; 
          	$getcountry = $db->fetch("select * from `skadate_location_country` where Country_str_code='$country'");
        	$country = $getcountry['Country_str_name'];
			$state=$profile['state'];
			$getstate = $db->fetch("select * from `skadate_location_state` where Admin1_str_code='$state'");
        	$state = $getstate['Admin1_str_name'];
			$city=$profile['city'];
			$photo=$profile['photo'];
			$mail_url1 = "http://$_SERVER[HTTP_HOST]".dirname($_SERVER["PHP_SELF"]) ;
					//	$mail_url =rtrim($mail_url1,"/restapi");
			if($photo != "")
			{
			    $photo="$mail_url/uploads/$photo";
			}
			
			if($photo == "" && $gender= "Female")
			{
			   	$photo="$mail_url/assets/images/avatar_female.png";
			}
			if($photo == "" && $gender= "Male")
			{
			   	$photo="$mail_url/assets/images/avatar_male.png";
			}
			$sql_expCheck1=$db->num_rows("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			$sql_expCheck2=$db->num_rows("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			if(($sql_expCheck1 >0) || ($sql_expCheck2 >0))
			{
			    if($sql_expCheck1 >0)
			    {
			       	$sql_status=$db->fetch("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="1";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			    elseif($sql_expCheck2 >0)
			    {
			        $sql_status=$db->fetch("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="2";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			}
			else{
			    $interest="0"; 
			}


		    $recent[$i]['gender']=$profile['gender'];
			
			$recent[$i]['name']=$name;
			$recent[$i]['userid']=$pid;
			$recent[$i]['profileid']=$profileid;
			$recent[$i]['age']=$age;
			$recent[$i]['marital_status']=$maritalstatus;
			$recent[$i]['height']=$height;
			$recent[$i]['religion']=$religion;
			$recent[$i]['caste']=$caste;
			$recent[$i]['profession']=$profession;
 			$recent[$i]['education']=$education;
 			$recent[$i]['country']=$country;
 			$recent[$i]['state']=$state;
 			$recent[$i]['city']=$city;
 			$recent[$i]['photo']=$photo;
 			$recent[$i]['interest_status']=$interest;
		}
	}
	else{
		$raw=array("Result"=>"No record found");
		$recent=array($raw);
	}
	
	
	
$prefer=$db->fetch("select * from memberregister where id='$userid'");
$gender=$prefer['gender'];

$sql1="SELECT * FROM memberregister,memberprofile WHERE memberregister.gender !='$gender' and memberregister.id=memberprofile.userid order by memberregister.id desc limit 10";
$latestlist=$db->fetch_all($sql1);
$nom_rows_latest=$db->num_rows($sql1);
	if($nom_rows_latest > 0)
	{
		foreach($latestlist as $i => $profile){
			$name=$profile['fname'].' '.$profile['lname'];
			$pid=$profile['userid'];
			$profileid=$profile['profileid'];
			$age=$profile['age'];
			$maritalstatus=$profile['marital_status'];
			$height=$profile['height'];
			$weight=$profile['weight'];
			$religion=$profile['religion'];
			$get_religion=$db->fetch("select * from community where id='$religion'");
        	$religion=$get_religion['community'];
			$caste=$profile['caste'];
 			$get_caste=$db->fetch("select * from caste where id='$caste'");
         	$caste=$get_caste['caste'];
         	$profession=$profile['occupation'];
         	$getprofession=$db->fetch("SELECT * FROM profession WHERE pro_id='$profession'");
         	$profession=$getprofession['pro_name'];
         	$education=$profile['education'];
         	$geteducation=$db->fetch("SELECT * FROM education WHERE edu_id='$education'");
			$education=$geteducation['edu_name'];
          	$country=$profile['country']; 
          	$getcountry = $db->fetch("select * from `skadate_location_country` where Country_str_code='$country'");
        	$country = $getcountry['Country_str_name'];
			$state=$profile['state'];
			$getstate = $db->fetch("select * from `skadate_location_state` where Admin1_str_code='$state'");
        	$state = $getstate['Admin1_str_name'];
			$city=$profile['city'];
			$photo=$profile['photo'];
			$mail_url1 = "http://$_SERVER[HTTP_HOST]".dirname($_SERVER["PHP_SELF"]) ;
						//$mail_url =rtrim($mail_url1,"/restapi");
			if($photo != "")
			{
			    $photo="$mail_url/uploads/$photo";
			}
			
			if($photo == "" && $gender= "Female")
			{
			   	$photo="$mail_url/assets/images/avatar_female.png";
			}
			if($photo == "" && $gender= "Male")
			{
			   	$photo="$mail_url/assets/images/avatar_male.png";
			}
			$sql_expCheck1=$db->num_rows("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			$sql_expCheck2=$db->num_rows("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			if(($sql_expCheck1 >0) || ($sql_expCheck2 >0))
			{
			    if($sql_expCheck1 >0)
			    {
			       	$sql_status=$db->fetch("select * from accept  where  userid='$userid' and  partnerid='$pid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="1";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			    elseif($sql_expCheck2 >0)
			    {
			        $sql_status=$db->fetch("select * from accept  where  userid='$pid' and  partnerid='$userid'");
			       	$interest_status=$sql_status['status'];
			       	$interest="2";
			       	if($interest_status == "1")
			       	{
			       	   $interest="3"; 
			       	}
			       		if($interest_status == "2")
			       	{
			       	   $interest="4"; 
			       	}
			    }
			}
			else{
			    $interest="0"; 
			}


		    $latest[$i]['gender']=$profile['gender'];
			
			$latest[$i]['name']=$name;
			$latest[$i]['userid']=$pid;
			$latest[$i]['profileid']=$profileid;
			$latest[$i]['age']=$age;
			$latest[$i]['marital_status']=$maritalstatus;
			$latest[$i]['height']=$height;
			$latest[$i]['religion']=$religion;
			$latest[$i]['caste']=$caste;
			$latest[$i]['profession']=$profession;
 			$latest[$i]['education']=$education;
 			$latest[$i]['country']=$country;
 			$latest[$i]['state']=$state;
 			$latest[$i]['city']=$city;
 			$latest[$i]['photo']=$photo;
 			$latest[$i]['interest_status']=$interest;
		}
	}
	else{
		$raw=array("Result"=>"No record found");
		$latest=array($raw);
	}	
	
	
	$usermember=$db->fetch("select * from upgrademembers where userid='$userid'");
     $current_date = date("Y-m-d");
     $end_date=$usermember['expiredate'];
     $memeber_paystatus = $usermember['paystatus'];
     if($current_date > $end_date and $memeber_paystatus=='1') {
         $plan_status="0";
     }else{
         $plan_status="1";
     }
	
	$details=array("matches"=>$nom_rows_matches,"shortlist"=>$nom_rows_short,"recent"=>$nom_rows_recent,"latest"=>$nom_rows_latest,"plan_status"=>$plan_status);
	
	
	$result[0]['matches']=$rawdata;
	$result[1]['shortlist']=$short;
	$result[2]['recent']=$recent;
	$result[3]['latest']=$latest;
	$result[4]['details']=array($details);
	
	$rest->DispResponse($result);
}

?>