def modCourLive(idP, pers, salles=None, typeCour=None, jour=None, semaineMin=None, semaineMax=None, hmin=None, hmax=None):
"""
Modify an lesson
:param idP: id of the lesson
:type idP: int
:param pers: the user who wants to modify the object
:type pers: Personne
:param salles: the lesson classroom(s)
:type salles: List of Salle
:param typeCour: which type of lesson
:type typeCour: typeCour
:param jour: Day of the lesson
:type jour: list of Tuple
:param semaineMin: first week of the lesson
:type semaineMin: int
:param semaineMax: last week of the lesson
:type semaineMax: int
:param hmin: first hour of the lesson
:type hmin: int
:param hmax: last hour of the lesson
:type hmax: int
:example:
>> from BDD.choices import MARDI
>> modCourLive(3, request.user.personne, jour=MARDI)
change the day of the lesson which id=3
"""
c = models.Cour.objects.get(id=idP)
if (typeCour != None and c.typeCour.id != typeCour.id) or (salles != None and c.salles != salles) or (jour != None and jour != "" and c.jour != jour) or (semaineMin != None and semaineMin != "" and c.semaineMin != semaineMin) or (semaineMax != None and semaineMax != "" and c.semaineMax != semaineMax) or (hmin != None and hmin != "" and c.hmin != hmin) or (hmax != None and hmax != "" and c.hmax != hmax):
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = 'TypeCour'
mod.typemod = MODIFIER
mod.ipmod = c.id
mod.save()
if typeCour != None and c.typeCour.id != typeCour.id:
txt = "Vous avez modifié un cours de " + c.typeCour.nom + " en un cours de " + typeCour.nom + ". "
cm1 = models.ChampsModifie()
cm1.champs = mod
cm1.nomchamp = 'Type de cours changé depuis'
cm1.valchamp = c.typeCour
cm1.save()
c.typeCour = typeCour
else:
txt = "Vous avez modifié un cours de " + c.typeCour.nom + ". "
if salles != None and c.salles != salles:
txt = manytomany(salles, txt, c, models.Salle, "salles", "salle", "la", False)
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = 'Salles changés depuis'
cm2.valchamp = c.salles
cm2.save()
c.salles = salles
if jour != None and jour != "" and c.jour != jour:
txt = txt + "Vous avez modifié son jour de " + c.get_jour_display() + " à " + str(findchoice(int(jour), SEMAINE))
cm3 = models.ChampsModifie()
cm3.champs = mod
cm3.nomchamp = 'Jour changé depuis'
cm3.valchamp = c.jour
cm3.save()
c.jour = jour
if (semaineMin != None and semaineMin != "" and c.semaineMin != semaineMin) or (semaineMax != None and semaineMax != "" and c.semaineMax != semaineMax):
cm4 = models.ChampsModifie()
cm4.champs = mod
cm4.nomchamp = 'Semaines'
if semaineMin != None and c.semaineMin != semaineMin:
txt = txt + "Vous avez modifié sa première semaine de " + str(c.semaineMin) + " à " + str(semaineMin)
cm4.valchamp = ''
cm4.save()
c.semaineMin = semaineMin
if semaineMax != None and c.semaineMax != semaineMax:
txt = txt + "Vous avez modifié sa dernière semaine de " + str(c.semaineMax) + " à " + str(semaineMax)
cm4.valchamp = 'De la semaine '+c.semaineMin+' à la semaine '+c.semaineMax
cm4.save()
c.semaineMax = semaineMax
if (hmin != None and hmin != "" and c.hmin != hmin) or (hmax != None and hmax != "" and c.hmax != hmax):
cm4 = models.ChampsModifie()
cm4.champs = mod
cm4.nomchamp = 'Heures'
if hmin != None and c.hmin != hmin:
txt = txt + "Vous avez modifié sa première heure de " + str(c.hmin) + " à " + str(hmin)
cm4.valchamp = 'De l\H'+c.hmin+' à l\H'+c.hmax
cm4.save()
c.hmin = hmin
if hmax != None and c.hmax != hmax:
txt = txt + "Vous avez modifié sa dernière heure de " + str(c.hmax) + " à " + str(hmax)
cm4.valchamp = 'De l\H'+c.hmin+' à l\H'+c.hmax
cm4.save()
c.hmax = hmax
c.save()
n = models.News()
n.txt = txt
n.typeG = MODIFIER
n.type = CALENDRIERSTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(pers)
def modModule(idP, p, nom=None, uv=None, groupes=None):
"""
modify a module in he database
:param idP: id of the module to modify
:type idP: int
:param p: the user who wants to modify the object
:type p: Personne
:param nom: name of the module
:type nom: string
:param uv: uv of the module
:type uv: UV
:param groupes: groups related to the module
:type groupes: list of Groupe
:example:
>> uv= UV.objects.get(id=3)
>> modModule(3, request.user.personne, uv=uv)
modify a module's UV in the database
"""
c = models.Module.objects.get(id=idP)
if (nom != None and nom != "" and c.nom != nom) or (uv != None and c.theuv != uv) or (groupes != None):
txt = " Vous avez modifié le module " + c.nom
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = 'ModuleChanged : '
mod.typemod = MODIFIER
mod.ipmod = c.id
mod.save()
if nom != None and nom != "" and c.nom != nom:
txt = txt + " en " + nom + ". "
cm1 = models.ChampsModifie()
cm1.champs = mod
cm1.nomchamp = 'Nom changé depuis'
cm1.valchamp = c.nom
cm1.save()
c.nom = nom
else:
txt = txt + ". "
if uv != None and uv != "" and c.theuv != uv:
txt = txt + " Le module n\'est plus dans " + c.theuv.nom + " mais dans " + uv.nom + ". "
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = 'UV changé depuis'
cm2.valchamp = c.theuv
cm2.save()
c.theuv = uv
if groupes != None:
txt = manytomany(groupes, txt, c, models.Groupe, "groupe_set", "groupe", "au", True)
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = 'Groupes changés depuis'
a = ''
for pi in c.groupe_set.all():
a = a+str(pi)+' '
cm2.valchamp = a
cm2.save()
c.groupe_set = groupes
c.save()
n = models.News()
n.txt = txt
n.typeG = MODIFIER
n.type = SALLESTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(p)
def modPersonne(perso, idP, nom=None, prenom=None, login=None, mdp=None, sexe=None, typeP=None, adresse=None, promotion=None, dateDeNaissance=None, lieuDeNaissance=None, numeroDeTel=None, email=None, groupes=None):
"""
Modify a person in the database
:param idP: id of the person to modify
:type idP: int
:param pers: the user who wants to modify the object
:type pers: Personne
:param nom: last name of the person
:type nom: string
:param prenom: first name of the person
:type prenom: string
:param login: username of the person
:type login: string
:param mdp: password of the person
:type mdp: string
:param sexe: sex of the person
:type sexe: list of tuple
:param typeP: if the person is a student, a teacher etc...
:type typeP: list of tuple
:param adresse: the address of the person
:type adresse: string
:param promotion: year of the person promotion
:type promotion: int
:param dateDeNaissance: date of birth
:type dateDeNaissance: python date
:param lieuDeNaissance: place of birth
:type lieuDeNaissance: string
:param numeroDeTel: phone number
:type numeroDeTel: string
:param email: email of the person
:type email: Django email or string
:example:
>> from BDD.choices import HOMME_STATUT, ELEVE_STATUT
>> modPersonne(request.user.personne, sexe=HOMME_STATUT, typeP=ELEVE_STATUT)
modify a person in the database
"""
p = models.Personne.objects.filter(id=idP)[0]
su = 0
txt = "Vous avez changé la personne " + p.user.first_name + " " + p.user.last_name
txt2 = "Votre profil à été changé :"
if (prenom != None and prenom != "" and prenom != p.user.first_name) or (nom != None and nom != "" and nom != p.user.last_name):
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = 'UserChanged : '
mod.typemod = MODIFIER
mod.ipmod = p.user.id
mod.save()
cm = models.ChampsModifie()
cm.champs = mod
cm.nomchamp = 'Nom changé depuis'
if prenom != None and prenom != "" and prenom != p.user.first_name:
su = 1
cm.valchamp = p.user.first_name+' '+p.user.last_name
cm.save()
p.user.first_name = prenom
if nom != None and nom != "" and nom != p.user.last_name:
su = 1
cm.valchamp = p.user.first_name+' '+p.user.last_name
cm.save()
p.user.last_name = nom
if su == 1:
txt2 = txt2 + " vous etes maintenant : " + prenom + " " + nom + ". "
txt = txt + " en " + prenom + " " + nom
txt = txt + ". "
if groupes != None:
txt, txt2 = manytomany(groupes, txt, p, models.Groupe, "groupe_set", "groupe", "au", True, attrafiche="nom", txt2=txt2)
p.groupe_set = groupes
if login != None and login != "" and login != p.user.username:
txt = txt + " Son login a changé de " + p.user.username + " à " + login
txt2 = txt2 + " Votre login a été changé de " + p.user.username + " à " + login
p.user.username = login
if mdp != None and mdp != "" and p.user.password != login:
txt = txt + " Son mot de passe a été changé "
txt2 = txt2 + " Votre mot de passe a été changé "
p.user.password = mdp
p.filter = "{0} {1}".format(p.user.last_name, p.user.first_name)
if email != None and email != "" and p.user.email != email:
txt = txt + " Son email a changé de " + p.user.email + " à " + email
txt2 = txt2 + " Votre email a été changé de " + p.user.email + " à " + email
p.user.email = email
p.user.save()
if typeP != None and typeP != "" and int(typeP) != int(p.type):
txt = txt + " Son statut a changé de " + str(p.get_type_display()) + " à " + findchoice(typeP, TYPE) + ". "
txt2 = txt2 + " Votre statut a été changé de " + str(p.get_type_display()) + " à " + findchoice(typeP, TYPE) + ". "
if int(typeP) == 3:
p.user.is_superuser = True
else:
p.user.is_superuser = False
p.type = typeP
if sexe != None and int(sexe) != int(p.sexe):
txt = txt + " Vous avez changé son sexe de " + str(p.get_sexe_display()) + " à " + findchoice(sexe, SEXE) + ". "
txt2 = txt2 + " Vous sexe a été changé (sur le site) de " + str(p.get_sexe_display()) + " à " + findchoice(sexe, SEXE) + ". "
p.sexe = sexe
if adresse != None and adresse != "" and p.adresse != adresse:
txt = txt + " Vous avez changé son adresse de " + p.adresse + " à " + adresse + ". "
txt2 = txt2 + " Votre adresse a été changé de " + p.adresse + " à " + adresse + ". "
p.adresse = adresse
if promotion != None and promotion != "" and p.promotion != promotion:
txt = txt + " Vous avez changé sa promotion de " + str(p.promotion) + " à " + str(promotion) + ". "
txt2 = txt2 + " Votre promotion a changé de " + str(p.promotion) + " à " + str(promotion) + ". "
p.promotion = promotion
if dateDeNaissance != None and dateDeNaissance != "" and p.dateDeNaissance != dateDeNaissance:
txt = txt + " Vous avez changé sa date de naissance de " + str(p.dateDeNaissance) + " à " + str(dateDeNaissance) + ". "
txt2 = txt2 + " Votre date de naissance a été changé de " + str(p.dateDeNaissance) + " à " + str(dateDeNaissance) + ". "
p.dateDeNaissance = dateDeNaissance
if lieuDeNaissance != None and lieuDeNaissance != "" and p.lieuDeNaissance != lieuDeNaissance:
txt = txt + " Vous avez changé son lieu de naissance de " + str(p.lieuDeNaissance) + " à " + str(lieuDeNaissance) + ". "
txt2 = txt2 + " Votre lieu de naissance a été changé de " + str(p.lieuDeNaissance) + " à " + str(lieuDeNaissance) + ". "
p.lieuDeNaissance = lieuDeNaissance
if numeroDeTel != None and numeroDeTel != "" and p.numeroDeTel != numeroDeTel:
txt = txt + " Vous avez changé son numéro de " + str(p.numeroDeTel) + " à " + str(numeroDeTel) + ". "
txt2 = txt2 + " Votre numéro a changé de " + str(p.numeroDeTel) + " à " + str(numeroDeTel) + ". "
p.numeroDeTel = numeroDeTel
p.save()
if p != perso:
n = models.News()
n.txt = txt
n.typeG = MODIFIER
n.type = PERSONNESTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(perso)
n2 = models.News()
n2.txt = txt2
n2.typeG = MODIFIER
n2.type = PERSONNESTATUT
n2.uploadDate = timezone.now()
n2.save()
n2.personne.add(p)
def modCour(idP, p, nom=None, isExam=None, groupes=None, profs=None):
"""
Modify a type of lesson in the database
:param idP: id of the type of lesson to modify
:type idP: int
:param p: the user who wants to modify the object
:type p: Personne
:param nom: name of the type of lesson
:type nom: string
:param isExam: is it aan exam ?
:type isExam: boolean
:param profs: the teacher(s) of the type of lesson
:type profs: List of Personne
:param groupes: the groupe(s) in the type of lesson
:type groupes: List of groups
:example:
>> modCour(3, request.user.personne, nom="Sport")
change a type of lesson in the database
"""
c = models.TypeCour.objects.filter(id=idP)[0]
if (nom != None and nom != "" and c.nom != nom) or (isExam != None and isExam != "" and c.isExam != isExam) or (groupes != None and groupes != "" and groupes != c.groupe) or (profs != None and profs != c.profs):
txt = "Vous avez modifié le type de cours " + c.nom
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = 'CourChanged : '
mod.typemod = MODIFIER
mod.ipmod = c.id
mod.save()
if nom != None and nom != "" and c.nom != nom:
txt = txt + " en " + nom
cm1 = models.ChampsModifie()
cm1.champs = mod
cm1.nomchamp = 'nom changé depuis'
cm1.valchamp = nom
cm1.save()
c.nom = nom
txt = txt + ". "
if isExam != None and c.isExam != isExam:
if c.isExam:
txt = txt + "Ce n\'est plus un exam. "
else:
txt = txt + "C\'est maintenant un exam. "
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = 'isExam changé depuis'
cm2.valchamp = c.isExam
cm2.save()
c.isExam = isExam
if groupes != None and c.groupe != groupes:
txt = manytomany(groupes, txt, c, models.Groupe, "groupe", "groupe", "au", False)
cm3 = models.ChampsModifie()
cm3.champs = mod
cm3.nomchamp = 'groupes changés depuis'
cm3.valchamp = c.groupe
cm3.save()
c.groupe = groupes
if profs != None and c.profs != profs:
txt = manytomany(profs, txt, c, models.Personne, "profs", "prof", "le", False)
cm4 = models.ChampsModifie()
cm4.champs = mod
cm4.nomchamp = 'profs changés depuis'
cm4.valchamp = c.profs
cm4.save()
c.profs = profs
c.save()
n = models.News()
n.txt = txt
n.typeG = MODIFIER
n.type = SALLESTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(p)
def modGroupe(idP, p, nom=None, personnes=None, modules=None):
"""
modify a group in the database
:param idP: id of the group to modify
:type idP: int
:param p: the user who wants to modify the group
:type p: Personne
:param nom: name of the group
:type nom: string
:param personnes: persons in the group
:type personnes: list of Personne
:param modules: which module the group is marked
:type modules: list of Module
:examples:
>> modGroupe(3, request.user.personne, nom="MP")
change the name of the group which id = 3
>> m = Module.objects.filter(id=1) # it must be a list that is why it is a filter and not a get
>> modGroupe(3, request.user.personne, modules=m)
change the group in the database whit new modules
"""
c = models.Groupe.objects.get(id=idP)
if nom != c.nom or (personnes != c.personnes and personnes != None) or (modules != None and c.modules != modules):
txt = "Vous avez modifié le groupe " + c.nom
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = 'GroupeChanged : '
mod.typemod = MODIFIER
mod.ipmod = c.id
mod.save()
if nom != None and nom != "" and c.nom != nom:
txt = txt + " à " +nom + " "
cm1 = models.ChampsModifie()
cm1.champs = mod
cm1.nomchamp = 'nom changé depuis'
cm1.valchamp = c.nom
cm1.save()
c.nom = nom
else:
txt = txt + ". "
if modules != None and modules != "" and c.modules != modules:
txt = manytomany(modules, txt, c, models.Module, "modules", "module", "le", False, attrafiche="nom")
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = 'Module(s) changé(s) depuis'
a = ''
for p in c.modules.all():
a = a+str(p)+' '
cm2.valchamp = a
cm2.save()
c.modules = modules
if personnes != None and personnes != "" and c.personnes != personnes:
txt = manytomany(personnes, txt, c, models.Personne, "personnes", "personne", "la", False, STATUT=GROUPESTATUT)
cm3 = models.ChampsModifie()
cm3.champs = mod
cm3.nomchamp = 'Membre(s) changé(s) depuis'
b = ''
for p in c.personnes.all():
b = b+str(p)+' '
cm3.valchamp = b
cm3.save()
c.personnes = personnes
c.save()
n = models.News()
n.txt = txt
n.typeG = MODIFIER
n.type = GROUPESTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(p)
def addCour(pers, nom, isExam=False, profs=None):
"""
Add a type of lesson in the database
:param pers: the user who wants to add the object
:type pers: Personne
:param nom: name of the type of lesson
:type nom: string
:param isExam: is it aan exam ?
:type isExam: boolean
:param profs: the teacher(s) of the type of lesson
:type profs: List of Personne
:exemples:
>> addCour(request.user.personne, "Connaissance de soi")
save a type of lesson in the database
>> addCour(request.user.personne, "Surprise !", True)
save exam in the database
"""
if models.TypeCour.objects.filter(nom__iexact=nom).count() > 0:
return "Name already taken"
if isExam == None:
isExam = False
txt = "Vous avez ajouté le type de cours " + nom
if isExam:
txt = txt + " qui est un exam"
txt = txt + ". "
c = models.TypeCour()
c.nom = nom
c.isExam = isExam
c.save()
if profs != None:
txt = manytomany(profs, txt, c, models.Personne, "profs", "prof", "le", False)
c.profs = profs
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = "Cour"
mod.typemod = AJOUT
mod.ipmod = c.id
mod.save()
cm1 = models.ChampsModifie()
cm1.champs = mod
cm1.nomchamp = "Nom"
cm1.valchamp = nom
cm1.save()
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = "C'est un Exam ?"
if isExam:
cm2.valchamp = "oui"
else:
cm2.valchamp = "non"
cm2.save()
cm3 = models.ChampsModifie()
cm3.champs = mod
cm3.nomchamp = "Date d'upload"
cm3.valchamp = c.uploadDate
cm3.save()
cm4 = models.ChampsModifie()
cm4.champs = mod
cm4.nomchamp = "Profs"
a = ""
for s in c.profs.all():
a = a + str(s)
cm4.valchamp = a
cm4.save()
cm5 = models.ChampsModifie()
cm5.champs = mod
cm5.nomchamp = "Groupes"
g = ""
for t in c.groupe.all():
g = g + str(t)
cm5.valchamp = g
cm5.save()
n = models.News()
n.txt = txt
n.typeG = AJOUT
n.type = COURTYPESTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(pers)
return c
def addGroupe(pers, nomm, personnes=None, modules=None):
"""
Add a group in the database
:param pers: the user who wants to add the object
:type pers: Personne
:param nomm: name of the group
:type nomm: string
:param personnes: persons in the group
:type personnes: list of Personne
:param modules: which module the group is marked
:type modules: list of Module
:exemples:
>> addGroupe(request.user.personne, "MP")
save a group in the database
>> m = Module.objects.filter(id=1) # it must be a list that is why it is a filter and not a get
>> addGroupe(request.user.personne, "MP", modules=m)
save a group in the database whit modules
"""
if models.Groupe.objects.filter(nom=nomm).count() > 0:
return "Name already taken"
txt = "Vous avez ajouté le groupe " + nomm + ". "
c = models.Groupe()
c.nom = nomm
c.uploadDate = timezone.now()
c.save()
if modules != None:
txt = manytomany(modules, txt, c, models.Module, "modules", "module", "au", False, attrafiche="nom")
c.modules = modules
if personnes != None:
txt = manytomany(
personnes, txt, c, models.Personne, "personnes", "personne", "à la", False, STATUT=GROUPESTATUT
)
c.personnes = personnes
mod = models.Modification()
mod.datemodif = timezone.now()
mod.typetable = "Groupe"
mod.typemod = AJOUT
mod.ipmod = c.id
mod.save()
cm1 = models.ChampsModifie()
cm1.champs = mod
cm1.nomchamp = "nom"
cm1.valchamp = nomm
cm1.save()
cm2 = models.ChampsModifie()
cm2.champs = mod
cm2.nomchamp = "Date d'upload"
cm2.valchamp = c.uploadDate
cm2.save()
if personnes != None:
cm3 = models.ChampsModifie()
cm3.champs = mod
cm3.nomchamp = "Personnes du groupe "
a = ""
for p in c.personnes.all():
a = a + str(p) + " "
cm3.valchamp = a
cm3.save()
if modules != None:
cm4 = models.ChampsModifie()
cm4.champs = mod
cm4.nomchamp = "Modules du groupe "
m = ""
for p in c.modules.all():
m = m + str(p) + " "
cm4.valchamp = m
cm4.save()
n = models.News()
n.txt = txt
n.typeG = AJOUT
n.type = GROUPESTATUT
n.uploadDate = timezone.now()
n.save()
n.personne.add(pers)
return c.id