def data_split(self):
data = DB.get_data()
self.headers = data[0]
del data[0]
for line in data:
if line[10] == None:
self.geen_mail.append(line)
elif '@' and '.' not in line[10]:
self.geen_mail.append(line)
elif line[6] == 'Niet gepland':
self.niet_gepland.append(line)
elif line[5] == 'privé':
self.wel_gepland_prv.append(line)
else :
self.wel_gepland.append(line)
def init_table(self):
self.setGeometry(530, 350, 1300, 800)
self.data_list = DB.get_data()
self.table = QtWidgets.QTableWidget(self)
self.table.setRowCount(len(self.data_list))
self.table.setColumnCount(len(self.data_list[0]))
hor_headers = window.Trans_Reader.headers
self.table.setHorizontalHeaderLabels(hor_headers)
self.data_to_table()
self.table.resizeColumnsToContents()
self.table.resizeRowsToContents()
grid_box = QtWidgets.QVBoxLayout()
grid_box.addWidget(self.table, 100)
self.setLayout(grid_box)