def __init__(self, ID): QtGui.QDialog.__init__(self) self.ui = Ui_Class_list_Dialog() self.ui.setupUi(self) self.id = ID class_query = QSqlQuery() #class current register class_query.exec_( "SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_model = QSqlQueryModel() self.class_model.setQuery(class_query) self.ui.Class_drop_tableView.setModel(self.class_model) #class available class_query.exec_( "SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id not in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_drop_model = QSqlQueryModel() self.class_drop_model.setQuery(class_query) self.ui.Class_add_tableView.setModel(self.class_drop_model) self.ui.Add_btn.clicked.connect(self.add) self.ui.Drop_btn.clicked.connect(self.drop) self.ui.Class_add_tableView.setSelectionBehavior( QAbstractItemView.SelectRows) self.ui.Class_drop_tableView.setSelectionBehavior( QAbstractItemView.SelectRows)
def __init__(self, ID): QtGui.QDialog.__init__(self) self.ui = Ui_Class_list_Dialog() self.ui.setupUi(self) self.id = ID class_query = QSqlQuery() #class current register class_query.exec_("SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_model = QSqlQueryModel() self.class_model.setQuery(class_query) self.ui.Class_drop_tableView.setModel(self.class_model) #class available class_query.exec_("SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id not in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_drop_model = QSqlQueryModel() self.class_drop_model.setQuery(class_query) self.ui.Class_add_tableView.setModel(self.class_drop_model) self.ui.Add_btn.clicked.connect(self.add) self.ui.Drop_btn.clicked.connect(self.drop) self.ui.Class_add_tableView.setSelectionBehavior(QAbstractItemView.SelectRows) self.ui.Class_drop_tableView.setSelectionBehavior(QAbstractItemView.SelectRows)
class Class_list_dialog(QtGui.QDialog): def __init__(self, ID): QtGui.QDialog.__init__(self) self.ui = Ui_Class_list_Dialog() self.ui.setupUi(self) self.id = ID class_query = QSqlQuery() class_query.exec_( "SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_model = QSqlQueryModel() self.class_model.setQuery(class_query) self.ui.Class_drop_tableView.setModel(self.class_model) class_query.exec_( "SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id not in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_drop_model = QSqlQueryModel() self.class_drop_model.setQuery(class_query) self.ui.Class_add_tableView.setModel(self.class_drop_model) self.ui.Add_btn.clicked.connect(self.add) self.ui.Drop_btn.clicked.connect(self.drop) self.ui.Class_add_tableView.setSelectionBehavior( QAbstractItemView.SelectRows) self.ui.Class_drop_tableView.setSelectionBehavior( QAbstractItemView.SelectRows) def add(self): data_list = [ i.data() for i in self.ui.Class_add_tableView.selectedIndexes() if isinstance(i.data(), int) ] class_add = QSqlQuery() for i in data_list: class_add.exec_( "INSERT into Student_Class values(%d, %d, 0, 0, CURDATE(), \ (SELECT Current_term FROM System WHERE System_id = 1))" % (self.id, i)) self.refresh() def drop(self): data_list = [ i.data() for i in self.ui.Class_drop_tableView.selectedIndexes() if isinstance(i.data(), int) ] class_drop = QSqlQuery() for i in data_list: class_drop.exec_( "delete from Student_Class where Student_id = %d and Class_id = %d and \ Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1)" % (self.id, i)) self.refresh() def refresh(self): class_query = QSqlQuery() class_query.exec_( "SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % self.id) self.class_model.setQuery(class_query) class_query.exec_( "SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id not in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % self.id) self.class_drop_model.setQuery(class_query)
class Class_list_dialog(QtGui.QDialog): def __init__(self, ID): QtGui.QDialog.__init__(self) self.ui = Ui_Class_list_Dialog() self.ui.setupUi(self) self.id = ID class_query = QSqlQuery() class_query.exec_("SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_model = QSqlQueryModel() self.class_model.setQuery(class_query) self.ui.Class_drop_tableView.setModel(self.class_model) #class available class_query.exec_("SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id not in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % ID) self.class_drop_model = QSqlQueryModel() self.class_drop_model.setQuery(class_query) self.ui.Class_add_tableView.setModel(self.class_drop_model) self.ui.Add_btn.clicked.connect(self.add) self.ui.Drop_btn.clicked.connect(self.drop) self.ui.Class_add_tableView.setSelectionBehavior(QAbstractItemView.SelectRows) self.ui.Class_drop_tableView.setSelectionBehavior(QAbstractItemView.SelectRows) def add(self): data_list = [i.data() for i in self.ui.Class_add_tableView.selectedIndexes() if isinstance(i.data(),int)] class_add = QSqlQuery() class_check = QSqlQuery() class_time = QSqlQuery() flag = False for i in data_list: class_add.exec_("INSERT into Student_Class values(%d, %d, 0, 0, CURDATE(), \ (SELECT Current_term FROM System WHERE System_id = 1))" % (self.id, i)) self.refresh() def drop(self): data_list = [i.data() for i in self.ui.Class_drop_tableView.selectedIndexes() if isinstance(i.data(),int)] class_drop = QSqlQuery() for i in data_list: class_drop.exec_("delete from Student_Class where Student_id = %d and Class_id = %d and \ Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1)" % (self.id, i)) self.refresh() def refresh(self): class_query = QSqlQuery() class_query.exec_("SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % self.id) self.class_model.setQuery(class_query) class_query.exec_("SELECT T.Teacher_name, C.Class_id, C.Class_name, C.Class_time, C.Class_end_time, \ C.Class_location 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 TC.Class_semester_taught = (SELECT Current_term FROM System WHERE System_id = 1) and\ C.Class_id not in(SELECT C.Class_id FROM Class as C, Student_Class as SC WHERE C.Class_id = \ SC.Class_id and SC.Student_semester_taken = (SELECT Current_term FROM System WHERE System_id\ = 1) and SC.Student_id = %d) order by C.Class_id" % self.id) self.class_drop_model.setQuery(class_query)