Ejemplo n.º 1
0
    def POST(self):
        disdir = os.path.join(os.getcwd(),'files')
        x= web.input(datafile={})
        
        # asmt = x.asmt.lower()
        # year = x.year
        # std = x.std
        # section = x.section
        # sub = x.subject
        # max = int(x.max)
        a = ('year','section','assessment','percent')

        if 'datafile' in x:
            filename = x.datafile.filename
            f = open(os.path.join(disdir,filename),'w')
            f.write(x.datafile.file.read())
            f.close()
            book = xlrd.open_workbook(os.path.join(disdir,filename))
            sheet = book.sheet_by_index(0)
            # print sheet
            for rownum in range(sheet.nrows):
                # if rownum == 0: continue
                row = sheet.row_values(rownum)
                if row[0].lower() == 'year':
                    year = row[0].lower()
                    continue
                if row[0].lower() == 'standard':
                    std = row[0].lower()
                    continue
                if row[0].lower() == 'section':
                    section = row[0].lower()
                    continue
                if row[0].lower() == 'assessment':
                    asmt = row[0].lower()
                    continue
                if row[0].lower() == 'percent':
                    per = row[0].lower()
                    continue
                if row[0].lower() == 'marks': continue
                if row[0].lower() == 'sl': continue
                name = row[1]
                adnum = row[2]
                english = float(row[3])
                seclang = float(row[4])
                maths = float(row[5])
                science = float(row[6])
                social = float(row[7])
                studentid = model.getStudentId(year,std,section,adnum,name)
                
                fields =  model.asmts[asmt]['fields']
                forten = conv.toten(mark,max)
                grade = conv.grade(conv.tocent(mark,max))
                per = conv.getContri(asmt,forten)
                data = [mark,max,grade,per]
                markid = model.getMarkId(studentid,sub,year,std,section)
                
                model.updateMark(markid,fields,data)
                
        raise web.seeother('/upload')
Ejemplo n.º 2
0
    def POST(self):
        q = web.input()
        markid = int(q.markid)
        marks = model.getMarksByMarkId(markid)
        ret = {}
        ret = {'fields':{},'id':0, 'status': False}
        render = web.template.render('templates/', base=None,globals={'context':session})
        
        if 'fa1_m' in q:
            fa1_m = float(q.fa1_m)
            forten = conv.toten(fa1_m,marks['fa1_o'])
            grade = conv.grade(conv.tocent(fa1_m,marks['fa1_o']))
            per = conv.getContri('fa1',forten)
            fields = model.asmts['fa1']['fields']
            data= [fa1_m,marks['fa1_o'],grade,per]
            model.updateMark(markid,fields,data)
            ret['fields'] = {'fa1_m':fa1_m,'fa1_g':grade,'fa1_p': per}
            ret['id'] = markid
            ret['status'] = True
            
        if 'fa2_m' in q:
            fa2_m = float(q.fa2_m)
            forten = conv.toten(fa2_m,marks['fa2_o'])
            grade = conv.grade(forten)
            per = conv.getContri('fa2',forten)
            fields = model.asmts['fa2']['fields']
            data = [fa2_m,marks['fa2_o'],grade,per]
            model.updateMark(markid,fields,data)
            ret['fields'] = {'fa2_m':fa2_m,'fa2_g':grade,'fa2_p': per}
            ret['id'] = markid
            ret['status'] = True
            
        if 'sa1_m' in q:
            sa1_m = float(q.sa1_m)
            forten = conv.toten(sa1_m,marks['sa1_o'])
            grade = conv.grade(forten)
            per = conv.getContri('sa1_m',forten)
            fields = model.asmts['sa1']['fields']
            data= [sa1_m,marks['sa1_o'],grade,per]
            model.updateMark(markid,fields,data)
            ret['fields'] = {'sa1_m':sa1_m,'sa1_g':grade,'sa1_p': per}
            ret['id'] = markid
            ret['status'] = True

        if 'fa3_m' in q:
            fa3_m = float(q.fa3_m)
            forten = conv.toten(fa3_m,marks['fa3_o'])
            grade = conv.grade(forten)
            per = conv.getContri('fa3_m',forten)
            fields = model.asmts['fa3']['fields']
            data= [fa3_m,marks['fa3_o'],grade,per]
            model.updateMark(markid,fields,data)
            ret['fields'] = {'fa3_m':fa3_m,'fa3_g':grade,'fa3_p': per}
            ret['id'] = markid
            ret['status'] = True
            
        if 'fa4_m' in q:
            fa4_m = float(q.fa4_m)
            forten = conv.toten(fa4_m,marks['fa4_o'])
            grade = conv.grade(forten)
            per = conv.getContri('fa4_m',forten)
            fields = model.asmts['fa4']['fields']
            data=[fa4_m,marks['fa4_o'],grade,per]
            model.updateMark(markid,fields,data)
            ret['fields'] = {'fa4_m':fa4_m,'fa4_g':grade,'fa3_p': per}
            ret['id'] = markid
            ret['status'] = True
            
        if 'sa2_m' in q:
            sa2_m = float(q.sa2_m)
            forten = conv.toten(sa2_m,marks['sa2_o'])
            grade = conv.grade(forten)
            per = conv.getContri('sa2_m',forten)
            fields = model.asmts['sa2']['fields']
            data= [sa2_m,marks['sa2_o'],grade,per]
            model.updateMark(markid,fields,data)
            ret['fields'] = {'sa2_m':fa4_m,'sa2_g':grade,'sa23_p': per}
            ret['id'] = markid
            ret['status'] = True
            
        web.header("Content-Type","text/json;charset=utf-8")
        return render.savemark(simplejson.dumps(ret))