employe = get_employe_from_user(request.user)
lookup_params['poste__implantation__region'] = employe.implantation.region
- # contrats échus
- #contrats_echus = rh.Contrat.objects.filter(
- # date_fin__lt=date.today()
- # ).filter(
- # **lookup_params
- # )
-
- ## dossiers en cours sans contrat
- #dossiers = rh.Dossier.objects.filter(q_region & (
- # Q(date_fin=None) | Q(date_fin__gt=date.today())),
- # ).exclude(
- # date_debut__gt=date.today()
- # ).filter(
- # # sans contrat | contrat échu
- # Q(rh_contrats=None) | Q(rh_contrats__in=contrats_echus)
- # ).distinct()
-
- ## employés sans contrat ou contrats échus
- #employes = rh.Employe.objects.filter(rh_dossiers__in=dossiers) \
- # .distinct().count()
dossiers = rh.Dossier.objects.sans_contrats_ou_echus(**lookup_params)
- for d in dossiers:
- print d
-
dossiers_ids = [d.id for d in dossiers]
employes = rh.Employe.objects.filter(id__in=dossiers_ids).distinct().count()