'; } $(myDiv).append(content); $('input:radio[name=chartTheme]:nth('+theme+')').attr('checked',true); } function userselect() { /* XAXIS */ $('.x-aggrs-select').unbind("click").click(function(){ if($(this).hasClass('disabled')){ $(this).val('none'); return false; } if($(this).val()=='none') selectedData['xaxis']['agg'] = '' ; else selectedData['xaxis']['agg'] = $(this).val(); reDo(); }); $("#xaxis").unbind("click").click(function(){ if($('#xaxis-list').css('display') =='block'){ //$('#close-xaxis-list').css('display','none'); $('#xaxis-list').css('display','none'); } else{ //$('#close-xaxis-list').css('display','block'); $('#xaxis-list').css('display','block'); } return false; }); $(".xaxis-row").live("click", function(){ $('.xaxis-row').css('font-weight','normal'); $(this).addClass('xaxis-selected').css('font-weight','bold'); $("#xaxis-list").css('display','none'); //$("#close-xaxis-list").css("display","none"); $("#xaxis-name").val($(this).find('label').html()); selectedData['xaxis']['name'] = $(this).find('input.val').val(); $("#sort-list option[value='xaxis']").html($(this).find('label').html()); reDo(); }); $(".xaxis-row").live("mouseover", function() { $(this).css('box-shadow', '3px 3px 1px #888888').css('background-color','#666666').css('color','#ffffff'); }); $(".xaxis-row").live("mouseout", function() { $(this).css('box-shadow', 'none').css('background-color','#ffffff').css('color','#666666'); }); $("#close-xaxis-list").click(function() { $("#xaxis-list").css('display','none'); $(this).css("display","none"); return false; }); /*Y-AXIS*/ /*add field */ $('#addf').unbind("click").click(function(){ $("#addy-list").css("display","block"); $("#close-yaxis-list").css("display","block"); $('div#axis-select').show(); }); /*delete*/ $(".field .delete").live("click", function(){ if(fieldscounter == 1) return false; var name = $(this).siblings('.yaxis-select').val(); var agg = $(this).siblings('.aggrs-select').val(); var ind = $(this).parent().attr('title'); //delete all filters that apply to that field //and reset the field counter for all the filters that apply to following fields $('select.applyselect').each(function(){ if($(this).val() == ind){ //delete the filter $(this).parents('tr').remove(); } else if($(this).val() > ind) $(this).val($(this).val()-1); //delete the last option $(this).find('option').last().remove(); }); //delete the field header var hfd = $("#fheaders > .headerdiv").has('input.fieldsheadersval[value="'+ind+'"]'); $(hfd).remove(); //if this yaxis has no other field then delete it as well if($(this).parent().siblings().length == 2){ //delete the axis header var temp1 = $(this).parent().parent().find('.ycountval').val(); var hd = $("#yheaders > .headerdiv").has('input.yaxisheadersval[value="'+temp1+'"]'); $(hd).remove(); yaxiscounter--; $(this).parent().parent().remove(); //redo the counts if(yaxiscounter == 1){ $('.ycount').empty(); $(".ycountval").val(1); $("#yheaders > .headerdiv").find("p").html("yaxis (1)"); $("#yheaders > .headerdiv").find("input.yaxisheadersval").val(1); } else{ $('.yaxis').each(function(index){ $(this).find('.ycount').empty().html("yaxis: ("+(index+1)+")")}); $(this).find('.ycountval').val(index+1); var header = $("#yheaders > .headerdiv").get(index); $(header).find("p").html("yaxis ("+(index+1)+")"); $(header).find("input.yaxisheadersval").val(index+1); } //delete from the select the last child $('div#axis-select select option:last-child').remove(); } else{ $(this).parent().remove(); } //delete the option in sort if needed compileSortOptions(); fieldscounter--; if(fieldscounter == 1) $('.field .delete').hide(); else $('.field .delete').show(); //redo counting the fields in field/@title and field/fieldnum/html $('.field').each(function(index){ $(this).attr('title', index+1); $(this).find('.fieldnum').html(index+1); var header = $("#fheaders > .headerdiv").get(index); $(header).find("p").html("field ("+(index+1)+")"); $(header).find("input.fieldsheadersval").val(index+1); }); reDo(); }); /*change agg*/ $('.aggrs-select').live("change", function(){ if($(this).hasClass('disabled')){ $(this).val('none'); return false; } compileSortOptions(); reDo(); }); /*change type*/ $('.type-select').live("change", function(){ if($(this).hasClass('disabled')){ $(this).val('scatter'); return false; } //find for which field the change was done var fieldId = $(this).parent().parent().attr('title'); if($(this).find(":selected").attr("value") == "column"){ //disable the column choise to all other axis //$(".type-select").not(this).find("option[value='column']").attr('disabled','disabled'); } var i=0; for(i=0;i
";
mscontent += "
";
mscontent += "Distinguish by:
"+forDimsColorsControls+"
";
mscontent += "
Group by:
"+forDimsGroupsControls+"
";
mccontent += "
";
mccontent += "sort by:
"; mccontent += "order:
min to max
max to min
max to min
";
mccontent += "
";
//mccontent += "Split by:
"+forDimsAnalyseControls+"
";
//mccontent += "
";
mccontent += "Size by:
"+forDimsAnalyseControls+"
";
contentString += "
";
else
contentString+= predecessors[predecessors.length-1]+"-"+attribs[attrnum]['name']+"";
}
}
else {
var temp = dimstree(attribs[attrnum]['attrib'],predecessors.concat([attribs[attrnum]['name']]), classname);
if(temp!='')
contentString += ""+temp+"
";
contentString += "
";
else
contentString+= predecessors[predecessors.length-1]+"-"+attribs[attrnum]['name']+"";
}
else {
contentString += attribsOfDims(attribs[attrnum]['attrib'],predecessors.concat([attribs[attrnum]['name']]),classPrefix,type);
}
}
else if(type == 'option') {
if(attribs[attrnum]['attrib'].length == 0) {
contentString += "";
else
contentString+= predecessors[predecessors.length-1]+"-"+attribs[attrnum]['name']+"";
}
else {
contentString += attribsOfDims(attribs[attrnum]['attrib'],predecessors.concat([attribs[attrnum]['name']]),classPrefix,type);
}
}
}
return contentString;
}
function reDo(){
if(viztype=='chart')
renderChart();
else if(viztype=='table')
renderTable('g');
else if(viztype=='g table')
renderTable('g');
else if(viztype=='map')
renderMap();
else if(viztype=='treemap')
renderTreemap();
else{
viztype='chart';
renderChart();
}
}
function renderMap(){
if(selectedData['fields'].length == 0)
getFields();
if(filtercounter >0)
getFilters();
$("#chartcontainer").attr("src",path+"choromap.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
$("#url").html(path+'choromap.php?com=query&data='+JSON.stringify(selectedData));
$("#urlencode").html(path+'choromap.php?com=query&data='+encodeURIComponent(JSON.stringify(selectedData)));
selectedData['fields'] = new Array();
$('.header-select').has('.type-select').hide();
}
function renderChart(){
if(loadFlag)
getFields();
loadFlag=true;
if(filtercounter > 0)
getFilters();
//xaxis style
selectedData['xStyle'] = Object();
if($("#xarotate").is(":checked")){
var val = $("#rotatedegrees").val();
selectedData['xStyle']['r'] = parseInt(val,10);
}
else
selectedData['xStyle']['r'] = "-";
if($("#xastep").is(":checked")){
var val = $("#stepsnum").val();
selectedData['xStyle']['s'] = parseInt(val,10);
}
else
selectedData['xStyle']['s'] = "-";
if($("#xalevel").is(":checked")){
var val = $("#levelsnum").val();
selectedData['xStyle']['l'] = parseInt(val,10);
}
else
selectedData['xStyle']['l'] = "-";
if($("#xaftrim").is(":checked")){
var val = $("#ftrimnum").val();
selectedData['xStyle']['ft'] = parseInt(val,10);
}
else
selectedData['xStyle']['ft'] = "-";
if($("#xawtrim").is(":checked")){
var val = $("#wtrimnum").val();
selectedData['xStyle']['wt'] = parseInt(val,10);
}
else
selectedData['xStyle']['wt'] = "-";
if(selectedData['type'] == 'scatter'){
if(selectedData['group'] && selectedData['group']!='' && (!selectedData['color'] || selectedData['color'] == '')){
$(".aggrs-select").val('avg').removeClass('disabled');
$(".x-aggrs-select").val('avg').removeClass('disabled');
}
else{
$(".aggrs-select").val('none').addClass('disabled');
$(".x-aggrs-select").val('none').addClass('disabled');
}
$('#scatter-controls .controls').removeClass('disabled');
$('#chart-controls .controls').addClass('disabled');
}
else{
if($(".aggrs-select").hasClass('disabled'))
$(".aggrs-select").val('avg').removeClass('disabled');
$(".x-aggrs-select").addClass('disabled');
$(".aggrs-select option").removeAttr('disabled');
$('#scatter-controls .controls').addClass('disabled');
$('#chart-controls .controls').removeClass('disabled');
}
$("#chartcontainer").attr("src",path+"chart.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
$("#url").html(path+'chart.php?com=query&data='+JSON.stringify(selectedData));
$("#urlencode").html(path+'chart.php?com=query&data='+encodeURIComponent(JSON.stringify(selectedData)));
selectedData['fields'] = new Array();
$('.header-select').has('.type-select').show();
}
function renderTable(which){
if(selectedData['fields'].length == 0)
getFields();
if(filtercounter >0)
getFilters();
if(selectedData['type'] == 'scatter'){
if(selectedData['group'] && selectedData['group']!='' && (!selectedData['color'] || selectedData['color'] == '')){
$(".aggrs-select").val('avg').removeClass('disabled');
$(".x-aggrs-select").val('avg').removeClass('disabled');
}
else {
$(".aggrs-select").val('none').addClass('disabled');
$(".x-aggrs-select").val('none').addClass('disabled');
}
$('#scatter-controls .controls').removeClass('disabled');
$('#chart-controls .controls').addClass('disabled');
}
else{
if($(".aggrs-select").hasClass('disabled'))
$(".aggrs-select").val('avg').removeClass('disabled');
$(".x-aggrs-select").addClass('disabled');
$(".aggrs-select option").removeAttr('disabled');
$('#scatter-controls .controls').addClass('disabled');
$('#chart-controls .controls').removeClass('disabled');
}
var location = '';
if(which == '1'){
$("#chartcontainer").attr("src",path+"table.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
$("#url").html(path+"table.php?com=query&data="+JSON.stringify(selectedData));
$("#urlencode").html(path+"table.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
}
else if(which == 'g'){
$("#chartcontainer").attr("src",path+"gtable.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
$("#url").html(path+"gtable.php?com=query&data="+JSON.stringify(selectedData));
$("#urlencode").html(path+"gtable.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
}
selectedData['fields'] = new Array();
$('.header-select').has('.type-select').hide();
}
function renderTreemap(){
if(selectedData['fields'].length == 0)
getFields();
if(filtercounter >0)
getFilters();
if(selectedData['type'] == 'scatter'){
if(selectedData['group'] && selectedData['group']!='' && (!selectedData['color'] || selectedData['color'] == '')){
$(".aggrs-select").val('avg').removeClass('disabled');
$(".x-aggrs-select").val('avg').removeClass('disabled');
}
else {
$(".aggrs-select").val('none').addClass('disabled');
$(".x-aggrs-select").val('none').addClass('disabled');
}
$('#scatter-controls .controls').removeClass('disabled');
$('#chart-controls .controls').addClass('disabled');
}
else{
if($(".aggrs-select").hasClass('disabled'))
$(".aggrs-select").val('avg').removeClass('disabled');
$(".x-aggrs-select").addClass('disabled');
$(".aggrs-select option").removeAttr('disabled');
$('#scatter-controls .controls').addClass('disabled');
$('#chart-controls .controls').removeClass('disabled');
}
$("#chartcontainer").attr("src",path+"treemap.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
$("#url").html(path+"treemap.php?com=query&data="+JSON.stringify(selectedData));
$("#urlencode").html(path+"treemap.php?com=query&data="+encodeURIComponent(JSON.stringify(selectedData)));
selectedData['fields'] = new Array();
$('.header-select').has('.type-select').hide();
}
function defaultSelections(){
//select the xAxis
//$('#xaxis').val(selectedData['xaxis']['name']);
$('#xaxis-name').val(selectedData['xaxis']['name']);
$(".xaxis-row").has("input[value='"+selectedData['xaxis']['name']+"']").addClass('xaxis-selected').css('font-weight','bold');
$("#sort-list option[value='xaxis']").html($(".xaxis-row").has("input[value='"+selectedData['xaxis']['name']+"']").find('label').html());
/*if($('#xaxis').find(':selected').hasClass('optionMeas')){ <-------------------------todo
selectedData['type'] = 'scatter';
}
else {
selectedData['type'] = 'chart';
}*/
//create the yaxis selection
for(var i=0; i";
content += "
";
//create select
content += ""
content += "";
//place the content in the yaxis
$($('.yaxis')[yaxis-1]).append(content);
//preselected option
if(agg!='')
$(".field[title='"+fieldscounter+"'] .aggrs-select").val(agg);
else
$(".field[title='"+fieldscounter+"'] .aggrs-select").val('none');
if(field!='')
$(".field[title='"+fieldscounter+"'] .yaxis-select").val(field);
if(selectedData['type'] == 'scatter')
$('.type-select').val('scatter').addClass('disabled');
else{
if(type!='')
$(".field[title='"+fieldscounter+"'] .type-select").val(type);
else
$(".field[title='"+fieldscounter+"'] .type-select").val('column');
}
if(fieldscounter>1){
$('.delete').show();
}
else
$('.delete').hide();
//add a header input for the new field
$("#fheaders").append("");
compileSortOptions();
}
function compileSortOptions(){
var previous = $("#sort-list").val();
$("#sort-list > option[value!='xaxis']").remove();
$(".field").each(function(){
var agg = $(this).find('.aggrs-select').val();
var field = $(this).find('.yaxis-select').val();
if($("#sort-list > option[value='"+agg+"-"+field+"']").length == 0)
$('#sort-list').append("");
})
if($("#sort-list > option[value='"+previous+"']").length > 0 ){
$("#sort-list").val(previous);
selectedData['sort'] = previous;
}
else{
$("#sort-list").val('xaxis');
selectedData['sort'] = 'xaxis';
}
}
function addyAxis(agg,field,type){
yaxiscounter++;
//add it in the axis-select
var name = '';
if(yaxiscounter == 1) $('div#axis-select select').append("");
else {
if(yaxiscounter == 2) name = '2nd';
else if(yaxiscounter == 3) name = '3rd';
else name = yaxiscounter+'th';
$('div#axis-select select').append("");
}
var mydiv = document.getElementById(newyAxis);
//div that has an x sign, an aggs select, a fields select, a diagram select
var content = "");
}
function getFields(){
var counter = 0;
selectedData['fields'] = new Array();
selectedData['yaxisheaders'] = new Array();
selectedData['fieldsheaders'] = new Array();
$('.yaxis').each(function(index){
//gia kathe yaxis get the header and iterate over the fields
selectedData['yaxisheaders'][index] = $($("#yheaders > .headerdiv").get(index)).find(".yaxisheaders").val();
//gia kathe field ftiakse ena gia to selectedData pou tha exei fld, agg, type, yaxis
selectedData['in'] = new Array();
$(this).find('.field').each(function(){
selectedData['fields'][counter] = new Object();
selectedData['fields'][counter]['fld'] = $(this).find('.yaxis-select').val();
if($(this).find('.aggrs-select').val() == 'none')
selectedData['fields'][counter]['agg'] = '';
else
selectedData['fields'][counter]['agg'] = $(this).find('.aggrs-select').val();
selectedData['fields'][counter]['type'] = $(this).find('.type-select').val();
selectedData['fields'][counter]['yaxis'] = index+1;
var fname = $($("#fheaders > .headerdiv").get(counter)).find(".fieldsheaders").val();
selectedData['fieldsheaders'][counter] = fname;
selectedData['fields'][counter]['c'] = $(this).find('.cumulate').is(':checked');
if($(this).find(".delfromchart").length > 0) {
var l = selectedData['in'].length;
selectedData['in'][l] = new Object;
selectedData['in'][l]['f'] = counter;
selectedData['in'][l]['text'] = $(this).find(".vscumulate").val();
}
counter++;
});
});
}
function getFilters(){
var incfilters = new Array();
var incfltcount = 0;
var filters = new Array();
var fltcount = 0;
var inchaving = new Array();
var inchavingcnt = 0;
var having = new Array();
var havingcnt = 0;
$('#filterTable tr td').each(function(index){
//SLIDER
if($(this).find('.filter-slider').length >0 && $(this).find('.filter-slider').css('display') != 'none'){
if($(this).find('select.applyselect').val()==-2){
var flag = false;
for(var i =0;i
slider"); $(container_div).append("discrete"); if(type=='m') $(container_div).append("having"); //double slider var str; str = ""; $(filtcont).append(str); $(function(){ $("#slider"+filtercounter).slider({ step: 1, range: true, min: filterData['min'], max: filterData['max'], values: [filterData['min'], filterData['max']], slide: function(event, ui){ $(this).siblings('span').find('.slider-user-min').html(ui.values[0]); $(this).siblings('span').find('.slider-user-max').html(ui.values[1]); } }); }); //str = ""; //form str = "
"+fieldscounter+"
"; content += ""; content += "";
//create select
content += ""
content += "";
//place the content in the yaxis
$($('.yaxis')[yaxis-1]).append(content);
//preselected option
if(agg!='')
$(".field[title='"+fieldscounter+"'] .aggrs-select").val(agg);
else
$(".field[title='"+fieldscounter+"'] .aggrs-select").val('none');
if(field!='')
$(".field[title='"+fieldscounter+"'] .yaxis-select").val(field);
if(selectedData['type'] == 'scatter')
$('.type-select').val('scatter').addClass('disabled');
else{
if(type!='')
$(".field[title='"+fieldscounter+"'] .type-select").val(type);
else
$(".field[title='"+fieldscounter+"'] .type-select").val('column');
}
if(fieldscounter>1){
$('.delete').show();
}
else
$('.delete').hide();
//add a header input for the new field
$("#fheaders").append("field ("+fieldscounter+"):
";
if(yaxiscounter == 1)
content += "";
else {
content += "
";
if(yaxiscounter == 2){
$('.yaxis .ycount').html('yaxis: (1)');
}
}
//put it in the div
$(mydiv).append(content);
addField(agg,field,type,yaxiscounter);
//add a header input for the new axis
$("#yheaders").append("yaxis: ("+yaxiscounter+")
yaxis ("+yaxiscounter+"):
apply to:
").append(applyselect); $(applyselect).append(""); $('.field').each(function(index){ $(applyselect).append(""); }); $(container_div).append(applydiv); $(container_div).append(filtcont); if(filterData['type'] == "ordinal"){ //buttons $(container_div).append("slider"); $(container_div).append("discrete"); if(type=='m') $(container_div).append("having"); //double slider var str; str = ""; $(filtcont).append(str); $(function(){ $("#slider"+filtercounter).slider({ step: 1, range: true, min: filterData['min'], max: filterData['max'], values: [filterData['min'], filterData['max']], slide: function(event, ui){ $(this).siblings('span').find('.slider-user-min').html(ui.values[0]); $(this).siblings('span').find('.slider-user-max').html(ui.values[1]); } }); }); //str = ""; //form str = "