<?
	class common_users
	{				
		public function get_details($id)
		{
			global $database;
						
			$db_name = DB_CLIENT_ACCOUNTS;															
			
			$query = "
			SELECT *
			FROM $db_name"."users
			WHERE id = '$id'
			LIMIT 1";
			$results = $database->getRow($query);

			$results['group_name'] = common_ref_global_client::get_group($results['group_id']);

			$results['start_date_nice'] = dates::change_format($results['start_date']);
			$results['birthday_nice'] = dates::change_format($results['birthday']);
			
			$all_departments = common_department::get_all_department();						
			$departments = common_department::get_department_of_user($id);						
			
			$results['department_ids'] = $departments;
			 
			foreach($departments AS $department)
				$results['departments'][] = $all_departments[$department['id']]['name'];
			
			$results = cleanup::filter_empty($results);
						
			return $results;
		}
		
		public function num_active()
		{
			global $database;
					
			$db_name = DB_CLIENT_ACCOUNTS;
			$account_id = $_SESSION['client_info']['id'];
			
			echo $get_contact = "
			SELECT count(id)
			FROM $db_name"."users
			WHERE status = '1' AND account_id = '$account_id'
			";
			$num_users = $database->getOne($get_contact);		
			
			return $num_users;
		}
			
		public function get_users()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_contact = "
			SELECT id,concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1' AND account_id = '$account_id' 
			";
			$results = $database->getAll($get_contact);		
			
			$users = array();
			
			foreach($results AS $result)
				$users[$result['id']] = $result['name'];
			
			return $users;
		}
		
		public function get_users_sort_name()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
		
			$get_contact = "
			SELECT id,concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1'
			ORDER BY name
			";
			$results = $database->getAll($get_contact);		
			
			$users = array();
			
			foreach($results AS $result)
				$users[] = array('id'=>$result['id'],'name'=>$result['name']);
			
			return $users;
		}
		
		public function get_all_users()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$get_all_users = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1'
			";
			$results = $database->getAll($get_all_users);			
			
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;		
		}

		public function get_all_names()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$get_all_users = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1'
			";
			$results = $database->getAll($get_all_users);			
			
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result['name'];
								
			return $final_results;		
		}
		
		public function get_all_names_link()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$get_all_users = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status ='1'
			";
			$results = $database->getAll($get_all_users);			
			
			
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = '<a   class="full_name '.$result['id'].'">'.$result['name'].'</a>';
								
			return $final_results;		
		}

		public function get_all_table_users()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
			$db_client = DB_CLIENT;
			
/*			$get_all_users = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1' AND  tablet = '1'
			ORDER BY name
			";
			$results = $database->getAll($get_all_users);	*/
			
