Need custom Wordpress plugin to update local database and PFsense via VPN
Budget: $50 – $0 USD
I need a Wordpress plugin that will take user information (via WooCommerce and/or PropertyHive plugin) for an office/coworking space and input it into a local Access database for access control that allows people to open RFID/passcode doors. The software works off ZKAccess (https://www.zkteco.com/en/product_detail/ZKAccess3.5.html) and it uses a local database (Access or MS SQL) to store key card IDs and passcodes for each user as well as which doors they can access. Database is straightforward (attached) with text inputs for user and password (sample attached). The building is small and will only have 4 doors to control and two user groups.
The plugin will need to take the user information from website sign up (will be a subscription model for monthly rent or additional offerings) and input it in the correct fields in a local access database to provide the user with a door access code upon sign up. A local VPN will be set up to allow database connection. Then a user should be able to edit their passcode through their Wordpress profile. Additionally, the plugin should connect remotely to a pfSense instance (https://www.pfsense.org/) to create a new captive portal login and password for local wifi that is then displayed to the new user.
The plugin should also automatically restrict access within the door access database and wifi access if an account is disabled on Wordpress, either from admin input or through automatic action secondary to nonpayment of rent or fees.
The plugin will need to take the user information from website sign up (will be a subscription model for monthly rent or additional offerings) and input it in the correct fields in a local access database to provide the user with a door access code upon sign up. A local VPN will be set up to allow database connection. Then a user should be able to edit their passcode through their Wordpress profile. Additionally, the plugin should connect remotely to a pfSense instance (https://www.pfsense.org/) to create a new captive portal login and password for local wifi that is then displayed to the new user.
The plugin should also automatically restrict access within the door access database and wifi access if an account is disabled on Wordpress, either from admin input or through automatic action secondary to nonpayment of rent or fees.