コード例 #1
0
def classadd(school):
    schoolname=school.getSchoolname()
    schoolid=school.getSchoolid()
    province=school.getProvince()
    city=school.getCity()
    starttime=school.getStarttime()



    request_params=[]
    values_params=[]
    if schoolname!='':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if schoolid!='':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if province!='':
        request_params.append('province')
        values_params.append(SQLTool.formatstring(province))
    if city!='':
        request_params.append('city')
        values_params.append(SQLTool.formatstring(city))
    if starttime!='':
        request_params.append('starttime')
        values_params.append(SQLTool.formatstring(starttime))      
    table=localconfig.schooltable
    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()

    tempresult=DBhelp.inserttableinfo_byparams(table=table, select_params=request_params,insert_values= [tuple(values_params)])

    DBhelp.closedb()

    return tempresult
コード例 #2
0
def classupdate(schoolname='',schoolid='',province='',city='',starttime=''):


    request_params=[]
    values_params=[]
    wset_params=[]
    wand_params=[]
    if schoolname!='':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if schoolid!='':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if province!='':
        request_params.append('province')
        values_params.append(SQLTool.formatstring(province))
    if city!='':
        request_params.append('city')
        values_params.append(SQLTool.formatstring(city))
    if starttime!='':
        request_params.append('starttime')
        values_params.append(SQLTool.formatstring(starttime))
    table=localconfig.schooltable
    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()

    tempresult=DBhelp.updatetableinfo_byparams([table],request_params,values_params,wset_params,wand_params)
    DBhelp.closedb()

    return tempresult

    
    
    
コード例 #3
0
def classshow(schoolname='',schoolid='',gradeid='',classid='',classname='',page='0'):
    validresult=False
    request_params=[]
    values_params=[]
    if schoolname!='':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if gradeid!='':
        request_params.append('t_classes.gradeId')
        values_params.append(SQLTool.formatstring(gradeid))
    if classid!='':
        request_params.append('t_classes.classId')
        values_params.append(SQLTool.formatstring(classid))
    if classname!='':
        request_params.append('t_class_name.className')
        values_params.append(SQLTool.formatstring(classname))
    if schoolid!='':
        request_params.append('t_classes.schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    request_params.append('t_school.schoolId')
    values_params.append('t_classes.schoolId')
    request_params.append('t_classes.classId')
    values_params.append('t_class_name.classId')

    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    table=localconfig.schooltable
    result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.classtable,localconfig.classnametable], ['schoolName','t_classes.schoolId','t_classes.gradeId','cId','t_class_name.className','t_classes.classId'], request_params, values_params)

    if count == 0:
        pagecount = 0;
    elif count %limitpage> 0:
#         pagecount = math.ceil(count / limitpage)
        pagecount=int((count+limitpage-1)/limitpage) 


    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount>0:
    
        limit='    limit  '+str(int(page)*limitpage)+','+str(limitpage)
        result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.classtable,localconfig.classnametable], ['schoolName','t_classes.schoolId','t_classes.gradeId','cId','t_class_name.className','t_classes.classId'], request_params, values_params,limit,order='schoolId desc')

        DBhelp.closedb()
        classes=[]
        if count>0:
            validresult=True
            for temp in result :
                aclass=Class.Class(schoolname=temp['schoolName'],schoolid=temp['schoolId'],gradeid=temp['gradeId'],cid=temp['cId'],classname=temp['className'],classid=temp['classId'])


                classes.append(aclass)
        return classes,count,pagecount
    return [],0,pagecount
コード例 #4
0
def haveclassshow(schoolid='',classid='',teacherid='',page='0'):
    validresult=False
    request_params=[]
    values_params=[]
    if schoolid!='':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if classid!='':
        request_params.append('t_classes.classId')
        values_params.append(SQLTool.formatstring(classid))
    if teacherid!='':
        request_params.append('teacherId')
        values_params.append(SQLTool.formatstring(teacherid))

    request_params.append('t_teach.teacherId')
    values_params.append('t_teachers.teacherId')

    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    table=localconfig.teachertable
    result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.teachtable], ['t_teachers.teacherId','masterId','time','schoolId','teacherName','classId'], request_params, values_params)

    if count == 0:
        pagecount = 0;
    elif count %limitpage> 0:
#         pagecount = math.ceil(count / limitpage)
        pagecount=int((count+limitpage-1)/limitpage) 


    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount>0:
    
        limit='    limit  '+str(int(page)*limitpage)+','+str(limitpage)
        result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.teachtable], ['t_teachers.teacherId','masterId','time','schoolId','teacherName','classId'], request_params, values_params,limit,order='time desc')

        DBhelp.closedb()
        classes=[]
        if count>0:
            validresult=True
            for temp in result :
                aclass=takeclass.Takeclass(teacherid=temp['teacherId'],schoolid=temp['schoolId'],masterid=temp['masterId'],time=temp['time'],teachername=temp['teacherName'],classid=temp['classId'])


                classes.append(aclass)
        return classes,count,pagecount
    return [],0,pagecount
