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)