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/ReportsDao.php          | 87 ++++++++++++++++++++++
 1 file changed, 87 insertions(+)
 create mode 100644 demos/time-tracker/protected/App_Code/Dao/ReportsDao.php

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

diff --git a/demos/time-tracker/protected/App_Code/Dao/ReportsDao.php b/demos/time-tracker/protected/App_Code/Dao/ReportsDao.php
new file mode 100644
index 00000000..50005d06
--- /dev/null
+++ b/demos/time-tracker/protected/App_Code/Dao/ReportsDao.php
@@ -0,0 +1,87 @@
+<?php
+
+class ProjectReport extends TComponent
+{
+	public $ProjectName = '';
+	public $EstimateHours = 0;
+	public $EstimateCompletion = 0;
+	public $Categories;
+	
+	public function __construct()
+	{
+		$this->Categories = new TList;
+	}
+	
+	public function getActualHours()
+	{
+		$total = 0;
+		foreach($this->Categories as $cat)
+			$total += $cat->getActualHours();
+		return $total;
+	}
+}
+
+class CategoryReport extends TComponent
+{
+	public $CategoryName = '';
+	public $EstimateHours = 0;
+	public $members = array();
+	
+	public function getActualHours()
+	{
+		$total = 0;
+		foreach($this->members as $member)
+			$total += $member['hours'];
+		return $total;
+	}	
+}
+
+class UserReport extends TComponent
+{
+	public $Username;
+	public $Projects = array();
+	
+	public function getTotalHours()
+	{
+		$hours = 0;
+		foreach($this->Projects as $project)
+			$hours += $project->Duration;
+		return $hours;
+	}
+}
+
+class UserProjectReport
+{
+	public $ProjectName = '';
+	public $CategoryName = '';
+	public $Duration = 0;
+	public $Description='';
+	public $ReportDate=0;
+}
+
+class ReportsDao extends BaseDao
+{
+	public function getTimeReportsByProjectIDs($projects)
+	{
+		$ids = implode(',', array_map('intval', $projects));
+		$sqlmap = $this->getConnection();
+		return $sqlmap->queryForList('GetTimeReportByProjectIDs', $ids);				
+	}
+	
+	public function getUserProjectTimeReports($users, $projects, $startDate, $endDate)
+	{
+		$sqlmap = $this->getConnection();
+		$driver = $sqlmap->openConnection();
+		$ids = implode(',', array_map('intval', $projects));
+		$usernames = implode(',', array_map(array($driver, 'quote'), $users));
+		
+		$param['projects'] = $ids;
+		$param['members'] = $usernames;
+		$param['startDate'] = intval($startDate);
+		$param['endDate'] = intval($endDate);
+		
+		return $sqlmap->queryForList('GetTimeReportByUsername', $param);
+	}		
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3