Accueil 
Stats commandes
table";
$resul_testa = mysql_query($query_testa, $commande->link);
while($row_testa = mysql_fetch_array($resul_testa)){
if($row_testa[18] == 1){
$cpta +=1;
$venteprod = new Venteprod();
$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)){
$cptab += $row_testb[6];
}
}elseif($row_testa[18] == 2){
$cptb +=1;
$venteprod = new Venteprod();
$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)){
$cptbb += $row_testb[6];
}
}elseif($row_testa[18] == 3){
$cptc +=1;
$venteprod = new Venteprod();
$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)){
$cptcb += $row_testb[6];
}
}elseif($row_testa[18] == 4){
$cptd +=1;
$venteprod = new Venteprod();
$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)){
$cptdb += $row_testb[6];
}
}elseif($row_testa[18] == 5){
$cpte +=1;
$venteprod = new Venteprod();
$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)){
$cpteb += $row_testb[6];
}
}elseif($row_testa[18] == 6){
$cptf +=1;
$venteprod = new Venteprod();
$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)){
$cptfb += $row_testb[6];
}
}
}
$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);
*/
?>
| Nb |
Non réglées |
Nb |
Réglées |
Nb |
En Traitement |
Nb |
Expédiées |
Nb |
Remboursées |
Nb |
Attente chèque |
|
€ |
|
€ |
|
€ |
|
€ |
|
€ |
|
€ |