require_api('html_api.php'); require_api('lang_api.php'); require_api('print_api.php'); form_security_validate('manage_custom_field_update'); auth_reauthenticate(); access_ensure_global_level(config_get('manage_custom_fields_threshold')); $f_field_id = gpc_get_int('field_id'); $f_return = strip_tags(gpc_get_string('return', 'manage_custom_field_page.php')); $t_values['name'] = gpc_get_string('name'); $t_values['type'] = gpc_get_int('type'); $t_values['possible_values'] = gpc_get_string('possible_values'); $t_values['default_value'] = gpc_get_string('default_value'); $t_values['valid_regexp'] = gpc_get_string('valid_regexp'); $t_values['access_level_r'] = gpc_get_int('access_level_r'); $t_values['access_level_rw'] = gpc_get_int('access_level_rw'); $t_values['length_min'] = gpc_get_int('length_min'); $t_values['length_max'] = gpc_get_int('length_max'); $t_values['display_report'] = gpc_get_bool('display_report'); $t_values['display_update'] = gpc_get_bool('display_update'); $t_values['display_resolved'] = gpc_get_bool('display_resolved'); $t_values['display_closed'] = gpc_get_bool('display_closed'); $t_values['require_report'] = gpc_get_bool('require_report'); $t_values['require_update'] = gpc_get_bool('require_update'); $t_values['require_resolved'] = gpc_get_bool('require_resolved'); $t_values['require_closed'] = gpc_get_bool('require_closed'); $t_values['filter_by'] = gpc_get_bool('filter_by'); custom_field_update($f_field_id, $t_values); form_security_purge('manage_custom_field_update'); html_page_top(null, $f_return); html_operation_successful($f_return); html_page_bottom();
function deleteProductBacklog() { $t_sql = "DELETE FROM gadiv_productbacklogs WHERE id=" . db_param(0); $t_params = array($this->id); db_query_bound($t_sql, $t_params); $t_sql = "DELETE FROM gadiv_rel_productbacklog_projects WHERE pb_id=" . db_param(0); $t_params = array($this->id); db_query_bound($t_sql, $t_params); $result = $this->executeQuery("SELECT * FROM gadiv_productbacklogs ORDER BY name ASC"); foreach ($result as $num => $row) { $pbs .= $row['name'] . '|'; } $pbs = substr($pbs, 0, -1); $this->getAdditionalProjectFields(); custom_field_update($this->pb, array('name' => 'ProductBacklog', 'possible_values' => $pbs)); }
/** * Creates a custom field if it does not exist. * The settings of the custom field will be updates in any case. * * @param unknown $p_field_name Name of the * @param unknown $p_def_array */ function create_custom_field($p_field_name, $p_def_array) { $p_def_array['name'] = $p_field_name; $p_def_array['default_value'] = ''; $p_def_array['access_level_r'] = '55'; $p_def_array['access_level_rw'] = '55'; $p_def_array['display_report'] = '0'; $p_def_array['display_update'] = '0'; $p_def_array['filter_by'] = '1'; $t_field_id = custom_field_get_id_from_name($p_field_name); if (!$t_field_id) { // Field does not exist yet, create it. $t_field_id = custom_field_create($p_field_name); // Update field settings custom_field_update($t_field_id, $p_def_array); } }
function changeCustomFieldFilter($p_field_name, $p_status) { $t_field_id = custom_field_get_id_from_name($p_field_name); if ($t_field_id) { custom_field_update($t_field_id, array('name' => $p_field_name, 'filter_by' => $p_status)); } }
function setSprintStatus($status, $sprint_id) { $t_sql = "UPDATE gadiv_sprints SET status=" . db_param(0) . " WHERE id=" . db_param(1); $t_params = array($status, $sprint_id); $ergebnis = db_query_bound($t_sql, $t_params); if ($status == 2) { $result = $this->executeQuery("SELECT id,\n\t\t\t\t\t\t\t\t\t\t\t\t\tteam_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\tpb_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\t\t\tdescription,\n\t\t\t\t\t\t\t\t\t\t\t\t\tstatus,\n\t\t\t\t\t\t\t\t\t\t\t\t\tdaily_scrum,\n\t\t\t\t\t\t\t\t\t\t\t\t\tstart,\n\t\t\t\t\t\t\t\t\t\t\t\t\tdispose as " . AGILEMANTIS_COMMIT_FIELD . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\tenddate as " . AGILEMANTIS_END_FIELD . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\tclosed,\n\t\t\t\t\t\t\t\t\t\t\t\t\tunit_storypoints,\n\t\t\t\t\t\t\t\t\t\t\t\t\tunit_planned_work,\n\t\t\t\t\t\t\t\t\t\t\t\t\tunit_planned_task,\n\t\t\t\t\t\t\t\t\t\t\t\t\tworkday_length\n\t\t\t FROM gadiv_sprints ORDER BY name ASC"); foreach ($result as $num => $row) { if ($row['status'] != 2) { $spr .= $row['name'] . '|'; } } $spr = substr($spr, 0, -1); $this->getAdditionalProjectFields(); custom_field_update($this->spr, array('name' => 'Sprint', 'possible_values' => $spr)); } if ($ergebnis == true) { return 1; } else { return 0; } }