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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
|
<?php
$mois = isset($_POST['mois'])?$_POST['mois']:null;
$annee = isset($_POST['annee'])?$_POST['annee']:null;
$server="****";
$user="****";
$pass="*****";
$db="*****";
mysql_connect($server,$user,$pass) or die('erreur de connexion');
mysql_select_db($db) or die ('impossible de se connecter a la base');
$sql1="SELECT count( id_reclamation ) as reclamation
FROM reclamation
WHERE MONTH( date_reclamation ) = '$mois'
AND YEAR( date_reclamation ) = '$annee';";
$query1 = mysql_query($sql1) or die('Erreur SQL !'.$sql1.'<br>'.mysql_error());
//mysql_num_rows($query1);
echo 'Pour le mois de '.$mois.'/'.$annee.', nous avons ';
while ( $list3 = mysql_fetch_array( $query1 ) ) { echo $list3["reclamation"];}
echo ' XXXX Réclamations.';
echo '<SELECT name="id_critere" onchange="critere()">';
$sql2="SELECT id_critere, nom_critere FROM critere;";
$query2 = mysql_query($sql2) or die('Erreur SQL !'.$sql2.'<br>'.mysql_error());
echo '<option value="-1"> Faite votre Choix</option>';
while ($list4 = mysql_fetch_array($query2))
{
echo '<option value='.$list4["id_critere"].'">'.$list4["nom_critere"].'</option>';
}
echo '</SELECT>';
require_once('Artichow/Pie.class.php');
$graph = new Graph(450, 280);
$graph->shadow->setPosition(Shadow::RIGHT_BOTTOM);
$graph->shadow->setSize(4);
$graph->setBackgroundGradient(
new LinearGradient(
new Color(240, 240, 240, 0),
new White,
0
)
);
$sql3="SELECT id_critere, nom_critere FROM critere;";
$query3 = mysql_query($sql3) or die('Erreur SQL !'.$sql3.'<br>'.mysql_error());
$ServArray = array ();
while($servicetab= mysql_fetch_array($query3)) {
$ServArray[$servicetab['id_critere']][0] = $servicetab['id_critere'];
$ServArray[$servicetab['id_critere']][1] = $servicetab['nom_critere'];
}
$genres = array();
while($servicetab2= mysql_fetch_array($query3)) {
$genres[$servicetab2['nom_critere']][0] = $servicetab2['id_critere'];
$genres[$servicetab2['nom_critere']][1] = $servicetab2['nom_critere'];
}
;
foreach ($ServArray as $key => $val)
{
$sql4="SELECT count( id_eva_reclamation ) as total, nom_critere
FROM eva_reclamation
INNER JOIN critere ON critere.id_critere=eva_reclamation.id_critere
INNER JOIN reclamation ON eva_reclamation.id_reclamation=reclamation.id_reclamation
WHERE MONTH( date_reclamation ) = '$mois'
AND YEAR( date_reclamation ) = '$annee'
AND critere.id_critere IN($key) GROUP by nom_critere;";
$query4 = mysql_query($sql4) or die('Erreur SQL !'.$sql4.'<br>'.mysql_error());
while($ligne = mysql_fetch_assoc($query4)){
echo '<br>'.$ligne["nom_critere"].'==>'.$ligne["eva_reclamation"].'<br>';
}
}
////////////////
$pie = new Pie(array_values($genres));
$pie->setLabelPrecision(1);
$pie->setLegend(array_keys($genres));
$pie->legend->setPosition(1.45, .25);
$pie->setCenter(.36, .58);
$pie->setSize(.65, .65);
$pie->set3D(5);
$pie->title->set('Popularité pour le mois juin');
$pie->title->move(0, -40);
$pie->title->setFont(new TuffyBold(14));
$pie->title->setBackgroundColor(new White(50));
$pie->title->setPadding(5, 5, 2, 2);
$pie->title->border->setColor(new Black());
$graph->add($pie);
$graph->draw(); |
Partager