mirror of
https://github.com/Icinga/icingadb-web.git
synced 2026-05-28 04:36:06 -04: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
73 lines
1.7 KiB
PHP
73 lines
1.7 KiB
PHP
<?php
|
|
|
|
/* Icinga DB Web | (c) 2025 Icinga GmbH | GPLv2 */
|
|
|
|
namespace Icinga\Module\Icingadb\Model;
|
|
|
|
use ipl\Orm\Behavior\Binary;
|
|
use ipl\Orm\Behavior\MillisecondTimestamp;
|
|
use ipl\Orm\Behaviors;
|
|
use Icinga\Module\Icingadb\Common\Model;
|
|
use ipl\Orm\Relations;
|
|
|
|
/**
|
|
* Model for table `sla_history_state`
|
|
*
|
|
* @property string $environment_id
|
|
* @property ?string $endpoint_id
|
|
* @property string $object_type
|
|
* @property string $host_id
|
|
* @property ?string $service_id
|
|
* @property string $downtime_id
|
|
* @property string $downtime_start
|
|
* @property string $downtime_end
|
|
*/
|
|
class SlaHistoryState extends Model
|
|
{
|
|
public function getTableName()
|
|
{
|
|
return 'sla_history_state';
|
|
}
|
|
|
|
public function getKeyName()
|
|
{
|
|
return 'id';
|
|
}
|
|
|
|
public function getColumns()
|
|
{
|
|
return [
|
|
'environment_id',
|
|
'endpoint_id',
|
|
'object_type',
|
|
'host_id',
|
|
'service_id',
|
|
'event_time',
|
|
'hard_state',
|
|
'previous_hard_state'
|
|
];
|
|
}
|
|
|
|
public function createBehaviors(Behaviors $behaviors)
|
|
{
|
|
$behaviors->add(new MillisecondTimestamp([
|
|
'event_time'
|
|
]));
|
|
|
|
$behaviors->add(new Binary([
|
|
'environment_id',
|
|
'endpoint_id',
|
|
'host_id',
|
|
'service_id',
|
|
'downtime_id'
|
|
]));
|
|
}
|
|
|
|
public function createRelations(Relations $relations)
|
|
{
|
|
$relations->belongsTo('endpoint', Endpoint::class);
|
|
$relations->belongsTo('environment', Environment::class);
|
|
$relations->belongsTo('host', Host::class)->setJoinType('LEFT');
|
|
$relations->belongsTo('service', Service::class)->setJoinType('LEFT');
|
|
}
|
|
}
|