ScoDoc-Lille/app/scodoc/sco_formsemestre_exterieurs.py

494 lines
17 KiB
Python
Raw Permalink Normal View History

2020-09-26 16:19:37 +02:00
# -*- mode: python -*-
# -*- coding: utf-8 -*-
##############################################################################
#
# Gestion scolarite IUT
#
2022-01-01 14:49:42 +01:00
# Copyright (c) 1999 - 2022 Emmanuel Viennet. All rights reserved.
2020-09-26 16:19:37 +02:00
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
# Emmanuel Viennet emmanuel.viennet@viennet.net
#
##############################################################################
"""Saisie et gestion des semestres extérieurs à ScoDoc dans un parcours.
On va créer/gérer des semestres de la même formation que le semestre ScoDoc
est inscrit l'étudiant, leur attribuer la modalité 'EXT'.
Ces semestres n'auront qu'un seul inscrit !
"""
import time
2021-08-01 10:16:16 +02:00
import flask
from flask import url_for, g, request
2021-08-22 13:24:36 +02:00
from flask_login import current_user
from app.comp import res_sem
from app.comp.res_compat import NotesTableCompat
from app.models import FormSemestre
import app.scodoc.sco_utils as scu
import app.scodoc.notesdb as ndb
2021-08-29 19:57:32 +02:00
from app import log
from app.scodoc.TrivialFormulator import TrivialFormulator, tf_error_message
from app.scodoc import html_sco_header
2021-07-19 19:53:01 +02:00
from app.scodoc import sco_cache
from app.scodoc import sco_edit_ue
from app.scodoc import sco_formations
from app.scodoc import sco_formsemestre
from app.scodoc import sco_formsemestre_inscriptions
from app.scodoc import sco_formsemestre_validation
2022-07-07 16:24:52 +02:00
from app.scodoc import sco_cursus_dut
from app.scodoc import sco_etud
2020-09-26 16:19:37 +02:00
def formsemestre_ext_create(etudid, sem_params):
2020-09-26 16:19:37 +02:00
"""Crée un formsemestre exterieur et y inscrit l'étudiant.
sem_params: dict nécessaire à la création du formsemestre
"""
# Check args
_formation = sco_formations.formation_list(
2021-08-19 10:28:35 +02:00
args={"formation_id": sem_params["formation_id"]}
2020-09-26 16:19:37 +02:00
)[0]
if etudid:
2021-08-22 13:24:36 +02:00
_etud = sco_etud.get_etud_info(etudid=etudid, filled=True)[0]
2020-09-26 16:19:37 +02:00
# Create formsemestre
sem_params["modalite"] = "EXT"
sem_params["etapes"] = None
2021-08-22 13:24:36 +02:00
sem_params["responsables"] = [current_user.id]
formsemestre_id = sco_formsemestre.do_formsemestre_create(sem_params, silent=True)
2020-09-26 16:19:37 +02:00
# nota: le semestre est créé vide: pas de modules
# Inscription au semestre
sco_formsemestre_inscriptions.do_formsemestre_inscription_with_modules(
formsemestre_id,
etudid,
method="formsemestre_ext_create",
)
return formsemestre_id
def formsemestre_ext_create_form(etudid, formsemestre_id):
2020-09-26 16:19:37 +02:00
"""Formulaire creation/inscription à un semestre extérieur"""
2021-08-22 13:24:36 +02:00
etud = sco_etud.get_etud_info(etudid=etudid, filled=True)[0]
2020-09-26 16:19:37 +02:00
H = [
html_sco_header.sco_header(),
2020-09-26 16:19:37 +02:00
"""<h2>Enregistrement d'une inscription antérieure dans un autre établissement</h2>
<p class="help">
Cette opération créé un semestre extérieur ("ancien") et y inscrit juste cet étudiant.
La décision de jury peut ensuite y être saisie.
</p>
<p class="help">
Notez que si un semestre extérieur similaire a déjà été créé pour un autre étudiant,
il est préférable d'utiliser la fonction
2021-05-11 11:48:32 +02:00
"<a href="formsemestre_inscription_with_modules_form?etudid=%s&only_ext=1">
2020-09-26 16:19:37 +02:00
inscrire à un autre semestre</a>"
</p>
"""
% (etudid,),
"""<h3><a href="%s" class="stdlink">Etudiant %s</a></h3>"""
% (
url_for("scolar.ficheEtud", scodoc_dept=g.scodoc_dept, etudid=etudid),
etud["nomprenom"],
),
2020-09-26 16:19:37 +02:00
]
F = html_sco_header.sco_footer()
2021-08-19 10:28:35 +02:00
orig_sem = sco_formsemestre.get_formsemestre(formsemestre_id)
2020-09-26 16:19:37 +02:00
# Ne propose que des semestres de semestre_id strictement inférieur au semestre courant
# et seulement si pas inscrit au même semestre_id d'un semestre ordinaire ScoDoc.
# Les autres situations (eg redoublements en changeant d'établissement)
# doivent être gérées par les validations de semestres "antérieurs"
insem = sco_formsemestre_inscriptions.do_formsemestre_inscription_list(
2021-08-19 10:28:35 +02:00
args={"etudid": etudid, "etat": "I"}
2020-09-26 16:19:37 +02:00
)
2021-08-19 10:28:35 +02:00
semlist = [sco_formsemestre.get_formsemestre(i["formsemestre_id"]) for i in insem]
2020-09-26 16:19:37 +02:00
existing_semestre_ids = set([s["semestre_id"] for s in semlist])
min_semestre_id = 1
max_semestre_id = orig_sem["semestre_id"]
semestre_ids = set(range(min_semestre_id, max_semestre_id)) - existing_semestre_ids
H.append(
"""<p>L'étudiant est déjà inscrit dans des semestres ScoDoc de rangs:
%s
</p>"""
% sorted(list(existing_semestre_ids))
)
if not semestre_ids:
H.append("""<p class="warning">pas de semestres extérieurs possibles</p>""")
return "\n".join(H) + F
# Formulaire
2021-08-30 23:28:15 +02:00
semestre_ids_list = sorted(semestre_ids)
semestre_ids_labels = [f"S{x}" for x in semestre_ids_list]
2020-09-26 16:19:37 +02:00
descr = [
("formsemestre_id", {"input_type": "hidden"}),
("etudid", {"input_type": "hidden"}),
(
"semestre_id",
{
"input_type": "menu",
"title": "Indice du semestre dans le cursus",
2021-08-30 23:28:15 +02:00
"allowed_values": semestre_ids_list,
"labels": semestre_ids_labels,
2020-09-26 16:19:37 +02:00
},
),
(
"titre",
{
"size": 40,
"title": "Nom de ce semestre extérieur",
"explanation": """par exemple: établissement. N'indiquez pas les dates, ni le semestre, ni la modalité dans
le titre: ils seront automatiquement ajoutés""",
},
),
(
"date_debut",
{
"title": "Date de début", # j/m/a
"input_type": "datedmy",
2020-09-26 16:19:37 +02:00
"explanation": "j/m/a (peut être approximatif)",
"size": 9,
"allow_null": False,
},
),
(
"date_fin",
{
"title": "Date de fin", # j/m/a
"input_type": "datedmy",
2020-09-26 16:19:37 +02:00
"explanation": "j/m/a (peut être approximatif)",
"size": 9,
"allow_null": False,
},
),
(
"elt_help_ue",
{
"title": """Les notes et coefficients des UE
capitalisées seront saisis ensuite""",
"input_type": "separator",
},
),
]
tf = TrivialFormulator(
request.base_url,
scu.get_request_args(),
2020-09-26 16:19:37 +02:00
descr,
cancelbutton="Annuler",
method="post",
submitlabel="Créer semestre extérieur et y inscrire l'étudiant",
cssclass="inscription",
name="tf",
)
if tf[0] == 0:
H.append(
"""<p>Ce formulaire sert à enregistrer un semestre antérieur dans la formation
effectué dans un autre établissement.
</p>"""
)
return "\n".join(H) + "\n" + tf[1] + F
elif tf[0] == -1:
2021-07-31 18:01:10 +02:00
return flask.redirect(
2021-05-11 11:48:32 +02:00
"%s/formsemestre_bulletinetud?formsemestre_id==%s&etudid=%s"
2021-06-15 12:34:33 +02:00
% (scu.ScoURL(), formsemestre_id, etudid)
2020-09-26 16:19:37 +02:00
)
else:
tf[2]["formation_id"] = orig_sem["formation_id"]
formsemestre_ext_create(etudid, tf[2])
2021-07-31 18:01:10 +02:00
return flask.redirect(
url_for("scolar.ficheEtud", scodoc_dept=g.scodoc_dept, etudid=etudid)
2020-09-26 16:19:37 +02:00
)
def formsemestre_ext_edit_ue_validations(formsemestre_id, etudid):
2020-09-26 16:19:37 +02:00
"""Edition des validations d'UE et de semestre (jury)
pour un semestre extérieur.
On peut saisir pour chaque UE du programme de formation
sa validation, son code jury, sa note, son coefficient.
La moyenne générale du semestre est calculée et affichée,
mais pas enregistrée.
"""
2021-08-19 10:28:35 +02:00
sem = sco_formsemestre.get_formsemestre(formsemestre_id)
etud = sco_etud.get_etud_info(etudid=etudid, filled=True)[0]
ues = _list_ue_with_coef_and_validations(sem, etudid)
descr = _ue_form_description(ues, scu.get_request_args())
if request.method == "GET":
2020-09-26 16:19:37 +02:00
initvalues = {
"note_" + str(ue["ue_id"]): ue["validation"].get("moy_ue", "") for ue in ues
2020-09-26 16:19:37 +02:00
}
else:
initvalues = {}
tf = TrivialFormulator(
request.base_url,
scu.get_request_args(),
2020-09-26 16:19:37 +02:00
descr,
cssclass="tf_ext_edit_ue_validations",
submitlabel="Enregistrer ces validations",
cancelbutton="Annuler",
initvalues=initvalues,
)
if tf[0] == -1:
return "<h4>annulation</h4>"
else:
H = _make_page(etud, sem, tf)
2020-09-26 16:19:37 +02:00
if tf[0] == 0: # premier affichage
return "\n".join(H)
else: # soumission
# simule erreur
ok, message = _check_values(ues, tf[2])
2020-09-26 16:19:37 +02:00
if not ok:
H = _make_page(etud, sem, tf, message=message)
2020-09-26 16:19:37 +02:00
return "\n".join(H)
else:
# Submit
_record_ue_validations_and_coefs(formsemestre_id, etudid, ues, tf[2])
2021-07-31 18:01:10 +02:00
return flask.redirect(
2020-09-26 16:19:37 +02:00
"formsemestre_bulletinetud?formsemestre_id=%s&etudid=%s"
% (formsemestre_id, etudid)
)
2022-05-10 22:40:00 +02:00
def _make_page(etud: dict, sem, tf, message="") -> list:
formsemestre = FormSemestre.query.get_or_404(sem["formsemestre_id"])
nt: NotesTableCompat = res_sem.load_formsemestre_results(formsemestre)
2020-09-26 16:19:37 +02:00
moy_gen = nt.get_etud_moy_gen(etud["etudid"])
H = [
2021-06-13 23:37:14 +02:00
html_sco_header.sco_header(
2020-09-26 16:19:37 +02:00
page_title="Validation des UE d'un semestre extérieur",
javascripts=["js/formsemestre_ext_edit_ue_validations.js"],
),
tf_error_message(message),
2020-09-26 16:19:37 +02:00
"""<p><b>%(nomprenom)s</b> est inscrit%(ne)s à ce semestre extérieur.</p>
<p>Voici les UE entregistrées avec leur notes et coefficients.
</p>
"""
% etud,
2022-05-10 22:40:00 +02:00
f"""<p>La moyenne de ce semestre serait:
<span class="ext_sem_moy"><span class="ext_sem_moy_val">{moy_gen}</span> / 20</span>
2020-09-26 16:19:37 +02:00
</p>
2022-05-10 22:40:00 +02:00
""",
2020-09-26 16:19:37 +02:00
'<div id="formsemestre_ext_edit_ue_validations">',
tf[1],
"</div>",
2022-05-10 22:40:00 +02:00
f"""<div>
<a class="stdlink"
href="{url_for("notes.formsemestre_bulletinetud", scodoc_dept=g.scodoc_dept,
formsemestre_id=formsemestre.id, etudid=etud['etudid']
)}">retour au bulletin de notes</a>
</div>
""",
html_sco_header.sco_footer(),
2020-09-26 16:19:37 +02:00
]
return H
_UE_VALID_CODES = {
None: "Non inscrit",
"ADM": "Capitalisée (ADM)",
# "CMP": "Acquise (car semestre validé)",
}
def _ue_form_description(ues, values):
2020-09-26 16:19:37 +02:00
"""Description du formulaire de saisie des UE / validations
Pour chaque UE, on peut saisir: son code jury, sa note, son coefficient.
"""
descr = [
(
"head_sep",
{
"input_type": "separator",
"template": """<tr %(item_dom_attr)s><th>UE</th>
<th>Code jury</th><th>Note/20</th><th>Coefficient UE</th></tr>
""",
},
),
("formsemestre_id", {"input_type": "hidden"}),
("etudid", {"input_type": "hidden"}),
]
for ue in ues:
2020-09-26 16:19:37 +02:00
# Menu pour code validation UE:
# Ne propose que ADM, CMP et "Non inscrit"
2021-08-11 11:53:20 +02:00
select_name = "valid_" + str(ue["ue_id"])
2020-09-26 16:19:37 +02:00
menu_code_UE = """<select class="ueext_valid_select" name="%s">""" % (
select_name,
)
2021-08-11 11:53:20 +02:00
cur_value = values.get("valid_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
for code in _UE_VALID_CODES:
if cur_value is False: # pas dans le form, cherche en base
cur_value = ue["validation"].get("code", None)
if str(cur_value) == str(code):
selected = "selected"
else:
selected = ""
menu_code_UE += '<option value="%s" %s>%s</option>' % (
code,
selected,
_UE_VALID_CODES[code],
)
if cur_value is None:
disabled = 'disabled="1"'
else:
disabled = ""
menu_code_UE += "</select>"
2021-08-11 11:53:20 +02:00
cur_value = values.get("coef_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
if cur_value is False: # pas dans le form, cherche en base
cur_value = ue["uecoef"].get("coefficient", "")
itemtemplate = (
"""<tr><td class="tf-fieldlabel">%(label)s</td>"""
+ "<td>"
+ menu_code_UE
+ "</td>" # code jury
+ '<td class="tf-field tf_field_note">%(elem)s</td>' # note
+ """<td class="tf-field tf_field_coef">
<input type="text" size="4" name="coef_%s" value="%s" %s></input></td>
"""
% (ue["ue_id"], cur_value, disabled)
+ "</td></tr>"
)
descr.append(
(
"note_" + str(ue["ue_id"]),
{
"input_type": "text",
"size": 4,
"template": itemtemplate,
"title": "<tt><b>%(acronyme)s</b></tt> %(titre)s" % ue,
"attributes": [disabled],
},
)
)
return descr
def _check_values(ue_list, values):
2020-09-26 16:19:37 +02:00
"""Check that form values are ok
for each UE:
code != None => note and coef
note or coef => code != None
note float in [0, 20]
note => coef
coef float >= 0
"""
for ue in ue_list:
pu = " pour UE %s" % ue["acronyme"]
2021-08-11 11:53:20 +02:00
code = values.get("valid_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
if code == "None":
code = None
2021-08-11 11:53:20 +02:00
note = values.get("note_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
try:
note = _convert_field_to_float(note)
except ValueError:
return False, "note invalide" + pu
2021-08-11 11:53:20 +02:00
coef = values.get("coef_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
try:
coef = _convert_field_to_float(coef)
except ValueError:
return False, "coefficient invalide" + pu
if code != False:
if code not in _UE_VALID_CODES:
return False, "code invalide" + pu
if code != None:
2021-08-17 14:15:15 +02:00
if note is False or note == "":
2020-09-26 16:19:37 +02:00
return False, "note manquante" + pu
if note != False and note != "":
if code == None:
return (
False,
"code jury incohérent (code %s, note %s)" % (code, note)
+ pu
+ " (supprimer note et coef)",
)
if note < 0 or note > 20:
return False, "valeur note invalide" + pu
if not isinstance(coef, float):
return False, "coefficient manquant pour note %s" % note + pu
if coef != False and coef != "":
if coef < 0:
return False, "valeur coefficient invalide" + pu
return True, "ok"
def _convert_field_to_float(val):
"""value may be empty, False, or a float. Raise exception"""
if val != False:
val = val.strip()
if val:
val = float(val)
return val
def _list_ue_with_coef_and_validations(sem, etudid):
2020-09-26 16:19:37 +02:00
"""Liste des UE de la même formation que sem,
avec leurs coefs d'UE capitalisée (si déjà saisi)
et leur validation pour cet étudiant.
"""
2021-06-15 13:59:56 +02:00
cnx = ndb.GetDBConnexion()
2020-09-26 16:19:37 +02:00
formsemestre_id = sem["formsemestre_id"]
ues = sco_edit_ue.ue_list({"formation_id": sem["formation_id"]})
for ue in ues:
2020-09-26 16:19:37 +02:00
# add coefficient
uecoef = sco_formsemestre.formsemestre_uecoef_list(
2020-09-26 16:19:37 +02:00
cnx, args={"formsemestre_id": formsemestre_id, "ue_id": ue["ue_id"]}
)
if uecoef:
ue["uecoef"] = uecoef[0]
else:
ue["uecoef"] = {}
# add validation
2022-07-07 16:24:52 +02:00
validation = sco_cursus_dut.scolar_formsemestre_validation_list(
2020-09-26 16:19:37 +02:00
cnx,
args={
"formsemestre_id": formsemestre_id,
"etudid": etudid,
"ue_id": ue["ue_id"],
},
)
if validation:
ue["validation"] = validation[0]
else:
ue["validation"] = {}
return ues
2020-09-26 16:19:37 +02:00
def _record_ue_validations_and_coefs(formsemestre_id, etudid, ues, values):
for ue in ues:
2021-08-11 11:53:20 +02:00
code = values.get("valid_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
if code == "None":
code = None
2021-08-11 11:53:20 +02:00
note = values.get("note_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
note = _convert_field_to_float(note)
2021-08-11 11:53:20 +02:00
coef = values.get("coef_" + str(ue["ue_id"]), False)
2020-09-26 16:19:37 +02:00
coef = _convert_field_to_float(coef)
if coef == "" or coef == False:
coef = None
now_dmy = time.strftime("%d/%m/%Y")
log(
"_record_ue_validations_and_coefs: %s etudid=%s ue_id=%s moy_ue=%s ue_coef=%s"
% (formsemestre_id, etudid, ue["ue_id"], note, repr(coef))
)
assert code == None or (note) # si code validant, il faut une note
sco_formsemestre_validation.do_formsemestre_validate_previous_ue(
formsemestre_id,
etudid,
ue["ue_id"],
note,
now_dmy,
code=code,
ue_coefficient=coef,
)