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.

---
 .../time-tracker/protected/App_Code/ProjectDao.php | 105 ---------------------
 1 file changed, 105 deletions(-)
 delete mode 100644 demos/time-tracker/protected/App_Code/ProjectDao.php

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

diff --git a/demos/time-tracker/protected/App_Code/ProjectDao.php b/demos/time-tracker/protected/App_Code/ProjectDao.php
deleted file mode 100644
index 0a0771e3..00000000
--- a/demos/time-tracker/protected/App_Code/ProjectDao.php
+++ /dev/null
@@ -1,105 +0,0 @@
-<?php
-/**
- * Project 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
- */
-
-/**
- * Project DAO class.
- *
- * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
- * @version $Revision: $  $16/07/2006: $
- * @package Demos
- * @since 3.1
- */
-class ProjectDao extends BaseDao
-{
-	public function projectNameExists($projectName)
-	{
-		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForObject('ProjectNameExists', $projectName);
-	}
-	
-	public function addNewProject($project)
-	{
-		$sqlmap = $this->getConnection();
-		$sqlmap->insert('CreateNewProject', $project);
-	}
-	
-	public function getProjectByID($projectID)
-	{
-		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForObject('GetProjectByID', $projectID);
-	}
-	
-	public function deleteProject($projectID)
-	{
-		$sqlmap = $this->getConnection();
-		$sqlmap->update('DeleteProject',$projectID);
-	}
-	
-	public function addUserToProject($projectID, $username)
-	{
-		$sqlmap = $this->getConnection();
-		$members = $this->getProjectMembers($projectID);
-		if(!in_array($username, $members))
-		{
-			$param['username'] = $username;
-			$param['project'] = $projectID;
-			$sqlmap->insert('AddUserToProject',$param);
-		} 
-	}
-	
-	public function getProjectMembers($projectID)
-	{
-		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForList('GetProjectMembers', $projectID);
-	}
-	
-	public function getAllProjects($sort='', $order='ASC')
-	{
-		$sqlmap = $this->getConnection();
-		if($sort === '')
-			return $sqlmap->queryForList('GetAllProjects');
-		else
-		{
-			$param['sort'] = $sort;
-			$param['order'] = $order;
-			return $sqlmap->queryForList('GetAllProjectsOrdered', $param);
-		}		
-	}
-	
-	public function getProjectsByManagerName($manager)
-	{
-		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForList('GetProjectsByManagerName', $manager);
-	}
-	
-	public function getProjectsByUserName($username)
-	{
-		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForList('GetProjectsByUserName', $username);
-	}
-	
-	public function removeUserFromProject($projectID, $username)
-	{
-		$sqlmap = $this->getConnection();
-		$param['username'] = $username;
-		$param['project'] = $projectID;
-		$sqlmap->delete('RemoveUserFromProject', $param);
-	}
-	
-	public function updateProject($project)
-	{
-		$sqlmap = $this->getConnection();
-		$sqlmap->update('UpdateProject', $project);
-	}
-}
-
-?>
\ No newline at end of file
-- 
cgit v1.2.3