コード例 #5
0
def loadteacher(path):

    data = xlstool.getdata(path, u'教师')
    teachdata = []
    attenddata = []
    logindata = []
    for i in data:
        temp = list(i)
        teacherid = uuid.uuid1()
        teachdata.append(
            (temp[0], teacherid, temp[1], temp[2], temp[3], temp[4], '123456'))
        logindata.append(
            (temp[5], 'e10adc3949ba59abbe56e057f20f883e', teacherid))

    sqlhelp = SQLTool.getObject()
    sqlhelp.connectdb()
    result = sqlhelp.inserttableinfo_byparams(config.Config.teachertable, [
        'schoolId', 'teacherId', 'teacherName', 'teacherPhone', 'offer',
        'jobTitle', 'password'
    ], teachdata)
    if result:

        result = sqlhelp.inserttableinfo_byparams(
            config.Config.usertable, ['username', 'password', 'userId'],
            logindata)

    return result
コード例 #6
0
def loadteacher(path):

    data = xlstool.getdata(path, u"教师")
    teachdata = []
    attenddata = []
    logindata = []
    for i in data:
        temp = list(i)
        teacherid = uuid.uuid1()
        teachdata.append((temp[0], teacherid, temp[1], temp[2], temp[3], temp[4], "123456"))
        logindata.append((temp[5], "e10adc3949ba59abbe56e057f20f883e", teacherid))

    sqlhelp = SQLTool.getObject()
    sqlhelp.connectdb()
    result = sqlhelp.inserttableinfo_byparams(
        config.Config.teachertable,
        ["schoolId", "teacherId", "teacherName", "teacherPhone", "offer", "jobTitle", "password"],
        teachdata,
    )
    if result:

        result = sqlhelp.inserttableinfo_byparams(
            config.Config.usertable, ["username", "password", "userId"], logindata
        )

    return result
コード例 #7
0
def loadstudent(path):
    
    data=xlstool.getdata(path, u'学生')
    studentdata=[]
    studentattenddata=[]
    logindata=[]
    for i in data:

        temp=list(i)
        studentid=uuid.uuid1()
 
        studentdata.append((studentid,temp[0],temp[1],temp[2],temp[3],temp[4],temp[5],temp[6],temp[7],temp[8],temp[9],temp[10],temp[14]))
        studentattenddata.append((studentid,temp[11],temp[13]))
        logindata.append((temp[12],'e10adc3949ba59abbe56e057f20f883e',studentid))
 
           
    sqlhelp=SQLTool.getObject()
    sqlhelp.connectdb()
    result=sqlhelp.inserttableinfo_byparams(config.Config.studenttable, ['studentId','name','sex','birthday','address','familyPhone','mail','family','admissionTime','nation','placeOfOrigin','team','id'], studentdata)
    if result:
        result=sqlhelp.inserttableinfo_byparams(config.Config.student_attend_table, ['studentId','classId','time'], studentattenddata)
        if result:
            result=sqlhelp.inserttableinfo_byparams(config.Config.usertable, ['username','password','userId'], logindata)
   
    return result
コード例 #8
0
def loadstudent(path):

    data = xlstool.getdata(path, u'学生')
    studentdata = []
    studentattenddata = []
    logindata = []
    for i in data:

        temp = list(i)
        studentid = uuid.uuid1()

        studentdata.append(
            (studentid, temp[0], temp[1], temp[2], temp[3], temp[4], temp[5],
             temp[6], temp[7], temp[8], temp[9], temp[10], temp[14]))
        studentattenddata.append((studentid, temp[11], temp[13]))
        logindata.append(
            (temp[12], 'e10adc3949ba59abbe56e057f20f883e', studentid))

    sqlhelp = SQLTool.getObject()
    sqlhelp.connectdb()
    result = sqlhelp.inserttableinfo_byparams(config.Config.studenttable, [
        'studentId', 'name', 'sex', 'birthday', 'address', 'familyPhone',
        'mail', 'family', 'admissionTime', 'nation', 'placeOfOrigin', 'team',
        'id'
    ], studentdata)
    if result:
        result = sqlhelp.inserttableinfo_byparams(
            config.Config.student_attend_table,
            ['studentId', 'classId', 'time'], studentattenddata)
        if result:
            result = sqlhelp.inserttableinfo_byparams(
                config.Config.usertable, ['username', 'password', 'userId'],
                logindata)

    return result
