Need some work done? Post a Project Today
The idea is to develop an application that welcomes people at each floor in a building when they go out form the elevator, so in order to make this work we installed long distance identification readers that reads the badges form the people going outside the elevator, so the reader reads the badges and puts the ID number in a MySQL database, also puts a non read flag, the reader and the antena each thing in a different column in the same table. Also there is another table where the same ID is linked to a person name and some other info and there is another table that contains news. So the application needs to keep looking for new registers (looking for the non read flag), and while there is no new registers in one part of the screen should be showing random news form the news table, but once there is a new register the news must go out and welcome by name the person linked to the ID read. The building have 12 readers with one antenna in six floors so each floor have 2 readers, one for each set of elevators, we are going to place a computer each floor, this computer will have two LCD displays connected so the application will be running in two instances in the same computer, one for each monitor and the query must be looking for the nos read flag and the reader + antena in order to pick the right register for each screen, the main lobby will have just 1 LCD an one reader with 2 antenas. So to summary the application must ask for reader and antena when opened, look for news and show that while looking for new registers and when a new register comes up must welcome the person by name show that for a few secs and then go back to show news. The reader can read multiple badges at the same time so there could be a lot of registers new at the same time in a lot of people goes out the elevator, so the application should show form one to five names at the same time and continue in a second block of there are more then 5 people. The application is to impress visitors, so must have very good transitions and effects on the showed text. I will sugest flash to achieve this presentation but other could be used. The screen must have two fixed images (see attached file). I will need the source code very good commented and explained if needed.