except:

                LOGGER.exception(u'Unable to import plugin %s', plugin_name)

    'groups',

    'masked_events',

    def get_search_fields(self):

        return []

    def handle_search_fields(self, query, search):

        pass

import tw.forms as twf

from pylons.i18n import ugettext as _, lazy_ugettext as l_

from tg.i18n import get_lang

import tg

from vigilo.models import tables

from vigiboard.lib.dateformat import DateFormatConverter

def get_calendar_lang():

    # TODO: Utiliser le champ "language" du modèle pour cet utilisateur ?

    # On récupère la langue du navigateur de l'utilisateur

    lang = get_lang()

    if not lang:

        lang = tg.config['lang']

    else:

        lang = lang[0]

    # TODO: Il faudrait gérer les cas où tout nous intéresse dans "lang".

    # Si l'identifiant de langage est composé (ex: "fr_FR"),

    # on ne récupère que la 1ère partie.

    lang = lang.replace('_', '-')

    lang = lang.split('-')[0]

    return lang

def get_date_format():

    # @HACK: nécessaire car l_() retourne un object LazyString

    # qui n'est pas sérialisable en JSON.

    return _('%Y-%m-%d %I:%M:%S %p').encode('utf-8')

    def get_search_fields(self):

        return [

            twf.CalendarDateTimePicker(

                'from_date',

                label_text=l_('From'),

                button_text=l_("Choose"),

                not_empty=False,

                validator=DateFormatConverter(if_missing=None),

                date_format=get_date_format,

                calendar_lang=get_calendar_lang,

            ),

            twf.CalendarDateTimePicker(

                'to_date',

                label_text=l_('To'),

                button_text=l_("Choose"),

                not_empty=False,

                validator=DateFormatConverter(if_missing=None),

                date_format=get_date_format,

                calendar_lang=get_calendar_lang,

            ),

        ]

    def handle_search_fields(self, query, search):

        if search.get('from_date'):

            query.add_filter(tables.CorrEvent.timestamp_active >=

                search['from_date'])

        if search.get('to_date'):

            query.add_filter(tables.CorrEvent.timestamp_active <=

                search['to_date'])

# -*- coding: utf-8 -*-

# vim:set expandtab tabstop=4 shiftwidth=4:

################################################################################

#

# Copyright (C) 2007-2011 CS-SI

#

# This program is free software; you can redistribute it and/or modify

# it under the terms of the GNU General Public License version 2 as

# published by the Free Software Foundation.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

################################################################################

"""

Un plugin pour VigiBoard qui ajoute une colonne avec les groupes

d'éléments supervisés auxquels appartient l'objet associé

à l'événement corrélé.

"""

import tw.forms as twf

from pylons.i18n import lazy_ugettext as l_

from vigiboard.controllers.plugins import VigiboardRequestPlugin

from vigilo.models.session import DBSession

from vigilo.models.tables.group import Group

from vigilo.models.tables.grouphierarchy import GroupHierarchy

class GroupSelector(twf.InputField):

    params = ["choose_text", "text_value", "clear_text"]

    choose_text = l_('Choose')

    clear_text = l_('Clear')

    text_value = ''

    template = """

<div xmlns="http://www.w3.org/1999/xhtml"

   xmlns:py="http://genshi.edgewall.org/" py:strip="">

<input type="hidden" name="${name}" class="${css_class}"

    id="${id}.value" value="${value}" py:attrs="attrs" />

<input type="text" class="${css_class}" id="${id}.ui"

    value="${text_value}" readonly="readonly" py:attrs="attrs" />

<input type="button" class="${css_class}" id="${id}"

    value="${choose_text}" py:attrs="attrs" />

<input type="button" class="${css_class}" id="${id}.clear"

    value="${clear_text}" py:attrs="attrs" />

</div>

"""

    def update_params(self, d):

        super(GroupSelector, self).update_params(d)

        text_value = DBSession.query(Group.name).filter(

                        Group.idgroup == d.value).scalar()

        if not text_value:

            d.value = ''

        else:

            d.text_value = text_value

