data.php File Reference

Go to the source code of this file.

Functions
	trackers_data_get_all_fields ($group_id=false, $reload=false)
	trackers_data_get_item_group ($item_id)
&	trackers_data_get_notification_settings ($group_id, $tracker_name)
	trackers_data_show_notification_settings ($group_id, $tracker_name, $show_intro_msg)
	trackers_data_post_notification_settings ($group_id, $tracker_name)
	trackers_data_get_item_notification_info ($item_id, $artifact, $updated)
	cmp_place ($ar1, $ar2)
	cmp_place_query ($ar1, $ar2)
	cmp_place_result ($ar1, $ar2)
	trackers_data_get_all_report_fields ($group_id=false, $report_id=100)
	trackers_data_get_field_predefined_values ($field, $group_id=false, $checked=false, $by_field_id=false, $active_only=true)
	trackers_data_use_field_predefined_values ($field, $group_id)
	trackers_data_is_custom ($field, $by_field_id=false)
	trackers_data_is_special ($field, $by_field_id=false)
	trackers_data_is_empty_ok ($field, $by_field_id=false)
	trackers_data_mandatory_flag ($field, $by_field_id=false)
	trackers_data_do_keep_history ($field, $by_field_id=false)
	trackers_data_is_required ($field, $by_field_id=false)
	trackers_data_is_used ($field, $by_field_id=false)
	trackers_data_is_showed_on_query ($field)
	trackers_data_is_showed_on_result ($field)
	trackers_data_is_showed_on_add ($field, $by_field_id=false)
	trackers_data_is_showed_on_add_nologin ($field, $by_field_id=false)
	trackers_data_is_showed_on_add_members ($field, $by_field_id=false)
	trackers_data_is_date_field ($field, $by_field_id=false)
	trackers_data_is_text_field ($field, $by_field_id=false)
	trackers_data_is_text_area ($field, $by_field_id=false)
	trackers_data_is_select_box ($field, $by_field_id=false)
	trackers_data_is_username_field ($field, $by_field_id=false)
	trackers_data_is_project_scope ($field, $by_field_id=false)
	trackers_data_is_status_closed ($status)
	trackers_data_get_field_name ($field_id)
	trackers_data_get_field_id ($field_name)
	trackers_data_get_group_id ($field, $by_field_id=false)
	trackers_data_get_label ($field, $by_field_id=false)
	trackers_data_get_description ($field, $by_field_id=false)
	trackers_data_get_display_type ($field, $by_field_id=false)
	trackers_data_get_display_type_in_clear ($field, $by_field_id=false)
	trackers_data_get_keep_history ($field, $by_field_id=false)
	trackers_data_get_place ($field, $by_field_id=false)
	trackers_data_get_scope ($field, $by_field_id=false)
	trackers_data_get_col_width ($field, $by_field_id=false)
	trackers_data_get_display_size ($field, $by_field_id=false)
	trackers_data_get_default_value ($field, $by_field_id=false)
	trackers_data_get_max_value_id ($field, $group_id, $by_field_id=false)
	trackers_data_get_cached_field_value ($field, $group_id, $value_id)
	trackers_data_get_field_value ($item_fv_id)
	trackers_data_is_default_value ($item_fv_id)
	trackers_data_create_value ($field, $group_id, $value, $description, $order_id, $status='A', $by_field_id=false)
	trackers_data_update_value ($item_fv_id, $field, $group_id, $value, $description, $order_id, $status='A')
	trackers_data_reset_usage ($field_name, $group_id)
	trackers_data_update_usage ($field_name, $group_id, $label, $description, $use_it, $rank, $display_size, $empty_ok, $keep_history, $show_on_add_members=0, $show_on_add=0, $transition_default_auth='A')
	trackers_data_get_technicians ($group_id)
	trackers_data_get_transition ($group_id)
	trackers_data_get_submitters ($group_id=false)
	trackers_data_get_items ($group_id=false, $artifact)
	trackers_data_get_dependent_items ($item_id=false, $artifact, $notin=false)
	trackers_data_get_valid_bugs ($group_id=false, $item_id='')
	trackers_data_get_followups ($item_id=false, $rorder=true)
	trackers_data_get_commenters ($item_id)
	trackers_data_get_history ($item_id=false)
	trackers_data_get_attached_files ($item_id=false, $order='DESC')
	trackers_data_get_cc_list ($item_id=false)
	trackers_data_add_history ($field_name, $old_value, $new_value, $item_id, $type=false, $artifact=0, $force=0)
	trackers_data_handle_update ($group_id, $item_id, $dependent_on_task, $dependent_on_bugs, $dependent_on_support, $dependent_on_patch, $canned_response, $vfl, &$changes, &$extra_addresses)

---

Function Documentation

cmp_place (  $  ar1, $  ar2 )

Definition at line 360 of file data.php. { if ($ar1['place']< $ar2['place']) return -1; else if ($ar1['place']>$ar2['place']) return 1; return 0; }

cmp_place_query (  $  ar1, $  ar2 )

Definition at line 369 of file data.php. { if ($ar1['place_query']< $ar2['place_query']) return -1; else if ($ar1['place_query']>$ar2['place_query']) return 1; return 0; }

cmp_place_result (  $  ar1, $  ar2 )

Definition at line 378 of file data.php. { if ($ar1['place_result']< $ar2['place_result']) return -1; else if ($ar1['place_result']>$ar2['place_result']) return 1; return 0; }

trackers_data_add_history (  $  field_name, $  old_value, $  new_value, $  item_id, $  type = false, $  artifact = 0, $  force = 0 )

