def btn4_clk(self): file_name = QFileDialog.getOpenFileName() try: fd = pd.read_excel(file_name[0], sheet_name=0) for i in fd.index: if fd['Верх/низ/-'][i] == "Верх": ND = 1 if fd['Верх/низ/-'][i] == "Низ": ND = 2 if fd['Верх/низ/-'][i] == "-": ND = 0 try: query_ins( DB_QUERY_INS_ZANYATIE.format(fd['День недели'][i], fd['Номер пары'][i], fd['Аудитория'][i], fd['Преподаватель'][i], fd['Название дисципл'][i], ND)) except: pass try: query_ins( DB_QUERY_INS_GROUPZAN.format(fd['Группа'][i], fd['День недели'][i], fd['Номер пары'][i], fd['Аудитория'][i], ND)) except: pass except: pass
def btn_clk(self): cortege = [] if self.comboBox_10.currentText() == '-': dayoftheweek_cb10 = 0 if self.comboBox_10.currentText() == 'Верх': dayoftheweek_cb10 = 1 if self.comboBox_10.currentText() == 'Низ': dayoftheweek_cb10 = 2 if self.comboBox_11.currentText() == '-': dayoftheweek_cb11 = 0 if self.comboBox_11.currentText() == 'Верх': dayoftheweek_cb11 = 1 if self.comboBox_11.currentText() == 'Низ': dayoftheweek_cb11 = 2 cortege.append(self.comboBox.currentText()) cortege.append(self.comboBox_5.currentText()) cortege.append(self.comboBox_2.currentText()) cortege.append(self.comboBox_3.currentText()) cortege.append(self.comboBox_4.currentText()) cortege.append(self.comboBox_6.currentText()) cortege.append(self.comboBox_7.currentText()) cortege.append(self.comboBox_8.currentText()) query = query_in(DB_REQUEST_SEl1.format(cortege[5], int(cortege[6]), dayoftheweek_cb11, cortege[7])) if query: query_ins(DB_REQUEST_INS1.format(cortege[0], cortege[1], cortege[2], int(cortege[3]), dayoftheweek_cb10, cortege[4], cortege[5], int(cortege[6]), dayoftheweek_cb11, cortege[7])) self.dialog.show() else: self.dialog_err.show()
def btn3_clk(self): self.msg = '' for i in range(0, 5): if self.log[i]: query_ins( DB_QUERY_UPD_ZANYATIE.format( self.query[self.page + i][6], int(self.query[self.page + i][7]), self.query[self.page + i][9], int(self.query[self.page + i][8]), self.query[self.page + i][2], int(self.query[self.page + i][3]), self.query[self.page + i][5], int(self.query[self.page + i][4]))) query_ins( DB_QUERY_DEL_ZAMENA.format(self.query[self.page + i][0], self.query[self.page + i][1], self.query[self.page + i][2], self.query[self.page + i][3], self.query[self.page + i][4], self.query[self.page + i][5], self.query[self.page + i][6], self.query[self.page + i][7], self.query[self.page + i][8], self.query[self.page + i][9])) self.msg = SET_TEXT_TE.format( self.query[self.page + i][0], self.query[self.page + i][1], self.query[self.page + i][2], self.query[self.page + i][3], self.query[self.page + i][4], self.query[self.page + i][5], self.query[self.page + i][6], self.query[self.page + i][7], self.query[self.page + i][8], self.query[self.page + i][9]) self.query_fio = query_in( DB_QUERY_FIO_PREP.format(self.query[self.page + i][0])) subject = "Перенос пары" body_text = "совершен перенос пары {}.".format(self.msg) body_text2 = "Ув. {},".format(self.query[self.page + i][0]) txt = body_text2 + body_text send_email(subject, txt, self.query_fio[0][0]) self.checkBox.setCheckState(False) self.checkBox_2.setCheckState(False) self.checkBox_3.setCheckState(False) self.checkBox_4.setCheckState(False) self.checkBox_5.setCheckState(False) self.log = [False, False, False, False, False] self.textEdit.clear() self.textEdit_2.clear() self.textEdit_3.clear() self.textEdit_4.clear() self.textEdit_5.clear() self.page = 0 self.viv(0)
def btn6_clk(self): self.X1 = query_in(DB_QUERY_REST) for i in range(0, len(self.X1)): self.query = query_in(DB_QUERY_FIO.format(self.X1[i][0])) subject = "ОПОВЕЩЕНИЕ отсутсвие преподавателя {}".format( self.X1[i][0]) if self.X1[i][3] == "": body_text = "Преподаватель {} будет отутсвовать с {} по {}".format( self.X1[i][0], str(self.X1[i][1]), str(self.X1[i][2])) if self.X1[i][3] != "": body_text = "Преподаватель {} будет отутсвовать с {} по {}. Его будет заменять преподаватель {}".format( self.X1[i][0], str(self.X1[i][1]), str(self.X1[i][2]), self.X1[i][3]) for ii in range(0, len(self.query)): body_text2 = "Ув. {},".format(self.query[ii][0]) txt = body_text2 + body_text send_email(subject, txt, self.query[ii][1]) query_ins(DB_QUERY_DEL_REST) self.textEdit_6.clear()
def btn7_clk(self): query_ins(DB_QUERY_DEL_ZANYATIE) query_ins(DB_QUERY_DEL_GROUPZAN)
def btn2_clk(self): date1 = self.calendarWidget.selectedDate() date2 = self.calendarWidget_2.selectedDate() query_ins(DB_REQUEST_INS2.format(self.comboBox.currentText(), date1.toString(Qt.ISODate), date2.toString(Qt.ISODate), self.comboBox_9.currentText()))