Door lock with 2.4 TFT and 512k eeprom and log send to server.
In our company have door lock, but this door lock can store only 100 card ID. But this is not enough. I made more usefull door lock system, with ESP32.
Rfid reader is: Innovations ID-12.
To clear all data on database: Magnet and reed relay.
If card ID is not in database, then door is still lock, when ID is in the data base, then door is open.
If in programming mode swipe already stored card, then not store this ID in database.
Database structure: The first 2 byte (16bit 64kb addressing) is the index/FAT (how many card stored in the database Big Endian LSB/MSB). This 2 byte clearing when use magnet to activate reed relay.
The log file (CSV) you can open in Microsoft Excel.
All events are logged: restart, eeprom erasing, new card, denied card and granted card.