Definition at line 1332 of file data.php. Referenced by cookbook_handle_update(), trackers_data_handle_update(), and trackers_transition_update_item(). { # If no artifact is defined, get the default one if (!$artifact) { $artifact = ARTIFACT; } # If field is not to be kept in bug change history then do nothing if (!$force && !trackers_data_get_keep_history($field_name)) { return; } if (!user_isloggedin()) { $user=100; } else { $user=user_getid(); } # If type has a value add it into the sql statement (this is only for # the follow up comments (details field)) if ($type) { $fld_type = ',type'; $val_type = ",'$type'"; } else { # No comment type specified for a followup comment # so force it to None (100) if ($field_name == 'details') { $fld_type = ',type'; $val_type = ",'100'"; } } $sql="INSERT INTO ".$artifact."_history (bug_id,field_name,old_value,new_value,mod_by,date $fld_type) ". "VALUES ('$item_id','$field_name','$old_value','$new_value','$user','".time()."' $val_type)"; return db_query($sql); }

trackers_data_create_value (  $  field, $  group_id, $  value, $  description, $  order_id, $  status = 'A', $  by_field_id = false )

Definition at line 975 of file data.php. References $feedback, $field_id, $sql, db_affected_rows(), db_query(), group_id, trackers_data_get_field_id(), and trackers_data_get_max_value_id(). { global $feedback,$ffeedback; /* Insert a new value for a given field for a given group */ # An empty field value is not allowed if (preg_match ("/^\s*$/", $value)) { fb(_("Empty field value not allowed"), 0); return; } if (!$by_field_id) { $field_id = trackers_data_get_field_id($field); } # if group_id=100 (None) then do nothing # because no real project should have the group number '100' if ($group_id != 100) { # if the current value set for this project is empty # then copy the default values first (if any) if (trackers_data_is_value_set_empty($field,$group_id)) { trackers_data_copy_default_values($field,$group_id); } # Find the next value_id to give to this new value. (Start arbitrarily # at 200 if no value exists (and therefore max is undefined) $max_value_id = trackers_data_get_max_value_id($field, $group_id); if ($max_value_id < 0) { $value_id = 200; } else { $value_id = $max_value_id +1; } $sql = "INSERT INTO ".ARTIFACT."_field_value ". "(bug_field_id,group_id,value_id,value,description,order_id,status) ". "VALUES ('$field_id','$group_id','$value_id','$value','$description','$order_id','$status')"; db_query($sql); if (db_affected_rows($result) < 1) { fb(_("Insert failed."), 0); ' - '.db_error(); } else { fb(_("New field value inserted.")); } } }

trackers_data_do_keep_history (  $  field, $  by_field_id = false )

Definition at line 554 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { $val = $BF_USAGE_BY_ID[$field]['custom_keep_history']; if (!isset($val)) { $val = $BF_USAGE_BY_ID[$field]['empty_keep_history']; } } else { $val = $BF_USAGE_BY_NAME[$field]['custom_keep_history']; if (!isset($val)) { $val = $BF_USAGE_BY_NAME[$field]['keep_history']; } } return($val); }

trackers_data_get_all_fields (  $  group_id = false, $  reload = false )

Definition at line 37 of file data.php. References $sql, db_fetch_array(), db_query(), and group_id. { /* Get all the possible bug fields for this project both used and unused. If used then show the project specific information about field usage otherwise show the default usage parameter Make sure array element are sorted by ascending place */ global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME, $AT_START; # Do nothing if already set and reload not forced if (isset($BF_USAGE_BY_ID) && !$reload) { return; } # Clean up the array $BF_USAGE_BY_ID=array(); $BF_USAGE_BY_NAME=array(); # First get the all the defaults. $sql='SELECT '.ARTIFACT.'_field.bug_field_id, field_name, display_type, '. 'display_size,label, description,scope,required,empty_ok,keep_history,special, custom, '. 'group_id, use_it,show_on_add,show_on_add_members, place, custom_label,'. 'custom_description,custom_display_size,custom_empty_ok,custom_keep_history '. 'FROM '.ARTIFACT.'_field, '.ARTIFACT.'_field_usage '. 'WHERE group_id=100 '. 'AND '.ARTIFACT.'_field.bug_field_id='.ARTIFACT.'_field_usage.bug_field_id '; $res_defaults = db_query($sql); # Now put all used fields in a global array for faster access # Index both by field_name and bug_field_id while ($field_array = db_fetch_array($res_defaults)) { $BF_USAGE_BY_ID[$field_array['bug_field_id'] ] = $field_array; $BF_USAGE_BY_NAME[$field_array['field_name'] ] = $field_array; } # Then select all project specific entries $sql='SELECT '.ARTIFACT.'_field.bug_field_id, field_name, display_type, '. 'display_size,label, description,scope,required,empty_ok,keep_history,special, custom, '. 'group_id, use_it, show_on_add, show_on_add_members, place, custom_label,'. 'custom_description,custom_display_size,custom_empty_ok,custom_keep_history '. 'FROM '.ARTIFACT.'_field, '.ARTIFACT.'_field_usage '. 'WHERE group_id='.$group_id. ' AND '.ARTIFACT.'_field.bug_field_id= '.ARTIFACT.'_field_usage.bug_field_id '; $res_project = db_query($sql); # And override entries in the default array while ($field_array = db_fetch_array($res_project)) { $BF_USAGE_BY_ID[$field_array['bug_field_id'] ] = $field_array; $BF_USAGE_BY_NAME[$field_array['field_name'] ] = $field_array; } #Debug code #print "<br />DBG - At end of bug_get_all_fields: $rows"; #reset($BF_USAGE_BY_NAME); #while (list($key, $val) = each($BF_USAGE_BY_NAME)) #{ #print "<br />DBG - $key -> use_it: $val[use_it], $val[place]"; #} # rewind internal pointer of global arrays reset($BF_USAGE_BY_ID); reset($BF_USAGE_BY_NAME); $AT_START = true; }

trackers_data_get_all_report_fields (  $  group_id = false, $  report_id = 100 )

Definition at line 387 of file data.php. References $field, $field_id, $res, $sql, db_fetch_array(), db_query(), safeinput(), and trackers_data_get_field_id(). { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; /* Get all the bug fields involved in the bug report. WARNING: This function ust only be called after bug_init() */ # Build the list of fields involved in this report $sql = "SELECT * FROM ".ARTIFACT."_report_field WHERE report_id='".safeinput($report_id)."'"; $res = db_query($sql); while ($arr = db_fetch_array($res)) { $field = $arr['field_name']; $field_id = trackers_data_get_field_id($field); $BF_USAGE_BY_NAME[$field]['show_on_query'] = $BF_USAGE_BY_ID[$field_id]['show_on_query'] = $arr['show_on_query']; $BF_USAGE_BY_NAME[$field]['show_on_result'] = $BF_USAGE_BY_ID[$field_id]['show_on_result'] = $arr['show_on_result']; $BF_USAGE_BY_NAME[$field]['place_query'] = $BF_USAGE_BY_ID[$field_id]['place_query'] = $arr['place_query']; $BF_USAGE_BY_NAME[$field]['place_result'] = $BF_USAGE_BY_ID[$field_id]['place_result'] = $arr['place_result']; $BF_USAGE_BY_NAME[$field]['col_width'] = $BF_USAGE_BY_ID[$field_id]['col_width'] = $arr['col_width']; } }

trackers_data_get_attached_files (  $  item_id = false, $  order = 'DESC' )

Definition at line 1313 of file data.php. Referenced by format_item_attached_files(). { $sql="SELECT file_id,filename,filesize,filetype,description,date,user.user_name ". "FROM trackers_file,user ". "WHERE submitted_by=user.user_id ". "AND artifact='".ARTIFACT."' ". "AND item_id='$item_id' ORDER BY date $order"; return db_query($sql); }

trackers_data_get_cached_field_value (  $  field, $  group_id, $  value_id )

Definition at line 933 of file data.php. References $field, $res, db_fetch_array(), group_id, and trackers_data_get_field_predefined_values(). Referenced by show_item_list(), and show_item_list_sober(). { global $BF_VALUE_BY_NAME; if (!isset($BF_VALUE_BY_NAME[$field][$value_id])) { $res = trackers_data_get_field_predefined_values ($field, $group_id,false,false,false); while ($fv_array = db_fetch_array($res)) { # $fv_array[0] has the value_id and [1] is the value $BF_VALUE_BY_NAME[$field][$fv_array['value_id']] = $fv_array[1]; } } return $BF_VALUE_BY_NAME[$field][$value_id]; }

trackers_data_get_cc_list (  $  item_id = false  )

Definition at line 1323 of file data.php. Referenced by format_item_cc_list(). { $sql="SELECT bug_cc_id,".ARTIFACT."_cc.email,".ARTIFACT."_cc.added_by,".ARTIFACT."_cc.comment,".ARTIFACT."_cc.date,user.user_name ". "FROM ".ARTIFACT."_cc,user ". "WHERE added_by=user.user_id ". "AND bug_id='$item_id' ORDER BY date DESC"; return db_query($sql); }

trackers_data_get_col_width (  $  field, $  by_field_id = false )

Definition at line 783 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['col_width'] : $BF_USAGE_BY_NAME[$field]['col_width']); }

trackers_data_get_commenters (  $  item_id  )

Definition at line 1295 of file data.php. { $sql="SELECT DISTINCT mod_by FROM ".ARTIFACT."_history ". "WHERE ".ARTIFACT."_history.bug_id='$item_id' ". "AND ".ARTIFACT."_history.field_name = 'details' "; return db_query($sql); }

trackers_data_get_default_value (  $  field, $  by_field_id = false )

Definition at line 806 of file data.php. References $field, $result, bug, db_query(), db_result, and trackers_data_get_field_name(). { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; /* Return the default value associated to a field_name as defined in the bug table (SQL definition) */ if ($by_field_id) { $field = trackers_data_get_field_name($field); } $result = db_query('describe bug '.$field); return (db_result($result,0,'Default')); }

trackers_data_get_dependent_items (  $  item_id = false, $  artifact, $  notin = false )

Definition at line 1250 of file data.php. References $sql, db_query(), and print. { /* Get the list of ids this is dependent on */ $sql="SELECT is_dependent_on_item_id FROM ".ARTIFACT."_dependencies WHERE item_id='$item_id' AND is_dependent_on_item_id_artifact='".$artifact."' "; if ($notin) { $sql .= ' AND is_dependent_on_item_id NOT IN ('. join(',',$notin).')'; } # print $sql; #DBG return db_query($sql); }

trackers_data_get_description (  $  field, $  by_field_id = false )

Definition at line 706 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { $desc = $BF_USAGE_BY_ID[$field]['custom_description']; if (!isset($desc)) { $desc = $BF_USAGE_BY_ID[$field]['description']; } } else { $desc = $BF_USAGE_BY_NAME[$field]['custom_description']; if (!isset($desc)) { $desc = $BF_USAGE_BY_NAME[$field]['description']; } } return($desc); }

trackers_data_get_display_size (  $  field, $  by_field_id = false )

Definition at line 789 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { $val = $BF_USAGE_BY_ID[$field]['custom_display_size']; if (!isset($val)) { $val = $BF_USAGE_BY_ID[$field]['display_size']; } } else { $val = $BF_USAGE_BY_NAME[$field]['custom_display_size']; if (!isset($val)) { $val = $BF_USAGE_BY_NAME[$field]['display_size']; } } return(explode('/',$val)); }

trackers_data_get_display_type (  $  field, $  by_field_id = false )

Definition at line 723 of file data.php. References $field. Referenced by trackers_data_is_date_field(), trackers_data_is_select_box(), trackers_data_is_text_area(), and trackers_data_is_text_field(). { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['display_type'] : $BF_USAGE_BY_NAME[$field]['display_type']); }

trackers_data_get_display_type_in_clear (  $  field, $  by_field_id = false )

Definition at line 729 of file data.php. References trackers_data_is_date_field(), trackers_data_is_select_box(), trackers_data_is_text_area(), and trackers_data_is_text_field(). { if (trackers_data_is_select_box($field, $by_field_id)) { return 'Select Box'; } else if (trackers_data_is_text_field($field, $by_field_id)) { return 'Text Field'; } else if (trackers_data_is_text_area($field, $by_field_id)) { return 'Text Area'; } else if (trackers_data_is_date_field($field, $by_field_id)) { return 'Date Field'; } else { return '?'; } }

trackers_data_get_field_id (  $  field_name  )

Definition at line 677 of file data.php. Referenced by trackers_data_create_value(), trackers_data_get_all_report_fields(), trackers_data_get_field_predefined_values(), trackers_data_get_max_value_id(), trackers_data_handle_update(), trackers_data_reset_usage(), trackers_data_update_usage(), and trackers_data_use_field_predefined_values(). { global $BF_USAGE_BY_NAME; return($BF_USAGE_BY_NAME[$field_name]['bug_field_id']); }

trackers_data_get_field_name (  $  field_id  )

Definition at line 671 of file data.php. References $field_id. Referenced by trackers_data_get_default_value(), trackers_data_get_field_predefined_values(), and trackers_data_is_username_field(). { global $BF_USAGE_BY_ID; return($BF_USAGE_BY_ID[$field_id]['field_name']); }

trackers_data_get_field_predefined_values (  $  field, $  group_id = false, $  checked = false, $  by_field_id = false, $  active_only = true )

Definition at line 421 of file data.php. References $field, $field_id, $rows, $sql, db_numrows(), db_query(), group_id, trackers_data_get_field_id(), trackers_data_get_field_name(), trackers_data_get_submitters(), and trackers_data_get_technicians(). Referenced by trackers_data_get_cached_field_value(). { /* Return all possible values for a select box field Rk: if the checked value is given then it means that we want this value in the list in any case (even if it is hidden and active_only is requested) */ $field_id = ($by_field_id ? $field : trackers_data_get_field_id($field)); $field_name = ($by_field_id ? trackers_data_get_field_name($field) : $field); # The "Assigned_to" box requires some special processing # because possible values are project members) and they are # not stored in the trackers_field_value table but in the user_group table if ($field_name == 'assigned_to') { $res_value = trackers_data_get_technicians($group_id); } else if ($field_name == 'submitted_by') { $res_value = trackers_data_get_submitters($group_id); } else { # If only active field if ($active_only) { if ($checked) { $status_cond = "AND (status IN ('A','P') OR value_id='$checked') "; } else { $status_cond = "AND status IN ('A','P') "; } } # CAUTION !! the fields value_id and value must be first in the # select statement because the output is used in the html_build_select_box # function # yeupou@gnu.org 2003-11-24 # FIXME!!!!! WHAT IS THIS CRAP! # It _on purpose_ ignores the permanent values for the # system when a group have his own values. # And when creating group specific values, it insert the permanent # system values in the group specific values. # # Can someone bring a reasonnable explanation for such a behavior? # - permanent field must by nature be permanent, in any case! # - database must never duplicates information without good reason # # When improving this code, please change that so it uses the permanent # values in any case, whatever the group specific values may be. # Look for project specific values first $sql="SELECT value_id,value,bug_fv_id,bug_field_id,group_id,description,order_id,status ". "FROM ".ARTIFACT."_field_value ". "WHERE group_id=$group_id AND bug_field_id=$field_id ". $status_cond." ORDER BY order_id,value ASC"; $res_value = db_query($sql); $rows=db_numrows($res_value); # If no specific value for this group then look for default values if ($rows == 0) { $sql="SELECT value_id,value,bug_fv_id,bug_field_id,group_id,description,order_id,status ". "FROM ".ARTIFACT."_field_value ". "WHERE group_id=100 AND bug_field_id=$field_id ". $status_cond." ORDER BY order_id,value ASC"; $res_value = db_query($sql); $rows=db_numrows($res_value); } } return($res_value); }

trackers_data_get_field_value (  $  item_fv_id  )

Definition at line 951 of file data.php. References $res, $sql, and db_query(). { /* Get all the columns associated to a given field value */ $sql = "SELECT * FROM ".ARTIFACT."_field_value WHERE bug_fv_id='$item_fv_id'"; $res = db_query($sql); return($res); }

trackers_data_get_followups (  $  item_id = false, $  rorder = true )

Definition at line 1273 of file data.php. Referenced by format_item_changes(), and format_item_details(). { if ($rorder == "true") { $rorder = "DESC"; } else { $rorder = "ASC"; } $sql="SELECT DISTINCT ".ARTIFACT."_history.bug_history_id,".ARTIFACT."_history.field_name,".ARTIFACT."_history.old_value,".ARTIFACT."_history.date,user.user_name,user.realname,".ARTIFACT."_field_value.value AS comment_type ". "FROM ".ARTIFACT."_history,".ARTIFACT."_field_value,".ARTIFACT."_field,".ARTIFACT.",user ". "WHERE ".ARTIFACT."_history.bug_id='$item_id' ". "AND ".ARTIFACT."_history.field_name = 'details' ". "AND ".ARTIFACT."_history.mod_by=user.user_id ". "AND ".ARTIFACT."_history.bug_id=".ARTIFACT.".bug_id ". "AND ".ARTIFACT."_history.type = ".ARTIFACT."_field_value.value_id ". "AND ".ARTIFACT."_field_value.bug_field_id = ".ARTIFACT."_field.bug_field_id ". "AND (".ARTIFACT."_field_value.group_id = ".ARTIFACT.".group_id OR ".ARTIFACT."_field_value.group_id = '100') ". "AND ".ARTIFACT."_field.field_name = 'comment_type_id' ". "ORDER BY ".ARTIFACT."_history.date $rorder"; return db_query($sql); }

trackers_data_get_group_id (  $  field, $  by_field_id = false )

Definition at line 683 of file data.php. References $field, and group_id. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['group_id'] : $BF_USAGE_BY_NAME[$field]['group_id']); }

trackers_data_get_history (  $  item_id = false  )

Definition at line 1303 of file data.php. Referenced by show_item_history(). { $sql="select ".ARTIFACT."_history.field_name,".ARTIFACT."_history.old_value,".ARTIFACT."_history.date,".ARTIFACT."_history.type,user.user_name,".ARTIFACT."_history.new_value ". "FROM ".ARTIFACT."_history,user ". "WHERE ".ARTIFACT."_history.mod_by=user.user_id ". "AND ".ARTIFACT."_history.field_name <> 'details' ". "AND bug_id='$item_id' ORDER BY ".ARTIFACT."_history.date DESC"; return db_query($sql); }

trackers_data_get_item_group (  $  item_id  )

Definition at line 112 of file data.php. References db_query(), db_result, and group_id. { return db_result( db_query("SELECT group_id FROM ".ARTIFACT." WHERE bug_id='$item_id'"), 0, 'group_id'); }

trackers_data_get_item_notification_info (  $  item_id, $  artifact, $  updated )

Definition at line 303 of file data.php. References $result, $rows, $sql, db_numrows(), db_query(), and db_result. Referenced by trackers_data_handle_update(). { $emailad = ""; $sendemail = 0; # Get group information bur new entity notification settings $sql="SELECT groups.$artifact"."_glnotif, groups.send_all_"."$artifact, groups.new_"."$artifact"."_address ". "FROM "."$artifact, groups ". "WHERE "."$artifact.bug_id='$item_id' ". "AND groups.group_id="."$artifact.group_id"; $result=db_query($sql); $glnotif = db_result($result,0,$artifact."_glnotif"); $glsendall = db_result($result,0,"send_all_".$artifact); $glnewad = db_result($result,0,"new_".$artifact."_address"); if ($glnotif != 1) { # if not 'global only' $cat_field_name = "category_id"; $sql="SELECT "."$artifact"."_field_value.email_ad, "."$artifact"."_field_value.send_all_flag ". "FROM "."$artifact"."_field_value, "."$artifact"."_field, $artifact ". "WHERE "."$artifact.bug_id='$item_id' ". "AND "."$artifact"."_field.field_name='$cat_field_name' ". "AND "."$artifact"."_field_value.bug_field_id="."$artifact"."_field.bug_field_id ". "AND "."$artifact"."_field_value.group_id="."$artifact.group_id ". "AND "."$artifact"."_field_value.value_id="."$artifact.category_id"; $result=db_query($sql); $rows=db_numrows($result); if ($rows > 0) { $sendallflag = db_result($result, 0, 'send_all_flag'); if (($updated == 0) || (($updated == 1) && ($sendallflag == 1))) { $emailad .= db_result($result, 0, 'email_ad'); } } else { # could be that administrator closes category notification and forgot # to define categories BUT in most cases it means the submitter selected # the 'NONE' category for this bug if (($updated == 0) || (($updated == 1) && ($glsendall == 1))) { $emailad .= $glnewad; } } } if ($glnotif > 0) { # if not 'category only' if (($updated == 0) || (($updated == 1) && ($glsendall == 1))) { if ($emailad != "") { $emailad .= ','; } $emailad .= $glnewad; } } if (trim($emailad) != "") { $sendemail = 1; } # print "EMAILAD=$emailad SENDEMAIL=$sendemail"; return array($emailad, $sendemail); }

trackers_data_get_items (  $  group_id = false, $  artifact )

Definition at line 1237 of file data.php. References $sql, and db_query(). { /* Get the items for this project */ $sql="SELECT bug_id,summary ". "FROM ".$artifact." ". "WHERE group_id='".$group_id."'". " AND status_id <> '3' ". " ORDER BY bug_id DESC LIMIT 100"; return db_query($sql); }

trackers_data_get_keep_history (  $  field, $  by_field_id = false )

Definition at line 754 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { $val = $BF_USAGE_BY_ID[$field]['custom_keep_history']; if (!isset($val)) { $val = $BF_USAGE_BY_ID[$field]['keep_history']; } } else { $val = $BF_USAGE_BY_NAME[$field]['custom_keep_history']; if (!isset($val)) { $val = $BF_USAGE_BY_NAME[$field]['keep_history']; } } return($val); }

trackers_data_get_label (  $  field, $  by_field_id = false )

Definition at line 689 of file data.php. References $field. Referenced by format_item_changes(), show_item_history(), and trackers_transition_update_item(). { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { $lbl = $BF_USAGE_BY_ID[$field]['custom_label']; if (!isset($lbl)) { $lbl = $BF_USAGE_BY_ID[$field]['label']; } } else { $lbl = $BF_USAGE_BY_NAME[$field]['custom_label']; if (!isset($lbl)) { $lbl = $BF_USAGE_BY_NAME[$field]['label']; } } return($lbl); }

trackers_data_get_max_value_id (  $  field, $  group_id, $  by_field_id = false )

Definition at line 823 of file data.php. References $field_id, $res, $rows, $sql, db_numrows(), db_query(), db_result, and trackers_data_get_field_id(). Referenced by trackers_data_create_value(). { /* Find the maximum value for the value_id of a field for a given group Return -1 if no value exist yet */ if (!$by_field_id) { $field_id = trackers_data_get_field_id($field); } $sql="SELECT max(value_id) as max FROM ".ARTIFACT."_field_value ". "WHERE bug_field_id='$field_id' AND group_id='$group_id' "; $res = db_query($sql); $rows = db_numrows($res); # If no max value found then it means it's the first value for this field # in this group. Return -1 in this case if ($rows == 0) { return(-1); } else { return(db_result($res,0,'max')); } } function trackers_data_is_value_set_empty($field, $group_id, $by_field_id=false) { /* Return true if there is an existing set of values for given field for a given group and false if it is empty */ if (!$by_field_id) { $field_id = trackers_data_get_field_id($field); } $sql="SELECT value_id FROM ".ARTIFACT."_field_value ". "WHERE bug_field_id='$field_id' AND group_id='$group_id' "; $res = db_query($sql); $rows=db_numrows($res); return (($rows<=0)); } function trackers_data_copy_default_values($field, $group_id, $by_field_id=false) { /* Initialize the set of values for a given field for a given group by using the system default (default values belong to group_id 'None' =100) */ if (!$by_field_id) { $field_id = trackers_data_get_field_id($field); } # if group_id=100 (None) it is a null operation # because default values belong to group_id 100 by definition if ($group_id != 100) { # First delete the exisiting value if any $sql="DELETE FROM ".ARTIFACT."_field_value ". "WHERE bug_field_id='$field_id' AND group_id='$group_id' "; $res = db_query($sql); # Second insert default values (if any) from group 'None' # Rk: The target table of the INSERT statement cannot appear in # the FROM clause of the SELECT part of the query because it's forbidden # in ANSI SQL to SELECT . So do it by hand ! # $sql = "SELECT value_id,value,description,order_id,status ". "FROM ".ARTIFACT."_field_value ". "WHERE bug_field_id='$field_id' AND group_id='100'"; $res = db_query($sql); $rows = db_numrows($res); for ($i=0; $i<$rows; $i++) { $value_id = addslashes(db_result($res,$i,'value_id')); $value = db_result($res,$i,'value'); $description = addslashes(db_result($res,$i,'description')); $order_id = db_result($res,$i,'order_id'); $status = db_result($res,$i,'status'); $sql="INSERT INTO ".ARTIFACT."_field_value ". "(bug_field_id,group_id,value_id,value,description,order_id,status) ". "VALUES ('$field_id','$group_id','$value_id','$value','$description','$order_id','$status')"; #print "<BR>DBG - $sql"; $res_insert = db_query($sql); if (db_affected_rows($res_insert) < 1) { fb(_("Insert of default value failed."), 0); db_error(); } } }

& trackers_data_get_notification_settings (  $  group_id, $  tracker_name )

Definition at line 120 of file data.php. References $i, $result, $sql, db_numrows(), db_query(), db_result, and exit_no_group(). Referenced by trackers_data_show_notification_settings(). { $result = db_query("SELECT * FROM groups WHERE group_id=$group_id"); if (db_numrows($result) < 1) { exit_no_group(); } $settings = array(); $settings['glnotif'] = db_result($result,0,$tracker_name."_glnotif"); $settings['glsendall'] = db_result($result,0,"send_all_".$tracker_name); $settings['glnewad'] = db_result($result,0,"new_".$tracker_name."_address"); $settings['private_exclude'] = db_result($result,0,$tracker_name."_private_exclude_address"); $cat_field_name = "category_id"; # Warning: The hardcoded fiels names: bug_fv_id and bug_field_id will need to be changed # one day to generic names since they apply to bugs but also to suuports,tasks, # and patch related tables. For now these fileds are called bug_xxx whatever # the service related tables. Too much work to make all the changes in the code. $sql="SELECT ".$tracker_name."_field_value.bug_fv_id,".$tracker_name."_field_value.value,".$tracker_name."_field_value.email_ad,".$tracker_name."_field_value.send_all_flag ". "FROM ".$tracker_name."_field, ".$tracker_name."_field_value ". "WHERE ".$tracker_name."_field_value.group_id='$group_id' ". "AND ".$tracker_name."_field.field_name='$cat_field_name' ". "AND ".$tracker_name."_field_value.bug_field_id=".$tracker_name."_field.bug_field_id ". "AND ".$tracker_name."_field_value.status!='H'"; $result=db_query($sql); $settings['nb_categories']=db_numrows($result); $settings['category'] = array(); for ($i=0; $i < $settings['nb_categories'] ; $i++) { $settings['category'][$i] = array(); $settings['category'][$i]['name'] = db_result($result, $i, 'value'); $settings['category'][$i]['fv_id'] = db_result($result, $i, 'bug_fv_id'); $email = db_result($result, $i, 'email_ad'); if ($email == '100') { $email = ""; } $settings['category'][$i]['email'] = $email; $settings['category'][$i]['send_all_flag'] = db_result($result, $i, 'send_all_flag'); } return $settings; }

trackers_data_get_place (  $  field, $  by_field_id = false )

Definition at line 771 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['place'] : $BF_USAGE_BY_NAME[$field]['place']); }

trackers_data_get_scope (  $  field, $  by_field_id = false )

Definition at line 777 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['scope'] : $BF_USAGE_BY_NAME[$field]['scope']); }

