function popup_debug_sql()
  {
    
    $.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  doaction:'popup_debug_sql'},
      cache:false,
      success: function(data) {
         
         $.fancybox(data,{
            'width':1600,
			 	    'height':1000,
				    'autoDimensions':false   
					});
           
        }
    });
  
    return false; 
  
  }
function findSWF(movieName) {
  if (navigator.appName.indexOf("Microsoft")!= -1) {
    return window[movieName];
  } else {
    return document[movieName];
  }
}
function updatechart( chart,defaultgraph, col1 , col2, group )
{

	var page = $('#page_en_cours').attr('value');
	
	  $.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  chart : chart , group : group , page : page ,  doaction:'updatecharttableau'},
      cache:false,
      success: function(data) {
      
		//$.fancybox(data,{     'width':800,    'height':1000,  'autoDimensions':true });
		var tab  = chart.split('-');
        $('#tableau_details-'+tab[1]).html(data);   
		
		
		$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  chart : chart , defaultgraph : defaultgraph, col1 : col1, col2 : col2 ,  doaction:'updatechart'},
      cache:false,
      success: function(data) {
      
		//$.fancybox(data,{     'width':800,    'height':1000,  'autoDimensions':true });
        	
			tmp = findSWF( chart );
			x = tmp.load( data );		
        }
		});
	
	
        	           
        }
    });
	
	
	



}
function updatedateselection( periode  )
{
	
	if(periode==0)
		return ;
		
    $.ajax({
		url: absolute_path+'/modules/statistiques/ajax_tools.php',
		type: "POST",
		contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
		dataType: "html",
		processData:true,
		scriptCharset:'iso-8859-1',
		data: {   periode : periode ,  doaction:'updatedateselection'},
		cache:false,
		success: function(data) {
      		
		var tab = $.trim(data).split(',');
		$('#date_debut_stat').attr('value',tab[0]);
		$('#date_fin_stat').attr('value',tab[1]);
           
        }
    });
}
function selectionperiode(item)
{
	for(ii = 1 ; ii < 12 ; ii++)
	{
		$('#selectperiod-'+ii).removeClass('periode_selectionee');
	}
	$('#selectperiod-'+item).addClass('periode_selectionee');
	updatedateselection(item);
}


function MAJprefschiffrescles()
{
	var champ = $('#page_en_cours').val()+'.chiffrescles';
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  champ : champ , chiffrecles : chiffrecles , chiffreclesTotal : chiffreclesTotal  ,  doaction:'MAJprefschiffrescles'},
      cache:false,
      success: function(data) {
        }
    });
}
function MAJprefscolonneTableau()
{
	var champ = $('#page_en_cours').val()+'.coltab';
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {   champ : champ , colonnetableau : colonnetableau , colonnetableauTotal : colonnetableauTotal  ,  doaction:'MAJprefscolonneTableau'},
      cache:false,
      success: function(data) {
	
					
        }
    });
}
function RefreshTableauDetail(group_by)
{	
	var fields = $("#filtreform").serialize();
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  fields:fields, group_by: group_by,   doaction:'RefreshTableauDetail'},
      cache:false,
      success: function(data) {
		$('#tableaudetail').html(data);
        }
    });

}

function RefreshGraph(chart)
{
	var champ = $('#page_en_cours').val()+'.graph';
	
	var fields = $("#filtreform").serialize();
	
	
	var col1 = $('#choixcolonnegraph1').val();
	var typeComparaison = $('#criteredecomparaison option:selected').val()
	var col2 = $('#colonne2_'+typeComparaison).val();
	
	
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  fields  : fields  ,col1 : col1 , col2 : col2 ,typeComparaison:typeComparaison ,   doaction:'RefreshGraph'},
      cache:false,
      success: function(data) {
		//$.fancybox(data);
		tmp = findSWF( chart );
		x = tmp.load( data );
		}
    });
	
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  champ : champ ,  col1 : col1 , col2 : col2 ,typeComparaison:typeComparaison  ,  doaction:'MAJprefscolonneGraph'},
      cache:false,
      success: function(data) {
        }
    });
	
}


function GenererPDF(stats)
{
	window.location = absolute_path+'/modules/statistiques/pdf.php?page='+stats/*+&pdf=0*/ ;	
}
function DoPDF( image , stats  )
{
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  image : image  ,  doaction:'DoPDF'},
      cache:false,
      success: function(data) {
			GenererPDF( stats );
        }
    });
}

function popupoutil(idx)
{
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_popup.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: {  idx : idx  ,  doaction:'popuoutil'},
      cache:false,
      success: function(data) {
			$('#visuel_outil').html(data);
        }
    });
}


/**********************************************************
 * fab : affichage stats index en ajax
 ********************************************************/ 
function StatsGetIndex()
{
	
	$.ajax({
      url: absolute_path+'/modules/statistiques/ajax_tools.php',
      type: "POST",
      contentType: 'application/x-www-form-urlencoded;charset=iso-8859-1',
      dataType: "html",
      processData:true,
      scriptCharset:'iso-8859-1',
      data: { doaction:'GetIndex'},
      cache:false,
      success: function(data) {
					
					$('#stats_index').html(data);
					
        }
    });




}