コード例 #9
0
def loadschool(path):
    
    data=xlstool.getdata(path, u'学校')

    sqlhelp=SQLTool.getObject()
    sqlhelp.connectdb()
    result=sqlhelp.inserttableinfo_byparams(config.Config.schooltable, ['province','city','schoolName','schoolTime'], data)
    return result
コード例 #10
0
def loadschool(path):

    data = xlstool.getdata(path, u'学校')

    sqlhelp = SQLTool.getObject()
    sqlhelp.connectdb()
    result = sqlhelp.inserttableinfo_byparams(
        config.Config.schooltable,
        ['province', 'city', 'schoolName', 'schoolTime'], data)
    return result
コード例 #11
0
def validuser(username, password):
    validresult = False
    password = webtool.md5(password)
    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()
    result, content, count, col = DBhelp.searchtableinfo_byparams(
        [localconfig.usertable], ['userName', 'password', 'userid'],
        ['userName', 'password'],
        [SQLTool.formatstring(username),
         SQLTool.formatstring(password)])
    DBhelp.closedb()
    role = ''
    userpower = ''
    if col > 0:

        validresult = True
        #         role=result[0]['role']
        #         userpower=result[0]['userpower']
        role = 'admin'
        userpower = 'admin'
    return validresult, username, role, userpower
コード例 #12
0
def classupdate(schoolname='',
                schoolid='',
                province='',
                city='',
                starttime=''):

    request_params = []
    values_params = []
    wset_params = []
    wand_params = []
    if schoolname != '':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if schoolid != '':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if province != '':
        request_params.append('province')
        values_params.append(SQLTool.formatstring(province))
    if city != '':
        request_params.append('city')
        values_params.append(SQLTool.formatstring(city))
    if starttime != '':
        request_params.append('starttime')
        values_params.append(SQLTool.formatstring(starttime))
    table = localconfig.schooltable
    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()

    tempresult = DBhelp.updatetableinfo_byparams([table], request_params,
                                                 values_params, wset_params,
                                                 wand_params)
    DBhelp.closedb()

    return tempresult
コード例 #13
0
def schooladd(school):
    schoolname=school.getSchoolname()
    schoolid=school.getSchoolid()
    province=school.getProvince()
    city=school.getCity()
    starttime=school.getStarttime()



    request_params=[]
    values_params=[]
    if schoolname!='':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if schoolid!='':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if province!='':
        request_params.append('province')
        values_params.append(SQLTool.formatstring(province))
    if city!='':
        request_params.append('city')
        values_params.append(SQLTool.formatstring(city))
    if starttime!='':
        request_params.append('starttime')
        values_params.append(SQLTool.formatstring(starttime))      
    table=localconfig.schooltable
    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()

    tempresult=DBhelp.inserttableinfo_byparams(table=table, select_params=request_params,insert_values= [tuple(values_params)])

    DBhelp.closedb()

    return tempresult
コード例 #14
0
def loadclasstake(path):
    
    data=xlstool.getdata(path, u'上课表')
    classdata=[]
    for i in data:
        temp=list(i)
        classid=uuid.uuid1()
        print classid
#         temp.append('classid')
        classdata.append((temp[0],temp[1],temp[2],temp[3]))

          
    sqlhelp=SQLTool.getObject()
    sqlhelp.connectdb()
    result=sqlhelp.inserttableinfo_byparams(config.Config.teachtable, ['teacherId','classId','masterId','time'], classdata)

    return result
コード例 #15
0
def loadclasstake(path):

    data = xlstool.getdata(path, u'上课表')
    classdata = []
    for i in data:
        temp = list(i)
        classid = uuid.uuid1()
        print classid
        #         temp.append('classid')
        classdata.append((temp[0], temp[1], temp[2], temp[3]))

    sqlhelp = SQLTool.getObject()
    sqlhelp.connectdb()
    result = sqlhelp.inserttableinfo_byparams(
        config.Config.teachtable, ['teacherId', 'classId', 'masterId', 'time'],
        classdata)

    return result
コード例 #16
0
def schoolshow(schoolname='',schoolid='',province='',city='',starttime='',page='0'):
    validresult=False
    request_params=[]
    values_params=[]
    if schoolname!='':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if schoolid!='':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if province!='':
        request_params.append('province')
        values_params.append(SQLTool.formatstring(province))
    if city!='':
        request_params.append('city')
        values_params.append(SQLTool.formatstring(city))
    if starttime!='':
        request_params.append('starttime')
        values_params.append(SQLTool.formatstring(starttime))

    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    table=localconfig.schooltable
    result,content,count,col=DBhelp.searchtableinfo_byparams([table], ['schoolName','schoolId','province','city'], request_params, values_params)

    if count == 0:
        pagecount = 0;
    elif count %limitpage> 0:
