var winSendMail;
var tabTaille = Array();
tabTaille['400'] = 3;
tabTaille['600'] = 6;
tabTaille['800'] = 12;
tabTaille['1024'] = 20;










function cursorHand(evenement,numFen) {
	
	//if(window.XMLHttpRequest)
	if(navigator.userAgent.indexOf("Firefox")!=-1)
	{
		event = evenement;
		var item = evenement.target;
	}
	else
		var item = event.srcElement;
	
	var trouve=false;
	if ((item.getAttribute("CelNbChild")!=null)&&(item.getAttribute("CelNbChild")!="")&&(item.getAttribute("CelNbChild")!="0"))
		if (tabWidget[numFen].options.AllowDrill && tabWidget[numFen].options.AllowDrill=='1')
			trouve = true;
	
	if ((item.getAttribute("drillType")!=null)&&(item.getAttribute("drillType")!="none"))
		if (tabWidget[numFen].options.AllowDrill && tabWidget[numFen].options.AllowDrill=='1')
			trouve = true;
		
		
	if ((item.getAttribute("CelType")!=null)&&(item.getAttribute("CelType")=="val")&&(item.getAttribute("Valeur")!=null)&&(item.getAttribute("Valeur")!="")&&(item.getAttribute("Valeur")!="0"))
		if (tabWidget[numFen].options.Extraction=='1')
			trouve = true;
		
	if (trouve) {
		item.style.cursor = "pointer";
		item.style.textDecorationUnderline = true;
		item.style.color = 'red';
		item.style.border = '1px solid red';
		event.cancelBubble = true;
	}
}


function cursorNormal(evenement,numFen) {
	//if(window.XMLHttpRequest)
	if(navigator.userAgent.indexOf("Firefox")!=-1)
	{
		event = evenement;
		var item = evenement.target;
	}
	else
		var item = event.srcElement;

	item.style.cursor = "";
	item.style.textDecorationUnderline = false;
	item.style.color = 'black';
	item.style.border = '1px solid #efefef';
	event.cancelBubble = true;

}


function EnvoiDataResult(evenement,numFen)
{
	//if(window.XMLHttpRequest)
	if(navigator.userAgent.indexOf("Firefox")!=-1) {
		event = evenement;
		var item = evenement.target;
	}
	else
		var item = event.srcElement;

	if ((item.getAttribute("Valeur")!=null)&&(item.getAttribute("Valeur")!='')) {
		if ((item.getAttribute("CelType")!=null)&&(item.getAttribute("CelType")=='entete')) {
			if (tabWidget[numFen].options.AllowDrill && tabWidget[numFen].options.AllowDrill=='1') {
				// Drilldown, drillup, ou flip
				formulaire = $('frmInput'+numFen);
				formulaire.strMDX.value=""
			
				formulaire.CelLevel.value=item.getAttribute("CelLevel")
				formulaire.drillType.value=item.getAttribute("drillType")
				formulaire.CelVal.value=item.getAttribute("CelVal")
			
				switch (formulaire.drillType.value) {
					case "Drilldown":
						formulaire.CelValOld.value=item.getAttribute("CelVal")
						formulaire.CelValOld2.value=item.getAttribute("CelValParent")  
						break;
					case "Drillup":	
						formulaire.CelValOld.value=item.getAttribute("CelValLastParent") 
						formulaire.CelValOld2.value=item.getAttribute("CelValLast")
						formulaire.CelVal.value=item.getAttribute("CelVal")
						break;
				}
			
				if (formulaire.drillType.value != "none") {
					chValeurs = returnValeursInput(numFen);
					trAjax("d_ResultContainer"+numFen,fichierXML_Result, fichierXSL_Result, "post",chValeurs,true,loadingHTML);
					return;
				}
			}
		}
		else {
			// Extraction en cliquant sur un nombre
			if ((item.getAttribute("Extract")!=null)&&(item.getAttribute("Extract")!=''))
			if (item.getAttribute("Valeur")!='0') {
				if (tabWidget[numFen].options.Extraction=='1') {
					var chExtract = item.getAttribute("Extract");
					//for (i=0;i<=6;i++)
					//	chExtract = chExtract.replace(/¤/,",");
					
					taille = chExtract.length;
					if (chExtract.substring(taille-1,taille) == ',')
						chExtract = chExtract.substring(0,taille-1);
		
					/* Suppression de dimension "measure" s'il y a, sinon le DRILTHROUGH plante */
					var contains = chExtract.toLowerCase().search("measures")
					var temp = "";
					if (contains != -1) {
						temp = chExtract.substring(contains-1,chExtract.length)
						var Ttemp = temp.split("¤");
						temp = Ttemp[0];
						chExtract = chExtract.replace(temp,"");
					}
					chExtract = chExtract.replace(/¤¤/,"¤");
					taille = chExtract.length;
					if (chExtract.substring(taille-1,taille) == ',')
						chExtract = chExtract.substring(0,taille-1);
					taille = chExtract.length;
					if (chExtract.substring(0,1) == '¤')
						chExtract = chExtract.substring(1,taille);
						
					formulaire = $('frmInput'+numFen);	
					if (formulaire.chExtract)
						formulaire.chExtract.value = chExtract;
					
					
					chValeurs = returnValeursInput(numFen);
					//var indTab = (tabWidget[numFen].options.AllowSearch && tabWidget[numFen].options.AllowSearch=='1')?2:1;
					tabWidget[numFen].tabView.set('activeIndex', 2);
					trAjax("d_DetailContainer"+numFen,fichierXML_Detail, fichierXSL_Detail, "post",chValeurs,true,loadingHTML);
				}
				return;
			}
		}
		
	}
}




