
<?
include 'database.php';
class GetCategoryData			// Get category,job Category Table values for all fields
{	
	public function ListcatRecords($catid)   // Caste Table values
	{
		global  $querybuild;
		$column = 'cat_'.language.'name as name';
		$selectalues = array("cat_id","$column");
		$key = language.Site_Nik.'cat_list'.$catid;
		$table = DB_com_name.".category";
		$sqll = $querybuild->build_query($selectalues,$table,'subcat_id',$catid,'looparray','','','','',$key);
		return $sqll;    // return country details
	}
	
	public function CategoryRecords($catid)   // Category Table values respect to language
	{
		
		global  $querybuild;
		$column = 'cat_'.language.'name ';
		$selectalues = array("cat_id","$column");
		$table = DB_com_name.".category";
		$sqll = $querybuild->build_query($selectalues,$table,'cat_id',$catid,'','','','','','');
		return $sqll;    // return country details
	}
	
	public function ListjobcatRecords($catid)   // Caste Table values
	{
		global  $querybuild;
		$column = 'cat_'.language.'name as name';
		$selectalues = array("job_id","$column");
		$key = language.Site_Nik.'jobcat_lists3'.$catid;
		$table = DB_com_name.".jobcategory";
		$sqll = $querybuild->build_query($selectalues,$table,'subcat_id <> 0',NUll,'looparray','','','','',$key);
		return $sqll;    // return country details
	}

	public function JobCategoryRecords($catid)   // JobCategory Table values respect to language
	{
		global  $querybuild;
		$column = 'cat_'.language.'name';
		$selectalues = array("$column");
		$key = language.Site_Nik.'job'.$catid;
		$table = DB_com_name.".jobcategory";
		$sqll = $querybuild->build_query($selectalues,$table,'subcat_id <> 0','','looparray','','','','','');
		return $sqll;    // return country details
	}
}

class Countrydet  
{
	public function sercountry($cntry=null,$stat=null,$cityid=null,$zipc=null)
	{   global $memc,$dbase;
		 
		$sercntry = $memc->get(language.'ser_countrys');      // check if key exists
			
		if($sercntry)
		{	$country_results = $sercntry;          // store memcache results
		}
		else                      			 // if no memcache data
		{ 
			$dbc = $dbase->db_connects();        // Database Connectivity
			$column = language.'_name';

			$sql = "select $column from ".DB_name.".country where ccode='$cntry'";
			$rs = mysqli_query($dbc,$sql);
			$row = mysqli_fetch_array($rs);
			$country_result = $row[0];
				
			$sqls = "select name from ".DB_name.".states where scode='$stat'";
			$rss = mysqli_query($dbc,$sqls);
			$rows = mysqli_fetch_array($rss);
			$state_result = $rows[0];
				
			if($cntry=='97' || $cntry=='188' || $cntry=='189')
				$sqlc = "select City from ".DB_name.".zipcode where cityid='$zipc'";
			else
				$sqlc = "select full_name_nd from ".DB_name.".city where id='$cityid'";
			$rsc = mysqli_query($dbc,$sqlc);
			$rowc = mysqli_fetch_array($rsc);
			$city_result = $rowc[0];
			$country_results = $city_result.', '.$state_result.', '.$country_result;
			$memc->set(language.'ser_countrys',$country_results);   //set key and values for memcache
		}
		return $country_results;    // return country details
	}
}
 
class SearchResultContent        // Search results Content Display fields
{
	public function getSearchContent($vpid,$poto) // Name, photo, 23, Divorced, childrens,Banking Professional,Bachlors,INR.20000,Tamil,5feet,43kgs,Hindu,Iyer,Srilanka,Chennai,Tamilnadu,India,About_me, vp,sr
	{
		global $memc,$dbase;
		 
		 
		$regcntry = $memc->get(Site_Nik.'_ser_resul_'.$vpid);      // check if key exists
		$pid = 'AS2245364';
		if($regcntry)
		{
			$search_result = $regcntry;         // store memcache results
		}
		else
		{
			 
			$dbobj1=new database;
			$dbobj2=$dbobj1->db_connects();  // database connectivity 
			$catres = new GetCategoryData;
			$countrydet = new Countrydet;     // country state city details 
			$uphoto = new Photographs;
			$photo = $uphoto->getUserphotos($pid,$vpid,$poto);  // User photo
				
			$sql = "select * from ".DB_name.".profile as p,".DB_name.".detprofile as d,".DB_name.".photo as ph where p.pro_profileid = '$vpid' and d.dpro_profileid = '$vpid' and ph.ph_profileid = '$vpid'";
			$rs = mysqli_query($dbc,$sql);
			$row = mysqli_fetch_array($rs);
				
			$search_result = array();
				
			$search_result['name'] = $row['dpro_name'];
			$search_result['gender'] = $row['pro_gender'];
			$search_result['age'] = $row['pro_age'].'yrs';
			$search_result['marital'] = $catres->CategoryRecords($row['pro_marital']);
			$living = $row['pro_living']>0?' ('.$catres->CategoryRecords($row['pro_living']).')':'';
			$child = ($row['pro_child']>0)?$row['pro_child'].$living:'';
			$search_result['child'] = $child;
			$search_result['education'] = $catres->CategoryRecords($row['pro_edu']);
			$search_result['occup'] = $catres->JobCategoryRecords($row['pro_occpmain']);
			$search_result['occupation'] = $catres->JobCategoryRecords($row['pro_occp']);
			$abtmestat = $row['dpro_aboutmestat'];
			$search_result['about_self'] = ($abtmestat>0)?'User has modified this section recently. This information will be available within 4 hours.':$row['dpro_aboutme'];
			$search_result['height'] =  $catres->CategoryRecords($row['pro_height']); // 657  5feet 4 inchs
			$search_result['weight'] =  $catres->CategoryRecords($row['pro_weight']);
			$languages= explode(',',$row['dpro_language']);
			$search_result['Mother_langid'] = ($languages[0])?$languages[0]:'';
			$search_result['Mother_language'] = ($languages[0])?$catres->CategoryRecords($languages[0]):'';
			$sec_lang = ($languages[1])?$catres->CategoryRecords($languages[1]):'';
			$thir_lang = ($languages[2])?', '.$catres->CategoryRecords($languages[2]):'';
			$search_result['known_language'] = $sec_lang.$thir_lang;
			$search_result['religion'] = $catres->CategoryRecords($row['pro_religion']);
			$search_result['caste'] = $catres->CategoryRecords($row['pro_caste']);
			$search_result['subcaste'] = $catres->CategoryRecords($row['dpro_caste']);
			$search_result['country'] = $countrydet->sercountry($row['pro_resid'],$row['pro_nstate'],$row['pro_ncity'],$row['pro_zipcode']);
			$incoe = $row['pro_income'];
			if($incoe=='PNS' || $incoe=='')
				$income = 'Prefer Not to Say';
			else if($incoe=='NOT')
				$income = 'Not Applicable';
			else
				$income = $row['pro_currency'].'.'.$row['pro_income'];
				
			$search_result['income'] =$income;
			$search_result['photo'] = $photo;

				
			$memc->set(Site_Nik.'_ser_resul_'.$pid,$search_result);
		}
		return $search_result;
	}
}