mirror of
https://github.com/Icinga/icingadb-web.git
synced 2026-02-20 00:10:09 -05:00
5e982dad40
* Auth: Add method `assertColumnRestrictions` * ObjectSuggestions: Do not suggest protected variables `assertColumnRestrictions` does not allow to use them anymore, hence we should not suggest them in searches as well to not to let the user run into an error by accepting a suggestion. Though, when fetching values as well, we still have to obfuscate, otherwise protected vars won't show up in details anymore. * Introduce Icinga\Module\Icingadb\Common\Model Must be used as base for all models, to ensure column restrictions are asserted on filters. * Utilize `Icinga\Module\Icingadb\Common\Model` where applicable
106 lines
3 KiB
PHP
106 lines
3 KiB
PHP
<?php
|
|
|
|
/* Icinga DB Web | (c) 2020 Icinga GmbH | GPLv2 */
|
|
|
|
namespace Icinga\Module\Icingadb\Model;
|
|
|
|
use Icinga\Module\Icingadb\Model\Behavior\ReRoute;
|
|
use ipl\Orm\Behavior\Binary;
|
|
use ipl\Orm\Behaviors;
|
|
use Icinga\Module\Icingadb\Common\Model;
|
|
use ipl\Orm\Relations;
|
|
|
|
/**
|
|
* @property string $id
|
|
* @property string $environment_id
|
|
* @property string $name_checksum
|
|
* @property string $properties_checksum
|
|
* @property string $name
|
|
* @property string $name_ci
|
|
* @property string $display_name
|
|
* @property ?string $zone_id
|
|
*/
|
|
class Usergroup extends Model
|
|
{
|
|
public function getTableName()
|
|
{
|
|
return 'usergroup';
|
|
}
|
|
|
|
public function getKeyName()
|
|
{
|
|
return 'id';
|
|
}
|
|
|
|
public function getColumns()
|
|
{
|
|
return [
|
|
'environment_id',
|
|
'name_checksum',
|
|
'properties_checksum',
|
|
'name',
|
|
'name_ci',
|
|
'display_name',
|
|
'zone_id'
|
|
];
|
|
}
|
|
|
|
public function getColumnDefinitions()
|
|
{
|
|
return [
|
|
'environment_id' => t('Environment Id'),
|
|
'name_checksum' => t('Contactgroup Name Checksum'),
|
|
'properties_checksum' => t('Contactgroup Properties Checksum'),
|
|
'name' => t('Contactgroup Name'),
|
|
'name_ci' => t('Contactgroup Name (CI)'),
|
|
'display_name' => t('Contactgroup Display Name'),
|
|
'zone_id' => t('Zone Id')
|
|
];
|
|
}
|
|
|
|
public function getSearchColumns()
|
|
{
|
|
return ['name_ci', 'display_name'];
|
|
}
|
|
|
|
public function getDefaultSort()
|
|
{
|
|
return 'usergroup.display_name';
|
|
}
|
|
|
|
public function createBehaviors(Behaviors $behaviors)
|
|
{
|
|
$behaviors->add(new ReRoute([
|
|
'host' => 'notification.host',
|
|
'service' => 'notification.service',
|
|
'hostgroup' => 'notification.host.hostgroup',
|
|
'servicegroup' => 'notification.service.servicegroup'
|
|
]));
|
|
|
|
$behaviors->add(new Binary([
|
|
'id',
|
|
'environment_id',
|
|
'name_checksum',
|
|
'properties_checksum',
|
|
'zone_id'
|
|
]));
|
|
}
|
|
|
|
public function createRelations(Relations $relations)
|
|
{
|
|
$relations->belongsTo('environment', Environment::class);
|
|
$relations->belongsTo('zone', Zone::class);
|
|
|
|
$relations->belongsToMany('customvar', Customvar::class)
|
|
->through(UsergroupCustomvar::class)
|
|
->setThroughAlias('t_usergroup_customvar');
|
|
$relations->belongsToMany('customvar_flat', CustomvarFlat::class)
|
|
->through(UsergroupCustomvar::class);
|
|
$relations->belongsToMany('vars', Vars::class)
|
|
->through(UsergroupCustomvar::class);
|
|
$relations->belongsToMany('user', User::class)
|
|
->through(UsergroupMember::class);
|
|
$relations->belongsToMany('notification', Notification::class)
|
|
->through('notification_recipient');
|
|
}
|
|
}
|