function flip(numFen)
{
	if (tabWidget[numFen].options.AllowDrill && tabWidget[numFen].options.AllowDrill=='1') {
		var formulaire = $('frmInput'+numFen);
		var chMDX = formulaire.strMDX.value;
		if (chMDX=="")
			chMDX = formulaire.strMDX_EC.value;
		chMDX = chMDX.replace(/on rows/gi,'xxxxx');
		chMDX = chMDX.replace(/on columns/gi,'on rows');
		chMDX = chMDX.replace('xxxxx','on columns');
		formulaire.strMDX_EC.value = chMDX;
		chValeurs = returnValeursInput(numFen);
		trAjax("d_ResultContainer"+numFen,fichierXML_Result, fichierXSL_Result, "post",chValeurs,true,loadingHTML);
	}
}







function exportResultExcel(numFen)
{
	try
	{
		var formulaire = $('f_SendResultExcel');
		var laTable = $('tableResult_'+numFen).cloneNode(true);
		var tabTD = laTable.getElementsByTagName('TD');
		for (var i=0; i<tabTD.length; i++)
		{
			if ((tabTD[i].className=="odd")||(tabTD[i].className=="even"))
			{
				tabTD[i].innerHTML = tabTD[i].innerHTML.replace(/ /gi,'');
				tabTD[i].innerHTML = tabTD[i].innerHTML.replace(/&nbsp;/gi,'');
			}
			
			tabTD[i].removeAttribute('CelLevel');
			tabTD[i].removeAttribute('Valeur');
			tabTD[i].removeAttribute('drillDirect');
			tabTD[i].removeAttribute('drillType');
			tabTD[i].removeAttribute('CelCol');
			tabTD[i].removeAttribute('CelRow');
			tabTD[i].removeAttribute('CelNbChild');
			tabTD[i].removeAttribute('CelVal');
			tabTD[i].removeAttribute('CelValParent');
			tabTD[i].removeAttribute('CelValLast');
			tabTD[i].removeAttribute('CelValLastParent');
			tabTD[i].removeAttribute('CelValColspan');
			tabTD[i].removeAttribute('CelValRowspan');
			tabTD[i].removeAttribute('CelType');
			tabTD[i].removeAttribute('Extract');
			tabTD[i].removeAttribute('onclick');
			tabTD[i].removeAttribute('style');
			
			if (tabTD[i].className=="sort-table_thead")
				tabTD[i].setAttribute("bgColor","#cccccc");
			tabTD[i].className ="";
			tabTD[i].removeAttribute('class');
			tabTD[i].removeAttribute('className');
				
			if (tabTD[i].innerHTML.indexOf('<img') != -1)
				tabTD[i].innerHTML="";
				
			if (tabTD[i].innerHTML.indexOf('<IMG') != -1)
				tabTD[i].innerHTML="";
		}
		formulaire.strTableResult.value =  laTable.innerHTML;
		formulaire.action = fichierExcel_Result;
		//formulaire.target = "_blank";
		formulaire.submit();
		laTable = null;
		
	}
	catch(e){/*alert(e.message)*/}
	return;
}





function saveRQT(numFen)
{
	try {
		var formulaire = $('frmInput'+numFen);
		if ((formulaire.strMDX_EC==null)||(formulaire.strMDX_EC.value == '')) {
			alert(erreurSaveRQT);
			return;	
		}
		
		var typeGraph='';
		var tailleGraph = "";
		typeGraph = getTypeGraph(numFen);
		tailleGraph = getTailleGraph(numFen);
		var titreQuery = '';
		if ($('editable_title_'+numFen))
			titreQuery = $('editable_title_'+numFen).value;
		else
			return;
		
		if (titreQuery.trim() =='') {
			alert(msg_ErrorTitreRQT)
			return;
		}
		
		
		//var titreQuery = prompt(saisieNomRQT,'');
		if ((titreQuery)&&(titreQuery!='')) {
			formulaire.action="/webarea/traite.php?type_action=saveRQT&nomRQT="+titreQuery+"&idWebArea="+idWebArea+"&typeGraph="+typeGraph+"&tailleGraph="+tailleGraph;
			formulaire.target="traite";
			formulaire.method="post";
			beginTraitement(msgTraitementEC.replace('XXXX',msg_TraitementSauvRQT));
			setTimeout(function(){formulaire.submit();},800);
		}
		return;
	}
	catch(e){
		alert("Erreur dans saveRQT : "+e.message)
	}
}




