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>"; ?>