#         pagecount = math.ceil(count / limitpage)
        pagecount=int((count+limitpage-1)/limitpage) 


    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount>0:
    
        limit='    limit  '+str(int(page)*limitpage)+','+str(limitpage)
        result,content,count,col=DBhelp.searchtableinfo_byparams([table], ['schoolName','schoolId','province','city'], request_params, values_params,limit,order='schoolId desc')
    
        DBhelp.closedb()
        schools=[]
        if count>0:
            validresult=True
            for temp in result :
                aschool=school.School(schoolname=temp['schoolName'],schoolid=temp['schoolId'],province=temp['province'],city=temp['city'])

#                 ajob=school.Job(username=temp[0],jobid=temp[1],jobname=temp[2],priority=temp[3],jobstatus=temp[4],starttime=temp[5],jobaddress=temp[6],jobport=temp[7],result=temp[8],endtime=temp[9],createtime=temp[10],forcesearch=temp[11])
                schools.append(aschool)
        return schools,count,pagecount
    return [],0,pagecount
コード例 #17
0
def loadclass(path):
    
    data=xlstool.getdata(path, u'班级')
    classdata=[]
    classnamedata=[]
    for i in data:
        temp=list(i)
        classid=uuid.uuid1()
        print classid
#         temp.append('classid')
        classdata.append((temp[0],temp[1],temp[2],classid))
        classnamedata.append((temp[3],classid))

          
    sqlhelp=SQLTool.getObject()
    sqlhelp.connectdb()
    result=sqlhelp.inserttableinfo_byparams(config.Config.classtable, ['schoolId','gradeId','cid','classId'], classdata)
    if result:
        result=sqlhelp.inserttableinfo_byparams(config.Config.classnametable, ['className','classId'], classnamedata)
 
    return result
コード例 #18
0
def loadclass(path):

    data = xlstool.getdata(path, u'班级')
    classdata = []
    classnamedata = []
    for i in data:
        temp = list(i)
        classid = uuid.uuid1()
        print classid
        #         temp.append('classid')
        classdata.append((temp[0], temp[1], temp[2], classid))
        classnamedata.append((temp[3], classid))

    sqlhelp = SQLTool.getObject()
    sqlhelp.connectdb()
    result = sqlhelp.inserttableinfo_byparams(
        config.Config.classtable, ['schoolId', 'gradeId', 'cid', 'classId'],
        classdata)
    if result:
        result = sqlhelp.inserttableinfo_byparams(config.Config.classnametable,
                                                  ['className', 'classId'],
                                                  classnamedata)

    return result
コード例 #19
0
def validuser(username,password):
    validresult=False
    password=webtool.md5(password)
    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    result,content,count,col=DBhelp.searchtableinfo_byparams([localconfig.usertable], ['userName','password','userid'], ['userName','password'], [SQLTool.formatstring(username),SQLTool.formatstring(password)])
    DBhelp.closedb()
    role=''
    userpower=''
    if col>0:
        
        validresult=True
#         role=result[0]['role']
#         userpower=result[0]['userpower']
        role='admin'
        userpower='admin'
    return validresult,username,role,userpower
    
コード例 #20
0
def studentshow(studentid='',
                name='',
                sex='',
                birthday='',
                address='',
                familyPhone='',
                mail='',
                family='',
                admissionTime='',
                nation='',
                placeOfOrigin='',
                team='',
                classid='',
                page='0'):
    validresult = False
    request_params = []
    values_params = []
    if studentid != '':
        request_params.append('t_student.studentId')
        values_params.append(SQLTool.formatstring(studentid))
    if name != '':
        request_params.append('name')
        values_params.append(SQLTool.formatstring(name))
    if sex != '':
        request_params.append('sex')
        values_params.append(SQLTool.formatstring(sex))
    if birthday != '':
        request_params.append('birthday')
        values_params.append(SQLTool.formatstring(birthday))
    if address != '':
        request_params.append('address')
        values_params.append(SQLTool.formatstring(address))
    if familyPhone != '':
        request_params.append('familyPhone')
        values_params.append(SQLTool.formatstring(familyPhone))
    if mail != '':
        request_params.append('mail')
        values_params.append(SQLTool.formatstring(mail))
    if family != '':
        request_params.append('family')
        values_params.append(SQLTool.formatstring(family))
    if admissionTime != '':
        request_params.append('admissionTime')
        values_params.append(SQLTool.formatstring(admissionTime))
    if nation != '':
        request_params.append('nation')
        values_params.append(SQLTool.formatstring(nation))

    if placeOfOrigin != '':
        request_params.append('placeOfOrigin')
        values_params.append(SQLTool.formatstring(placeOfOrigin))
    if team != '':
        request_params.append('team')
        values_params.append(SQLTool.formatstring(team))
    if classid != '':
        request_params.append('t_students_attend_class.classId')
        values_params.append(SQLTool.formatstring(classid))

    request_params.append('t_students_attend_class.studentId')
    values_params.append('t_student.studentId')

    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()
    table = localconfig.studenttable
    result, content, count, col = DBhelp.searchtableinfo_byparams(
        [table, localconfig.student_attend_table], [
            't_student.studentId', 'name', 'sex', 'birthday', 'address',
            'familyPhone', 'mail', 'family', 'admissionTime', 'nation',
            'placeOfOrigin', 'team', 't_students_attend_class.classId'
        ], request_params, values_params)

    if count == 0:
        pagecount = 0
    elif count % limitpage > 0:
        #         pagecount = math.ceil(count / limitpage)
        pagecount = int((count + limitpage - 1) / limitpage)

    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount > 0:

        limit = '    limit  ' + str(
            int(page) * limitpage) + ',' + str(limitpage)
        result, content, count, col = DBhelp.searchtableinfo_byparams(
            [table, localconfig.student_attend_table], [
                't_student.studentId', 'name', 'sex', 'birthday', 'address',
                'familyPhone', 'mail', 'family', 'admissionTime', 'nation',
                'placeOfOrigin', 'team', 't_students_attend_class.classId'
            ],
            request_params,
            values_params,
            limit,
            order=' time desc ,t_student.studentId desc')

        DBhelp.closedb()
        students = []
        if count > 0:
            validresult = True
            for temp in result:
                astudent = student.Student(studentid=temp['studentId'],
                                           name=temp['name'],
                                           address=temp['address'],
                                           familyPhone=temp['familyPhone'],
                                           classid=temp['classId'],
                                           family=temp['family'])

                students.append(astudent)
        return students, count, pagecount
    return [], 0, pagecount
