<?php
include_once 'code/init.php';
$from = 20131001  ;
$to = 20131031  ;
$au = 20131104 ;
$ca = 0;
$caht = 0;
$cattc = 0;
$t=dbi_query("SELECT * FROM ".TABLE_FACT." WHERE date_debut>=$from AND date_fin<=$to AND agence_id=$agence");
// echo "SELECT * FROM ".TABLE_FACT." WHERE date_debut>=$from AND date_fin<=$to AND agence_id=$agence";
$n=0;
while($f = dbi_fetch_row($t))
	{
	$data = $f['data'];
	$cattc += $f['total'];
	list($data) = unserialize($data) ;
	// echo " <pre>";
	foreach($data as $id => $l)

			{
			
			// print_r($l);
				if($l['des']=='TOTAL')
				{
				++$n;
					$total = $l['somme'] ;
					$totalHT = $l['sommeht'] ;
					$tva=$l['tauxtva']/100 ;
					$caht +=  $totalHT;
					$ca += $total;
				}
			}	
	// if( number_format($total, 2, ",", " ") !=number_format($f['total'], 2, ",", " ")   )
	// {
	// echo  number_format($total, 2, ",", " ").' / '.number_format($f['total'], 2, ",", " ");
	if( number_format($total, 2, '.', '') != number_format($f['total'], 2, '.', '') )
	{
	echo " <pre>";
	// print_r($f);
	echo $f['client_id'].' ? '.number_format($total, 2, '.', '')." | ".number_format($f['total'], 2, '.', '') ;
	// echo " id = ".$f['fact_id'];
	// echo " total = ".$total;
	print_r($l);
	echo " </pre>";
	}
	// }
	// echo $f['fact_id']." || $total ||".$f['total'].'<br/>';
	// echo " </pre>";
	}
	echo " Total = $cattc <br/>";
	echo " TTC = $ca <br/>";
	echo " HT  = $caht <br/>";
	echo " nombre  = $n <br/>";
// ancienne requête qui marche pas bien		
//dbi_query("SELECT f.num_fact, f.date_fact, relance, data, f.client_id, sum(if(p.montant is null, 0, p.montant)), date_debut, date_fin, sum(if(a.montant is null, 0, a.montant)) FROM ".TABLE_FACT." f LEFT JOIN ".TABLE_PAIEMENT." p ON f.fact_id = p.fact_id LEFT JOIN ".TABLE_AVOIR." a ON  f.fact_id = a.fact_id WHERE f.fact_id = $id GROUP by relance, data, f.client_id, f.fact_id")) ;
		
		
		
?>