1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
function lister_clients_preventif(){
$today = date("Y-m-d");
$req ="SELECT * FROM contrats WHERE ('$today' BETWEEN debut AND fin) ORDER BY nom_client ASC";
$id_resultat = mysql_query($req) or die(mysql_error());
$i=0;
while($contrat = mysql_fetch_array($id_resultat,MYSQL_ASSOC)){
$id_type_contrat = $contrat['id_type_contrat'];
$serveur = trouver("types_contrat", "id_type_contrat",$id_type_contrat, "serveurs");
if($serveur==1){
$id_client = $contrat['id_client'];
$prevents[$id_client]['debut'] = $contrat['debut'];
$prevents[$id_client]['fin'] = $contrat['fin'];
$prevents[$id_client]['tps_alloue'] = $contrat['tps_alloue'];
$prevents[$id_client]['tps_total'] = $contrat['tps_total'];
$prevents[$id_client]['nom_client'] = trouver("clients","id_client",$contrat['id_client'],"nom_client");
//echo '<br />'.$prevents[$id_client]['nom_client'] = trouver("clients","id_client",$contrat['id_client'],"nom_client");
$prevents[$id_client]['sites'] = compter_sites($contrat['id_client']);
$prevents[$id_client]['serveurs'] = compter_serveurs_par_client($contrat['id_client']);
$i++;
}
}
mysql_free_result($id_resultat);
if($i>0){
return showarray($prevents);
}else{
return false;
}
} |
Partager