Exemple #1
0
def global_search(user, search, qs):
    """
    Returns results according to search keyword.
    It will look in all available fields.
    """
    fks = {'os': 'name',
           'site': 'label',
           'supplier': 'name',
           'type': 'text',
           'status': 'name'}
    # Filtre les foreign key en fonction du niveau de securite.
    authorized_keys = SearchHostForm.filter_list(user, fks.keys())
    fks = dict([(k, v) for k, v in fks.iteritems()
        if k in authorized_keys])

    # Filter local fields
    fields = SearchHostForm.filter_list(user, SearchHostForm.Meta.fields)
    qs = qs.filter(
        (
            # Do search on extra_fields
            Q(additionnalfield__field__fast_search__exact=True)
            & ~Q(additionnalfield__field__data_type__in=('2', '3', '6'))
            & Q(additionnalfield__value__icontains=search)
        ) | (
            # Do search only for local fields
            reduce(ior, (Q(**{"%s__icontains" % (key,): search})
                     for key in fields if key not in fks.keys()))
        ) | (
            # Do search on filtered foreign keys
            reduce(ior, (Q(**{"%s__%s__icontains" % (key, value): search})
                     for key, value in fks.iteritems()))
        )
    )
    # Distict is needed because could match 2 fields in the or just above
    return qs.distinct()
Exemple #2
0
def list_all(request, target_client=None, *args, **kw):
    """
    Vue permettant de lister les machines recherchées.
    Variables de session utilisées:
        search_host_form_fields : dernier formulaire de rechere
        additionnal_field_form_fields : dernier formulaire additionnel
        sort_adm_list : dernier tri
        lastpage_clariadmin : dernier numéreau de page
    """
    if request.GET.get("reset", "0") == "1":
        try:  # ordre de nettoyage de session logique.
            del request.session["lastpage_clariadmin"]
            del request.session["sort_adm_list"]
            del request.session["search_host_form_fields"]
            del request.session["additionnal_field_form_fields"]
        except KeyError:
            pass
        return redirect('list_hosts')

    if target_client:
        tmp = request.session.get("search_host_form_fields", {})
        tmp["site"] = target_client
        request.session["search_host_form_fields"] = tmp
        return redirect('list_hosts')

    POST = HostForm.filter_querydict(request.user, request.POST)
    new_search = False
    form_extra = False
    sort_default = settings.HOST_DEFAULT_ORDER
    columns = HostForm.filter_list(request.user, ("hostname", "ip", "site",
                      "type", "os", "model", "status", "additionnal_fields"))

    if POST:
        # Init forms
        form = SearchHostForm(request.user, POST)
        if form.is_valid():
            # récupère les éléments de POST propre à SearchHostForm
            post_filtred = dict((k, v) for k, v in POST.iteritems()
                                if k in form.cleaned_data.keys())

            # si recherche != dernière recherche,
            # retour page 1 et update session
            if request.session.get('search_host_form_fields', {}) != post_filtred:
                new_search = True
                request.session['search_host_form_fields'] = post_filtred
            host_type = request.session.get('search_host_form_fields', {}).get('type', False)

            if host_type:
                form_extra = AdditionnalFieldForm(POST,
                             host_type=HostType.objects.get(pk=host_type))
                # if search != last search => page 1 and update session
                post_filtred = dict([(k, v) for k, v in POST.iteritems()
                    if k in form_extra.fields.keys()])
                if request.session.get('additionnal_field_form_fields', {}) != post_filtred:
                    new_search = True
                    request.session['additionnal_field_form_fields'] = post_filtred
                form_extra.is_valid()
    else:
        host_type = request.session.get('search_host_form_fields', {}).get('type', False)
        form = SearchHostForm(request.user, request.session.get('search_host_form_fields', {}))
        if host_type:
            form_extra = AdditionnalFieldForm(
                    request.session.get('additionnal_field_form_fields', {}),
                    host_type=HostType.objects.get(pk=host_type))
            form_extra.is_valid()

    # filter SearchHostFrom
    form.fields = SearchHostForm.filter_querydict(request.user, form.fields)

    # get sorting
    sorting = sort_default
    sort_get = request.GET.get('sort',
                           request.session.get("sort_adm_list", sort_default))
    if sort_get in columns:
        sorting = sort_get
    if sort_get.startswith('-') and sort_get[1:] in columns:
        sorting = sort_get
    request.session["sort_adm_list"] = sorting

    # apply searchs if any.
    qs = Host.objects.none()
    if form.is_valid():
        search_args = form.cleaned_data
        if [v for v in search_args.itervalues() if v]:
            qs = Host.objects.filter_by_user(request.user)
            if form_extra:
                qs = filter_hosts(qs, request.user, sorting, form.cleaned_data,
                                  form_extra.get_data())
            else:
                qs = filter_hosts(qs, request.user, sorting, form.cleaned_data)
            form.update(qs)
    # fill paginator
    paginator = DiggPaginator(qs, settings.HOSTS_PER_PAGE,
                              body=5, tail=2, padding=2)

    # get page
    page_num = 1
    page_asked = int(request.GET.get('page',
                     request.session.get('lastpage_clariadmin', 1)))
    if ((page_asked <= paginator.num_pages) and not new_search):
        page_num = page_asked
    request.session["lastpage_clariadmin"] = page_num
    page = paginator.page(page_num)

    return render_to_response("clariadmin/list.html", {
        "page": page,
        "form": form,
        "columns": columns,
        "sorting": sorting,
        "form_extra": form_extra,
    }, context_instance=RequestContext(request))