class PluginGroups(VigiboardRequestPlugin):

    """

    Affiche les groupes d'éléments supervisés auxquels

    appartient l'événement corrélé.

    """

    def get_search_fields(self):

        return [

            GroupSelector(

                'supitemgroup',

                label_text=l_('Group'),

                validator=twf.validators.Int(if_invalid=None, if_missing=None),

            )

        ]

    def handle_search_fields(self, query, search):

        if search.get('supitemgroup'):

            query.add_join((GroupHierarchy, GroupHierarchy.idchild ==

                query.items.c.idsupitemgroup))

            query.add_filter(GroupHierarchy.idparent ==

                search['supitemgroup'])

import tw.forms as twf

from pylons.i18n import lazy_ugettext as l_

from vigilo.models.functions import sql_escape_like

    def get_search_fields(self):

        return [

            twf.TextField(

                'host',

                label_text=l_('Host'),

                validator=twf.validators.String(if_missing=None),

            )

        ]

    def handle_search_fields(self, query, search):

        if search.get('host'):

            host = sql_escape_like(search['host'])

            query.add_filter(query.items.c.hostname.ilike(host))

# -*- coding: utf-8 -*-

# vim:set expandtab tabstop=4 shiftwidth=4:

################################################################################

#

# Copyright (C) 2007-2011 CS-SI

#

# This program is free software; you can redistribute it and/or modify

# it under the terms of the GNU General Public License version 2 as

# published by the Free Software Foundation.

#

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

# GNU General Public License for more details.

#

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

################################################################################

"""

Un plugin pour VigiBoard qui ajoute une colonne avec le nombre

d'événements masqués d'un événement corrélé.

"""

from vigiboard.controllers.plugins import VigiboardRequestPlugin

class PluginMaskedEvents(VigiboardRequestPlugin):

    """

    Affiche le nombre d'événements masqués par l'événement corrélé.

    """

import tw.forms as twf

from pylons.i18n import lazy_ugettext as l_

from vigilo.models.tables import Event

from vigilo.models.functions import sql_escape_like

    def get_search_fields(self):

        return [

            twf.TextField(

                'output',

                label_text=l_('Output'),

                validator=twf.validators.String(if_missing=None),

            )

        ]

    def handle_search_fields(self, query, search):

        if search.get('output'):

            output = sql_escape_like(search['output'])

            query.add_filter(Event.message.ilike(output))

import tw.forms as twf

from pylons.i18n import lazy_ugettext as l_

from formencode import schema, validators

from vigilo.models.tables import CorrEvent

from tw.forms.fields import ContainerMixin, FormField

from tw.core.base import WidgetsList

class HorizontalBox(ContainerMixin, FormField):

    """

    Container de widgets, qui se contente de les placer

    côte-à-côte horizontalement.

    """

    template = """<div

    xmlns="http://www.w3.org/1999/xhtml"

    xmlns:py="http://genshi.edgewall.org/"

    id="${id}"

    name="${name}"

    class="${css_class}"

    py:attrs="attrs">

    <py:for each="field in fields">

        ${field.display(value_for(field), **args_for(field))}

    </py:for>

</div>

"""

    def generate_schema(self):

        """

        Fait en sorte que l'absence de saisie dans les sous-champs

        du container ne génère pas une erreur (Valeur manquante)

        sur le container lui-même.

        """

        super(HorizontalBox, self).generate_schema()

        self.validator.if_missing = None

    def get_search_fields(self):

        options = [

            ('eq',  u'='),

            ('neq', u'≠'),

            ('gt',  u'>'),

            ('gte', u'≥'),

            ('lt',  u'<'),

            ('lte', u'≤'),

        ]

        return [

            HorizontalBox(

                'priority',

                label_text=l_('Priority'),

                fields=[

                    twf.SingleSelectField(

                        'op',

                        options=options,

                        validator=twf.validators.OneOf(

                            dict(options).keys(),

                            if_invalid=None,

                            if_missing=None,

                        ),

                    ),

                    twf.TextField(

                        'value',

                        validator=twf.validators.Int(

                            if_invalid=None,

                            if_missing=None,

                        ),

                    ),

                ],

            )

        ]

    def handle_search_fields(self, query, search):

        if (not search.get('priority')):

            return

        op = search['priority']['op']

        value = search['priority']['value']

        if (not op) or (not value):

            search['priority'] = None

            return

        if op == 'eq':

            query.add_filter(CorrEvent.priority == value)

        elif op == 'neq':

            query.add_filter(CorrEvent.priority != value)

        elif op == 'gt':

            query.add_filter(CorrEvent.priority > value)

        elif op == 'gte':

            query.add_filter(CorrEvent.priority >= value)

        elif op == 'lt':

            query.add_filter(CorrEvent.priority < value)

        elif op == 'lte':

            query.add_filter(CorrEvent.priority <= value)

