<?php

/* <summary>
	 Class contains methods related to state module
	 <author>
	 Beatle Buddy 2017.
	 </author>
	 Version 1.0
   </summary>
*/
 
class include_users
{
	/*
	<summary>
		Default constructor
	</summary>	
	*/
	
	function __CONSTRUCT(){
	
	}
	
	protected function EditReligionData(){
		global $objDB;
			
			$str = $this->pg.".html?v=".$this->v;
			
			if ($this->CheckReligionIsExistOrNot($this->ReligionName) ){
					
			ReturnPostFormData($this->DataArr,$str."&ReligionID=".$this->ReligionID,"Religion is alreay taken, please try again with different Religion !",1);
			exit;
			}
			else
			{	
			
			// UPDATE data into user_info table
			
			$SQL = "UPDATE religion SET
				Religion_Name     = '".AddFieldAddslashes($this->ReligionName)."' ,
				IsActive  = '".AddFieldAddslashes($this->IsActive)."',
				UpdatedDate = '".date('Y-m-d H:i:s')."'
				WHERE ReligionID = ".$this->ReligionID;
				
			$Result = $objDB->sql_query($SQL);
			
			if($Result) {
				return true;
			}else{
				return false;	
			}
			
			}			
		}

	protected function InsertUserInfo(){
		global $objDB;
		
			$str = $this->pg.".html?v=".$this->v;
			
			if ($this->CheckReligionIsExistOrNot($this->ReligionName) ){
						
			// return error error value
			ReturnPostFormData($this->DataArr,$str,"Religion is alreay taken, please try again with different Religion !",1);
			exit;
			}else{
			
		// Insert data into user_info table
		
		 $SQL = "INSERT INTO religion SET
			Religion_Name  = '".AddFieldAddslashes($this->ReligionName)."' ,
			IsActive  = '".AddFieldAddslashes($this->IsActive)."',
			IsDeleted = 'N',
			AddedBy = '".$_SESSION['UserInfo']['UserID']."',
			AddedDate = '".date('Y-m-d H:i:s')."'";
			
			$Result = $objDB->sql_query($SQL);
		 	
		 	if($Result)
		 	{
				return true;
		 	} 
			else
			{
				return false;
			}	 
	
		}
	}  ///// InsertUserInfo completed  /////

	public function fetchOrganization(){
		global $objDB;
		
		//$SQL = "SELECT OrgID,BranchID,IndustryID FROM beatle_userlogin WHERE 1 = 1 AND lower(db_usertype) = '".strtolower($_SESSION['UserInfo']['UType'])."' AND userId = ".$_SESSION['UserInfo']['UserID'];
		//$rsOrg = $objDB->sql_query($SQL);

		$SQL = "SELECT OrgId,db_Orgname FROM beatle_organization WHERE OrgId = ".$_SESSION['OtherInfo']['OrgID'];
		$rsOrgInfo = $objDB->sql_query($SQL);
		return $rsOrgInfo;
	}
	
	public function fetchBranches(){
		global $objDB;
		$SQL = "SELECT db_branchName,branchId FROM beatle_branch WHERE db_branchOrg = ".$_SESSION['OtherInfo']['OrgID'];
		$rsBranches = $objDB->sql_query($SQL);
		return $rsBranches;
	}
	
	public function fetchIndustrys($OrgID,$BranchID,$IndustryID){
		global $objDB;
		
		if(!empty($OrgID)) {
			$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid IN (SELECT GROUP_CONCAT(branchId) FROM beatle_branch WHERE db_branchOrg = ".$OrgID.")";
			$rsBranches = $objDB->sql_query($SQL);
		}else {
			$SQL = "SELECT * FROM beatle_industry WHERE db_bracnchid IN (SELECT GROUP_CONCAT(branchId) FROM beatle_branch WHERE db_branchOrg = ".$_SESSION['OtherInfo']['OrgID'].")";
			$rsBranches = $objDB->sql_query($SQL);
		}
		return $rsBranches;
	}	

