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})