report_additionals.js

SugarCRM5.1 开源PHP客户关系管理系统

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

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

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

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

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


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

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

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

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

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

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

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

	var cell = document.createElement("td");
	cell.setAttribute('valign','middle'); 
	var img_element = document.createElement("img");
	img_element.setAttribute('src','themes/default/images/jscalendar.gif'); 
	img_element.setAttribute('id','jscal_trigger'); 
	cell.appendChild(img_element);
	row.appendChild(cell);

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

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

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

	var cell = document.createElement("td");
	var img_element = document.createElement("img");
	img_element.setAttribute('src','themes/default/images/jscalendar.gif'); 
	img_element.setAttribute('id','jscal_trigger2'); 
	cell.appendChild(img_element);
	row.appendChild(cell);
	Calendar.setup ({ 
		inputFieldObj : new_input , 
		buttonObj : img_element, 	
		ifFormat : cal_date_format, 
		showsTime : false, 
		singleClick : true, 
		step : 1 });
}



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

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

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

	return selected_module;
}

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

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

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

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

	row.appendChild(cell);

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

	cell.appendChild(new_input);

	row.appendChild(cell);
}


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

	var field;

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

	var field_type = field.type;

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

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

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

	var selected = false;

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

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

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

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

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

	field_type = field.type;

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

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

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

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

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

var default_group = {column_name:''};

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

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

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

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

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

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

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

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

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

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

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