def SearchStudentByUid(uid): record = Student.get_or_none(Student.uid == uid, Student.status == STATUS_VALID) r = model_to_dict(record) r = utils.Time2Str(r) r = utils.Decimal2Str(r) return r
def GetLessonsBylessonid(lessonid): lesson = Lesson.get_or_none(Lesson.id == lessonid) if lesson: lesson = model_to_dict(lesson) lesson = utils.Time2Str(lesson) lesson = utils.Decimal2Str(lesson) return lesson
def SearchTeacherByNickname(nickname): mem = Teacher.get_or_none(Teacher.nickname == nickname, Teacher.status == STATUS_VALID) m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) return m
def SearchMemberById(nickname): mem = Member.get_or_none(Member.nickname == nickname, Member.status == STATUS_VALID) m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) return m
def GetOneCourseByName(cname): #mem = Course.get_or_none(Course.name == cname, Course.status == STATUS_VALID) mem = Course.get_or_none(Course.name == cname) m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) return m
def SearchMemberByMobile(mobile): m = Member.get_or_none(Member.mobile == mobile, Member.status == STATUS_VALID) if m: m = model_to_dict(m) m = utils.Time2Str(m) m = utils.Decimal2Str(m) return m
def SearchTeacherById(tid): teacher = Teacher.get_or_none(Teacher.id == tid, Teacher.status == STATUS_VALID) if teacher: teacher = model_to_dict(teacher) teacher = utils.Time2Str(teacher) teacher = utils.Decimal2Str(teacher) return teacher
def GetLessonsByCourseid(courseid): lessons = [] for rec in Lesson.select().where(Lesson.course_id == courseid): r = model_to_dict(rec) r = utils.Time2Str(r) r = utils.Decimal2Str(r) lessons.append(r) return lessons
def GetLessonsByName(name): lessons = [] for mem in Lesson.select().where(Lesson.lessonname.contains(name)): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) lessons.append(m) return lessons
def GetTeacherByCourseid(courseid): teachers = [] for rec in Courseteacher.select().where( Courseteacher.course_id == courseid): r = model_to_dict(rec) r = utils.Time2Str(r) r = utils.Decimal2Str(r) teachers.append(r) return teachers
def GetCourses(page_num, item_per_page): count = Course.select().count() courses = [] for mem in Course.select().order_by(Course.id).paginate(page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) courses.append(m) return count, courses
def GetStdIdByMemid(mid): stdids = [] #memList = [model_to_dict(mem) for mem in Member.select().order_by(Member.id).paginate(page_num, item_per_page)] for rec in Studentguarder.select().where(Studentguarder.member_id == mid,Studentguarder.status == STATUS_VALID): r = model_to_dict(rec) r = utils.Time2Str(r) r = utils.Decimal2Str(r) stdids.append(r['student_id']) return stdids
def SearchLessonByName(page_num, item_per_page,name): count = Lesson.select().where(Lesson.lessonname == name).count() lessons = [] for mem in Lesson.select().where(Lesson.lessonname == name).order_by(Lesson.id).paginate(page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) lessons.append(m) return count, lessons
def SearchCourseByName(page_num, item_per_page,name): count = Course.select().where(Course.name == name).count() courses = [] for mem in Course.select().where(Course.name == name).order_by(Course.id).paginate(page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) courses.append(m) return count, courses
def GetLessons(page_num, item_per_page): count = Lesson.select().count() lessons = [] for mem in Lesson.select().order_by(Lesson.id).paginate(page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) lessons.append(m) return count, lessons
def GetStudents(page_num, item_per_page): count = Student.select().where(Student.status == STATUS_VALID).count() students = [] print("total record nums: %d" % count) #memList = [model_to_dict(mem) for mem in Student.select().order_by(Student.id).paginate(page_num, item_per_page)] for mem in Student.select().where(Student.status == STATUS_VALID).order_by( Student.id).paginate(page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) students.append(m) return count, students
def GetStudentsInfoByName(name): stdsInfo = [] for mem in Student.select().where(Student.name == name, Student.status == STATUS_VALID).order_by( Student.id): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) std_name_mobile = m['name'] + '_' + m['urgent_mobile'] stdInfo = {'value': m['id'], 'label': std_name_mobile} stdsInfo.append(stdInfo) return stdsInfo
def GetTeachers(page_num, item_per_page): count = Teacher.select().where(Teacher.status == STATUS_VALID).count() teachers = [] print("total record nums: %d" % count) #memList = [model_to_dict(mem) for mem in Teacher.select().order_by(Teacher.id).paginate(page_num, item_per_page)] for mem in Teacher.select().where(Teacher.status == STATUS_VALID).order_by( Teacher.id).paginate(page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) teachers.append(m) return count, teachers
def SearchMemberByName(page_num, item_per_page, name): count = Member.select().where(Member.name == name, Member.status == STATUS_VALID).count() members = [] #memList = [model_to_dict(mem) for mem in Member.select().order_by(Member.id).paginate(page_num, item_per_page)] for mem in Member.select().where(Member.name == name, Member.status == STATUS_VALID).order_by( Member.id).paginate( page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) members.append(m) return count, members
def SearchStudentByName(page_num, item_per_page, name): count = Student.select().where(Student.name == name, Student.status == STATUS_VALID).count() students = [] #memList = [model_to_dict(mem) for mem in Student.select().order_by(Student.id).paginate(page_num, item_per_page)] for mem in Student.select().where(Student.name == name, Student.status == STATUS_VALID).order_by( Student.id).paginate( page_num, item_per_page): m = model_to_dict(mem) m = utils.Time2Str(m) m = utils.Decimal2Str(m) students.append(m) return count, students
def GetStdInfoById(sid): stdinfo = dict() record = Student.get_or_none(Student.id == sid, Student.status == STATUS_VALID) if record: r = model_to_dict(record) r = utils.Time2Str(r) r = utils.Decimal2Str(r) stdinfo['name'] = r['name'] stdinfo['uid'] = r['uid'] stdinfo['id'] = r['id'] stdinfo['nickname'] = r['nickname'] stdinfo['sex'] = r['sex'] stdinfo['urgent_contactor'] = r['urgent_contactor'] stdinfo['urgent_mobile'] = r['urgent_mobile'] stdinfo['birthday'] = r['birthday'] return stdinfo