trackers_data_get_submitters (  $  group_id = false  )

Definition at line 1227 of file data.php. References $sql, and db_query(). Referenced by trackers_data_get_field_predefined_values(). { $sql="SELECT DISTINCT user.user_id,user.user_name ". "FROM user,".ARTIFACT." ". "WHERE user.user_id=".ARTIFACT.".submitted_by ". "AND ".ARTIFACT.".group_id='$group_id' ". "ORDER BY user.user_name"; return db_query($sql); }

trackers_data_get_technicians (  $  group_id  )

Definition at line 1186 of file data.php. References $sql, db_fetch_array(), db_query(), group_id, member_check(), and member_create_tracker_flag(). Referenced by trackers_data_get_field_predefined_values(). { # FIXME: The cleanest thing would be to issue one SQL command. # But we have to handle the fact that "no setting" = get back # to the group, or even group type, setting. # In fact, this is terrible, we cannot return something else than # a mysql result if we do not want to rewrite 25 functions. # So we get the appropriate list of users... and finally issue a # mysql command only to be able to return a mysql result. # Please, propose something better at savannah-dev@gnu.org # Get list of members $members_sql = "SELECT user.user_id AS user_id " . "FROM user,user_group " . "WHERE user.user_id=user_group.user_id AND user_group.group_id=$group_id "; $members_res = db_query($members_sql); # Build the sql command $sql = "SELECT user_id,user_name FROM user WHERE "; while ($member = db_fetch_array($members_res)) { if (member_check($member['user_id'], $group_id, member_create_tracker_flag(ARTIFACT).'1')) { if ($notfirst) { $sql .= " OR "; } $sql .= " user_id='".$member['user_id']."'"; $notfirst = 1; } } $sql .= " ORDER BY user_name"; return db_query($sql); }

trackers_data_get_transition (  $  group_id  )

Definition at line 1222 of file data.php. References group_id, and trackers_transition_get_update(). Referenced by trackers_data_handle_update(). { return trackers_transition_get_update($group_id); }

trackers_data_get_valid_bugs (  $  group_id = false, $  item_id = '' )

Definition at line 1264 of file data.php. { $sql="SELECT bug_id,summary ". "FROM ".ARTIFACT." ". "WHERE group_id='$group_id' ". "AND bug_id <> '$item_id' AND ".ARTIFACT.".resolution_id <> '2' ORDER BY bug_id DESC LIMIT 200"; return db_query($sql); }

trackers_data_handle_update (  $  group_id, $  item_id, $  dependent_on_task, $  dependent_on_bugs, $  dependent_on_support, $  dependent_on_patch, $  canned_response, $  vfl, &$  changes, &$  extra_addresses )

Definition at line 1385 of file data.php. References $address, $changes, $field, $field_id, $now, $result, $sql, $upd_list, $value, $vfl, cookbook_handle_update(), db_affected_rows(), db_numrows(), db_query(), db_result, exit_error(), exit_missing_param(), exit_permission_denied(), group_id, member_check(), member_create_tracker_flag(), summary, trackers_data_add_history(), trackers_data_get_field_id(), trackers_data_get_item_notification_info(), trackers_data_get_transition(), trackers_data_is_date_field(), trackers_data_is_special(), trackers_data_is_status_closed(), trackers_data_is_text_area(), trackers_data_is_text_field(), trackers_transition_update_item(), utils_cutstring(), utils_date_to_unixtime(), and utils_unconvert_htmlspecialchars().

trackers_data_is_custom (  $  field, $  by_field_id = false )

Definition at line 515 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['custom']: $BF_USAGE_BY_NAME[$field]['custom']); }

