/** * Gets the bug note count for an issue * @param BugData $p_bug A bug object. * @return string * @access public */ function excel_format_bugnotes_count(BugData $p_bug) { # grab the bugnote count $t_bugnote_stats = bug_get_bugnote_stats($p_bug->id); if (null !== $t_bugnote_stats) { $t_bugnote_count = $t_bugnote_stats['count']; } else { $t_bugnote_count = 0; } return excel_prepare_number($t_bugnote_count); }
echo excel_format_column_title(lang_get('username')); } echo excel_format_column_title(lang_get('timestamp')); echo excel_format_column_title(lang_get('minutes')); echo excel_format_column_title(lang_get('time_tracking_time_spent')); if ($t_show_cost) { echo excel_format_column_title('cost'); } echo excel_format_column_title('note'); echo '</Row>'; foreach ($t_billing_rows as $t_billing) { echo "\n<Row>\n"; echo excel_prepare_number($t_billing['bug_id']); echo excel_prepare_string($t_billing['project_name']); echo excel_prepare_string($t_billing['bug_category']); echo excel_prepare_string($t_billing['bug_summary']); if ($t_show_realname) { echo excel_prepare_string($t_billing['reporter_realname']); } else { echo excel_prepare_string($t_billing['reporter_username']); } echo excel_prepare_string(date($t_date_format, $t_billing['date_submitted'])); echo excel_prepare_number($t_billing['minutes']); echo excel_prepare_string($t_billing['duration']); if ($t_show_cost) { echo excel_prepare_string($t_billing['cost']); } echo excel_prepare_string($t_billing['note']); echo "</Row>\n"; } echo excel_get_footer();
/** * Gets the formatted value for the specified issue id, project and custom field. * @param integer $p_issue_id The issue id. * @param integer $p_project_id The project id. * @param string $p_custom_field The custom field name (without 'custom_' prefix). * @return string The custom field value. */ function excel_format_custom_field($p_issue_id, $p_project_id, $p_custom_field) { $t_field_id = custom_field_get_id_from_name($p_custom_field); if ($t_field_id === false) { return excel_prepare_string('@' . $p_custom_field . '@'); } if (custom_field_is_linked($t_field_id, $p_project_id)) { $t_def = custom_field_get_definition($t_field_id); if ($t_def['type'] == CUSTOM_FIELD_TYPE_NUMERIC) { return excel_prepare_number(string_custom_field_value($t_def, $t_field_id, $p_issue_id)); } return excel_prepare_string(string_custom_field_value($t_def, $t_field_id, $p_issue_id)); } # field is not linked to project return excel_prepare_string(''); }