279b0d2a6f1446b29823b89b7aa32675a41b2b34
[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': ('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 class Media:
269 js = ('js/dossier.js',)
270
271 def lookup_allowed(self, key, value):
272 if key in ('employe__nom__istartswith', 'actif__exact', ):
273 return True
274
275 def _actif(self, dossier):
276 if dossier.employe.actif:
277 html = """<img alt="True" src="%simg/admin/icon-yes.gif">"""
278 else:
279 html = """<img alt="False" src="%simg/admin/icon-no.gif">"""
280 return html % settings.ADMIN_MEDIA_PREFIX
281 _actif.allow_tags = u'Employé actif'
282 _actif.short_description = u'Employé actif'
283 _actif.admin_order_field = 'employe__actif'
284
285 def _poste(self, dossier):
286 return unicode(dossier.poste.nom)
287 _poste.short_description = u'Poste'
288 _poste.admin_order_field = 'poste__nom'
289
290 def _employe(self, dossier):
291 return unicode(dossier.employe)
292 _employe.short_description = u'Employé'
293 _employe.admin_order_field = 'employe__nom'
294
295 def save_formset(self, request, form, formset, change):
296 instances = formset.save(commit=False)
297 for instance in instances:
298 if instance.__class__ == rh.DossierCommentaire:
299 instance.owner = request.user
300 instance.save()
301
302 def render_change_form(self, request, context, *args, **kwargs):
303 obj = kwargs.get('obj', None)
304
305 if not obj:
306 return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
307
308
309 remun, remun_sum, remun_sum_euro = calc_remun(obj)
310
311 extra = {
312 'remun': remun,
313 'remun_sum': remun_sum,
314 'remun_sum_euro': remun_sum_euro,
315 'employe': obj.employe,
316 'poste_nom': obj.poste.nom,
317 'poste_service': obj.poste.service,
318 'poste_implantation': obj.poste.implantation,
319 }
320
321 context.update(extra)
322
323 return super(DossierAdmin, self).render_change_form(request, context, *args, **kwargs)
324
325
326 class DossierPieceAdmin(admin.ModelAdmin):
327 pass
328
329
330 class DossierCommentaireAdmin(admin.ModelAdmin):
331 pass
332
333
334 class EmployeAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
335 alphabet_filter = 'nom'
336 search_fields = ('id', 'nom', 'prenom', 'nom_affichage', 'actif', )
337 list_filter = ('actif', )
338 ordering = ('nom', )
339 actions = ('desactiver', )
340 list_display = ('id', 'nom', 'prenom', 'actif', )
341 list_display_links = ('id', 'nom',)
342 inlines = (AyantDroitInline,
343 DossierROInline,
344 EmployePieceInline,
345 EmployeCommentaireInline)
346 fieldsets = AUFMetadataAdminMixin.fieldsets + (
347 ('Identification', {
348 'fields': (('nom', 'prenom'), ('nom_affichage', 'genre'), 'nationalite', 'date_naissance', )
349 }),
350 ('Informations personnelles', {
351 'fields': ('situation_famille', 'date_entree', )
352 }),
353 ('Coordonnées', {
354 'fields': (('tel_domicile', 'tel_cellulaire'), ('adresse', 'ville'), ('code_postal', 'province'), 'pays', )
355 }),
356 )
357
358 def save_formset(self, request, form, formset, change):
359 instances = formset.save(commit=False)
360 for instance in instances:
361 if instance.__class__ == rh.EmployeCommentaire:
362 instance.owner = request.user
363 instance.save()
364
365 class EmployeCommentaireAdmin(admin.ModelAdmin):
366 pass
367
368
369 class EmployePieceAdmin(admin.ModelAdmin):
370 pass
371
372
373 class EvenementAdmin(admin.ModelAdmin):
374 inlines = (EvenementRemunerationInline,)
375
376
377 class EvenementRemunerationAdmin(admin.ModelAdmin):
378 pass
379
380
381 class FamilleEmploiAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
382 inlines = (TypePosteInline,)
383 fieldsets = AUFMetadataAdminMixin.fieldsets + (
384 (None, {
385 'fields': ('nom', )
386 }),
387 )
388
389
390 class OrganismeBstgAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
391 search_fields = ('nom', )
392 list_display = ('nom', 'type', 'pays', )
393 inlines = (DossierROInline,)
394 fieldsets = AUFMetadataAdminMixin.fieldsets + (
395 (None, {
396 'fields': ('nom', 'type', 'pays', )
397 }),
398 )
399
400
401 class PosteAdmin(AUFMetadataAdminMixin, ProtectRegionMixin, admin.ModelAdmin):
402 alphabet_filter = 'nom'
403 search_fields = ('nom', 'implantation__code', 'implantation__nom', 'implantation__region__code', 'implantation__region__nom', )
404 list_display = ('nom', 'implantation', 'service', 'type_poste', 'date_debut', 'date_fin', )
405 fieldsets = AUFMetadataAdminMixin.fieldsets + (
406 (None, {
407 'fields': (('nom', 'nom_feminin'), 'implantation', 'type_poste',
408 'service', 'responsable')
409 }),
410 ('Contrat', {
411 'fields': (('regime_travail', 'regime_travail_nb_heure_semaine'), )
412 }),
413 ('Recrutement', {
414 'fields': (('local', 'expatrie', 'mise_a_disposition', 'appel'),)
415 }),
416 ('Rémunération', {
417 'fields': (('classement_min', 'classement_max'),
418 ('valeur_point_min', 'valeur_point_max'),
419 ('devise_min', 'devise_max'),
420 ('salaire_min', 'salaire_max'),
421 ('indemn_min', 'indemn_max'),
422 ('autre_min', 'autre_max'))
423 }),
424 ('Comparatifs de rémunération', {
425 'fields': ('devise_comparaison',
426 ('comp_locale_min', 'comp_locale_max'),
427 ('comp_universite_min', 'comp_universite_max'),
428 ('comp_fonctionpub_min', 'comp_fonctionpub_max'),
429 ('comp_ong_min', 'comp_ong_max'),
430 ('comp_autre_min', 'comp_autre_max'))
431 }),
432 ('Justification', {
433 'fields': ('justification',)
434 }),
435 ('Autres Metadata', {
436 'fields': ('date_validation', ('date_debut', 'date_fin'))
437 }),
438 )
439
440 inlines = (PosteFinancementInline,
441 PostePieceInline,
442 DossierROInline,
443 PosteCommentaireInline, )
444
445 def save_formset(self, request, form, formset, change):
446 instances = formset.save(commit=False)
447 for instance in instances:
448 if instance.__class__ == rh.PosteCommentaire:
449 instance.owner = request.user
450 instance.save()
451 formset.save_m2m()
452
453
454 class PosteCommentaireAdmin(admin.ModelAdmin):
455 pass
456
457
458 class PosteFinancementAdmin(admin.ModelAdmin):
459 pass
460
461
462 class PostePieceAdmin(admin.ModelAdmin):
463 pass
464
465
466 class RemunerationAdmin(admin.ModelAdmin):
467 pass
468
469
470 class ResponsableImplantationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
471 fieldsets = AUFMetadataAdminMixin.fieldsets + (
472 (None, {
473 'fields': ('employe', 'implantation', ),
474 }),
475 )
476
477
478 class ServiceAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
479 list_display = ('nom', 'actif', )
480 fieldsets = AUFMetadataAdminMixin.fieldsets + (
481 (None, {
482 'fields': ('nom', ),
483 }),
484 )
485
486 class StatutAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
487 fieldsets = AUFMetadataAdminMixin.fieldsets + (
488 (None, {
489 'fields': ('code', 'nom', ),
490 }),
491 )
492
493 class TauxChangeAdmin(admin.ModelAdmin):
494 list_display = ('taux', 'devise', 'annee', )
495 list_filter = ('devise', )
496 fieldsets = AUFMetadataAdminMixin.fieldsets + (
497 (None, {
498 'fields': ('taux', 'devise', 'annee', ),
499 }),
500 )
501
502 class TypeContratAdmin(admin.ModelAdmin):
503 inlines = (ContratInline,)
504 fieldsets = AUFMetadataAdminMixin.fieldsets + (
505 (None, {
506 'fields': ('nom', 'nom_long', ),
507 }),
508 )
509
510
511 class TypePosteAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
512 search_fields = ('nom', 'nom_feminin', )
513 list_display = ('nom', 'famille_emploi', )
514 list_filter = ('famille_emploi', )
515 fieldsets = AUFMetadataAdminMixin.fieldsets + (
516 (None, {
517 'fields': ('nom', 'nom_feminin', 'is_responsable', 'famille_emploi', )
518 }),
519 )
520
521
522 class TypeRemunerationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
523 list_display = ('nom', 'type_paiement', 'nature_remuneration', )
524 #inlines = (RemunerationROInline,) utilité?
525 fieldsets = AUFMetadataAdminMixin.fieldsets + (
526 (None, {
527 'fields': ('nom', 'type_paiement', 'nature_remuneration', )
528 }),
529 )
530
531
532 class TypeRevalorisationAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
533 #inlines = (RemunerationROInline,) utilité?
534 fieldsets = AUFMetadataAdminMixin.fieldsets + (
535 (None, {
536 'fields': ('nom', )
537 }),
538 )
539
540
541 class ValeurPointAdmin(AUFMetadataAdminMixin, admin.ModelAdmin):
542 list_display = ('_devise_code', '_devise_nom', 'annee', 'valeur', )
543 fieldsets = AUFMetadataAdminMixin.fieldsets + (
544 (None, {
545 'fields': ('valeur', 'devise', 'implantation', 'annee', )
546 }),
547 )
548
549 def _devise_code(self, obj):
550 return obj.devise.code
551 _devise_code.short_description = "Code de la devise"
552
553 def _devise_nom(self, obj):
554 return obj.devise.nom
555 _devise_nom.short_description = "Nom de la devise"
556
557
558 def calc_remun(dossier):
559 thisyear = datetime.date.today().year
560 thisyearfilter = Q(date_debut__year=thisyear) | Q(date_fin__year=thisyear)
561
562 remunnow = dossier.rh_remuneration_remunerations.filter(thisyearfilter)
563
564 remun_sum = 0
565 remun_sum_euro = 0
566 sums = defaultdict(int)
567 sums_euro = defaultdict(int)
568 for r in remunnow:
569 nature = r.type.nature_remuneration
570 sums[nature] += r.montant
571 sums_euro[nature] += r.montant_euro()
572 remun_sum += r.montant
573 remun_sum_euro += r.montant_euro()
574
575 remun = {}
576 sums = dict(sums)
577 for n, s in sums.iteritems():
578 remun[n] = [sums[n], sums_euro[n]]
579
580 return remun, remun_sum, remun_sum_euro