diff options
Diffstat (limited to 'demos/time-tracker/protected/App_Code/UserReportsDao.php')
-rw-r--r-- | demos/time-tracker/protected/App_Code/UserReportsDao.php | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/demos/time-tracker/protected/App_Code/UserReportsDao.php b/demos/time-tracker/protected/App_Code/UserReportsDao.php new file mode 100644 index 00000000..3cf943af --- /dev/null +++ b/demos/time-tracker/protected/App_Code/UserReportsDao.php @@ -0,0 +1,25 @@ +<?php
+
+class UserReportsDao extends BaseDao
+{
+ public function getUserTimeReport($username)
+ {
+ $sqlmap = $this->getConnection();
+ return $sqlmap->queryForObject('GetTimeReportByUsername', $username);
+ }
+
+ public function getTimeReportsByCategoryID($categoryID)
+ {
+ $sqlmap = $this->getConnection();
+ return $sqlmap->queryForList('GetTimeReportByCategoryID', $categoryID);
+ }
+
+ public function getTimeReportsByProjectID($projectID)
+ {
+ $sqlmap = $this->getConnection();
+ return $sqlmap->queryForList('GetTimeReportByProjectID', $projectID);
+ }
+
+}
+
+?>
\ No newline at end of file |