trackers_data_is_date_field (  $  field, $  by_field_id = false )

Definition at line 621 of file data.php. References trackers_data_get_display_type(). Referenced by show_item_history(), show_item_list(), show_item_list_sober(), trackers_data_get_display_type_in_clear(), and trackers_data_handle_update(). { return(trackers_data_get_display_type($field, $by_field_id) == 'DF'); }

trackers_data_is_default_value (  $  item_fv_id  )

Definition at line 962 of file data.php. References $res, $sql, db_numrows(), and db_query(). Referenced by trackers_data_update_value(). { /* See if this field value belongs to group None (100). In this case it is a so called default value. */ $sql = "SELECT bug_field_id,value_id FROM ".ARTIFACT."_field_value WHERE bug_fv_id='$item_fv_id' AND group_id='100'"; $res = db_query($sql); return ( (db_numrows($res) >= 1) ? $res : false); }

trackers_data_is_empty_ok (  $  field, $  by_field_id = false )

Definition at line 528 of file data.php. References trackers_data_mandatory_flag(). { return trackers_data_mandatory_flag($field, $by_field_id); }

trackers_data_is_project_scope (  $  field, $  by_field_id = false )

Definition at line 651 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { return($BF_USAGE_BY_ID[$field]['scope'] == 'P'); } else { return($BF_USAGE_BY_NAME[$field]['scope'] == 'P'); } }

