Debian Codegraph @

library/Toplevelview/Model/ServicegroupSummary.php

raw
1 <?php
2
3 namespace Icinga\Module\Toplevelview\Model;
4
5 use Icinga\Module\Icingadb\Common\Auth;
6 use Icinga\Module\Icingadb\Model\Service;
7 use Icinga\Module\Icingadb\Model\Servicegroup;
8
9 use ipl\Orm\Behavior\Binary;
10 use ipl\Orm\Behaviors;
11 use ipl\Orm\Query;
12 use ipl\Orm\Relations;
13 use ipl\Orm\UnionModel;
14 use ipl\Orm\UnionQuery;
15 use ipl\Sql\Adapter\Pgsql;
16 use ipl\Sql\Connection;
17 use ipl\Sql\Expression;
18 use ipl\Sql\Select;
19
20 /**
21 * Servicegroupsummary is a custom model we use to add more columns than the IcingaDB Servicegroupsummary
22 */
23 class ServicegroupSummary extends UnionModel
24 {
25 public static function on(Connection $db): UnionQuery
26 {
27 $q = parent::on($db);
28
29 $q->on(
30 Query::ON_SELECT_ASSEMBLED,
31 function () use ($q) {
32 $auth = new class () {
33 use Auth;
34 };
35
36 $auth->assertColumnRestrictions($q->getFilter());
37 }
38 );
39
40 $q->on($q::ON_SELECT_ASSEMBLED, function (Select $select) use ($q) {
41 $model = $q->getModel();
42
43 $groupBy = $q->getResolver()->qualifyColumnsAndAliases((array) $model->getKeyName(), $model, false);
44
45 // For PostgreSQL, ALL non-aggregate SELECT columns must appear in the GROUP BY clause:
46 if ($q->getDb()->getAdapter() instanceof Pgsql) {
47 /**
48 * Ignore Expressions, i.e. aggregate functions {@see getColumns()},
49 * which do not need to be added to the GROUP BY.
50 */
51 $candidates = array_filter($select->getColumns(), 'is_string');
52 // Remove already considered columns for the GROUP BY, i.e. the primary key.
53 $candidates = array_diff_assoc($candidates, $groupBy);
54 $groupBy = array_merge($groupBy, $candidates);
55 }
56
57 $select->groupBy($groupBy);
58 });
59
60 return $q;
61 }
62
63 public function getTableName()
64 {
65 return 'servicegroup';
66 }
67
68 public function getKeyName()
69 {
70 return ['id' => 'servicegroup_id'];
71 }
72
73 public function getColumns()
74 {
75 return [
76 'name' => 'servicegroup_name',
77 'name_ci' => 'servicegroup_name_ci',
78 'display_name' => 'servicegroup_display_name',
79 'services_critical_handled' => new Expression(
80 'SUM(CASE WHEN service_state = 2'
81 . ' AND (service_handled = \'y\' OR service_reachable = \'n\') THEN 1 ELSE 0 END)'
82 ),
83 'services_critical_unhandled' => new Expression(
84 'SUM(CASE WHEN service_state = 2'
85 . ' AND service_handled = \'n\' AND service_reachable = \'y\' THEN 1 ELSE 0 END)'
86 ),
87 'services_ok' => new Expression(
88 'SUM(CASE WHEN service_state = 0 THEN 1 ELSE 0 END)'
89 ),
90 'services_pending' => new Expression(
91 'SUM(CASE WHEN service_state = 99 THEN 1 ELSE 0 END)'
92 ),
93 'services_total' => new Expression(
94 'SUM(CASE WHEN service_id IS NOT NULL THEN 1 ELSE 0 END)'
95 ),
96 'services_unknown_handled' => new Expression(
97 'SUM(CASE WHEN service_state = 3'
98 . ' AND (service_handled = \'y\' OR service_reachable = \'n\') THEN 1 ELSE 0 END)'
99 ),
100 'services_unknown_unhandled' => new Expression(
101 'SUM(CASE WHEN service_state = 3'
102 . ' AND service_handled = \'n\' AND service_reachable = \'y\' THEN 1 ELSE 0 END)'
103 ),
104 'services_warning_handled' => new Expression(
105 'SUM(CASE WHEN service_state = 1'
106 . ' AND (service_handled = \'y\' OR service_reachable = \'n\') THEN 1 ELSE 0 END)'
107 ),
108 'services_warning_unhandled' => new Expression(
109 'SUM(CASE WHEN service_state = 1'
110 . ' AND service_handled = \'n\' AND service_reachable = \'y\' THEN 1 ELSE 0 END)'
111 ),
112 'services_severity' => new Expression('MAX(service_severity)'),
113 'services_downtime_handled' => new Expression(
114 'SUM(CASE WHEN service_state != 1 AND service_in_downtime = \'y\' THEN 1 ELSE 0 END)'
115 ),
116 'services_downtime_active' => new Expression(
117 'SUM(CASE WHEN service_in_downtime = \'y\' THEN 1 ELSE 0 END)'
118 ),
119 ];
120 }
121
122 public function getSearchColumns()
123 {
124 return ['name_ci', 'display_name'];
125 }
126
127 public function getDefaultSort()
128 {
129 return 'display_name';
130 }
131
132 public function getUnions(): array
133 {
134 $unions = [
135 [
136 Service::class,
137 [
138 'servicegroup',
139 'state'
140 ],
141 [
142 'servicegroup_id' => 'servicegroup.id',
143 'servicegroup_name' => 'servicegroup.name',
144 'servicegroup_name_ci' => 'servicegroup.name_ci',
145 'servicegroup_display_name' => 'servicegroup.display_name',
146 'service_id' => 'service.id',
147 'service_state' => 'state.hard_state',
148 'service_handled' => 'state.is_handled',
149 'service_reachable' => 'state.is_reachable',
150 'service_severity' => 'state.severity',
151 'service_in_downtime' => 'state.in_downtime',
152 ]
153 ],
154 [
155 Servicegroup::class,
156 [],
157 [
158 'servicegroup_id' => 'servicegroup.id',
159 'servicegroup_name' => 'servicegroup.name',
160 'servicegroup_name_ci' => 'servicegroup.name_ci',
161 'servicegroup_display_name' => 'servicegroup.display_name',
162 'service_id' => new Expression('NULL'),
163 'service_state' => new Expression('NULL'),
164 'service_handled' => new Expression('NULL'),
165 'service_reachable' => new Expression('NULL'),
166 'service_severity' => new Expression('0'),
167 'service_in_downtime' => new Expression('NULL'),
168 ]
169 ]
170 ];
171
172 return $unions;
173 }
174
175 public function createBehaviors(Behaviors $behaviors)
176 {
177 $behaviors->add(new Binary([
178 'id'
179 ]));
180
181 // This is because there is no better way
182 (new Servicegroup())->createBehaviors($behaviors);
183 }
184
185 public function createRelations(Relations $relations)
186 {
187 // This is because there is no better way
188 (new Servicegroup())->createRelations($relations);
189 }
190
191 public function getColumnDefinitions()
192 {
193 // This is because there is no better way
194 return (new Servicegroup())->getColumnDefinitions();
195 }
196 }