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