<?php
if (!defined("LIBUSERINFO_INC")){

	define(LIBUSERINFO_INC,1);

	define(LIBUSERINFO_CAT_ACHETEUR,'ACH');
	define(LIBUSERINFO_CAT_MAGASINIER,'MAG');
	define(LIBUSERINFO_CAT_OTHER,'OTH');


	class UserInfo {
		var $_firstName;
		var $_secondName;
		var $_address;
		var $_accessLevel;
		var $_id;
		var $_site;
		
		function UserInfo($login, $accesslevel, $category, $catid){
			$query="";
			if ($category==LIBUSERINFO_CAT_OTHER){
			} else {
				switch($category){
					case LIBUSERINFO_CAT_ACHETEUR: 				     
						$query="SELECT * FROM Acheteur WHERE ID_ACHETEUR='$catid' "
							."ORDER BY ID_ACHETEUR DESC LIMIT 0,1";
						break;
					case LIBUSERINFO_CAT_MAGASINIER: 
						$query="SELECT * FROM Magasinier WHERE ID_MAGASINIER='$catid' "
							."ORDER BY ID_MAGASINIER DESC LIMIT 0,1";
						break;
					default: break; /* TODO: ERREUR */
				}
				$connexion = @mysql_connect(SQL_SERVER,SQL_USER,SQL_PASSWD); 
				if (!$connexion){
					die("Erreur serveur mysql $connexion");
				} else {
					$result=mysql_db_query(SQL_BASE,$query)
						or die($query.":".mysql_error($connexion));
					  //,$connexion) 
					if (mysql_num_rows($result)>0){
						$row=mysql_fetch_object($result);
						$this->_firstName=$row->nom;
						$this->_secondName=$row->prenom;
						$this->_address=$row->adresse;
						$this->_tel=$row->telephone;
						$this->_fax=$row->fax;
						$this->_site=$row->id_site;
						$this->_accessLevel=$accesslevel;
						$this->_id=$catid;
						/* TODO: remplir l'objet avec les valeurs de la BD */
					} else {
						mysql_error($connexion);
					}
					
					mysql_close($connexion);
				}
			}
		}


		function getFirstName(){
			return $this->_firstName;
		}

		function getSecondName(){
			return $this->_secondName;
		}

		function getID(){
			return $this->_id;
		}

		function getSite(){
			return $this->_site;
		}

		function getAccessLevel(){
			return $this->_accessLevel;
		}
	}


}
?>