Commit | Line | Data |
---|---|---|
5d680e84 | 1 | # -*- encoding: utf-8 -*- |
8e30e17f | 2 | from datetime import date |
139686f2 | 3 | from json import dumps |
768d7e1b | 4 | import warnings |
139686f2 NC |
5 | |
6 | from django.http import Http404, HttpResponse | |
5d680e84 NC |
7 | from django.shortcuts import redirect, render_to_response, get_object_or_404 |
8 | from django.template import RequestContext | |
9 | ||
139686f2 | 10 | from project.dae.forms import (ChoosePosteForm, DossierForm, EmployeForm, |
d766bf2c OL |
11 | PosteForm, PosteFinancementForm, PostePieceForm, |
12 | DossierPieceForm) | |
5d680e84 NC |
13 | from project.dae import models as dae |
14 | from project.rh_v1 import models as rh | |
15 | ||
e993f3dc | 16 | from project.decorators import admin_required |
5d680e84 | 17 | |
ed1982f3 | 18 | |
36341125 | 19 | |
5d680e84 NC |
20 | def index(request): |
21 | return render_to_response('dae/index.html', {}, RequestContext(request)) | |
22 | ||
ed1982f3 | 23 | |
3ed49093 | 24 | def poste(request, key=None): |
5d680e84 NC |
25 | """ Formulaire pour un poste. |
26 | ||
27 | Permet de créer ou modifier un poste. Si le poste n'existe que dans rh_v1 | |
28 | il est automatiquement copié dans dae. | |
29 | ||
30 | """ | |
31 | poste, data, vars = None, dict(), dict() | |
32 | ||
3ed49093 | 33 | if key: |
5d680e84 | 34 | # Poste existant |
3ed49093 | 35 | data['poste'] = key |
139686f2 | 36 | source, id = key.split('-') |
5d680e84 | 37 | |
139686f2 | 38 | if source == 'dae': |
5d680e84 | 39 | poste = get_object_or_404(dae.Poste, pk=id) |
139686f2 NC |
40 | elif source == 'rh': |
41 | p = get_object_or_404(rh.Poste, pk=id) | |
5d680e84 NC |
42 | # Initialisation avec les valeurs du poste de rh_v1 |
43 | poste = dae.Poste(id_rh=p, nom=p.type_poste.nom) | |
44 | for field in ('implantation', 'type_poste', 'actif'): | |
45 | setattr(poste, field, getattr(p, field)) | |
3ed49093 NC |
46 | else: |
47 | # Nouveau poste | |
48 | vars['new'] = True | |
5d680e84 NC |
49 | |
50 | if request.POST: | |
3ed49093 | 51 | data.update(dict(request.POST.items())) |
5d680e84 | 52 | form = PosteForm(data, instance=poste) |
36341125 | 53 | piecesForm = PostePieceForm(request.POST, request.FILES, instance=poste) |
3ed49093 | 54 | if 'save' in data and form.is_valid(): |
5d680e84 | 55 | poste = form.save() |
36341125 | 56 | piecesForm.save() |
24d44b1b | 57 | return redirect('poste', key='dae-%s' % poste.id) |
5d680e84 NC |
58 | else: |
59 | # 'initial' évite la validation prémature lors d'une copie de poste de | |
60 | # rh_v1 vers dae. | |
61 | form = PosteForm(initial=data, instance=poste) | |
36341125 | 62 | piecesForm = PostePieceForm(instance=poste) |
5d680e84 | 63 | |
36341125 | 64 | vars.update(dict(form=form, poste=poste, poste_key=key, piecesForm=piecesForm)) |
5d680e84 NC |
65 | |
66 | return render_to_response('dae/poste.html', vars, RequestContext(request)) | |
3ed49093 | 67 | |
98d51b59 | 68 | |
498881f4 | 69 | def postes_liste(request): |
0f23302a | 70 | """ Liste des postes. """ |
498881f4 | 71 | vars = dict() |
0f23302a | 72 | vars['postes'] = dae.Poste.objects.all().order_by('-date_creation') |
98d51b59 NC |
73 | return render_to_response('dae/postes_liste.html', vars, |
74 | RequestContext(request)) | |
75 | ||
3ed49093 NC |
76 | |
77 | def financement(request, key=None, id=None): | |
78 | """ Formulaire pour une source de financement pour un poste. """ | |
79 | poste, financement, data, vars = None, None, dict(), dict() | |
80 | ||
81 | if request.POST: | |
82 | data.update(dict(request.POST.items())) | |
83 | ||
84 | if key: | |
139686f2 | 85 | source, poste_id = key.split('-') |
703e5cfb | 86 | vars['poste_key'] = key |
139686f2 | 87 | if source == 'dae': |
3ed49093 NC |
88 | poste = get_object_or_404(dae.Poste, pk=poste_id) |
89 | if id: | |
90 | # Financement existant | |
91 | financement = get_object_or_404(dae.PosteFinancement, pk=id) | |
703e5cfb | 92 | vars['financement_id'] = id |
3ed49093 NC |
93 | else: |
94 | # Nouveau financement | |
95 | financement = dae.PosteFinancement(poste_id=poste_id) | |
96 | vars['new'] = True | |
97 | ||
98 | if not financement: | |
99 | return Http404 | |
100 | ||
101 | if request.POST: | |
102 | form = PosteFinancementForm(data, instance=financement) | |
103 | if 'delete' in data: | |
104 | financement.delete() | |
105 | elif 'save' in data and form.is_valid(): | |
106 | financement = form.save() | |
107 | return redirect('poste', key='dae-%s' % poste.id) | |
108 | else: | |
109 | form = PosteFinancementForm(initial=data, instance=financement) | |
110 | ||
111 | vars.update(dict(form=form, financement=financement)) | |
112 | ||
703e5cfb NC |
113 | if 'ajax' in request.GET: |
114 | template = 'dae/financement.html' | |
115 | else: | |
116 | template = 'dae/financement-full.html' | |
117 | return render_to_response(template, vars, RequestContext(request)) | |
139686f2 NC |
118 | |
119 | ||
ed1982f3 | 120 | def embauche(request, key=None, dossier=None): |
139686f2 NC |
121 | """ Formulaire d'autorisation d'embauche. """ |
122 | if not key: | |
123 | vars = dict(step='poste', form=ChoosePosteForm()) | |
124 | else: | |
125 | source, id = key.split('-') | |
126 | if source != 'dae': | |
127 | return Http404 | |
128 | poste = get_object_or_404(dae.Poste, pk=id) | |
139686f2 NC |
129 | |
130 | if request.POST: | |
768d7e1b NC |
131 | if request.POST['employe'] == '': |
132 | # Nouvel employé | |
133 | employe = dae.Employe() | |
139686f2 | 134 | else: |
768d7e1b NC |
135 | employe_source, id = request.POST['employe'].split('-') |
136 | if employe_source == 'dae': | |
137 | # Employé DAE | |
138 | employe = get_object_or_404(dae.Employe, pk=id) | |
139 | elif employe_source == 'rh': | |
140 | # Employé RH, on le copie dans DAE | |
141 | e = get_object_or_404(rh.Employe, pk=id) | |
142 | employe = dae.Employe(id_rh=e, prenom=e.prenom, nom=e.nom, | |
143 | genre=e.genre) | |
144 | else: | |
145 | raise Http404 | |
146 | ||
139686f2 | 147 | employe_form = EmployeForm(request.POST, instance=employe) |
768d7e1b NC |
148 | |
149 | if 'save' in request.POST: | |
150 | if employe_form.is_valid(): | |
151 | data = dict(request.POST.items()) | |
152 | with warnings.catch_warnings(): | |
153 | warnings.simplefilter('ignore') | |
154 | employe = employe_form.save() | |
155 | data['employe'] = 'dae-%s' % employe.id | |
156 | employe_form = EmployeForm(data, instance=employe) | |
ed1982f3 NC |
157 | if not dossier: |
158 | dossier = dae.Dossier(poste=poste, employe=employe) | |
159 | else: | |
160 | dossier = get_object_or_404(dae.Dossier, pk=dossier) | |
161 | dossier_form = DossierForm(request.POST, instance=dossier) | |
d766bf2c OL |
162 | piecesForm = DossierPieceForm(request.POST, request.FILES, instance=dossier) |
163 | ||
768d7e1b NC |
164 | if dossier_form.is_valid(): |
165 | dossier = dossier_form.save() | |
d766bf2c | 166 | piecesForm.save() |
768d7e1b NC |
167 | return redirect('embauche', key='dae-%s' % poste.id, |
168 | dossier=dossier.id) | |
169 | else: | |
170 | dossier_form = DossierForm(instance=dossier) | |
d766bf2c | 171 | piecesForm = DossierPieceForm(instance=dossier) |
ed1982f3 | 172 | else: |
768d7e1b | 173 | # Initialisation d'un formulaire vide |
ed1982f3 NC |
174 | dossier_rh = rh.Dossier() |
175 | poste_rh = poste.id_rh | |
768d7e1b NC |
176 | if dossier: |
177 | dossier = get_object_or_404(dae.Dossier, pk=dossier) | |
178 | employe = dossier.employe | |
179 | data = dict(employe='dae-%s' % employe.id) | |
180 | employe_form = EmployeForm(initial=data, instance=employe) | |
181 | else: | |
182 | dossier = pre_filled_dossier(dossier_rh, 'new', poste_rh) | |
183 | employe_form = EmployeForm() | |
d766bf2c | 184 | |
ed1982f3 | 185 | dossier_form = DossierForm(instance=dossier) |
d766bf2c | 186 | piecesForm = DossierPieceForm(instance=dossier) |
ed1982f3 | 187 | |
d766bf2c OL |
188 | vars = dict(step='employe', poste=poste, dossier=dossier, piecesForm=piecesForm, |
189 | forms=dict(employe=employe_form, dossier=dossier_form, )) | |
139686f2 | 190 | |
139686f2 NC |
191 | return render_to_response('dae/embauche.html', vars, |
192 | RequestContext(request)) | |
193 | ||
194 | ||
195 | def employe(request, key): | |
196 | """ Récupération AJAX de l'employé pour la page d'embauche. """ | |
197 | data = dict(employe=key) | |
198 | ||
199 | if key == '': | |
200 | # Nouvel employé | |
201 | employe = dae.Employe() | |
202 | else: | |
203 | # Employé existant | |
204 | source, id = key.split('-') | |
205 | ||
206 | if source == 'dae': | |
207 | employe = get_object_or_404(dae.Employe, pk=id) | |
208 | elif source == 'rh': | |
209 | e = get_object_or_404(rh.Employe, id=id) | |
210 | # Initialisation avec les valeurs de l'employé de rh_v1 | |
211 | employe = dae.Employe(id_rh=e) | |
212 | for field in ('prenom', 'nom', 'genre'): | |
213 | setattr(employe, field, getattr(e, field)) | |
214 | ||
215 | return HttpResponse(EmployeForm(initial=data, instance=employe).as_table()) | |
216 | ||
217 | ||
218 | def dossier(request, poste_key, employe_key): | |
219 | """ Récupération AJAX du dossier pour la page d'embauche. """ | |
220 | data = dict() | |
221 | ||
222 | poste_source, poste_id = poste_key.split('-') | |
223 | poste = get_object_or_404(dae.Poste, pk=poste_id) | |
224 | poste_rh = get_object_or_404(rh.Poste, pk=poste.id_rh_id) | |
225 | ||
226 | if employe_key == '': | |
227 | employe_source = 'new' | |
228 | dossier_rh = rh.Dossier() | |
229 | else: | |
230 | # Récupération des données de RH v1 | |
231 | employe_source, employe_id = employe_key.split('-') | |
232 | if employe_source == 'dae': | |
233 | employe = get_object_or_404(dae.Employe, pk=employe_id) | |
234 | employe_source, employe_id = 'rh', employe.id_rh_id | |
235 | if employe_source == 'rh': | |
236 | employe_rh = get_object_or_404(rh.Employe, pk=employe_id) | |
237 | try: | |
238 | dossier_rh = rh.Dossier.objects.get(employe=employe_rh, | |
239 | mandat_date_fin=None) | |
240 | except (rh.Dossier.DoesNotExist): | |
241 | dossier_rh = rh.Dossier() | |
242 | ||
139686f2 NC |
243 | # Récupération du dossier dae existant ou pré-remplissage |
244 | # des valeurs par défaut | |
245 | if employe_source == 'dae': | |
246 | try: | |
247 | dossier = dae.Dossier.objects.get(employe=employe, poste=poste) | |
248 | except (dae.Dossier.DoesNotExist): | |
ed1982f3 | 249 | dossier = pre_filled_dossier(dossier_rh, employe_source, poste_rh) |
139686f2 | 250 | else: |
ed1982f3 | 251 | dossier = pre_filled_dossier(dossier_rh, employe_source, poste_rh) |
139686f2 | 252 | |
da3ca955 | 253 | dossier_form = DossierForm(initial=data, instance=dossier) |
254 | vars = dict(form=dossier_form) | |
255 | ||
256 | return render_to_response('dae/embauche-dossier.html', vars, | |
257 | RequestContext(request)) | |
139686f2 NC |
258 | |
259 | ||
260 | def salaire(request, implantation, devise, classement): | |
261 | if not devise or not classement: | |
262 | raise Http404 | |
263 | ||
264 | taux_impl = rh.TauxChange.objects.filter(implantation=implantation) \ | |
265 | .order_by('-annee') | |
266 | taux = rh.TauxChange.objects.filter(devise=devise).order_by('-annee') | |
267 | vp = rh.ValeurPoint.objects.filter(implantation=implantation) \ | |
268 | .order_by('-annee') | |
269 | if vp.count() * taux.count() * taux_impl.count() == 0: | |
270 | raise Http404 | |
271 | ||
272 | classement = get_object_or_404(rh.Classement, pk=classement) | |
273 | taux, taux_impl, vp = taux[0].taux, taux_impl[0].taux, vp[0].valeur | |
274 | ||
275 | salaire_euro = round(vp * classement.coefficient * taux_impl, 2) | |
276 | data = dict(salaire_euro=salaire_euro, taux=taux, | |
277 | salaire_devise=round(salaire_euro / taux, 2)) | |
278 | ||
279 | return HttpResponse(dumps(data)) | |
ed1982f3 NC |
280 | |
281 | ||
282 | def pre_filled_dossier(dossier_rh, employe_source, poste_rh): | |
283 | dossier = dae.Dossier() | |
284 | ||
285 | if employe_source != 'new' and dossier_rh.id: | |
286 | dossier.statut_anterieur = dossier_rh.statut | |
287 | ||
288 | # Certains dossiers ont un classement à zéro | |
289 | if dossier_rh.classement_id > 0: | |
290 | dossier.classement_anterieur = dossier_rh.classement | |
291 | ||
292 | # Récupération du salaire de base | |
293 | remun = dossier_rh.remuneration_set.filter(type=1) | |
294 | if remun: | |
295 | dossier.salaire_anterieur = remun[0].montant | |
296 | ||
297 | # Récupération du titulaire précédent | |
298 | try: | |
299 | dossiers = rh.Dossier.objects.order_by('-mandat_date_fin') | |
300 | dossiers = dossiers.filter(poste1=poste_rh) \ | |
301 | | dossiers.filter(poste2=poste_rh) | |
302 | if len(dossiers): | |
303 | # Ce bloc ignore toutes les erreurs, car les données de rh | |
304 | # manquantes peuvent en générer | |
305 | d = dossiers[0] | |
306 | try: | |
307 | titulaire = d.employe | |
308 | dossier.employe_anterieur = titulaire | |
309 | dossier.classement_titulaire_anterieur = d.classement | |
310 | dossier.statut_titulaire_anterieur = d.statut | |
311 | dossier.salaire_titulaire_anterieur = \ | |
312 | d.remuneration_set.all()[0].montant | |
313 | except: | |
314 | pass | |
315 | # TODO: afficher l'info, les champs ne sont pas dans le | |
316 | # modèle dae.Dossier: nom, prenom, classement, salaire | |
317 | pass | |
318 | ||
319 | except (rh.Dossier.DoesNotExist): | |
320 | dossier_rh = rh.Dossier() | |
321 | ||
322 | return dossier | |
323 | ||
b50b0cd3 | 324 | def coefficient(request): |
3d627bfd | 325 | """ Appel AJAX : |
326 | input : classement | |
327 | output : coefficient | |
328 | """ | |
b50b0cd3 | 329 | data = dict() |
330 | if request.POST and 'classement' in request.POST: | |
331 | classement = request.POST.get('classement') | |
332 | classement = rh.Classement.objects.get(pk=classement) | |
333 | data['coefficient'] = classement.coefficient | |
334 | return HttpResponse(dumps(data)) | |
335 | ||
85668061 | 336 | def valeur(request): |
3d627bfd | 337 | """ Appel AJAX : |
338 | input : valeur_point | |
339 | output : valeur | |
340 | """ | |
85668061 | 341 | data = dict() |
342 | if request.POST and 'valeur_point' in request.POST: | |
343 | valeur_point = request.POST.get('valeur_point') | |
344 | valeur_point = rh.ValeurPoint.objects.get(pk=valeur_point) | |
345 | data['valeur'] = valeur_point.valeur | |
346 | return HttpResponse(dumps(data)) | |
3d627bfd | 347 | |
348 | def devise(request): | |
349 | """ Appel AJAX : | |
350 | input : valeur_point | |
8e30e17f | 351 | output : devise, devise_code, taux_euro |
3d627bfd | 352 | """ |
353 | data = dict() | |
354 | if request.POST and 'valeur_point' in request.POST: | |
355 | valeur_point = request.POST.get('valeur_point') | |
356 | valeur_point = rh.ValeurPoint.objects.get(pk=valeur_point) | |
357 | annee = valeur_point.annee | |
358 | implantation = valeur_point.implantation | |
359 | taux = rh.TauxChange.objects.get(annee=annee, | |
360 | implantation=implantation) | |
361 | data['devise'] = taux.devise.id | |
362 | data['devise_code'] = taux.devise.code | |
8e30e17f | 363 | data['taux_euro'] = taux.taux |
3d627bfd | 364 | return HttpResponse(dumps(data)) |
365 | ||
366 | def devise_code(request): | |
367 | """ Appel AJAX : | |
368 | input : devise | |
8e30e17f | 369 | output : devise_code, taux_euro |
3d627bfd | 370 | """ |
371 | data = dict() | |
372 | if request.POST and 'devise' in request.POST: | |
373 | devise = request.POST.get('devise') | |
374 | devise = rh.Devise.objects.get(pk=devise) | |
8e30e17f | 375 | annee = date.today().year |
376 | taux = rh.TauxChange.objects.filter(annee=annee, devise=devise) | |
3d627bfd | 377 | data['devise_code'] = devise.code |
8e30e17f | 378 | data['taux_euro'] = taux[0].taux |
3d627bfd | 379 | return HttpResponse(dumps(data)) |
85668061 | 380 |