from vigiboard.model import DBSession

from vigiboard.model import Event, EventHistory, EventsAggregate, \

                            Host, HostGroup, \

from repoze.what.predicates import Any, not_anonymous

from vigiboard.widgets.edit_event import edit_event_status_options

from vigiboard.controllers.vigiboardrequest import VigiboardRequest

                    }

        return dict(

                                    event[1].current_state),

                                    event[1].initial_state),

                                    event[1].peak_state),

                idaggregate = idaggregate,

                host = event[1].hostname,

from vigiboard.model import Event, EventsAggregate, EventHistory, State, \

                            Host, HostGroup, ServiceLowLevel, ServiceGroup, \

from tg import tmpl_context, url, config

from vigiboard.model import DBSession

from sqlalchemy import not_, and_, asc, desc, sql

                (ServiceLowLevel, Event.servicename == ServiceLowLevel.name),

                (HostGroup, Host.name == HostGroup.hostname),

                (ServiceGroup, ServiceLowLevel.name == ServiceGroup.servicename),

            ]

        self.outerjoin = []

                # On masque les événements avec l'état OK

                # et traités (status == u'AAClosed').

                not_(and_(

                    EventsAggregate.status == u'AAClosed'

                )),

                EventsAggregate.timestamp_active != None,

        self.orderby = [

                desc(EventsAggregate.status),   # None, Acknowledged, AAClosed

                priority_order,                 # Priorité ITIL (entier).

                desc(Event.timestamp),

                asc(Event.hostname),

            ]

                EventsAggregate.idaggregate,

                EventsAggregate,

                Event.hostname,

                Event.timestamp,

            ]

            events.append([

                    event,

                    {'class': class_tr[i % 2]},

                        cause.initial_state) +

                        self.class_ack[event.status]},

                        cause.current_state) +

                        self.class_ack[event.status]},

                    {'src': '/images/%s2.png' %

                        cause.current_state)},

                    self.format_events_img_status(event),

                    [[j.__show__(event), j.style] for j in self.plugin]

from vigilo.models import User, UserGroup, Permission

from vigilo.models import Event, EventHistory, EventsAggregate

from vigilo.models import Graph, GraphGroup, GraphToGroups

from vigilo.models import Host, HostGroup

from vigilo.models import ServiceLowLevel, ServiceHighLevel, ServiceGroup

from vigilo.models import Access