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
| <?php
//connection a phpMyAdmin
$db = mysql_connect( "localhost", "x", "x" ) or die ('ERREUR '.mysql_error());
//Sélection des tables _equalone de chaque portail
$req = mysql_query("SHOW DATABASES LIKE '%_one%';");
while($data = mysql_fetch_array($req)) {
$db_name = $data[0];
$db = mysql_select_db( $db_name ) or die ('ERREUR '.mysql_error());
//echo "DATABASE USED : $db_name\n";
/*if($db_name != "avantec_one") { */
$req2 = mysql_query("SHOW tables LIKE 'ta_d_licence_by_os';");
//$data2 = mysql_fetch_array($req2);
if($data2[0]) {
//Création de la requête SQL
$sql = ("SELECT day, os_id, licence_installed, licence_connected, licence_kpi, licence_charged
FROM ta_d_licence_by_os");
//Exécution de la requête SQL:
$requete = mysql_query($sql) or die ('ERREUR ' .mysql_error()) ;
$table_data = array();
while($data2 = mysql_fetch_array($requete)) {
//Connection à la base operations_statistiques
$db = mysql_select_db("operations_statistiques");
$insert = "INSERT INTO ta_d_licence_by_os_stat (day, os_id, licence_installed, licence_connected, licence_kpi, licence_charged)
VALUES ('".$data2['day']."', '".$data2['os_id']."', '".$data2['licence_installed']."', '".$data2['licence_connected']."', '".$data2['licence_kpi']."', '".$data2['licence_charged']."')";
$rs = mysql_query($insert);
}
}
// Affichage de la liste des agents installés/os/mois
$sql2= ("SELECT MONTH(day) as day_month,YEAR(day) as day_year,
SUM(licence_installed) as licence_installed,
SUM(licence_charged) as licence_charged,
SUM(licence_connected) as licence_connected,
SUM(licence_kpi) as licence_kpi,
os_id
FROM ta_d_licence_by_os_stat
GROUP BY MONTH(day),YEAR(day),os_id
ORDER BY day_year,day_month ASC,os_id");
}
//exécution de la requête SQL:
$requete2 = mysql_query($sql2);
while($data = mysql_fetch_array($requete2)){
// on affiche les résultats
echo 'Portail :' .$data['portail'];
echo ' - Date (mois/année) : '.$data['day_month'];
echo '/'.$data['day_year'];
echo ' - Os : '.$data['os_id'].'<br />';
echo 'Licences installées : '.$data['licence_installed'];
echo ' - Licences chargées : '.$data['licence_charged'];
echo ' - Licences connectées : '.$data['licence_connected'];
echo ' - Licences kpi: '.$data['licence_kpi'].'<br />' .'<br />';
}
mysql_close();
exit();
?> |
