From cbb7a11179b9c1c46e35f04d07d6386a44e400b2 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Sun, 23 Jul 2006 11:11:21 +0000
Subject: Update time-tracker demo and add simple dynamic SQLMap
---
.../protected/App_Code/CategoryDao.php | 5 +-
.../time-tracker/protected/App_Code/ProjectDao.php | 11 +-
.../protected/App_Data/time_tracker.db | Bin 16384 -> 17408 bytes
demos/time-tracker/protected/application.xml | 2 +-
.../pages/TimeTracker/CategoryDataList.php | 94 ++++++++++++
.../pages/TimeTracker/CategoryDataList.tpl | 152 ++++++++++++++++++++
.../protected/pages/TimeTracker/LogTimeEntry.page | 77 ++++++++++
.../protected/pages/TimeTracker/LogTimeEntry.php | 107 ++++++++++++++
.../pages/TimeTracker/ProjectDetails.page | 70 ++++++++-
.../protected/pages/TimeTracker/ProjectDetails.php | 160 ++++++++++++++++++++-
.../protected/pages/TimeTracker/ProjectList.page | 40 +++++-
.../protected/pages/TimeTracker/ProjectList.php | 34 +++++
.../protected/pages/TimeTracker/ReportProject.page | 15 +-
.../protected/pages/TimeTracker/SiteMap.tpl | 2 +-
.../protected/pages/TimeTracker/TimeEntry.page | 4 -
.../protected/pages/TimeTracker/TimeEntryList.php | 89 ++++++++++++
.../protected/pages/TimeTracker/TimeEntryList.tpl | 66 +++++++++
.../protected/pages/TimeTracker/UserList.page | 33 ++---
.../protected/pages/TimeTracker/config.xml | 2 +-
demos/time-tracker/themes/TimeTracker/project.css | 96 +++++++++++--
demos/time-tracker/themes/TimeTracker/site.css | 7 +
.../time-tracker/themes/TimeTracker/time-entry.css | 46 ++++++
22 files changed, 1059 insertions(+), 53 deletions(-)
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/CategoryDataList.php
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/CategoryDataList.tpl
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/LogTimeEntry.page
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/LogTimeEntry.php
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/ProjectList.php
delete mode 100644 demos/time-tracker/protected/pages/TimeTracker/TimeEntry.page
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/TimeEntryList.php
create mode 100644 demos/time-tracker/protected/pages/TimeTracker/TimeEntryList.tpl
create mode 100644 demos/time-tracker/themes/TimeTracker/time-entry.css
(limited to 'demos/time-tracker')
diff --git a/demos/time-tracker/protected/App_Code/CategoryDao.php b/demos/time-tracker/protected/App_Code/CategoryDao.php
index f0149f0b..cb1b6399 100644
--- a/demos/time-tracker/protected/App_Code/CategoryDao.php
+++ b/demos/time-tracker/protected/App_Code/CategoryDao.php
@@ -5,7 +5,10 @@ class CategoryDao extends BaseDao
function addNewCategory($category)
{
$sqlmap = $this->getConnection();
- $sqlmap->insert('AddNewCategory', $category);
+ $exists = $this->getCategoryByNameInProject(
+ $category->Name, $category->ProjectID);
+ if(!$exists)
+ $sqlmap->insert('AddNewCategory', $category);
}
function getCategoryByID($categoryID)
diff --git a/demos/time-tracker/protected/App_Code/ProjectDao.php b/demos/time-tracker/protected/App_Code/ProjectDao.php
index 416c6540..0a0771e3 100644
--- a/demos/time-tracker/protected/App_Code/ProjectDao.php
+++ b/demos/time-tracker/protected/App_Code/ProjectDao.php
@@ -62,10 +62,17 @@ class ProjectDao extends BaseDao
return $sqlmap->queryForList('GetProjectMembers', $projectID);
}
- public function getAllProjects()
+ public function getAllProjects($sort='', $order='ASC')
{
$sqlmap = $this->getConnection();
- return $sqlmap->queryForList('GetAllProjects');
+ if($sort === '')
+ return $sqlmap->queryForList('GetAllProjects');
+ else
+ {
+ $param['sort'] = $sort;
+ $param['order'] = $order;
+ return $sqlmap->queryForList('GetAllProjectsOrdered', $param);
+ }
}
public function getProjectsByManagerName($manager)
diff --git a/demos/time-tracker/protected/App_Data/time_tracker.db b/demos/time-tracker/protected/App_Data/time_tracker.db
index 03fe9156..e7adaec3 100644
Binary files a/demos/time-tracker/protected/App_Data/time_tracker.db and b/demos/time-tracker/protected/App_Data/time_tracker.db differ
diff --git a/demos/time-tracker/protected/application.xml b/demos/time-tracker/protected/application.xml
index e7d3b330..02be327b 100644
--- a/demos/time-tracker/protected/application.xml
+++ b/demos/time-tracker/protected/application.xml
@@ -21,6 +21,6 @@
Category Name | +Abbreviation | +Estimate Duration | ++ |
---|---|---|---|
<%# $this->DataItem->Name %> | +<%# $this->DataItem->Abbreviation %> | +<%# $this->DataItem->EstimateDuration %> | +
+ |
+
+ |
+
+ |
+
+ |
+
+ |
+
+ |
+
+
+ |
+
+
+ |
+
+ |
+