function changeTailleGraph(numFen,taille,chargerGraph)
{
	var theButton = eval("splitButton_tailleGraph"+numFen);
	if (taille=='400') theButton.set('label','400 * 300');
	if (taille=='600') theButton.set('label','600 * 450');
	if (taille=='800') theButton.set('label','800 * 600');
	if (taille=='1024') theButton.set('label','1024 * 768');
	theButton.set('value',taille);
	
	
	if (!chargerGraph) return;
	genereGraph(numFen,getTypeGraph(numFen));
}




function genereGraph(numFen,typeGraph)
{
	if (typeGraph==undefined || typeGraph==null || typeGraph=='') return;
	try {
		var fichier = "/webarea/graph/";
		if (typeGraph=="bar") fichier += "barPlot.php?";
		if (typeGraph=="line") fichier += "linePlot.php?";
		if (typeGraph=="pie") fichier += "piePlot.php?";
		
		
		
		var taille = getTailleGraph(numFen);
		
		var formulaire = $('frmInput'+numFen);
		var param = "";
		param += "numFen="+numFen;
		param += "&chMDX="+formulaire.strMDX_EC_Datamart.value;
		param += "&Serveur="+formulaire.bck_Serveur.value;
		param += "&DataBase="+formulaire.bck_DataBase.value;
		param += "&Cube="+formulaire.bck_Cube.value;
		param += "&size="+taille;
		param += "&page="+1;
		
		$('containsIMG'+numFen).innerHTML = loadingHTML;
		
	
		var xhr_object = null;
		if(window.XMLHttpRequest)
			xhr_object = new XMLHttpRequest();
		else if(window.ActiveXObject)
			xhr_object = new ActiveXObject("Microsoft.XMLHTTP");
			else return;
	
		//window.open(fichier+param);
		xhr_object.open("POST", fichier, true);
		xhr_object.onreadystatechange = function() {
			if(xhr_object.readyState == 4) {
				
				var ladiv = 'containsIMG'+numFen;
				var reponse = xhr_object.responseText
				reponse = reponse.replace('barPlot.php','/webarea/graph/barPlot.php');
				reponse = reponse.replace('linePlot.php','/webarea/graph/linePlot.php');
				reponse = reponse.replace('piePlot.php','/webarea/graph/piePlot.php');
				
				if (typeGraph=="pie") {
					var nbValRow = new Number(formulaire.nbValRow.value);
					var nbPages = Math.ceil(nbValRow / tabTaille[taille]);
					if (nbPages>1) {
						var html = "<div id='pageGraph"+numFen+"' class='toolbar' style='width:"+taille+"px'>";
						html += "<input type='hidden' id='pageGraph_"+numFen+"' value='1'/>";
						html += "</div><br/><div id='pieGraph"+numFen+"'></div>";
						$('containsIMG'+numFen).innerHTML = html;
						var toolbar_pageGraphResult = new YAHOO.widget.ButtonGroup({ 
					        id:  "toolbar_pageGraphResult"+numFen, 
					        name:  "toolbar_pageGraphResult"+numFen,
					        container:  "pageGraph"+numFen
					    });
					    for (var i=1; i<=nbPages; i++) {
						    toolbar_pageGraphResult.addButton({
							    label: 'Page '+i,
							    value: numFen+'_'+i,
							    checked: (i==1?true:false)
						    })
					    }
					    toolbar_pageGraphResult.addListener('checkedButtonChange', function(args){
						    var id = args.newValue.get('value');
							var numFen = id.split("_")[0];
							var numPage = id.split("_")[1];
							if ($('pageGraph_'+numFen))
								$('pageGraph_'+numFen).value = numPage;
								
							var formulaire = $('frmInput'+numFen);
							var param = "";
							param += "numFen="+numFen;
							param += "&Serveur="+formulaire.bck_Serveur.value;
							param += "&DataBase="+formulaire.bck_DataBase.value;
							param += "&Cube="+formulaire.bck_Cube.value;
							param += "&size="+taille;
							param += "&page="+numPage;
							param += "&chMDX="+formulaire.strMDX_EC_Datamart.value;
							
							var xhr_object = null;
							if(window.XMLHttpRequest) xhr_object = new XMLHttpRequest();
							else if(window.ActiveXObject) xhr_object = new ActiveXObject("Microsoft.XMLHTTP");
							
							xhr_object.open("POST", fichier, true);
							xhr_object.onreadystatechange = function() {
								if(xhr_object.readyState == 4) {
									var ladiv = 'containsIMG'+numFen;
									var reponse = xhr_object.responseText
									reponse = reponse.replace('barPlot.php','/webarea/graph/barPlot.php');
									reponse = reponse.replace('linePlot.php','/webarea/graph/linePlot.php');
									reponse = reponse.replace('piePlot.php','/webarea/graph/piePlot.php');
									$('pieGraph'+numFen).innerHTML = reponse;
								}
							}
							xhr_object.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
							xhr_object.send(param);
						});
					    ladiv = 'pieGraph'+numFen;
					}
				}
				if ($(ladiv)==null) return;
				$(ladiv).innerHTML = reponse;
			}
		}
		xhr_object.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
		xhr_object.send(param);
		
	}
	catch(e){
		alert("Erreur dans genereGraph("+numFen+") : "+e.message)
	}
}



