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
Exemple #2
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
Exemple #3
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
Exemple #4
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
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
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
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
Exemple #8
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
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