+2003-01-07 Tom Copeland <tom@infoether.com>
+
+ * Added "submitted by" info to the task detail view. Modified project_task_vw
+ to include user name and realname from user table.
+
2003-01-06 Richard Offer
* www/include/Layout.class, www/project/showfiles.php: patch #134:
* @return boolean success.
*/
function fetchData($project_task_id) {
- $res=db_query("SELECT * FROM project_task
+ $res=db_query("SELECT * FROM project_task_vw
WHERE project_task_id='$project_task_id'
AND group_project_id='". $this->ProjectGroup->getID() ."'");
if (!$res || db_numrows($res) < 1) {
return $this->data_array['project_task_id'];
}
+ /**
+ * getSubmittedRealName - get the real name of the person who created this task.
+ *
+ * @return string The real name person who created this task.
+ */
+ function getSubmittedRealName() {
+ return $this->data_array['realname'];
+ }
+
+ /**
+ * getSubmittedUnixName - get the unix name of the person who created this task.
+ *
+ * @return string The unix name of the person who created this task.
+ */
+ function getSubmittedUnixName() {
+ return $this->data_array['user_name'];
+ }
+
/**
* getSummary - get the subject/summary of this task.
*
"category_name" text
);
-
-CREATE VIEW "project_task_vw" as SELECT project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.details, project_task.percent_complete, project_task.priority, project_task.hours, project_task.start_date, project_task.end_date, project_task.created_by, project_task.status_id, project_task.category_id, project_category.category_name, project_status.status_name FROM ((project_task FULL JOIN project_category ON ((project_category.category_id = project_task.category_id))) NATURAL JOIN project_status);
-
+CREATE VIEW project_task_vw AS
+SELECT project_task.*,project_category.category_name,project_status.status_name,users.user_name,users.realname
+FROM project_task
+FULL JOIN project_category ON (project_category.category_id=project_task.category_id)
+FULL JOIN users ON (users.user_id=project_task.created_by)
+NATURAL JOIN project_status;
CREATE TABLE "project_task_artifact" (
"project_task_id" integer,
?>
<table border="0" width="100%">
+
+ <tr>
+ <TD><B>Submitted By:</B><br><?php echo $pt->getSubmittedRealName(); ?> (<?php echo $pt->getSubmittedUnixName(); ?>)</TD>
+ </tr>
+
<tr>
<td colspan="2">
<b>Category:</b><br>
<table border="0" width="100%">
+ <tr>
+ <TD><B>Submitted By:</B><br><?php echo $pt->getSubmittedRealName(); ?> (<?php echo $pt->getSubmittedUnixName(); ?>)</TD>
+ </tr>
+
<tr>
<td>
<b>Category:</b><br>
<b>Priority:</b><br>
<?php echo build_priority_select_box('priority',$pt->getPriority()); ?>
</td>
+
+
+
</tr>
<tr>