</TR> <TR> <TD> <B>Hours:</B> <BR> <?php echo db_result($result, 0, 'hours'); ?> </TD> <TD> <B>Status:</B> <BR> <?php echo pm_data_get_status_name(db_result($result, 0, 'status_id')); ?> </TD> </TR> <TR> <TD COLSPAN="2"> <?php echo pm_show_dependent_tasks($project_task_id, $group_id, $group_project_id); ?> </TD> </TR> <TR> <TD COLSPAN="2"> <?php
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;
}
}
}
//if assigned to selected, and more to where clause
if ($_assigned_to) {
$assigned_str = "AND project_assigned_to.assigned_to_id='{$_assigned_to}'";
//workaround for old tasks that do not have anyone assigned to them
//should not be needed for tasks created/updated after may, 2000
$assigned_str2 = ',project_assigned_to';
$assigned_str3 = 'project_task.project_task_id=project_assigned_to.project_task_id AND';
} else {
//no assigned to was chosen, so don't add it to where clause
$assigned_str = '';
}
//build page title to make bookmarking easier
//if a user was selected, add the user_name to the title
//same for status
pm_header(array('title' => 'Browse Tasks' . ($_assigned_to ? ' For: ' . user_getname($_assigned_to) : '') . ($_status && $_status != 100 ? ' By Status: ' . pm_data_get_status_name($_status) : '')));
$sql = "SELECT project_task.priority,project_task.group_project_id,project_task.project_task_id," . "project_task.start_date,project_task.end_date,project_task.percent_complete,project_task.summary " . "FROM project_task {$assigned_str2} " . "WHERE {$assigned_str3} project_task.group_project_id='{$group_project_id}' " . " {$assigned_str} {$status_str} " . $order_by;
$message = "Browsing Custom Task List";
$result = db_query($sql, 51, $offset);
/*
creating a custom technician box which includes "any" and "unassigned"
*/
$res_tech = pm_data_get_technicians($group_id);
$tech_id_arr = util_result_column_to_array($res_tech, 0);
$tech_id_arr[] = '0';
//this will be the 'any' row
$tech_name_arr = util_result_column_to_array($res_tech, 1);
$tech_name_arr[] = 'Any';
$tech_box = html_build_select_box_from_arrays($tech_id_arr, $tech_name_arr, '_assigned_to', $_assigned_to, true, 'Unassigned');
/*
Show the new pop-up boxes to select assigned to and/or status
function pm_show_task_history($project_task_id)
{
/*
show the project_history rows that are
relevant to this project_task_id, excluding details
*/
global $sys_datefmt;
$sql = "select project_history.field_name,project_history.old_value,project_history.date,users.user_name " . "FROM project_history,users " . "WHERE project_history.mod_by=users.user_id AND " . "project_history.field_name <> 'details' AND project_task_id='{$project_task_id}' ORDER BY project_history.date DESC";
$result = db_query($sql);
$rows = db_numrows($result);
if ($rows > 0) {
echo '
<H3>Task Change History</H3>
<P>';
$title_arr = array();
$title_arr[] = 'Field';
$title_arr[] = 'Old Value';
$title_arr[] = 'Date';
$title_arr[] = 'By';
echo html_build_list_table_top($title_arr);
for ($i = 0; $i < $rows; $i++) {
$field = db_result($result, $i, 'field_name');
echo '
<TR BGCOLOR="' . html_get_alt_row_color($i) . '"><TD>' . $field . '</TD><TD>';
if ($field == 'status_id') {
echo pm_data_get_status_name(db_result($result, $i, 'old_value'));
} else {
if ($field == 'start_date') {
echo date('Y-m-d', db_result($result, $i, 'old_value'));
} else {
if ($field == 'end_date') {
echo date('Y-m-d', db_result($result, $i, 'old_value'));
} else {
echo db_result($result, $i, 'old_value');
}
}
}
echo '</TD>
<TD>' . date($sys_datefmt, db_result($result, $i, 'date')) . '</TD>
<TD>' . db_result($result, $i, 'user_name') . '</TD></TR>';
}
echo '
</TABLE>';
} else {
echo '
<H3>No Changes Have Been Made</H3>';
}
}
