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()