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)