function extractChart(numFen,chExtract)
{
	if (tabWidget[numFen].options.Extraction !='1')	return;
	formulaire = $('frmInput'+numFen);
	if (formulaire==null) return;
	
	chExtract = chExtract.replace(']:::[',']¤[');
	taille = chExtract.length;
	if (chExtract.substring(taille-1,taille) == ']')
		chExtract = chExtract.substring(0,taille-1);
	

	if (formulaire.chExtract)
		formulaire.chExtract.value = chExtract;
	
	
	chValeurs = returnValeursInput(numFen);
	//var indTab = (tabWidget[numFen].options.AllowSearch && tabWidget[numFen].options.AllowSearch=='1')?2:1;
	tabWidget[numFen].tabView.set('activeIndex', 2);
	trAjax("d_DetailContainer"+numFen,fichierXML_Detail, fichierXSL_Detail, "post",chValeurs,true,loadingHTML);

}



function getTypeGraph(numFen)
{
	var valTypeGraph = eval("buttonGroup_graph"+numFen);
	valTypeGraph = valTypeGraph.get('value');
	return valTypeGraph;
}


function getTailleGraph(numFen)
{
	var valTailleGraph = eval("splitButton_tailleGraph"+numFen);
	valTailleGraph = valTailleGraph.get('value');
	return valTailleGraph;
}





function genereGraphSimple(numFen,typeGraph,param)
{
	try {
		if ((numFen==undefined)||(numFen==null)||(numFen==''))
			return;
		
		if ((typeGraph==undefined)||(typeGraph==null)||(typeGraph==''))
			typeGraph='bar';
		
			
		var fichier = "/webarea/graph/";
		if (typeGraph=="bar") fichier += "barPlot.php?";
		if (typeGraph=="line") fichier += "linePlot.php?";
		if (typeGraph=="pie") fichier += "piePlot.php?";
		
		
		
		$('containsIMG'+numFen).innerHTML = loadingHTML;
		var xhr_object = null;
		if(window.XMLHttpRequest) xhr_object = new XMLHttpRequest();
		else if(window.ActiveXObject) xhr_object = new ActiveXObject("Microsoft.XMLHTTP");
		
		xhr_object.open("POST", fichier, true);
		xhr_object.onreadystatechange = function() {
			if(xhr_object.readyState == 4) {
				var ladiv = 'containsIMG'+numFen;
				var reponse = xhr_object.responseText
				reponse = reponse.replace('barPlot.php','/webarea/graph/barPlot.php');
				reponse = reponse.replace('linePlot.php','/webarea/graph/linePlot.php');
				reponse = reponse.replace('piePlot.php','/webarea/graph/piePlot.php');
				$(ladiv).innerHTML = reponse;
				updateParentHeight();
			}
		}
		xhr_object.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
		xhr_object.send(param);
	}
	catch(e){}
}


function sendLogPrint(numFen)
{
	var xhr_object = null;
	if(window.XMLHttpRequest) xhr_object = new XMLHttpRequest();
	else if(window.ActiveXObject) xhr_object = new ActiveXObject("Microsoft.XMLHTTP");
	
	var contenu = "";
	if ($('decodeable'+numFen))
		contenu = $('decodeable'+numFen).innerHTML;
	
	var param = "type_action=logPrint";
	param += "&idWebArea="+idWebArea;
	param += "&idWidget="+tabWidget[numFen].options.idWin;
	param += "&contenu="+contenu;
	xhr_object.open("POST", "/webarea/traite.php?", true);
	xhr_object.onreadystatechange = function() {}
	xhr_object.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
	xhr_object.send(param);
}