*/ echo '<H2>Browse Tasks by</H2> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="6"><FORM ACTION="' . $PHP_SELF . '" METHOD="GET"> <INPUT TYPE="HIDDEN" NAME="group_id" VALUE="' . $group_id . '"> <INPUT TYPE="HIDDEN" NAME="set" VALUE="custom"> <TR><TD><b>Subproject:</b></TD><TD><b>Assigned User:</b></TD><TD><b>Status:</b></TD></TR> <TR><TD>' . pm_show_subprojects_box('group_project_id', $group_id, $group_project_id) . '</TD>' . '<TD><FONT SIZE="-1">' . $tech_box . '</TD><TD><FONT SIZE="-1">' . pm_status_box('_status', $_status, 'Any') . '</TD>' . '<TD><FONT SIZE="-1"><INPUT TYPE="SUBMIT" NAME="SUBMIT" VALUE="Browse"></TD></TR></FORM></TABLE>'; if (db_numrows($result) < 1) { echo ' <H1>No Matching Tasks found</H1> <P> <B>Add tasks using the link above</B>'; echo db_error(); } else { //create a new $set string to be used for next/prev button if ($set == 'custom') { $set .= '&_assigned_to=' . $_assigned_to . '&_status=' . $_status; } /* Now display the tasks in a table with priority colors */ echo ' <br> <H3>' . $message . ' In ' . pm_data_get_group_name($group_project_id) . '</H3>'; pm_show_tasklist($result, $offset, $set); echo '<P>* Denotes overdue tasks'; show_priority_colors_key(); $url = "/pm/task.php?group_id={$group_id}&group_project_id={$group_project_id}&func=browse&set={$set}&order="; echo '<P>Click a column heading to sort by that column, or <A HREF="' . $url . 'priority">Sort by Priority</A>'; } pm_footer(array());
<?php // // SourceForge: Breaking Down the Barriers to Open Source Development // Copyright 1999-2000 (c) The SourceForge Crew // http://sourceforge.net // // $Id: detail_task.php,v 1.2 2003/11/13 11:29:25 helix Exp $ pm_header(array('title' => 'View A Task')); $sql = "SELECT * FROM project_task " . "WHERE project_task_id='{$project_task_id}' AND group_project_id='{$group_project_id}'"; $result = db_query($sql); ?> <H2>View A Task In <?php echo pm_data_get_group_name($group_project_id); ?> </H2> <TABLE BORDER="0" WIDTH="100%"> <TR> <TD><B>Percent Complete:</B> <BR> <?php echo db_result($result, 0, 'percent_complete'); ?> % </TD> <TD><B>Priority:</B> <BR> <?php echo db_result($result, 0, 'priority');
function prepare_task_history_record(&$record) { global $datetime_fmt; /* Prepare the column values in the task history record Input: a row from the project_history database (passed by reference. Output: the same row with values transformed for database */ // replace the modification date field with human readable dates $record['date'] = format_date($datetime_fmt, $record['date']); switch ($record['field_name']) { case 'start_date': case 'end_date': if ($record['old_value'] == 0) { $record['old_value'] = ''; } else { $record['old_value'] = format_date($datetime_fmt, $record['old_value']); } break; case 'summary': case 'details': $record['old_value'] = prepare_textarea($record['old_value']); break; case 'status_id': $record['old_value'] = pm_data_get_status_name($record['old_value']); break; case 'subproject_id': $record['old_value'] = pm_data_get_group_name($record['old_value']); break; case 'percent_complete': $record['old_value'] = $record['old_value'] - 1000; break; default: break; } }