/usr/share/icingaweb2/modules/monitoring/library/Monitoring/Backend/Ido/Query/AllcontactsQuery.php is in icingaweb2-module-monitoring 2.1.0-1ubuntu1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 | <?php
/* Icinga Web 2 | (c) 2013-2015 Icinga Development Team | GPLv2+ */
namespace Icinga\Module\Monitoring\Backend\Ido\Query;
use Zend_Db_Select;
class AllcontactsQuery extends IdoQuery
{
protected $columnMap = array(
'contacts' => array(
'contact_name' => 'c.contact_name',
'host_object_id' => 'c.host_object_id',
'host_name' => 'c.host_name',
'service_object_id' => 'c.service_object_id',
'service_host_name' => 'c.service_host_name',
'service_description' => 'c.service_description',
'contact_alias' => 'c.contact_alias',
'contact_email' => 'c.contact_email',
'contact_pager' => 'c.contact_pager',
'contact_has_host_notfications' => 'c.contact_has_host_notfications',
'contact_has_service_notfications' => 'c.contact_has_service_notfications',
'contact_can_submit_commands' => 'c.contact_can_submit_commands',
'contact_notify_service_recovery' => 'c.notify_service_recovery',
'contact_notify_service_warning' => 'c.notify_service_warning',
'contact_notify_service_critical' => 'c.notify_service_critical',
'contact_notify_service_unknown' => 'c.notify_service_unknown',
'contact_notify_service_flapping' => 'c.notify_service_flapping',
'contact_notify_service_downtime' => 'c.notify_service_recovery',
'contact_notify_host_recovery' => 'c.notify_host_recovery',
'contact_notify_host_down' => 'c.notify_host_down',
'contact_notify_host_unreachable' => 'c.notify_host_unreachable',
'contact_notify_host_flapping' => 'c.notify_host_flapping',
'contact_notify_host_downtime' => 'c.notify_host_downtime',
)
);
protected $contacts;
protected $contactgroups;
protected $useSubqueryCount = true;
public function requireColumn($alias)
{
$this->contacts->addColumn($alias);
$this->contactgroups->addColumn($alias);
return parent::requireColumn($alias);
}
protected function joinBaseTables()
{
$this->contacts = $this->createSubQuery(
'contact',
array('contact_name')
);
$this->contactgroups = $this->createSubQuery(
'contactgroup',
array('contact_name')
);
$sub = $this->db->select()->union(
array($this->contacts, $this->contactgroups),
Zend_Db_Select::SQL_UNION_ALL
);
$this->baseQuery = $this->db->select()->distinct()->from(
array('c' => $sub),
array()
);
$this->joinedVirtualTables = array('contacts' => true);
}
}
|