def insert(self):
all_competitors = db.get_all_competitors_experts(db.user_data[9], 0, 2)
competitor = all_competitors[self.MCompetitorComboBox.currentIndex()][0]
module = self.ModulComboBox.currentIndex() + 1
mark = self.MarkComboBox.currentIndex() + 1
data_mark = [competitor, module, mark]
db.add_marks(data_mark)
def results_click(self):
self.block_frame()
self.MainFrame.setHidden(True)
self.ResultsFrame.setHidden(False)
all_competitors = db.get_all_competitors_experts(db.user_data[9], 0, 2)
self.CompetitorComboBox.clear()
for i in range(len(all_competitors)):
self.CompetitorComboBox.addItem(str(all_competitors[i][0]) + '. ' + str(all_competitors[i][1]))
self.CompetitorComboBox.adjustSize()
def participant_expert_click(self, role):
self.block_competition_frame()
self.PeopleFrame.setHidden(False)
if role == 'participant':
data = db.get_all_competitors_experts(db.user_data[9], db.user_data[0], db.user_data[8])
else:
data = db.get_all_competitors_experts(db.user_data[9], db.user_data[0], 4)
size_str = 0
for i in range(len(data)):
data[i].pop(3)
data[i].pop(3)
if len(data) != 0:
size_str = len(data[0])
self.InfoTable.setRowCount(len(data))
self.InfoTable.setColumnCount(size_str - 2)
self.InfoTable.setHorizontalHeaderLabels(head_comp_exp)
for i in range(len(data)):
for j in range(size_str - 2):
info = QTableWidgetItem(str(data[i][j]))
info.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled)
self.InfoTable.setItem(i, j, info)
self.InfoTable.resizeColumnsToContents()
header = self.InfoTable.horizontalHeader()
header.setSectionResizeMode(QtWidgets.QHeaderView.ResizeToContents)
def search(self):
all_competitors = db.get_all_competitors_experts(db.user_data[9], 0, 2)
competitor = all_competitors[self.CompetitorComboBox.currentIndex()][0]
marks = db.show_marks(competitor)
self.ResultsWidget.setRowCount(len(marks))
self.ResultsWidget.setColumnCount(2)
self.ResultsWidget.setHorizontalHeaderLabels(head_module)
for i in range(len(marks)):
for j in range(2):
if j == 0:
info = QTableWidgetItem('Модуль ' + str(marks[i][j]))
else:
info = QTableWidgetItem(str(marks[i][j]))
info.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled)
self.ResultsWidget.setItem(i, j, info)
header = self.ResultsWidget.horizontalHeader()
header.setSectionResizeMode(QtWidgets.QHeaderView.ResizeToContents)
def enter_ratings_click(self):
self.block_frame()
self.MainFrame.setHidden(True)
self.MarksFrame.setHidden(False)
all_competitors = db.get_all_competitors_experts(db.user_data[9], 0, 2)
self.MCompetitorComboBox.clear()
self.ModulComboBox.clear()
self.MarkComboBox.clear()
for i in range(len(all_competitors)):
self.MCompetitorComboBox.addItem(str(all_competitors[i][0]) + '. ' + str(all_competitors[i][1]))
for i in range(5):
self.ModulComboBox.addItem('Модуль' + str(i + 1))
for i in range(10):
self.MarkComboBox.addItem(str(i + 1))
self.MCompetitorComboBox.adjustSize()
self.MarkComboBox.adjustSize()
self.ModulComboBox.adjustSize()
def search_click(self):
all_competence = db.get_all_competences()
competence = all_competence[self.CompetitionComboBox.currentIndex()].split('. ')
data = db.get_all_competitors_experts(competence[0], 0, 2)
size_str = 0
if len(data) != 0:
size_str = len(data[0])
self.CompetitorTable.setRowCount(len(data))
self.CompetitorTable.setColumnCount(size_str)
self.CompetitorTable.setHorizontalHeaderLabels(head_comp)
for i in range(len(data)):
for j in range(size_str):
info = QTableWidgetItem(str(data[i][j]))
info.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled)
self.CompetitorTable.setItem(i, j, info)
header = self.CompetitorTable.horizontalHeader()
header.setSectionResizeMode(QtWidgets.QHeaderView.ResizeToContents)
def managing_competitor_click(self):
self.CompetitorFrame.setHidden(False)
self.MainFrame.setHidden(True)
all_competence = db.get_all_competences()
self.CompetitionComboBox.clear()
for i in range(len(all_competence)):
self.CompetitionComboBox.addItem(all_competence[i])
self.CompetitionComboBox.adjustSize()
data = db.get_all_competitors_experts(0, 0, 2)
size_str = 0
if len(data) != 0:
size_str = len(data[0])
self.CompetitorTable.setRowCount(len(data))
self.CompetitorTable.setColumnCount(size_str)
self.CompetitorTable.setHorizontalHeaderLabels(head_comp)
for i in range(len(data)):
for j in range(size_str):
info = QTableWidgetItem(str(data[i][j]))
info.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled)
self.CompetitorTable.setItem(i, j, info)
header = self.CompetitorTable.horizontalHeader()
header.setSectionResizeMode(QtWidgets.QHeaderView.ResizeToContents)