$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>'; $project_info .= __('Project group') . "</b><br>"; $project_info .= get_db_value("name", "tproject_group", "id", $id_project_group); // Description $project_info .= "<tr><td style='text-align: left;' colspan=4><b>" . __("Description") . "</b><br>"; $project_info .= $description; $project_info .= "</td></tr>"; $project_info .= "</table>"; echo print_container('project_info_report', __('Project info'), $project_info, 'no', true, true, "container_simple_title", "container_simple_div"); if ($id_project) { // Project activity graph $project_activity = project_activity_graph($id_project, 650, 150, true, $graph_ttl, 50, true); if ($project_activity) { $project_activity = '<div class="graph_frame">' . $project_activity . '</div>'; echo print_container('project_activity_report', __('Project activity'), $project_activity, 'no', true, true, "container_simple_title", "container_simple_div"); } // Calculation $people_inv = get_db_sql("SELECT COUNT(DISTINCT id_user) FROM trole_people_task, ttask WHERE ttask.id_project={$id_project} AND ttask.id = trole_people_task.id_task;"); $total_hr = get_project_workunit_hours($id_project); $total_planned = get_planned_project_workunit_hours($id_project); $total_planned = get_planned_project_workunit_hours($id_project); $expected_length = get_db_sql("SELECT SUM(hours) FROM ttask WHERE id_project = {$id_project}"); $pr_hour = get_project_workunit_hours($id_project, 1); $deviation = format_numeric(($pr_hour - $expected_length) / $config["hours_perday"]); $total = project_workunit_cost($id_project, 1); $real = project_workunit_cost($id_project, 0); $real = $real + get_incident_project_workunit_cost($id_project);
if ($id_project && $project_access['manage']) { $project_info .= print_input_hidden('id_project', $id_project, true); $project_info .= print_input_hidden('action', 'update', true); $project_info .= print_submit_button(__('Update'), 'upd_btn', false, 'class="sub upd"', true); } elseif (!$id_project) { $project_info .= print_input_hidden('action', 'insert'); $project_info .= print_submit_button(__('Create'), 'create_btn', false, 'class="sub create"', true); } $project_info .= '</div>'; $project_info .= "</td></tr>"; } $project_info .= "</table>"; echo print_container('project_info', __('Project info'), $project_info, 'no'); if ($id_project) { // Project activity graph $project_activity = project_activity_graph($id_project, 650, 150, true, 1, 50, true); if ($project_activity) { $project_activity = '<div class="graph_frame">' . $project_activity . '</div>'; echo print_container('project_activity', __('Project activity'), $project_activity, 'closed'); } // Calculation $people_inv = get_db_sql("SELECT COUNT(DISTINCT id_user) FROM trole_people_task, ttask WHERE ttask.id_project={$id_project} AND ttask.id = trole_people_task.id_task;"); $total_hr = get_project_workunit_hours($id_project); $total_planned = get_planned_project_workunit_hours($id_project); $total_planned = get_planned_project_workunit_hours($id_project); $expected_length = get_db_sql("SELECT SUM(hours) FROM ttask WHERE id_project = {$id_project}"); $pr_hour = get_project_workunit_hours($id_project, 1); $deviation = format_numeric(($pr_hour - $expected_length) / $config["hours_perday"]); $total = project_workunit_cost($id_project, 1); $real = project_workunit_cost($id_project, 0); $real = $real + get_incident_project_workunit_cost($id_project);
$budget .= '<td>'.__('Deviation').'</td><td>'; $deviation_percent = calculate_project_deviation ($id_project); $budget .= $deviation_percent ."%"; $budget .= "</td></tr>"; $budget .= "<tr>"; $budget .= '<td>'.__('Project costs').'</td><td>'; // Task distribution $task_distribution = '<div class="pie_frame">' . graph_workunit_project (350, 150, $id_project, $graph_ttl). "</div>"; // Workload distribution $workload_distribution = '<div class="pie_frame">' . graph_workunit_project_user_single (350, 150, $id_project, $graph_ttl). "</div>"; // Project activity graph $project_activity = project_activity_graph ($id_project, 750, 300, true, 1, 50, true); if ($project_activity) { $project_activity = '<tr><td colspan="2" style="padding:20px;">' . $project_activity . '</td></tr>'; } // Costs (client / total) $real = project_workunit_cost ($id_project, 0); $external = project_cost_invoices ($id_project); $total_project_costs = $external + $real; $budget .= format_numeric( $total_project_costs) ." ". $config["currency"]; if ($external > 0) $budget .= "<span title='External costs to the project'> ($external)</span>"; $budget .= "</td></tr>"; $total_per_profile = projects_get_cost_by_profile ($id_project, false);
$table->head[1] = __('Pri'); $table->head[2] = __('Progress'); $table->head[3] = __('Estimation'); $table->head[4] = __('Time used'); $table->head[5] = __('People'); $table->head[6] = __('Start/End'); $table->align = array (); $table->align[1] = 'left'; $table->align[2] = 'center'; $table->align[3] = 'center'; $table->align[4] = 'center'; $table->align[8] = 'center'; $table->style[6] = "font-size: 9px"; echo project_activity_graph ($id_project, 650, 150, false, $graph_ttl); $color = 1; show_task_tree ($table, $id_project, 0, 0, $where_clause); if (empty($table->data)) { echo ui_print_error_message (__('No tasks found'), '', true, 'h3', true); } else { print_table ($table); } } else { tasks_print_tree ($id_project); }