Python program with full screen counter and GPIO button interface
Budget: $30 – $250 USD
We need a simplified script written in Python to manage a queue of people with the following features:
- read initial settings (variables) such as client number and department from a local file
- connect to a remote database to fetch the current "turn" number and increase it on the table (MySQL) based on the values previously read from the file
- Initialize full screen and display the current "turn" number in black big font on white background
- Allow for a button to be pressed (by reading the GPIO value from either a Raspberry Pi or an Orange Pi) and advance the number by writing the new number on the MySQL table and updating the screen. Additionally by pressing this button a new entry on a different table should be produced. This will show which button was pressed and when.
- Allow for a different button to be pressed. This second button will save the current number and will fetch it 3 times in the future with red letters in between the regular ascending "turn" numbers. After the third time, this number should not be seen anymore.
- Finally, allow for the existence of several other buttons such as the first (which will also advance the turn but will be registered as a different button on the table that records button presses. The objective of these entries is for analytics.
We can supply additional details such as the structure of the tables, local file with settings, etc.
- read initial settings (variables) such as client number and department from a local file
- connect to a remote database to fetch the current "turn" number and increase it on the table (MySQL) based on the values previously read from the file
- Initialize full screen and display the current "turn" number in black big font on white background
- Allow for a button to be pressed (by reading the GPIO value from either a Raspberry Pi or an Orange Pi) and advance the number by writing the new number on the MySQL table and updating the screen. Additionally by pressing this button a new entry on a different table should be produced. This will show which button was pressed and when.
- Allow for a different button to be pressed. This second button will save the current number and will fetch it 3 times in the future with red letters in between the regular ascending "turn" numbers. After the third time, this number should not be seen anymore.
- Finally, allow for the existence of several other buttons such as the first (which will also advance the turn but will be registered as a different button on the table that records button presses. The objective of these entries is for analytics.
We can supply additional details such as the structure of the tables, local file with settings, etc.