def get_data_search(self, table, item): if item.text() == "": item.setStyleSheet("QLineEdit{ " "border:none;" "border-radius:5;" "background-color:#af2b44;}" "QLineEdit:focus {" "border:none;" "border-radius:5;" "background-color:white;}") return item.setStyleSheet("QLineEdit{ " "border:none;" "border-radius:5;" "background-color:white;}") hospital.execute( "select date_appointment,time_appointment,Doctor_UserCode,Username,Patient_UserCode " "from appointment, user where appointment.Doctor_UserCode = user.User_Code and User_Code=%s", (item.text(), )) filters = hospital.fetchall() for i in range(table.rowCount() - 1): table.removeRow(i) print(table.rowCount()) for i in range(len(filters)): table.insertRow(i) for i in range(len(filters)): for j in range(4): text = QTableWidgetItem(str(filters[i][j])) table.setItem(i, j, text) print("successful")
def get_data_search(self, table, item): if item.text() == "": item.setStyleSheet("QLineEdit{ " "border:none;" "border-radius:5;" "background-color:#af2b44;}" "QLineEdit:focus {" "border:none;" "border-radius:5;" "background-color:white;}") return item.setStyleSheet("QLine Edit{ " "border:none;" "border-radius:5;" "background-color:white;}") hospital.execute( "select DrugName,ExpirationDate,Price from drug where ExpirationDate > %s order by ExpirationDate asc", (item.text(), )) filters = hospital.fetchall() for i in range(table.rowCount() - 1): table.removeRow(i) print(table.rowCount())
def get_data(self, table): hospital.execute("select DrugName,ExpirationDate,Price from drug") drugs = hospital.fetchall() for i in range(len(drugs)): table.insertRow(i) for i in range(len(drugs)): for j in range(3): text = QTableWidgetItem(str(drugs[i][j])) table.setItem(i, j, text) table.insertRow(table.rowCount())
def get_data(self, table): hospital.execute( "select date_appointment,time_appointment,Doctor_UserCode,Username,Patient_UserCode " "from appointment, user where appointment.Doctor_UserCode = user.User_Code" ) appointments = hospital.fetchall() for i in range(len(appointments)): table.insertRow(i) for i in range(len(appointments)): for j in range(4): text = QTableWidgetItem(str(appointments[i][j])) table.setItem(i, j, text)
def get_data(self, table): hospital.execute( "select user.User_Code,Username,Phone_Number,`E-Mail` from user," "user_role where user.User_Code = user_role.user_Code " "and user_role.role_ID = 3 and user.isVerified=0;") doctors = hospital.fetchall() for i in range(len(doctors)): table.insertRow(i) for i in range(len(doctors)): for j in range(4): print(i) text = QTableWidgetItem(str(doctors[i][j])) table.setItem(i, j, text)
def get_drugs(self, username): hospital.execute( "select drug.Drug_ID,DrugName " "from drug, has_drug, given, prescription where given.Patient_UserCode =%s " "and given.PrescriptionID = prescription.PrescriptionID " "and prescription.DrugFlag = true " "and ExamineFlag = false " "and has_drug.Drug_ID = drug.Drug_ID " "and has_drug.Prescription_ID = given.PrescriptionID", (username, )) drugs = hospital.fetchall() drug_string = "" for i in range(len(drugs)): drug_string = drug_string + str(i + 1) + ":" + drugs[i][1] + "(" + str( drugs[i][0]) + ")" + "\n" return drug_string
def get_date(self, table, username): hospital.execute( "select date_appointment,time_appointment,Patient_UserCode,Username " "from appointment, user where " "appointment.Patient_UserCode = user.User_Code and Doctor_UserCode=%s", (username, )) appointments = hospital.fetchall() for i in range(len(appointments)): table.insertRow(i) for i in range(len(appointments)): for j in range(4): if j == 2: button = QPushButton(str(appointments[i][2])) button.setStyleSheet( "QPushButton{" "background-color: rgba(255, 255, 255, 50);" "color:rgb(0,0,0)}") table.setCellWidget(i, 2, button) button.clicked.connect( lambda: self.show_patient_drog_history(appointments[i][ 2])) continue text = QTableWidgetItem(str(appointments[i][j])) table.setItem(i, j, text)