def retranslateUi(self, Form):
_translate = QtCore.QCoreApplication.translate
Form.setWindowTitle(_translate("Form", "Расписание занятий"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("Form", "Расписание"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_2), _translate("Form", "Найти преподавателя"))
self.pushButton.setText(_translate("Form", "NULL"))
self.pushButton_2.setText(_translate("Form", "NOT NULL"))
self.label.setText(_translate("Form", "Choice"))
self.label_2.setText(_translate("Form", "Good luck"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_3), _translate("Form", "Казино"))
self.lcdNumber.display(datetime.strftime(datetime.now(), "%H:%M"))
position_cb = 0
for Ngroup in query_in(DB_REQUEST_Ngrupp):
self.comboBox.addItem("")
self.comboBox.setItemText(position_cb, _translate("MainWindow", Ngroup[0]))
position_cb += 1
position_cb = 0
for fio in query_in(DB_REQUEST_FIO):
self.comboBox_2.addItem("")
self.comboBox_2.setItemText(position_cb, _translate("MainWindow", fio[0]))
position_cb += 1
def combo_activated(self, text):
day_of_week = ('Понедельник', 'Вторник', 'Среда', 'Четверг', 'Пятница', 'Суббота')
self.textEdit.clear()
for chosen_day in day_of_week:
self.textEdit.append('\t')
self.textEdit.append('<font size="5"><u>' + chosen_day + '</u></font>')
try:
query = query_in(DB_REQUEST_INS3.format(str(text), chosen_day))
if query:
for cortege in query:
if cortege[4] == 1:
self.textEdit.append(
'<font size="4"><span style="color: red;">' + str(cortege[0]) +
'</span>' + ' - ' + cortege[1] + ' ' + ' - ' + cortege[2] +'</font>')
if cortege[4] == 2:
self.textEdit.append(
'<font size="4"><span style="color: blue;">' + str(cortege[0]) +
'</span>' + ' - ' + cortege[1] + ' ' + ' - ' + cortege[2] + '</font>')
if cortege[4] == 0:
self.textEdit.append(
'<font size="4"><span style="color: black;">' + str(cortege[0]) +
'</span>' + ' - ' + cortege[1] + ' ' + ' - ' + cortege[2] + '</font>')
else:
self.textEdit.append("\nВыходной")
except:
self.textEdit.append("Error")
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 retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "УЧИТЕЛЪ"))
self.pushButton.setText(_translate("MainWindow", "Заменить"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab), _translate("MainWindow", "Занятия"))
self.pushButton_2.setText(_translate("MainWindow", "Оповестить"))
self.tabWidget.setTabText(self.tabWidget.indexOf(self.tab_2), _translate("MainWindow", "Оповещение"))
position_cb = 0
self.comboBox_9.addItem("")
self.comboBox_9.setItemText(position_cb, _translate("MainWindow", '-'))
for fio in query_in(DB_REQUEST_IN):
self.comboBox.addItem("")
self.comboBox.setItemText(position_cb, _translate("MainWindow", fio[0]))
self.comboBox_9.addItem("")
self.comboBox_9.setItemText(position_cb+1, _translate("MainWindow", fio[0]))
position_cb += 1
position_cb = 0
for chosen_day in DAY_OF_WEEK:
self.comboBox_2.addItem("")
self.comboBox_2.setItemText(position_cb, _translate("MainWindow", chosen_day))
self.comboBox_6.addItem("")
self.comboBox_6.setItemText(position_cb, _translate("MainWindow", chosen_day))
position_cb += 1
position_cb = 0
for x in range(1,9):
self.comboBox_3.addItem("")
self.comboBox_3.setItemText(position_cb, _translate("MainWindow", str(x)))
self.comboBox_7.addItem("")
self.comboBox_7.setItemText(position_cb, _translate("MainWindow", str(x)))
position_cb += 1
query = query_in(DB_REQUEST_IN1)
position_cb = 0
for cortege in query:
self.comboBox_4.addItem("")
self.comboBox_4.setItemText(position_cb, _translate("MainWindow", cortege[0]))
self.comboBox_8.addItem("")
self.comboBox_8.setItemText(position_cb, _translate("MainWindow", cortege[0]))
position_cb += 1
query = query_in(DB_REQUEST_IN2)
position_cb = 0
for cortege in query:
self.comboBox_5.addItem("")
self.comboBox_5.setItemText(position_cb, _translate("MainWindow", cortege[0]))
position_cb += 1
self.comboBox_10.addItem("")
self.comboBox_10.setItemText(0, _translate("MainWindow", "Верх"))
self.comboBox_11.addItem("")
self.comboBox_11.setItemText(0, _translate("MainWindow", "Верх"))
self.comboBox_10.addItem("")
self.comboBox_10.setItemText(1, _translate("MainWindow", "Низ"))
self.comboBox_11.addItem("")
self.comboBox_11.setItemText(1, _translate("MainWindow", "Низ"))
self.comboBox_10.addItem("")
self.comboBox_10.setItemText(2, _translate("MainWindow", "-"))
self.comboBox_11.addItem("")
self.comboBox_11.setItemText(2, _translate("MainWindow", "-"))
def viv(self, cortage):
self.query = query_in(DB_QUERY_ZAMENA)
for i in range(0, 5):
try:
if self.query[cortage + i][4] == 1:
day_cb1 = 'Верх'
if self.query[cortage + i][4] == 2:
day_cb1 = 'Низ'
if self.query[cortage + i][4] == 0:
day_cb1 = ''
if self.query[cortage + i][8] == 1:
day_cb2 = 'Верх'
if self.query[cortage + i][8] == 2:
day_cb2 = 'Низ'
if self.query[cortage + i][8] == 0:
day_cb2 = ''
if i == 0:
self.textEdit.setText(
SET_TEXT_TE.format(self.query[cortage + i][0],
self.query[cortage + i][1],
self.query[cortage + i][2],
str(self.query[cortage + i][3]),
day_cb1, self.query[cortage + i][5],
self.query[cortage + i][6],
str(self.query[cortage + i][7]),
day_cb2,
self.query[cortage + i][9]))
if i == 1:
self.textEdit_2.setText(
SET_TEXT_TE.format(self.query[cortage + i][0],
self.query[cortage + i][1],
self.query[cortage + i][2],
str(self.query[cortage + i][3]),
day_cb1, self.query[cortage + i][5],
self.query[cortage + i][6],
str(self.query[cortage + i][7]),
day_cb2,
self.query[cortage + i][9]))
if i == 2:
self.textEdit_3.setText(
SET_TEXT_TE.format(self.query[cortage + i][0],
self.query[cortage + i][1],
self.query[cortage + i][2],
str(self.query[cortage + i][3]),
day_cb1, self.query[cortage + i][5],
self.query[cortage + i][6],
str(self.query[cortage + i][7]),
day_cb2,
self.query[cortage + i][9]))
if i == 3:
self.textEdit_4.setText(
SET_TEXT_TE.format(self.query[cortage + i][0],
self.query[cortage + i][1],
self.query[cortage + i][2],
str(self.query[cortage + i][3]),
day_cb1, self.query[cortage + i][5],
self.query[cortage + i][6],
str(self.query[cortage + i][7]),
day_cb2,
self.query[cortage + i][9]))
if i == 4:
self.textEdit_5.setText(
SET_TEXT_TE.format(self.query[cortage + i][0],
self.query[cortage + i][1],
self.query[cortage + i][2],
str(self.query[cortage + i][3]),
day_cb1, self.query[cortage + i][5],
self.query[cortage + i][6],
str(self.query[cortage + i][7]),
day_cb2,
self.query[cortage + i][9]))
except:
pass
def viv2(self):
query = query_in(DB_QUERY_REST)
for i in range(0, len(query)):
self.textEdit_6.append(query[i][0] + "\t" + str(query[i][1]) +
"\t" + str(query[i][2]) + "\t" +
query[i][3])
