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
103 lines
3 KiB
PHP
103 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 $prefer_includes
|
|
* @property ?string $zone_id
|
|
*/
|
|
class Timeperiod extends Model
|
|
{
|
|
public function getTableName()
|
|
{
|
|
return 'timeperiod';
|
|
}
|
|
|
|
public function getKeyName()
|
|
{
|
|
return 'id';
|
|
}
|
|
|
|
public function getColumns()
|
|
{
|
|
return [
|
|
'environment_id',
|
|
'name_checksum',
|
|
'properties_checksum',
|
|
'name',
|
|
'name_ci',
|
|
'display_name',
|
|
'prefer_includes',
|
|
'zone_id'
|
|
];
|
|
}
|
|
|
|
public function getColumnDefinitions()
|
|
{
|
|
return [
|
|
'environment_id' => t('Environment Id'),
|
|
'name_checksum' => t('Timeperiod Name Checksum'),
|
|
'properties_checksum' => t('Timeperiod Properties Checksum'),
|
|
'name' => t('Timeperiod Name'),
|
|
'name_ci' => t('Timeperiod Name (CI)'),
|
|
'display_name' => t('Timeperiod Display Name'),
|
|
'prefer_includes' => t('Timeperiod Prefer Includes'),
|
|
'zone_id' => t('Zone Id')
|
|
];
|
|
}
|
|
|
|
public function createBehaviors(Behaviors $behaviors)
|
|
{
|
|
$behaviors->add(new ReRoute([
|
|
'hostgroup' => 'host.hostgroup',
|
|
'servicegroup' => '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(TimeperiodCustomvar::class)
|
|
->setThroughAlias('t_timeperiod_customvar');
|
|
$relations->belongsToMany('customvar_flat', CustomvarFlat::class)
|
|
->through(TimeperiodCustomvar::class);
|
|
$relations->belongsToMany('vars', Vars::class)
|
|
->through(TimeperiodCustomvar::class);
|
|
|
|
// TODO: Decide how to establish the override relations
|
|
|
|
$relations->hasMany('range', TimeperiodRange::class);
|
|
$relations->hasMany('host', Host::class)
|
|
->setForeignKey('check_timeperiod_id');
|
|
$relations->hasMany('Notification', Notification::class);
|
|
$relations->hasMany('service', Service::class)
|
|
->setForeignKey('check_timeperiod_id');
|
|
$relations->hasMany('user', User::class);
|
|
}
|
|
}
|