Once a user(employee) comes to our office and touches NFC tag/card, the nfc id has to be passed to main Database, and should search for that id (for one nfc, we assign one id ) in database. And if account found & exist, now automatically a new record has to be created with a combination of date & time figures.
Once record is created, we will need one android app where in we can open that record and pass on 3 more data.(pass or Fail drop down, total money to be paid (manual entry)
Again if that same person comes after 3 hours in the same day and punches nfc card, again that input should go to main database and his account has to be searched and if found exist, again a new record has to be created with the date+time combination. ANd later, one person will go to mobile app, search for that database id and latest record and open it for entering two details(pass/fail, and money to be paid). in to that same newly created record, now we will press save button on phone. These data has to go and save into that record.
Like that a person can come any number of times, but everytime, he punches, a new record has to be created.