Add sqlite support for time-tracker.

1 files changed, 0 insertions, 87 deletions

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