1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / MCS_Backup / shubha27Aug / restapi /
Filename : interest-sent-receive.php
back
<?php
require_once "Core/Config.php";
$userid=isset($_POST['userid']) ? $_POST['userid'] : '';
$status=isset($_POST['interest_status']) ? $_POST['interest_status'] : '';

if($userid !="" && $status != "")
{
	if($status=="1")
	{
		$query="select partnerid as id from accept where userid='$userid' order by entrydate desc";
		$selectprofiles=$db->fetch_all("$query");
	}
	elseif($status=="2")
	{
		$query="select userid as id from accept where partnerid='$userid'";
		
		$selectprofiles=$db->fetch_all("$query");
	}
	$num_rows=$db->num_rows($query);
	if($num_rows > 0)
	{
		foreach($selectprofiles as $i => $profile1){
			$pid=$profile1['id'];
			$rawqry = "select * from memberprofile,memberregister where memberprofile.activestatus='0' and memberprofile.userid='$pid' and memberregister.email!='' and memberregister.id=memberprofile.userid "; 
			$rawqry .= "group by memberprofile.userid order by featuredprofile_status desc";
			$profile=$db->fetch("$rawqry");
			$name=$profile['fname'].' '.$profile['lname'];
			$pid=$profile['userid'];
			$profileid=$profile['profileid'];
			$age=$profile['age'];
			$gender=$profile['gender'];
			$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]['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);
	}
	$rest->DispResponse($rawdata);
}
?>