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++; } }