* @param sql The sql that returns artifact_id
* @return Artifact[] The array of Artifacts
*/
- function getArtifactsFromSQL($sql) {
+ function & getArtifactsFromSQL($sql) {
$artifacts = array();
$result=db_query($sql);
$rows=db_numrows($result);
* getAssignedArtifacts - Get the users's assigned artifacts
* @return Artifact[] The array of Artifacts
*/
- function getAssignedArtifactsByGroup() {
+ function & getAssignedArtifactsByGroup() {
$sql="SELECT * FROM artifact_vw av WHERE av.assigned_to=".$this->User->getID()."
AND av.status_id='1' ORDER BY av.group_artifact_id, av.artifact_id DESC";
return $this->getArtifactsFromSQL($sql);
*
* @return Artifact[] The array of Artifacts
*/
- function getSubmittedArtifactsByGroup() {
+ function & getSubmittedArtifactsByGroup() {
$sql="SELECT *
FROM artifact_vw av
WHERE av.submitted_by=".$this->User->getID()."
$last_group=0;
echo $HTML->boxTop($Language->getText('my', 'assigneditems'));
$artifactsForUser = new ArtifactsForUser(session_get_user());
- $assignedArtifacts = $artifactsForUser->getAssignedArtifactsByGroup();
+ $assignedArtifacts =& $artifactsForUser->getAssignedArtifactsByGroup();
if (count($assignedArtifacts) > 0) {
foreach($assignedArtifacts as $art) {
echo '</td></tr>';
}
echo '
<tr style="background-color:'.html_get_priority_color($art->getPriority()).'">
+ <td width="10%">'.$art->getID().'</td>
<td><a href="/tracker/?func=detail&aid='.
$art->getID().
'&group_id='.$art->ArtifactType->Group->getID().
- '&atid='.$art->ArtifactType->getID().'">'.
- $art->getID().'</td>
- <td>' . $art->getSummary();
+ '&atid='.$art->ArtifactType->getID().'">' . $art->getSummary() . '</a>';
$last_group = $art->ArtifactType->getID();
}
$last_group="0";
echo $HTML->boxMiddle($Language->getText('my', 'submitteditems'),false,false);
- $submittedArtifacts = $artifactsForUser->getSubmittedArtifactsByGroup();
+ $submittedArtifacts =& $artifactsForUser->getSubmittedArtifactsByGroup();
if (count($submittedArtifacts) > 0) {
foreach ($submittedArtifacts as $art) {
echo '</td></tr>';
}
echo '
<tr style="background-color:'.html_get_priority_color($art->getPriority()).'">
- <td>'.$art->getID().'</td>
+ <td width="10%">'.$art->getID().'</td>
<td><a href="/tracker/?func=detail&aid='.
$art->getID().
'&group_id='.$art->ArtifactType->Group->getID().
}
echo '
<tr style="background-color:'.html_get_priority_color($task->getPriority()).'">
+ <td width="10%">'.$task->getID().'</td>
<td><a href="/pm/task.php?func=detailtask&project_task_id='.
$task->getID().
'&group_id='.$group->getID().
- '&group_project_id='.$projectGroup->getID().'">'.
- $task->getID().'</td>
- <td>'.$style_begin.$task->getSummary().$style_end;
+ '&group_project_id='.$projectGroup->getID().'">'.$style_begin.$task->getSummary().$style_end.'</a>';
$last_group = $projectGroup->getID();
}