コード例 #21
0
def teachershow(id='',evaluationobject='',evaluationscore='',type='',time='',week='',page='0'):
    validresult=False
    request_params=[]
    values_params=[]
    if id!='':
        request_params.append('studentId')
        values_params.append(SQLTool.formatstring(id))
    if evaluationobject!='':
        request_params.append('teacherId')
        values_params.append(SQLTool.formatstring(evaluationobject))
    if evaluationscore!='':
        request_params.append('evaluationScore')
        values_params.append(SQLTool.formatstring(evaluationscore))
    if type!='':
        request_params.append('t_student_evaluation.type')
        values_params.append(SQLTool.formatstring(type))
    if time!='':
        request_params.append('time')
        values_params.append(SQLTool.formatstring(time))
    if week!='':
        request_params.append('week')
        values_params.append(SQLTool.formatstring(week))
   

    request_params.append('contentEvaluationId')
    values_params.append('contentId')


    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    table=localconfig.tevaluation_table
    extra=' and yn=0 union select studentId,teacherId,evaluationScore,t_teacher_evaluation.type,time,week,content from t_content_evaluation,t_teacher_evaluation,t_evaluation_template where contentEvaluationId=contentId and contentId=t_evaluation_template.templateId and yn=1'
    result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.cevaluation_table], ['studentId','teacherId','evaluationScore','t_teacher_evaluation.type','time','week','contentEvaluation'], request_params, values_params,extra=extra)

    if count == 0:
        pagecount = 0;
    elif count %limitpage> 0:
#         pagecount = math.ceil(count / limitpage)
        pagecount=int((count+limitpage-1)/limitpage) 


    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount>0:
    
        limit='    limit  '+str(int(page)*limitpage)+','+str(limitpage)
        result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.cevaluation_table], ['studentId','teacherId','evaluationScore','t_teacher_evaluation.type','time','week','contentEvaluation'], request_params, values_params,limit,extra=extra,order=' time desc')

        DBhelp.closedb()
        evaluations=[]
        if count>0:
            validresult=True
            for temp in result :
                aevaluation=evaluation.Evaluation(id=temp['studentId'],evaluationobject=temp['teacherId'],evaluationscore=temp['evaluationScore'],type=temp['type'],time=temp['time'],week=temp['week'],content=temp['contentEvaluation'])


                evaluations.append(aevaluation)
        return evaluations,count,pagecount
    return [],0,pagecount
