t('Environment Id'), 'name_checksum' => t('Service Name Checksum'), 'properties_checksum' => t('Service Properties Checksum'), 'host_id' => t('Host Id'), 'name' => t('Service Name'), 'name_ci' => t('Service Name (CI)'), 'display_name' => t('Service Display Name'), 'checkcommand_name' => t('Checkcommand Name'), 'checkcommand_id' => t('Checkcommand Id'), 'max_check_attempts' => t('Service Max Check Attempts'), 'check_timeperiod_name' => t('Check Timeperiod Name'), 'check_timeperiod_id' => t('Check Timeperiod Id'), 'check_timeout' => t('Service Check Timeout'), 'check_interval' => t('Service Check Interval'), 'check_retry_interval' => t('Service Check Retry Inverval'), 'active_checks_enabled' => t('Service Active Checks Enabled'), 'passive_checks_enabled' => t('Service Passive Checks Enabled'), 'event_handler_enabled' => t('Service Event Handler Enabled'), 'notifications_enabled' => t('Service Notifications Enabled'), 'flapping_enabled' => t('Service Flapping Enabled'), 'flapping_threshold_low' => t('Service Flapping Threshold Low'), 'flapping_threshold_high' => t('Service Flapping Threshold High'), 'perfdata_enabled' => t('Service Performance Data Enabled'), 'eventcommand_name' => t('Eventcommand Name'), 'eventcommand_id' => t('Eventcommand Id'), 'is_volatile' => t('Service Is Volatile'), 'action_url_id' => t('Action Url Id'), 'notes_url_id' => t('Notes Url Id'), 'notes' => t('Service Notes'), 'icon_image_id' => t('Icon Image Id'), 'icon_image_alt' => t('Icon Image Alt'), 'zone_name' => t('Zone Name'), 'zone_id' => t('Zone Id'), 'command_endpoint_name' => t('Endpoint Name'), 'command_endpoint_id' => t('Endpoint Id') ]; } public function getSearchColumns() { return ['name_ci', 'display_name']; } public function getDefaultSort() { return 'service.display_name'; } public function createBehaviors(Behaviors $behaviors) { $behaviors->add(new BoolCast([ 'active_checks_enabled', 'passive_checks_enabled', 'event_handler_enabled', 'notifications_enabled', 'flapping_enabled', 'is_volatile' ])); $behaviors->add(new ReRoute([ 'user' => 'notification.user', 'usergroup' => 'notification.usergroup' ])); $behaviors->add(new Binary([ 'id', 'environment_id', 'name_checksum', 'properties_checksum', 'host_id', 'checkcommand_id', 'check_timeperiod_id', 'eventcommand_id', 'action_url_id', 'notes_url_id', 'icon_image_id', 'zone_id', 'command_endpoint_id' ])); } public function createDefaults(Defaults $defaults) { $defaults->add('vars', function (self $subject) { if (! $subject->customvar_flat instanceof ResultSet) { $this->applyRestrictions($subject->customvar_flat); } $vars = []; foreach ($subject->customvar_flat as $customVar) { $vars[$customVar->flatname] = $customVar->flatvalue; } return $vars; }); $defaults->add('customvars', function (self $subject) { if (! $subject->customvar instanceof ResultSet) { $this->applyRestrictions($subject->customvar); } $vars = []; foreach ($subject->customvar as $customVar) { $vars[$customVar->name] = json_decode($customVar->value, true); } return $vars; }); } public function createRelations(Relations $relations) { $relations->belongsTo('environment', Environment::class); $relations->belongsTo('host', Host::class)->setJoinType('LEFT'); $relations->belongsTo('checkcommand', Checkcommand::class); $relations->belongsTo('timeperiod', Timeperiod::class) ->setCandidateKey('check_timeperiod_id') ->setJoinType('LEFT'); $relations->belongsTo('eventcommand', Eventcommand::class); $relations->belongsTo('action_url', ActionUrl::class) ->setCandidateKey('action_url_id') ->setForeignKey('id'); $relations->belongsTo('notes_url', NotesUrl::class) ->setCandidateKey('notes_url_id') ->setForeignKey('id'); $relations->belongsTo('icon_image', IconImage::class) ->setCandidateKey('icon_image_id') ->setJoinType('LEFT'); $relations->belongsTo('zone', Zone::class); $relations->belongsTo('endpoint', Endpoint::class) ->setCandidateKey('command_endpoint_id'); $relations->belongsToMany('customvar', Customvar::class) ->through(ServiceCustomvar::class); $relations->belongsToMany('customvar_flat', CustomvarFlat::class) ->through(ServiceCustomvar::class); $relations->belongsToMany('vars', Vars::class) ->through(ServiceCustomvar::class); $relations->belongsToMany('servicegroup', Servicegroup::class) ->through(ServicegroupMember::class); $relations->belongsToMany('hostgroup', Hostgroup::class) ->through(HostgroupMember::class); $relations->hasOne('state', ServiceState::class)->setJoinType('LEFT'); $relations->hasMany('comment', Comment::class)->setJoinType('LEFT'); $relations->hasMany('downtime', Downtime::class)->setJoinType('LEFT'); $relations->hasMany('history', History::class); $relations->hasMany('notification', Notification::class)->setJoinType('LEFT'); $relations->hasMany('notification_history', NotificationHistory::class); } }