def form_display_byclasse(self):
window = WindowCustom(self.master)
entrys = {"Classe": None}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Classe")
optionClasse.pack(side=LEFT)
container.pack()
container = Frame(window)
listeEleve = SqliteService.getInstance().selectByQueryEntity(
"SELECT a.prenomApprenant || ' ' || a.nomApprenant FROM APPRENANT AS a INNER JOIN CLASSE AS c ON a.idClasse = c.idClasse WHERE c.libelleClasse = '{0}'"
.format(entrys["Classe"].get()))
listeEleve = ToolsBox.convert_rowlist_tostringlist(listeEleve)
scrollbar = Scrollbar(window)
scrollbar.pack(side=RIGHT, fill=Y)
listEleveView = Listbox(window, yscrollcommand=scrollbar.set)
for eleve in listeEleve:
listEleveView.insert(END, eleve)
listEleveView.pack(side=LEFT, fill=BOTH)
scrollbar.config(command=listEleveView.yview)
container.pack(fill=BOTH)
optionClasse.v.trace(
"w",
partial(ClasseForm.refreshClasse,
entrys=entrys,
listbox=listEleveView))
def form_associate_matiere(self):
window = WindowCustom(self.master)
entrys = {"Enseignant": None, "Matiere": None}
Label(
window,
text=
"(Sélectionner dans le liste, l'enseignant puis la matiere, puis validez)"
).pack(side=TOP)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT prenomEnseignant || ' ' || nomEnseignant AS fullname FROM ENSEIGNANT"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionEnseignant = OptionMenuCustom(container, listeOptions, entrys,
"Enseignant")
container.pack()
container = Frame(window)
listeMatiere = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleMatiere FROM MATIERE")
listeMatiere = ToolsBox.convert_rowlist_tostringlist(listeMatiere)
optionMatiere = OptionMenuCustom(container, listeMatiere, entrys,
"Matiere")
container.pack()
btn = Button(window,
text="Valider",
command=partial(
self.controller.associateEnseignantMatiere,
entrys)).pack(side=BOTTOM)
def form_update_cours(self):
window = WindowCustom(self.master)
entrys = {
"Jour/Heure/Matiere": None,
"Jour": None,
"Heure": None,
"Classe": None,
"Enseignant": None,
"Matiere": None
}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT crs.idCours ||' '|| crs.jourCours ||' '|| crs.heureCours ||' '|| m.libelleMatiere AS jourHeureMatiere FROM COURS AS crs INNER JOIN MATIERE AS m ON crs.k_idMatiere = m.idMatiere"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Jour/Heure/Matiere")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Classe")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT prenomEnseignant || ' ' || nomEnseignant AS fullname FROM ENSEIGNANT"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionEnseignant = OptionMenuCustom(container, listeOptions, entrys,
"Enseignant")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleMatiere FROM MATIERE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionMatiere = OptionMenuCustom(container, listeOptions, entrys,
"Matiere")
container.pack(fill=BOTH)
optionEnseignant.v.trace(
"w",
partial(CoursForm.refreshMatiere,
entrys=entrys,
optionMatiere=optionMatiere))
btn = Button(window,
text="Valider",
command=partial(self.controller.updateCours,
entrys)).pack(side=BOTTOM)
def from_associate_eleve(self):
window = WindowCustom(self.master)
entrys = {"Eleves": None, "NewClasse": None}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT prenomApprenant || ' ' || nomApprenant AS fullname FROM APPRENANT ORDER BY nomApprenant"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Eleves")
optionClasse.pack(side=RIGHT)
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"NewClasse")
optionClasse.pack(side=RIGHT)
container.pack(fill=BOTH)
btn = Button(window,
text="Valider",
command=partial(self.controller.associateEleveWithClasse,
entrys)).pack(side=BOTTOM)
def form_delete_eleve(self):
window = WindowCustom(self.master)
entrys = {"Eleves": None, "Classe": None}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Classe")
optionClasse.pack(side=RIGHT)
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT a.prenomApprenant || ' ' || a.nomApprenant AS fullname FROM APPRENANT AS a INNER JOIN CLASSE AS cls ON a.idClasse = cls.idClasse WHERE cls.libelleClasse = '{0}'"
.format(entrys["Classe"].get()))
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionEleves = OptionMenuCustom(container, listeOptions, entrys,
"Eleves")
optionEleves.pack(side=RIGHT)
container.pack(fill=BOTH)
optionClasse.v.trace(
"w",
partial(EleveForm.refreshEleve,
entrys=entrys,
optionEleves=optionEleves))
btn = Button(window,
text="Valider",
command=partial(self.controller.deleteEleve,
entrys)).pack(side=BOTTOM)
def form_add_eleve(self):
window = WindowCustom(self.master)
entrys = {"Nom": None, "Prenom": None, "Classe": None}
container = Frame(window)
EntryCustom(container, entrys, "Nom")
container.pack(fill=BOTH)
container = Frame(window)
EntryCustom(container, entrys, "Prenom")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Classe").pack()
container.pack(fill=BOTH)
btn = Button(window,
text="Valider",
command=partial(self.controller.addEleve,
entrys)).pack(side=BOTTOM)
def form_delete_enseignant(self):
window = WindowCustom(self.master)
entrys = {"Enseignant": None}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT prenomEnseignant || ' ' || nomEnseignant AS fullname FROM ENSEIGNANT"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionEnseignant = OptionMenuCustom(container, listeOptions, entrys,
"Enseignant")
container.pack()
btn = Button(window,
text="Valider",
command=partial(self.controller.deleteEnseignant,
entrys)).pack(side=BOTTOM)
def form_delete_cours(self):
window = WindowCustom(self.master)
entrys = {"Jour/Heure/Matiere": None}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT crs.idCours ||' '|| crs.jourCours ||' '|| crs.heureCours ||' '|| m.libelleMatiere AS jourHeureMatiere FROM COURS AS crs INNER JOIN MATIERE AS m ON crs.k_idMatiere = m.idMatiere"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Jour/Heure/Matiere")
container.pack(fill=BOTH)
btn = Button(window,
text="Valider",
command=partial(self.controller.deleteCours,
entrys)).pack(side=BOTTOM)
def form_delete_matiere(self):
window = WindowCustom(self.master)
entrys = {
"Matiere": None,
}
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleMatiere FROM MATIERE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
OptionMenuCustom(container, listeOptions, entrys, "Matiere")
container.pack(fill=BOTH)
btn = Button(window,
text="Valider",
command=partial(self.controller.deleteMatiere,
entrys)).pack(side=BOTTOM)
containerTOP = Frame(root, width=width, height=height / 5)
containerTOP.pack(side=TOP, fill=BOTH)
# Emplacement du calendrier
edt = AffichageEmploiDuTemps(root, width, height)
edt.currentdate = datetime.now().date()
edt.pack(side=TOP, fill=BOTH)
entrys = {"Classe": None}
container = Frame(containerTOP)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys, "Classe")
container.pack(side=LEFT, fill=BOTH)
Label(containerTOP,
text="Veuillez saisir une date pour afficher l'EDT : ").pack(side=LEFT)
container = Frame(containerTOP)
Label(container, text="Jour").pack(side=LEFT)
sb = Spinbox(container, from_=1, to=31, width=7, state="readonly")
sb.pack(side=LEFT)
entrys["Jour"] = sb
container.pack(side=LEFT, fill=BOTH)
container = Frame(containerTOP)
Label(container, text="Mois").pack(side=LEFT)
sb = Spinbox(container, from_=1, to=12, width=7, state="readonly")
def form_add_cours(self):
window = WindowCustom(self.master)
entrys = {
"Jour": None,
"Mois": None,
"Annee": None,
"Heure": None,
"Classe": None,
"Enseignant": None,
"Matiere": None
}
container = Frame(window)
Label(container, text="Jour").pack(side=LEFT)
sb = Spinbox(container, from_=1, to=31, width=10, state="readonly")
sb.pack(side=RIGHT)
entrys["Jour"] = sb
container.pack(fill=BOTH)
container = Frame(window)
Label(container, text="Mois").pack(side=LEFT)
sb = Spinbox(container, from_=1, to=12, width=10, state="readonly")
sb.pack(side=RIGHT)
entrys["Mois"] = sb
container.pack(fill=BOTH)
container = Frame(window)
Label(container, text="Année").pack(side=LEFT)
sb = Spinbox(container,
from_=2019,
to=2022,
width=10,
state="readonly")
sb.pack(side=RIGHT)
entrys["Annee"] = sb
container.pack(fill=BOTH)
container = Frame(window)
listOptions = ['AM', 'PM']
OptionMenuCustom(container, listOptions, entrys, "Heure")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleClasse FROM CLASSE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionClasse = OptionMenuCustom(container, listeOptions, entrys,
"Classe")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT prenomEnseignant || ' ' || nomEnseignant AS fullname FROM ENSEIGNANT"
)
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionEnseignant = OptionMenuCustom(container, listeOptions, entrys,
"Enseignant")
container.pack(fill=BOTH)
container = Frame(window)
listeOptions = SqliteService.getInstance().selectByQueryEntity(
"SELECT libelleMatiere FROM MATIERE")
listeOptions = ToolsBox.convert_rowlist_tostringlist(listeOptions)
optionMatiere = OptionMenuCustom(container, listeOptions, entrys,
"Matiere")
container.pack(fill=BOTH)
optionEnseignant.v.trace(
"w",
partial(CoursForm.refreshMatiere,
entrys=entrys,
optionMatiere=optionMatiere))
btn = Button(window,
text="Valider",
command=partial(self.controller.addCours,
entrys)).pack(side=BOTTOM)