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 )