import tw.forms as twf

from pylons.i18n import lazy_ugettext as l_

from vigilo.models.functions import sql_escape_like

    def get_search_fields(self):

        return [

            twf.TextField(

                'service',

                label_text=l_('Service'),

                validator=twf.validators.String(if_missing=None),

            )

        ]

    def handle_search_fields(self, query, search):

        if search.get('service'):

            service = sql_escape_like(search['service'])

            query.add_filter(query.items.c.servicename.ilike(service))

import tw.forms as twf

from pylons.i18n import lazy_ugettext as l_

from vigilo.models.tables import CorrEvent

from vigilo.models.functions import sql_escape_like

    def get_search_fields(self):

        return [

            twf.TextField(

                'trouble_ticket',

                label_text=l_('Trouble Ticket'),

                validator=twf.validators.String(if_missing=None),

            )

        ]

    def handle_search_fields(self, query, search):

        if search.get('trouble_ticket'):

            tt = sql_escape_like(search['trouble_ticket'])

            query.add_filter(CorrEvent.trouble_ticket.ilike(tt))

from tg.exceptions import HTTPNotFound

from vigiboard.widgets.search_form import create_search_form

        Gestion des erreurs de validation : on affiche les erreurs

        # Nécessaire pour que les critères de recherche soient conservés.

        allow_extra_fields = True

        # 2ème validation, cette fois avec les champs

        # du formulaire de recherche.

        chained_validators = [create_search_form.validator]

    def default(self, page, **search):

        @type page: C{int}

        @param search: Dictionnaire contenant les critères de recherche.

        @type search: C{dict}

        # Application des filtres des plugins si nécessaire.

        for plugin, instance in config.get('columns_plugins', []):

            instance.handle_search_fields(aggregates, search)

        # Certains arguments sont réservés dans url_for().

        # On effectue les substitutions adéquates.

        # Par exemple: "host" devient "host_".

        reserved = ('host', )

        copy = search.copy()

        for column in copy:

            if column in reserved:

                search[column + '_'] = search[column]

                del search[column]

        page = paginate.Page(aggregates.req, page=page,

            items_per_page=items_per_page)

        page = paginate.Page(events.req, page=page,

            items_per_page=items_per_page)

        page = paginate.Page(aggregates.req, page=page,

            items_per_page=items_per_page)

                        type_action=u"Ticket change",

# -*- coding: utf-8 -*-

"""

Validateur et convertisseur de dates selon un format.

"""

from formencode.api import FancyValidator, Invalid

from datetime import datetime

from pylons.i18n import ugettext as _, lazy_ugettext as l_

class DateFormatConverter(FancyValidator):

    """

    Valide une date selon un format identique à ceux

    acceptés par la fonction strptime().

    """

    messages = {

        'invalid': 'Invalid value',

    }

    def _to_python(self, value, state):

        if not isinstance(value, basestring):

            raise Invalid(self.message('invalid', state), value, state)

        str_date = value.lower()

        if isinstance(str_date, unicode):

            str_date = str_date.encode('utf-8')

        try:

            # TRANSLATORS: Format de date et heure Python/JavaScript.

            # TRANSLATORS: http://www.dynarch.com/static/jscalendar-1.0/doc/html/reference.html#node_sec_5.3.5

            # TRANSLATORS: http://docs.python.org/release/2.5/lib/module-time.html

            date = datetime.strptime(str_date, _('%Y-%m-%d %I:%M:%S %p').encode('utf8'))

        except ValueError, e:

            raise Invalid(self.message('invalid', state), value, state)

        return date

    def _from_python(self, value, state):

        if not isinstance(value, datetime):

            raise Invalid(self.message('invalid', state), value, state)

        # Même format que pour _to_python.

        return datetime.strftime(

                    value,

                    _('%Y-%m-%d %I:%M:%S %p').encode('utf8')

                ).decode('utf-8')

        from_date = timestamp.strftime("%Y-%m-%d %I:%M:%S %p")

        to_date = datetime.max.strftime("%Y-%m-%d %I:%M:%S %p")

    fields = [

        twf.HiddenField('page')

    ]

    for plugin, instance in tg.config.get('columns_plugins', []):

        fields.extend(instance.get_search_fields())