User.class.php

<?php

/*
 @nom: User
 @auteur: Idleman (idleman@idleman.fr)
 @description:  Classe de gestion des utilisateurs
 */

class User extends MysqlEntity{

	protected $id,$login,$password,$prefixDatabase;
	protected $TABLE_NAME = 'user';
	protected $CLASS_NAME = 'User';
	protected $object_fields = 
	array(
		'id'=>'key',
		'login'=>'string',
		'password'=>'string',
		'prefixDatabase'=>'string'
	);

	function __construct(){
		parent::__construct();
	}

	function setId($id){
		$this->id = $id;
	}

	function exist($login,$password){
		$userManager = new User();
		return $userManager->load(array('login'=>$login,'password'=>User::encrypt($password)));
	}

	function existAuthToken($auth){
		$result = false;
		$userManager = new User();
		$users = $userManager->populate('id');
		foreach($users as $user){
			if(sha1($user->getPassword().$user->getLogin())==$auth) $result = $user;
		}
		return $result;
	}
	
	function getId(){
		return $this->id;
	}

	function getLogin(){
		return $this->login;
	}

	function setLogin($login){
		$this->login = $login;
	}

	function getPassword(){
		return $this->password;
	}

	function setPassword($password){
		$this->password = User::encrypt($password);
	}

	static function encrypt($password){
		return sha1($password);
	}

	function setPrefixDatabase($prefix){
		$this->prefixDatabase = $prefix;
	}

	function getprefixDatabase(){
		return $this->prefixDatabase;
	}
	
	function getUsersCodeSynchro() {
		$objects = array();
		$userManager = new User();
		$users = $userManager->populate('id');
		$query = '';
		$i=false;
		foreach($users as $user){
			$prefixTable = $user->getprefixDatabase();
			if($i){$query.=' UNION ';}else{$i=true;}
			$query.= 'SELECT '.$user->getId().' as id,\''.$user->getLogin().'\' as login, value, (select count(1) from '.$prefixTable.'feed) as nbfeed, (select count(1) from '.$prefixTable.'event WHERE unread=1) as nbunread, (select count(1) from '.$prefixTable.'event) as nbarticle FROM '.$prefixTable.'configuration WHERE `Key`=\'synchronisationCode\'';
		}
		$result = $this->customQuery($query);
		while ($row = mysql_fetch_assoc($result)) {
			$objects[] = $row;
		}
		return $objects;
	}
	
	function getUserByCodeSync ($codeSync) {
		if (isset($codeSync)){
			$objects = array();
			$userManager = new User();
			$objects = $userManager->getUsersCodeSynchro();
			$user = false;
			foreach ($objects as $users) {
				if ($users['value']==$codeSync)
					$user = $userManager->load(array('id'=>$users['id']));
			}
			return $user;
		} else {
			return false;
		}
	}
}

?>