	public function FetchAllUsersData($Val=""){
	
		global $objDB;

			$SQL = "SELECT OrgID,BranchID,IndustryID FROM beatle_userlogin WHERE 1 = 1 AND 
			lower(db_usertype) = '".strtolower($_SESSION['UserInfo']['UType'])."' 
			AND userId = ".$_SESSION['UserInfo']['UserID']." 
			AND lower(db_usertype) <> 'end_user' ";
			
			/*
			if(!empty($this->OrgID))
			$SQL .= " AND beatle_survey.orgid = ".$this->OrgID." " ;
			else
			$SQL .= " AND beatle_survey.orgid = ".$_SESSION['OtherInfo']['OrgID']." " ;
			
			if(!empty($this->BranchID))
			$SQL .= " AND beatle_survey.db_surveyBranchid = ".$this->BranchID." " ;
			
			if(!empty($this->IndustryID))
			$SQL .= " AND beatle_survey.db_surveyIndId = ".$this->IndustryID." " ;
			*/
			
			
			$rsOwnerInfo = $objDB->sql_query($SQL);
		
	
		if(strtolower($_SESSION['UserInfo']['UType']) == 'owner') {
			
			//$SQL = "SELECT * FROM beatle_userlogin WHERE OrgID = ".$rsOwnerInfo[0]['OrgID'];
			$SQL = "";
			if(!empty($this->OrgID))
			$SQL .= "SELECT * FROM beatle_userlogin WHERE OrgID = ".$this->OrgID;
			else
			$SQL .= "SELECT * FROM beatle_userlogin WHERE OrgID = ".$rsOwnerInfo[0]['OrgID'];
			
			$SQL .= " AND lower(db_usertype) <> 'end_user' ";

			if(!empty($this->BranchID))
			$SQL .= " AND BranchID = ".$this->BranchID;
			
			if(!empty($this->IndustryID))
			$SQL .= " AND IndustryID = ".$this->IndustryID;			
			$rsUserInfo = $objDB->sql_query($SQL);
			
		}else if(strtolower($_SESSION['UserInfo']['UType']) == 'manager') {

			$SQL = "SELECT * FROM beatle_userlogin WHERE 1 = 1 AND lower(db_usertype) <> 'end_user'";
			
			
			if(!empty($this->OrgID))
			$SQL .= " AND OrgID = ".$this->OrgID;
			else
			$SQL .= " AND OrgID = ".$rsOwnerInfo[0]['OrgID'];
			

			if(!empty($this->BranchID))
			$SQL .= " AND BranchID = ".$this->BranchID;
			else
			$SQL .= " AND  BranchID = ".$rsOwnerInfo[0]['BranchID'];
			
			//echo $SQL;
			//echo "<br />";
			
			$rsUserInfo = $objDB->sql_query($SQL);
		
		}else if(strtolower($_SESSION['UserInfo']['UType']) == 'line_manager') {
			
			//$SQL = "SELECT * FROM beatle_userlogin WHERE OrgID = ".$rsOwnerInfo[0]['OrgID']." AND  BranchID = ".$rsOwnerInfo[0]['BranchID']. " AND  IndustryID = ".$rsOwnerInfo[0]['IndustryID'];;

			$SQL = "SELECT * FROM beatle_userlogin WHERE 1 = 1 AND lower(db_usertype) <> 'end_user'";
			
			if(!empty($this->OrgID))
			$SQL .= " AND OrgID = ".$this->OrgID;
			else
			$SQL .= " AND OrgID = ".$rsOwnerInfo[0]['OrgID'];

			if(!empty($this->BranchID))
			$SQL .= " AND BranchID = ".$this->BranchID;
			else
			$SQL .= " AND  BranchID = ".$rsOwnerInfo[0]['BranchID'];

			if(!empty($this->IndustryID))
			$SQL .= " AND IndustryID = ".$this->IndustryID;
			else
			$SQL .= " AND  IndustryID = ".$rsOwnerInfo[0]['BranchID'];			
						
			$rsUserInfo = $objDB->sql_query($SQL);
		}

		return $rsUserInfo;	
	}
	
	public function FetchOrganizationName($id){
		global $objDB;
		$SQL = "SELECT db_Orgname FROM beatle_organization WHERE OrgId = ".$id;
		$rsOwnerInfo = $objDB->sql_query($SQL);
		return $rsOwnerInfo[0]['db_Orgname'];
	}
	
	public function FetchBranchName($id){
		global $objDB;
		$SQL = "SELECT db_branchName FROM beatle_branch WHERE branchId = ".$id;
		$rsOwnerInfo = $objDB->sql_query($SQL);
		return $rsOwnerInfo[0]['db_branchName'];
	}
	
	public function FetchIndustryName($id){
		global $objDB;
		$SQL = "SELECT db_industry FROM beatle_industry WHERE IndId = ".$id;
		$rsOwnerInfo = $objDB->sql_query($SQL);
		return $rsOwnerInfo[0]['db_industry'];
	}
	
	public function DeletedData($ReligionID){
	
	global $objDB;
	$SQL ="UPDATE religion set IsDeleted='Y' WHERE ReligionID ='".$ReligionID."'";	
	
	//echo $SQL;
	
	$rsInsert=$objDB->sql_query($SQL);
	
		if(count($rsInsert)>0){
			
			return $rsInsert;
		}else{
			return false;
		}
	
	}
	
		public function ChangeReligionStatus(){
		global $objDB;
		
		$SQL =	"UPDATE religion set IsActive = '".$this->status."' WHERE ReligionID ='".$this->ReligionID."'";	
		
		$rsInsert=$objDB->sql_query($SQL);
		
			if(count($rsInsert)){
				
				return $rsInsert;
			
			}else{
				
				return false;
			}
		
	}
	public function CheckReligionIsExistOrNot($ReligionName){
		global $objDB;
		// Select data from user_info to check email is exist or not.
		$SQL = "SELECT * FROM religion WHERE Religion_Name = '".$ReligionName."'";
		
	
		if($this->ReligionID != "" && $this->ReligionID != 0 ){
			$SQL .= " AND ReligionID != ".$this->ReligionID;
		}
		
		// Run query.
		$Result = $objDB->sql_query($SQL);
		
		if(count($Result) > 0 ){
			// Return true if email is exist.
			return true;
			exit;
		}else{
			// Return false if email does not exist.
			return false;
			exit;			
		}
	
	}
}


?>