trackers_data_is_required (  $  field, $  by_field_id = false )

Definition at line 571 of file data.php. References $field. Referenced by trackers_data_update_usage(). { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['required']: $BF_USAGE_BY_NAME[$field]['required']); }

trackers_data_is_select_box (  $  field, $  by_field_id = false )

Definition at line 636 of file data.php. References trackers_data_get_display_type(). Referenced by show_item_history(), show_item_list(), show_item_list_sober(), and trackers_data_get_display_type_in_clear(). { return(trackers_data_get_display_type($field, $by_field_id) == 'SB'); }

trackers_data_is_showed_on_add (  $  field, $  by_field_id = false )

Definition at line 599 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['show_on_add'] & 1: $BF_USAGE_BY_NAME[$field]['show_on_add'] & 1); }

trackers_data_is_showed_on_add_members (  $  field, $  by_field_id = false )

Definition at line 615 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['show_on_add_members']: $BF_USAGE_BY_NAME[$field]['show_on_add_members']); }

trackers_data_is_showed_on_add_nologin (  $  field, $  by_field_id = false )

Definition at line 607 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['show_on_add'] & 2: $BF_USAGE_BY_NAME[$field]['show_on_add'] & 2); }

trackers_data_is_showed_on_query (  $  field  )

Definition at line 583 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['show_on_query']: $BF_USAGE_BY_NAME[$field]['show_on_query']); }

