def database_visits(self): self.Visits.show() self.Main.hide() self.Edit_doctors.hide() self.Edit_discount.hide() self.Edit_patients.hide() self.Edit_medicines.hide() self.Edit_discount.hide() self.Patients.hide() self.Doctors.hide() self.Medicines.hide() self.Discount.hide() self.Visits.show() self.pushButton_vis_show.clicked.connect(self.load_visits) self.pushButton_vis_add.clicked.connect(self.add_visits) # self.pushButton_vis_edit.clicked.connect(self.edit_discount) # self.pushButton_vis_del.clicked.connect(self.delete_discount) # self.pushButton_vis_search.clicked.connect(self.search_discount) # self.pushButton_vis_menu.clicked.connect(self.creation) self.tableWidget_visits.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_vis()): self.tableWidget_visits.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_visits.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) self.tableWidget.setRowCount(0) for row_number, row_data in enumerate(Database_module.read_vis_pat()): self.tableWidget.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) self.tableWidget_2.setRowCount(0) for row_number, row_data in enumerate(Database_module.read_vis_doc()): self.tableWidget_2.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_2.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) self.tableWidget_3.setRowCount(0) for row_number, row_data in enumerate(Database_module.read_vis_dis()): self.tableWidget_3.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_3.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def database_discount(self): self.Main.hide() self.Edit_doctors.hide() self.Edit_patients.hide() self.Edit_medicines.hide() self.Patients.hide() self.Doctors.hide() self.Medicines.hide() self.Discount.show() self.pushButton_dis_show.clicked.connect(self.load_discount) self.pushButton_dis_add.clicked.connect(self.add_discount) self.pushButton_dis_edit.clicked.connect(self.edit_discount) self.pushButton_dis_del.clicked.connect(self.delete_discount) self.pushButton_dis_search.clicked.connect(self.search_discount) self.pushButton_dis_menu.clicked.connect(self.creation) self.pushButton_27.clicked.connect(self.sort_id_discount) self.pushButton_28.clicked.connect(self.sort_id_alpha) self.pushButton_30.clicked.connect(self.sort_interest1_dis) self.pushButton_29.clicked.connect(self.sort_interest2_dis) self.pushButton_31.clicked.connect(self.database_patients) self.pushButton_32.clicked.connect(self.database_doctors) self.pushButton_33.clicked.connect(self.database_visits) self.pushButton_34.clicked.connect(self.database_medicines) self.tableWidget_discount.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_dis()): self.tableWidget_discount.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_discount.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def database_patients(self): self.Main.hide() self.Edit_doctors.hide() self.Doctors.hide() self.Edit_patients.hide() self.Patients.show() self.Edit_discount.hide() self.Medicines.hide() self.Discount.hide() self.Edit_medicines.hide() self.pushButton_pat_show.clicked.connect(self.load_patients) self.pushButton_pat_add.clicked.connect(self.add_patients) self.pushButton_pat_edit.clicked.connect(self.edit_patients) self.pushButton_pat_del.clicked.connect(self.delete_patients) self.pushButton_pat_search.clicked.connect(self.search_patients) self.pushButton_pat_menu.clicked.connect(self.creation) self.pushButton.clicked.connect(self.sort_alpha_patients) self.pushButton_2.clicked.connect(self.sort_id_patients) self.pushButton_3.clicked.connect(self.sort_date_patients) self.pushButton_4.clicked.connect(self.sort_date2_patients) self.pushButton_5.clicked.connect(self.sort_sex1_patients) self.pushButton_6.clicked.connect(self.sort_sex2_patients) self.pushButton_7.clicked.connect(self.database_doctors) self.pushButton_8.clicked.connect(self.database_medicines) self.pushButton_9.clicked.connect(self.database_visits) self.pushButton_10.clicked.connect(self.database_discount) self.tableWidget_patients.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_pat()): self.tableWidget_patients.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_patients.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def database_doctors(self): self.Main.hide() self.Edit_doctors.hide() self.Edit_patients.hide() self.Edit_medicines.hide() self.Patients.hide() self.Doctors.show() self.Medicines.hide() self.Edit_discount.hide() self.Discount.hide() self.pushButton_doc_show.clicked.connect(self.load_doctors) self.pushButton_doc_add.clicked.connect(self.add_doctors) self.pushButton_doc_edit.clicked.connect(self.edit_doctors) self.pushButton_doc_del.clicked.connect(self.delete_doctors) self.pushButton_doc_search.clicked.connect(self.search_doctors) self.pushButton_doc_menu.clicked.connect(self.creation) self.pushButton_15.clicked.connect(self.database_patients) self.pushButton_16.clicked.connect(self.database_medicines) self.pushButton_17.clicked.connect(self.database_visits) self.pushButton_18.clicked.connect(self.database_discount) self.pushButton_11.clicked.connect(self.sort_alpha_doctors) self.pushButton_12.clicked.connect(self.sort_id_doctors) self.pushButton_13.clicked.connect(self.sort_cab_doctors) self.pushButton_14.clicked.connect(self.sort_spec_doctors) self.tableWidget_docotors.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_doc()): self.tableWidget_docotors.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_docotors.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def sort_id_alpha(self): self.tableWidget_discount.setRowCount(0) for row_number, row_data in enumerate(Database_module.sort_id_alpha()): self.tableWidget_discount.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_discount.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def sort_spec_doctors(self): self.tableWidget_docotors.setRowCount(0) for row_number, row_data in enumerate(Database_module.sort_id_spec()): self.tableWidget_docotors.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_docotors.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def sort_sex2_patients(self): self.tableWidget_patients.setRowCount(0) for row_number, row_data in enumerate(Database_module.sort_sex2_pat()): self.tableWidget_patients.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_patients.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def load_visits(self): self.tableWidget_6.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_vis()): self.tableWidget_6.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_6.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def load_patients(self): self.lineEdit_7.clear() self.tableWidget_patients.setRowCount(0) for row_number, row_data in enumerate( Database_module.read_from_db_pat()): self.tableWidget_patients.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_patients.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
def add_visits(self): self.Main.hide() self.Visits.hide() self.Patients.hide() self.Medicines.hide() self.Doctors.hide() self.Discount.hide() self.Edit_medicines.hide() self.Edit_discount.hide() self.Edit_doctors.hide() self.Edit_visits.show() self.lineEdit_5.hide() self.label_37.hide() self.pushButton_37.hide() self.pushButton_35.clicked.connect(self.add_visits2) self.pushButton_36.clicked.connect(self.database_visits) self.tableWidget_4.setRowCount(0) for row_number, row_data in enumerate(Database_module.read_vis_pat()): self.tableWidget_4.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_4.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) self.tableWidget_5.setRowCount(0) for row_number, row_data in enumerate(Database_module.read_vis_doc()): self.tableWidget_5.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_5.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) self.tableWidget_6.setRowCount(0) for row_number, row_data in enumerate(Database_module.read_vis_dis()): self.tableWidget_6.insertRow(row_number) for column_number, data in enumerate(row_data): self.tableWidget_6.setItem( row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))