Arduino RFID based Attendance system
Idea - I want some one to built an RFID based system .when student will show the rfid card to system . it must read the card and send the RFID card ID to my mysql database with read time stamp & pre configured Device ID.
Hardware currently Available with me:
Arduino UNO
RFID - MCRC522
Wifi - ESP8266
Breadboard
Keypad - 4x4
LCD - Arduino character LCD 16x2
GSM Module - (not available currently with me, but preferable over Wifi module)
(http://www.amazon.in/Elementz-SIM900A-MODULE-ANTENNA-OUTPUT/dp/B00LE7VHMS/ref=sr_1_2?ie=UTF8&qid=1490039093&sr=8-2&keywords=arduino+gsm)
The whole idea is to create a standalone System.
Requirement:
1. For First Time :
(I). Starting System must ask user to enter 4 digit PIN thru keypad. [this pin must be validated with number mentioned in code. just to avoid misuse.]
(II). After Step (i) , System must ask user to set Device ID, once user input 5 digit number thru keypad , it must be stored in Arduino memory.
FLOW :
Power on Device >> for first time [LCD]- Enter Authentication PIN >> SUCCESS >>
[LCD] Enter 5 digit Device ID >> success message LCD : device configured successfully
2. Once Device ID is set, Arduino should get connected to Internet Server, same should be shown on LCD : Device Ready !! , like that
3. System must display message to user to Show Card,
LCD : Show Card >> Success >> LCD : Thanks
4. Push the read Rfid Tag ID + read TimeStamp + Device ID to my server.
5. Incase no internet connectivity the system should save a cache of read tag data , and push it back to my server as internet connectivity resumes. and clear the cache.
DATABASE TABLE Name :
Table Name : tblrawdata
Columns name will be : ID(primary key), TAGID, Device ID
NOTE : I also need detailed Circuit Diagram of system to connect all components.