require_once('common/include/Error.class');
+function &projectgroup_get_object($group_project_id,$data=false) {
+ global $PROJECTGROUP_OBJ;
+ if (!isset($PROJECTGROUP_OBJ["_".$group_project_id."_"])) {
+ if ($data) {
+ //the db result handle was passed in
+ } else {
+ $res=db_query("SELECT * FROM project_group_list
+ WHERE group_project_id='$group_project_id'");
+
+ if (db_numrows($res) <1 ) {
+ $PROJECTGROUP_OBJ["_".$group_project_id."_"]=false;
+ return false;
+ }
+ $data =& db_fetch_array($res);
+
+ }
+ $Group =& group_get_object($data["group_id"]);
+ $PROJECTGROUP_OBJ["_".$group_project_id."_"]= new ProjectGroup($Group,$group_project_id,$data);
+ }
+
+ return $PROJECTGROUP_OBJ["_".$group_project_id."_"];
+}
+
+
class ProjectGroup extends Error {
/**
require_once('common/include/Error.class');
require_once('common/pm/Validator.class');
+function &projecttask_get_object($project_task_id,$data=false) {
+ global $PROJECTTASK_OBJ;
+ if (!isset($PROJECTTASK_OBJ["_".$project_task_id."_"])) {
+ if ($data) {
+ //the db result handle was passed in
+ } else {
+ echo "NO PT data<br>";
+ $res=db_query("SELECT * FROM project_task_vw
+ WHERE project_task_id='$project_task_id'");
+
+ if (db_numrows($res) <1 ) {
+ $PROJECTTASK_OBJ["_".$project_task_id."_"]=false;
+ return false;
+ }
+ $data =& db_fetch_array($res);
+
+ }
+ $ProjectGroup =& projectgroup_get_object($data["group_project_id"]);
+ $PROJECTTASK_OBJ["_".$project_task_id."_"]= new ProjectTask($ProjectGroup,$project_task_id,$data);
+
+ }
+
+ return $PROJECTTASK_OBJ["_".$project_task_id."_"];
+}
+
+
class ProjectTask extends Error {
/**
$rows=db_numrows($result);
for ($i=0; $i < $rows; $i++) {
- $group_id = db_result($result,$i,'group_id');
- $group_project_id = db_result($result,$i,'group_project_id');
$project_task_id = db_result($result,$i,'project_task_id');
- $Group =& group_get_object($group_id);
- $ProjectGroup =& new ProjectGroup($Group,$group_project_id);
- $task =& new ProjectTask($ProjectGroup,$project_task_id);
+ $arr =& db_fetch_array($result);
+ $task =& projecttask_get_object($project_task_id,$arr);
$tasks[] =& $task;
}
}
function getTasksByGroupProjectName () {
- $sql = "SELECT groups.group_name,project_group_list.project_name,project_group_list.group_id, ".
- "project_task.group_project_id,project_task.priority,project_task.project_task_id,project_task.summary,project_task.percent_complete ".
- "FROM groups,project_group_list,project_task,project_assigned_to ".
- "WHERE project_task.project_task_id=project_assigned_to.project_task_id ".
- "AND project_assigned_to.assigned_to_id='".$this->User->getID()."' AND project_task.status_id='1' ".
- "AND project_group_list.group_id=groups.group_id ".
- "AND project_group_list.group_project_id=project_task.group_project_id AND groups.status = 'A'".
- "ORDER BY group_name,project_name";
+ $sql = "SELECT ptv.*,g.group_name,pgl.project_name
+ FROM project_task_vw ptv,
+ project_assigned_to pat,
+ groups g,
+ project_group_list pgl
+ WHERE ptv.project_task_id=pat.project_task_id
+ AND pgl.group_id=g.group_id
+ AND pgl.group_project_id=ptv.group_project_id
+ AND ptv.status_id=1
+ AND pat.assigned_to_id='".$this->User->getID()."'
+ ORDER BY group_name,project_name";
return $this->getTasksFromSQL($sql);
}
*/
require_once('common/include/Error.class');
+function &artifact_get_object($artifact_id,$data=false) {
+ global $ARTIFACT_OBJ;
+ if (!isset($ARTIFACT_OBJ["_".$artifact_id."_"])) {
+ if ($data) {
+ //the db result handle was passed in
+ } else {
+ $res=db_query("SELECT * FROM artifact_vw
+ WHERE artifact_id='$artifact_id'");
+ if (db_numrows($res) <1 ) {
+ $ARTIFACT_OBJ["_".$artifact_id."_"]=false;
+ return false;
+ }
+ $data =& db_fetch_array($res);
+
+ }
+ $Group =& group_get_object($data["group_id"]);
+ $ArtifactType =& artifactType_get_object($data["group_artifact_id"]);
+ $ARTIFACT_OBJ["_".$artifact_id."_"]= new Artifact($ArtifactType,$data);
+ }
+
+ return $ARTIFACT_OBJ["_".$artifact_id."_"];
+}
+
class Artifact extends Error {
/**
$this->setError('Artifact: No Valid ArtifactType');
return false;
}
+
//did ArtifactType have an error?
if ($ArtifactType->isError()) {
$this->setError('Artifact: '.$ArtifactType->getErrorMessage());
var $ArtifactType;
var $Artifact;
- function ArtifactFromID($id) {
- $res=db_query("SELECT * FROM artifact_vw WHERE artifact_id='$id'");
- if (!$res || db_numrows($res) < 1) {
- $this->setError("Invalid Artifact ID");
- return false;
+ function ArtifactFromID($id, $data = false) {
+ if ($data) {
+ $art_arr =& $data;
} else {
- $art_arr =& db_fetch_array($res);
-
- $res=db_query("SELECT * FROM artifact_group_list
- WHERE group_artifact_id='".$art_arr['group_artifact_id']."'");
-
- $typ_arr =& db_fetch_array($res);
-
- $g =& group_get_object($typ_arr['group_id']);
- $this->Group =& $g;
-
- $at = new ArtifactType($g,$art_arr['group_artifact_id'],$typ_arr);
- if (!$at || !is_object($at)) {
- $this->setError("Could Not Create ArtifactType");
- return false;
- } elseif ($at->isError()) {
- $this->setError($at->getErrorMessage());
+ $res=db_query("SELECT * FROM artifact_vw WHERE artifact_id='$id'");
+ if (!$res || db_numrows($res) < 1) {
+ $this->setError("Invalid Artifact ID");
return false;
+ } else {
+ $art_arr =& db_fetch_array($res);
}
- $this->ArtifactType =& $at;
+ }
- $a = new Artifact($at,$id,$art_arr);
- if (!$a || !is_object($a)) {
- $this->setError("Could Not Create Artifact");
- return false;
- } elseif ($a->isError()) {
- $this->setError($a->getErrorMessage());
- return false;
- }
- $this->Artifact =& $a;
+ $at = artifactType_get_object($art_arr['group_artifact_id']);
+ if (!$at || !is_object($at)) {
+ $this->setError("Could Not Create ArtifactType");
+ return false;
+ } elseif ($at->isError()) {
+ $this->setError($at->getErrorMessage());
+ return false;
+ }
+ $this->ArtifactType =& $at;
+
+ $a = artifact_get_object($id,$art_arr);
+ if (!$a || !is_object($a)) {
+ $this->setError("Could Not Create Artifact");
+ return false;
+ } elseif ($a->isError()) {
+ $this->setError($a->getErrorMessage());
+ return false;
}
+ $this->Artifact =& $a;
return true;
}
*/
require_once('common/include/Error.class');
+function &artifactType_get_object($artType_id,$res=false) {
+ global $ARTIFACTTYPE_OBJ;
+ if (!isset($ARTIFACTTYPE_OBJ["_".$artType_id."_"])) {
+ if ($res) {
+ //the db result handle was passed in
+ } else {
+ $res=db_query("SELECT * FROM artifact_group_list_vw
+ WHERE group_artifact_id='$artType_id'");
+ }
+ if (!$res || db_numrows($res) < 1 ){
+ $ARTIFACTTYPE_OBJ["_".$artType_id."_"]=false;
+ } else {
+ $data =& db_fetch_array($res);
+ $Group =& group_get_object($data["group_id"]);
+ $ARTIFACTTYPE_OBJ["_".$artType_id."_"]= new ArtifactType($Group,$data["group_artifact_id"],$data);
+ }
+ }
+ return $ARTIFACTTYPE_OBJ["_".$artType_id."_"];
+}
+
class ArtifactType extends Error {
/**
}
for ($i=0; $i < $rows; $i++) {
$id = db_result($result,$i,'artifact_id');
- $afi =& new ArtifactFromID($id);
+ $arr = db_fetch_array($result);
+ $afi =& new ArtifactFromID($id,$arr);
if ($afi->isError()) {
$this->setError($afi->getErrorMessage());
+ echo "Error =".$afi->getErrorMessage()."<br>";
} else {
$artifacts[] =& $afi->Artifact;
}
*
*/
function getAssignedArtifactsByGroup() {
- $sql="SELECT a.artifact_id
- FROM artifact a, artifact_group_list agl
- WHERE a.assigned_to=".$this->User->getID()."
- AND a.group_artifact_id=agl.group_artifact_id
- AND a.status_id='1'
- ORDER BY agl.group_id,a.group_artifact_id,a.assigned_to,a.status_id";
+ $sql="SELECT *
+ FROM artifact_vw av
+ WHERE av.assigned_to=".$this->User->getID()."
+ AND av.status_id='1'
+ ORDER BY av.artifact_group_id,
+ av.group_artifact_id,
+ av.assigned_to,
+ av.status_id";
+
return $this->getArtifactsFromSQL($sql);
}
*
*/
function getSubmittedArtifactsByGroup() {
- $sql="SELECT a.artifact_id
- FROM artifact a, artifact_group_list agl
- WHERE a.group_artifact_id=agl.group_artifact_id
- AND a.submitted_by='".$this->User->getID()."'
- AND a.status_id='1'
- ORDER BY agl.group_id,a.group_artifact_id,a.submitted_by,a.status_id";
+ $sql="SELECT *
+ FROM artifact_vw av
+ WHERE av.submitted_by=".$this->User->getID()."
+ AND av.status_id='1'
+ ORDER BY av.artifact_group_id,av.group_artifact_id,av.assigned_to,av.status_id";
+
return $this->getArtifactsFromSQL($sql);
}
if (count($assignedArtifacts) > 0) {
foreach($assignedArtifacts as $art) {
echo '</td></tr>';
- if ($art->ArtifactType->Group->getID() != $last_group) {
+ if ($art->ArtifactType->getID() != $last_group) {
echo '
<tr><td colspan="2"><strong><a href="/tracker/?group_id='.
$art->ArtifactType->Group->getID().'&atid='.
$art->getID().'</td>
<td>' . stripslashes($art->getSummary());
- $last_group = $art->ArtifactType->Group->getID();
+ $last_group = $art->ArtifactType->getID();
}
} else {
echo '
if (count($submittedArtifacts) > 0) {
foreach ($submittedArtifacts as $art) {
echo '</td></tr>';
- if ($art->ArtifactType->Group->getID() != $last_group) {
+ if ($art->ArtifactType->getID() != $last_group) {
echo '
<tr><td colspan="2"><strong><a href="/tracker/?group_id='.
$art->ArtifactType->Group->getID().'&atid='.
$art->getID().'</td>
<td>' . stripslashes($art->getSummary());
- $last_group = $art->ArtifactType->Group->getID();
+ $last_group = $art->ArtifactType->getID();
}
} else {
echo '