def edit(self):
# Мне тоже больно что addres с двумя d, но исправлять больнее
# Функция редактирования
mas = dbd.buffer()
for person in mas:
d = 1
serial_n = self.serial_line.text()
number_n = self.number_line.text()
addres_n = self.addres_line.text()
phone_n = self.phone_line.text()
educ_form_n = self.Form_box.currentText()
sex_n = self.SexBox.currentText()
hostel_n = self.HostelNumber.currentText()
while d != 0:
fio_n = self.FIO_line.text()
d = dbd.try_get_fio(fio_n)
if d == 1:
self.FIO_line.clear()
break
if person[1]['Общежитие'] != '':
if person[1]['Комната'] != '' and person[1]['Комната'] != 'queue':
way=''
#way = "dormitory" + str(person[1]['Общежитие']) + "/" + "rooms" + "/" + str(
# person[1]['Комната']) + "/" + "members"
else:
way = "dormitory" + str(person[1]['Общежитие']) + "/" + "rooms" + "/" + "queue"
else:
way = "queue"
break
if d == 0:
room = 'queue'
dbd.add_student_buffer(person[0], fio_n, phone_n, serial_n + number_n, addres_n, educ_form_n, sex_n, room, hostel_n)
dbd.edit_student(person[0],way,fio_n,phone_n,serial_n + number_n,addres_n,educ_form_n,sex_n, str(hostel_n))
from success_action import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
else:
from error import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def export_to_exel(self):
hat_data = ["Название", "Стоимость"]
fac_mas = dbd.list_of_facilities()[0]
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 fac in fac_mas:
sheet.write(i, j, fac[0])
sheet.write(i, j + 1, int(fac[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()
def export_to_exel(self):
hat_data = ["ФИО", "Дата начала", "Дата конца", "Шифр"]
archive_mas = dbd.list_of_archive()
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 archive in archive_mas:
for elem in archive:
sheet.write(i, j, elem)
j += 1
i += 1
try:
os.mkdir("exports")
except:
pass
export_file.save("exports/Архив.xls")
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()
def export_to_exel(self):
hat_data = [
"ФИО", "Общежитие", "Комната", "Пол", "Адрес регистрации",
"Телефон", "Серия и номер паспорта", "Форма обучения",
"Шифр Договора", "Дата начала", "Дата конца", "Льгота", "Стоимость"
]
students_mas = dbd.list_off_all_students()
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 student in students_mas:
sheet.write(i, j, student[1]["ФИО"])
if student[1]["Общежитие"] != "":
sheet.write(i, j + 1, student[1]["Общежитие"])
else:
sheet.write(i, j + 1, "-")
if student[1]["Комната"] != "":
sheet.write(i, j + 2, student[1]["Комната"])
else:
sheet.write(i, j + 2, "-")
sheet.write(i, j + 3, student[1]["Пол"])
sheet.write(i, j + 4, student[1]["Адрес регистрации"])
sheet.write(i, j + 5, student[1]["Телефон"])
sheet.write(i, j + 6, student[1]["Паспорт"])
sheet.write(i, j + 7, student[1]["Форма обучения"])
contract_code = dbd.get_students_contract_num2(student[0])
if contract_code != "":
contract = dbd.search_contract_by_code(contract_code)
sheet.write(i, j + 8, contract[2]["Шифр"])
sheet.write(i, j + 9, contract[2]["Дата начала"])
sheet.write(i, j + 10, contract[2]["Дата конца"])
sheet.write(i, j + 11, contract[2]["Льгота"])
sheet.write(i, j + 12, int(contract[2]["Стоимость"]))
else:
sheet.write(i, j + 8, "-")
sheet.write(i, j + 9, "-")
sheet.write(i, j + 10, "-")
sheet.write(i, j + 11, "-")
sheet.write(i, j + 12, "-")
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()
def add_room(self):
room_number = self.room_number_line.text()
dorm_number = int(self.RoomHostelNumber.currentText())
capacity = int(self.RoomPlacesBox.currentText())
room_list = dbd.list_of_room_num(dorm_number)
if str(room_number) not in room_list:
dbd.add_room(dorm_number, room_number, capacity)
from success_action import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
else:
from error_add_room import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def del_facility(self):
item = self.NameBox.currentText()
fac_name = item.split(" -")[0]
n = self.NameBox.currentIndex()
# Проверяем наличие выбранной льготы
can_delete = dbd.check_facility(fac_name)
if can_delete:
dbd.remove_facility(fac_name)
from success_action import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
else:
from error_del_facility import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def edit(self):
number = self.Number_line.text()
new_address = self.Addres_line.text()
db = dbd.init_firebase()
db.child("dormitories").child("dormitory" + str(number)).update(
{"Адрес": new_address})
from success_action import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def red(self):
db = dbd.init_firebase()
room = db.child("dormitories").child("buffer_room").get()
room_number = room.val()["number"]
dorm_number = room.val()["dorm"]
status = self.RoomTipeBox.currentText()
capacity = int(self.RoomPlacesBox.currentText())
db.child("dormitories").child("dormitory"+str(dorm_number)).child("rooms").child(room_number).update({"capacity":capacity,"status":status})
from success_action import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def get_and_update(self):
cost = self.discount_line.text()
name = self.Name_line.text()
dbd.edit_facility(name, cost)
#Получаем старое имя
db = dbd.init_firebase()
data_fac = db.child("facilities").child("buffer").get()
for data in data_fac.each():
old_name = data.key()
dbd.update_facility_data(old_name, name, cost)
from success_action import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()
def export_to_exel(self):
hat_data = [
"Шифр",
"ФИО",
"Общежитие",
"Комната",
"Дата начала",
"Дата конца",
"Льгота",
"Стоимость",
]
contract_mas = dbd.list_of_contracts()
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 contract in contract_mas:
student = dbd.search_student_by_id(contract[0])
sheet.write(i, j, contract[2]["Шифр"])
sheet.write(i, j + 1, student[1]["ФИО"])
sheet.write(i, j + 2, contract[1])
sheet.write(i, j + 3, student[1]["Комната"])
sheet.write(i, j + 4, contract[2]["Дата начала"])
sheet.write(i, j + 5, contract[2]["Дата конца"])
sheet.write(i, j + 6, contract[2]["Льгота"])
sheet.write(i, j + 7, int(contract[2]["Стоимость"]))
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()
def export_to_exel(self):
hat_data = ["Общежитие", "Комната", "Жильцы"]
room_mas = dbd.list_of_all_rooms()
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 room in room_mas:
if room[1] != "queue":
sheet.write(i, j, room[0])
sheet.write(i, j + 1, int(room[1]))
if "members" in room[2]:
if len(room[2]["members"]) > 1:
k = 0
for member in room[2]["members"]:
fio = dbd.search_student_by_id(member)[1]["ФИО"]
sheet.write(i + k, j + 2, fio)
k += 1
if len(room[2]["members"]) == 1:
for member in room[2]["members"]:
fio = dbd.search_student_by_id(member)[1]["ФИО"]
sheet.write(i, j + 2, fio)
else:
sheet.write(i, j + 2, "-")
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()
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()
def edit_contract(self):
# Мне тоже больно что addres с двумя d, но исправлять больнее
# Функция редактирования
mas = dbd.buffer()
for person in mas:
d = 1
c = 1
serial_n = self.serial_line.text()
number_n = self.number_line.text()
addres_n = self.addres_line.text()
phone_n = self.phone_line.text()
educ_form_n = self.Form_box.currentText()
sex_n = self.SexBox.currentText()
hostel_n = self.HostelNumber.currentText()
с = str(hostel_n)
while c != 0:
fio_n = self.FIO_line.text()
c = dbd.try_get_fio(fio_n)
if c == 1:
self.FIO_line.clear()
break
while d != 0:
hostel = self.HostelNumber.currentText()
d = dbd.try_get_hostel(hostel)
if d == 1:
self.HostelNumber.setCurrentIndex(0)
break
if person[1]['Общежитие'] != '':
if person[1]['Комната'] != '' and person[1]['Комната'] != 'queue':
room = person[1]['Комната']
way = room
# way = "dormitory" + str(person[1]['Общежитие']) + "/" + "rooms" + "/" + str(
# person[1]['Комната']) + "/" + "members"
else:
way = "dormitory" + str(person[1]['Общежитие']) + "/" + "rooms" + "/" + "queue"
room = 'queue'
else:
way = "queue"
room = 'queue'
break
if c == 0:
if d == 0:
if sex_n == "Мужской" or sex_n == "Женский":
dbd.add_student_buffer(person[0], fio_n, phone_n, serial_n + number_n, addres_n, educ_form_n, sex_n,
room, hostel_n)
dbd.edit_student(person[0], way, fio_n, phone_n, serial_n + number_n, addres_n, educ_form_n, sex_n,
str(hostel_n))
from red_contract_2 import Ui_red_contract_2
self.window = QtWidgets.QMainWindow()
self.ui = Ui_red_contract_2()
self.ui.setupUi(self.window)
self.window.show()
else:
from error import Ui_Error
self.window = QtWidgets.QMainWindow()
self.ui = Ui_Error()
self.ui.setupUi(self.window)
self.window.show()