|
Bienvenue sur l'espace client ALCY
|
|
|
$i AND NoClient=$Intra_noclient";
$result=mysql_query($select) or die($select);
$i=mysql_result($result,0,0);
if($i>0) echo "Des nouveaux messages dans la section support ($i)
";
echo "Nous sommes le ".date_ustofr(date("Y-m-d H:i:s"))."
";
$select = "SELECT count(*) FROM intervs WHERE noclient=$Intra_noclient";
$result=mysql_query($select) or die($select);
$i=0;
if($val=mysql_fetch_array($result)) {
$nbrinterv=$val[0];
}
echo $nbrinterv." interventions ";
$select = "SELECT count(*) FROM intervs WHERE noclient=$Intra_noclient and etat=1";
$result=mysql_query($select) or die($select);
$i=0;
if($val=mysql_fetch_array($result)) {
$nbrintervr=$val[0];
}
echo " dont ".$nbrintervr." terminées.
";
$select = "SELECT count(*) FROM $DatabaseintranetAlcy.devis d, $DatabaseintranetAlcy.factures f WHERE f.nofacture=d.nofacture and d.public=1 AND d.noclient=$Intra_noclient";
$result=mysql_query($select) or die($select);
$i=0;
if($val=mysql_fetch_array($result)) {
$nbrfac=$val[0];
}
if($nbrfac>1) echo $nbrfac." factures consultables
";
else echo $nbrfac." facture consultable
";
$select = "SELECT count(*) FROM $DatabaseintranetAlcy.devis WHERE public=1 AND noclient=$Intra_noclient";
$result=mysql_query($select) or die($select);
$i=0;
if($val=mysql_fetch_array($result)) {
$nbrdevis=$val[0];
}
echo $nbrdevis." devis consultables
";
$select = "SELECT count(*)
FROM support s
WHERE noclient=$Intra_noclient";
$result=mysql_query($select);
$i=mysql_result($result,0,0);
if($i>0) echo $i." messages sur le support
";
$select = "SELECT Prenom FROM $DatabaseintranetAlcy.fetes WHERE DateFete='2003-".date("m-d")."'";
$result=mysql_query($select) or die($select);
$i=0;
while($val=mysql_fetch_array($result)) {
$i++;
if($i>1) $msg_fete.=", ";
$msg_fete.=ucfirst($val[0]);
}
echo "Nous fêtons les ".$msg_fete."
";
?>
|
|
|