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

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

diff --git a/demos/time-tracker/protected/App_Code/ReportsDao.php b/demos/time-tracker/protected/App_Code/ReportsDao.php
deleted file mode 100644
index 50005d06..00000000
--- a/demos/time-tracker/protected/App_Code/ReportsDao.php
+++ /dev/null
@@ -1,87 +0,0 @@
-<?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