salesagility_SuiteCRM/jssource/src_files/include/javascript/report_additionals.js

/**
 *
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
 *
 * SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
 * Copyright (C) 2011 - 2018 SalesAgility Ltd.
 *
 * 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 and "Supercharged by SuiteCRM" logo. If the display of the logos is not
 * reasonably feasible for technical reasons, the Appropriate Legal Notices must
 * display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
 */


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' || ( 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');
        SUGAR.util.globalEval("users_array[users_array.length] = (" + 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) {
    new_input.value = to_display_date(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("span");
  img_element.className = 'suitepicon suitepicon-module-calendar';
  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 = '';
  }

  new_input.value = to_display_date(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("span");
  img_element.className = 'suitepicon suitepicon-module-calendar';
  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 = '';
  }
  new_input.value = to_display_date(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("span");
  img_element.className = 'suitepicon suitepicon-module-calendar';
  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;
//	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 dbValue = convertReportDateTimeToDB(filter_def.input_name0, filter_def.input_name1);
        if (dbValue != '') {
          filter_def.input_name0 = dbValue;
        }
      }
      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 dbValue = convertReportDateTimeToDB(filter_def.input_name2, filter_def.input_name3);
        if (dbValue != '') {
          filter_def.input_name2 = dbValue;
        }
      }
    }
    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 = YAHOO.lang.JSON.stringify(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 ((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') {
      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);
    }
  }

  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" class="inlineHelpTip" src="' + image_path + 'help.gif" onclick="SUGAR.util.showHelpTips(this,\'' + lbl_optional_help + '\')"/>';

  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, "");

    }
  }
}