Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: utf-8 -*-
- # Form implementation generated from reading ui file 'board.ui'
- #
- # Created by: PyQt5 UI code generator 5.11.3
- #
- # WARNING! All changes made in this file will be lost!
- from PyQt5 import QtCore, QtGui, QtWidgets
- import pymysql
- from PyQt5.QtCore import QDate, QTime, QDateTime, Qt
- from deleteDialog import *
- from updateDialog import *
- class Ui_MainWindow(object):
- globalV = "vide"
- globalIdPersonne="0"
- globalIdCarte="0"
- def messageBox(self, title, message):
- mess = QtWidgets.QMessageBox()
- mess.setWindowTitle(title)
- mess.setText(message)
- mess.setStandardButtons(QtWidgets.QMessageBox.Ok)
- mess.exec_()
- def Historique(self):
- global globalV
- globalV = "vide"
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- self.tableWidget.setColumnCount(2) # Columns Number
- # Fetch data from MYSQL
- try:
- with conn.cursor() as cursor:
- sql = "SELECT * FROM Historique"
- cursor.execute(sql)
- result = cursor.fetchall()
- self.tableWidget.setRowCount(len(result)) # Set Row number of table
- x = 0
- y = 0
- self.tableWidget.setHorizontalHeaderItem(0,QtWidgets.QTableWidgetItem("Id"))
- self.tableWidget.setHorizontalHeaderItem(1, QtWidgets.QTableWidgetItem("Date d'identification"))
- for row in result:
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['id_Carte'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['date_LogIn'])))
- y = 0
- x += 1
- finally:
- conn.close()
- def Cartes(self):
- global globalV
- globalV = "Cartes"
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- self.tableWidget.setColumnCount(5) # Columns Number
- # Fetch data from MYSQL
- try:
- with conn.cursor() as cursor:
- sql = "SELECT * FROM Carte"
- cursor.execute(sql)
- result = cursor.fetchall()
- self.tableWidget.setRowCount(len(result)) # Set Row number of table
- x = 0
- y = 0
- self.tableWidget.setHorizontalHeaderItem(0, QtWidgets.QTableWidgetItem("Id"))
- self.tableWidget.setHorizontalHeaderItem(1, QtWidgets.QTableWidgetItem("Password"))
- self.tableWidget.setHorizontalHeaderItem(2, QtWidgets.QTableWidgetItem("Date d'Affectation"))
- self.tableWidget.setHorizontalHeaderItem(3, QtWidgets.QTableWidgetItem("Date d'Expiration"))
- self.tableWidget.setHorizontalHeaderItem(4, QtWidgets.QTableWidgetItem("Affecté"))
- for row in result:
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['id_Carte'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['id'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['date_Affectation'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['date_expiration'])))
- y += 1
- if int(row['affecte'])==1:
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem("oui"))
- else:
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem("non"))
- y = 0
- x += 1
- finally:
- conn.close()
- def Personnes(self):
- global globalV
- globalV = "Personnes"
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- self.tableWidget.setColumnCount(5) # Columns Number
- # Fetch data from MYSQL
- try:
- with conn.cursor() as cursor:
- sql = "SELECT * FROM Personne"
- cursor.execute(sql)
- result = cursor.fetchall()
- self.tableWidget.setRowCount(len(result)) # Set Row number of table
- x = 0
- y = 0
- self.tableWidget.setHorizontalHeaderItem(0, QtWidgets.QTableWidgetItem("Id"))
- self.tableWidget.setHorizontalHeaderItem(1, QtWidgets.QTableWidgetItem("Nom"))
- self.tableWidget.setHorizontalHeaderItem(2, QtWidgets.QTableWidgetItem("Prenom"))
- self.tableWidget.setHorizontalHeaderItem(3, QtWidgets.QTableWidgetItem("Date d'Inscription"))
- self.tableWidget.setHorizontalHeaderItem(4, QtWidgets.QTableWidgetItem("Id Carte"))
- for row in result:
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['id_Personne'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['nom'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['prenom'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['dateInscription'])))
- y += 1
- self.tableWidget.setItem(x, y, QtWidgets.QTableWidgetItem(str(row['id_Carte'])))
- y = 0
- x += 1
- finally:
- conn.close()
- def search(self):
- item = self.lineEdit_8.text()
- print(item)
- items = self.tableWidget.findItems(item, QtCore.Qt.MatchContains)
- brush = QtGui.QBrush(QtGui.QColor("orange"))
- brush.setStyle(QtCore.Qt.SolidPattern)
- for item in items:
- item.setForeground(brush)
- def ajouter_Personne(self):
- nom = self.lineEdit.text()
- prenom = self.lineEdit_2.text()
- dateInscription = self.dateEdit.text()
- id_Carte = self.lineEdit_7.text()
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursorObject = conn.cursor()
- sqlQuery = "select max(id_Personne) as nombre from Personne "
- cursorObject.execute(sqlQuery)
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- nombre = nombre+1
- dateSplited=dateInscription.split("/")
- dateInscription=dateSplited[2]+"-"+dateSplited[1]+"-"+dateSplited[0]
- sqlQuery0 = "select affecte from Carte where id_Carte=%s"
- sqlQuery1 = "insert into Personne values(%s,%s,%s,%s,%s)"
- sqlQuery2 = "update Carte set affecte=1 where id_Carte=%s"
- if len(nom)==0 or len(prenom)==0 or len(id_Carte)==0:
- self.messageBox("error","informations manquants")
- else:
- cursorObject.execute(sqlQuery0, id_Carte)
- rows = cursorObject.fetchall()
- for row in rows:
- affecte = row["affecte"]
- if affecte == 0:
- try:
- cursorObject.execute(sqlQuery1, (nombre, nom, prenom, dateInscription, id_Carte))
- try:
- cursorObject.execute(sqlQuery2, id_Carte)
- self.messageBox("congrats", "Personne ajouté avec succes")
- self.lineEdit.setText("")
- self.lineEdit_2.setText("")
- self.lineEdit_7.setText("")
- except:
- self.messageBox("error", "Carte error")
- self.lineEdit_7.setText("")
- except:
- self.messageBox("error", "informations erronés")
- self.lineEdit.setText("")
- self.lineEdit_2.setText("")
- self.lineEdit_7.setText("")
- else:
- self.messageBox("error", "Carte deja affecté")
- self.lineEdit_7.setText("")
- conn.close()
- def ajouter_Carte(self):
- id = self.lineEdit_3.text()
- dateAffectation = self.dateEdit_2.text()
- dateExpiration = self.dateEdit_3.text()
- if len(id)==0 :
- self.messageBox("error", "informations manquants")
- else:
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursorObject = conn.cursor()
- sqlQuery0="select count(id_Carte) as nombre from Carte where id=%s"
- cursorObject.execute(sqlQuery0, id)
- rows = cursorObject.fetchall()
- for row in rows:
- nombre0 = row["nombre"]
- print(nombre0)
- if nombre0>0 :
- self.messageBox("error","id deja existe")
- else:
- sqlQuery = "select max(id_Carte) as nombre from Carte "
- cursorObject.execute(sqlQuery)
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- nombre = nombre + 1
- dateSplited = dateAffectation.split("/")
- dateAffectation = dateSplited[2] + "-" + dateSplited[1] + "-" + dateSplited[0]
- dateSplited = dateExpiration.split("/")
- dateExpiration = dateSplited[2] + "-" + dateSplited[1] + "-" + dateSplited[0]
- sqlQuery1 = "insert into Carte values(%s,%s,%s,%s,0)"
- try:
- cursorObject.execute(sqlQuery1, (nombre, id, dateAffectation, dateExpiration))
- self.lineEdit_3.setText("")
- self.messageBox("congrats", "Carte ajouté avec succes")
- except:
- self.messageBox("error", "informations erronés")
- def cell_was_clicked(self):
- global globalV
- global globalIdPersonne
- global globalIdCarte
- row = self.tableWidget.currentRow()
- print(globalV)
- if globalV=="Personnes":
- globalIdPersonne=self.tableWidget.item(row,0).text()
- nom = self.tableWidget.item(row,1).text()
- prenom = self.tableWidget.item(row,2).text()
- dateInscription= self.tableWidget.item(row,3).text()
- id_Carte= self.tableWidget.item(row,4).text()
- print(globalIdPersonne, nom, prenom, dateInscription, id_Carte)
- self.lineEdit.setText(nom)
- self.lineEdit_2.setText(prenom)
- dateSplited = dateInscription.split("-")
- year=int(dateSplited[0])
- mounth=int(dateSplited[1])
- day=int(dateSplited[2])
- self.dateEdit.setDate(QtCore.QDate(year, mounth, day))
- self.lineEdit_7.setText(id_Carte)
- if globalV == "Cartes":
- globalIdCarte=self.tableWidget.item(row,0).text()
- id=self.tableWidget.item(row,1).text()
- date_Affectation=self.tableWidget.item(row,2).text()
- date_expiration=self.tableWidget.item(row,3).text()
- affecte=self.tableWidget.item(row,4).text()
- print(globalIdCarte, id, date_Affectation, date_expiration, affecte)
- self.lineEdit_3.setText(id)
- dateSplited = date_Affectation.split("-")
- year = int(dateSplited[0])
- mounth = int(dateSplited[1])
- day = int(dateSplited[2])
- self.dateEdit_2.setDate(QtCore.QDate(year, mounth, day))
- dateSplited = date_expiration.split("-")
- print(globalIdCarte, id, date_Affectation, date_expiration, affecte)
- year = int(dateSplited[0])
- mounth = int(dateSplited[1])
- day = int(dateSplited[2])
- self.dateEdit_3.setDate(QtCore.QDate(year, mounth, day))
- self.lineEdit_6.setText(str(affecte))
- def supprimerPersonne(self):
- global globalIdPersonne
- DialogDelete = QtWidgets.QDialog()
- ui = Ui_DialogDelete()
- ui.setupUi(DialogDelete)
- DialogDelete.show()
- rsp = DialogDelete.exec_()
- if rsp == QtWidgets.QDialog.Accepted:
- print("deleeeeeeeeeeeeeeeeeeeeeete")
- test= self.lineEdit.text()
- if len(test)==0 :
- self.messageBox("error", 'pas de selection pour les Personnes')
- else:
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursorObject = conn.cursor()
- sqlQuery = "select count(id_Personne) as nombre from Personne where id_Personne =%s"
- cursorObject.execute(sqlQuery, int(globalIdPersonne))
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- if nombre == 0:
- self.messageBox("error", "il n y a Personne avec cet ID")
- else:
- try:
- sqlQuery = "select id_Carte from Personne where id_Personne =%s"
- cursorObject.execute(sqlQuery, int(globalIdPersonne))
- rows = cursorObject.fetchall()
- for row in rows:
- id_Carte = row["id_Carte"]
- sqlQuery = "update Carte set affecte=0 where id_Carte=%s"
- cursorObject.execute(sqlQuery, int(id_Carte))
- sqlQuery = "delete from Personne where id_Personne =%s"
- cursorObject.execute(sqlQuery, int(globalIdPersonne))
- self.messageBox("congrats", "Personne supprimé avec succé")
- except:
- self.messageBox("error", "error")
- else:
- print("nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnon")
- def supprimerCarte(self):
- global globalIdCarte
- DialogDelete = QtWidgets.QDialog()
- ui = Ui_DialogDelete()
- ui.setupUi(DialogDelete)
- DialogDelete.show()
- rsp = DialogDelete.exec_()
- if rsp == QtWidgets.QDialog.Accepted:
- print("deleeeeeeeeeeeeeeeeeeeeeete")
- test = self.lineEdit_3.text()
- if len(test) == 0:
- self.messageBox("error", 'pas de selection pour les Cartes')
- else:
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursorObject = conn.cursor()
- sqlQuery = "select count(id_Carte) as nombre from Carte where id_Carte =%s"
- cursorObject.execute(sqlQuery, int(globalIdCarte))
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- if nombre == 0:
- self.messageBox("error", "il n y a aucune Carte avec cet ID")
- else:
- try:
- sqlQuery = "select count(id_Personne) as count from Personne where id_Carte =%s"
- cursorObject.execute(sqlQuery, int(globalIdCarte))
- rows = cursorObject.fetchall()
- for row in rows:
- count = row["count"]
- if count==0:
- print("pas de Personne affecte a cet Carte")
- else:
- sqlQuery = "select id_Personne from Personne where id_Carte =%s"
- cursorObject.execute(sqlQuery, int(globalIdCarte))
- rows = cursorObject.fetchall()
- for row in rows:
- id_Personne = row["id_Personne"]
- sqlQuery = "delete from Personne where id_Personne =%s"
- cursorObject.execute(sqlQuery, int(id_Personne))
- sqlQuery = "delete from Carte where id_Carte=%s"
- cursorObject.execute(sqlQuery, int(globalIdCarte))
- sqlQuery1 = "commit"
- cursorObject.execute(sqlQuery1)
- self.messageBox("congrats", "Carte supprimé avec succé")
- except:
- self.messageBox("error", "error")
- else:
- print("nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnon")
- def modifierPersonne(self):
- print("modifier Personne")
- nom = self.lineEdit.text()
- prenom = self.lineEdit_2.text()
- dateInscription = self.dateEdit.text()
- dateSplited = dateInscription.split("/")
- dateInscription = dateSplited[2] + "-" + dateSplited[1] + "-" + dateSplited[0]
- id_Carte = self.lineEdit_7.text()
- global globalIdPersonne
- DialogUpdate = QtWidgets.QDialog()
- ui = Ui_DialogUpdate()
- ui.setupUi(DialogUpdate)
- DialogUpdate.show()
- rsp = DialogUpdate.exec_()
- if rsp == QtWidgets.QDialog.Accepted:
- test = self.lineEdit.text()
- if len(test) == 0:
- self.messageBox("error", 'pas de selection pour les Personnes')
- else:
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursorObject = conn.cursor()
- sqlQuery = "select count(id_Personne) as nombre from Personne where id_Personne =%s"
- cursorObject.execute(sqlQuery, int(globalIdPersonne))
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- if nombre == 0:
- self.messageBox("error", "il n y a Personne avec cet ID")
- else:
- try:
- sqlQuery = "select count(id_Carte) as nombre from Carte where id_Carte =%s"
- cursorObject.execute(sqlQuery, int(id_Carte))
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- if nombre==0:
- self.messageBox('error','pas de Carte avec cette ID')
- else:
- sqlQuery = "select count(id_Personne) as nombre from Personne where id_Personne=%s and id_Carte =%s "
- cursorObject.execute(sqlQuery, (int(globalIdPersonne), int(id_Carte)))
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- if nombre == 0:
- self.messageBox('error', ' cette Carte appartient à une autre Personne')
- else:
- sqlQuery="update Personne set nom=%s , prenom=%s , dateInscription=%s ,id_Carte=%s where id_Personne=%s"
- cursorObject.execute(sqlQuery, (nom, prenom, dateInscription, id_Carte, globalIdPersonne))
- self.messageBox("congrats","Personne modifié avec succes")
- except:
- self.messageBox("error","error")
- else:
- print("nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnon")
- def modifierCarte(self):
- id = self.lineEdit_3.text()
- dateAffectation = self.dateEdit_2.text()
- dateExpiration = self.dateEdit_3.text()
- dateSplited = dateAffectation.split("/")
- dateAffectation = dateSplited[2] + "-" + dateSplited[1] + "-" + dateSplited[0]
- dateSplited = dateExpiration.split("/")
- dateExpiration = dateSplited[2] + "-" + dateSplited[1] + "-" + dateSplited[0]
- global globalIdCarte
- DialogUpdate = QtWidgets.QDialog()
- ui = Ui_DialogUpdate()
- ui.setupUi(DialogUpdate)
- DialogUpdate.show()
- rsp = DialogUpdate.exec_()
- if rsp == QtWidgets.QDialog.Accepted:
- if len(id) == 0:
- self.messageBox("error", "aucune Carte n'est selectionée")
- else:
- conn = pymysql.connect(host='localhost',
- user='root',
- password='',
- db='RFID',
- charset='utf8mb4',
- cursorclass=pymysql.cursors.DictCursor)
- cursorObject = conn.cursor()
- sqlQuery0 = "select count(id_Carte) as nombre from Carte where id_Carte=%s"
- cursorObject.execute(sqlQuery0, globalIdCarte)
- rows = cursorObject.fetchall()
- for row in rows:
- nombre = row["nombre"]
- if nombre ==0:
- self.messageBox("error", "pas de Carte avec cet ID")
- else:
- sqlQuery="update Carte set id=%s , date_Affectation=%s , date_expiration=%s where id_Carte=%s"
- cursorObject.execute(sqlQuery, (id, dateAffectation, dateExpiration, globalIdCarte))
- self.messageBox("congrats", "Carte modifier avec succes")
- else:
- print("nnnnnnnnnnnnnnnnnnnnn")
- def setupUi(self, MainWindow):
- MainWindow.setObjectName("MainWindow")
- MainWindow.resize(844, 453)
- self.centralwidget = QtWidgets.QWidget(MainWindow)
- self.centralwidget.setObjectName("centralwidget")
- self.tabWidget = QtWidgets.QTabWidget(self.centralwidget)
- self.tabWidget.setGeometry(QtCore.QRect(20, 30, 261, 321))
- self.tabWidget.setObjectName("tabWidget")
- self.tab = QtWidgets.QWidget()
- self.tab.setObjectName("tab")
- self.label = QtWidgets.QLabel(self.tab)
- self.label.setGeometry(QtCore.QRect(20, 50, 47, 13))
- self.label.setObjectName("label")
- self.label_2 = QtWidgets.QLabel(self.tab)
- self.label_2.setGeometry(QtCore.QRect(20, 100, 47, 13))
- self.label_2.setObjectName("label_2")
- self.label_3 = QtWidgets.QLabel(self.tab)
- self.label_3.setGeometry(QtCore.QRect(20, 150, 91, 21))
- self.label_3.setObjectName("label_3")
- self.lineEdit = QtWidgets.QLineEdit(self.tab)
- self.lineEdit.setGeometry(QtCore.QRect(120, 50, 113, 20))
- self.lineEdit.setObjectName("lineEdit")
- self.lineEdit_2 = QtWidgets.QLineEdit(self.tab)
- self.lineEdit_2.setGeometry(QtCore.QRect(120, 100, 113, 20))
- self.lineEdit_2.setObjectName("lineEdit_2")
- self.dateEdit = QtWidgets.QDateEdit(self.tab)
- self.dateEdit.setGeometry(QtCore.QRect(120, 150, 110, 22))
- self.dateEdit.setObjectName("dateEdit")
- self.pushButton = QtWidgets.QPushButton(self.tab)
- self.pushButton.setGeometry(QtCore.QRect(10, 250, 75, 23))
- self.pushButton.setObjectName("pushButton")
- self.pushButton.clicked.connect(self.ajouter_Personne)
- self.pushButton_2 = QtWidgets.QPushButton(self.tab)
- self.pushButton_2.setGeometry(QtCore.QRect(90, 250, 75, 23))
- self.pushButton_2.setObjectName("pushButton_2")
- self.pushButton_2.clicked.connect(self.modifierPersonne)
- self.pushButton_3 = QtWidgets.QPushButton(self.tab)
- self.pushButton_3.setGeometry(QtCore.QRect(170, 250, 75, 23))
- self.pushButton_3.setObjectName("pushButton_3")
- self.pushButton_3.clicked.connect(self.supprimerPersonne)
- self.label_8 = QtWidgets.QLabel(self.tab)
- self.label_8.setGeometry(QtCore.QRect(20, 200, 47, 13))
- self.label_8.setObjectName("label_8")
- self.lineEdit_7 = QtWidgets.QLineEdit(self.tab)
- self.lineEdit_7.setGeometry(QtCore.QRect(120, 200, 113, 20))
- self.lineEdit_7.setObjectName("lineEdit_7")
- self.tabWidget.addTab(self.tab, "")
- self.tab_2 = QtWidgets.QWidget()
- self.tab_2.setObjectName("tab_2")
- self.label_4 = QtWidgets.QLabel(self.tab_2)
- self.label_4.setGeometry(QtCore.QRect(20, 50, 47, 13))
- self.label_4.setObjectName("label_4")
- self.label_5 = QtWidgets.QLabel(self.tab_2)
- self.label_5.setGeometry(QtCore.QRect(20, 100, 91, 16))
- self.label_5.setObjectName("label_5")
- self.label_6 = QtWidgets.QLabel(self.tab_2)
- self.label_6.setGeometry(QtCore.QRect(20, 150, 81, 16))
- self.label_6.setObjectName("label_6")
- self.label_7 = QtWidgets.QLabel(self.tab_2)
- self.label_7.setGeometry(QtCore.QRect(20, 200, 47, 13))
- self.label_7.setObjectName("label_7")
- self.lineEdit_3 = QtWidgets.QLineEdit(self.tab_2)
- self.lineEdit_3.setGeometry(QtCore.QRect(130, 50, 111, 20))
- self.lineEdit_3.setObjectName("lineEdit_3")
- self.lineEdit_6 = QtWidgets.QLineEdit(self.tab_2)
- self.lineEdit_6.setGeometry(QtCore.QRect(130, 200, 113, 20))
- self.lineEdit_6.setObjectName("lineEdit_6")
- self.pushButton_4 = QtWidgets.QPushButton(self.tab_2)
- self.pushButton_4.setGeometry(QtCore.QRect(10, 250, 75, 23))
- self.pushButton_4.setObjectName("pushButton_4")
- self.pushButton_4.clicked.connect(self.ajouter_Carte)
- self.pushButton_5 = QtWidgets.QPushButton(self.tab_2)
- self.pushButton_5.setGeometry(QtCore.QRect(90, 250, 75, 23))
- self.pushButton_5.setObjectName("pushButton_5")
- self.pushButton_5.clicked.connect(self.modifierCarte)
- self.pushButton_6 = QtWidgets.QPushButton(self.tab_2)
- self.pushButton_6.setGeometry(QtCore.QRect(170, 250, 75, 23))
- self.pushButton_6.setObjectName("pushButton_6")
- self.pushButton_6.clicked.connect(self.supprimerCarte)
- self.dateEdit_2 = QtWidgets.QDateEdit(self.tab_2)
- self.dateEdit_2.setGeometry(QtCore.QRect(130, 100, 110, 22))
- self.dateEdit_2.setObjectName("dateEdit_2")
- self.dateEdit_3 = QtWidgets.QDateEdit(self.tab_2)
- self.dateEdit_3.setGeometry(QtCore.QRect(130, 150, 110, 22))
- self.dateEdit_3.setObjectName("dateEdit_3")
- self.tabWidget.addTab(self.tab_2, "")
- self.lineEdit_8 = QtWidgets.QLineEdit(self.centralwidget)
- self.lineEdit_8.setGeometry(QtCore.QRect(630, 20, 131, 20))
- self.lineEdit_8.setObjectName("lineEdit_8")
- self.pushButton_7 = QtWidgets.QPushButton(self.centralwidget)
- self.pushButton_7.setGeometry(QtCore.QRect(770, 20, 51, 23))
- self.pushButton_7.setObjectName("pushButton_7")
- self.pushButton_7.clicked.connect(self.search)
- self.tableWidget = QtWidgets.QTableWidget(self.centralwidget)
- self.tableWidget.setGeometry(QtCore.QRect(300, 50, 531, 301))
- self.tableWidget.setObjectName("tableWidget")
- self.tableWidget.cellClicked.connect(self.cell_was_clicked)
- self.tableWidget.setColumnCount(0)
- self.tableWidget.setRowCount(0)
- self.pushButton_8 = QtWidgets.QPushButton(self.centralwidget)
- self.pushButton_8.setGeometry(QtCore.QRect(750, 360, 75, 23))
- self.pushButton_8.setObjectName("pushButton_8")
- self.pushButton_8.clicked.connect(self.Historique)
- self.pushButton_9 = QtWidgets.QPushButton(self.centralwidget)
- self.pushButton_9.setGeometry(QtCore.QRect(660, 360, 75, 23))
- self.pushButton_9.setObjectName("pushButton_9")
- self.pushButton_9.clicked.connect(self.Cartes)
- self.pushButton_10 = QtWidgets.QPushButton(self.centralwidget)
- self.pushButton_10.setGeometry(QtCore.QRect(560, 360, 81, 23))
- self.pushButton_10.setObjectName("pushButton_10")
- self.pushButton_10.clicked.connect(self.Personnes)
- MainWindow.setCentralWidget(self.centralwidget)
- self.menubar = QtWidgets.QMenuBar(MainWindow)
- self.menubar.setGeometry(QtCore.QRect(0, 0, 844, 21))
- self.menubar.setObjectName("menubar")
- MainWindow.setMenuBar(self.menubar)
- self.statusbar = QtWidgets.QStatusBar(MainWindow)
- self.statusbar.setObjectName("statusbar")
- MainWindow.setStatusBar(self.statusbar)
- self.retranslateUi(MainWindow)
- self.tabWidget.setCurrentIndex(0)
- QtCore.QMetaObject.connectSlotsByName(MainWindow)
- def retranslateUi(self, MainWindow):
- _translate = QtCore.QCoreApplication.translate
- MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
- self.label.setText(_translate("MainWindow", "Nom"))
- self.label_2.setText(_translate("MainWindow", "Prenom"))
- self.label_3.setText(_translate("MainWindow", "Date d\'Inscription"))
- self.pushButton.setText(_translate("MainWindow", "ajouter"))
- self.pushButton_2.setText(_translate("MainWindow", "modifier"))
- self.pushButton_3.setText(_translate("MainWindow", "supprimer"))
- self.label_8.setText(_translate("MainWindow", "Carte"))
- self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("MainWindow", "Personne"))
- self.label_4.setText(_translate("MainWindow", "Id"))
- self.label_5.setText(_translate("MainWindow", "Date d\'Affectation"))
- self.label_6.setText(_translate("MainWindow", "Date d\'Expiration"))
- self.label_7.setText(_translate("MainWindow", "Affecté"))
- self.pushButton_4.setText(_translate("MainWindow", "ajouter"))
- self.pushButton_5.setText(_translate("MainWindow", "modifier"))
- self.pushButton_6.setText(_translate("MainWindow", "supprimer"))
- self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_2), _translate("MainWindow", "Carte"))
- self.pushButton_7.setText(_translate("MainWindow", "Srch"))
- self.pushButton_8.setText(_translate("MainWindow", "Historique"))
- self.pushButton_9.setText(_translate("MainWindow", "Les Cartes"))
- self.pushButton_10.setText(_translate("MainWindow", "Les Personnes"))
- if __name__ == "__main__":
- import sys
- app = QtWidgets.QApplication(sys.argv)
- MainWindow = QtWidgets.QMainWindow()
- ui = Ui_MainWindow()
- ui.setupUi(MainWindow)
- MainWindow.show()
- sys.exit(app.exec_())
Add Comment
Please, Sign In to add comment