# 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/>.

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

	# $Id: print_all_bug_page_word.php,v 1.65.2.1 2007-10-13 22:34:17 giallu Exp $

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

?>

	# Word 2000 export page

	# The bugs displayed in print_all_bug_page.php are saved in a .doc file

	# The IE icon allows to see or directly print the same result

?>

	require_once( 'core.php' );

	$t_core_path = config_get( 'core_path' );

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

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

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

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

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

?>

	$f_type_page	= gpc_get_string( 'type_page', 'word' );

	$f_search		= gpc_get_string( 'search', false ); # @@@ need a better default

	$f_offset		= gpc_get_int( 'offset', 0 );

	$f_export		= gpc_get_string( 'export' );

	$f_show_flag	= gpc_get_bool( 'show_flag' );

	helper_begin_long_process();

	# word or html export

	if ( $f_type_page != 'html' ) {

		$t_export_title = helper_get_default_export_filename( '' );

		$t_export_title = ereg_replace( '[\/:*?"<>|]', '', $t_export_title );

		# Make sure that IE can download the attachments under https.

		header( 'Pragma: public' );

		header( 'Content-Type: application/msword' );

		if ( preg_match( "/MSIE/", $_SERVER["HTTP_USER_AGENT"] ) ) {

                        header( 'Content-Disposition: attachment; filename="' . urlencode( $t_export_title ) . '.doc"' );

                } else {

                        header( 'Content-Disposition: attachment; filename="' . $t_export_title . '.doc"' );

                }

	}

	# This is where we used to do the entire actual filter ourselves

	$t_page_number = gpc_get_int( 'page_number', 1 );

	$t_per_page = -1;

	$t_bug_count = null;

	$t_page_count = null;

	$result = filter_get_bug_rows( $t_page_number, $t_per_page, $t_page_count, $t_bug_count );

	$row_count = sizeof( $result );

?>

xmlns:w="urn:schemas-microsoft-com:office:word"

xmlns="http://www.w3.org/TR/REC-html40">

	//$t_bug_arr_sort[$row_count]=-1;

	$f_bug_arr = explode_enum_string( $f_export );

	for( $j=0; $j < $row_count; $j++ ) {

		# prefix bug data with v_

		extract( $result[$j], EXTR_PREFIX_ALL, 'v' );

		# display the available and selected bugs

		if ( in_array( $v_id, $f_bug_arr ) || ( $f_show_flag==0 ) ) {

            $t_last_updated = date( $g_short_date_format, $v_last_updated );

            # grab the bugnote count

            $bugnote_count = bug_get_bugnote_count( $v_id );

            # grab the project name

            $t_project_name = project_get_field( $v_project_id, 'name' );

            # bug text infos

            $t_bug_text_table = config_get( 'mantis_bug_text_table' );

            $query3 = "SELECT *

                FROM $t_bug_text_table

                WHERE id='$v_bug_text_id'";

            $result3 = db_query( $query3 );

            $row = db_fetch_array( $result3 );

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

            $v_os 						= string_display( $v_os );

            $v_os_build					= string_display( $v_os_build );

            $v_platform					= string_display( $v_platform );

            $v_version 					= string_display( $v_version );

            $v_summary 					= string_display_links( $v_summary );

            $v2_description 			= string_display_links( $v2_description );

            $v2_steps_to_reproduce 		= string_display_links( $v2_steps_to_reproduce );

            $v2_additional_information 	= string_display_links( $v2_additional_information );

            ### note that dates are converted to unix format in filter_get_bug_rows

?>

		:

		:

		:

		:

		:

		:

		:

		:

		:

			if ( access_has_bug_level( config_get( 'view_handler_threshold' ), $v_id ) ) {

				print_user_with_subject( $v_handler_id, $v_id ); 

			}

		?>

		:

		:

		:

		:

		:

		:

		:

		:

			if ( !config_get( 'enable_relationship' ) ) {

				echo lang_get( 'duplicate_id' );

			} # MASC RELATIONSHIP

		?> 

			if ( !config_get( 'enable_relationship' ) ) {

				print_duplicate_id( $v_duplicate_id );

			} # MASC RELATIONSHIP

		?> 

		:

$t_related_custom_field_ids = custom_field_get_linked_ids( $v_project_id );

foreach( $t_related_custom_field_ids as $t_id ) {

	$t_def = custom_field_get_definition( $t_id );

?>

		:

}       // foreach

?>

		:

		:

		:

		:

	# account profile description

	if ( $v_profile_id > 0 ) {

	   $t_user_prof_table = config_get( 'mantis_user_profile_table' );

		$query4 = "SELECT description

				FROM $t_user_prof_table

				WHERE id='$v_profile_id'";

		$result4 = db_query( $query4 );

		$t_profile_description = '';

		if ( db_num_rows( $result4 ) > 0 ) {

			$t_profile_description = db_result( $result4, 0 );

		}

		$t_profile_description = string_display( $t_profile_description );

?>

	} # profile description

?>

		:

	        $t_bug_file_table = config_get( 'mantis_bug_file_table' );

			$query5 = "SELECT filename, filesize, date_added

					FROM $t_bug_file_table

					WHERE bug_id='$v_id'";

			$result5 = db_query( $query5 );

			$num_files = db_num_rows( $result5 );

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

				$row = db_fetch_array( $result5 );

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

				$v2_filename = file_get_display_name( $v2_filename );

				$v2_filesize = round( $v2_filesize / 1024 );

				$v2_date_added = date( config_get( 'normal_date_format' ), db_unixtimestamp( $v2_date_added ) );

				switch ( $g_file_upload_method ) {

					case DISK:	PRINT "$v2_filename ($v2_filesize KB) $v2_date_added";

							break;

					case DATABASE:	PRINT "$v2_filename ($v2_filesize KB) $v2_date_added";

							break;

				}

				if ( $i != ( $num_files - 1 ) ) {

					PRINT '
';

				}

			}

		?>

	# get the bugnote data

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

 		$t_restriction = 'AND view_state=' . VS_PUBLIC;

 	} 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' );

	$query6 = "SELECT *

			FROM $t_bugnote_table

			WHERE bug_id='$v_id' $t_restriction

			ORDER BY date_submitted $t_bugnote_order";

	$result6 = db_query( $query6 );

	$num_notes = db_num_rows( $result6 );

?>

	# no bugnotes

	if ( 0 == $num_notes ) {

	?>

		else { # print bugnotes ?>

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

			# prefix all bugnote data with v3_

			$row = db_fetch_array( $result6 );

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

			$v3_date_submitted = date( config_get( 'normal_date_format' ), ( db_unixtimestamp( $v3_date_submitted ) ) );

			$v3_last_modified = date( config_get( 'normal_date_format' ), ( db_unixtimestamp( $v3_last_modified ) ) );

			# grab the bugnote text and id and prefix with v3_

			$query6 = "SELECT note, id

					FROM $t_bugnote_text_table

					WHERE id='$v3_bugnote_text_id'";

			$result7 = db_query( $query6 );

			$v3_note = db_result( $result7, 0, 0 );

			$v3_bugnote_text_id = db_result( $result7, 0, 1 );

			$v3_note = string_display_links( $v3_note );

	?>

				()

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

				} ?>

					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 ) . '
';

						default:

							echo $v3_note;

					}

				?>

		} # end for

	} # end else

?>

echo '

';

		} # end in_array

}  # end main loop

?>