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
114
115
116
117
118
119
120
121
122
123
|
<?php
/*
** Zabbix
** Copyright (C) 2001-2016 Zabbix SIA
**
** This program 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.
**
** This program 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 this program; if not, write to the Free Software
** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
**/
class CScreenHostsInfo extends CScreenBase {
/**
* Process screen.
*
* @return CDiv (screen inside container)
*/
public function get() {
$total = 0;
// fetch accessible host ids
$hosts = API::Host()->get([
'output' => ['hostid'],
'preservekeys' => true
]);
$hostids = array_keys($hosts);
if ($this->screenitem['resourceid'] != 0) {
$cond_from = ',hosts_groups hg';
$cond_where = ' AND hg.hostid=h.hostid AND hg.groupid='.zbx_dbstr($this->screenitem['resourceid']);
}
else {
$cond_from = '';
$cond_where = '';
}
$db_host_cnt = DBselect(
'SELECT COUNT(DISTINCT h.hostid) AS cnt'.
' FROM hosts h'.$cond_from.
' WHERE h.available='.HOST_AVAILABLE_TRUE.
' AND h.status IN ('.HOST_STATUS_MONITORED.','.HOST_STATUS_NOT_MONITORED.')'.
' AND '.dbConditionInt('h.hostid', $hostids).
$cond_where
);
$host_cnt = DBfetch($db_host_cnt);
$avail = $host_cnt['cnt'];
$total += $host_cnt['cnt'];
$db_host_cnt = DBselect(
'SELECT COUNT(DISTINCT h.hostid) AS cnt'.
' FROM hosts h'.$cond_from.
' WHERE h.available='.HOST_AVAILABLE_FALSE.
' AND h.status IN ('.HOST_STATUS_MONITORED.','.HOST_STATUS_NOT_MONITORED.')'.
' AND '.dbConditionInt('h.hostid', $hostids).
$cond_where
);
$host_cnt = DBfetch($db_host_cnt);
$notav = $host_cnt['cnt'];
$total += $host_cnt['cnt'];
$db_host_cnt = DBselect(
'SELECT COUNT(DISTINCT h.hostid) AS cnt'.
' FROM hosts h'.$cond_from.
' WHERE h.available='.HOST_AVAILABLE_UNKNOWN.
' AND h.status IN ('.HOST_STATUS_MONITORED.','.HOST_STATUS_NOT_MONITORED.')'.
' AND '.dbConditionInt('h.hostid', $hostids).
$cond_where
);
$host_cnt = DBfetch($db_host_cnt);
$uncn = $host_cnt['cnt'];
$total += $host_cnt['cnt'];
$avail = (new CCol($avail.' '._('Available')))->addClass(ZBX_STYLE_GREEN);
$notav = (new CCol($notav.' '._('Not available')))->addClass(ZBX_STYLE_RED);
$uncn = (new CCol($uncn.' '._('Unknown')))->addClass(ZBX_STYLE_GREY);
$total = new CCol($total.' '._('Total'));
$header = (new CDiv([
new CTag('h4', true, _('Hosts info'))
]))->addClass(ZBX_STYLE_DASHBRD_WIDGET_HEAD);
if ($this->screenitem['resourceid'] != 0) {
$groups = API::HostGroup()->get([
'output' => ['name'],
'groupids' => [$this->screenitem['resourceid']]
]);
$header->addItem((new CList())->addItem([_('Group'), ':', SPACE, $groups[0]['name']]));
}
$table = new CTableInfo();
if ($this->screenitem['style'] == STYLE_HORIZONTAL) {
$table->addRow([$avail, $notav, $uncn, $total]);
}
else {
$table->addRow($avail);
$table->addRow($notav);
$table->addRow($uncn);
$table->addRow($total);
}
$footer = (new CList())
->addItem(_s('Updated: %s', zbx_date2str(TIME_FORMAT_SECONDS)))
->addClass(ZBX_STYLE_DASHBRD_WIDGET_FOOT);
return $this->getOutput(new CUiWidget(uniqid(), [$header, $table, $footer]));
}
}
|
