# Mantis - a php based bugtracking system

# Copyright (C) 2000 - 2002  Kenzaburo Ito - kenito@300baud.org

# Copyright (C) 2002 - 2007  Mantis Team   - mantisbt-dev@lists.sourceforge.net

# Mantis is free software: you can redistribute it and/or modify

# it under the terms of the GNU General Public License as published by

# the Free Software Foundation, either version 2 of the License, or

# (at your option) any later version.

#

# Mantis is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with Mantis.  If not, see <http://www.gnu.org/licenses/>.

	#------------------------------

	#   $Revision: 2643 $

	#     $Author: al $    

	#       $Date: 2009-06-18 19:06:27 -0400 (Thu, 18 Jun 2009) $  

	#------------------------------

	# This include file prints out the list of bugnotes attached to the bug

	# $f_bug_id must be set and be set to the bug id

	$t_core_path = config_get( 'core_path' );

	require_once( $t_core_path.'current_user_api.php' );

	# grab the user id currently logged in

	$t_user_id = auth_get_current_user_id();

	if ( !access_has_bug_level( config_get( 'private_bugnote_threshold' ), $f_bug_id ) ) {

		$t_restriction = 'AND ( view_state=' . VS_PUBLIC . ' OR reporter_id = ' . $t_user_id . ')';

	} else {

		$t_restriction = '';

	}

	$t_bugnote_table		= config_get( 'mantis_bugnote_table' );

	$t_bugnote_text_table	= config_get( 'mantis_bugnote_text_table' );

	$t_bugnote_order		= current_user_get_pref( 'bugnote_order' );

	# get the bugnote data

	$query = "SELECT *

			FROM $t_bugnote_table

			WHERE bug_id='$f_bug_id' $t_restriction

			ORDER BY date_submitted $t_bugnote_order, id $t_bugnote_order";

	$result = db_query( $query );

	$num_notes = db_num_rows( $result );

?>

	collapse_open( 'bugnotes' );

?>

	# no bugnotes

	if ( 0 == $num_notes ) {

?>

		collapse_icon( 'bugnotes' ); ?>

	$t_normal_date_format = config_get( 'normal_date_format' );

	$t_total_time = 0;

	for ( $i=0; $i < $num_notes; $i++ ) {

		# prefix all bugnote data with v3_

		$row = db_fetch_array( $result );

		extract( $row, EXTR_PREFIX_ALL, 'v3' );

		if ( db_unixtimestamp( $v3_date_submitted ) != db_unixtimestamp( $v3_last_modified ) )

			$t_bugnote_modified = true;

		else

			$t_bugnote_modified = false;

		$v3_date_submitted = date( $t_normal_date_format, ( db_unixtimestamp( $v3_date_submitted ) ) );

		$v3_last_modified = date( $t_normal_date_format, ( db_unixtimestamp( $v3_last_modified ) ) );

		# grab the bugnote text and id and prefix with v3_

		$query = "SELECT note

				FROM $t_bugnote_text_table

				WHERE id='$v3_bugnote_text_id'";

		$result2 = db_query( $query );

		$row = db_fetch_array( $result2 );

		$v3_note = $row['note'];

		$v3_note = string_display_links( $v3_note );

		$t_bugnote_id_formatted = bugnote_format_id( $v3_id );

		if ( 0 != $v3_time_tracking ) {

			$v3_time_tracking_hhmm = db_minutes_to_hhmm( $v3_time_tracking );

			$v3_note_type = TIME_TRACKING;   // for older entries that didn't set the type

			$t_total_time += $v3_time_tracking;

		} else {

			$v3_time_tracking_hhmm = '';

		}

		if ( VS_PRIVATE == $v3_view_state ) {

			$t_bugnote_css		= 'bugnote-private';

			$t_bugnote_note_css	= 'bugnote-note-private';

		} else {

			$t_bugnote_css		= 'bugnote-public';

			$t_bugnote_note_css	= 'bugnote-note-public';

		}

?>

		()

			echo print_user( $v3_reporter_id );

		?>

			if ( user_exists( $v3_reporter_id ) ) {

				$t_access_level = access_get_project_level( null, $v3_reporter_id );

				echo '(', get_enum_element( 'access_levels', $t_access_level ), ')';

			} 

		?>

		[  ]

		if ( $t_bugnote_modified ) {

			echo ''.lang_get( 'edited_on').' '.$v3_last_modified.'
';

		}

		?>

			# bug must be open to be editable

			if ( !bug_is_readonly( $f_bug_id ) ) {

				$t_can_edit_note = false;

				$t_can_delete_note = false;

				# admins and the bugnote creator can edit/delete this bugnote

				if ( ( access_has_bug_level( config_get( 'manage_project_threshold' ), $f_bug_id ) ) ||

					( ( $v3_reporter_id == $t_user_id ) && ( ON == config_get( 'bugnote_allow_user_edit_delete' ) ) ) ) {

					$t_can_edit_note = true;

					$t_can_delete_note = true;

				}

				# users above update_bugnote_threshold should be able to edit this bugnote

				if ( $t_can_edit_note || access_has_bug_level( config_get( 'update_bugnote_threshold' ), $f_bug_id ) ) {

					print_button( 'bugnote_edit_page.php?bugnote_id='.$v3_id, lang_get( 'bugnote_edit_link' ) );

				}

				# users above delete_bugnote_threshold should be able to delete this bugnote

				if ( $t_can_delete_note || access_has_bug_level( config_get( 'delete_bugnote_threshold' ), $f_bug_id ) ) {

					echo " ";

					print_button( 'bugnote_delete.php?bugnote_id='.$v3_id, lang_get( 'delete_link' ) );

				}

				if ( access_has_bug_level( config_get( 'private_bugnote_threshold' ), $f_bug_id ) &&

					access_has_bug_level( config_get( 'change_view_status_threshold' ), $f_bug_id ) ) {

					if ( VS_PRIVATE == $v3_view_state ) {

						echo " ";

						print_button('bugnote_set_view_state.php?private=0&bugnote_id='.$v3_id, lang_get( 'make_public' ));

					} else {

						echo " ";

						print_button('bugnote_set_view_state.php?private=1&bugnote_id='.$v3_id, lang_get( 'make_private' ));

					}

				}

			}

		?>

			switch ( $v3_note_type ) {

				case REMINDER:

					echo '' . lang_get( 'reminder_sent_to' ) . ': ';

					$v3_note_attr = substr( $v3_note_attr, 1, strlen( $v3_note_attr ) - 2 );

					$t_to = array();

					foreach ( explode( '|', $v3_note_attr ) as $t_recipient ) {

						$t_to[] = prepare_user_name( $t_recipient );

					}

					echo implode( ', ', $t_to ) . '

';

				case TIME_TRACKING:

					if ( access_has_bug_level( config_get( 'time_tracking_view_threshold' ), $f_bug_id ) ) {

						echo '<big>', $v3_time_tracking_hhmm, '</big>

';

					}

					break;

			}

			echo $v3_note;

		?>

		} # end for loop

		if ( $t_total_time > 0 && access_has_bug_level( config_get( 'time_tracking_view_threshold' ), $f_bug_id ) ) {

			echo '', sprintf ( lang_get( 'total_time_for_issue' ), db_minutes_to_hhmm( $t_total_time ) ), '';

		}

	} # end else

?>

	collapse_closed( 'bugnotes' );

?>

	collapse_end( 'bugnotes' );

?>