| |
'.db_result($res,$i,'summary').' |
'.db_result($res,$i,'status_name').' |
'.number_format(db_result($res,$i,'cumulative_hrs'),1).' |
'.number_format((db_result($res,$i,'hours')-db_result($res,$i,'remaining_hrs')),1).' |
'.date($sys_datefmt,db_result($res,$i,'end_date')).' |
';
$task=db_result($res,$i,'project_task_id');
$sql2="SELECT g.group_name, g.group_id, agl.group_artifact_id, agl.name, a.artifact_id, a.summary
FROM project_task_artifact pta, artifact a, artifact_group_list agl, groups g
WHERE pta.project_task_id='$task'
AND pta.artifact_id=a.artifact_id
AND a.group_artifact_id=agl.group_artifact_id
AND agl.group_id=g.group_id";
$res2=db_query($sql2);
if (!$res2 || db_numrows($res2) < 1) {
echo db_error();
} else {
for ($j=0; $j |
';
if ($last_tracker != $tracker) {
$last_tracker = $tracker;
echo $tracker;
} else {
echo ' ';
}
echo ' |
'.db_result($res2,$j,'summary').' |
';
}
$last_tracker='';
}
}
echo '';
}
echo report_footer();
?>