0d4d8dca8372ff165f45926a0c0d023fcf098b9e
[auf_rh_dae.git] / project / rh / lib.py
1 # -*- encoding: utf-8 -*-
2
3 from collections import defaultdict
4 import datetime
5
6 from django.db import models
7 from django.contrib import admin
8 from django.conf import settings
9 from django.db.models import Q
10 from auf.django.metadata.admin import AUFMetadataAdminMixin, AUFMetadataInlineAdminMixin, AUF_METADATA_READONLY_FIELDS
11 from project.rh import models as rh
12 from forms import DossierForm, ContratForm
13 from dae.utils import get_employe_from_user
14
15
16 # Override of the InlineModelAdmin to support the link in the tabular inline
17 class LinkedInline(admin.options.InlineModelAdmin):
18 template = "admin/linked.html"
19 admin_model_path = None
20
21 def __init__(self, *args):
22 super(LinkedInline, self).__init__(*args)
23 if self.admin_model_path is None:
24 self.admin_model_path = self.model.__name__.lower()
25
26
27 class ProtectRegionMixin(object):
28
29 def queryset(self, request):
30 qs = super(ProtectRegionMixin, self).queryset(request)
31
32 if request.user.is_superuser:
33 return qs
34
35 employe = get_employe_from_user(request.user)
36
37 q = Q(**{self.model.prefix_implantation: employe.implantation.region})
38 qs = qs.filter(q).distinct()
39 return qs
40
41 def has_change_permission(self, request, obj=None):
42 if request.user.is_superuser:
43 return True
44
45 if obj:
46 employe = get_employe_from_user(request.user)
47 if employe.implantation.region in obj.get_regions():
48 return True
49 else:
50 return False
51
52 return True
53
54
55 # Inlines
56
57 class ReadOnlyInlineMixin(object):
58 def get_readonly_fields(self, request, obj=None):
59 return [f.name for f in self.model._meta.fields if f.name not in AUF_METADATA_READONLY_FIELDS]
60
61
62 class AyantDroitInline(AUFMetadataInlineAdminMixin, admin.StackedInline):
63 model = models.Model # à remplacer dans admin.py
64 extra = 0
65
66 fieldsets = (
67 (None, {
68 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', 'lien_parente', )
69 }),
70 )
71
72
73 class AyantDroitCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
74 readonly_fields = ('owner', )
75 model = models.Model # à remplacer dans admin.py
76 extra = 1
77
78
79 class ContratInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
80 form = ContratForm
81 model = models.Model # à remplacer dans admin.py
82 extra = 1
83
84
85 class DossierROInline(ReadOnlyInlineMixin, LinkedInline):
86 exclude = AUF_METADATA_READONLY_FIELDS
87 model = models.Model # à remplacer dans admin.py
88 extra = 0
89
90
91 class DossierCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
92 readonly_fields = ('owner', )
93 model = models.Model # à remplacer dans admin.py
94 extra = 1
95
96
97 class DossierPieceInline(admin.TabularInline):
98 model = models.Model # à remplacer dans admin.py
99 extra = 4
100
101
102 class EmployeInline(admin.TabularInline):
103 model = models.Model # à remplacer dans admin.py
104
105 class EmployeCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
106 readonly_fields = ('owner', )
107 model = models.Model # à remplacer dans admin.py
108 extra = 1
109
110
111 class EmployePieceInline(admin.TabularInline):
112 model = models.Model # à remplacer dans admin.py
113 extra = 4
114
115
116 class EvenementInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
117 model = models.Model # à remplacer dans admin.py
118 extra = 1
119
120
121 class EvenementRemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
122 model = models.Model # à remplacer dans admin.py
123 extra = 1
124
125
126 class PosteCommentaireInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
127 readonly_fields = ('owner', )
128 model = models.Model # à remplacer dans admin.py
129 extra = 1
130
131
132 class PosteFinancementInline(admin.TabularInline):
133 model = models.Model # à remplacer dans admin.py
134
135
136 class PostePieceInline(admin.TabularInline):
137 model = models.Model # à remplacer dans admin.py
138
139
140 class RemunerationInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
141 model = models.Model # à remplacer dans admin.py
142 extra = 1
143
144
145 class RemunerationROInline(ReadOnlyInlineMixin, RemunerationInline):
146 pass
147
148
149 class TypePosteInline(AUFMetadataInlineAdminMixin, admin.TabularInline):
150 model = models.Model # à remplacer dans admin.py
151
152
153 # Admins
154
155 class AyantDroitAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
156 """
157 L'ajout d'un nouvel ayantdroit se fait dans l'admin de l'employé.
158 """
159 alphabet_filter = 'nom'
160 search_fields = ('nom', 'prenom', 'employe__nom', 'employe__prenom', )
161 list_display = ('_employe', 'lien_parente', '_ayantdroit', )
162 inlines = (AyantDroitCommentaireInline,)
163 readonly_fields = AUFMetadataAdminMixin.readonly_fields + ('employe',)
164 fieldsets = AUFMetadataAdminMixin.fieldsets + (
165 ("Lien avec l'employé", {
166 'fields': (('employe', 'lien_parente'), )
167 }),
168
169 ('Identification', {
170 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
171 }),
172 )
173
174 def save_formset(self, request, form, formset, change):
175 instances = formset.save(commit=False)
176 for instance in instances:
177 if instance.__class__ == rh.AyantDroitCommentaire:
178 instance.owner = request.user
179 instance.save()
180
181 def _ayantdroit(self, obj):
182 return unicode(obj)
183 _ayantdroit.short_description = u'Ayant droit'
184
185 def _employe(self, obj):
186 return unicode(obj.employe)
187 _employe.short_description = u'Employé'
188
189 def has_add_permission(self, request):
190 return False
191
192 class AyantDroitCommentaireAdmin(admin.ModelAdmin):
193 pass
194
195
196 class ClassementAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
197 fieldsets = AUFMetadataAdminMixin.fieldsets + (
198 (None, {
199 'fields': ('type', 'echelon', 'degre', 'coefficient', )
200 }),
201 )
202
203
204 class CommentaireAdmin(admin.ModelAdmin):
205 pass
206
207
208 #class ContratAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
209 # form = ContratForm
210 # alphabet_filter = 'dossier__employe__nom'
211 # search_fields = ('dossier__employe__nom', 'dossier__employe__prenom', 'dossier__poste__nom', 'dossier__poste__nom_feminin', )
212 # list_display = ('id', '_employe', '_poste', 'date_debut', 'date_fin', '_implantation', )
213 # fieldsets = AUFMetadataAdminMixin.fieldsets + (
214 # (None, {
215 # 'fields': ('dossier', 'type_contrat', 'date_debut', 'date_fin', )
216 # }),
217 # )
218 #
219 # def lookup_allowed(self, key, value):
220 # if key in ('dossier__employe__nom__istartswith', ):
221 # return True
222 #
223 # def _employe(self, obj):
224 # return unicode(obj.dossier.employe)
225 # _employe.short_description = "Employé"
226 #
227 # def _poste(self, obj):
228 # return obj.dossier.poste.nom
229 # _poste.short_description = "Poste"
230 #
231 # def _implantation(self, obj):
232 # return obj.dossier.poste.implantation
233 # _poste.short_description = "Implantation"
234
235 class DeviseAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
236 fieldsets = AUFMetadataAdminMixin.fieldsets + (
237 (None, {
238 'fields': ('code', 'nom', ),
239 }),
240 )
241
242
243 class DossierAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin,):
244 form = DossierForm
245 alphabet_filter = 'employe__nom'
246 search_fields = ('employe__nom', 'employe__prenom', 'poste__nom', 'poste__nom_feminin')
247 list_display = ('_employe', '_poste', 'date_debut', 'date_fin', 'date_modification', '_actif')
248 inlines = (DossierPieceInline, ContratInline,
249 RemunerationInline,
250 #EvenementInline,
251 DossierCommentaireInline,
252 )
253 fieldsets = AUFMetadataAdminMixin.fieldsets + (
254 (None, {
255 'fields': ('employe', 'poste', 'statut', 'organisme_bstg',)
256 }),
257 ('Recrutement', {
258 'fields': ('statut_residence', 'remplacement', 'remplacement_de', )
259 }),
260 ('Rémunération', {
261 'fields': ('classement', ('regime_travail', 'regime_travail_nb_heure_semaine'),)
262 }),
263 ('Occupation du Poste par cet Employe', {
264 'fields': (('date_debut', 'date_fin'), )
265 }),
266 )
267
268 add_form_template = 'admin/change_form.html'
269
270 class Media:
271 js = ('js/dossier.js',)
272
273 def lookup_allowed(self, key, value):
274 if key in ('employe__nom__istartswith', 'actif__exact', ):
275 return True
276
277 def _actif(self, dossier):
278 if dossier.employe.actif:
279 html = """<img alt="True" src="%simg/admin/icon-yes.gif">"""
280 else:
281 html = """<img alt="False" src="%simg/admin/icon-no.gif">"""
282 return html % settings.ADMIN_MEDIA_PREFIX
283 _actif.allow_tags = u'Employé actif'
284 _actif.short_description = u'Employé actif'
285 _actif.admin_order_field = 'employe__actif'
286
287 def _poste(self, dossier):
288 return unicode(dossier.poste.nom)
289 _poste.short_description = u'Poste'
290 _poste.admin_order_field = 'poste__nom'
291
292 def _employe(self, dossier):
293 return unicode(dossier.employe)
294 _employe.short_description = u'Employé'
295 _employe.admin_order_field = 'employe__nom'
296
297 def save_formset(self, request, form, formset, change):
298 instances = formset.save(commit=False)
299 for instance in instances:
300 if instance.__class__ == rh.DossierCommentaire:
301 instance.owner = request.user
302 instance.save()
303
304 def render_change_form(self, request, context, *args, **kwargs):
305 obj = kwargs.get('obj', None)
306
307 if not obj:
308 return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
309
310
311 remun, remun_sum, remun_sum_euro = calc_remun(obj)
312
313 extra = {
314 'remun': remun,
315 'remun_sum': remun_sum,
316 'remun_sum_euro': remun_sum_euro,
317 'employe': obj.employe,
318 'poste_nom': obj.poste.nom,
319 'poste_service': obj.poste.service,
320 'poste_implantation': obj.poste.implantation,
321 }
322
323 context.update(extra)
324
325 return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
326
327
328 class DossierPieceAdmin(admin.ModelAdmin):
329 pass
330
331
332 class DossierCommentaireAdmin(admin.ModelAdmin):
333 pass
334
335
336 class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
337 alphabet_filter = 'nom'
338 search_fields = ('id', 'nom', 'prenom', 'nom_affichage', 'actif', )
339 list_filter = ('actif', )
340 ordering = ('nom', )
341 actions = ('desactiver', )
342 list_display = ('id', 'nom', 'prenom', 'actif', )
343 list_display_links = ('id', 'nom',)
344 inlines = (AyantDroitInline,
345 DossierROInline,
346 EmployePieceInline,
347 EmployeCommentaireInline)
348 fieldsets = AUFMetadataAdminMixin.fieldsets + (
349 ('Identification', {
350 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
351 }),
352 ('Informations personnelles', {
353 'fields': ('situation_famille', 'date_entree', )
354 }),
355 ('Coordonnées', {
356 'fields': (('tel_domicile', 'tel_cellulaire'), ('adresse', 'ville'), ('code_postal', 'province'), 'pays', )
357 }),
358 )
359
360 def save_formset(self, request, form, formset, change):
361 instances = formset.save(commit=False)
362 for instance in instances:
363 if instance.__class__ == rh.EmployeCommentaire:
364 instance.owner = request.user
365 instance.save()
366
367 class EmployeCommentaireAdmin(admin.ModelAdmin):
368 pass
369
370
371 class EmployePieceAdmin(admin.ModelAdmin):
372 pass
373
374
375 class EvenementAdmin(admin.ModelAdmin):
376 inlines = (EvenementRemunerationInline,)
377
378
379 class EvenementRemunerationAdmin(admin.ModelAdmin):
380 pass
381
382
383 class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
384 inlines = (TypePosteInline,)
385 fieldsets = AUFMetadataAdminMixin.fieldsets + (
386 (None, {
387 'fields': ('nom', )
388 }),
389 )
390
391
392 class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
393 search_fields = ('nom', )
394 list_display = ('nom', 'type', 'pays', )
395 inlines = (DossierROInline,)
396 fieldsets = AUFMetadataAdminMixin.fieldsets + (
397 (None, {
398 'fields': ('nom', 'type', 'pays', )
399 }),
400 )
401
402
403 class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
404 alphabet_filter = 'nom'
405 search_fields = ('nom', 'implantation__code', 'implantation__nom', 'implantation__region__code', 'implantation__region__nom', )
406 list_display = ('nom', 'implantation', 'service', 'type_poste', 'date_debut', 'date_fin', )
407 fieldsets = AUFMetadataAdminMixin.fieldsets + (
408 (None, {
409 'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
410 'service', 'responsable')
411 }),
412 ('Contrat', {
413 'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
414 }),
415 ('Recrutement', {
416 'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
417 }),
418 ('Rémunération', {
419 'fields': (('classement_min', 'classement_max'),
420 ('valeur_point_min', 'valeur_point_max'),
421 ('devise_min', 'devise_max'),
422 ('salaire_min', 'salaire_max'),
423 ('indemn_min', 'indemn_max'),
424 ('autre_min', 'autre_max'))
425 }),
426 ('Comparatifs de rémunération', {
427 'fields': ('devise_comparaison',
428 ('comp_locale_min', 'comp_locale_max'),
429 ('comp_universite_min', 'comp_universite_max'),
430 ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
431 ('comp_ong_min', 'comp_ong_max'),
432 ('comp_autre_min', 'comp_autre_max'))
433 }),
434 ('Justification', {
435 'fields': ('justification',)
436 }),
437 ('Autres Metadata', {
438 'fields': ('date_validation', ('date_debut', 'date_fin'))
439 }),
440 )
441
442 inlines = (PosteFinancementInline,
443 PostePieceInline,
444 DossierROInline,
445 PosteCommentaireInline, )
446
447 def save_formset(self, request, form, formset, change):
448 instances = formset.save(commit=False)
449 for instance in instances:
450 if instance.__class__ == rh.PosteCommentaire:
451 instance.owner = request.user
452 instance.save()
453 formset.save_m2m()
454
455
456 class PosteCommentaireAdmin(admin.ModelAdmin):
457 pass
458
459
460 class PosteFinancementAdmin(admin.ModelAdmin):
461 pass
462
463
464 class PostePieceAdmin(admin.ModelAdmin):
465 pass
466
467
468 class RemunerationAdmin(admin.ModelAdmin):
469 pass
470
471
472 class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
473 fieldsets = AUFMetadataAdminMixin.fieldsets + (
474 (None, {
475 'fields': ('employe', 'implantation', ),
476 }),
477 )
478
479
480 class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
481 list_display = ('nom', 'actif', )
482 fieldsets = AUFMetadataAdminMixin.fieldsets + (
483 (None, {
484 'fields': ('nom', ),
485 }),
486 )
487
488 class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
489 fieldsets = AUFMetadataAdminMixin.fieldsets + (
490 (None, {
491 'fields': ('code', 'nom', ),
492 }),
493 )
494
495 class TauxChangeAdmin(admin.ModelAdmin):
496 list_display = ('taux', 'devise', 'annee', )
497 list_filter = ('devise', )
498 fieldsets = AUFMetadataAdminMixin.fieldsets + (
499 (None, {
500 'fields': ('taux', 'devise', 'annee', ),
501 }),
502 )
503
504 class TypeContratAdmin(admin.ModelAdmin):
505 inlines = (ContratInline,)
506 fieldsets = AUFMetadataAdminMixin.fieldsets + (
507 (None, {
508 'fields': ('nom', 'nom_long', ),
509 }),
510 )
511
512
513 class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
514 search_fields = ('nom', 'nom_feminin', )
515 list_display = ('nom', 'famille_emploi', )
516 list_filter = ('famille_emploi', )
517 fieldsets = AUFMetadataAdminMixin.fieldsets + (
518 (None, {
519 'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi', )
520 }),
521 )
522
523
524 class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
525 list_display = ('nom', 'type_paiement', 'nature_remuneration', )
526 #inlines = (RemunerationROInline,) utilité?
527 fieldsets = AUFMetadataAdminMixin.fieldsets + (
528 (None, {
529 'fields': ('nom', 'type_paiement', 'nature_remuneration', )
530 }),
531 )
532
533
534 class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
535 #inlines = (RemunerationROInline,) utilité?
536 fieldsets = AUFMetadataAdminMixin.fieldsets + (
537 (None, {
538 'fields': ('nom', )
539 }),
540 )
541
542
543 class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
544 list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
545 fieldsets = AUFMetadataAdminMixin.fieldsets + (
546 (None, {
547 'fields': ('valeur', 'devise', 'implantation', 'annee', )
548 }),
549 )
550
551 def _devise_code(self, obj):
552 return obj.devise.code
553 _devise_code.short_description = "Code de la devise"
554
555 def _devise_nom(self, obj):
556 return obj.devise.nom
557 _devise_nom.short_description = "Nom de la devise"
558
559
560 def calc_remun(dossier):
561 thisyear = datetime.date.today().year
562 thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
563
564 remunnow = dossier.rh_remuneration_remunerations.filter(thisyearfilter)
565
566 remun_sum = 0
567 remun_sum_euro = 0
568 sums = defaultdict(int)
569 sums_euro = defaultdict(int)
570 for r in remunnow:
571 nature = r.type.nature_remuneration
572 sums[nature] += r.montant
573 sums_euro[nature] += r.montant_euro()
574 remun_sum += r.montant
575 remun_sum_euro += r.montant_euro()
576
577 remun = {}
578 sums = dict(sums)
579 for n, s in sums.iteritems():
580 remun[n] = [sums[n], sums_euro[n]]
581
582 return remun, remun_sum, remun_sum_euro