def fill_dorm_data(self): dorm_mas = dbd.list_of_dormitories() i = 0 for dorm in dorm_mas: self.HostelNumber.addItem("") self.HostelNumber.setItemText(i, f"{dorm[1]['number']}") i += 1
def fill_dorm_data(self): dorm_mas = dbd.list_of_dormitories() i = 0 for dorm in dorm_mas: if dorm[0] != 'queue' and dorm[0] != 'buffer' and dorm[ 0] != 'contract_buffer': self.HostelNumber.addItem("") self.HostelNumber.setItemText(i, f"{dorm[1]['number']}") i += 1
def fill_list(self): '''заполняет список''' mas = dbd.list_of_dormitories() i = 1 for person in mas: if 'name' in person[1]: self.hostel_info.addItem(str(i) + '. Название: ' + person[1]['name'] + '\n' \ + 'Адрес: ' + person[1]['Адрес'] + '\n') i = i + 1
def export_to_exel(self): hat_data = ["Название", "Адрес"] dorm_mas = dbd.list_of_dormitories() export_file = xlwt.Workbook() sheet = export_file.add_sheet("Общежития") i, j = 0, 0 for elem in hat_data: sheet.write(i, j, elem) j += 1 i, j = 1, 0 for dorm in dorm_mas: sheet.write(i, j, dorm[1]["name"]) sheet.write(i, j + 1, dorm[1]["Адрес"]) i += 1 try: os.mkdir("exports") except: pass export_file.save("exports/Общежития.xls") from success_action import Ui_Error self.window = QtWidgets.QMainWindow() self.ui = Ui_Error() self.ui.setupUi(self.window) self.window.show()