From cbb7a11179b9c1c46e35f04d07d6386a44e400b2 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Sun, 23 Jul 2006 11:11:21 +0000
Subject: Update time-tracker demo and add simple dynamic SQLMap

---
 demos/time-tracker/protected/App_Code/CategoryDao.php |  5 ++++-
 demos/time-tracker/protected/App_Code/ProjectDao.php  | 11 +++++++++--
 2 files changed, 13 insertions(+), 3 deletions(-)

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

diff --git a/demos/time-tracker/protected/App_Code/CategoryDao.php b/demos/time-tracker/protected/App_Code/CategoryDao.php
index f0149f0b..cb1b6399 100644
--- a/demos/time-tracker/protected/App_Code/CategoryDao.php
+++ b/demos/time-tracker/protected/App_Code/CategoryDao.php
@@ -5,7 +5,10 @@ class CategoryDao extends BaseDao
 	function addNewCategory($category)
 	{
 		$sqlmap = $this->getConnection();
-		$sqlmap->insert('AddNewCategory', $category);
+		$exists = $this->getCategoryByNameInProject(
+			$category->Name, $category->ProjectID);
+		if(!$exists)
+			$sqlmap->insert('AddNewCategory', $category);
 	}	
 	
 	function getCategoryByID($categoryID)
diff --git a/demos/time-tracker/protected/App_Code/ProjectDao.php b/demos/time-tracker/protected/App_Code/ProjectDao.php
index 416c6540..0a0771e3 100644
--- a/demos/time-tracker/protected/App_Code/ProjectDao.php
+++ b/demos/time-tracker/protected/App_Code/ProjectDao.php
@@ -62,10 +62,17 @@ class ProjectDao extends BaseDao
 		return $sqlmap->queryForList('GetProjectMembers', $projectID);
 	}
 	
-	public function getAllProjects()
+	public function getAllProjects($sort='', $order='ASC')
 	{
 		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForList('GetAllProjects');	
+		if($sort === '')
+			return $sqlmap->queryForList('GetAllProjects');
+		else
+		{
+			$param['sort'] = $sort;
+			$param['order'] = $order;
+			return $sqlmap->queryForList('GetAllProjectsOrdered', $param);
+		}		
 	}
 	
 	public function getProjectsByManagerName($manager)
-- 
cgit v1.2.3