/*			$get_all_users_id_production_installation = "
			SELECT DISTINCT user_id
			FROM $db_client"."departments_users
			WHERE department_id = '2' OR department_id = '4'
			";	
			$users_id_production_installation = $database->getAll($get_all_users_id_production_installation);	*/
			
			/** Kai 13/11/2012*/
			$get_all_users = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1' AND ( id IN ( SELECT DISTINCT user_id
											FROM $db_client"."departments_users
											WHERE department_id = '2' OR department_id = '4' OR department_id='10') 
								OR	tablet ='1') 
								AND group_id IN (35,39,36)
			ORDER BY name
			";
			$results = $database->getAll($get_all_users);

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;		
		}
						
		public function get_all_users_sort_by_name()
		{
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;

			$get_all_users = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE status = '1'
			ORDER BY name
			";
			$results = $database->getAll($get_all_users);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;		
		}
		
		public function get_all_group_user($group_name)
		{					
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
			
			$group_id = common_users::get_group_id($group_name);

			$get_all_auditors = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."users
			WHERE group_id = '$group_id'
			";
			$results = $database->getAll($get_all_auditors);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}
		
		public function get_user_group_id($user_id)
		{	
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
				
			$get_group_id = "
			SELECT group_id
			FROM $db_name"."users
			WHERE id = '$user_id'
			LIMIT 1
			";
			$results = $database->getOne($get_group_id);			
			
			return $results;	
		}
		
		public function get_group_id($group_name)
		{	
			global $database;
			
			$db_name = DB_CLIENT_SETTINGS;
				
			$group_name = ucfirst($group_name);
			
			$get_group_id = "
			SELECT id, name
			FROM $db_name"."groups
			WHERE name = '$group_name'
			LIMIT 1
			";
			$results = $database->getOne($get_group_id);				
			
			return $results;
		}
				
		public function full_name($id)
		{						
			global $database;
					
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$full_name = "
			SELECT CONCAT(first_name,' ' ,last_name)
			FROM $db_name"."users
			WHERE id='$id'
			LIMIT 1";			
			$name = $database->getOne($full_name);			
			
			return '<a   class="full_name '.$id.'">'.$name.'</a>';
		}
		
		public function get_full_name($id)
		{						
			global $database;
					
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$full_name = "
			SELECT CONCAT(first_name,' ' ,last_name)
			FROM $db_name"."users
			WHERE id='$id'
			LIMIT 1";			
			$name = $database->getOne($full_name);			
			
			return $name;
		}
		
		
		public function get_initials($id)
		{						
			global $database;
					
			$db_name = DB_CLIENT_ACCOUNTS;
						
			 $full_name = "
			SELECT concat(ucase(SUBSTRING( first_name, 1, 1 )),'.',ucase(last_name)) as initial
			FROM $db_name"."users
			WHERE id='$id'
			LIMIT 1";									
			$name = $database->getRow($full_name);			
			
			return $name['initial'];
		}	

		public function get_all_initials($link = false)
		{						
			global $database;
			
			
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$sql = "
			SELECT id, concat(ucase(SUBSTRING( first_name, 1, 1 )),'',ucase(SUBSTRING(last_name,1,1))) as name
			FROM $db_name"."users
			WHERE status ='1'
			";									
			$results = $database->getAll($sql);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}							

		public function get_all_initials_links()
		{						
			global $database;
			
			
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$sql = "
			SELECT id, concat(ucase(SUBSTRING( first_name, 1, 1 )),'',ucase(SUBSTRING(last_name,1,1))) as name
			FROM $db_name"."users
			WHERE status ='1'
			";									
			$results = $database->getAll($sql);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = '<a   class="full_name '.$result['id'].'">'.$result['name'].'</a>';
			
			return $final_results;			
		}	
				
		public function get_department_users($context)
		{
			global $database;
			
			$group_id = $context['group_id'];
			$departments = $context['departments'];

			$users = "";
						
			if(count($departments) > 0)
			{
				$ids = "";
				
				foreach($departments AS $dep_key => $department)				
					$ids .= "'".$department."',";
	
				$departments_sql = "AND departments_users.department_id IN (".substr($ids,0,strlen($ids) - 1).")";					

				$get_users = "
				SELECT users.id, concat(ucase(SUBSTRING( users.first_name, 1, 1 )),'',ucase(SUBSTRING(users.last_name,1,1))) as name
				FROM ".DB_CLIENT_ACCOUNTS."users AS users,".DB_CLIENT."departments_users as  departments_users
				WHERE users.group_id = '$group_id' AND departments_users.user_id = users.id $departments_sql
				";
				$users_array = $database->getAll($get_users);												
				
				if(count($users) > 0)
				{
					foreach($users_array AS $user)
						$users .= '<a   class="full_name '.$user['id'].'">'.$user['name'].'</a>'.",  ";					
						
					$users = substr($users,0,strlen($users) - 3);
				}
			}										
									
			return $users;
		}

		public function get_user_company($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$company = "
			SELECT company_id
			FROM $db_name"."users
			WHERE id='$id'
			LIMIT 1";			
			$company_id = $database->getOne($company);			
						
			return $company_id;
		}
				
		public function get_user_location($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$location = "
			SELECT location_id
			FROM $db_name"."users
			WHERE id='$id'
			LIMIT 1";			
			$location_id = $database->getOne($location);			
						
			return $location_id;
		}	
		
		public function get_user_shift($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
			
			$shift = "
			SELECT start_shift_time,
					end_shift_time
			FROM $db_name"."users
			WHERE id='$id'
			LIMIT 1";			
			$shift_time = $database->getRow($shift);			

			return $shift_time;
		}

		public function get_sales_users(){
			global $database;
			
			$db_account = DB_CLIENT_ACCOUNTS;
			$db_settings= DB_CLIENT_SETTINGS;
			$db_client	= DB_CLIENT;
			
			
			$sql= "	SELECT concat(a.first_name,' ',a.last_name) as name,a.id
					FROM ".$db_account."users a
					INNER JOIN ".$db_settings."groups b ON a.group_id = b.id
					INNER JOIN ".$db_client."departments_users c ON a.id = c.user_id
					WHERE c.department_id=1
					AND b.id=36
					AND a.status=1";
			$results = $database->getAll($sql);
			
			return $results;
		}
	}

?>