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', 'Ответ', 'Действие'])