コード例 #22
0
def studentshow(studentid='',name='',sex='',birthday='',address='',familyPhone='',mail='',family='',admissionTime='',nation='',placeOfOrigin='',team='',classid='',page='0'):
    validresult=False
    request_params=[]
    values_params=[]
    if studentid!='':
        request_params.append('t_student.studentId')
        values_params.append(SQLTool.formatstring(studentid))
    if name!='':
        request_params.append('name')
        values_params.append(SQLTool.formatstring(name))
    if sex!='':
        request_params.append('sex')
        values_params.append(SQLTool.formatstring(sex))
    if birthday!='':
        request_params.append('birthday')
        values_params.append(SQLTool.formatstring(birthday))
    if address!='':
        request_params.append('address')
        values_params.append(SQLTool.formatstring(address))
    if familyPhone!='':
        request_params.append('familyPhone')
        values_params.append(SQLTool.formatstring(familyPhone))
    if mail!='':
        request_params.append('mail')
        values_params.append(SQLTool.formatstring(mail))
    if family!='':
        request_params.append('family')
        values_params.append(SQLTool.formatstring(family))
    if admissionTime!='':
        request_params.append('admissionTime')
        values_params.append(SQLTool.formatstring(admissionTime))
    if nation!='':
        request_params.append('nation')
        values_params.append(SQLTool.formatstring(nation))
        
    if placeOfOrigin!='':
        request_params.append('placeOfOrigin')
        values_params.append(SQLTool.formatstring(placeOfOrigin))
    if team!='':
        request_params.append('team')
        values_params.append(SQLTool.formatstring(team))
    if classid!='':
        request_params.append('t_students_attend_class.classId')
        values_params.append(SQLTool.formatstring(classid))

    request_params.append('t_students_attend_class.studentId')
    values_params.append('t_student.studentId')


    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    table=localconfig.studenttable
    result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.student_attend_table], ['t_student.studentId','name','sex','birthday','address','familyPhone','mail','family','admissionTime','nation','placeOfOrigin','team','t_students_attend_class.classId'], request_params, values_params)

    if count == 0:
        pagecount = 0;
    elif count %limitpage> 0:
#         pagecount = math.ceil(count / limitpage)
        pagecount=int((count+limitpage-1)/limitpage) 


    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount>0:
    
        limit='    limit  '+str(int(page)*limitpage)+','+str(limitpage)
        result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.student_attend_table], ['t_student.studentId','name','sex','birthday','address','familyPhone','mail','family','admissionTime','nation','placeOfOrigin','team','t_students_attend_class.classId'], request_params, values_params,limit,order=' time desc ,t_student.studentId desc')

        DBhelp.closedb()
        students=[]
        if count>0:
            validresult=True
            for temp in result :
                astudent=student.Student(studentid=temp['studentId'],name=temp['name'],address=temp['address'],familyPhone=temp['familyPhone'],classid=temp['classId'],family=temp['family'])


                students.append(astudent)
        return students,count,pagecount
    return [],0,pagecount
コード例 #23
0
def familyshow(id='',
               evaluationobject='',
               evaluationscore='',
               type='',
               time='',
               week='',
               page='0'):
    validresult = False
    request_params = []
    values_params = []
    if id != '':
        request_params.append('studentId')
        values_params.append(SQLTool.formatstring(id))
    if evaluationobject != '':
        request_params.append('teacherId')
        values_params.append(SQLTool.formatstring(evaluationobject))
    if evaluationscore != '':
        request_params.append('evaluationScore')
        values_params.append(SQLTool.formatstring(evaluationscore))
    if type != '':
        request_params.append('t_student_evaluation.type')
        values_params.append(SQLTool.formatstring(type))
    if time != '':
        request_params.append('time')
        values_params.append(SQLTool.formatstring(time))
    if week != '':
        request_params.append('week')
        values_params.append(SQLTool.formatstring(week))

    request_params.append('contentEvaluationId')
    values_params.append('contentId')

    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()
    table = localconfig.fevaluation_table
    extra = ' and yn=0 union select studentId,parentid,evaluationScore,t_family_evaluation.type,time,week,content from t_content_evaluation,t_family_evaluation,t_evaluation_template where contentEvaluationId=contentId and contentId=t_evaluation_template.templateId and yn=1'
    result, content, count, col = DBhelp.searchtableinfo_byparams(
        [table, localconfig.cevaluation_table], [
            'studentId', 'parentid', 'evaluationScore',
            't_family_evaluation.type', 'time', 'week', 'contentEvaluation'
        ],
        request_params,
        values_params,
        extra=extra)

    if count == 0:
        pagecount = 0
    elif count % limitpage > 0:
        #         pagecount = math.ceil(count / limitpage)
        pagecount = int((count + limitpage - 1) / limitpage)

    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount > 0:

        limit = '    limit  ' + str(
            int(page) * limitpage) + ',' + str(limitpage)
        result, content, count, col = DBhelp.searchtableinfo_byparams(
            [table, localconfig.cevaluation_table], [
                'studentId', 'parentid', 'evaluationScore',
                't_family_evaluation.type', 'time', 'week', 'contentEvaluation'
            ],
            request_params,
            values_params,
            limit,
            extra=extra,
            order=' time desc')

        DBhelp.closedb()
        evaluations = []
        if count > 0:
            validresult = True
            for temp in result:
                aevaluation = evaluation.Evaluation(
                    id=temp['studentId'],
                    evaluationobject=temp['parentid'],
                    evaluationscore=temp['evaluationScore'],
                    type=temp['type'],
                    time=temp['time'],
                    week=temp['week'],
                    content=temp['contentEvaluation'])

                evaluations.append(aevaluation)
        return evaluations, count, pagecount
    return [], 0, pagecount
