From 623447ffea7a49359c773a0bc3a851397885f319 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Fri, 28 Jul 2006 12:32:01 +0000
Subject: Add sqlite support for time-tracker.

---
 .../protected/App_Code/Dao/UserDao.php             | 165 +++++++++++++++++++++
 1 file changed, 165 insertions(+)
 create mode 100644 demos/time-tracker/protected/App_Code/Dao/UserDao.php

(limited to 'demos/time-tracker/protected/App_Code/Dao/UserDao.php')

diff --git a/demos/time-tracker/protected/App_Code/Dao/UserDao.php b/demos/time-tracker/protected/App_Code/Dao/UserDao.php
new file mode 100644
index 00000000..95a85410
--- /dev/null
+++ b/demos/time-tracker/protected/App_Code/Dao/UserDao.php
@@ -0,0 +1,165 @@
+<?php
+/**
+ * User Dao class file.
+ *
+ * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
+ * @link http://www.pradosoft.com/
+ * @copyright Copyright &copy; 2005-2006 PradoSoft
+ * @license http://www.pradosoft.com/license/
+ * @version $Revision: $  $16/07/2006: $
+ * @package Demos
+ */
+
+/**
+ * UserDao class list, create, find and delete users. 
+ * In addition, it can validate username and password, and update
+ * the user roles. Furthermore, a unique new token can be generated,
+ * this token can be used to perform persistent cookie login.
+ *
+ * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
+ * @version $Revision: $  $16/07/2006: $
+ * @package Demos
+ * @since 3.1
+ */
+class UserDao extends BaseDao
+{
+	/**
+	 * @param string username
+	 * @return TimeTrackerUser find by user name, null if not found or disabled.
+	 */
+	public function getUserByName($username)
+	{
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForObject('GetUserByName', $username);
+	}
+	
+	/**
+	 * @param string username
+	 * @return boolean true if username already exists, false otherwise.
+	 */
+	public function usernameExists($username)
+	{
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForObject('UsernameExists', $username);
+	}
+	
+	/**
+	 * @return array list of all enabled users.
+	 */
+	public function getAllUsers()
+	{
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForList('GetAllUsers');
+	}
+		
+	/**
+	 * @param TimeTrackerUser new user details.
+	 * @param string new user password.
+	 */
+	public function addNewUser($user, $password)
+	{
+		$sqlmap = $this->getConnection();
+		$param['user'] = $user;
+		$param['password'] = md5($password);
+		$sqlmap->insert('AddNewUser', $param);
+		if(count($user->getRoles()) > 0)
+			$this->updateUserRoles($user);
+	}
+	
+	/**
+	 * @param string username to delete
+	 */
+	public function deleteUserByName($username)
+	{
+		$sqlmap = $this->getConnection();
+		$sqlmap->delete('DeleteUserByName', $username);
+	}
+
+	/**
+	 * Updates the user profile details, including user roles.
+	 * @param TimeTrackerUser updated user details.
+	 * @param string new user password, null to avoid updating password.
+	 */
+	public function updateUser($user,$password=null)
+	{
+		$sqlmap = $this->getConnection();
+		if($password !== null)
+		{
+			$param['user'] = $user;
+			$param['password'] = md5($password);
+			$sqlmap->update('UpdateUserDetailsAndPassword', $param);
+		}
+		else
+		{
+			$sqlmap->update('UpdateUserDetails', $user);
+		}
+		$this->updateUserRoles($user);
+	}
+
+	/**
+	 * @param string username to be validated
+	 * @param string matching password
+	 * @return boolean true if the username and password matches.
+	 */
+	public function validateUser($username, $password)
+	{
+		$sqlmap = $this->getConnection();
+		$param['username'] = $username;
+		$param['password'] = md5($password);
+		return $sqlmap->queryForObject('ValidateUser', $param);
+	}
+		
+	/**
+	 * @param string unique persistent session token
+	 * @return TimeTrackerUser user details if valid token, null otherwise.
+	 */
+	public function validateSignon($token)
+	{
+		$sqlmap = $this->getConnection();
+		$sqlmap->update('UpdateSignon', $token);
+		return $sqlmap->queryForObject('ValidateAutoSignon', $token);
+	}
+	
+	/**
+	 * @param TimeTrackerUser user details to generate the token
+	 * @return string unique persistent login token.
+	 */
+	public function createSignonToken($user)
+	{
+		$sqlmap = $this->getConnection();
+		$param['username'] = $user->getName();
+		$param['token'] = md5(microtime().$param['username']);
+		$sqlmap->insert('RegisterAutoSignon', $param);
+		return $param['token'];
+	}
+	
+	/**
+	 * @param TimeTrackerUser deletes all signon token for given user, null to delete all
+	 * tokens.
+	 */
+	public function clearSignonTokens($user=null)
+	{
+		$sqlmap = $this->getConnection();
+		if($user !== null)
+			$sqlmap->delete('DeleteAutoSignon', $user->getName());
+		else
+			$sqlmap->delete('DeleteAllSignon');
+	}
+	
+	/**
+	 * @param TimeTrackerUser user details for updating the assigned roles.
+	 */
+	public function updateUserRoles($user)
+	{
+		$sqlmap = $this->getConnection();
+		$sqlmap->delete('DeleteUserRoles', $user);
+		foreach($user->getRoles() as $role)
+		{
+			$param['username'] = $user->getName();
+			$param['role'] = $role;
+			$sqlmap->update('AddUserRole', $param);
+		}
+	}
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3