|
box1_top($Language->getText('my', 'assigneditems'));
$sql="SELECT g.group_name,agl.name,agl.group_id,a.group_artifact_id,
a.assigned_to,a.summary,a.artifact_id,a.priority
FROM artifact a, groups g, artifact_group_list agl
WHERE
a.group_artifact_id=agl.group_artifact_id
AND agl.group_id=g.group_id
AND g.status = 'A'
AND a.assigned_to='". user_getid() ."'
AND a.status_id='1'
AND g.status='A'
ORDER BY agl.group_id,a.group_artifact_id,a.assigned_to,a.status_id";
$result=db_query($sql);
$rows=db_numrows($result);
if ($rows > 0) {
for ($i=0; $i < $rows; $i++) {
if (db_result($result,$i,'group_artifact_id') != $last_group) {
echo '
|
| '.
db_result($result,$i,'group_name').' - '.
db_result($result,$i,'name').' |
';
}
echo '
| '.
db_result($result, $i, 'artifact_id').' |
' . stripslashes(db_result($result, $i, 'summary')) . ' |
';
$last_group = db_result($result,$i,'group_artifact_id');
}
} else {
echo '
| '.$Language->getText('my', 'no_tracker_items_assigned').' |
';
echo db_error();
}
$last_group=0;
echo $HTML->box1_middle($Language->getText('my', 'submitteditems'),false,false);
$sql="SELECT g.group_name,agl.name,agl.group_id,a.group_artifact_id,
a.assigned_to,a.summary,a.artifact_id,a.priority
FROM artifact a, groups g, artifact_group_list agl
WHERE
a.group_artifact_id=agl.group_artifact_id
AND agl.group_id=g.group_id
AND g.status = 'A'
AND a.submitted_by='". user_getid() ."'
AND a.status_id='1'
ORDER BY agl.group_id,a.group_artifact_id,a.submitted_by,a.status_id";
$result=db_query($sql);
$rows=db_numrows($result);
if ($rows > 0) {
for ($i=0; $i < $rows; $i++) {
if (db_result($result,$i,'group_artifact_id') != $last_group) {
echo '
| '.
db_result($result,$i,'group_name').' - '.
db_result($result,$i,'name').' |
';
}
echo '
| '.
db_result($result, $i, 'artifact_id').' |
' . stripslashes(db_result($result, $i, 'summary')) . ' |
';
$last_group = db_result($result,$i,'group_artifact_id');
}
} else {
echo '
| '.$Language->getText('my', 'no_tracker_items_submitted').' |
';
echo db_error();
}
/*
Forums that are actively monitored
*/
$last_group=0;
echo $HTML->box1_middle($Language->getText('my', 'monitoredforum'),false,false);
$sql="SELECT groups.group_name,groups.group_id,forum_group_list.group_forum_id,forum_group_list.forum_name ".
"FROM groups,forum_group_list,forum_monitored_forums ".
"WHERE groups.group_id=forum_group_list.group_id AND groups.status ='A' ".
"AND forum_group_list.group_forum_id=forum_monitored_forums.forum_id ".
"AND forum_monitored_forums.user_id='".user_getid()."' ORDER BY group_name DESC";
$result=db_query($sql);
$rows=db_numrows($result);
if (!$result || $rows < 1) {
echo '
| '.$Language->getText('my', 'no_monitored_forums').'
|
';
echo db_error();
} else {
for ($i=0; $i<$rows; $i++) {
if (db_result($result,$i,'group_id') != $last_group) {
echo '
box1_get_alt_row_style($i) .'>| '.
db_result($result,$i,'group_name').' |
';
}
echo '
box1_get_alt_row_style($i) .'> | '.
stripslashes(db_result($result,$i,'forum_name')).' |
';
$last_group=db_result($result,$i,'group_id');
}
}
/*
Filemodules that are actively monitored
*/
$last_group=0;
echo $HTML->box1_middle($Language->getText('my', 'monitoredfile'),false,false);
$sql="SELECT groups.group_name,groups.group_id,frs_package.name,filemodule_monitor.filemodule_id ".
"FROM groups,filemodule_monitor,frs_package ".
"WHERE groups.group_id=frs_package.group_id AND groups.status = 'A' ".
"AND frs_package.package_id=filemodule_monitor.filemodule_id ".
"AND filemodule_monitor.user_id='".user_getid()."' ORDER BY group_name DESC";
$result=db_query($sql);
$rows=db_numrows($result);
if (!$result || $rows < 1) {
echo '
| '.$Language->getText('my', 'no_monitored_filemodules').'
|
';
echo db_error();
} else {
for ($i=0; $i<$rows; $i++) {
if (db_result($result,$i,'group_id') != $last_group) {
echo '
box1_get_alt_row_style($i) .'>| '.
db_result($result,$i,'group_name').' |
';
}
echo '
box1_get_alt_row_style($i) .'> | '.
db_result($result,$i,'name').' |
';
$last_group=db_result($result,$i,'group_id');
}
}
echo $HTML->box1_bottom();
//second column of "my" page
?>
box1_top($Language->getText('my', 'tasks'));
$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='".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";
$result=db_query($sql);
$rows=db_numrows($result);
if ($rows > 0) {
for ($i=0; $i < $rows; $i++) {
/* Deduce summary style */
$style_begin='';
$style_end='';
if (db_result($result,$i,'percent_complete')==100) {
$style_begin='';
$style_end='';
}
if (db_result($result,$i,'group_project_id') != $last_group) {
echo '
| | '.
db_result($result,$i,'group_name').' - '.
db_result($result,$i,'project_name').' |
';
}
echo '
| '.
db_result($result, $i, 'project_task_id').' |
'.$style_begin.stripslashes(db_result($result, $i, 'summary')).$style_end.' |
';
$last_group = db_result($result,$i,'group_project_id');
}
} else {
echo '
| '.$Language->getText('my', 'no_open_tasks').' |
';
echo db_error();
}
/*
DEVELOPER SURVEYS
This needs to be updated manually to display any given survey
*/
$sql="SELECT * from survey_responses ".
"WHERE survey_id='1' AND user_id='".user_getid()."' AND group_id='1'";
$result=db_query($sql);
echo $HTML->box1_middle($Language->getText('my', 'survey'),false,false);
if (db_numrows($result) < 1) {
show_survey(1,1);
} else {
echo '
| You have taken your developer survey |
';
}
/*
* Pending projects and news bytes
*/
$admingroup = group_get_object (1) ;
exit_assert_object($admingroup,'Group');
$perm =& $admingroup->getPermission( session_get_user() );
if ($perm && is_object($perm) && $perm->isAdmin()) {
$sql="SELECT group_name FROM groups where status='P';";
$result=db_query($sql);
$rows=db_numrows($result);
if ($rows) {
echo $HTML->box1_middle('Pending Projects', false, false);
echo "| There ";
echo (($rows!=1)?"are ": "is "). "$rows project";
echo (($rows!=1)?"s":"");
echo " awaiting ";
echo "review. |
";
}
}
$newsgroup = group_get_object ($GLOBALS['sys_news_group']) ;
exit_assert_object($newsgroup,'Group');
$perm =& $newsgroup->getPermission( session_get_user() );
if ($perm && is_object($perm) && $perm->isAdmin()) {
$sql="SELECT * FROM news_bytes WHERE is_approved=0";
$result=db_query($sql);
$rows=db_numrows($result);
if ($rows) {
echo $HTML->box1_middle('Pending News Bytes', false, false);
echo "| There ";
echo (($rows!=1)?"are ": "is "). "$rows news byte";
echo (($rows!=1)?"s":"");
echo " awaiting ";
echo "review. |
";
}
}
/*
Personal bookmarks
*/
echo $HTML->box1_middle($Language->getText('my', 'bookmarks'),false,false);
$result = db_query("SELECT bookmark_url, bookmark_title, bookmark_id from user_bookmarks where ".
"user_id='". user_getid() ."' ORDER BY bookmark_title");
$rows=db_numrows($result);
if (!$result || $rows < 1) {
echo '
| '.$Language->getText('my', 'no_bookmarks').' |
';
echo db_error();
} else {
for ($i=0; $i<$rows; $i++) {
echo '
box1_get_alt_row_style($i) .'>|
|
'.
db_result($result,$i,'bookmark_title') .'
[Edit]';
}
}
/*
PROJECT LIST
*/
echo $HTML->box1_middle($Language->getText('my', 'projects'),false,false);
// Include both groups and foundries; developers should be similarly
// aware of membership in either.
$result = db_query("SELECT groups.group_name,"
. "groups.group_id,"
. "groups.unix_group_name,"
. "groups.status,"
. "groups.type,"
. "user_group.admin_flags "
. "FROM groups,user_group "
. "WHERE groups.group_id=user_group.group_id "
. "AND user_group.user_id='". user_getid() ."' "
. "AND groups.status='A'");
$rows=db_numrows($result);
if (!$result || $rows < 1) {
echo ' |
| '.$Language->getText('my', 'no_projects').' |
';
echo db_error();
} else {
for ($i=0; $i<$rows; $i++) {
$admin_flags = db_result($result, $i, 'admin_flags');
if (stristr($admin_flags, 'A')) {
$img="trash-x.png";
} else {
$img="trash.png";
}
if (db_result($result, $i, 'type')==2) {
$type = 'foundry';
} else {
$type = 'projects';
}
echo '
box1_get_alt_row_style($i) .'>
 |
'. htmlspecialchars(db_result($result,$i,'group_name')) .' |
';
}
}
echo $HTML->box1_bottom();
echo '
| ';
echo show_priority_colors_key();
echo '
|
';
echo site_user_footer(array());
} else {
exit_not_logged_in();
}
?>