コード例 #24
0
def haveclassshow(schoolid='', classid='', teacherid='', page='0'):
    validresult = False
    request_params = []
    values_params = []
    if schoolid != '':
        request_params.append('schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if classid != '':
        request_params.append('t_classes.classId')
        values_params.append(SQLTool.formatstring(classid))
    if teacherid != '':
        request_params.append('teacherId')
        values_params.append(SQLTool.formatstring(teacherid))

    request_params.append('t_teach.teacherId')
    values_params.append('t_teachers.teacherId')

    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()
    table = localconfig.teachertable
    result, content, count, col = DBhelp.searchtableinfo_byparams(
        [table, localconfig.teachtable], [
            't_teachers.teacherId', 'masterId', 'time', 'schoolId',
            'teacherName', 'classId'
        ], request_params, values_params)

    if count == 0:
        pagecount = 0
    elif count % limitpage > 0:
        #         pagecount = math.ceil(count / limitpage)
        pagecount = int((count + limitpage - 1) / limitpage)

    else:
        pagecount = count / limitpage


#     print pagecount
    if pagecount > 0:

        limit = '    limit  ' + str(
            int(page) * limitpage) + ',' + str(limitpage)
        result, content, count, col = DBhelp.searchtableinfo_byparams(
            [table, localconfig.teachtable], [
                't_teachers.teacherId', 'masterId', 'time', 'schoolId',
                'teacherName', 'classId'
            ],
            request_params,
            values_params,
            limit,
            order='time desc')

        DBhelp.closedb()
        classes = []
        if count > 0:
            validresult = True
            for temp in result:
                aclass = takeclass.Takeclass(teacherid=temp['teacherId'],
                                             schoolid=temp['schoolId'],
                                             masterid=temp['masterId'],
                                             time=temp['time'],
                                             teachername=temp['teacherName'],
                                             classid=temp['classId'])

                classes.append(aclass)
        return classes, count, pagecount
    return [], 0, pagecount
コード例 #25
0
def teachershow(schoolid='',
                teacherid='',
                name='',
                phone='',
                offer='',
                job='',
                schoolname='',
                page='0'):
    validresult = False
    request_params = []
    values_params = []
    if schoolid != '':
        request_params.append('t_teachers.schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if teacherid != '':
        request_params.append('teacherId')
        values_params.append(SQLTool.formatstring(teacherid))
    if name != '':
        request_params.append('teacherName')
        values_params.append(SQLTool.formatstring(name))
    if phone != '':
        request_params.append('teacherPhone')
        values_params.append(SQLTool.formatstring(phone))
    if offer != '':
        request_params.append('offer')
        values_params.append(SQLTool.formatstring(offer))
    if job != '':
        request_params.append('jobTitle')
        values_params.append(SQLTool.formatstring(job))
    if schoolname != '':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))

    request_params.append('t_school.schoolId')
    values_params.append('t_teachers.schoolId')

    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()
    table = localconfig.teachertable
    result, content, count, col = DBhelp.searchtableinfo_byparams(
        [table, localconfig.schooltable], [
            't_teachers.schoolId', 'teacherId', 'teacherName', 'teacherPhone',
            'offer', 'jobTitle', 'schoolName'
        ], request_params, values_params)

    if count == 0:
        pagecount = 0
    elif count % limitpage > 0:
        #         pagecount = math.ceil(count / limitpage)
        pagecount = int((count + limitpage - 1) / limitpage)

    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount > 0:

        limit = '    limit  ' + str(
            int(page) * limitpage) + ',' + str(limitpage)
        result, content, count, col = DBhelp.searchtableinfo_byparams(
            [table, localconfig.schooltable], [
                't_teachers.schoolId', 'teacherId', 'teacherName',
                'teacherPhone', 'offer', 'jobTitle', 'schoolName'
            ],
            request_params,
            values_params,
            limit,
            order=' teacherId desc')

        DBhelp.closedb()
        teachers = []
        if count > 0:
            validresult = True
            for temp in result:
                ateacher = teacher.Teacher(schoolid=temp['schoolId'],
                                           teacherid=temp['teacherId'],
                                           name=temp['teacherName'],
                                           phone=temp['teacherPhone'],
                                           offer=temp['offer'],
                                           job=temp['jobTitle'],
                                           schoolname=temp['schoolName'])

                teachers.append(ateacher)
        return teachers, count, pagecount
    return [], 0, pagecount
