Menu
▾
▴
[Mantisbt-cvs] mantisbt history_inc.php,1.6,1.7
|
From: <vb...@us...> - 2002-08-29 14:26:48
|
Update of /cvsroot/mantisbt/mantisbt
In directory usw-pr-cvs1:/tmp/cvs-serv28212
Modified Files:
history_inc.php
Log Message:
- Implemented 0002419: Include Bug History in emails
- Moved the bug history retrieval code to history_api.php
- Re-used the new api from history_api.php to implement bug history viewing and e-mailing.
Index: history_inc.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/history_inc.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- history_inc.php 29 Aug 2002 13:00:50 -0000 1.6
+++ history_inc.php 29 Aug 2002 14:26:45 -0000 1.7
@@ -11,15 +11,7 @@
<?php # Bug History BEGIN ?>
<a name="history"><p></a>
<?php
- # grab history and display by date_modified then field_name
- $query = "SELECT b.*, UNIX_TIMESTAMP(b.date_modified) as date_modified, u.username
- FROM $g_mantis_bug_history_table b
- LEFT JOIN $g_mantis_user_table u
- ON b.user_id=u.id
- WHERE bug_id='$f_id'
- ORDER BY date_modified $g_history_order, field_name ASC";
- $result = db_query( $query );
- $history_count = db_num_rows( $result );
+ $history = history_get_events_array( $f_id );
?>
<table class="width100" cellspacing="0">
<tr>
@@ -42,118 +34,24 @@
</td>
</tr>
<?php
- for ( $i=0; $i < $history_count; $i++ ) {
- $row = db_fetch_array( $result );
- extract( $row, EXTR_PREFIX_ALL, 'v' );
-
+ for ( $i=0; $i < count( $history ); $i++ ) {
$status_color = alternate_colors( $i+1, config_get( 'background_color' ) );
-
- $v_date_modified = date( config_get( 'complete_date_format' ), $v_date_modified );
-
- switch ( $v_field_name ) {
- case 'status': $v_old_value = get_enum_element( 'status', $v_old_value );
- $v_new_value = get_enum_element( 'status', $v_new_value );
- break;
- case 'severity': $v_old_value = get_enum_element( 'severity', $v_old_value );
- $v_new_value = get_enum_element( 'severity', $v_new_value );
- break;
- case 'reproducibility': $v_old_value = get_enum_element( 'reproducibility', $v_old_value );
- $v_new_value = get_enum_element( 'reproducibility', $v_new_value );
- break;
- case 'resolution': $v_old_value = get_enum_element( 'resolution', $v_old_value );
- $v_new_value = get_enum_element( 'resolution', $v_new_value );
- break;
- case 'priority': $v_old_value = get_enum_element( 'priority', $v_old_value );
- $v_new_value = get_enum_element( 'priority', $v_new_value );
- break;
- case 'eta': $v_old_value = get_enum_element( 'eta', $v_old_value );
- $v_new_value = get_enum_element( 'eta', $v_new_value );
- break;
- case 'view_state': $v_old_value = get_enum_element( 'view_state', $v_old_value );
- $v_new_value = get_enum_element( 'view_state', $v_new_value );
- break;
- case 'projection': $v_old_value = get_enum_element( 'projection', $v_old_value );
- $v_new_value = get_enum_element( 'projection', $v_new_value );
- break;
- case 'project_id': $v_old_value = project_get_field( $v_old_value, 'name' );
- $v_new_value = project_get_field( $v_new_value, 'name' );
- break;
- case 'handler_id':
- case 'reporter_id': $v_old_value = user_get_field( $v_old_value, 'username' );
- $v_new_value = user_get_field( $v_new_value, 'username' );
- break;
- }
-
- if ( NORMAL_TYPE != $v_type ) {
- switch ( $v_type ) {
- case NEW_BUG: $t_note = lang_get( 'new_bug' );
- break;
- case BUGNOTE_ADDED: $t_note = lang_get( 'bugnote_added' ) . ": " . $v_old_value;
- break;
- case BUGNOTE_UPDATED: $t_note = lang_get( 'bugnote_edited' ) . ": " . $v_old_value;
- break;
- case BUGNOTE_DELETED: $t_note = lang_get( 'bugnote_deleted' ) . ": " . $v_old_value;
- break;
- case SUMMARY_UPDATED: $t_note = lang_get( 'summary_updated' );
- break;
- case DESCRIPTION_UPDATED: $t_note = lang_get( 'description_updated' );
- break;
- case ADDITIONAL_INFO_UPDATED: $t_note = lang_get( 'additional_information_updated' );
- break;
- case STEP_TO_REPRODUCE_UPDATED: $t_note = lang_get( 'steps_to_reproduce_updated' );
- break;
- case FILE_ADDED: $t_note = lang_get( 'file_added' ) . ": " . $v_old_value;
- break;
- case FILE_DELETED: $t_note = lang_get( 'file_deleted' ) . ": " . $v_old_value;
- break;
- case BUGNOTE_STATE_CHANGED: $v_old_value = get_enum_element( 'view_state', $v_old_value );
- $t_note = lang_get( 'bugnote_view_state' ) . ": " . $v_old_value . ": " . $v_new_value;
- break;
- case BUG_MONITOR: $v_old_value = user_get_field( $v_old_value, 'username' );
- $t_note = lang_get( 'bug_monitor' ) . ": " . $v_old_value;
- break;
- case BUG_UNMONITOR: $v_old_value = user_get_field( $v_old_value, 'username' );
- $t_note = lang_get( 'bug_end_monitor' ) . ": " . $v_old_value;
- break;
- }
- }
-
- # output special cases
- if ( NORMAL_TYPE != $v_type ) {
-?>
-<tr bgcolor="<?php echo $status_color ?>">
- <td class="small-caption">
- <?php echo $v_date_modified ?>
- </td>
- <td class="small-caption">
- <?php echo $v_username ?>
- </td>
- <td class="small-caption">
-
- </td>
- <td class="small-caption">
- <?php echo $t_note ?>
- </td>
-</tr>
-<?php
- } else { # output normal changes
?>
<tr bgcolor="<?php echo $status_color ?>">
<td class="small-caption">
- <?php echo $v_date_modified ?>
+ <?php echo $history[$i]['date'] ?>
</td>
<td class="small-caption">
- <?php echo $v_username ?>
+ <?php echo $history[$i]['username'] ?>
</td>
<td class="small-caption">
- <?php echo $v_field_name ?>
+ <?php echo $history[$i]['note'] ?>
</td>
<td class="small-caption">
- <?php echo $v_old_value ?> => <?php echo $v_new_value ?>
+ <?php echo $history[$i]['change'] ?>
</td>
</tr>
<?php
- } # end if DEFAULT
} # end for loop
?>
</table>
|