Subversion Repositories ALCASAR

<?php

/*

*/

require_once('mysql.class.php');// the mysql class in already OK!

class radiusMysqlUser

{

	// public properties

	// no public properties

	// private properties

	private $database	= null;

	private $username	= null;

	private $userid		= 0;

	private $userInfos	= Array("Username"=>"","Name"=>"","Mail"=>"","Department"=>"","WorkPhone"=>"","HomePhone"=>"","Mobile"=>"");

	private $checkItems	= Array();

	private $replyItems	= Array();

	//TO DO : init $userInfos, $checkItems and $replyItems fields and operator from config file !!!! URGENT

	// protected properties

	// no protected properties

	// Class constructor

	public function __construct($dbOptions = Array(), $attributeConfig = Array())

	{

		/*

		Db init and config init to do!

		*/

		$this->database = new mysql("127.0.0.1","root","","radius");

	}

	// Class destructor

	public function __destruct()

	{

		//$this->mysql->close();	//is private !

		$this->database = null;

	}

	// public methods

	public static function find($options = Array(), $escape=false)

	{

		$database = new mysql("127.0.0.1","root","","radius");

		/*

		If the options are not xss clean, escape all options string by calling _escapeDatas() method.

		*/

		if ($escape == true) { 

			//$this->_extractArray($options, true); //create variable from $options array and get xss clean for mysql database

			$options = $this->_escapeDatas($options); //create variable from $options array and get xss clean for mysql database

		}

		/*

		The differents $options values are :

		$distinct	-> only distinct response ?

		$username	-> only for this username

		$fields		-> fields to return (default : username)

		$search		-> search value to find

		$search_IN	-> search in this/those field(s)(text or array)

		$limit		-> to limit the resultset

		$offset		-> offset (work with $limit for pagination)

		$sortby		-> sort by x field (default : no sorting)

		$sortdir	-> sort direction (ASC/DESC) (default : no sorting)

		$radius_attr-> radius attribute to find (text or array) if search_IN = radius

		*/

		//mysql_real_escape_string

		$sql = "SELECT ";

		// distinct option

		if ((isset($distinct))&&($distinct=="distinct"))

			$sql .= "DISTINCT ";

		// field option (make sure that the field exist!)

		if ((isset($options['fields']))&&($options['fields']!='')){

			$sql .= $options['fields'].", username ";

		}else{

			$sql .= "username ";

		}

		$sql .= "FROM userinfo ";

		// search option

		if ((isset($options['username']))&&($options['username']!='')){

		}

		// where option

		if ((isset($options['username']))&&($options['username']!=""))

		{

			$sql .= "WHERE username='".$options['username']."'";

			$this->username = $options['username'];

		}

		// sort

		if ((isset($options['sortby']))&&($options['sortby']!='')){

			$sql .= "ORDER BY ".$options['sortby']." ";

			if ((isset($options['sortdir']))&&($options['sortdir']!='')){

				$sql .= "LIMIT ".$options['sortdir']." ";

			}

		}

		// limit / offset

		if ((isset($options['limit']))&&($options['limit']!='')){

			if ((isset($options['offset']))&&($options['offset']!='')){

				$sql .= "LIMIT $offset $limit ";

			} else {

				$sql .= "LIMIT $limit ";

			}

		}

		$sql .= ";";

		// query

		$result = $database->query($sql);

		// return the result values

		return $result;

	}

	public function load($username, $attribute = false) //ok

	{

		/*

		Load an user from mysql database. If $attribute==true, get all chekitems and replyitems attributes too.

		*/

		$sql = "SELECT * FROM userinfo WHERE UserName='$username';";

		$result = $this->database->query($sql);

		if (count($result) != 1) return false;

		$this->userInfos = $result[0];

		if ($attribute === true){

			// get from radcheck table

			$result=null;

			$sql = "SELECT * FROM radcheck WHERE username='$username';";

			$result = $this->database->query($sql);

			if (count($result) != 1) return false;

			$this->checkItems = $result[0];

			// get from radreply table

			$result=null;

			$sql = "SELECT * FROM radreply WHERE username='$username';";

			$result = $this->database->query($sql);

			if (count($result) != 1) return false;

			$this->replyItems = $result[0];

		}

		return true;

	}