コード例 #26
0
def classshow(schoolname='',
              schoolid='',
              gradeid='',
              classid='',
              classname='',
              page='0'):
    validresult = False
    request_params = []
    values_params = []
    if schoolname != '':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
    if gradeid != '':
        request_params.append('t_classes.gradeId')
        values_params.append(SQLTool.formatstring(gradeid))
    if classid != '':
        request_params.append('t_classes.classId')
        values_params.append(SQLTool.formatstring(classid))
    if classname != '':
        request_params.append('t_class_name.className')
        values_params.append(SQLTool.formatstring(classname))
    if schoolid != '':
        request_params.append('t_classes.schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    request_params.append('t_school.schoolId')
    values_params.append('t_classes.schoolId')
    request_params.append('t_classes.classId')
    values_params.append('t_class_name.classId')

    DBhelp = SQLTool.DBmanager()
    DBhelp.connectdb()
    table = localconfig.schooltable
    result, content, count, col = DBhelp.searchtableinfo_byparams(
        [table, localconfig.classtable, localconfig.classnametable], [
            'schoolName', 't_classes.schoolId', 't_classes.gradeId', 'cId',
            't_class_name.className', 't_classes.classId'
        ], request_params, values_params)

    if count == 0:
        pagecount = 0
    elif count % limitpage > 0:
        #         pagecount = math.ceil(count / limitpage)
        pagecount = int((count + limitpage - 1) / limitpage)

    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount > 0:

        limit = '    limit  ' + str(
            int(page) * limitpage) + ',' + str(limitpage)
        result, content, count, col = DBhelp.searchtableinfo_byparams(
            [table, localconfig.classtable, localconfig.classnametable], [
                'schoolName', 't_classes.schoolId', 't_classes.gradeId', 'cId',
                't_class_name.className', 't_classes.classId'
            ],
            request_params,
            values_params,
            limit,
            order='schoolId desc')

        DBhelp.closedb()
        classes = []
        if count > 0:
            validresult = True
            for temp in result:
                aclass = Class.Class(schoolname=temp['schoolName'],
                                     schoolid=temp['schoolId'],
                                     gradeid=temp['gradeId'],
                                     cid=temp['cId'],
                                     classname=temp['className'],
                                     classid=temp['classId'])

                classes.append(aclass)
        return classes, count, pagecount
    return [], 0, pagecount
コード例 #27
0
def teachershow(schoolid='',teacherid='',name='',phone='',offer='',job='',schoolname='',page='0'):
    validresult=False
    request_params=[]
    values_params=[]
    if schoolid!='':
        request_params.append('t_teachers.schoolId')
        values_params.append(SQLTool.formatstring(schoolid))
    if teacherid!='':
        request_params.append('teacherId')
        values_params.append(SQLTool.formatstring(teacherid))
    if name!='':
        request_params.append('teacherName')
        values_params.append(SQLTool.formatstring(name))
    if phone!='':
        request_params.append('teacherPhone')
        values_params.append(SQLTool.formatstring(phone))
    if offer!='':
        request_params.append('offer')
        values_params.append(SQLTool.formatstring(offer))
    if job!='':
        request_params.append('jobTitle')
        values_params.append(SQLTool.formatstring(job))
    if schoolname!='':
        request_params.append('schoolName')
        values_params.append(SQLTool.formatstring(schoolname))
   
    request_params.append('t_school.schoolId')
    values_params.append('t_teachers.schoolId')


    DBhelp=SQLTool.DBmanager()
    DBhelp.connectdb()
    table=localconfig.teachertable
    result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.schooltable], ['t_teachers.schoolId','teacherId','teacherName','teacherPhone','offer','jobTitle','schoolName'], request_params, values_params)

    if count == 0:
        pagecount = 0;
    elif count %limitpage> 0:
#         pagecount = math.ceil(count / limitpage)
        pagecount=int((count+limitpage-1)/limitpage) 


    else:
        pagecount = count / limitpage

#     print pagecount
    if pagecount>0:
    
        limit='    limit  '+str(int(page)*limitpage)+','+str(limitpage)
        result,content,count,col=DBhelp.searchtableinfo_byparams([table,localconfig.schooltable], ['t_teachers.schoolId','teacherId','teacherName','teacherPhone','offer','jobTitle','schoolName'], request_params, values_params,limit,order=' teacherId desc')

        DBhelp.closedb()
        teachers=[]
        if count>0:
            validresult=True
            for temp in result :
                ateacher=teacher.Teacher(schoolid=temp['schoolId'],teacherid=temp['teacherId'],name=temp['teacherName'],phone=temp['teacherPhone'],offer=temp['offer'],job=temp['jobTitle'],schoolname=temp['schoolName'])


                teachers.append(ateacher)
        return teachers,count,pagecount
    return [],0,pagecount