def update_password():
msgList = ['修改密码成功', '原密码错误，验证失败', '新旧密码一致，无须修改', '该用户不存在']
data = request.get_json(force=True)
# check if the old password is correct
user = AdmModel.GetRecordByUsername(data['username'])
if user is None:
errcode = 3
else:
if safe_str_cmp(data['oldpwd'].encode('utf-8'),
user.password.encode('utf-8')):
if safe_str_cmp(data['newpwd'].encode('utf-8'),
user.password.encode('utf-8')):
errcode = 2
else:
# update new password to database
AdmModel.UpdateRecrodByUsername({
'username': user.username,
'password': data['newpwd']
})
errcode = 0
else:
errcode = 1
return utils.jsonresp(jsonobj={
'errcode': errcode,
'errmsg': msgList[errcode]
})
def delete_students(uids):
errcode = 0
for uid in uids.split(','):
ret = StudentModel.DeleteStudentByUid(uid)
if ret != 0:
errcode = 1
return utils.jsonresp(jsonobj={'errcode': errcode})
def delete_lessons(names):
errcode = 0
#nameList = names.split(',')
for name in names.split(','):
ret = LessonModel.DeleteLessonByname(name)
if ret != 0:
errcode = 1
return utils.jsonresp(jsonobj={'errcode': errcode})
def delete_members(nicknames):
errcode = 0
#nameList = nicknames.split(',')
for nickname in nicknames.split(','):
ret = MemberModel.DeleteMemberByNickname(nickname)
if ret != 0:
errcode = 1
return utils.jsonresp(jsonobj={'errcode': errcode})
def delete_courses(names):
errcode = 0
#nameList = names.split(',')
for name in names.split(','):
ret = CourseModel.DeleteCourseByname(name)
if ret != 0:
errcode = 1
return utils.jsonresp(jsonobj={'errcode':errcode})
def update_teacher(nickname):
print(datetime.datetime.now())
print('request put request')
print(datetime.datetime.now())
data = request.get_json(force=True)
print(datetime.datetime.now())
print(data)
#dataDict = utils.str_to_dict(rm.get_dict())
errcode = TeacherModel.UpdateTeacherById(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def updateCidBylessonid(cid):
data = request.get_json(force=True)
courseid = int(cid)
# step1 reset courseid to 0 for current all lesson
# courseid = 0 , it mean no correlation for this lesson
for lesson in LessonModel.GetLessonsByCourseid(courseid):
LessonModel.UpdateCidByLid(0, lesson['id'])
# step2 update courseid according to lessonid
for lid in data['corLessonids']:
errcode = LessonModel.UpdateCidByLid(courseid, int(lid))
return utils.jsonresp(jsonobj={'errcode': errcode})
def get_lessons():
limit = int(request.args.get('limit'))
page = int(request.args.get('page'))
name = request.args.get('lessonname')
if name:
total, lessons = LessonModel.SearchLessonByName(page, limit, name)
else:
total, lessons = LessonModel.GetLessons(page, limit)
return utils.jsonresp(jsonobj={
'total': total,
'limit': limit,
'lessons': lessons
})
def get_students():
print("recevie get all students requests")
limit = int(request.args.get('limit'))
page = int(request.args.get('page'))
name = request.args.get('name')
if name:
total, students = StudentModel.SearchStudentByName(page, limit, name)
else:
total, students = StudentModel.GetStudents(page, limit)
return utils.jsonresp(jsonobj={
'total': total,
'limit': limit,
'students': students
})
def get_teachers():
print("recevie get all teachers requests")
limit = int(request.args.get('limit'))
page = int(request.args.get('page'))
name = request.args.get('name')
if name:
total, teachers = TeacherModel.SearchTeacherByName(page, limit, name)
else:
total, teachers = TeacherModel.GetTeachers(page, limit)
return utils.jsonresp(jsonobj={
'total': total,
'limit': limit,
'teachers': teachers
})
def update_courseteachers(cid):
data = request.get_json(force=True)
courseid = int(cid)
# step1 delete all records for course_id = courseid
CTeacherModel.DeleteByCourseid(courseid)
# store all records for courseid
for ct in data['corTeachers']:
ctdict = {
'course_id': courseid,
'teacher_id': int(ct['teacher_id']),
'teacher_name': ct['teacher_name'],
'teacher_mobile': ct['teacher_mobile']
}
errcode = CTeacherModel.CreateCourseteacher(ctdict)
return utils.jsonresp(jsonobj={'errcode': errcode})
def get_courses():
limit = int(request.args.get('limit'))
page = int(request.args.get('page'))
name = request.args.get('name')
if name:
total, courses = CourseModel.SearchCourseByName(page, limit, name)
else:
total, courses = CourseModel.GetCourses(page, limit)
# get relation lessons information
for i in range(len(courses)):
courses[i]['lessonInfo'] = []
#query student according members[i]['id']
lessons = LessonModel.GetLessonsByCourseid(courses[i]['id'])
for lesson in lessons:
# get lesson information
courses[i]['lessonInfo'].append(lesson)
courses[i]['teacherInfo'] = []
teachers = CTeacherModel.GetTeacherByCourseid(courses[i]['id'])
for th in teachers:
courses[i]['teacherInfo'].append({'teacher_id':th['teacher_id'],'teacher_name':th['teacher_name'],'teacher_mobile':th['teacher_mobile']})
return utils.jsonresp(jsonobj={'total':total, 'limit':limit, 'courses':courses})
def get_members():
limit = int(request.args.get('limit'))
page = int(request.args.get('page'))
name = request.args.get('name')
if name:
total, members = MemberModel.SearchMemberByName(page, limit, name)
else:
total, members = MemberModel.GetMembers(page, limit)
# get relation student information
for i in range(len(members)):
members[i]['studentInfo'] = []
#query student according members[i]['id']
stdids = StdGuarderModel.GetStdIdByMemid(members[i]['id'])
if stdids:
for sid in stdids:
# get student information
stdinfo = StdModel.GetStdInfoById(sid)
members[i]['studentInfo'].append(stdinfo)
return utils.jsonresp(jsonobj={
'total': total,
'limit': limit,
'members': members
})
def create_course():
data = request.get_json('content')
errcode = CourseModel.CreateCourse(data)
return utils.jsonresp(jsonobj={'errcode':errcode})
def get_onecourse(name):
courses = []
course = CourseModel.GetOneCourseByName(name)
if courses:
courses.append(course)
return utils.jsonresp(jsonobj={'courses':courses})
def update_lesson(name):
data = request.get_json(force=True)
errcode = LessonModel.UpdateLessonByName(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def delete_member(nickname):
errcode = MemberModel.DeleteMemberByNickname(nickname)
return utils.jsonresp(jsonobj={'errcode': errcode})
def GetStudentsInfoById(sid):
stdInfos = StudentModel.GetStdInfoById(sid)
return utils.jsonresp(jsonobj={'stdinfos': stdInfos})
def create_lesson():
data = request.get_json('content')
errcode = LessonModel.CreateLesson(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def get_member(mobile):
members = []
member = MemberModel.SearchMemberByMobile(mobile)
if member:
members.append(member)
return utils.jsonresp(jsonobj={'members': members})
def delete_lesson(name):
errcode = LessonModel.DeleteLessonByname(name)
return utils.jsonresp(jsonobj={'errcode': errcode})
def get_student(uid):
students = []
student = StudentModel.SearchStudentByUid(uid)
if student:
students.append(student)
return utils.jsonresp(jsonobj={'students': students})
def delete_student(uid):
errcode = StudentModel.DeleteStudentByUid(uid)
return utils.jsonresp(jsonobj={'errcode': errcode})
def update_student(uid):
data = request.get_json(force=True)
#dataDict = utils.str_to_dict(rm.get_dict())
errcode = StudentModel.UpdateStudentByUid(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def create_student():
print('receive post reqeust')
data = request.get_json('content')
errcode = StudentModel.CreateStudent(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def update_course(name):
data = request.get_json(force=True)
errcode = CourseModel.UpdateCourseByName(data)
return utils.jsonresp(jsonobj={'errcode':errcode})
def delete_course(name):
errcode = CourseModel.DeleteCourseByname(name)
return utils.jsonresp(jsonobj={'errcode':errcode})
def create_member():
print('receive post reqeust')
data = request.get_json('content')
errcode = MemberModel.CreateMember(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def update_member(nickname):
data = request.get_json(force=True)
#dataDict = utils.str_to_dict(rm.get_dict())
errcode = MemberModel.UpdateMemberById(data)
return utils.jsonresp(jsonobj={'errcode': errcode})
def GetStudentsInfoByName(sname):
stdInfos = StudentModel.GetStudentsInfoByName(sname)
return utils.jsonresp(jsonobj={'stdinfos': stdInfos})
