include_once APP_INC_PATH . "db_access.php";
$prj_id = $_REQUEST['prj_id'];
$tpl = new Template_API();
$tpl->setTemplate("manage/index.tpl.html");
Auth::checkAuthentication(APP_COOKIE);
$tpl->assign("type", "column_display");
$role_id = Auth::getCurrentRole();
if ($role_id == User::getRoleID('administrator') || $role_id == User::getRoleID('manager')) {
if ($role_id == User::getRoleID('administrator')) {
$tpl->assign("show_setup_links", true);
}
if (@$HTTP_POST_VARS["cat"] == "save") {
$tpl->assign("result", Display_Column::save());
}
$page = 'list_issues';
$available = Display_Column::getAllColumns($page);
$selected = Display_Column::getSelectedColumns($prj_id, $page);
// re-order available array to match rank
$available_ordered = array();
foreach ($selected as $field_name => $field_info) {
$available_ordered[$field_name] = $available[$field_name];
unset($available[$field_name]);
}
if (count($available) > 0) {
$available_ordered += $available;
}
$excluded_roles = array();
if (!Customer::hasCustomerIntegration($prj_id)) {
$excluded_roles[] = "customer";
}
$user_roles = User::getRoles($excluded_roles);
/**
* Adds records in database for new project.
*
* @param integer $prj_id The ID of the project.
*/
function setupNewProject($prj_id)
{
$page = 'list_issues';
$columns = Display_Column::getAllColumns($page);
$rank = 1;
foreach ($columns as $field_name => $column) {
if (!empty($column['default_role'])) {
$min_role = $column['default_role'];
} else {
$min_role = 1;
}
$stmt = "INSERT INTO\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "columns_to_display\n SET\n ctd_prj_id = {$prj_id},\n ctd_page = '{$page}',\n ctd_field = '{$field_name}',\n ctd_min_role = {$min_role},\n ctd_rank = {$rank}";
$res = $GLOBALS["db_api"]->dbh->query($stmt);
if (PEAR::isError($res)) {
Error_Handler::logError(array($res->getMessage(), $res->getDebugInfo()), __FILE__, __LINE__);
return -1;
}
$rank++;
}
}
