79 lines
2.0 KiB
PHP
79 lines
2.0 KiB
PHP
<?php
|
|
|
|
function calc($mois, $annee, $pourc=100, $port=1, $type=0){
|
|
|
|
if(strlen($mois)<2)
|
|
$mois = "0$mois";
|
|
|
|
$commande = new Commande();
|
|
|
|
if($type == 0)
|
|
$query = "select * from $commande->table where statut>=2 and statut<>5 and date like '$annee-$mois-%'";
|
|
else
|
|
$query = "select count(*) as nb from $commande->table where statut>=2 and statut<>5 and date like '$annee-$mois-%'";
|
|
|
|
|
|
$resul = mysql_query($query);
|
|
|
|
if($type == 1){
|
|
return mysql_result($resul, 0, "nb");
|
|
}
|
|
|
|
$list="";
|
|
while($row = mysql_fetch_object($resul)){
|
|
|
|
$list .= "'" . $row->id . "'" . ",";
|
|
}
|
|
|
|
$list = substr($list, 0, strlen($list)-1);
|
|
$list == "";
|
|
|
|
if($list == "") $list="''";
|
|
|
|
$query = "SELECT sum(venteprod.quantite*venteprod.prixu) as ca FROM venteprod where commande in ($list)";
|
|
$resul = mysql_query($query);
|
|
$ca = round(mysql_result($resul, 0, "ca"), 2);
|
|
|
|
$query = "SELECT sum(port)as ca FROM commande where id in ($list)";
|
|
$resul = mysql_query($query);
|
|
|
|
$ca += mysql_result($resul, 0, "ca");
|
|
|
|
$query = "SELECT sum(remise)as ca FROM commande where id in ($list)";
|
|
$resul = mysql_query($query);
|
|
|
|
$ca -= mysql_result($resul, 0, "ca");
|
|
|
|
if(!$port){
|
|
$query = "SELECT sum(port)as port FROM commande where id in ($list)";
|
|
$resul = mysql_query($query);
|
|
|
|
$ca -= mysql_result($resul, 0, "port");
|
|
}
|
|
|
|
return round($ca*$pourc/100, 0);
|
|
|
|
}
|
|
|
|
|
|
function trouve_mois($mois){
|
|
|
|
switch($mois){
|
|
case '1' : return "Jan"; break;
|
|
case '2' : return "Fev"; break;
|
|
case '3' : return "Mars"; break;
|
|
case '4' : return "Avril"; break;
|
|
case '5' : return "Mai"; break;
|
|
case '6' : return "Juin"; break;
|
|
case '7' : return "Juil"; break;
|
|
case '8' : return "Aout"; break;
|
|
case '9' : return "Sept"; break;
|
|
case '10' : return "Oct"; break;
|
|
case '11' : return "Nov"; break;
|
|
case '12' : return "Dec"; break;
|
|
}
|
|
|
|
}
|
|
|
|
|
|
?>
|