$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);
}
