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()))