/*********************************************************************************
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program 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 Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/


var groups_arr=new Array();
var chartTypesHolder = []; // storage for removed chart items
var groups_count=-1;
var filters_arr=new Array();
var filters_count_map=new Object();
var filters_count = -1;
var current_filter_id = -1;
var groups_count_map=new Object();
var current_group_id = -1;
var join_refs = new Array();
var group_field = null;
var has_group = null;
var global_report_def = null;
var goto_anchor = '';
// holds all the fields from current and joined tables
var all_fields = new Object();

var full_table_list = new Object();
full_table_list.self = new Object();
full_table_list.self.parent = '';
full_table_list.self.value = document.EditView.self.options[document.EditView.self.options.selectedIndex].value;
full_table_list.self.module = document.EditView.self.options[document.EditView.self.options.selectedIndex].value;
full_table_list.self.label = document.EditView.self.options[document.EditView.self.options.selectedIndex].text;
full_table_list.self.children = new Object();

function hideCheckGroups() {
	document.getElementById('checkGroups').style.display = 'none';
}

function table_changed(obj) {
	if(document.EditView.report_type[1].checked) {
		if(typeof hideCheckGroupsTimeout != 'undefined') clearTimeout(hideCheckGroupsTimeout);
		document.getElementById('checkGroups').style.display = '';
		hideCheckGroupsTimeout = window.setTimeout('hideCheckGroups()', 6000);
	}
	
	current_module = document.EditView.self.options[document.EditView.self.options.selectedIndex].value;
	if(obj.options[obj.selectedIndex].value == '') { // None was selected, delete the link
		delete_this_join(obj.id);
		return;
	}
	
	// Set the master table list to the current value
	full_table_list[obj.id].value = obj.value;
	full_table_list[obj.id].label = obj.options[obj.options.selectedIndex].text;
	
	if ( obj.id != 'self' )	{
		// Get the link definitions, and store them
		var parent_id = full_table_list[obj.id].parent;
		var parent_module = full_table_list[parent_id].module;
		var parent_link_defs = getLinksByRelType(module_defs[parent_module].link_defs);
		
		full_table_list[obj.id].link_def = parent_link_defs[full_table_list[obj.id].value];
		//full_table_list[obj.id].rel_def = rel_defs[full_table_list[obj.id].link_def.relationship_name];
		//full_table_list[obj.id].module = full_table_list[obj.id].label;
		full_table_list[obj.id].module = getRelatedModule(full_table_list[obj.id].link_def);

		full_table_list[obj.id].link_def.table_key = obj.id;
	}
	else {
		full_table_list[obj.id].module = obj.value;
	}

	if ( document.getElementById('report_results') != null ) {
		document.getElementById('report_results').style.display='none';
	}
	delete_join_rows(obj.id);
	//alert("I'm done deleting the join rows");
	if ( obj.id == 'self' ) {
		// We are deleting the main entry, nuke everything
		reload_join_rows();
		deleteAllFilters();
		deleteAllGroups(0);
		reload_columns();
	}
	else {
		joinChecked(obj);
	}

	remakeGroups();

	document.EditView.sort_by.value = '';
	document.EditView.sort_dir.value = '';
	document.EditView.summary_sort_by.value = '';
	document.EditView.summary_sort_dir.value = '';
}

function showDetailsClicked(obj) {
	if (obj.checked) {
		document.getElementById('columns_table').style.display='';
		document.getElementById('columns_more_div').style.display='';
 	}
 	else {
		document.getElementById('columns_table').style.display='none';
		document.getElementById('columns_more_div').style.display='none';
	}
}

function deleteFilter(index) {
	var this_row = filters_arr[filters_count_map[index]].row;
	this_row.parentNode.removeChild(this_row);
	filters_arr.splice(filters_count_map[index],1);

	for ( id in filters_count_map) {
		if (filters_count_map[id] > filters_count_map[index]) {
			filters_count_map[id]--;
		}
	}
}

function deleteGroup(index) {
	if(typeof(groups_count_map[index]) == 'undefined' || typeof(groups_arr[groups_count_map[index]]) == 'undefined') {
		return;
	}

	var this_row = groups_arr[groups_count_map[index]].row;
	this_row.parentNode.removeChild(this_row);
	groups_arr.splice(groups_count_map[index],1);

	for ( id in groups_count_map) {
		if (groups_count_map[id] > groups_count_map[index]) {
			groups_count_map[id]--;
		}
	}
	
	var group_by_button = document.getElementById('group_by_button');
	group_by_button.style.display = 'inline';	
	
	// add back line charts
	if(groups_arr.length == 1 && document.EditView.chart_type.options.length > 5) {
		chartTypesHolder.push(document.EditView.chart_type.options[5]);
		document.EditView.chart_type.options[5] = null;
	}
	reload_columns('add');
}

function getReportType() {
	for (i=0;i < document.EditView.report_type.length;i++) {
		if ( document.EditView.report_type[i].checked == true) {
			return document.EditView.report_type[i].value;
		}
	}
}

function reportTypeChanged() {
	var report_type = getReportType();

	var columns_table = document.getElementById('columns_table');
	var summary_table = document.getElementById('summary_table');

	if ( report_type == 'summary') {
		document.getElementById('tab_li_chart_options_tab').style.display='';
		document.getElementById('tab_link_chart_options_tab').style.display='';
		document.getElementById('tab_li_group_by_tab').style.display='';
		document.getElementById('tab_link_group_by_tab').style.display='';
		document.getElementById('tab_link_columns_tab').innerHTML = SUGAR.language.get('Reports', 'LBL_4_CHOOSE') ;
		document.getElementById('summary_table').style.display='';
		document.getElementById('summary_more_div').style.display='';
		document.getElementById('columns_table').style.display='none';
		document.getElementById('columns_more_div').style.display='none';
		document.getElementById('group_by_div').style.display='';

		if (document.EditView.show_details.checked)  {
			document.getElementById('columns_table').style.display='';
			document.getElementById('columns_more_div').style.display='';
		}
		else {
			document.getElementById('columns_table').style.display='none';
			document.getElementById('columns_more_div').style.display='none';
		}
	}
	else if ( report_type == 'tabular' ) {
		document.getElementById('tab_li_chart_options_tab').style.display='none';
		document.getElementById('tab_link_chart_options_tab').style.display='none';
		document.getElementById('tab_li_group_by_tab').style.display='none';
		document.getElementById('tab_link_group_by_tab').style.display='none';
		document.getElementById('tab_link_columns_tab').innerHTML = SUGAR.language.get('Reports', 'LBL_3_CHOOSE') ;

		document.getElementById('columns_table').style.display='';
		document.getElementById('columns_more_div').style.display='';
		document.getElementById('summary_table').style.display='none';
		document.getElementById('summary_more_div').style.display='none';
		document.getElementById('group_by_div').style.display='none';
	}
	document.getElementById('report_results').style.display='none';
	refresh_chart_tab();
}

function manyColumnSelectChanged(index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];
	refreshFilterColumn(filter_row.column_select,default_filter,index);
	refreshFilterQualify(filter_row.column_select,default_filter,index);
	refreshFilterInput(default_filter,index);
}

function moduleSelectChanged(index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];
	refreshFilterColumn(filter_row.column_select,default_filter,index);
	refreshFilterQualify(filter_row.column_select,default_filter,index);
	refreshFilterInput(default_filter,index);
}

function moduleSelectChangedGroup(index) {
	current_group_id = index;
	var group_row = groups_arr[groups_count_map[index]];
	refreshGroupColumn(group_row.column_select,default_group,index);
	refreshGroupQualify(group_row.column_select,default_group,index);
	reload_columns('add');
}

function columnSelectChanged(index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];
	refreshFilterQualify(filter_row.column_select,default_filter,index);
	refreshFilterInput(default_filter,index);
}

function columnSelectGroupChanged(index) {
	current_group_id = index;
	var group_row = groups_arr[groups_count_map[index]];
	refreshGroupQualify(group_row.column_select,default_group,index);
	reload_columns('add');
}

function refreshGroupQualify(obj,group,index) {
	current_group_id = index;
	var group_row = groups_arr[groups_count_map[index]];
	group_row.qualify_cell.removeChild(group_row.qualify_select);
	addGroupQualify(group_row.qualify_cell,group);
}

function refreshFilterQualify(obj,filter,index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];
	filter_row.qualify_cell.removeChild(filter_row.qualify_select);
	addFilterQualify(filter_row.qualify_cell,filter);
}

function refreshFilterColumn(obj,filter,index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];
	filter_row.column_cell.removeChild(filter_row.column_select);
	addColumnSelectFilter(filter_row.column_cell,filter);
}

function refreshGroupColumn(obj,group,index) {
	current_group_id = index;
	var group_row = groups_arr[groups_count_map[index]];
	group_row.column_cell.removeChild(group_row.column_select);
	addColumnSelectGroup(group_row.column_cell,group);
}

function refreshFilterModule(obj,filter,index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];
	filter_row.module_cell.removeChild(filter_row.module_select);
	addModuleSelectFilter(filter_row.module_cell,filter);
}

function refreshGroupModule(obj,group,index) {
	current_group_id = index;
	var group_row = groups_arr[groups_count_map[index]];
	group_row.module_cell.removeChild(group_row.module_select);
	addModuleSelectGroup(group_row.module_cell,group);
}

function filterTypeChanged(index) {
	var filter = {input_name0:''};
	refreshFilterInput(filter,index);
}

function refreshFilterInput(filter,index) {
	current_filter_id = index;
	var filter_row = filters_arr[filters_count_map[index]];

	if (typeof (filter_row.input_field0) != 'undefined' && typeof (filter_row.input_field0.value) != 'undefined') {
		type = "input";
	}

	filter_row.input_cell.removeChild(filter_row.input_cell.firstChild);
	addFilterInput(filter_row.input_cell,filter);
}

function addColumnSelectGroup(cell,group) {
	var select_html_info = new Object();
	var options = new Array();
	var select_info = new Object();
	select_info['name'] = 'group';
	select_info['onchange'] = 'columnSelectGroupChanged('+current_group_id+');';
	select_html_info['select'] = select_info;

	var module_select = groups_arr[groups_count_map[current_group_id]].module_select;
	var table_key = module_select.options[module_select.selectedIndex].value;

	if (table_key == 'self') {
		selected_module = current_module;
		field_defs = module_defs[selected_module].group_by_field_defs;
	}
	else {
		selected_module = table_key;
		var field_defs = module_defs[full_table_list[table_key].module].group_by_field_defs;
 	}

	var field_defs_arr = getOrderedFieldDefArray(field_defs,true);

	var selected = false;
	var got_selected = 0;
	for(var index in field_defs_arr) {
	    var field = field_defs_arr[index];
		if ( field.type == 'text' || ( current_db_type == 'oci8' && field.type == 'name' && typeof (field.fields) != 'undefined' )) {
			continue;
		}

    var key = table_key+":"+field.name;

    if ( typeof(all_fields[key]) == 'undefined') {
		continue;
    }

    if ( group.column_name == key) {
    	got_selected = 1;
		selected = true;
    } 
    else {
		selected = false;
    }
		var option_info = new Object();
		option_info['value'] = key;
		option_info['text'] = field.vname;
		option_info['selected'] = selected;
		options[options.length] = option_info;
	}

	if ( got_selected == 0) {
		options[0]['selected'] = true;
	}
	select_html_info['options'] = options;
	cell.innerHTML=buildSelectHTML(select_html_info);
	groups_arr[groups_count_map[current_group_id]].column_select = cell.getElementsByTagName('select')[0];
}

function addModuleSelectFilter(cell,filter) {
	var select_html_info = new Object();
	var options = new Array();
	var select_info = new Object();
	select_info['name'] = 'filter';
	select_info['onchange'] = 'moduleSelectChanged('+current_filter_id+');';
	select_html_info['select'] = select_info;

	var link_defs = getSelectedLinkDefs();

	var option_info = new Object();
	option_info['value'] = 'self';
	option_info['text'] = module_defs[current_module].label;
	option_info['selected'] = selected;
	options[options.length] = option_info;

	var parts = filter.column_name.split(':');
	var selected_link_name = parts[0];

	for(var i in link_defs) {
		var linked_field = link_defs[i];
		var selected = false;
		if ( i == selected_link_name) {
				selected=true;
		} 
		else {
				selected=false;
		}

		// re-selected the remembered select (if there was one)

		var option_info = new Object();
		option_info['value'] = i;
		var label = linked_field['label'];
		if ( i != 'self' ) {
			label = full_table_list[full_table_list[i].parent].label + ' &gt; '+ label;
		}
		option_info['text'] = label;
		option_info['selected'] = selected;
		options[options.length] = option_info;
	}

	select_html_info['options'] = options;
	cell.innerHTML=buildSelectHTML(select_html_info);
	filters_arr[filters_count_map[current_filter_id]].module_select = cell.getElementsByTagName('select')[0];
}

function addModuleSelectGroup(cell,filter) {
	var select_html_info = new Object();
	var options = new Array();
	var select_info = new Object();
	select_info['name'] = 'group';
	select_info['onchange'] = 'moduleSelectChangedGroup('+current_group_id+');';
	select_html_info['select'] = select_info;

	var link_defs = getSelectedLinkDefs();
	var option_info = new Object();
	option_info['value'] = 'self';
	option_info['text'] = module_defs[current_module].label;
	option_info['selected'] = selected;
	options[options.length] = option_info;

	var parts = filter.column_name.split(':');
	var selected_link_name = parts[0];

	for(var i in  link_defs) {
		var linked_field = link_defs[i];
		var selected = false;
		if ( i == selected_link_name) {
			selected=true;
		} 
		else {
			selected=false;
		}

		// re-selected the remembered select (if there was one)
		var option_info = new Object();
		option_info['value'] = i;
		var label = linked_field['label'];
		if ( i != 'self' ) {
			label = full_table_list[full_table_list[i].parent].label + ' &gt; '+ label;
		}

		option_info['text'] = label;
		option_info['selected'] = selected;
		options[options.length] = option_info;
	}

	select_html_info['options'] = options;
	cell.innerHTML=buildSelectHTML(select_html_info);
	groups_arr[groups_count_map[current_group_id]].module_select = cell.getElementsByTagName('select')[0];
}

function getOrderedFieldDefArray(field_defs,show_id_field) {
	var field_defs_arr = new Array();
	var id_field = null;

	for(field_name in field_defs) {
		var field = field_defs[field_name];
		field_defs_arr.push(field);
	}
	
	field_defs_arr.sort( _sort_by_field_name);

	if ( id_field  != null && show_id_field ) {
		field_defs_arr.unshift(id_field);
	}
	return field_defs_arr;
}

function _sort_by_field_name(a,b) {
	if ( typeof(a['vname']) == 'undefined') {
		a['vname'] = a['name'];
	} 
	else if ( typeof(b['vname']) == 'undefined') {
		b['vname'] = b['name'];
	}
	
	if ( a['type'] == 'name' ||  a['type'] == 'user_name' ) {
		return -1;
	} 
	else if ( b['type'] == 'name' ||  b['type'] == 'user_name' ) {
		return 1;
	} 
	else { 
		return a['vname'].localeCompare( b['vname']);
	}
}

function addColumnSelectFilter(cell,filter) {
	var select_html_info = new Object();
	var options = new Array();
	var select_info = new Object();
	var field_defs = new Object();

	select_info['name'] = 'filter';
	select_info['onchange'] = 'columnSelectChanged('+current_filter_id+');';
	select_html_info['select'] = select_info;

	var module_select = filters_arr[filters_count_map[current_filter_id]].module_select;
	var table_key = module_select.options[module_select.selectedIndex].value;
	if (table_key == 'self') {
		selected_module = current_module;
		field_defs = module_defs[selected_module].field_defs;
	} 
	else {
		selected_module = table_key;
		var field_defs = module_defs[full_table_list[table_key].module].field_defs;
	}

	var field_defs_arr = getOrderedFieldDefArray(field_defs,true);

	var	selected = false;
	for(var index in field_defs_arr) {
		var field = field_defs_arr[index];
		var key = table_key+":"+field.name;
		if ( typeof(all_fields[key]) == 'undefined') {
			continue;
		}

		if ( field.type  == 'time') {
			continue;
		}

		if ( filter.column_name == key) {
			selected = true;
		} 
		else {
			selected = false;
		}
		var option_info = new Object();
		option_info['value'] = key;
		option_info['text'] = field.vname;
		option_info['selected'] = selected;
		options[options.length] = option_info;
	}

	select_html_info['options'] = options;
	cell.innerHTML=buildSelectHTML(select_html_info);
	filters_arr[filters_count_map[current_filter_id]].column_select = cell.getElementsByTagName('select')[0];
}


function addFilterInput(cell,filter) {
	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	var qualifier_name = filter_row.qualify_select.options[filter_row.qualify_select.selectedIndex].value;
	var module_select = filter_row.module_select;
	var table_key = module_select.options[module_select.selectedIndex].value;
	filter.table_key = table_key;
	var module_select = filters_arr[filters_count_map[current_filter_id]].module_select;
	var table_key = module_select.options[module_select.selectedIndex].value;
	if (table_key == 'self') {
	    selected_module = current_module;
		var field_defs = module_defs[selected_module].field_defs;
	}
	else {
		selected_module = table_key;
		var field_defs = module_defs[full_table_list[table_key].module].field_defs;
 	}

	if ( typeof ( qualifier_name) == 'undefined' ||  qualifier_name == '') {
		qualifier_name='equals';
	}

	var column_name = filter_row.column_select.options[filter_row.column_select.selectedIndex].value;

	if ( typeof ( column_name) == 'undefined' || column_name == '') {
		column_name='';
	}
	var field = all_fields[column_name].field_def;	

	var field_type = field.type;
	if ( typeof(field.custom_type) != 'undefined') {
		field_type = field.custom_type;
	}
	cell.innerHTML = "<table><tr></tr></table>";

	var row = cell.getElementsByTagName("tr")[0];

	if (qualifier_name == 'between') {
		addFilterInputTextBetween(row,filter);
	} 
	else if (qualifier_name == 'between_dates') {
		addFilterInputDateBetween(row,filter);
	} 
	else if (qualifier_name == 'empty' || qualifier_name == 'not_empty') {
	    addFilterNoInput(row,filter);
 	}
	else if (field_type == 'date' || field_type == 'datetime') {
		if (qualifier_name.indexOf('tp_') == 0) {
			addFilterInputEmpty(row,filter);
		}
		
		else {
			addFilterInputDate(row,filter);
		}
	} 
	else if (field_type == 'id' || field_type == 'name' ) {
		if ( qualifier_name == 'is') {
			addFilterInputRelate(row,field,filter);
		} 
		else {
			addFilterInputText(row,filter);
		}
	} 
	else if ((field_type == 'user_name')||(field_type == 'assigned_user_name')) {
		if(users_array=="") {
			loadXML();
		}
		if (qualifier_name == 'one_of') {
			addFilterInputSelectMultiple(row,users_array,filter);
		}
		else {
			addFilterInputSelectSingle(row,users_array,filter);
		}
	} 
	else if (field_type == 'enum' || field_type == 'multienum') {
		if (qualifier_name == 'one_of') {
			addFilterInputSelectMultiple(row,field.options,filter);
		}
		else {
			addFilterInputSelectSingle(row,field.options,filter);
		}
	}
	else if (field_type=='bool') {
        var no = new Object();
        no['value'] = 'yes';
        no['text'] = SUGAR.language.languages.app_list_strings.checkbox_dom[1];
        var yes = new Object();
        yes['value'] = 'no';
        yes['text'] = SUGAR.language.languages.app_list_strings.checkbox_dom[2];
        var options = [ yes, no ];
        addFilterInputSelectSingle(row,options,filter);
    }
	else {
		addFilterInputText(row,filter);
	}

	return row;
}

function loadXML() {
	var gURL = 'index.php?module=Reports&action=fillUserCombo';
	if (window.XMLHttpRequest) { // code for Mozilla, Safari, etc 
		xmlhttp=new XMLHttpRequest();
		if (xmlhttp.overrideMimeType) {
			xmlhttp.overrideMimeType('text/xml');
		}	
		xmlhttp.open("GET", gURL, false);
		xmlhttp.onreadystatechange=loadUsers;
		xmlhttp.send(null);
		loadUsers();
	} 
	else if (window.ActiveXObject) { //IE 
		xmlhttp=new ActiveXObject('Microsoft.XMLHTTP'); 
		if (xmlhttp) {
			xmlhttp.onreadystatechange=loadUsers;
			xmlhttp.open('GET', gURL, false);
			xmlhttp.send();
		}
	}
}

function loadUsers() {
	if (xmlhttp.readyState==4) { 
		if(xmlhttp.status==200 || xmlhttp.status==0){ 
			if (window.ActiveXObject)
				xmlhttp.responseXML.loadXML(xmlhttp.responseText);

			var acc = xmlhttp.responseXML.getElementsByTagName('data');
			var opts = '';
			for (var i=0;i<acc.length;i++)
			{	
				val = getNodeValue(acc[i],'datavalue');
				users_array[users_array.length] = eval("("+val+")");
			}
		}
	}
}

function getNodeValue(obj,tag) {
	return obj.getElementsByTagName(tag)[0].firstChild.nodeValue;
}

function addFilterInputText(row,filter) {
	var cell = document.createElement("td");
	var new_input = document.createElement("input");
	new_input.type="text";
	if ( typeof (filter.input_name0) == 'undefined') {
		filter.input_name0 = '';
	}
	new_input.value=filter.input_name0;
	new_input.name="text_input";
	new_input.size="30";
	new_input.maxsize="255";
	new_input.visible="true";
	cell.appendChild(new_input);
	row.appendChild(cell);
	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	filter_row.input_field0 = new_input;
	filter_row.input_field1 = null;
}


function to_display_date(date_str) {
	var date_arr = date_str.match(/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})/);
	if ( date_arr != null) {
		var new_date = new String(cal_date_format);
    	new_date = new_date.replace("%Y",date_arr[1]);
    	new_date = new_date.replace("%m",date_arr[2]);
    	new_date = new_date.replace("%d",date_arr[3]);
    	return new_date;
 	} 
 	else {
    	return date_str;
 	}
}

function addFilterInputDate(row,filter) {
	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var new_input = document.createElement("input");
	new_input.type="text";

	if ( typeof (filter.input_name0) != 'undefined' && filter.input_name0.length > 0) {
		filter.input_name0 = to_display_date(filter.input_name0);
 	}

	new_input.value=filter.input_name0;
	new_input.name="text_input";
	new_input.size="30";
	new_input.maxsize="255";
	new_input.visible="true";
	new_input.setAttribute('id','jscal_field'); 
	cell.appendChild(new_input);
	row.appendChild(cell);

	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var img_element = document.createElement("img");
	img_element.setAttribute('src','index.php?entryPoint=getImage&themeName='+SUGAR.themes.theme_name+'&imageName=jscalendar.gif'); 
	img_element.setAttribute('id','jscal_trigger'); 
	cell.appendChild(img_element);
	row.appendChild(cell);
	Calendar.setup ({
		inputFieldObj : new_input , 
		buttonObj : img_element, 
		ifFormat : cal_date_format, 
		showsTime : false, 
		singleClick : true, step : 1,
		weekNumbers:false
	});

	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	filter_row.input_field0 = new_input;
	filter_row.input_field1 = null;
}

function addFilterNoInput(row,filter) {
	var cell = document.createElement("td");
	cell.setAttribute('valign','middle');
	var new_input = document.createElement("input");
 	new_input.type="hidden";
	new_input.value=filter.qualifier_name;
	new_input.name="text_input";
	cell.appendChild(new_input);
	row.appendChild(cell);
}

function addFilterInputEmpty(row,filter) {
	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var new_input = document.createElement("input");
	new_input.type="hidden";
	new_input.value=filter.qualifier_name;
	new_input.name="text_input";
	cell.appendChild(new_input);
	row.appendChild(cell);

	var cell = document.createElement("td");
	row.appendChild(cell);

	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	filter_row.input_field0 = new_input;
	filter_row.input_field1 = null;
}

function addFilterInputSelectMultiple(row,options,filter) {
	var cell = document.createElement('td');
	row.appendChild(cell);

	var select_html_info = new Object();
	var options_arr = new Array();
	var select_info = new Object();
	select_info['size'] = '5';
	select_info['multiple'] = true;
	select_html_info['select'] = select_info;

	var selected_map = new Object();
	for (i=0;i < filter.input_name0.length;i++) {
		selected_map[filter.input_name0[i] ] = 1;
	}

	for(i=0;i < options.length;i++) {
		var option_name;
		var option_value;
		if (typeof(options[i].text) == 'undefined') {
			option_text = options[i];
			option_value = options[i];
		}
		else if (options[i].value == '') {
			continue;
		}
		else {
			option_text = options[i].text;
			option_value = options[i].value;
		}
		if ( typeof( selected_map[option_value]) != 'undefined' ) {
			selected = true;
		}
		else {
			selected = false;
		}
		var option_info = new Object();
		option_info['value'] = option_value;
		option_info['text'] = option_text;
		option_info['selected'] = selected;
		options_arr[options_arr.length] = option_info;
	}

	select_html_info['options'] = options_arr;
	cell.innerHTML=buildSelectHTML(select_html_info)
	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	filter_row.input_field0 = cell.getElementsByTagName('select')[0];
	filter_row.input_field1 = null;
}

function addFilterInputSelectSingle(row,options,filter) {
	var cell = document.createElement('td');
	row.appendChild(cell);

	var select_html_info = new Object();
	var options_arr = new Array();
	var select_info = new Object();
	select_info['name'] = 'input';
	select_html_info['select'] = select_info;

	for(i=0;i < options.length;i++) {
		if (typeof(options[i].text) == 'undefined') {
			option_text = options[i];
			option_value = options[i];
		}
		else if (options[i].value == '') {
			continue;
		}
		else {
			option_text = options[i].text;
			option_value = options[i].value;
		}

		if (option_value == filter.input_name0 ) {
			selected = true;
		}
		else {
			selected = false;
		}
		var option_info = new Object();
		option_info['value'] = option_value;
		option_info['text'] = option_text;
		option_info['selected'] = selected;
		options_arr[options_arr.length] = option_info;
	}
	select_html_info['options'] = options_arr;
	cell.innerHTML=buildSelectHTML(select_html_info);
	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	filter_row.input_field0 = cell.getElementsByTagName('select')[0];
	filter_row.input_field1 = null;
}


function addFilterInputTextBetween(row,filter) {
	var filter_row = filters_arr[filters_count_map[current_filter_id]];

	var cell = document.createElement('td');
	var new_input = document.createElement("input");
	new_input.type="text";
	if (typeof(filter.input_name0) == 'undefined') {
		filter.input_name0 = '';
	}

	new_input.value=filter.input_name0;
	cell.appendChild(new_input);
	row.appendChild(cell);
	filter_row.input_field0 = new_input;
	
	var cell = document.createElement('td');
	var new_text = document.createTextNode(lbl_and);
	cell.appendChild(new_text);
	row.appendChild(cell);

	var cell = document.createElement('td');
	var new_input = document.createElement("input");
	new_input.type="text";
	if (typeof(filter.input_name1) == 'undefined') {
		filter.input_name1 = '';
	}

	new_input.value=filter.input_name1;
	cell.appendChild(new_input);
	row.appendChild(cell);
	filter_row.input_field1 = new_input;
}

function addFilterInputDateBetween(row,filter) {
	var filter_row = filters_arr[filters_count_map[current_filter_id]];

	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var new_input = document.createElement("input");
	new_input.type="text";
	if (typeof(filter.input_name0) == 'undefined') {
		filter.input_name0 = '';
	}
	
	filter.input_name0 = to_display_date(filter.input_name0);
	new_input.value=filter.input_name0;
	new_input.name="text_input";
	new_input.size="12";
	new_input.maxsize="255";
	new_input.visible="true";
	new_input.setAttribute('id','jscal_field'); 
	cell.appendChild(new_input);
	row.appendChild(cell);
	filter_row.input_field1 = new_input;

	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var img_element = document.createElement("img");
	img_element.setAttribute('src','index.php?entryPoint=getImage&themeName='+SUGAR.themes.theme_name+'&imageName=jscalendar.gif'); 
	img_element.setAttribute('id','jscal_trigger'); 
	cell.appendChild(img_element);
	row.appendChild(cell);

	Calendar.setup ({ 
		inputFieldObj : new_input , 
		buttonObj : img_element, 	
		ifFormat : cal_date_format, 
		showsTime : false, 
		singleClick : true,
		weekNumbers:false,
		step : 1 });

    var cell = document.createElement('td');
	cell.setAttribute('valign','middle'); 
    var new_text = document.createTextNode(lbl_and);
    cell.appendChild(new_text);
    row.appendChild(cell);

	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var new_input = document.createElement("input");
	new_input.type="text";
	if (typeof(filter.input_name1) == 'undefined') {
		filter.input_name1 = '';
	}
	filter.input_name1 = to_display_date(filter.input_name1);
	new_input.value=filter.input_name1;
	new_input.name="text_input";
	new_input.size="12";
	new_input.maxsize="255";
	new_input.visible="true";
	new_input.setAttribute('id','jscal_field2'); 
	cell.appendChild(new_input);
	row.appendChild(cell);
	filter_row.input_field1 = new_input;

	var cell = document.createElement("td");
	var img_element = document.createElement("img");
	img_element.setAttribute('src','index.php?entryPoint=getImage&themeName='+SUGAR.themes.theme_name+'&imageName=jscalendar.gif'); 
	img_element.setAttribute('id','jscal_trigger2'); 
	cell.appendChild(img_element);
	row.appendChild(cell);
	Calendar.setup ({ 
		inputFieldObj : new_input , 
		buttonObj : img_element, 	
		ifFormat : cal_date_format, 
		showsTime : false, 
		singleClick : true,
		weekNumbers:false,
		step : 1 });
}



var current_parent = '';
var current_parent_id = '';

function set_current_parent(name,value) {
	current_parent.value = name;
	current_parent_id.value = value;
}

function getModuleInFilter(filter) {
	// select the first one if first time load
	var selected_module = current_module;
	//current_prefix = module_defs[selected_module].label;
	current_prefix = 'self';
	var view_join = filter.module_cell.getElementsByTagName('select')[0];
	var selected_option = view_join.options[view_join.selectedIndex].value;
	if ( selected_option != 'self') {
		selected_module = full_table_list[selected_option].module;
	} 

	return selected_module;
}

function set_form_return_reports(popup_reply_data) {
	var form_name = popup_reply_data.form_name;
	var name_to_value_array = popup_reply_data.name_to_value_array;
	var passthru_data = popup_reply_data.passthru_data;
	
 	current_parent_id.value = name_to_value_array['id'];
 	current_parent.value = name_to_value_array['name'];
}

function addFilterInputRelate(row,field,filter) {
	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	var module_name=getModuleInFilter(filter_row);
	var field_name= module_name+":"+field.name;
	var field_id_name= module_name+":"+field.name+":id";

	var cell = document.createElement('td');
	var id_input = document.createElement("input");
	id_input.setAttribute('type','hidden');
	id_input.setAttribute("name", field_id_name);
	id_input.setAttribute("id", field_id_name);
	if ( typeof (filter.input_name0) == 'undefined') {
		filter.input_name0 = '';
	}
	id_input.setAttribute("value",filter.input_name0); 
	cell.appendChild(id_input);
	filter_row.input_field0 = id_input;

	var name_input = document.createElement("input");
	name_input.setAttribute("type","text"); 
	name_input.setAttribute("readonly","true"); 
	name_input.setAttribute("name", field_name);
	name_input.setAttribute("id", field_name);
	if ( typeof (filter.input_name1) == 'undefined') {
		filter.input_name1= '';
	}
	name_input.setAttribute("value",filter.input_name1); 
	cell.appendChild(name_input);
	filter_row.input_field1 = name_input;

	row.appendChild(cell);

	var cell = document.createElement('td');
	var new_input = document.createElement("input");
	new_input.title= lbl_select+"[Alt+G]";
	new_input.accessKey="G";
	new_input.type="button";
	new_input.value=lbl_select; 
	new_input.name=field.module;
	new_input.setAttribute("class","button"); 
	new_input.onclick= function () { 	        
		current_parent = name_input; 	 
		current_parent_id = id_input; 	 
		return	open_popup(module_name, 600, 400, "", true, false, { "call_back_function":"set_form_return_reports", "form_name":"EditView", "field_to_name_array":{ "id":"id", "name":"name" } });
	}

	cell.appendChild(new_input);

	row.appendChild(cell);
}


function addGroupQualify(cell, group) {
	var group_row = groups_arr[groups_count_map[current_group_id]];
	var column_name = group_row.column_select.options[group_row.column_select.selectedIndex].value;
	var module_select = group_row.module_select;
	var table_key = module_select.options[module_select.selectedIndex].value;
	if (table_key == 'self') {
	selected_module = current_module;
	} 
	else {
	  selected_module = full_table_list[table_key].module;
	}

	var field;

	if (typeof(column_name) == 'undefined' || column_name == '') {
		field = all_fields['self:name'].field_def;	
	} 
	else {
		field = all_fields[column_name].field_def;	
	}

	var field_type = field.type;

	if ( typeof(field.custom_type) != 'undefined') {
		field_type = field.custom_type;
	}

	var style = 'display: inline';
	if (field_type != 'date' && field_type != 'datetime') {
		style='display: none';
	}

	var select_html_info = new Object();
	var options = new Array();
	var select_info = new Object();
	select_info['name'] = 'qualify';
	select_info['style'] = style;
	select_info['onChange'] = 'reload_columns(\'add\');';
	select_html_info['select'] = select_info;

	var selected = false;

	for(i=0;i < date_group_defs.length; i++) {
		if ( ( typeof(group.qualifier_name) != 'undefined' && date_group_defs[i].name == group.qualifier_name) || (typeof(group.qualifier) != 'undefined' && date_group_defs[i].name == group.qualifier) ) {
			selected = true;
		}
		else {
			selected = false;
		}
		var option_info = new Object();
		option_info['value'] =  date_group_defs[i].name;
		option_info['text'] =  date_group_defs[i].value;
		option_info['selected'] = selected;
		options[options.length] = option_info;
	}

	select_html_info['options'] = options;
	var html =buildSelectHTML(select_html_info);
	cell.innerHTML=html;
	group_row.qualify_select = cell.getElementsByTagName('select')[0];
}

function addFilterQualify(cell, filter) {
	var filter_row = filters_arr[filters_count_map[current_filter_id]];
	var field_key = filter_row.column_select.options[filter_row.column_select.selectedIndex].value;

	var field = new Object();
	if (typeof(field_key) != 'undefined' && field_key != '') {
		field = all_fields[field_key].field_def;	
	}

	var select_html_info = new Object();
	var options = new Array();
	var select_info = new Object();
	select_info['name'] = 'qualify';
	select_info['onchange'] = "filterTypeChanged("+current_filter_id+");";
	select_html_info['select'] = select_info;

	field_type = field.type;

	if ( typeof(field.custom_type) != 'undefined') {
		field_type = field.custom_type;
	}

	var qualifiers = filter_defs[field_type];
	var selected = false;

	for(i=0;i < qualifiers.length; i++) {
		if (qualifiers[i].name == filter.qualifier_name) {
			selected = true;
		}
		else {
			selected = false;
		}
		var option_info = new Object();
		option_info['value'] =  qualifiers[i].name;
		option_info['text'] =  qualifiers[i].value;
		option_info['selected'] = selected;
		options[options.length] = option_info;
	}

	select_html_info['options'] = options;
	cell.innerHTML=buildSelectHTML(select_html_info);

	filter_row['qualify_select'] = cell.getElementsByTagName('select')[0];
}

var default_group = {column_name:''};

function addGroupByFromButton(group) {
  addGroupBy(group);
  reload_columns('add');
}

function addGroupBy(group) {
	groups_arr[groups_arr.length] = new Object();
	groups_count++;
	groups_count_map[groups_count] = groups_arr.length - 1;
	current_group_id = groups_count;

	if ( typeof (group) == 'undefined') {
		group = default_group;
	}
	group.column_name = group.table_key+":"+group.name;

	var the_table = document.getElementById('group_by_tbody');
	var row = document.createElement('tr');
 	groups_arr[groups_count_map[groups_count]].row = row;
	row.valign="top";

	var module_cell = document.createElement('td');
 	module_cell.valign="top";
	row.appendChild(module_cell);
	groups_arr[groups_count_map[groups_count]].module_cell = module_cell;
	addModuleSelectGroup(module_cell,group);

    var column_cell = document.createElement('td');
	column_cell.valign="top";
	row.appendChild(column_cell);
	groups_arr[groups_count_map[groups_count]].column_cell = column_cell;
	var new_select = addColumnSelectGroup(column_cell,group);

	var qualify_cell = document.createElement('td');
	qualify_cell.valign="top";
	row.appendChild( qualify_cell);
	groups_arr[groups_count_map[groups_count]].qualify_cell = qualify_cell;
	var new_filter = addGroupQualify(qualify_cell,group);

	var cell = document.createElement('td');
	cell.innerHTML = "<input type=button onclick=\"deleteGroup("+groups_count+");\" class=button value="+lbl_remove+">";
	row.appendChild(cell);

	the_table.appendChild(row);
	
	if(groups_arr.length == 1 && document.EditView.chart_type.options.length > 5) {
		chartTypesHolder.push(document.EditView.chart_type.options[5]);
		document.EditView.chart_type.options[5] = null;
	}
	else if(groups_arr.length == 2){
		document.EditView.chart_type.options[5] = chartTypesHolder.pop();		
	}
}

var default_filter = {column_name:'',qualifier_name:'',input_name0:'',input_name1:''};

function addFilter(filter) {
	filters_arr[filters_arr.length] = new Object();
	filters_count++;
	filters_count_map[filters_count] = filters_arr.length - 1;
	current_filter_id = filters_count;
	if ( typeof(filter) == 'undefined') {
		filter = default_filter;
	}

	var the_table = document.getElementById('filters');
	var row = document.createElement('tr');
	filters_arr[filters_count_map[filters_count]].row = row;
	row.valign="top";

	var module_cell = document.createElement('td');
	module_cell.valign="top";
	row.appendChild(module_cell);
	filters_arr[filters_count_map[filters_count]].module_cell = module_cell;
	addModuleSelectFilter(module_cell,filter);

	var column_cell = document.createElement('td');
	column_cell.valign="top";
	row.appendChild(column_cell);
	filters_arr[filters_count_map[filters_count]].column_cell = column_cell;
	addColumnSelectFilter(column_cell,filter);

	var qualify_cell = document.createElement('td');
	qualify_cell.valign="top";
	row.appendChild(qualify_cell);
	filters_arr[filters_count_map[filters_count]].qualify_cell = qualify_cell;
	addFilterQualify(qualify_cell,filter);

	var input_cell = document.createElement('td');
	input_cell.valign="top";
	row.appendChild(input_cell);
	filters_arr[filters_count_map[filters_count]].input_cell = input_cell;
	addFilterInput(input_cell,filter);

	var cell = document.createElement('td');
	cell.valign="top";
	row.appendChild(cell);

	var cell = document.createElement('td');
	cell.innerHTML = "<input type=button onclick=\"deleteFilter("+filters_count+");\" class=button value='"+lbl_remove+"'>";
	row.appendChild(cell);

	the_table.appendChild(row);
}

function deleteAllFilters() {
	var the_table = document.getElementById('filters');
	var rows = the_table.rows;
	for (i=rows.length - 1; i >= 0;i--) {
		the_table.removeChild(rows[i]);
	}
	return;
}

function deleteAllGroups(index) {
	if (typeof(groups_arr[groups_count_map[index]])!='undefined') {
		var this_row = groups_arr[groups_count_map[index]].row;
		this_row.parentNode.removeChild(this_row);
		groups_arr.splice(groups_count_map[index],1);
	
		for ( id in groups_count_map) {
			if (groups_count_map[id] > groups_count_map[index]) {
				groups_count_map[id]--;
			}
		}
		
		var group_by_button = document.getElementById('group_by_button');
		group_by_button.style.display = 'inline';
	}
	return;
}



function remakeGroups() {
	document.EditView['report_offset'].value=0;
	if (typeof(document.EditView.show_columns) != 'undefined' && document.EditView.show_columns.checked){
		module_defs[current_module].group_by_field_defs = new Object();
	
		for(i=0; i < object_refs['display_columns'].options.length ;i++)  {
			var field_name =  object_refs['display_columns'].options[i].value;
			var field_def = module_defs[current_module].field_defs[field_name];
			module_defs[current_module].group_by_field_defs[ field_def.name ] = field_def;
		}	
	}
}

function getListFieldDef(field_key) {
	var field_def = new Object();

	var vardef =  all_fields[field_key].field_def;
	if ( typeof(vardef.field_def_name) != 'undefined') {
		field_def.name = vardef['field_def_name'];
	}
	else {
		field_def.name = vardef['name'];
	}
	
	field_def.label = vardef['vname'];
	
	if ( typeof(vardef.group_function) != 'undefined' && vardef.group_function != null) {
		field_def.group_function = vardef.group_function;
	}
	if ( typeof(vardef.column_function) != 'undefined' && vardef.column_function != null) {
		field_def.column_function = vardef.column_function;
	}
	field_def.table_key = all_fields[field_key].linked_field_name;
	return field_def;
}

// called on save:
function fill_form(type) {
	var report_def = new Object();
	var form_obj = document.EditView;

  // we want an export of csv:
	if ( typeof (type) != 'undefined' && type == 'export') {
		form_obj.to_pdf.value = '';
		form_obj.to_csv.value = 'on';
	}
	var got_sort = 0;
	var got_summary_sort = 0;
	var got_summary_column = 0;
	var got_error = 0;
	var error_msgs =  lbl_missing_fields+': \n';
	report_def['report_type'] = getReportType();

	report_def.display_columns = new Array();

	var group_by_table = document.getElementById('group_by_tbody');

	if (document.EditView.show_details.checked == true || report_def.report_type=='tabular') {
	    var disp_opts = object_refs['display_columns'].options;

    	// loop thru display columns in the select element    
	    // and construct report_def for display_columns
		for(i=0; i < disp_opts.length ;i++) {
			var field_def = getListFieldDef(disp_opts[i].value);

			if(typeof(disp_opts[i].saved_text) != 'undefined') {
				field_def['label'] = disp_opts[i].saved_text;
			}
			else {
				field_def['label'] = disp_opts[i].text;
			}

			report_def.display_columns.push(field_def);

			if (form_obj.sort_by.value == disp_opts[i].value) {
				got_sort = 1;
			}			
		}
	}

	report_def.summary_columns = new Array();

	if (report_def.report_type=='summary' && object_refs['display_summary'].style.display != 'none') {
		// loop thru display columns in the select element    
		// and construct report_def for display_columns
		var sum_opts = object_refs['display_summary'].options;
		var summary_column_map = new Object();
		for(i=0; i < sum_opts.length ;i++) {
			var field_def = getListFieldDef(sum_opts[i].value);

			if (typeof(field_def.group_function) != 'undefined') {
				got_summary_column = 1;
			}

			if(typeof(sum_opts[i].saved_text) != 'undefined') {
				field_def['label'] = sum_opts[i].saved_text;
			}
			else {
				field_def['label'] = sum_opts[i].text;
			}

			summary_column_map[sum_opts[i].value] = field_def;

			report_def.summary_columns.push(field_def);

			if (form_obj.summary_sort_by.value == sum_opts[i].value) {
				got_summary_sort = 1;
			}			
   		}
	}

	// set sorting
	var sort_by = new Array();
	var summary_sort_by = new Array();
	var sort_dir = new Array();
	var summary_sort_dir = new Array();

	if (got_sort == 0 ) {
		form_obj.sort_by.value = '';
		form_obj.sort_dir.value = '';
	}
	else {
		var sort_by_elem = new Object();
		var sort_by_elem = getListFieldDef(form_obj.sort_by.value);

		sort_by_elem.sort_dir = form_obj.sort_dir.value;
		sort_by.push(sort_by_elem);

		report_def.order_by = sort_by;
	}

	if (got_summary_sort == 0 || document.EditView.show_details.checked) {
		form_obj.summary_sort_by.value = '';
		form_obj.summary_sort_dir.value = '';
	} 
	else {
		var summary_sort_by_elem = new Object();
		var key_arr = form_obj.summary_sort_by.value.split(':');

		summary_sort_by_elem.name = key_arr[1];

		if ( typeof(all_fields[ form_obj.summary_sort_by.value ].field_def.group_function) != 'undefined') {
			summary_sort_by_elem.group_function = all_fields[ form_obj.summary_sort_by.value ].field_def.group_function;
		} 
		else if ( typeof(all_fields[ form_obj.summary_sort_by.value ].field_def.column_function) != 'undefined') {
			summary_sort_by_elem.group_function = all_fields[ form_obj.summary_sort_by.value ].field_def.column_function;
		}

		summary_sort_by_elem.column_function = key_arr[2];
		summary_sort_by_elem.table_key = all_fields[ form_obj.summary_sort_by.value ].linked_field_name;
		summary_sort_by_elem.sort_dir = form_obj.summary_sort_dir.value;
		summary_sort_by.push(summary_sort_by_elem);
		report_def.summary_order_by = summary_sort_by;
	}

	var group_by_table = document.getElementById('group_by_tbody');
 	var report_type_elem = document.EditView.report_type;

	var group_defs = new Array();

	if ((document.EditView.show_details.checked || report_def['report_type'] == 'tabular' ) && object_refs['display_columns'].options.length == 0) {
		error_msgs += lbl_at_least_one_display_column+'\n';
		got_error = 1;
	}

	if (report_def['report_type'] == 'summary' &&  object_refs['display_summary'].options.length == 0 ) {
		error_msgs += lbl_at_least_one_summary_column+'\n';
		got_error = 1;
	}

	// check if all options have been filled out for related tables
	for(var wp in full_table_list) {
		if(typeof full_table_list[wp].value == 'undefined') {
			error_msgs += lbl_related_table_blank + '\n';
			got_error = 1;
			break;
		}
	}
	var filter_table = document.getElementById('filters');
	var filters_def = new Array();

	for(i=0; i < filter_table.rows.length;i++) {
		// the module select is the first cell.. we dont need that
		var cell0 = filter_table.rows[i].cells[1];
		var cell1 = filter_table.rows[i].cells[2];
		var cell2 = filter_table.rows[i].cells[3];
	
		var column_name = cell0.getElementsByTagName('select')[0].value;
		var filter_def = new Object();
		var field = all_fields[column_name].field_def;	
		filter_def.name = field.name;
		filter_def.table_key = all_fields[column_name].linked_field_name;

		column_vname = all_fields[column_name].label_prefix+": "+ field['vname'];
		filter_def.qualifier_name=cell1.getElementsByTagName('select')[0].value;
		var input_arr = cell2.getElementsByTagName('input');

		if ( typeof(input_arr[0]) !=  'undefined') {
			filter_def.input_name0=input_arr[0].value;
			if (input_arr[0].value == '') {
				got_error = 1;
				error_msgs += "\""+column_vname+"\""+lbl_missing_input_value+"\n";
			}
	
			if ( typeof(input_arr[1]) != 'undefined') {
				filter_def.input_name1=input_arr[1].value;
				if (input_arr[1].value == '') {
					got_error = 1;
					error_msgs += "\"" + column_vname + "\""+lbl_missing_second_input_value+"\n";
				}
			}
			
			if(field.type=='datetimecombo'){
				if( typeof(input_arr[2]) != 'undefined'){
					filter_def.input_name2=input_arr[2].value;
					if (input_arr[2].value == '' && input_arr[2].type != 'checkbox') {
						got_error = 1;
						error_msgs += "\"" + column_vname + "\" "+lbl_missing_input_value+"\n";
					}
				}
				if( typeof(input_arr[3]) != 'undefined'){
					filter_def.input_name3=input_arr[3].value;
					if (input_arr[3].value == '' && input_arr[3].type != 'checkbox') {
						got_error = 1;
						error_msgs += "\"" + column_vname + "\" "+lbl_missing_input_value+"\n";
					}
				}
				if( typeof(input_arr[4]) != 'undefined'){
					filter_def.input_name4=input_arr[4].value;
					if (input_arr[4].value == '' && input_arr[4].type != 'checkbox') {
						got_error = 1;
						error_msgs += "\"" + column_vname + "\" "+lbl_missing_input_value+"\n";
					}
				}
			}
		} 
		else {
			var got_selected = 0;
			var select_input = cell2.getElementsByTagName('select')[0];
			filter_def.input_name0= new Array();
			for (j=0;j<select_input.options.length;j++) {
				if (select_input.options[j].selected == true) {
					filter_def.input_name0.push(decodeURI(select_input.options[j].value));
					got_selected = 1;
				}
			}
			if (got_selected==0) {
				error_msgs += "\"" +column_vname +"\": "+lbl_missing_second_input_value+"\n";
				got_error = 1;
			}
		}

 		if ( field.type == 'datetime' || field.type == 'date') {
			if ( typeof(filter_def.input_name0) != 'undefined' && typeof(filter_def.input_name0) != 'array') {
				var date_match = filter_def.input_name0.match(date_reg_format);
				if ( date_match != null) {
					filter_def.input_name0 = date_match[date_reg_positions['Y']] + "-"+date_match[date_reg_positions['m']] + "-"+date_match[date_reg_positions['d']];
				}
			}			
			if ( typeof(filter_def.input_name1) != 'undefined' && typeof(filter_def.input_name1) != 'array') {
				var date_match = filter_def.input_name1.match(date_reg_format);
				if ( date_match != null) {
					filter_def.input_name1 = date_match[date_reg_positions['Y']] + "-"+date_match[date_reg_positions['m']] + "-"+date_match[date_reg_positions['d']];
				}
			}			
		}else if ( field.type == 'datetimecombo') {
			if ( (typeof(filter_def.input_name0) != 'undefined' && typeof(filter_def.input_name0) != 'array') && (typeof(filter_def.input_name1) != 'undefined' && typeof(filter_def.input_name1) != 'array')) {
				var date_match = filter_def.input_name0.match(date_reg_format);
				var time_match = filter_def.input_name1.match(time_reg_format);
				if ( date_match != null && time_match != null) {
					filter_def.input_name0 = date_match[date_reg_positions['Y']] + "-"+date_match[date_reg_positions['m']] + "-"+date_match[date_reg_positions['d']] + ' '+ filter_def.input_name1;
				}
			}			
			if ( typeof(filter_def.input_name2) != 'undefined' && typeof(filter_def.input_name2) != 'array' && typeof(filter_def.input_name3) != 'undefined' && typeof(filter_def.input_name3) != 'array') {
				var date_match = filter_def.input_name2.match(date_reg_format);
				var time_match = filter_def.input_name3.match(time_reg_format);
				if ( date_match != null && time_match != null) {
					filter_def.input_name2 = date_match[date_reg_positions['Y']] + "-"+date_match[date_reg_positions['m']] + "-"+date_match[date_reg_positions['d']] + ' '+ filter_def.input_name3;
				}
			}			
		}
		filters_def.push(filter_def);
	}

	if (got_error == 1) {
		alert(error_msgs);
		return false;
	}

	report_def.filters_def = filters_def;
	
	// and/or filter option
	report_def.filters_combiner = document.getElementById('filters_combiner').options[document.getElementById('filters_combiner').selectedIndex].value;
	
	var group_by_table = document.getElementById('group_by_tbody');
	var group_defs = new Array();

	if (report_def.report_type!='tabular') {
		//Loop through the group by table
	    for(i=0; i < group_by_table.rows.length;i++) {
			var cell0 = group_by_table.rows[i].cells[1];
			var cell1 = group_by_table.rows[i].cells[2];

			var group_by_def = getListFieldDef(cell0.getElementsByTagName('select')[0].value);
			var group_key = cell0.getElementsByTagName('select')[0].value;
			if ( typeof (cell1) !=  'undefined' && cell1.getElementsByTagName('select')[0].style.display != 'none') {
				group_by_def.qualifier = cell1.getElementsByTagName('select')[0].value;
			}

			//Should this column be displayed?
			if ( typeof(summary_column_map[group_key]) == 'undefined') {
				// unshift on the display summary columns this group and mark it
				report_def.summary_columns.unshift( group_by_def);
				group_by_def.is_group_by = 'hidden';
				if ( typeof(group_by_def.qualifier) != 'undefined') {
					group_by_def.column_function = group_by_def.qualifier;
				}
			}
			else {
				summary_column_map[group_key].is_group_by = 'visible';
			}

			group_defs.push(group_by_def);
		}
	}
	report_def.group_defs = group_defs;
	var links = getSelectedLinks();
	var links_def  = new Array();

	for(var i in links) {
	  	links_def.push(links[i]);
	}	

	var link_joins = getSelectedLinkJoins(links_def);
	report_def.full_table_list = full_table_list;

	report_def.module = current_module;
	report_def.report_name = document.EditView.save_report_as.value;
	report_def.chart_type = document.EditView.chart_type.value;
	report_def.chart_description = document.EditView.chart_description.value;
	report_def.numerical_chart_column = document.EditView.numerical_chart_column.value;

	global_report_def = report_def;
  	report_def.assigned_user_id = document.EditView.assigned_user_id.value;
  
	report_def_str = JSON.stringifyNoSecurity(report_def);
	form_obj.report_def.value = report_def_str;

	return true;
}

function do_export() {
	if ( fill_form('export') == true) {
		document.EditView.submit();
	}
}

function set_sort(column_name,source) {
	if ( source == 'undefined') {
		source = 'columns';
	}

	var sort_by = 'sort_by';	
	var sort_dir = 'sort_dir';	
	if ( source == 'summary') {
		sort_by = 'summary_sort_by';	
		sort_dir = 'summary_sort_dir';	
	}

	if (column_name == document.EditView[sort_by].value) {
		if (  document.EditView[sort_dir].value=="d") {
			document.EditView[sort_dir].value = "a";
		}
		else {
			document.EditView[sort_dir].value = "d";
		}
	}
	else {
		document.EditView[sort_by].value = column_name;
		document.EditView[sort_dir].value = "a";
	}
	document.EditView.to_pdf.value='';
	document.EditView.to_csv.value='';
	document.EditView['report_offset'].value=0;
	if ( fill_form() == true) {
		document.EditView.submit();
	}
}

function set_offset(offset) {
	document.EditView['report_offset'].value=offset;
	document.EditView.to_pdf.value='';
	document.EditView.to_csv.value='';
	if ( fill_form() == true) {
		document.EditView.submit();
	}
	
}

function load_page() {
	reload_joins();
    current_module = document.EditView.self.options[document.EditView.self.options.selectedIndex].value;
    reload_join_rows('regular');
    all_fields = getAllFieldsMapped(current_module);
    if(form_submit != "true")
    {
        remakeGroups();
        reload_groups();
        reload_filters();
    }
    reload_columns('regular');
}

function reload_joins() {
	for ( var index in report_def.full_table_list ) {
		var curr_table = report_def.full_table_list[index];

		if ( index != "self" ) {
			add_related(curr_table.parent,index);

			option_selectbox = document.getElementById('outer_' + index);

			if ( option_selectbox != null ) {
				if ( curr_table.optional != null && curr_table.optional == true ) {
					option_selectbox.checked = true;
				}
				else {
					option_selectbox.checked = false;
				}
			}
			else {
				//alert("option_selectbox is null (outer_" + index + ")");
			}
		}

		var curr_select = document.getElementById(index);
		curr_select.value = curr_table.value;
		full_table_list[index] = curr_table;
	}
}

function getFieldKey(field_def) {
	var func_name = '';
	if (typeof(field_def.group_function) != 'undefined') {
		func_name = field_def.group_function;
	} 
	else if (typeof(field_def.column_function) != 'undefined') {
		func_name = field_def.column_function;
	}

	if ( field_def.group_function == 'count') {
               return 'count';
	}
	else if (! (func_name == 'weighted_amount' || func_name == 'weighted_sum') && func_name != '' ) {
		return field_def.table_key+":"+field_def.name+":"+func_name;
	}
	
	return field_def.table_key+":"+field_def.name;
}


function reload_filters() {
	for(index in report_def.filters_def) {
		report_def.filters_def[index].column_name = getFieldKey(report_def.filters_def[index]);
		addFilter(report_def.filters_def[index]);
	}	
}

function reload_groups() {
	for(index in report_def.group_defs) {
		addGroupBy(report_def.group_defs[index]);
	}
}

function get_rel_type(linked_field,relationship) {
	if ( typeof(linked_field['link_type']) != 'undefined') {
		return linked_field['link_type'];
	}

	// code should never get this far.. link_type is already defined 
	
	if ( relationship.relationship_type == 'one-to-many') {
		if (linked_field.bean_is_lhs == true) {
			if ( relationship['lhs_module'] == linked_field['module']) {
				return 'one';
			} 
			else {
				return 'many';
			}
		}
		else {
			if ( relationship['rhs_module'] == linked_field['module']) {
				return 'one';
			}
			else {
				return 'many';
			}
		}
	} 
	
	return 'many';
}

function joinChecked(obj) {
	reload_columns('add');
	reload_join_rows('add');

	var objName = obj.id;
	
	// loop thru all filters, refresh module select, and reset if 
	// was selecting a module that doesnt exist in the current links
	for( var index in filters_arr) {
		current_filter_id = index;
		var filter_row = filters_arr[filters_count_map[index]];		

		// Bug 13073////
		var filter_module = filter_row.module_select[filter_row.module_select.selectedIndex].value;
		if ( objName.indexOf("_div") > -1)
			filter_module = filter_module.substr(0, objName.indexOf("_div"));
		
		// If the filter and the object refer to the same module and we aren't just adding more relations...
		// When we add more relations, the object is not a div
		if ( objName.indexOf("_div") > -1 && objName.substr(0, objName.indexOf("_div")) == filter_module) {
			deleteFilter(index);
		}
		else {
			// Bug 13124////
			var filter = {column_name:filter_row.module_select[filter_row.module_select.selectedIndex].value,
				qualifier_name:'',input_name0:'',input_name1:''};
			// Bug 13124////

			refreshFilterModule(filter_row.module_select,filter,index);		
		}	
	}

	for( var index in groups_arr) {
		current_group_id = index;
		var group_row = groups_arr[groups_count_map[index]];
		// Bug 13073////
		var group_module = group_row.module_select[group_row.module_select.selectedIndex].value;
		if ( objName.indexOf("_div") > -1)
			group_module = group_module.substr(0, objName.indexOf("_div"));

		// If the group and the object refer to the same module and we aren't just adding more relations...
		// When we add more relations, the object is not a div
		if ( objName.indexOf("_div") > -1 && objName.substr(0, objName.indexOf("_div")) == group_module) {
			deleteGroup(index);
		}
		else {
			// Bug 13124////
			var group = {column_name:group_row.module_select[group_row.module_select.selectedIndex].value};
			// Bug 13124////
			refreshGroupModule(group_row.module_select,group,index);
			refreshGroupColumn(group_row.column_select,group,index);
			refreshGroupQualify(group_row.qualify_select,group,index);
		}	

	}
}


function delete_this_join( this_id ) {
	// Get rid of my children
	delete_join_rows(this_id);

	this_obj = document.getElementById(this_id + "_div");
	this_obj.parentNode.removeChild(this_obj);

	parent_id = full_table_list[this_id].parent;

	if ( full_table_list[parent_id] != null ) {
		delete full_table_list[parent_id].children[this_id];
	}

	delete full_table_list[this_id];
	joinChecked(this_obj);
}

function delete_join_rows( parent_id ) {
	// Reset the selected fields
	all_fields = new Array();
	
	if ( full_table_list[parent_id] != null && full_table_list[parent_id].children != null ) {
		// This guy has some children
		// Make a copy of the list, javascript doesn't like iterating through a list you are modifying.
		var children_list = full_table_list[parent_id].children;

		for ( var child in children_list ) {
			// Delete the grand-children first
			delete_join_rows(child);
			// Then delete the child
			delete full_table_list[child];
			delete full_table_list[parent_id].children[child];
		}
	}

	// Clear out the HTML div that contains the children
	var children_div = document.getElementById(parent_id + "_children");
	if ( children_div != null ) {
		children_div.innerHTML = '';
		children_div.style.display = 'none';
	}
}

function add_related( parent_id, my_id ) {
	var options = new Array();
	var option_info = new Object();
	option_info['value'] = '';
	option_info['text'] = lbl_none;
	option_info['selected'] = true;
	options[options.length] = option_info;

	// Get the parent module name
	var mod_name = full_table_list[parent_id].module;
	if ( mod_name == null ) {
		alert(lbl_alert_cant_add);
		return(false);
	}			

	if ( module_defs[mod_name] == null ) {
		return(false);
	}

	// Grab the parent's link list
	var link_defs = getLinksByRelType( module_defs[mod_name].link_defs);

	var selected_linked_field;

	for (linked_field_name in link_defs) {
		var linked_field =  link_defs[linked_field_name];

		var selected = false;
		var option_info = new Object();
		option_info['text'] = linked_field['label'];
		option_info['value'] = linked_field_name;
		option_info['selected'] = false;
		options[options.length] = option_info;
	}

	var select_html_info = new Object();
	var select_info = new Object();

	// Find a free ID
	if ( my_id == null ) {
		var id_num = 0;
		while ( document.getElementById(parent_id + '_link_' + id_num ) != null ) {
			id_num++;
		}
		select_info['name'] = parent_id + '_link_' + id_num;
	}
	else {
		// Use the ID that someone gave me.
		select_info['name'] = my_id;
	}
	select_info['id'] = select_info['name'];
	select_info['onchange'] = 'table_changed(this);';
	select_html_info['select'] = select_info;

	select_html_info['options'] = options;

	// Setup the entry in the full table list
	full_table_list[select_info['id']] = new Object();
	full_table_list[select_info['id']].parent = parent_id;
	full_table_list[select_info['id']].children = new Object();

	// Add some bookkeeping so that we can properly prune the children
	full_table_list[parent_id].children[select_info['id']] = select_info['id'];

	children_div = document.getElementById(parent_id + "_children");
	if ( children_div.style.display == 'none' ) {
		// We want to add children, we should make the display visible
		children_div.style.display = '';
	}
	
	new_child_div = document.createElement('div');
	new_child_div.style.marginLeft = '10px';
	new_child_div.style.marginTop = '5px';
	new_child_div.style.marginBottom = '5px';
	
	new_child_div.innerHTML = "<b>" + LBL_RELATED + "</b>" + buildSelectHTML(select_html_info) + 
		' <a href="" class="button" style="padding: 2px; text-decoration: none;" onClick="add_related(\'' + select_info['name'] + '\'); return(false);">' + lbl_add_related + 
		'</a> <a href="" class="button" style="padding: 2px; text-decoration: none;" onClick="delete_this_join(\'' + select_info['name'] + '\'); return(false);">' + lbl_del_this + '</a> ' + 
		buildOuterJoinHTML(select_html_info) + 
		'<div style="display: none; border-left: 2px dotted #000000; padding-left: 5px;" id="' + select_info['name'] + '_children"></div>';

	new_child_div.id = select_info['name'] + '_div';
	children_div.appendChild(new_child_div);
}

function reload_join_rows( type ) {
	// This function is now blank, in case someone wants to fill it in.
}

//FIXME: Delete, this is now unused
function build_join_rows(module,joins_table,level) {
	join_refs = new Array();
	if ( typeof (level) == 'undefined') {
		level = 0;
	}
	level++;

	var link_defs = getLinksByRelType( module_defs[module].link_defs,'one');
	if ( level == 1) {

	}

	if ( level < 5 ) {
		var tr = joins_table.insertRow(joins_table.rows.length);
		var td = tr.insertCell(tr.cells.length);
		var hidden_input = '';
		join_index = 0;
		for (linked_field_name in  link_defs) {
			var linked_field = link_defs[linked_field_name];
			var input_elem =  document.createElement('input');
			input_elem.type='hidden';
			input_elem.name='link_'+linked_field['name'];
			input_elem.id='link_'+linked_field['name'];
			input_elem.value=linked_field['name'];
	
			join_index++;
	
			join_refs.push(input_elem);
			td.appendChild(input_elem);
		}
	}
	
	if ( level == 1 ) {
		var options = new Array();
		var option_info = new Object();
		option_info['value'] = '';
		option_info['text'] = lbl_none;
		option_info['selected'] = selected;
		options[options.length] = option_info;
		var link_defs = getLinksByRelType( module_defs[module].link_defs,'many');

		var selected_linked_field;
		var first = true;
		for (linked_field_name in  link_defs) {
			if (first) {
				selected_linked_field = link_defs[linked_field_name];
				first = false;
			}
			var linked_field =  link_defs[linked_field_name];
			var selected = false;
			var option_info = new Object();
			option_info['value'] = linked_field['name'];
			option_info['text'] = linked_field_name.substring(0,1).toUpperCase() + linked_field_name.substring(1,linked_field_name.length); 
			option_info['selected'] = selected;
			options[options.length] = option_info;
		}

		var select_html_info = new Object();
		var select_info = new Object();
		select_info['name'] = 'joined';
		select_info['id'] = 'multijoin';
		select_info['onchange'] = 'joinChecked(this);';
		select_html_info['select'] = select_info;

		var tr = joins_table.insertRow(joins_table.rows.length);
		var td = tr.insertCell(tr.cells.length);
		select_html_info['options'] = options;
	}
}

function getSelectedLinkJoins( link_array ) {
	var link_join_array = new Object();

	var outer_check = document.getElementById("outer_joined");
	if ( outer_check != null ) {
		link_name = document.forms.EditView.joined;
		if ( outer_check.checked ) {
			link_join_array[link_name.value] = 1;
		}
		else {
			link_join_array[link_name.value] = 0;
		}
	}

	return link_join_array;
}

function getSelectedLinks() {
	var joins_array = new Array();

	for (var index in full_table_list) {
		if ( index == 'self' ) {
			// This is the primary module, we don't want to include it
			continue;
		}
		
		if ( full_table_list[index] != null && full_table_list[index].value != '' ) {
			joins_array.push(index);
		}
	}

	return joins_array;
}

function getRelatedModule(link_def) {
	if(typeof link_def == 'undefined') {
		return;
	}
	var rel_name = link_def.relationship_name;
	var rel_def = rel_defs[rel_name];
	if(typeof(rel_def) == 'undefined') {
		return '';
	}
	if ( link_def.bean_is_lhs ) {
		return rel_def['rhs_module'];
	} 
	else {
		return rel_def['lhs_module'];
	}
}


function viewJoinChanged(obj) {
	reload_columns('join');
}

function getSelectedLinkDefs(module) {
	if ( typeof(module) == 'undefined') {
		module = current_module;	
	}
	var new_links = new Object();
	var links = getSelectedLinks()
	
	var type = 'one';
	for(var i in  links) {
		if(typeof full_table_list[links[i]].link_def == 'undefined') {
			return;
		}
		var linked_field = full_table_list[links[i]].link_def;
		
		var selected = false;
		var relationship = rel_defs[linked_field['relationship_name']];
		var rel_type = get_rel_type(linked_field,relationship);

		new_links[links[i]] = linked_field;
	}
	return new_links;
}

function moduleIsVisible(module) {
	if (typeof(visible_modules[module]) == 'undefined') {
		return false;
	}
	return true;
}

function getLinksByRelType(link_defs,type) {
	var new_links = new Object();
	for(var i in link_defs) {
		var linked_field = link_defs[i];
		
		var module = getRelatedModule(linked_field);
		if (! moduleIsVisible(module)) {
			continue;
		}
		
		var selected = false;
		var relationship = rel_defs[linked_field['relationship_name']];
		var rel_type = get_rel_type(linked_field,relationship);

		if (typeof(type) == 'undefined' || rel_type == type) { 
			new_links[i] = link_defs[i];
		}
	}
	return new_links;
}

//create a unique key for each reportable field across tables

function getAllFieldsMapped(module) {
	var all_fields = new Array();
	var summary_fields_str = '';

	for(var k in module_defs[module].field_defs) {
		all_fields["self:"+module_defs[module].field_defs[k].name] = {"field_def": module_defs[module].field_defs[k],"linked_field_name":"self","label_prefix":module_defs[module].label};
	}
	
	for(var k in module_defs[module].summary_field_defs) {
		all_fields["self:"+module_defs[module].summary_field_defs[k].name] = {"field_def": module_defs[module].summary_field_defs[k],"linked_field_name":"self","label_prefix":module_defs[module].label};
			summary_fields_str+='|'+"self:"+module_defs[module].summary_field_defs[k].name;
	}

	all_fields["count"] = all_fields["self:count"];

	var link_defs = getSelectedLinkDefs(module);


	for(var i in link_defs) {
		var join_module = getRelatedModule(link_defs[i]);
		if ( typeof(module_defs[join_module]) == 'undefined') {
			continue;
		}
		
		for( var j in module_defs[join_module].field_defs) {
			all_fields[i+":"+module_defs[join_module].field_defs[j].name] = {"field_def": module_defs[join_module].field_defs[j],"linked_field_name":i,"label_prefix":link_defs[i].label};
		}

		for(var j in module_defs[join_module].summary_field_defs) {
			var sum_field_def = module_defs[join_module].summary_field_defs[j];

			// dont include custom fields on the second level.. yet
			if ( typeof( sum_field_def.field_def_name) != 'undefined') {
				var field_def = module_defs[join_module].field_defs[sum_field_def.field_def_name];
				if ( typeof( field_def.custom_type) != 'undefined') {
					continue;
				}
			}
			all_fields[i+":"+module_defs[join_module].summary_field_defs[j].name] ={"field_def": module_defs[join_module].summary_field_defs[j],"linked_field_name":i,"label_prefix":link_defs[i].label};
		}
	}	

	return all_fields;
}

// this is called on doubleclick of the columns selector
function doRename(obj) { 
	var label = prompt("Rename label:\n"+obj.default_label,obj.text);
	if ( label != null) {
		obj.text = label;
		obj.saved_text = label;
	}
}

function saveLabel(type, obj) {
	if(type == 'column') {
		var columns_ref = object_refs['display_columns'];	
	}
	else if(type == 'detailsummary'){
		var columns_ref = object_refs['display_summary'];	
	}
	else {
		return;	
	}

	if(typeof(obj.lastIndex) != 'undefined' &&  obj.lastIndex != -1 ){
		var current_option = columns_ref.options[obj.lastIndex];
	 	current_option.text =  obj.value + '  [' +  current_option.default_label + ']';
	 	current_option.saved_text = obj.value;
	 }
	 else{
	 	this.value = '';
	 	this.lastIndex = -1;	
	 }
}

function reload_columns( reload_type) {
	document.getElementById('column_label_editor').value = '';
	if ( typeof ( reload_type ) == 'undefined') {
		reload_type = 'default';
	}

 // get the current module from the dropdown value
	current_module = document.EditView.self.options[document.EditView.self.options.selectedIndex].value;

	// get the reference to the select objects
    display_columns_ref = object_refs['display_columns'];
    hidden_columns_ref = object_refs['hidden_columns'];
    display_summary_ref = object_refs['display_summary'];
    display_summary_ref.onchange = function() { 
		var current_option = this.options[this.selectedIndex];
		document.getElementById('detailsummary_label_editor').lastIndex = this.selectedIndex;
		if(typeof(current_option.saved_text) == 'undefined') {
			document.getElementById('detailsummary_label_editor').value =current_option.text; 
		}
		else{
			document.getElementById('detailsummary_label_editor').value =current_option.saved_text; 
		}
	};

    hidden_summary_ref = object_refs['hidden_summary'];
	display_columns_ref.onchange = function() { 
		var current_option = this.options[this.selectedIndex];
		document.getElementById('column_label_editor').lastIndex = this.selectedIndex;
		if(typeof(current_option.saved_text) == 'undefined'){
			document.getElementById('column_label_editor').value =current_option.text; 
		}
		else{
			document.getElementById('column_label_editor').value =current_option.saved_text; 
		}
	};
	
    if ( reload_type == 'default' || reload_type=='regular') {
		if (reload_type == 'default') {
			visible_fields_map = new Object();
			document.EditView.show_details.checked = false;
//			document.EditView.report_type[0].checked  = true;

			document.getElementById('summary_table').style.display='none';
			document.getElementById('summary_more_div').style.display='none';
			document.getElementById('columns_table').style.display='';
			document.getElementById('columns_more_div').style.display='';
           	visible_summary_fields_org = module_defs[current_module].default_summary_columns;
					
        	visible_summary_fields = new Array();

          	for(i=0;i < visible_summary_fields_org.length;i++) {
				if ( visible_summary_fields_org[i] == 'count') {
	         		visible_summary_fields.push(  visible_summary_fields_org[i]);
				} 
				else {
	         		visible_summary_fields.push( 'self:'+ visible_summary_fields_org[i]);
				}
       	  	}
    		visible_fields = module_defs[current_module].default_table_columns;
		}

		// TODO: FIX THIS:
		
		selected_link_name = module_defs[current_module].default_link_name;
		display_columns_ref.options.length = 0;
		display_summary_ref.options.length = 0;
		hidden_columns_ref.options.length = 0;
		hidden_summary_ref.options.length = 0;
	}
	else if (reload_type == 'add' || reload_type == 'join')  {
		visible_fields = new Array();
		visible_summary_fields = new Array();

		for(i=0;i < display_columns_ref.options.length;i++) {
			visible_fields.push(display_columns_ref.options[i].value);

			if ( typeof(visible_fields_map) != 'undefined' && typeof(visible_fields_map[display_columns_ref.options[i].value]) == 'undefined' ) {
				if ( typeof (display_columns_ref.options[i].saved_text) != 'undefined') {
					visible_fields_map[display_columns_ref.options[i].value] = {"label":display_columns_ref.options[i].saved_text};
				}					
			}
		}

		for(i=0;i < display_summary_ref.options.length;i++) {
			visible_summary_fields.push(display_summary_ref.options[i].value);
			if ( typeof(visible_summary_fields_map) != 'undefined' && typeof(visible_summary_fields_map[display_summary_ref.options[i].value]) == 'undefined' ) {
				if ( typeof (display_summary_ref.options[i].saved_text) != 'undefined') {
					visible_fields_map[display_summary_ref.options[i].value] = {"label":display_summary_ref.options[i].saved_text};
				}					
			}
		}
	
		display_columns_ref.options.length = 0;
		display_summary_ref.options.length = 0;
		hidden_columns_ref.options.length = 0;
		hidden_summary_ref.options.length = 0;
	}

    var seen_visible = new Object();

	var view_join = document.EditView.view_join;
	
	var selected_link = '';
	var link_defs = getSelectedLinkDefs();

	var view_join_value = '';
	// first remember what was selected originally
	if (typeof(view_join.options) != 'undefined' && view_join.options.length > 0) {
		view_join_value = view_join.options[view_join.selectedIndex].value;
	}
	// now rebuild the select box that chooses which related table to use when showing the available fields
	view_join.options.length = 0;

	if ('self' == view_join_value) {
		selected=true;
	} 
	else {
		selected=false;
	}

	var select_counter = 0;
	view_join.options[view_join.options.length] = new Option(module_defs[current_module].label,'self',selected);


	for(var i in full_table_list) {
		if ( i == "self" ) {
			// We already added the self option above
			continue;
		}
		var table_def = full_table_list[i];
		var selected = false;
		select_counter++;

		// re-selected the remembered select (if there was one)
		if (i == view_join_value) {
			selected=true;
		} 
		else {
			selected=false;
		}

		var label = table_def['label'];
		if ( i != 'self' ) {
			label = full_table_list[full_table_list[i].parent].label + ' > '+ label;
		}

		view_join.options[view_join.options.length] = new Option(label,i,selected);
		if(selected){
			view_join.selectedIndex = select_counter;
		}
   	}

	// select the first one if first time load
	var selected_module = current_module;
	current_prefix = 'self';
	var table_key = view_join.options[view_join.selectedIndex].value;
	var field_defs = new Object();
	if ( table_key != 'self') {
		current_prefix = table_key;
		selected_module = full_table_list[table_key].module;
		field_defs = module_defs[selected_module].field_defs;
	}
	else {
        field_defs = module_defs[selected_module].field_defs;
	}

	all_fields = getAllFieldsMapped(current_module);

	for(i=0;i < visible_fields.length;i++) {
		if (typeof(all_fields[visible_fields[i]]) == 'undefined') {
             continue;
		}
		var field = all_fields[visible_fields[i]].field_def;
		var default_label = all_fields[visible_fields[i]]['label_prefix']+": "+field['vname'];
		
		if ( typeof (visible_fields_map[visible_fields[i]]) != 'undefined' &&  typeof (visible_fields_map[visible_fields[i]].label) != 'undefined') {
			display_columns_ref.options[display_columns_ref.options.length] = new Option(visible_fields_map[visible_fields[i]].label,all_fields[visible_fields[i]]['linked_field_name']+":"+all_fields[visible_fields[i]].field_def['name']);
		} 
		else {
			display_columns_ref.options[display_columns_ref.options.length] = new Option(default_label,all_fields[visible_fields[i]]['linked_field_name']+":"+all_fields[visible_fields[i]].field_def['name']);
		}
	
		var current_option = display_columns_ref.options[display_columns_ref.options.length-1];
		current_option.default_label = default_label;

		if(current_option.text != current_option.default_label){
			current_option.saved_text = current_option.text;
			current_option.text  += '  [' + default_label + ']';
		}

       seen_visible[ visible_fields[i] ] = 1;
	}
                                                                                                      
	var field_defs_arr = getOrderedFieldDefArray(field_defs,false);

	for(var index in field_defs_arr) {
        var field = field_defs_arr[index];
        var key = current_prefix +":"+field['name'];

		if ( typeof(all_fields[key]) == 'undefined') {
			continue;
		}

		if (seen_visible[key] != 1) {
			hidden_columns_ref.options[hidden_columns_ref.options.length] = new Option(field['vname'],key);
		}
	}

	var seen_visible_summary = new Object();
	var view_join_summary = document.EditView.view_join_summary;
	var selected_link_value = '';

	// first remember what was selected originally
	if (typeof(view_join_summary.options) != 'undefined' && view_join_summary.options.length > 0) {
		selected_link_value = view_join_summary.options[view_join_summary.selectedIndex].value;
	}

	// now rebuild the select box that chooses which related table to use when showing the available fields
	view_join_summary.options.length = 0;
	if ( 'self' == selected_link_value) {
		selected=true;
	}
	else {
		selected=false;
	}
	
	view_join_summary.options[view_join_summary.options.length] = new Option(module_defs[current_module].label,'self',selected);

	var summary_select_counter = 0;

	for(var i in full_table_list) {
		if ( i == "self" ) {
			// We already added the self option above
			continue;
		}

		var linked_field = full_table_list[i];
		var selected = false;

		// re-selected the remembered select (if there was one)

		if (i == selected_link_value) {
			selected=true;
		} 
		else {
			selected=false;
		}
		
		var label = linked_field['label'];
		if ( i != 'self' ) {
			label = full_table_list[full_table_list[i].parent].label + ' > '+ label;
		}
		
		summary_select_counter++;
		view_join_summary.options[view_join_summary.options.length] = new Option(label,i,selected);
		if(selected){
			view_join_summary.selectedIndex = summary_select_counter;
		}
	}

	// select the first one if first time load
	var selected_module = current_module;

	current_prefix = 'self';

	var sum_table_key = view_join_summary.options[view_join_summary.selectedIndex].value;
	if ( sum_table_key != '' && sum_table_key != 'self') {
		current_prefix = sum_table_key;
		selected_module = full_table_list[sum_table_key].module;
	}


	var valid_groups = new Object();

	var group_by_table = document.getElementById('group_by_tbody'); 

	has_group = null;

	for(i=0; i < group_by_table.rows.length;i++) {
        has_group = 1;
        var cell0 = group_by_table.rows[i].cells[1];
        var cell1 = group_by_table.rows[i].cells[2];
		var key = cell0.getElementsByTagName('select')[0].value;

		if ( typeof(all_fields[key]) == 'undefined') {
			// Not a valid field
			continue;
		}

		var group_by_def = getListFieldDef(key);

		if ( group_by_def.table_key != current_prefix) {
			continue;
		}
		var key = group_by_def.table_key+":"+group_by_def.name;
						
		if ( typeof (cell1) !=  'undefined' && cell1.getElementsByTagName('select')[0].style.display != 'none') {
			key += ":"+cell1.getElementsByTagName('select')[0].value;
		}
        
        valid_groups[key] = 1;
	}

    var field_defs = module_defs[selected_module].field_defs;
	var numerical_chart_column = document.EditView.numerical_chart_column;
	numerical_chart_column.options.length = 0;
	var which_option_selected = 0;

	for(i=0;i < visible_summary_fields.length;i++) {
		var key = visible_summary_fields[i];
		if (typeof(all_fields[key]) == 'undefined' || typeof( all_fields[key].field_def) == 'undefined') {
            continue;
		} 

		if ( current_db_type !='mysql' && (typeof(valid_groups[key]) == 'undefined' && ( typeof( all_fields[key].field_def.summary_type)  == 'undefined' 
             || all_fields[key].field_def.summary_type != 'group'))) {
			continue;
		} 

		var field = all_fields[key].field_def;
		var linked_field_name = '';
		var label_prefix = '';
		var default_label =  '';
		
		if ( field.name == 'count') {
			key = 'count';
			default_label = field['vname'];
		}
		else {
			linked_field_name = all_fields[key].linked_field_name;
			label_prefix = all_fields[key].label_prefix;
			default_label = label_prefix+": "+field['vname'];
		}

		var column_label;

		if (  typeof (visible_summary_field_map[key]) != 'undefined' && typeof (visible_summary_field_map[key].label) != 'undefined') {
	 		column_label = visible_summary_field_map[key].label;
		}
		else {
 			column_label = default_label;
		}

		display_summary_ref.options[display_summary_ref.options.length] = new Option(column_label,key);
		var split_key = key.split(':');
		var summary_field = all_fields[key].field_def;
		if ( typeof (summary_field.group_function) != 'undefined') {
			if (key == report_def['numerical_chart_column']) {
				which_option_selected = numerical_chart_column.options.length;
			}
			numerical_chart_column.options[numerical_chart_column.options.length] = new Option( column_label,key);
		}

		var current_option = display_summary_ref.options[display_summary_ref.options.length-1];
		current_option.default_label = default_label;
		if(current_option.text != current_option.default_label) {
			current_option.saved_text = current_option.text;
			current_option.text  += '  [' + default_label + ']';
		}

		seen_visible_summary[ key] = 1;
	}

	numerical_chart_column.options.selectedIndex = which_option_selected;

	var summary_field_defs = module_defs[selected_module].summary_field_defs;
  	var field_defs_arr = getOrderedFieldDefArray(field_defs,false);

	group_field = null;
	for(group_key in valid_groups) {
		if(typeof all_fields[group_key] != 'undefined') {
			group_field = all_fields[group_key].field_def;

			if (seen_visible_summary[group_key] != 1) {
				hidden_summary_ref.options[hidden_summary_ref.options.length] = new Option(group_field['vname'],group_key);
			}
			seen_visible_summary[group_key] = 1;
		}
	}

	for( var index in summary_field_defs) {
		var field = summary_field_defs[index];
		if ( field.summary_type != 'group' && current_db_type !='mysql') {
			continue;
		}

        var key = current_prefix +":"+field['name'];

		if ( field['name'] == 'count') {
			key = 'count';
		}

		if ( typeof(all_fields[key]) == 'undefined') {
			continue;
		}

		if (seen_visible_summary[key] != 1) {
			hidden_summary_ref.options[hidden_summary_ref.options.length] = new Option(field['vname'],key);
		}
	}

	if ( current_db_type == 'mysql') {
        for(var index in field_defs_arr) {
	        var field = field_defs_arr[index];
	        var key = current_prefix +":"+field['name'];

            if (seen_visible_summary[key] != 1) {
				hidden_summary_ref.options[hidden_summary_ref.options.length] = new Option(field['vname'],key);
			}
        }
	}

	refresh_chart_tab();
	var selected_chart_index = 1;
	if (reload_type == 'regular') {
		for(var i=0;i < document.EditView.chart_type.options.length; i++) {
			if (document.EditView.chart_type.options[i].value == report_def.chart_type) {
				selected_chart_index = i;
			}
		}
		document.EditView.chart_type.selectedIndex = selected_chart_index;
	}
}

function refresh_chart_tab() {
	if ( document.EditView.numerical_chart_column.options.length > 0 && has_group != null) {
		document.getElementById('no_chart_text').style.display='none';
		document.EditView.numerical_chart_column.disabled = false;
		document.EditView.chart_type.disabled = false;
		document.EditView.chart_type.selectedIndex = 1;
		document.EditView.chart_description.disabled = false;
	} 
	else {
		document.getElementById('no_chart_text').style.display='';
		document.EditView.numerical_chart_column.disabled = true;
		document.EditView.chart_type.disabled = true;
		document.EditView.chart_type.selectedIndex = 0;
		document.EditView.chart_description.disabled = true;
	}
}

function set_readonly(form) {
	if (form.save_report.checked) {
		form.save_report.value='on';
		form.save_report_as.readOnly=false;
		form.save_report_as.focus();
	}
	else {
		form.save_report.value='off';
		form.save_report_as.readOnly=true;
	}
}

// add non-standard attrs to the newly created option objects
function addSelectOptionAttrs(info,obj) {
	for(i=0; i < info['options'].length; i++) {
		option = info['options'][i];
		var attr = new Object();

		for( var j in option ) {
			if ( j != 'text' &&  j != 'value' && j != 'selected' && j != 'name' && j != 'id') {
		        obj.options[i][j] = option[j];
			}
		}
	}
}

//builds the html for a select 
function buildSelectHTML(info) {
	var text;
	text = "<select";
       
	for(var key in info['select']) {
		if ( typeof (info['select'][key]) != 'undefined') {
			text +=" "+ key +"=\""+ info['select'][key] +"\"";
		}
	}
	text +=">";
	
	var saved_attrs = new Array();

	for(i=0; i < info['options'].length; i++) {
		option = info['options'][i];
		var attr = new Object();
		for( var j in option ) {
            if ( j != 'text' &&  j != 'value' && j != 'selected' && j != 'name' && j != 'id') {
				attr[j] = option[j];
            }
		}
		saved_attrs.push(attr);
		text += "<option value=\""+encodeURI(option['value'])+"\" ";

		if ( typeof (option['selected']) != 'undefined' && option['selected']== true) {
			text += "SELECTED";
		}
		text += ">"+option['text']+"</option>";
	}
	text += "</select>";
	return text;
}

function buildOuterJoinHTML(info) {
	var text;
	var checked;

	checked = '';
	if ( report_def.link_joins != null ) {
		for ( key in report_def.link_joins ) {
			if ( report_def.link_joins[key] == 1 ) {
				checked = 'CHECKED';
			}
		}
	}
	text = " <input class='checkbox' type='checkbox' name='outer_" + info['select']['name'] + "' id='outer_" + info['select']['name'] + "' value=1 " + checked + " onChange='updateOuterJoin(this);'> " + lbl_outer_join_checkbox;
	text += '<img border="0" onmouseout="return nd();" onmouseover="return overlib(\'' + lbl_optional_help + '\', FGCLASS, \'olFgClass\', CGCLASS, \'olCgClass\', BGCLASS, \'olBgClass\', TEXTFONTCLASS, \'olFontClass\', CAPTIONFONTCLASS, \'olCapFontClass\', CLOSEFONTCLASS, \'olCloseFontClass\' );" src="' + image_path +'help.gif"/>';

	return text;
}

// This function is called when the outer join/optional checkbox is checked.
function updateOuterJoin ( obj ) {
	// Nuke the outer_ part at the front of the string, to get the table key
	table_key = obj.id.replace("outer_","");
	
	if ( obj.checked == true ) {
		full_table_list[table_key].optional = true;
	}
	else {
		full_table_list[table_key].optional = false;
	}
}

function saved_chart_drilldown(group_value,group_key,id) {
       var report_url = 'index.php?module=Reports&page=report&action=index&id='+id+'#'+group_value;
       document.location = report_url;
}

function chart_drilldown(group_value,is_saved_report,id) {
	var anch = document.getElementById(group_value);
	var elems = document.anchors;

	for(var i in elems) {
		var elem = elems[i];
		if ( typeof(elem.name) != 'undefined' && elem.name != '' && typeof(elem.id) != 'undefined' && elem.id != '' && elem.id == elem.name) {
			if ( group_value == elem.name ) {
				elem.focus();
				window.scrollBy(0,300);
			}
		}
	}
}

function expandCollapseComboSummaryDiv(divId) {
	if (document.getElementById(divId)) {
		if (document.getElementById(divId).style.display == "none") {
			document.getElementById(divId).style.display = "";
			document.getElementById("img_" + divId).innerHTML = 
				document.getElementById("img_" + divId).innerHTML.replace(/advanced_search/,"basic_search");
			document.getElementById('expanded_combo_summary_divs').value += divId + " ";
		}
		else {
			document.getElementById(divId).style.display = "none";
			document.getElementById("img_" + divId).innerHTML = 			
				document.getElementById("img_" + divId).innerHTML.replace(/basic_search/,"advanced_search");
			document.getElementById('expanded_combo_summary_divs').value = 
				document.getElementById('expanded_combo_summary_divs').value.replace(divId,"");

		}
	}
}