#
#
#
# build_database_fields_page()
#
#
#

include "templates.util.base_util";
include "templates.util.matching_files.matching_files_section";
include "templates.util.rebuild_db_advice.rebuild_db_advice_form";

subroutine(build_database_fields_page(
	bool is_msie_v6,
	string profile_name,
	bool is_edit,
	bool is_add,
	bool is_delete), (
	
	node item;
	
	#
	# build the log field options
	#
	
	# We only add the first select option, the log fields are populated via js
	string log_field_options_list = '<option value="" selected="selected">' . lang_admin.database_fields.select_log_field . '</option>';
	

	#
	#
	# build session_field_options_list
	#
	#
	
	node db_field_session_fields = "templates.util.list_structures.db_field_session_fields";
	string session_field_options_list = '<option value="" selected="selected">' . lang_admin.database_fields.select_session_field . '</option>';
	
	foreach item db_field_session_fields (
		session_field_options_list .= '<option value="' . node_name(item) . '">' . expand(@item) . '</option>';
	);

	
	#
	# build type options
	#
	
	node db_field_types = "templates.util.list_structures.db_field_types";
	string type_options_list = '<option value="" selected="selected">' . lang_admin.database_fields.select_type . '</option>';
	
	foreach item db_field_types (
		type_options_list .= '<option value="' . node_name(item) . '">' . @item . '</option>';
	);
	
		
	#
	# build aggregation method options
	#
	
	node aggregation_methods = "templates.util.list_structures.aggregation_methods";
	string aggregation_method_options_list = '<option value="" selected="selected">' . lang_admin.database_fields.select_aggregation_method . '</option>';
	
	foreach item aggregation_methods (
		aggregation_method_options_list .= '<option value="' . node_name(item) . '">' . @item . '</option>';
	);

	
	#
	# build field category options
	#
	
	string category_options_list = '<option value="" selected="selected">' . lang_stats.btn.none . '</option>';
	
	foreach item "field_categories" (
	
		category_options_list .= '<option value="' . node_name(item) . '">' . get_expanded_label(@item{"label"}) . '</option>';
	);


	#
	#
	#
	# Toolbar
	#
	#
	#
		
	'<div class="admin-config-toolbar">';
	'<table id="admin_config_toolbar" class="admin-config-toolbar" cellspacing="0">';
	'<tr>';
	
	build_toolbar_spacer();
	
	if (is_edit or is_add or is_delete) then (
	
		build_toolbar_button("database_fields", "save_changes");
		
		if (is_add) then (build_toolbar_button("database_fields","new_database_field"));
		if (is_add) then (build_toolbar_button("database_fields","duplicate"));
		if (is_delete) then (build_toolbar_button("database_fields","delete"));
	
		build_toolbar_button("database_fields", "undo_all_changes");
	)
	else (
		build_toolbar_view_permission_info();
	);
	
	build_right_toolbar_spacer();
	# build_toolbar_help_button("?dp+docs.technical_manual.toc");

	'</tr>';
	'</table>';
	'</div>'; # admin-config-toolbar


	#
	#
	#
	# Form section
	#
	#
	#
	

	'<div id="form_section" style="display:none">';



	#
	#
	# Option info
	#
	#

	option_info_section();
	
	
	#
	#
	# Item list
	#
	#
	
	
	build_config_item_list(lang_admin.database_fields.database_fields);


	#
	#
	#
	#
	# Item form
	#
	#
	#
	#

	
	'<div id="item_form" class="item-form">';
	
	
	#
	#
	# Item form header
	#
	#

	
	'<div class="item-form-header">';
		'<table cellspacing="0">';
		'<tr>';
		'<th>&nbsp;</th>';
		'<td><a id="identifier:toggle_identifier_btn" href="javascript:;" class="command-link-50">' . lang_admin.general.show_identifier . '</a></td>';
		'</tr>';
		'</table>';
	'</div>';


	#
	#
	# Item form body
	#
	#
		

	'<div class="item-form-body">';

	
	#
	#
	# No item form
	#
	#
	
	'<div id="no_item:form" class="no-item-form">';
	lang_admin.database_fields.no_database_field_exists;
	'</div>';
	
	
	#
	#
	#
	# Database field form
	#
	#
	#

		
	'<form id="db_fields:form" onsubmit="return false">';
	
		'<input id="node_name_ori" type="hidden" value="" />';
	
		'<table class="item-form" cellspacing="0">';
		
		'<tbody>';
		
			'<tr>';
			'<th>' . lang_admin.database_fields.field_name . ':</th>';
			'<td>';
			'<input id="db_fields:label" type="text" value="" style="width:260px;" />';
			'<div id="db_fields:label:error" class="form-error"></div>';
			'</td>';
			'</tr>';
		
	
			# Identifier (node_name) object is handled by a separate shared identifier.js file!
			'<tr id="identifier:identifier_section" style="display:none">';
			'<th>' . lang_admin.general.identifier . ':</th>';
			'<td>';
			'<input id="identifier:node_name" type="text" value="" disabled="disabled" style="width:360px;" /> ';
			'<a id="identifier:toggle_define_custom_identifier_btn" href="javascript:;" style="white-space:nowrap">' . lang_admin.general.define_custom_identifier . '</a>';
			'<div id="identifier:node_name:error" class="form-error"></div>';
			'</td>';
			'</tr>';
	
		
			'<tr>';
			'<th>' . lang_options.profile.database.fields.derivation_method.label . ':</th>';
			'<td>';
			'<select id="db_fields:derivation_method">';
			'<option value="log_field" selected="selected">' . lang_options.profile.database.fields.log_field.label . '</option>';
			'<option value="session_field">' . lang_options.profile.database.fields.session_field.label . '</option>';
			'</select>';
			'</td>';
			'</tr>';
		
			'<tr id="db_fields:log_field_section">';
			'<th>' . lang_options.profile.database.fields.log_field.label . ':</th>';
			'<td>';
			'<select id="db_fields:log_field">' . log_field_options_list . '</select>';
			'<div id="db_fields:log_field:error" class="form-error"></div>';
			'</td>';
			'</tr>';
			
			'<tr id="db_fields:session_field_section">';
			'<th>' . lang_options.profile.database.fields.session_field.label . ':</th>';
			'<td>';
			'<select id="db_fields:session_field">' . session_field_options_list . '</select>';
			'<div id="db_fields:session_field:error" class="form-error"></div>';
			'</td>';
			'</tr>';
		
		'</tbody>';
		
		'<tbody id="db_fields:field_details_section">';
		
			'<tr id="db_fields:source_database_field_section">';
			'<th>' . lang_options.profile.database.fields.source_database_field.label . ':</th>';
			'<td>';
			'<select id="db_fields:source_database_field"></select>';
			'<div id="db_fields:source_database_field:error" class="form-error"></div>';
			'</td>';
			'</tr>';
			
			'<tr>';
			'<th>' . lang_options.profile.database.fields.type.label . ':</th>';
			'<td>';
			'<select id="db_fields:type">' . type_options_list . '</select>';
			'<div id="db_fields:type:error" class="form-error"></div>';
			'</td>';
			'</tr>';
			
			'<tr>';
			'<th>' . lang_options.profile.database.fields.aggregation_method.label . ':</th>';
			'<td>';
			'<select id="db_fields:aggregation_method"> ' . aggregation_method_options_list . '</select>';
			option_info_image(is_msie_v6, "profile.database.fields.aggregation_method");
			'<div id="db_fields:aggregation_method:error" class="form-error"></div>';
			'</td>';
			'</tr>';
			
			'<tr>';
			'<th>' . lang_options.profile.database.fields.category.label . ':</th>';
			'<td><select id="db_fields:category">' . category_options_list . '</select></td>'; 
			'</tr>';
			
			'<tr id="db_fields:sql_field_length_section">';
			'<th>' . lang_options.profile.database.fields.sql_field_length.label . ':</th>';
			'<td>';
			'<input id="db_fields:sql_field_length" type="text" value="0" style="width:60px" />';
			option_info_image(is_msie_v6, "profile.database.fields.sql_field_length");
			'<div id="db_fields:sql_field_length:error" class="form-error"></div>';
			'</td>'; 
			'</tr>';
			
			'<tr id="db_fields:integer_bits_section">';
			'<th>' . lang_options.profile.database.fields.integer_bits.label . ':</th>';
			'<td>';
			'<select id="db_fields:integer_bits">';
			'<option value="0" selected="selected">' . lang_admin.database_fields.auto . '</option>';
			'<option value="8">8</option>';
			'<option value="16">16</option>';
			'<option value="32">32</option>';
			'<option value="64">64</option>';
			'</select>';
			option_info_image(is_msie_v6, "profile.database.fields.integer_bits");
			'</td>';
			'</tr>';
			
			'<tr>';
			'<th>&nbsp;</th>';
			'<td>';
			'<input id="db_fields:index" type="checkbox" checked="checked" /> ';
			'<label for="db_fields:index">' . lang_options.profile.database.fields.index.label . '</label>';
			option_info_image(is_msie_v6, "profile.database.fields.index");
			'</td>';
			'</tr>';

			'<tr id="db_fields:supress_label_section">';
			'<th class="reduced-space">' . lang_admin.database_fields.suppress_levels . '</th>';
			'<td>&nbsp;</td>';
			'</tr>';
	
			'<tr id="db_fields:supress_top_section">';
			'<th class="reduced-space">' . lang_admin.database_fields.above . ':</th>';
			'<td class="reduced-space">';
			'<input id="db_fields:suppress_top" type="text" value="0" style="width:40px" />';
			option_info_image(is_msie_v6, "profile.database.fields.suppress_top");
			'<div id="db_fields:suppress_top:error" class="form-error"></div>';
			'</td>';
			'</tr>';
			
			'<tr id="db_fields:supress_bottom_section">';
			'<th class="reduced-space">' . lang_admin.database_fields.below . ':</th>';
			'<td class="reduced-space">';
			'<input id="db_fields:suppress_bottom" type="text" value="2" style="width:40px" />';
			option_info_image(is_msie_v6, "profile.database.fields.suppress_bottom");
			'<div id="db_fields:suppress_bottom:error" class="form-error"></div>';
			'</td>';
			'</tr>';
			
			
			'<tr id="db_fields:always_include_bottom_level_items_section">';
			'<th>&nbsp;</th>';
			'<td>';
			'<input id="db_fields:always_include_bottom_level_items" type="checkbox" /> ';
			'<label for="db_fields:always_include_bottom_level_items">' . lang_options.profile.database.fields.always_include_bottom_level_items.label . '</label>';
			option_info_image(is_msie_v6, "profile.database.fields.always_include_bottom_level_items");
			'</td>';
			'</tr>';
			
		
			'<tr id="db_fields:itemnums_hash_function_section">';
			'<th>' . lang_options.profile.database.fields.itemnums_hash_function.label . ':</th>';
			'<td>';
			'<input id="db_fields:itemnums_hash_function" type="text" value="" disabled="disabled" />';
			option_info_image(is_msie_v6, "profile.database.fields.itemnums_hash_function");
			'</td>';
			'</tr>';
			
		'</tbody>';
		
		'</table>';
				
	'</form>';
		
	'</div>'; # item-form-body
	
	'</div>'; # item-form
	

	set_copyright();

	'</div>'; # form_section

	build_config_saving_info();
	
	
	#
	#
	# Add save changes - rebuild database advice message panel
	#
	#
	
	rebuild_db_advice_form("database_fields");
	
	
	#
	#
	# Get data 
	#
	#

	'<script language="JavaScript" type="text/JavaScript">dbFields.getDbFieldsData();</script>';
));