$new = false;
$project_permission = get_project_access ($config['id_user'], $project['id']);
if (!$project_permission['read']) {
continue;
}
$data = array ();
// Project name
$data[0] = '<a href="index.php?sec=projects&sec2=operation/projects/project_detail&id_project='.$project['id'].'">'.$project['name'].'</a>';
$data[1] = $project["id_owner"];
if ($project["start"] == $project["end"]) {
$data[2] = __('Unlimited');
} else {
$completion = format_numeric (calculate_project_progress ($project['id']));
$data[2] = progress_bar($completion, 90, 20);
}
// Last update time
$sql = sprintf ('SELECT tworkunit.timestamp
FROM ttask, tworkunit_task, tworkunit
WHERE ttask.id_project = %d
AND ttask.id = tworkunit_task.id_task
AND tworkunit_task.id_workunit = tworkunit.id
ORDER BY tworkunit.timestamp DESC LIMIT 1',
$project['id']);
$timestamp = get_db_sql ($sql);
if ($timestamp != "")
$data[3] = "<span style='font-size: 10px'>".human_time_comparation ($timestamp)."</span>";
else
$table->size[1] = '50%';
$table->style = array();
$table->data = array();
$table->style[0] = "vertical-align: top;";
$table->style[1] = "vertical-align: top";
// Project info
$project_info = '<table class="search-table-button" style="margin-top: 0px;">';
// Name
$project_info .= '<tr><td class="datos" colspan=3><b>' . __('Name') . ' </b><br>';
$project_info .= $name;
$project_info .= '<td colspan=1>';
//Only show project progress if there is a project created
if ($id_project) {
$project_info .= '<b>' . __('Current progress') . ' </b><br>';
$project_info .= '<span style="vertical-align:bottom">';
$completion = format_numeric(calculate_project_progress($id_project));
$project_info .= progress_bar($completion, 90, 20, $graph_ttl);
$project_info .= "</span>";
}
$project_info .= "</td>";
$project_info .= "</tr>";
// start and end date
$project_info .= '<tr><td width="25%"><b>' . __('Start') . ' </b><br>';
$project_info .= $start_date;
$project_info .= '<td width="25%"><b>' . __('End') . ' </b><br>';
$project_info .= $end_date;
$id_owner = get_db_value('id_owner', 'tproject', 'id', $id_project);
$project_info .= '<td width="25%">';
$project_info .= "<b>" . __('Project manager') . " </b><br>";
$project_info .= get_db_value("nombre_real", "tusuario", "id_usuario", $owner);
$project_info .= '<td width="25%"><b>';