def set_floor_combobox_data_change_search(building_combobox, floor_combobox, type_of_floor, database):
building_object = building_combobox.currentData()
if building_object:
building_id = building_object.pk
floor_combobox.clear()
if type_of_floor:
query_select_floor = '''
select f.id, f.name as 'floor', b.name as 'building' ,t.name as 'type_of_floor',
f.number_of_apartment as 'number_of_apartment' from floor as f
join building as b on f.building = b.id
join type_of_floor as t on f.type_of_floor = t.id
where b.id = {} and t.id = {}
'''
data_floor = get_list_model(database, my_model.Floor, query_select_floor.format(building_id, type_of_floor))
else:
query_select_floor = '''
select f.id, f.name as 'floor', b.name as 'building' ,t.name as 'type_of_floor',
f.number_of_apartment as 'number_of_apartment' from floor as f
join building as b on f.building = b.id
join type_of_floor as t on f.type_of_floor = t.id
where b.id = {}
'''
data_floor = get_list_model(database, my_model.Floor, query_select_floor.format(building_id))
for floor in data_floor:
floor_object = my_model.Floor(*floor)
floor_name = 'Tầng ' + str(floor[1])+' Tòa Nhà ' + floor[2]
floor_combobox.addItem(floor_name, floor_object)
else:
floor_combobox.clear()
floor_combobox.addItem('')
def resident_manage_staff_tab_data_change_floor_combobox(self):
building_object = self.comboBox_company_staff_building.currentData()
if building_object:
building_id = building_object.pk
self.comboBox_company_staff_floor.clear()
cursor = self.database.cursor()
query_select_floor = '''
select f.id, f.name as 'floor', b.name as 'building' ,t.name as 'type_of_floor', f.number_of_apartment as 'number_of_apartment' from floor as f
join building as b on f.building = b.id
join type_of_floor as t on f.type_of_floor = t.id
where b.id = %s and t.id = 1
'''
cursor.execute(query_select_floor, (building_id, ))
data_floor = cursor.fetchall()
for floor in data_floor:
floor_object = my_model.Floor(floor[0], floor[1], floor[2],
floor[3], floor[4])
floor_name = 'Tầng ' + str(floor[1]) + ' Tòa Nhà ' + floor[2]
self.comboBox_company_staff_floor.addItem(floor_name, floor_object)