def placeStudent(UID,CT): day = getLectDay() isname = getSfromUID(UID) ClassN = getClass() wb = load_workbook(ClassN+".xlsx") sheetday = wb["Sheet"+str(day)] late = RDC.setTM(getTTime()) starttime = CT time = RDC.getCT() c = 1 r = 5 while(True): student = sheetday.cell(row=r,column=1) if(student.value == isname): sheetday.cell(row=r,column=3).value = UID sheetday.cell(row=r,column=4).value = time if((time-starttime)> late): sheetday.cell(row=r,column=5).value = 0 else: sheetday.cell(row=r,column=5).value = 1 break; else: r = r +1 wb.save(ClassN+".xlsx") return
def scan_in(): UID=EasyProcess('/home/pi/libnfc/libnfc-1.7.1/examples/nfc-poll').call(timeout=10).stdout if(UID): UID = RDC.formatC(UID) lname = XL.getLstudent() XL.addStudent(lname) XL.addUID(UID) RDC.buz() controller.show_frame(EditStudents) else: showerror(title="Error",message="No Card was recorded.") print "time out"
def setClassS(): classStart = RDC.getCT() ClassN = getClass() wb = load_workbook(ClassN+".xlsx") day = getLectDay() sheetday = wb["Sheet"+str(day)] sheetday.cell(row=1,column=2).value = classStart wb.save(ClassN+".xlsx") return
def Upload(): XL.emailCXL() RDC.buz2() RDC.buz2() RDC.buz2() RDC.buz2()
def Start_Class(boo): RDC.setison(boo) RDC.buz() RDC.buz() currentT = RDC.getCT() XL.setClassS() EOC = RDC.getEOC() zero = RDC.setT(0,0) while((EOC-RDC.getCT())>zero): print "time out" if(RDC.getison()): print "3" ext = EasyProcess('/home/pi/libnfc/libnfc-1.7.1/examples/nfc-poll').call(timeout=5).stdout print " 4" if(ext): temp = RDC.formatC(ext) if(temp == "d198290f"): break; XL.placeStudent(temp,currentT) #take photo and record him/her RDC.buz() print("student added") else: RDC.setinc(False) break; RDC.buz() RDC.buz() RDC.buz() XL.incLectDay() day = XL.getLectDay() lecture = XL.getLD() if(day > lecture): showerror(title="Error",message="That was the last day of class.") RDC.setinc(True)