From 5c1132f6da292a689bc52bd7f20a83ff8d733fbd Mon Sep 17 00:00:00 2001
From: wei <>
Date: Wed, 26 Jul 2006 01:44:57 +0000
Subject: Allow nested GroupBy result maps

---
 demos/time-tracker/protected/App_Code/UserReport.php     | 6 +++---
 demos/time-tracker/protected/App_Code/UserReportsDao.php | 5 +++--
 2 files changed, 6 insertions(+), 5 deletions(-)

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

diff --git a/demos/time-tracker/protected/App_Code/UserReport.php b/demos/time-tracker/protected/App_Code/UserReport.php
index e7529120..d37de934 100644
--- a/demos/time-tracker/protected/App_Code/UserReport.php
+++ b/demos/time-tracker/protected/App_Code/UserReport.php
@@ -2,9 +2,9 @@
 
 class UserReport
 {
-	public $Username = '';
-	public $CategoryID = 0;
-	public $ActualDuration = 0.0;	
+	public $CategoryName = '';
+	public $users = array();
+	public $ProjectName = '';
 }
 
 ?>
\ No newline at end of file
diff --git a/demos/time-tracker/protected/App_Code/UserReportsDao.php b/demos/time-tracker/protected/App_Code/UserReportsDao.php
index 3cf943af..c6eab660 100644
--- a/demos/time-tracker/protected/App_Code/UserReportsDao.php
+++ b/demos/time-tracker/protected/App_Code/UserReportsDao.php
@@ -14,10 +14,11 @@ class UserReportsDao extends BaseDao
 		return $sqlmap->queryForList('GetTimeReportByCategoryID', $categoryID);		
 	}
 	
-	public function getTimeReportsByProjectID($projectID)
+	public function getTimeReportsByProjectIDs($projects)
 	{
+		$ids = implode(',', array_map('intval', $projects));
 		$sqlmap = $this->getConnection();
-		return $sqlmap->queryForList('GetTimeReportByProjectID', $projectID);				
+		return $sqlmap->queryForList('GetTimeReportByProjectIDs', $ids);				
 	}
 		
 }
-- 
cgit v1.2.3