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
