Accueil
Stats de ventes clients
table";
$resul_test = mysql_query($query_test, $client->link);
while($row_test = mysql_fetch_array($resul_test)){
$commande = new Commande();
$query_testa = "select * from $commande->table WHERE client='".$row_test[0]."' AND (statut='2' OR statut='3' OR statut='4')";
$resul_testa = mysql_query($query_testa, $commande->link);
while($row_testa = mysql_fetch_array($resul_testa)){
$venteprod = new Venteprod();
$cpta += 1;
$query_testb = "select * from $venteprod->table where commande='".$row_testa[0]."'";
$resul_testb = mysql_query($query_testb, $venteprod->link);
while($row_testb = mysql_fetch_array($resul_testb)){
$cptb += $row_testb[6];
}
}
if($cpta >=1){
$refer[] = $row_test[1].",".$row_test[2].",".$cpta.",".$cptb;
}
$cpta='';
$cptb='';
}
$annee = substr($row_test->date, 0, 4);
/*
$query_test = "select * from $commande->table where statut>=2 order by date desc limit 0,1";
$resul_test = mysql_query($query_test, $commande->link);
$row_test = mysql_fetch_object($resul_test);
$anneefin = substr($row_test->date, 0, 4);
*/
?>