def verify_rdv(self):
global ident
from Database import connexion
id_patient_rdv = self.id_Patient_rdv.text()
conx, cur = connexion()
try:
cur.execute("""SELECT * FROM rdv WHERE id_patient ="{}" """.format(id_patient_rdv))
print("SQL --> ok")
except Exception as e:
print("error: ",e)
print("SQL --> fail")
res= cur.fetchall()
if len(res)!=0:
ident= res[0][1]
print("ident =",ident)
self.open_liste_rdv()
else:
print("ident =",ident)
msg = QMessageBox()
msg.setWindowTitle("Echec")
msg.setText("Vous n'avez pas de RDV")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
print("ident=",ident)
conx.close()
def login_handler(self):
from Database import connexion
pseudo = self.username_log.text()
pwd = self.password.text()
conx, cur = connexion()
try:
cur.execute("""SELECT * FROM connexion""")
except Exception as e:
print(e)
rows = cur.fetchall()
for row in rows:
if pseudo == row[1] and pwd == row[2]:
print("connected")
msg = QMessageBox()
msg.setWindowTitle("Succes")
msg.setText("Vous êtes connecté")
msg.exec_()
self.open_acc()
else:
print("not connected")
msg = QMessageBox()
msg.setWindowTitle("Alert")
msg.setText("Pseudo ou Password incorrect veuiller recommencer")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
def verify_handler(self):
global identify
from Database import connexion
id_patient = self.id_Patient.text()
conx, cur = connexion()
try:
cur.execute(
"""SELECT * FROM patient WHERE id_patient ="{}" """.format(
id_patient))
print("SQL --> ok")
except Exception as e:
print("error: ", e)
print("SQL --> fail")
res = cur.fetchall()
if len(res) != 0:
identify = res[0][0]
print("id =", identify)
self.open_ficheMed()
else:
print("id =", identify)
msg = QMessageBox()
msg.setWindowTitle("Echec")
msg.setText("Vous n'êtes pas inscrit")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
def update_info(self):
from accueil import iden
nom = self.nomClient.text()
prenom = self.prenomClient.text()
sexe = self.sexe.currentText()
# dateNaiss = self.date.date().toPyDate()
profession = self.prof.text()
tel = self.cont.text()
email = self.mail.text()
assurance = self.sexe_3.currentText()
id_patient = iden
# id_patient = "DA454"
element = (nom, prenom, sexe, profession, tel, email, assurance,
id_patient)
conx, cur = connexion()
try:
cur.execute(
"""UPDATE patient SET nom= ?, prenom= ?, sexe= ?, profession= ?, tel= ?, email= ?, assurance= ? WHERE id_patient=?""",
element)
print("SQL MODIFICATION TABLE patient--> ok")
conx.commit()
msg = QMessageBox()
msg.setWindowTitle("Succes")
msg.setText("Modification Effectuée avec success")
msg.exec_()
except Exception as e:
print("SQL MODIFICATION TABLE patient--> fail")
print('Error : ', e)
msg = QMessageBox()
msg.setWindowTitle("Echec")
msg.setText("Echec de connexion")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
conx.close()
def select_info(self):
"""Pour recuperer les info depuis la base de donnée"""
from accueil import iden
print("id_p dans modif =", iden)
test = iden
# test = "DA454"
conx, cur = connexion()
try:
cur.execute(
"""SELECT nom,prenom,sexe,dateNaiss,cni,profession,tel,email,assurance FROM patient WHERE id_patient = "{}" """
.format(test))
print("SQL SELECTION TABLE patient --> ok")
except Exception as e:
print("ERREUR SELECTION TABLE patient : ", e)
res = cur.fetchall()
conx.close()
if len(res) != 0:
info = list()
for data in res:
info.append(data)
return info
else:
msg = QMessageBox()
msg.setWindowTitle("Alert")
msg.setText("Le patient n'existe pas dans la base de donnée!!!")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
def loadData(self):
from Database import connexion
conx, cur = connexion()
try:
cur.execute("""SELECT * FROM patient""")
print("SQL -->ok")
except Exception as e:
print("error here:",e)
res = cur.fetchall()
print("len = ",len(res))
for row_number, row_data in enumerate(res):
self.tableWidget.setRowCount((row_number+1))
for column_number, data in enumerate(row_data):
self.tableWidget.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
conx.close()
def delete_info(self):
from Database import connexion
num = self.line_Edit_Supprimer.text()
conx, cur = connexion()
try:
cur.execute(
"""SELECT * FROM patient WHERE id_patient="{}" """.format(num))
except Exception as e:
print("ERREUR SELECTION TABLE patient: ", e)
res = cur.fetchall()
if (len(res) != 0):
msgBox = QMessageBox()
msgBox.setIcon(QMessageBox.Information)
msgBox.setWindowTitle("Alert")
msgBox.setText(
"Voulez vous vraiment supprimer le patient N° {}".format(num))
msgBox.setStandardButtons(QMessageBox.Yes | QMessageBox.No)
returnValue = msgBox.exec_()
if returnValue == QMessageBox.Yes:
try:
cur.execute(
"""DELETE FROM patient WHERE id_patient="{}" """.
format(num))
cur.execute(
"""DELETE FROM rdv WHERE id_patient="{}" """.format(
num))
conx.commit()
print("SQL SUPPRESSION TABLE patient --> ok")
msg = QMessageBox()
msg.setWindowTitle("Info")
msg.setText("Effacé avec success!!!")
msg.exec_()
conx.close()
except Exception as e:
print("ERREUR SUPPRESSION TABLE patient: ", e)
conx.close()
else:
msg = QMessageBox()
msg.setWindowTitle("Alert")
msg.setText("Le patient n'existe pas dans la base de donnée!!!")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
def loadData(self):
from saisie_Id_rdv import ident
from Database import connexion
conx, cur = connexion()
try:
cur.execute(
"""SELECT * FROM rdv where id_patient="{}" """.format(ident))
print("SQL -->ok")
except Exception as e:
print("error here:", e)
res = cur.fetchall()
print("len = ", len(res))
for row_number, row_data in enumerate(res):
self.liste_rdv_2.setRowCount((row_number + 1))
for column_number, data in enumerate(row_data):
self.liste_rdv_2.setItem(row_number, column_number,
QtWidgets.QTableWidgetItem(str(data)))
conx.close()
def insert_ordonnance(self):
from Database import connexion
from saisie_Id import identify
from ficheMed import Ui_FicheMed, d, nm #d represente la date ne pas effacer
nom_med = nm
conx, cur = connexion()
try:
cur.execute(
"""SELECT id_med FROM medecin WHERE nom="{}" """.format(
nom_med)) #On recupère l'id du medecin
except Exception as e:
print("error select id_med :", e)
res = cur.fetchall()
print("len = ", len(res))
id_med = res[0][0]
medicaments = self.text_ordonnace.toPlainText()
element = (medicaments, d[0], id_med, identify)
try:
cur.execute(
"""INSERT INTO ordonnance(medicaments,date,id_med,id_patient) VALUES(?,?,?,?)""",
element)
print("SQL INSERTION TABLE ordonance --> ok")
conx.commit()
msg = QMessageBox()
msg.setWindowTitle("Succes")
msg.setText("Enregistrement effectué avec succes")
msg.exec_()
except Exception as e:
print('Error in ordonance : ', e)
print('SQL --> fail')
msg = QMessageBox()
msg.setWindowTitle("Echec")
msg.setText("Echec de connexion")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
conx.close()
def save_handler(self):
from Database import connexion
nom = self.nomClient.text()
prenom = self.prenomClient.text()
sexe = self.sexe.currentText()
dateNaiss = self.date.date().toPyDate()
cni = self.cni_Client.text()
profession = self.prof.text()
tel = self.cont.text()
email = self.mail.text()
assurance = self.sexe_3.currentText()
id_patient = "STP20-{}20".format(cni)
element = (id_patient,nom,prenom,sexe,dateNaiss,cni,profession,tel,email,assurance)
conx, cur = connexion()
if(cni ==""):
msg = QMessageBox()
msg.setWindowTitle("Echec")
msg.setText("Veuiller Remplir le champ cni svp")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
else:
try:
cur.execute("""INSERT INTO patient(id_patient,nom,prenom,sexe,dateNaiss,cni,profession,tel,email,assurance) VALUES(?,?,?,?,?,?,?,?,?,?)""",element)
print("SQL INSERTION TABLE patient --> ok")
conx.commit()
msg = QMessageBox()
msg.setWindowTitle("Succes")
msg.setText("Enregistrement effectué avec succes")
msg.exec_()
except Exception as e:
print('Error : ',e)
print('SQL --> fail')
msg = QMessageBox()
msg.setWindowTitle("Echec")
msg.setText("Echec de connexion")
msg.setIcon(QMessageBox.Critical)
msg.exec_()
conx.close()
