#
#
#
# get_database_info_html()
# 
# This returns the database info table used in database info, update database and build database.
# Values which are avaialble prior getting detailed database info data are set in the HTML so
# that the table can be displayed before getting all data.
#

include "templates.util.database";

subroutine(get_database_info_html(
	node profile,
	string profile_name,
	string profile_label_html), (
	
	string profile_name = node_name(profile);
	string log_format_label;
	
	if (?(profile . ".log.format.format_label") and (@(profile . ".log.format.format_label") ne "")) then (
	 	log_format_label = @(profile . ".log.format.format_label");
	)
	else (
	 	log_format_label = "-";
	);

	bool is_real_time_processing = get_is_real_time_processing(profile_name);
	string real_time_processing_label = if (!is_real_time_processing) then (lang_stats.btn.no) else (lang_stats.btn.yes);
	
	node db_server = profile . ".database.options.server";
	string db_server_type = @db_server{"type"};
	string database_name = "-";
	
	debug_message("\n#### db_server_type: " . db_server_type . "\n");
	
	string db_server_type_label = @("lang_admin.database.options.server.type." . db_server_type);
	
	if (db_server_type ne "internal_sql") then (
		database_name = @db_server{"database_name"};
	);
	
	
	'<table class="database-info" cellspacing="0" style="width:670px">';
	
	'<tbody>';
		
		# '<tr>';
		# '<th>' . lang_stats.database.database . ':</th>';
		# '<td>&nbsp;</td>';
		# '</tr>';
		
		'<tr>';
		'<th>' . lang_stats.database.server_type . ':</th>';
		'<td id="database_info:db_server_type">' . db_server_type_label . '</td>';
		'</tr>';
		
		'<tr id="database_info:db_directory:tr">';
		'<th>' . lang_stats.database.database_directory . ':</th>';
		'<td id="database_info:db_directory">-</td>';
		'</tr>';
		
		'<tr id="database_info:db_name:tr">';
		'<th>' . lang_stats.database.database_name . ':</th>';
		'<td id="database_info:db_name">' . database_name . '</td>';
		'</tr>';
		
	'</tbody>';
	
	'<tbody id="database_info:db_build_details_section" style="display:none">';
		
		'<tr>';
		'<th>' . lang_stats.database.last_modified . ':</th>';
		'<td id="database_info:db_last_modified">-</td>';
		'</tr>';
		
		'<tr>';
		'<th>' . lang_stats.database.last_operation . ':</th>';
		'<td id="database_info:db_last_operation">-</td>';
		'</tr>';
		
		'<tr>';
		'<th>' . lang_stats.database.earliest_log_entry . ':</th>';
		'<td id="database_info:db_earliest_log_entry">-</td>';
		'</tr>';
		
		'<tr>';
		'<th>' . lang_stats.database.latest_log_entry . ':</th>';
		'<td id="database_info:db_latest_log_entry">-</td>';
		'</tr>';
		
	'</tbody>';
	
	'<tbody>';
	
		'<tr>';
		'<th>' . lang_stats.database.real_time_processing . ':</th>';
		'<td id="database_info:real_time_processing">' . real_time_processing_label . '</td>';
		'</tr>';
		
	'</tbody>';
	
	'<tbody id="database_info:current_operation_section" style="display:none">';
		
		'<tr>';
		'<th>' . lang_stats.database.current_operation . ':</th>';
		'<td>';
			'<table cellspacing="0">';
			'<tr>';
			'<td style="padding:0px;border-width:0;width:1%">';
			'<img id="database_info:progress_animation_stop" src="' . fileref("picts/progress_anim_stop_2.gif") . '" width="9" height="9" alt="" />';
			'<img id="database_info:progress_animation_blink" src="' . fileref("picts/progress_anim_blink.gif") . '" width="42" height="11" alt="" style="display:none" />';
			'<img id="database_info:progress_animation_run" src="' . fileref("picts/progress_animation_2.gif") . '" width="42" height="11" alt="" style="display:none" />';
			'</td>';
			'<td id="database_info:current_operation_text" style="padding:0;padding-left:4px;border-width:0">-</td>';
			'</tr>';
			'</table>';
		'</td>';
		'</tr>';
		
	'</tbody>';
		
	'</table>';
));