function print_project_timegraph($id_project, $start_date = false, $end_date = false, $id_user_filter = "")
{
if ($id_user_filter == "") {
$users = get_users_project($id_project);
} else {
$sql = "SELECT *\n FROM trole_people_project\n WHERE id_project = {$id_project} AND id_user = '******'";
$users = get_db_all_rows_sql($sql);
}
$tasks = get_db_all_rows_field_filter('ttask', 'id_project', $id_project);
$data = array();
foreach ($tasks as $task) {
foreach ($users as $user) {
$user_name = get_db_value('nombre_real', 'tusuario', 'id_usuario', $user['id_user']);
$hours = get_task_workunit_hours_user($task['id'], $user['id_user'], 0, $start_date, $end_date);
if (empty($hours)) {
continue;
}
$data[$task['id']][$user['id_user']] = array('parent_name' => safe_output($task['name']), 'name' => safe_output($user_name), 'value' => $hours, 'tooltip' => "<b>" . __('Task:') . "</b> " . $task['name'] . "<br />" . "<b>" . __('User:'******'Hours:') . "</b> " . $hours, 'id' => $task['id'] . "_" . $user['id_user']);
}
}
if (empty($data)) {
ui_print_error_message(__('There are not tasks with hours in this period.'));
return;
}
graph_print_d3js_treemap($data);
}
echo "<th>" . __('Delete');
}
$color = 1;
while ($row = mysql_fetch_array($result)) {
if ($color == 1) {
$tdcolor = "datos";
$color = 0;
} else {
$tdcolor = "datos2";
$color = 1;
}
echo "<tr><td valign='top' class='{$tdcolor}'>" . $row["id_user"];
echo "<td valign='top' class='{$tdcolor}'>" . get_db_value('name', 'trole', 'id', $row["id_role"]);
echo "<td valign=top>";
echo "<a href='index.php?sec=projects&sec2=operation/projects/task_workunit&id_project={$id_project}&id_task={$id_task}&id_user="******"id_user"] . "'><b>";
echo get_task_workunit_hours_user($id_task, $row["id_user"]);
echo "</a></b></td>";
if ($task_permission["manage"]) {
echo "<td valign='top' class='{$tdcolor}' align='center'>";
echo "<a href='index.php?sec=projects&sec2=operation/projects/people_manager&id_project={$id_project}&id_task={$id_task}&action=delete&id=" . $row["id"] . "' onClick='if (!confirm(\\' " . __('Are you sure?') . "\\')) return false;'><img src='images/cross.png' border='0'></a>";
}
}
echo "</table>";
}
} else {
// MAIN PROJECT PEOPLE LIST
echo "<h1>" . __('Project people management') . " » " . get_db_value('name', 'tproject', 'id', $id_project) . "</h1>";
$sql = "SELECT COUNT(*) FROM trole_people_project WHERE id_project = {$id_project}";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if ($row[0] > 0) {
$assigned_role .= "<th>".__('Total work time (Hrs)');
$columns = 2;
if ($task_permission["manage"]) {
$assigned_role .= "<th>".__('Delete');
$columns = 3;
}
$color = 1;
foreach ($result as $row) {
$assigned_role .= "<tr><td>".$row["id_user"];
$assigned_role .= "<td>".get_db_value('name','trole','id',$row["id_role"]);
$assigned_role .= "<td>";
$assigned_role .= "<a href='index.php?sec=projects&sec2=operation/projects/task_workunit&id_project=$id_project&id_task=$id_task&id_user="******"id_user"]."'><b>";
$assigned_role .= get_task_workunit_hours_user ($id_task, $row["id_user"]);
$assigned_role .= "</a></b></td>";
if ($task_permission["manage"]) {
$assigned_role .= "<td>";
$offset=0;
$assigned_role .= "<a href='#' onClick='javascript: show_validation_delete_general(\"delete_people_task_human\",".$id_project.",".$id_task.",".$row['id'].",\"".$search_params."\");'><img src='images/cross.png' title='".__('Delete')."'></a>";
}
}
}
$assigned_role .= "</table>";
}
else {
$sql = "SELECT COUNT(*) total FROM trole_people_project WHERE id_project = $id_project";
$result = get_db_row_sql($sql);
echo "<th>" . __('Task');
echo "<th>" . __('Progress');
echo "<th>" . __('Worked hours');
echo "<th>" . __('Last update');
echo "<th>" . __('Operation');
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . print_priority_flag_image($row['priority'], true);
echo "<td>" . $row[2];
$id_proj = $row[4];
$id_task = $row[5];
echo "<td><a href='index.php?sec=projects&sec2=operation/projects/task_detail&id_project={$id_proj}&id_task={$id_task}&operation=view'>" . $row[1] . "</a>";
echo "<td >";
echo progress_bar($row[3], 70, 20);
echo "<td align=center>" . get_task_workunit_hours_user($row[0], $id_user);
echo "<td class='f9'>";
$time1 = get_db_sql("SELECT timestamp\n\t\tFROM tworkunit_task, tworkunit\n\t\tWHERE tworkunit.id_user = '******'\n\t\tAND tworkunit_task.id_task = " . $row[0] . ' AND tworkunit.id = tworkunit_task.id_workunit
ORDER BY timestamp DESC LIMIT 1');
echo substr($time1, 0, 10);
echo "<td>";
if (give_acl($config["id_user"], 0, "PM")) {
echo "<a href='index.php?sec=users&sec2=operation/users/user_task_assigment&op=fin&id_task={$id_task}&id_user={$id_user}'><img src='images/upd.png' title='" . __("Finish this task") . "'></a>";
echo " ";
echo "<a href='index.php?sec=users&sec2=operation/users/user_task_assigment&op=deas&id_task={$id_task}&id_user={$id_user}'><img src='images/delete.png' title='" . __("Deassign this task") . "'></a>";
}
}
echo "</table>";
?>
<script type="text/javascript" src="include/js/jquery.ui.autocomplete.js"></script>
$new = false;
$belong_task = user_belong_task($id_user, $task['id'], true);
$task_access = get_project_access($config['id_user'], $project['id'], $task['id'], false, true);
// ACL - To see the task, you should have read access
if (!$task_access['read']) {
continue;
// Does not show this task
}
$role = get_db_sql("SELECT name\n\t\t\t\t\t\t\t FROM trole\n\t\t\t\t\t\t\t WHERE id IN(SELECT id_role\n\t\t\t\t\t\t\t\t\t\t FROM trole_people_task\n\t\t\t\t\t\t\t\t\t\t WHERE id_user='******'\n\t\t\t\t\t\t\t\t\t\t\tAND id_task=" . $task['id'] . ")");
echo "<tr>";
echo "<td>";
echo "<a href='index.php?sec=projects&sec2=operation/projects/project_detail&id_project=" . $project['id'] . "'>" . $project['name'] . "</a>";
echo "<td><b><a href='index.php?sec=projects&sec2=operation/projects/task_detail&id_project=" . $project['id'] . "&id_task=" . $task['id'] . "&operation=view'>" . $task['name'] . "</a></b>";
echo "<td>" . $role;
if ($belong_task) {
echo "<td>" . get_task_workunit_hours_user($task["id"], $id_user);
echo "<td>" . get_task_workunit_hours($task["id"]);
} else {
echo "<td>";
echo "<td>";
}
if ($task_access['manage'] && $belong_task) {
echo "<td align='center'><a href='index.php?sec=projects&sec2=operation/projects/role_user_global&id_user="******"&delete=" . $task['id'] . "' onClick='if (!confirm('" . __('Are you sure?') . "')) return false;'><img border=0 src='images/cross.png'></a>";
} else {
echo "<td align='center'>";
}
}
$new = false;
}
echo "</table>";
?>