	public function add()

	{

		/*

		Add the current user with all his attribute in the mysql database

		(only if the user not already exist)

		*/

		$sql = "";

		//INSERT INTO table (a,b,c) VALUES (1,2,3)

		//INSERT userinfo table (insert)

		$sql = "INSERT INTO userinfo (UserName, Name, Mail, Department, WorkPhone, HomePhone, Mobile) VALUES ()";

		//INSERT radcheck table (insert)

		$sql = "";

		//INSERT radreply table (insert)

		$sql = "";

		//INSERT radusergroup table (insert)

		$sql = "";

		//INSERT radpostauth table (insert)

	}

	public function delete() //ok

	{

		/*

		Delete the current user from the mysql database

		note : this function doesn't delete any accounting record of the current user

		*/

		if ($this->userid == 0) return 0; //0 record deleted

		//can be better with transaction

		$sql1 = "DELETE FROM radreply WHERE username = $this->username ;";

		$sql2 = "DELETE FROM radcheck WHERE username = $this->username ;";

		$sql3 = "DELETE FROM radpostauth WHERE username = $this->username ;";

		$sql4 = "DELETE FROM radusergroup WHERE username = $this->username ;";

		$sql5 = "DELETE FROM userinfo WHERE username = $this->username ;";

		$nb1 = $this->database->exec($sql1);

		$nb2 = $this->database->exec($sql2);

		$nb3 = $this->database->exec($sql3);

		$nb4 = $this->database->exec($sql4);

		$nb5 = $this->database->exec($sql5);

		return ($nb1+$nb2+$nb3+$nb4+$nb5); // n record deleted

	}

	public function update()

	{

		/*

		Update the current user with all his attribute in the mysql database

		(only if the user does not already exist)

		*/

		if ($this->userid == 0) return 0; //0 record deleted

		//UPDATE userinfo table (update)

		//UPDATE radcheck table (update)

		//UPDATE radreply table (update)

		//UPDATE radusergroup table (update)

		//UPDATE radpostauth table (update)

	}

	public function save() //ok

	{

		/*

		insert or Update the current user with all his attribute in the mysql database

		(use add() and update() method)

		*/

		if ($this->userid == 0){

			return $this->add();

		} else {

			return $this->update();

		}

	}

	public function get($userInfo = 'null') //ok

	{

		/*

		return userInfos

		*/

		if (array_key_exists($userInfo, $this->userInfos)){

			return $this->userInfos[$userInfo];

		} else {

			return $this->userInfos;

		}

	}

	public function set($userInfo) //ok

	{

		/*

		Set a value in userInfos

		*/

		if (array_key_exists($userInfo, $this->userInfos)){

			$this->userInfos[$userInfo] = $userInfo;

		}

		if (strtolower($userInfo) == "username") $this->username = $userInfo;

	}

	public function getAttribute($attribute = null)

	{

		/*

		Get a checkItem or replyItem from the user or get the value from the mysql database

		*/

		if (array_key_exists($attribute, $this->userInfos)){

		} elseif (array_key_exists($attribute, $this->checkItems)){

		} elseif (array_key_exists($attribute, $this->replyItems)){

		} else{

		}

	}

	public function setAttribute($attribute)

	{

		/*

		Set a checkItem or replyItem of the user

		*/

	}

	public function checkPassword($pwd)

	{

		//	Check the user password

		//	Return true or false

	}

	public function setPassword($pwd)

	{

		//	Set or change the user password

	}

	// private methods

	private function _escapeDatas($options)

	{

	}

	private function _init($configFile)

	{

	}

	// protected methods

	// no protected method

}

?>