mirror of
https://github.com/Icinga/icingadb-web.git
synced 2026-05-28 04:36:06 -04:00
3c8ed68cc6
This was easy because only README.md and doc/01-About.md were redacted manually, everything else via: git ls-files -z |xargs -0 perl -pi -e 's/Icinga GmbH \| GPLv2/Icinga GmbH | GPLv2+/' This is legal because we have only merged PRs with label:cla/signed or made by Icinga staff: https://github.com/Icinga/icingadb-web/pulls?page=1&q=is%3Apr+is%3Aclosed+-label%3Acla%2Fsigned+-author%3Anilmerg This has no risk for us in people distributing their own version under GPLv3 only. After all, we won't take their patches anyway, unless they sign our CLA. This is the cleanest solution for having e.g. these in one address space: * Icinga Web, GPLv2+ * K8s Web, AGPLv3 * Thirdparty, some LGPLv3 and Apache-2.0 Apropos, K8s Web is even v3-licensed on purpose, to have a stronger protection against cloud ops.
251 lines
9.4 KiB
PHP
251 lines
9.4 KiB
PHP
<?php
|
|
|
|
/* Icinga DB Web | (c) 2020 Icinga GmbH | GPLv2+ */
|
|
|
|
namespace Icinga\Module\Icingadb\Model;
|
|
|
|
use Icinga\Module\Icingadb\Common\Auth;
|
|
use ipl\Orm\Behavior\Binary;
|
|
use ipl\Orm\Behaviors;
|
|
use ipl\Orm\Query;
|
|
use ipl\Orm\Relations;
|
|
use ipl\Orm\UnionModel;
|
|
use ipl\Sql\Adapter\Pgsql;
|
|
use ipl\Sql\Connection;
|
|
use ipl\Sql\Expression;
|
|
use ipl\Sql\Select;
|
|
|
|
/**
|
|
* @property string $id
|
|
* @property string $display_name
|
|
* @property string $name_ci
|
|
* @property string $name
|
|
* @property int $hosts_down_handled
|
|
* @property int $hosts_down_unhandled
|
|
* @property int $hosts_pending
|
|
* @property int $hosts_total
|
|
* @property int $hosts_up
|
|
* @property int $hosts_severity
|
|
* @property int $services_critical_handled
|
|
* @property int $services_critical_unhandled
|
|
* @property int $services_ok
|
|
* @property int $services_pending
|
|
* @property int $services_total
|
|
* @property int $services_unknown_handled
|
|
* @property int $services_unknown_unhandled
|
|
* @property int $services_warning_handled
|
|
* @property int $services_warning_unhandled
|
|
*/
|
|
class Hostgroupsummary extends UnionModel
|
|
{
|
|
public static function on(Connection $db)
|
|
{
|
|
$q = parent::on($db);
|
|
|
|
$q->on(
|
|
Query::ON_SELECT_ASSEMBLED,
|
|
function () use ($q) {
|
|
$auth = new class () {
|
|
use Auth;
|
|
};
|
|
|
|
$auth->assertColumnRestrictions($q->getFilter());
|
|
}
|
|
);
|
|
|
|
$q->on($q::ON_SELECT_ASSEMBLED, function (Select $select) use ($q) {
|
|
$model = $q->getModel();
|
|
|
|
$groupBy = $q->getResolver()->qualifyColumnsAndAliases((array) $model->getKeyName(), $model, false);
|
|
|
|
// For PostgreSQL, ALL non-aggregate SELECT columns must appear in the GROUP BY clause:
|
|
if ($q->getDb()->getAdapter() instanceof Pgsql) {
|
|
/**
|
|
* Ignore Expressions, i.e. aggregate functions {@see getColumns()},
|
|
* which do not need to be added to the GROUP BY.
|
|
*/
|
|
$candidates = array_filter($select->getColumns(), 'is_string');
|
|
// Remove already considered columns for the GROUP BY, i.e. the primary key.
|
|
$candidates = array_diff_assoc($candidates, $groupBy);
|
|
$groupBy = array_merge($groupBy, $candidates);
|
|
}
|
|
|
|
$select->groupBy($groupBy);
|
|
});
|
|
|
|
return $q;
|
|
}
|
|
|
|
public function getTableName()
|
|
{
|
|
return 'hostgroup';
|
|
}
|
|
|
|
public function getKeyName()
|
|
{
|
|
return ['id' => 'hostgroup_id'];
|
|
}
|
|
|
|
public function getColumns()
|
|
{
|
|
return [
|
|
'name' => 'hostgroup_name',
|
|
'name_ci' => 'hostgroup_name_ci',
|
|
'display_name' => 'hostgroup_display_name',
|
|
'hosts_down_handled' => new Expression(
|
|
'SUM(CASE WHEN host_state = 1'
|
|
. ' AND (host_handled = \'y\' OR host_reachable = \'n\') THEN 1 ELSE 0 END)'
|
|
),
|
|
'hosts_down_unhandled' => new Expression(
|
|
'SUM(CASE WHEN host_state = 1'
|
|
. ' AND host_handled = \'n\' AND host_reachable = \'y\' THEN 1 ELSE 0 END)'
|
|
),
|
|
'hosts_pending' => new Expression(
|
|
'SUM(CASE WHEN host_state = 99 THEN 1 ELSE 0 END)'
|
|
),
|
|
'hosts_total' => new Expression(
|
|
'SUM(CASE WHEN host_id IS NOT NULL THEN 1 ELSE 0 END)'
|
|
),
|
|
'hosts_up' => new Expression(
|
|
'SUM(CASE WHEN host_state = 0 THEN 1 ELSE 0 END)'
|
|
),
|
|
'hosts_severity' => new Expression('MAX(host_severity)'),
|
|
'services_critical_handled' => new Expression(
|
|
'SUM(CASE WHEN service_state = 2'
|
|
. ' AND (service_handled = \'y\' OR service_reachable = \'n\') THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_critical_unhandled' => new Expression(
|
|
'SUM(CASE WHEN service_state = 2'
|
|
. ' AND service_handled = \'n\' AND service_reachable = \'y\' THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_ok' => new Expression(
|
|
'SUM(CASE WHEN service_state = 0 THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_pending' => new Expression(
|
|
'SUM(CASE WHEN service_state = 99 THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_total' => new Expression(
|
|
'SUM(CASE WHEN service_id IS NOT NULL THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_unknown_handled' => new Expression(
|
|
'SUM(CASE WHEN service_state = 3'
|
|
. ' AND (service_handled = \'y\' OR service_reachable = \'n\') THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_unknown_unhandled' => new Expression(
|
|
'SUM(CASE WHEN service_state = 3'
|
|
. ' AND service_handled = \'n\' AND service_reachable = \'y\' THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_warning_handled' => new Expression(
|
|
'SUM(CASE WHEN service_state = 1'
|
|
. ' AND (service_handled = \'y\' OR service_reachable = \'n\') THEN 1 ELSE 0 END)'
|
|
),
|
|
'services_warning_unhandled' => new Expression(
|
|
'SUM(CASE WHEN service_state = 1'
|
|
. ' AND service_handled = \'n\' AND service_reachable = \'y\' THEN 1 ELSE 0 END)'
|
|
)
|
|
];
|
|
}
|
|
|
|
public function getSearchColumns()
|
|
{
|
|
return ['name_ci', 'display_name'];
|
|
}
|
|
|
|
public function getDefaultSort()
|
|
{
|
|
return 'display_name';
|
|
}
|
|
|
|
public function getUnions()
|
|
{
|
|
$unions = [
|
|
[
|
|
Host::class,
|
|
[
|
|
'hostgroup',
|
|
'state'
|
|
],
|
|
[
|
|
'hostgroup_id' => 'hostgroup.id',
|
|
'hostgroup_name' => 'hostgroup.name',
|
|
'hostgroup_name_ci' => 'hostgroup.name_ci',
|
|
'hostgroup_display_name' => 'hostgroup.display_name',
|
|
'host_id' => 'host.id',
|
|
'host_state' => 'state.soft_state',
|
|
'host_handled' => 'state.is_handled',
|
|
'host_reachable' => 'state.is_reachable',
|
|
'host_severity' => 'state.severity',
|
|
'service_id' => new Expression('NULL'),
|
|
'service_state' => new Expression('NULL'),
|
|
'service_handled' => new Expression('NULL'),
|
|
'service_reachable' => new Expression('NULL')
|
|
]
|
|
],
|
|
[
|
|
Service::class,
|
|
[
|
|
'hostgroup',
|
|
'state'
|
|
],
|
|
[
|
|
'hostgroup_id' => 'hostgroup.id',
|
|
'hostgroup_name' => 'hostgroup.name',
|
|
'hostgroup_name_ci' => 'hostgroup.name_ci',
|
|
'hostgroup_display_name' => 'hostgroup.display_name',
|
|
'host_id' => new Expression('NULL'),
|
|
'host_state' => new Expression('NULL'),
|
|
'host_handled' => new Expression('NULL'),
|
|
'host_reachable' => new Expression('NULL'),
|
|
'host_severity' => new Expression('0'),
|
|
'service_id' => 'service.id',
|
|
'service_state' => 'state.soft_state',
|
|
'service_handled' => 'state.is_handled',
|
|
'service_reachable' => 'state.is_reachable'
|
|
]
|
|
],
|
|
[
|
|
Hostgroup::class,
|
|
[],
|
|
[
|
|
'hostgroup_id' => 'hostgroup.id',
|
|
'hostgroup_name' => 'hostgroup.name',
|
|
'hostgroup_name_ci' => 'hostgroup.name_ci',
|
|
'hostgroup_display_name' => 'hostgroup.display_name',
|
|
'host_id' => new Expression('NULL'),
|
|
'host_state' => new Expression('NULL'),
|
|
'host_handled' => new Expression('NULL'),
|
|
'host_reachable' => new Expression('NULL'),
|
|
'host_severity' => new Expression('0'),
|
|
'service_id' => new Expression('NULL'),
|
|
'service_state' => new Expression('NULL'),
|
|
'service_handled' => new Expression('NULL'),
|
|
'service_reachable' => new Expression('NULL')
|
|
]
|
|
]
|
|
];
|
|
|
|
return $unions;
|
|
}
|
|
|
|
public function createBehaviors(Behaviors $behaviors)
|
|
{
|
|
$behaviors->add(new Binary([
|
|
'id'
|
|
]));
|
|
|
|
// This is because there is no better way
|
|
(new Hostgroup())->createBehaviors($behaviors);
|
|
}
|
|
|
|
public function createRelations(Relations $relations)
|
|
{
|
|
// This is because there is no better way
|
|
(new Hostgroup())->createRelations($relations);
|
|
}
|
|
|
|
public function getColumnDefinitions()
|
|
{
|
|
// This is because there is no better way
|
|
return (new Hostgroup())->getColumnDefinitions();
|
|
}
|
|
}
|