<?php

/* <summary>
	 Class contains methods related to state module
	 <author>
	 Beatle Buddy 2017.
	 </author>
	 Version 1.0
   </summary>
*/
 
class include_profile
{
	/*
	<summary>
		Default constructor
	</summary>	
	*/
	
	function __CONSTRUCT(){
	
	}
	
	// Method for user verify for login (email and password)
	protected function  VerifyEmailAndPassword(){
		global $objDB;
		// Select query for fetch user data.
		$SQL = "SELECT * FROM user_info WHERE Email = '".$this->Email."' AND Password = '". base64_encode($this->Password)."' ";
		
		// Run query
		$rsResult = $objDB->sql_query($SQL);
		
		// Return data if record found.
		if(count($rsResult) > 0){
			return $rsResult;
		}else{
		// Return false if record does not found.
			return false;
		}
	}
	
	//  Method to fetch all user info.
	public function FetchAllUserInfo(){
		global $objDB;
		$SQL = "SELECT user_info.UserID, user_info.WorkFor, user_info.Gender, user_profile.ProfileID, user_profile.SkillList, user_profile.ProfileTitle, user_detail_info.UserDetailID, user_detail_info.Phone, user_detail_info.Image, user_info.UserName, user_info.FirstName, user_info.LastName, user_info.`Password`, user_info.Email, user_info.IsActive, user_info.IsDeleted, user_info.ActivationCode, user_info.ResetCode, user_info.IsBlocked, user_profile.Description, user_profile.AddedDate, user_profile.EditedDate, user_profile.IsCompleted, user_detail_info.Rating, user_detail_info.Country, user_detail_info.State, user_detail_info.City, user_detail_info.Address1, user_detail_info.Address2, user_detail_info.Address3, user_detail_info.ZipCode, user_detail_info.SecurityQuestions, user_detail_info.SecurityAnswer, user_detail_info.HourlyRate, user_detail_info.IsCompleted FROM user_info LEFT JOIN user_profile ON user_info.UserID = user_profile.UserID LEFT JOIN user_detail_info ON user_info.UserID = user_detail_info.UserID WHERE user_info.UserID = ".$_SESSION['UserInfo']['UserID'];
		$rsUserInfo = $objDB->sql_query($SQL);
		if(count($rsUserInfo) > 0){
			return $rsUserInfo;	
		}else{
			return false;
		}
		
	}
	
	public function FetchAllCountryList(){
		global $objDB;	
		
		$SQL = "SELECT * FROM country_list WHERE IsActive = 'Y' AND IsDeleted = 'N'";
		
		$rsCountry = $objDB->sql_query($SQL);
		if(count($rsCountry) > 0){
			return $rsCountry;	
		}else{
			return false;
		}
		
	}
	
	public function FetchAllStateList($CountryID){
		global $objDB;
		
		$SQL = "SELECT * FROM state_list WHERE CountryID = {$CountryID} AND IsActive = 'Y' AND IsDeleted = 'N'";
		$rsState = $objDB->sql_query($SQL);
		
		if(count($rsState) > 0){
			return $rsState;	
		}else{
			return false;
		}		
		
	}

	public function SelectAllSkillList(){
			echo "xxx";
	}

	public function FetchTimeZoneData(){
		global $objDB;
		
		$SQL = "SELECT * FROM time_zone WHERE IsActive = 'Y' ORDER BY OrderBy";
		$rsTimeZone = $objDB->sql_query($SQL);
		
		if(count($rsTimeZone) > 0){
			return $rsTimeZone;	
		}else{
			return false;
		}		
	}
	
	public function GetRootCategoryList(){
		global $objDB;
		
		$SQL = "SELECT * FROM category_list WHERE IsActive = 'Y' AND IsDeleted = 'N' AND Parent = 0 ORDER BY CatID ASC";
		$rsRootCat = $objDB->sql_query($SQL);
		
		if(count($rsRootCat) > 0){
			return $rsRootCat;	
		}else{
			return false;
		}		
		
	}
	
	public function GetSubCategoryList($CID){
		global $objDB;
		
		$SQL = "SELECT * FROM category_list WHERE IsActive = 'Y' AND IsDeleted = 'N' AND Parent = {$CID} ORDER BY CatID ASC";
		$rsSubCat = $objDB->sql_query($SQL);
		
		if(count($rsSubCat) > 0){
			return $rsSubCat;	
		}else{
			return false;
		}		
	}
	

	public function __DESTRUCT()	{
		global $objDB;
		unset($objDB->objModel);
	}
	

	
	
} ///// class include_login completed  /////
?>