def school_to_dict(school):
"""school to dict
"""
return {
'schoolname': school.schoolname,
'description': school.description,
'creator': UserHelper.get_name_by_id(school.creator)
}
def get_file(file_id):
"""get file
"""
qs = Attechment.objects.filter(id=file_id)
if qs.exists():
attechment = qs.last()
return {
'filename' : attechment.filename,
'filepath' : attechment.filepath,
'user' : UserHelper.get_name_by_id(attechment.user_id)
}
return None
def get_applies(school_id, list_type, page):
"""get school's applies
"""
params = SchoolApplyHelper.get_applies_filter(school_id, list_type)
if params is None:
return 0
qs = SchoolApply.objects.filter(**params)
qs.order_by('apply_time')
qs = qs[(page - 1) * 20:page * 20]
applies = []
for apply in qs:
username = UserHelper.get_name_by_id(apply.user_id)
judger = UserHelper.get_name_by_id(apply.judge)
applies.append({
'id': apply.id,
'username': username,
'reason': apply.message,
'time': date_to_string(apply.apply_time),
'judger': judger,
'status': apply.status
})
return applies
def get_school_by_name(school_name):
"""get schoolname
"""
schools = School.objects.filter(schoolname=school_name)
if schools.exists():
school = schools.last()
headmaster_id = PermissionHelper.get_school_headmaster(school.id)
return {
'id': school.id,
'schoolname': school.schoolname,
'description': school.description,
'headmaster': UserHelper.get_name_by_id(headmaster_id),
'population': PermissionHelper.get_school_population(school.id)
}
return None
def video_to_dict(video):
"""video to dict
"""
return {
'id' : video.id,
'name' : video.title,
'description' : video.description,
'upload_time' : date_to_string(video.upload_time),
'size' : video.video_size,
'filename' : video.filename,
'filepath' : video.filepath,
'school' : video.school,
'uploader' : UserHelper.get_name_by_id(video.uploader),
'category' : video.category
}
def get_school(school_id):
"""get school
"""
if school_id == 0:
return {
'id': 0,
'schoolname': '-',
'description': '-',
'headmaster': '-',
'population': -1
}
schools = School.objects.filter(id=school_id)
headmaster_id = PermissionHelper.get_school_headmaster(school_id)
if schools.exists():
school = schools.last()
return {
'id': school_id,
'schoolname': school.schoolname,
'description': school.description,
'headmaster': UserHelper.get_name_by_id(headmaster_id),
'population': PermissionHelper.get_school_population(school_id)
}
return None
