We using RFID and Biometric devices to mark attendance of school/college students.
The students carry RFID cards with them and enter the school/college. When they come in range with our devices, their ID is captured and sent to a TCP/IP port on our server. The captured data contains ID of the student and the time and date when the ID was captured.
We need a php-mysql based web application which will get data from the server port and mark attendance of the students and send SMS accordingly. Four types of SMS should be sent according to the situation.
Entry SMS - When the child enters the school/college. This SMS will be like - Your child $studentname entered school at $in_time on $date.
Exit SMS - Your child $studentname exited school at $out_time on $date.
Late Entry SMS - This SMS will be like - Your child $studentname entered school at $in_time on $date and has been marked as late.
The application should have fields to enter the range of time after which the student will be marked as late. For example: If the IN Time is from 8AM to 8:30 AM and the data is received after 8:30AM, the Late Entry SMS should be sent.
Absent SMS - This SMS should be sent if no data is received for a particular student. This SMS will be like - $studentname has been marked as absent on $date
The application should have options to take data in bulk through excel sheet. The data will consist of Student's Name, Parent's Name, Parent's Mobile Number, Class etc. The attendance data can be exported/printed easily based on day, week, month, class, section, year etc. It should have user roles so that only particular people can view attendance data and edit settings from the backend. The front end has to be beautiful with proper customization options for clients. SMS gateway API will be provided for easy SMS integration. These are not the only requirements, more features will be discussed and required as the project proceeds.
We are currently using a system based on a different language and a screenshot of the configuration page is attached to give more idea. [url removed, login to view]
You can sign up for a demo account at https://www.myattendancetracker.com to get some idea of the layout that is required.