function prj_viewproject_details($id)
{
global $_PRJCONF, $_TABLES, $_CONF, $_USER, $pluginLangLabels, $progress, $priority, $status;
$sql = "SELECT p.*, s.description 'statusdesc' FROM {$_TABLES['prj_projects']} p ";
$sql .= "LEFT JOIN {$_TABLES['prj_statuslog']} s ON p.pid=s.pid WHERE p.pid='{$id}' order by s.slid desc";
$result = DB_query($sql);
$projectrec = DB_fetchArray($result);
$p = new Template($_CONF['path_layout'] . 'nexproject');
$p->set_file(array('project' => 'viewproject.thtml', 'tasklog' => 'tasklog_record.thtml'));
$p->set_var($pluginLangLabels);
$p->set_var('show_resources', 'none');
prj_setTemplateVars($p, $projectrec);
$project_owner = COM_getDisplayName(DB_getItem($_TABLES['prj_users'], 'uid', "pid = {$id} AND role='o'"));
$p->set_var('VALUE_project_owner', $project_owner);
$p->set_var('VALUE_progress_color', $progress[$projectrec['progress_id']]);
$p->set_var('VALUE_status', $status[$projectrec['status_id']]);
$p->set_var('VALUE_priority', $priority[$projectrec['priority_id']]);
$p->set_var('VALUE_objective', nexlistValue($_PRJCONF['nexlist_objective'], $projectrec['objective_id'], 0));
$query = DB_query("SELECT location_id FROM {$_TABLES['prj_location']} WHERE pid='{$id}'");
while (list($location_id) = DB_fetchArray($query)) {
$location = nexlistValue($_PRJCONF['nexlist_locations'], $location_id, 0);
if ($VALUE_location == '') {
$VALUE_location = $location;
} else {
$VALUE_location .= ", {$location}";
}
}
$p->set_var('VALUE_location', $VALUE_location);
$query = DB_query("SELECT department_id FROM {$_TABLES['prj_department']} WHERE pid='{$id}'");
while (list($department_id) = DB_fetchArray($query)) {
$department = nexlistValue($_PRJCONF['nexlist_departments'], $department_id, 0);
if ($VALUE_department == '') {
$VALUE_department = $department;
} else {
$VALUE_department .= ", {$department}";
}
}
$p->set_var('VALUE_department', $VALUE_department);
$query = DB_query("SELECT category_id FROM {$_TABLES['prj_category']} WHERE pid='{$id}'");
while (list($category_id) = DB_fetchArray($query)) {
//$category = DB_getItem($_TABLES['prj_site_category'], 'description', "category_id=$category_id");
$category = nexlistValue($_PRJCONF['nexlist_category'], $category_id, 0);
if ($VALUE_category == '') {
$VALUE_category = $category;
} else {
$VALUE_category .= ", {$category}";
}
}
$p->set_var('VALUE_category', $VALUE_category);
$sql = "SELECT {$_TABLES['users']}.uid FROM {$_TABLES['users']},{$_TABLES['prj_users']} WHERE ";
$sql .= "{$_TABLES['prj_users']}.pid={$id} AND {$_TABLES['prj_users']}.uid={$_TABLES['users']}.uid ";
$query = DB_query($sql);
while (list($resource) = DB_fetchArray($query)) {
$resource_name = COM_getDisplayName($resource);
if ($VALUE_resources == '') {
$VALUE_resources = $resource_name;
} else {
$VALUE_resources .= ", {$resource_name}";
}
}
$p->set_var('VALUE_resources', $VALUE_resources);
$VALUE_resources = '';
$sql = "SELECT {$_TABLES['users']}.fullname FROM {$_TABLES['users']},{$_TABLES['prj_projPerms']} WHERE ";
$sql .= "{$_TABLES['prj_projPerms']}.pid={$id} AND {$_TABLES['prj_projPerms']}.taskid='0' AND {$_TABLES['prj_projPerms']}.uid={$_TABLES['users']}.uid ";
$query = DB_query($sql);
while (list($resource) = DB_fetchArray($query)) {
if ($VALUE_resources == '') {
$VALUE_resources = $resource;
} else {
$VALUE_resources .= ",<BR> {$resource}";
}
}
$p->set_var('project_resources', $VALUE_resources);
$sql = "SELECT uid, description, updated FROM {$_TABLES['prj_statuslog']} WHERE pid={$id} and tid=0 ORDER BY updated ASC";
$query = DB_query($sql);
if (DB_numRows($query) > 0) {
while (list($user, $comment, $date) = DB_fetchArray($query)) {
$p->set_var('member_name', DB_getItem($_TABLES['users'], 'fullname', "uid={$user}") . ': ');
$p->set_var('log_date', strftime("%Y/%m/%d %H:%M", $date));
if ($comment == '') {
$p->set_var('log_entry', '<br>Edit Task completed, no comment entered');
} else {
$p->set_var('log_entry', '<br>' . $comment);
}
$p->parse('task_log_entries', 'tasklog', true);
}
} else {
$p->set_var('log_entry', $strings['noresults']);
$p->parse('task_log_entries', 'tasklog');
}
$p->parse('output', 'project');
return $p->finish($p->get_var('output'));
}
}
$p = new Template($_CONF['path_layout'] . 'nexproject');
$p->set_file(array('task' => 'viewtask.thtml', 'tasklog' => 'tasklog_record.thtml'));
$p->set_var('breadcrumb_trail', prj_breadcrumbs($id, $pid, $strings["view_task"], $strings["view_task"]));
$p->set_var($pluginLangLabels);
$p->set_var('site_url', $_CONF['site_url']);
$p->set_var('layout_url', $_CONF['layout_url']);
$p->set_var('mode', 'save');
$p->set_var('id', $id);
$p->set_var('pid', $pid);
$p->set_var('LANG_heading', $pluginLangLabels['LANG_edit_task']);
$p->set_var('edit_icons', $edit_icons);
$p->set_var('project_name', $name);
$p->set_var('show_resources', 'none');
$p->set_var('show_submit', 'none');
prj_setTemplateVars($p, $taskrec);
$p->set_var('VALUE_progress_color', $progress[$taskrec['progress_id']]);
$p->set_var('VALUE_duration_type', $duration[$taskrec['duration_type_id']]);
$p->set_var('VALUE_status', $status[$taskrec['status_id']]);
$p->set_var('VALUE_priority', $priority[$taskrec['priority_id']]);
$taskowner = DB_getItem($_TABLES['prj_task_users'], 'uid', "tid={$id} AND role='o'");
$p->set_var('VALUE_owner', COM_getDisplayName($taskowner));
$sql = "SELECT uid, description, updated FROM {$_TABLES['prj_statuslog']} WHERE pid={$pid} and tid={$id} ORDER BY updated ASC";
$result1 = DB_query($sql);
if (DB_numRows($result1) > 0) {
while (list($user, $comment, $date) = DB_fetchArray($result1)) {
$p->set_var('member_name', DB_getItem($_TABLES['users'], 'fullname', "uid={$user}") . ': ');
$p->set_var('log_date', strftime("%Y/%m/%d %H:%M", $date));
if ($comment == '') {
$p->set_var('log_entry', '<br>Edit Task completed, no comment entered');
} else {
$projectrec = DB_fetchArray($result);
$edit_icons = prj_edit_project_icons($id, 'edit');
$p = new Template($_CONF['path_layout'] . 'nexproject');
$p->set_file('project', 'editproject.thtml');
$p->set_var('breadcrumb_trail', prj_breadcrumbs(0, $id, $strings["edit_project"]));
$p->set_var($pluginLangLabels);
$p->set_var('site_url', $_CONF['site_url']);
$p->set_var('layout_url', $_CONF['layout_url']);
$p->set_var('mode', 'save');
$p->set_var('id', $id);
$p->set_var('LANG_heading', $pluginLangLabels['LANG_edit_project']);
$p->set_var('show_resources', 'none');
$p->set_var('edit_icons', $edit_icons);
$p->set_var('linked_content_disabled', $nexfile ? '' : 'disabled="disabled"');
$p->set_var('discussion_board_disabled', $forum ? '' : 'disabled="disabled"');
prj_setTemplateVars($p, $projectrec);
$p->set_var('priority_options', selectBox2($priority, $projectrec['priority_id']));
$p->set_var('status_options', selectBox2($status, $projectrec['status_id']));
$p->set_var('progress_options', selectBox2($progress, $projectrec['progress_id']));
$p->set_var('objective_options', nexlistOptionList('options', '', $_PRJCONF['nexlist_objective'], 0, $projectrec['objective_id']));
$result1 = DB_query("SELECT location_id FROM {$_TABLES['prj_location']} WHERE pid='{$id}'");
$nrows = DB_numRows($result1);
for ($i = 0; $i < $nrows; $i++) {
$B = DB_fetchArray($result1);
$selected[$i] = $B['location_id'];
}
$p->set_var('location_options', nexlistOptionList('options', '', $_PRJCONF['nexlist_locations'], 0, $selected, '', -1, true));
$selected = NULL;
$result1 = DB_query("SELECT department_id FROM {$_TABLES['prj_department']} WHERE pid='{$id}'");
$nrows = DB_numRows($result1);
for ($i = 0; $i < $nrows; $i++) {
