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/ProjectDao.php | 11 +++++++++--
 1 file changed, 9 insertions(+), 2 deletions(-)

(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
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