trackers_data_is_showed_on_result (  $  field  )

Definition at line 590 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['show_on_result']: $BF_USAGE_BY_NAME[$field]['show_on_result']); }

trackers_data_is_special (  $  field, $  by_field_id = false )

Definition at line 521 of file data.php. References $field. Referenced by trackers_data_handle_update(). { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['special']: $BF_USAGE_BY_NAME[$field]['special']); }

trackers_data_is_status_closed (  $  status  )

Definition at line 664 of file data.php. Referenced by trackers_data_handle_update(). { if ($status == '3') { return 1; } return 0; }

trackers_data_is_text_area (  $  field, $  by_field_id = false )

Definition at line 631 of file data.php. References trackers_data_get_display_type(). Referenced by trackers_data_get_display_type_in_clear(), and trackers_data_handle_update(). { return(trackers_data_get_display_type($field, $by_field_id) == 'TA'); }

trackers_data_is_text_field (  $  field, $  by_field_id = false )

Definition at line 626 of file data.php. References trackers_data_get_display_type(). Referenced by trackers_data_get_display_type_in_clear(), and trackers_data_handle_update(). { return(trackers_data_get_display_type($field, $by_field_id) == 'TF'); }

trackers_data_is_used (  $  field, $  by_field_id = false )

Definition at line 577 of file data.php. References $field. { global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; return($by_field_id ? $BF_USAGE_BY_ID[$field]['use_it']: $BF_USAGE_BY_NAME[$field]['use_it']); }

