I would like to install lockers (12 locker boxes) which can be used for a certain time and opened by a code entered via a keypad which is only valid during the defined periode.
Hence I require a code developed with the following functionality, hardware setup and by the use of Arduino IDE, Mqtt and SQL.
Description of functionality:
1) The lockers shall be opend and closed by entering the code via one central keypad with display
2) Each locker is locked/unlocked by an electrick lock (controled via relay)
3) Access codes for locker are stored in a SQL database (cloud hosted)
3a) ESP32 downloads and stores localy the SQL database from the cloud every e.g. 5min to also work incase of connection issues
4) The access code shall only be valid during the reservation periode (start, end time) and for a specific locker (l out of 12)
5) ESP32 validates if entered code matches to the code in the SQL database and opens via a relais the correspnding locker.
6) Successful entered code shall be logged (time) to the SQL database, LED (green/ red if wrong) and display shall confirm entered code
Hardware and Software:
- ESP32 shall manage all locker functionalities
- Input via keypad
- Output shall switch on/off relays
- ESP32 shall be connected via GSM-modul (SIM 800L) to Internet (SQL database)
- Prgramm coded with Arduino IDE
- ESP32 shall communicate via MQTT to SQL
- SQL database and MQTT Broker to be setup via Azure or AWS
- Power saving mode esp for GSM modul shall be used (e.g turn off/deep sleep during certain times)
18 freelancer đang chào giá trung bình €331 cho công việc này
Hello, I already have all electronic parts ... so I will give you one tested prototype(breadboard) solution. I invite you continue the discuss on freelancer's chat Thanks
I am ready to work on this project. Please do message me for more details. Note : Directly I will not provide SQL access. But using HTTP API I will provide the data access to the ESP.
hello i have experience of programming many arduino based projects including GSM automation and robotics. I can complete this job in 3 days period. you can contact me if you have any inquiry Regards
i have 3 year experience in arduino and nodemcu .i have done many arduino projects .my last projects was iot based smart parking system with android application and the other was home automation using google assistant