def term_get_by_params(page=0,
only_invalided=0,
discipline_id=0,
user_id=0):
on_page = 40
start = on_page * (page - 1)
end = start + on_page
term_db = TermGateway()
rv = term_db.read_for_editor(start, end, only_invalided, discipline_id,
user_id)
if rv == None:
return {}
else:
user_db = UserGateway()
users = user_db.read_all()
discipline_db = DisciplineGateway()
disciplines = discipline_db.read_all()
for (index, row_term) in enumerate(rv):
discipline = {}
creator = {}
cur_discipline = row_term['discipline']
cur_user = row_term['creator']
for (index, row_discipline) in enumerate(disciplines):
if row_discipline['iddiscipline'] == cur_discipline:
discipline = row_discipline
for (index, row_user) in enumerate(users):
if row_user['iduser'] == cur_user:
creator = row_user
row_term['creator'] = creator
row_term['discipline'] = discipline
return rv
def discipline_delete_by_id(usertoken, discipline_id):
discipline_db = DisciplineGateway()
rv = discipline_db.delete(discipline_id)
if rv['code'] == 0:
ControlService.write_to_log(usertoken, "discipline",
str(discipline_id), "delete")
return rv
def disciplines_users_for_term_editor():
user_db = UserGateway()
users = user_db.read_all()
if users == None:
users = {}
teacher_db = TeacherGateway()
teachers = teacher_db.read_all()
if teachers == None:
teachers = {}
disciplines = {}
department_db = DepartmentGateway()
departments = department_db.read_all()
if departments == None:
departments = {}
else:
discipline_db = DisciplineGateway()
disciplines = discipline_db.read_all()
if disciplines == None:
disciplines = {}
else:
for (index, row_discipline) in enumerate(disciplines):
department_id = row_discipline['department_id']
department = ''
for (index, row) in enumerate(departments):
if row['iddepartment'] == department_id:
department = row['initials']
row_discipline['department_id'] = department
return {
"users": users,
"disciplines": disciplines,
"teachers": teachers
}
def discipline_get_all():
discipline_db = DisciplineGateway()
rv = discipline_db.read_all()
if rv == None:
return {}
else:
return rv
def discipline_edit_by_id(usertoken, discipline_id, name, semester,
department_id):
discipline_db = DisciplineGateway()
rv = discipline_db.update(name, semester, department_id, discipline_id)
if rv['code'] == 0:
ControlService.write_to_log(usertoken, "discipline",
str(discipline_id), "edit")
return rv
def discipline_add(usertoken, name, semester, department_id):
discipline_db = DisciplineGateway()
database_result = discipline_db.create(name, semester, department_id)
result = {
"code": database_result['code'],
"message": database_result['message'],
}
if result["code"] == 0:
number = discipline_db.access_get_number(visitor=VisitorLastNumber)
ControlService.write_to_log(usertoken, "discipline", str(number),
"add")
return result
def term_get_random():
term_db = TermGateway()
id = term_db.access_get_number(visitor=VisitorRandomNumber)
terms = term_db.read_by_id(id)
teacher_db = TeacherGateway()
teachers = teacher_db.read_all()
if teachers == None:
teachers = {}
disciplines = {}
department_db = DepartmentGateway()
departments = department_db.read_all()
if departments == None:
departments = {}
else:
discipline_db = DisciplineGateway()
disciplines = discipline_db.read_all()
if disciplines == None:
disciplines = {}
else:
for (index, row_discipline) in enumerate(disciplines):
department_id = row_discipline['department_id']
department = ''
for (index, row) in enumerate(departments):
if row['iddepartment'] == department_id:
department = row['initials']
row_discipline['department_id'] = department
if terms == None:
return {"term": {}, "media": {}}
else:
media_db = MediaGateway()
rv = media_db.read_by_term(id)
if rv == None:
rv = {}
return {
"term": terms,
"media": rv,
"disciplines": disciplines,
"teachers": teachers
}
def term_get_filters():
disciplines = {}
department_db = DepartmentGateway()
departments = department_db.read_all()
if departments == None:
departments = {}
else:
discipline_db = DisciplineGateway()
disciplines = discipline_db.read_all()
if disciplines == None:
disciplines = {}
else:
for (index, row_discipline) in enumerate(disciplines):
department_id = row_discipline['department_id']
department = ''
for (index, row) in enumerate(departments):
if row['iddepartment'] == department_id:
department = row
row_discipline['department_id'] = department
return {"departments": departments, "disciplines": disciplines}
def discipline_get_by_id(id):
discipline_db = DisciplineGateway()
rv = discipline_db.read_by_id(id)
return rv
def log_read_last(count):
logDB = LogGateway()
logs = logDB.read_last(count=count)
user_db = UserGateway()
users = user_db.read_all()
department_db = DepartmentGateway()
departments = department_db.read_all()
discipline_db = DisciplineGateway()
disciplines = discipline_db.read_all()
teacher_db = TeacherGateway()
teachers = teacher_db.read_all()
term_db = TermGateway()
terms = term_db.read_for_editor(start=0, end=20, only_invalided=False)
media_db = MediaGateway()
medias = media_db.read_all()
if logs == None:
return {}
else:
for (index_log, log) in enumerate(logs):
# correct date
tmp = log['date_time']
log['date_time'] = tmp.strftime('%d.%m.%Y %H:%M')
# add user to log
for (index_user, user) in enumerate(users):
if (log['user'] == user['iduser']):
log['user'] = user
# long series for if for element detection
if (log['table'] == "user"):
for (index_user, user) in enumerate(users):
if (log['element'] == user['iduser']):
element_text = user['first_name'] + " " + user[
'last_name']
log['element'] = {
"id": user['iduser'],
"text": element_text
}
if (log['table'] == "department"):
for (index_department,
department) in enumerate(departments):
if (log['element'] == department['iddepartment']):
element_text = department['initials']
log['element'] = {
"id": department['iddepartment'],
"text": element_text
}
if (log['table'] == "discipline"):
for (index_discipline,
discipline) in enumerate(disciplines):
if (log['element'] == discipline['iddiscipline']):
element_text = discipline['name']
log['element'] = {
"id": discipline['iddiscipline'],
"text": element_text
}
if (log['table'] == "teacher"):
for (index_teacher, teacher) in enumerate(teachers):
if (log['element'] == teacher['idteacher']):
element_text = teacher['name']
log['element'] = {
"id": teacher['idteacher'],
"text": element_text
}
if (log['table'] == "term"):
for (index_term, term) in enumerate(terms):
if (log['element'] == term['idterm']):
element_text = term['caption']
log['element'] = {
"id": term['idterm'],
"text": element_text
}
if (log['table'] == "media"):
for (index_media, media) in enumerate(medias):
if (log['element'] == media['idmedia']):
types = {
1: "Жест",
2: "Артикуляция",
3: "Контекстный пример"
}
element_text = types[media['type']]
log['element'] = {
"id": media['idmedia'],
"text": element_text
}
rv = logs
return rv