trackers_data_is_username_field (  $  field, $  by_field_id = false )

Definition at line 641 of file data.php. References $field, and trackers_data_get_field_name(). Referenced by show_item_list(), and show_item_list_sober(). { global $BF_USAGE_BY_ID; if ($by_field_id) { $field = trackers_data_get_field_name($field); } return(($field == 'assigned_to') || ($field == 'submitted_by')); }

trackers_data_mandatory_flag (  $  field, $  by_field_id = false )

Definition at line 533 of file data.php. References $field. Referenced by trackers_data_is_empty_ok(). { # 1 = not mandatory # 0 = relaxed mandatory (mandatory if it was to the submitter) # 3 = mandatory whenever possible global $BF_USAGE_BY_ID,$BF_USAGE_BY_NAME; if ($by_field_id) { $val = $BF_USAGE_BY_ID[$field]['custom_empty_ok']; if (!isset($val)) { $val = $BF_USAGE_BY_ID[$field]['empty_ok']; } } else { $val = $BF_USAGE_BY_NAME[$field]['custom_empty_ok']; if (!isset($val)) { $val = $BF_USAGE_BY_NAME[$field]['empty_ok']; } } return($val); }

trackers_data_post_notification_settings (  $  group_id, $  tracker_name )

Definition at line 228 of file data.php. References $feedback, $GLOBALS, $i, $res_cat, db_error(), and db_query(). { global $feedback; $local_feedback = ""; # build the variable names related to elements always present in the form # and get their values $notif_scope_name = $tracker_name."_notif_scope"; $notif_scope = $GLOBALS[$notif_scope_name]; $new_item_address_name = $tracker_name."_new_item_address"; $new_item_address = $GLOBALS[$new_item_address_name]; $send_all_changes_name = $tracker_name."_send_all_changes"; $send_all_changes = $GLOBALS[$send_all_changes_name]; $nb_categories_name = $tracker_name."_nb_categories"; $nb_categories = $GLOBALS[$nb_categories_name]; $private_exclude_address_name = $tracker_name."_private_exclude_address"; $private_exclude_address = $GLOBALS[$private_exclude_address_name]; if ($notif_scope != "global") { if ($notif_scope == "category") { $notif_value = 0; } if ($notif_scope == "both") { $notif_value = 2; } } else { $notif_value = 1; } # set global notification info for this group $res_gl=db_query("UPDATE groups SET " .$tracker_name."_glnotif='$notif_value', " ."send_all_".$tracker_name."='$send_all_changes', " ."new_".$tracker_name."_address=".($new_item_address? "'$new_item_address' " : "''").", " .$private_exclude_address_name.'='.($private_exclude_address? "'$private_exclude_address' " : "''") . " WHERE group_id=$group_id"); if (!$res_gl) { $local_feedback .= _("groups table Update failed.").' '.db_error(); } $ok = 0; if ($nb_categories > 0) { for ($i=0; $i<$nb_categories; $i++) { $current_fv_name = $tracker_name."_cat_".$i."_bug_fv_id"; $current_fv_id = $GLOBALS[$current_fv_name]; $current_email_name = $tracker_name."_cat_".$i."_email"; $current_email = $GLOBALS[$current_email_name]; # if ($current_email && !validate_email($current_email)) # { # $local_feedback .= _("[".$tracker_name."] notification address: ".$current_email." appeared Invalid"); # $current_email=''; # } $current_send_all_name = $tracker_name."_cat_".$i."_send_all_flag"; $current_send_all_flag = $GLOBALS[$current_send_all_name]; $res_cat=db_query("UPDATE ".$tracker_name."_field_value SET " ."email_ad='$current_email', " ."send_all_flag='$current_send_all_flag' " ." WHERE bug_fv_id=$current_fv_id"); if ($res_cat) { $ok++; } else { $local_feedback .= _($tracker_name."_field_value table Update failed.").' '.db_error(); } } } if (($res_gl) && ($ok == $nb_categories) && ($local_feedback == "")) { return 1; } else { if ($local_feedback != "") { fb($local_feedback); } return 0; } }

trackers_data_reset_usage (  $  field_name, $  group_id )

Definition at line 1091 of file data.php. References $feedback, $field_id, $sql, db_query(), group_id, and trackers_data_get_field_id(). { global $feedback; /* Reset a field settings to its defaults usage (values are untouched). The defaults always belong to group_id 100 (None) so make sure we don;t delete entries for group 100 */ $field_id = trackers_data_get_field_id($field_name); if ($group_id != 100) { $sql = "DELETE FROM ".ARTIFACT."_field_usage ". "WHERE group_id='$group_id' AND bug_field_id='$field_id'"; db_query($sql); fb(_("Field value successfully reset to defaults.")); } }

trackers_data_show_notification_settings (  $  group_id, $  tracker_name, $  show_intro_msg )

Definition at line 164 of file data.php. References $i, group_id, nbsp, print, and trackers_data_get_notification_settings(). { $grtrsettings = &trackers_data_get_notification_settings($group_id, $tracker_name); if (user_ismember($group_id,'A')) { if ($grtrsettings['glnotif'] == 0) { $categoryradio = "CHECKED"; $globalradio = ""; $bothradio = ""; } if ($grtrsettings['glnotif'] == 1) { $categoryradio = ""; $globalradio = "CHECKED"; $bothradio = ""; } if ($grtrsettings['glnotif'] == 2) { $categoryradio = ""; $globalradio = ""; $bothradio = "CHECKED"; } if ($grtrsettings['nb_categories'] > 0) { if ($show_intro_msg != 0) { print '<p>'.sprintf(_("As a project administrator you must decide if the list of persons to be systematically notified on new %s submissions (and possibly updates) depend on the categories or not and you must provide the corresponding email addresses (comma separated list)."), $tracker_name).'</p>'; } print ' <INPUT TYPE="RADIO" NAME="'.$tracker_name.'_notif_scope" VALUE="global" '.$globalradio.' />&nbsp;&nbsp;<span class="preinput">'._("Notify persons in the global list only").'</span><br /> <INPUT TYPE="RADIO" NAME="'.$tracker_name.'_notif_scope" VALUE="category" '.$categoryradio.' />&nbsp;&nbsp;<span class="preinput">'._("Notify persons in the category related list instead of the global list").'</span><br /> <INPUT TYPE="RADIO" NAME="'.$tracker_name.'_notif_scope" VALUE="both" '.$bothradio.' />&nbsp;&nbsp;<span class="preinput">'._("Notify persons in the category related list in addition to the global list").'</span><br /> <h4>'._("Category related lists").'</h4>'; print '<INPUT TYPE="HIDDEN" NAME="'.$tracker_name.'_nb_categories" VALUE="'.$grtrsettings['nb_categories'].'" />'; for ($i=0; $i < $grtrsettings['nb_categories'] ; $i++) { print '<INPUT TYPE="HIDDEN" NAME="'.$tracker_name.'_cat_'.$i.'_bug_fv_id" VALUE="'.$grtrsettings['category'][$i]['fv_id'].'" />'; print '<span class="preinput">'.$grtrsettings['category'][$i]['name'].'</span><br />&nbsp;&nbsp;<INPUT TYPE="TEXT" NAME="'.$tracker_name.'_cat_'.$i.'_email" VALUE="'.$grtrsettings['category'][$i]['email'].'" SIZE="50" MAXLENGTH="255" /> &nbsp;&nbsp;<span class="preinput">( <INPUT TYPE="CHECKBOX" NAME="'.$tracker_name.'_cat_'.$i.'_send_all_flag" VALUE="1" '. (($grtrsettings['category'][$i]['send_all_flag'])?'checked="checked"':'') .' />'._("Send on all updates").')</span><br /> '; } print '<h4>'._("Global list").'</h4>'; } else { if ($show_intro_msg != 0) { print '<p>'.sprintf(_("As a project administrator you must decide if the list of persons to be systematically notified on new %s submissions (and possibly updates) depend on the categories or not and you must provide the corresponding email addresses (comma separated list)."), $tracker_name).'</p>'; } } print '<span class="preinput">'._("Global List:").'</span><br />&nbsp;&nbsp;<INPUT TYPE="TEXT" NAME="'.$tracker_name.'_new_item_address" VALUE="'.$grtrsettings['glnewad'].'" SIZE="50" MAXLENGTH="255" /> &nbsp;&nbsp;<span class="preinput">(<INPUT TYPE="CHECKBOX" NAME="'.$tracker_name.'_send_all_changes" VALUE="1" '. (($grtrsettings['glsendall'])?'CHECKED':'') .'>'._("Send on all updates").')</span>'; print '<h4>'._("Private items exclude list").'</h4>'; if ($show_intro_msg != 0) { print '<p>'._("Addresses registered in this list will be excluded from default mail notification for private items.").'</p>'; } print '<span class="preinput">'._("Exclude List:").'</span><br />&nbsp;&nbsp;<INPUT TYPE="TEXT" NAME="'.$tracker_name.'_private_exclude_address" VALUE="'.$grtrsettings['private_exclude'].'" SIZE="50" MAXLENGTH="255" /><br />'; } }

trackers_data_update_usage (  $  field_name, $  group_id, $  label, $  description, $  use_it, $  rank, $  display_size, $  empty_ok, $  keep_history, $  show_on_add_members = 0, $  show_on_add = 0, $  transition_default_auth = 'A' )

Definition at line 1110 of file data.php. References $field_id, $result, $rows, $sql, db_affected_rows(), db_numrows(), db_query(), trackers_data_get_field_id(), and trackers_data_is_required(). { /* Update a field settings in the trackers_usage_table Rk: All the show_on_xxx boolean parameters are set to 0 by default because their values come from checkboxes and if not checked the form variable is not set at all. It must be 0 to be ok with the SQL statement */ # if it's a required field then make sure the use_it flag is true if (trackers_data_is_required($field_name)) { $use_it = 1; } $field_id = trackers_data_get_field_id($field_name); # if it's a custom field then take label into account else store NULL # if (trackers_data_is_custom($field_name)) { $lbl = isset($label) ? "'$label'" : 'NULL'; $desc = isset($description) ? "'$description'" : 'NULL'; $disp_size = isset($display_size) ? "'$display_size'" : 'NULL'; $empty = isset($empty_ok) ? "'$empty_ok'" : 'NULL'; $keep_hist = isset($keep_history) ? "'$keep_history'" : 'NULL'; # } else { # $lbl = $desc = $disp_size = $empty = $keep_hist = "NULL"; # } # See if this field usage exists in the table for this project $sql = 'SELECT bug_field_id FROM '.ARTIFACT.'_field_usage '. "WHERE bug_field_id='$field_id' AND group_id='$group_id'"; $result = db_query($sql); $rows = db_numrows($result); # if it does exist then update it else insert a new usage entry for this field. if ($rows) { $sql = 'UPDATE '.ARTIFACT.'_field_usage '. "SET use_it='$use_it',show_on_add='$show_on_add',". "show_on_add_members='$show_on_add_members',place='$rank', ". "custom_label=$lbl, custom_description=$desc,". "custom_display_size=$disp_size, custom_empty_ok=$empty,". "custom_keep_history=$keep_hist, ". "transition_default_auth='$transition_default_auth' ". "WHERE bug_field_id='$field_id' AND group_id='$group_id'"; $result = db_query($sql); } else { $sql = 'INSERT INTO '.ARTIFACT.'_field_usage '. "VALUES ('$field_id','$group_id','$use_it','$show_on_add',". "'$show_on_add_members','$rank',$lbl,$desc,$disp_size,$empty,$keep_hist,'$transition_default_auth')"; $result = db_query($sql); } if (db_affected_rows($result) < 1) { fb(_("Update of field usage failed."), 1); } else { fb(_("Field usage updated.")); } }

trackers_data_update_value (  $  item_fv_id, $  field, $  group_id, $  value, $  description, $  order_id, $  status = 'A' )

Definition at line 1041 of file data.php. References $feedback, $result, $sql, db_affected_rows(), db_fetch_array(), db_query(), group_id, and trackers_data_is_default_value(). { global $feedback,$ffeedback; /* Insert a new value for a given field for a given group */ # An empty field value is not allowed if (preg_match ("/^\s*$/", $value)) { fb(_("Empty field value not allowed"), 0); return; } # Updating a bug field value that belong to group 100 (None) is # forbidden. These are default values that cannot be changed so # make sure to copy the default values first in the project context first if ($res = trackers_data_is_default_value($item_fv_id)) { trackers_data_copy_default_values($field,$group_id); $arr = db_fetch_array($res); $where_cond = 'bug_field_id='.$arr['bug_field_id']. ' AND value_id='.$arr['value_id']." AND group_id='$group_id' "; } else { $where_cond = "bug_fv_id='$item_fv_id' AND group_id<>'100'"; } # Now perform the value update $sql = "UPDATE ".ARTIFACT."_field_value ". "SET value='$value',description='$description',order_id='$order_id',status='$status' ". "WHERE $where_cond"; $result = db_query($sql); #print "<BR>DBG - $sql"; if (db_affected_rows($result) < 1) { fb(_("Update of field value failed.")); } else { fb(_("New field value updated.")); } }

trackers_data_use_field_predefined_values (  $  field, $  group_id )

Definition at line 501 of file data.php. References $field_id, $result, $sql, db_numrows(), db_query(), and trackers_data_get_field_id(). { # Check whether a group field values are the default one or not. # If no entry in the database for the relevant field value belong to the # group, then it uses default values (fallback) $field_id = trackers_data_get_field_id($field); $sql="SELECT bug_fv_id FROM ".ARTIFACT."_field_value ". "WHERE group_id=".$group_id." AND bug_field_id=$field_id"; $result = db_query($sql); return db_numrows($result); }

---