def getTVTeachersModel(self, idCathedra=0): if not idCathedra: sql = "SELECT clients.id as id, clients.fio as fio, " \ "teacherinfo.dolzhnost as dolzhnost, teacherinfo.obrazovanie as obrazovanie, " \ "teacherinfo.stepen as stepen, teacherinfo.zvanie as zvanie, " \ "teacherinfo.kvalifikacia as kvalifikacia, " \ "cathedra.name as cathedra " \ "FROM (riidb.clients INNER JOIN riidb.teacherinfo " \ "ON clients.idInfo = teacherinfo.id and clients.idClientGroup=2) " \ "INNER JOIN riidb.cathedra ON cathedra.id = teacherinfo.idCath;" else: sql = "SELECT clients.id as id, clients.fio as fio, " \ "teacherinfo.dolzhnost as dolzhnost, teacherinfo.obrazovanie as obrazovanie, " \ "teacherinfo.stepen as stepen, teacherinfo.zvanie as zvanie, " \ "teacherinfo.kvalifikacia as kvalifikacia, " \ "cathedra.name as cathedra " \ "FROM (riidb.clients INNER JOIN riidb.teacherinfo " \ "ON clients.idInfo = teacherinfo.id and clients.idClientGroup=2 ) " \ "INNER JOIN riidb.cathedra ON cathedra.id = teacherinfo.idCath " \ "AND teacherinfo.idCath = '%s';" % idCathedra nameList = ['id', 'fio', 'dolzhnost', 'obrazovanie', 'stepen', 'zvanie', 'kvalifikacia', 'cathedra'] asList = ['id', 'ФИО', 'Должность', 'Образование', "Степень", "Звание", "Квалификация", "Кафедра"] model = DataBaseModule.CreateTableViewModel(sql, nameList, asList, nameDB='riidb') return model
def GetTableViewModel(self): """model = QStandardItemModel() model.setHorizontalHeaderLabels(['id','Заголовок контекста', 'id Родителя', 'Группы пользователей']) model.setVerticalHeaderLabels([' ']*len(self.__Table)) for i in range(len(self.__Table)): item = QStandardItem(str(self.__Table[i]['id'])) item.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) model.setItem(i, 0, item) item = QStandardItem(str(self.__Table[i]['header'])) item.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) model.setItem(i, 1, item) item = QStandardItem(str(self.__Table[i]['idParent'])) item.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) model.setItem(i, 2, item) item = QStandardItem(str(self.__Table[i]['idGroupStr'])) item.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) model.setItem(i, 3, item)""" sql = 'SELECT * FROM contexttab' model = DataBaseModule.CreateTableViewModel( sql, ['id', 'header', 'idParent', 'level'], ['id', 'Заголовок контекста', 'id Родителя', 'Уровень']) return model
def getTVModel(self): sql = "SELECT * FROM botdb.clientstab" fieldsTable = ['id', 'idRii', 'idClientGroup', 'idTelegram'] model = DBM.CreateTableViewModel(sql=sql, fieldsView=fieldsTable, fieldTab=fieldsTable, nameDB='botdb') return model
def getTVModel(self): sql = "SELECT * from riidb.projectors" fieldsTab = ['id', 'name', 'numAud'] fieldsView = ['id', 'Название', "Ауд."] model = DBM.CreateTableViewModel(sql=sql, fieldsView=fieldsView, fieldTab=fieldsTab, nameDB='riidb') return model
def GetGroupsModelFromID(self, id): sql = """SELECT usergrouptab.id as 'id', usergrouptab.nameGroup as 'nameGroup' FROM botdb.usergrouptab INNER JOIN (botdb.accesstab INNER JOIN botdb.contexttab ON accesstab.idContext = contexttab.id) ON usergrouptab.id = accesstab.idGroup WHERE contexttab.id='""" + str(id) + "';" model = DataBaseModule.CreateTableViewModel(sql, ['id', 'nameGroup'], ['id', 'Группа']) return model
def getTVModel(self): sql = "SELECT id, num FROM riidb.audtable " \ "ORDER BY num" fieldsTable = ['id', 'num'] fieldsView = ['id', 'Номер аудитории'] model = DBM.CreateTableViewModel(sql=sql, fieldTab=fieldsTable, fieldsView=fieldsView, nameDB='riidb') return model
def getTVCathedraModel(self, zav=True): if zav: sql = "SELECT cathedra.id as id, cathedra.name as name," \ " clients.fio as zav " \ "FROM riidb.cathedra INNER JOIN riidb.clients " \ "ON cathedra.idZav = clients.id;" nameList = ['id', 'name', 'zav'] asList = ['id', "Кафедра", "Заведующий"] else: sql = "SELECT * FROM riidb.cathedra" nameList = ['id', 'name', 'idZav'] asList = ['id', "Кафедра", "Заведующий"] model = DBM.CreateTableViewModel(sql, nameList, asList, nameDB='riidb') return model
def getTVCathGroup(self, idCathedra=0): if not idCathedra: sql = "SELECT cathGroup.id as idGroup, cathGroup.name as nameGroup, " \ "cathGroup.course as course, clients.fio as fioCur, cathedra.name as nameCathedra " \ "FROM (riidb.cathGroup INNER JOIN riidb.clients " \ "ON cathGroup.idCurator = clients.id) INNER JOIN riidb.cathedra " \ "ON cathGroup.idCathedra = cathedra.id;" else: sql = "SELECT cathGroup.id as idGroup, cathGroup.name as nameGroup, " \ "cathGroup.course as course, clients.fio as fioCur, cathedra.name as nameCathedra " \ "FROM (riidb.cathGroup INNER JOIN riidb.clients " \ "ON cathGroup.idCurator = clients.id) INNER JOIN riidb.cathedra " \ "ON cathGroup.idCathedra = cathedra.id AND cathedra.id='%s';"%idCathedra fieldTab = ['idGroup', 'nameGroup', 'course', 'fioCur', 'nameCathedra'] fieldView = ['id', 'Группа', 'Курс', "Куратор", "Кафедра"] model = DBM.CreateTableViewModel(sql, fieldTab, fieldView, 'riidb') return model
def GetTableViewModel(self): """model = QStandardItemModel() model.setHorizontalHeaderLabels(['id', 'Вопрос']) model.setVerticalHeaderLabels([' '] * len(self.__Table)) for i in range(len(self.__Table)): item = QStandardItem(str(self.__Table[i]['id'])) item.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) model.setItem(i, 0, item) item = QStandardItem(str(self.__Table[i]['question'])) item.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled) model.setItem(i, 1, item)""" return DataBaseModule.CreateTableViewModel('SELECT * FROM questiontab', ['id', 'question'], ['id', 'Вопрос'])
def getTVStudentsModel(self, cathGroup=0): if cathGroup == 0: sql = "SELECT clients.id as id, clients.fio as fio, " \ "clients.idClientGroup, " \ "cathGroup.name as cathGroup, cathGroup.course as course " \ "FROM riidb.clients INNER JOIN riidb.cathGroup " \ "ON clients.idInfo = cathGroup.id and clients.idClientGroup=3;" else: sql = "SELECT clients.id as id, clients.fio as fio, " \ "clients.idClientGroup, " \ "cathGroup.name as cathGroup, cathGroup.course as course " \ "FROM riidb.clients INNER JOIN riidb.cathGroup " \ "ON clients.idInfo = cathGroup.id and clients.idClientGroup=3 " \ "and clients.idInfo='%s';"%cathGroup nameList = ['id', 'fio', 'cathGroup', 'course'] asList = ['id', 'ФИО', 'Группа', 'Курс'] model = DataBaseModule.CreateTableViewModel(sql, nameList, asList, nameDB='riidb') return model
def GetTableViewModel(self): return DataBaseModule.CreateTableViewModel( 'SELECT * FROM answertab', ['id', 'answer', 'idAction'], ['id', 'Ответ', 'Действие'])