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
103
104
105
106
107
108
109
110
111
112
113
|
<?php
/*
* Copyright 2005-2016 OCSInventory-NG/OCSInventory-ocsreports contributors.
* See the Contributors file for more details about them.
*
* This file is part of OCSInventory-NG/OCSInventory-ocsreports.
*
* OCSInventory-NG/OCSInventory-ocsreports is free software: you can redistribute
* it and/or modify it under the terms of the GNU General Public License as
* published by the Free Software Foundation, either version 2 of the License,
* or (at your option) any later version.
*
* OCSInventory-NG/OCSInventory-ocsreports is distributed in the hope that it
* will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
* of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with OCSInventory-NG/OCSInventory-ocsreports. if not, write to the
* Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
* MA 02110-1301, USA.
*/
require('require/function_stats.php');
require('require/charts/StatsChartsRenderer.php');
$year_mouth['Dec'] = 12;
$year_mouth['Nov'] = 11;
$year_mouth['Oct'] = 10;
$year_mouth['Sep'] = 9;
$year_mouth['Aug'] = 8;
$year_mouth['Jul'] = 7;
$year_mouth['Jun'] = 6;
$year_mouth['May'] = 5;
$year_mouth['Apr'] = 4;
$year_mouth['Mar'] = 3;
$year_mouth['Feb'] = 2;
$year_mouth['Jan'] = 1;
$sql = "select count(*) c from devices d,
download_enable d_e,download_available d_a
where d.name='DOWNLOAD'
and d_e.id=d.ivalue
and d_a.fileid=d_e.fileid
and d_e.fileid='%s'";
$arg = $protectedGet['stat'];
$result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $arg);
$item = mysqli_fetch_object($result);
$total_mach = $item->c;
if ($total_mach <= 0) {
msg_error($l->g(837));
require_once(FOOTER_HTML);
die();
}
$sql = "select d.hardware_id as id,d.comments as date_valid
from devices d,download_enable d_e,download_available d_a
where d.name='DOWNLOAD'
and tvalue='%s'
and comments is not null
and d_e.id=d.ivalue
and d_a.fileid=d_e.fileid
and d_e.fileid='%s'";
$arg = array(urldecode($protectedGet['ta']), $protectedGet['stat']);
$result = mysql2_query_secure($sql, $_SESSION['OCS']["readServer"], $arg);
$nb_4_hour = array();
while ($item = mysqli_fetch_object($result)) {
unset($data_temp, $day, $year, $hour_temp, $hour);
$data_temp = explode(' ', $item->date_valid);
if ($data_temp[2] != '') {
$day = $data_temp[2];
} else {
$day = $data_temp[3];
}
$mouth = $data_temp[1];
if (isset($data_temp[5])) {
$year = $data_temp[5];
} else {
$year = $data_temp[4];
}
$hour_temp = explode(':', $data_temp[3]);
$hour = $hour_temp[0];
if ($hour < 12) {
$hour = 12;
} else {
$hour = 00;
}
$timestamp = mktime($hour, 0, 0, $year_mouth[$mouth], $day, $year);
if (isset($nb_4_hour[$timestamp])) {
$nb_4_hour[$timestamp] ++;
} else {
$nb_4_hour[$timestamp] = 1;
}
}
ksort($nb_4_hour);
$i = 0;
foreach ($nb_4_hour as $key => $value) {
$ancienne += $value;
$data[$i] = round((($ancienne * 100) / $total_mach), 2);
$legende[$i] = date("d/m/Y H:00", $key);
$i++;
}
if (isset($data) && count($data) != 1) {
$stats = new StatsChartsRenderer;
$stats->createChartCanvas("teledeploy_speed", false, false);
$stats->createPointChart("teledeploy_speed", $legende, $data, $l->g(1125));
} else {
msg_warning($l->g(989));
}
?>
|
