Esempio n. 1
0
class show_hours_dialog(QtGui.QDialog):
    def __init__(self, teacher_name):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Show_hours()
        self.ui.setupUi(self)
        self.teacher_name = teacher_name

        Term_query = QSqlQuery()
        Term_query.exec_(
            "select Current_term from System where System_id = '1'")
        Term_query.next()
        self.ui.cur_term = Term_query.value(0)

        Hours_query = QSqlQuery()
        Hours_query.exec_(
            "select sum(TIME_TO_SEC(TIMEDIFF(C.Class_end_time, C.Class_time))) from Teacher as T, Teacher_Class as TC, Class as C\
                           where T.Teacher_id = TC.Teacher_id and TC.Class_id = C.Class_id and T.Teacher_name = '%s'\
                           and TC.Class_semester_taught = '%s'" %
            (teacher_name, self.ui.cur_term))
        Hours_query.next()
        hours = 0.0
        if not isinstance(Hours_query.value(0), QtCore.QPyNullVariant):
            hours = int(Hours_query.value(0)) / 3600

        other_hours = 0.0
        other_hours_query = QSqlQuery()
        other_hours_query.exec_(
            "select Teacher_hours from Teacher where Teacher_name = '%s'" %
            teacher_name)
        other_hours_query.next()

        if not isinstance(other_hours_query.value(0), QtCore.QPyNullVariant):
            other_hours = other_hours_query.value(0)
        self.ui.course_lineEdit.setText(str(hours))
        self.ui.course_lineEdit.setDisabled(True)
        self.ui.other_lineEdit.setText(str(other_hours))
        self.ui.update_btn.clicked.connect(self.update_hours)
        self.ui.cancel_btn.clicked.connect(self.close)

    def update_hours(self):
        update_hours = QSqlQuery()
        if update_hours.exec_(
                "update Teacher set Teacher_hours = '%s' where\
                            Teacher_name = '%s'" %
            (self.ui.other_lineEdit.text(), self.teacher_name)):
            QtGui.QMessageBox.information(self, 'success', 'Success!')
        else:
            QtGui.QMessageBox.information(self, 'fail',
                                          'Please enter a number!')
    def __init__(self, teacher_name):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Show_hours()
        self.ui.setupUi(self)
        self.teacher_name = teacher_name

        Term_query = QSqlQuery()
        Term_query.exec_("select Current_term from System where System_id = '1'")
        Term_query.next()
        self.ui.cur_term = Term_query.value(0)

        Hours_query = QSqlQuery()
        Hours_query.exec_(
            "select sum(TIME_TO_SEC(TIMEDIFF(C.Class_end_time, C.Class_time))) from Teacher as T, Teacher_Class as TC, Class as C\
                           where T.Teacher_id = TC.Teacher_id and TC.Class_id = C.Class_id and T.Teacher_name = '%s'\
                           and TC.Class_semester_taught = '%s'"
            % (teacher_name, self.ui.cur_term)
        )
        Hours_query.next()
        hours = 0.0
        if not isinstance(Hours_query.value(0), QtCore.QPyNullVariant):
            hours = int(Hours_query.value(0)) / 3600

        other_hours = 0.0
        other_hours_query = QSqlQuery()
        other_hours_query.exec_("select Teacher_hours from Teacher where Teacher_name = '%s'" % teacher_name)
        other_hours_query.next()

        if not isinstance(other_hours_query.value(0), QtCore.QPyNullVariant):
            other_hours = other_hours_query.value(0)
        self.ui.course_lineEdit.setText(str(hours))
        self.ui.course_lineEdit.setDisabled(True)
        self.ui.other_lineEdit.setText(str(other_hours))
        self.ui.update_btn.clicked.connect(self.update_hours)
        self.ui.cancel_btn.clicked.connect(self.close)
    def __init__(self, teacher_name):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Show_hours()
        self.ui.setupUi(self)
        self.teacher_name = teacher_name
        
        self.hours_dict = {}
        pay_query = QSqlQuery()
        pay_query.exec_("select Payname, Hours, Payrate from Teacher_Payrate as TP, Payrate as P where \
                             TP.Payrate_id = P.Payrate_id and TP.Teacher_id = \
                             (select Teacher_id from Teacher where Teacher_name = '%s')" % teacher_name)

        sum = 0.0
        while pay_query.next():
            self.ui.Hour_comboBox.addItem(pay_query.value(0))
            self.hours_dict[pay_query.value(0)] = float(pay_query.value(1))
            sum += (pay_query.value(1) * pay_query.value(2))

        if self.ui.Hour_comboBox.currentText() != '':
            self.ui.other_lineEdit.setText(str(self.hours_dict[str(self.ui.Hour_comboBox.currentText())]))  


        Term_query = QSqlQuery()
        Term_query.exec_("select Current_term from System where System_id = '1'")
        Term_query.next()
        self.ui.cur_term = Term_query.value(0)

        Hours_query = QSqlQuery()
        Hours_query.exec_("select sum(TIME_TO_SEC(TIMEDIFF(C.Class_end_time, C.Class_time))) from Teacher as T, Teacher_Class as TC, Class as C\
                           where T.Teacher_id = TC.Teacher_id and TC.Class_id = C.Class_id and T.Teacher_name = '%s'\
                           and TC.Class_semester_taught = '%s'" % (teacher_name, self.ui.cur_term))
        Hours_query.next()
        hours = 0.0
        if not isinstance(Hours_query.value(0), QtCore.QPyNullVariant):
            hours = int(Hours_query.value(0)) / 3600

        self.ui.course_lineEdit.setText(str(hours))
        self.ui.course_lineEdit.setDisabled(True)
        self.ui.Wage_lineEdit.setDisabled(True)
        self.ui.Wage_lineEdit.setText(str(sum))
        self.ui.update_btn.clicked.connect(self.update_hours)
        self.ui.cancel_btn.clicked.connect(self.close)

        self.ui.Hour_comboBox.currentIndexChanged.connect(self.update_text)
    def __init__(self, teacher_name):
        QtGui.QDialog.__init__(self)
        self.ui = Ui_Show_hours()
        self.ui.setupUi(self)
        self.teacher_name = teacher_name

        self.hours_dict = {}
        pay_query = QSqlQuery()
        pay_query.exec_(
            "select Payname, Hours, Payrate from Teacher_Payrate as TP, Payrate as P where \
                             TP.Payrate_id = P.Payrate_id and TP.Teacher_id = \
                             (select Teacher_id from Teacher where Teacher_name = '%s')"
            % teacher_name
        )

        sum = 0.0
        while pay_query.next():
            self.ui.Hour_comboBox.addItem(pay_query.value(0))
            self.hours_dict[pay_query.value(0)] = float(pay_query.value(1))
            sum += pay_query.value(1) * pay_query.value(2)

        if self.ui.Hour_comboBox.currentText() != "":
            self.ui.other_lineEdit.setText(str(self.hours_dict[str(self.ui.Hour_comboBox.currentText())]))

        Term_query = QSqlQuery()
        Term_query.exec_("select Current_term from System where System_id = '1'")
        Term_query.next()
        self.ui.cur_term = Term_query.value(0)

        Hours_query = QSqlQuery()
        Hours_query.exec_(
            "select sum(TIME_TO_SEC(TIMEDIFF(C.Class_end_time, C.Class_time))) from Teacher as T, Teacher_Class as TC, Class as C\
                           where T.Teacher_id = TC.Teacher_id and TC.Class_id = C.Class_id and T.Teacher_name = '%s'\
                           and TC.Class_semester_taught = '%s'"
            % (teacher_name, self.ui.cur_term)
        )
        Hours_query.next()
        hours = 0.0
        if not isinstance(Hours_query.value(0), QtCore.QPyNullVariant):
            hours = int(Hours_query.value(0)) / 3600

        self.ui.course_lineEdit.setText(str(hours))
        self.ui.course_lineEdit.setDisabled(True)
        self.ui.Wage_lineEdit.setDisabled(True)
        self.ui.Wage_lineEdit.setText(str(sum))
        self.ui.update_btn.clicked.connect(self.update_hours)
        self.ui.cancel_btn.clicked.connect(self.close)

        self.ui.Hour_comboBox.currentIndexChanged.connect(self.update_text)