# -*- encoding: utf-8 -*-
-from django.db.models import Q
+import datetime
+from django.db.models import Q
from project import groups
from project.rh import models as rh
employe = groups.get_employe_from_user(request.user)
prefixe_implantation = 'poste__implantation'
- q_recherche = Q(poste__nom__icontains=q) | \
- Q(poste__type_poste__nom__icontains=q) | \
- Q(employe__nom__icontains=q) | \
- Q(employe__prenom__icontains=q)
+ q_recherche = (
+ (Q(poste__nom__icontains=q) |
+ Q(poste__type_poste__nom__icontains=q) |
+ Q(employe__nom__icontains=q) |
+ Q(employe__prenom__icontains=q))
+ )
q_place = Q(**{
prefixe_implantation + '__zone_administrative':
employe.implantation.zone_administrative
})
+
user_groupes = [g.name for g in request.user.groups.all()]
if groups.DRH_NIVEAU_1 in user_groupes:
q_filtre = q_recherche
employe = groups.get_employe_from_user(request.user)
prefixe_implantation = 'poste__implantation'
- q_recherche = \
- Q(poste__nom__icontains=q) | \
- Q(poste__type_poste__nom__icontains=q)
+ q_recherche = (
+ (Q(poste__nom__icontains=q) |
+ Q(poste__type_poste__nom__icontains=q)) &
+ (Q(date_fin=None) |
+ Q(date_fin__gte=(
+ datetime.date.today() -
+ datetime.timedelta(365)
+ ))
+ ))
if groups.is_user_dans_services_centraux(request.user):
q_place = Q(**{prefixe_implantation: employe.implantation})
# -*- encoding: utf-8 -*-
+import datetime
from django.db.models import Q
from auf.django.references import models as ref
def get_query(self, q, request):
dossiers = rh.Dossier.objects.filter(
- Q(poste__nom=q) | Q(poste__type_poste__nom=q) |
- Q(employe__nom__icontains=q) | Q(employe__prenom__icontains=q) |
- Q(employe__nom_affichage__icontains=q)
+ (Q(poste__nom=q) | Q(poste__type_poste__nom=q) |
+ Q(employe__nom__icontains=q) | Q(employe__prenom__icontains=q) |
+ Q(employe__nom_affichage__icontains=q)) &
+ (Q(date_fin=None) |
+ Q(date_fin__gte=(
+ datetime.date.today() -
+ datetime.timedelta(365)
+ ))
+ )
)
return dossiers