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(); |
[Artichow] Construction d'un camembert
Répondre avec citation
Partager