I want to make a WordPress plugin that uses a form in the frontend to look up values from 2 tables. The backend allows creating, editing and import of values for 2 tables.
The frontend form field makes use of the Google Places API to autocomplete addresses.
-A one field form that looks up address. We use the Google Places API to filter addresses. After user picks an address, the post code from the address is filtered using the Google Maps API.
-User presses "Check" button. According to post code and individual address, results are shown about which services are available. Individual address services take priority over post code services (see 2 tables in backend).
-The results are displayed as a table. Each service is a row in the table.
-A form to enquire is always shown under the results area. It asks for First Name, Last Name, Email, Phone, Company, How Did You Hear about Us?. Form is verified. First Name, Last Name, Email, Phone are compulsory fields.
-Verify email address according to format and with DNS lookup (e.g. -[login to view URL] )
-Address is passed with the other form fields in an email to website owner.
-In the backend, the 1st table is a table of post codes and services that can be edited. The table is a list of post codes and the internet services available for that post code.
-A 2nd table is a list of addresses. These are individual addresses and the services available to them. The service list is the same as the service list in the table of post codes. This allows control over individual addresses within a post code.
-Each post code is one row of the 1st table.
-Each individual address is one row in the 2nd table.
-Each column in both tables is one service.
-About 20 services will be available, so please make sure
-For each post code (row) there is a checkbox for if the service is available or not.
-An Update button saves any changes to checkboxes, rows and columns.
-New post code rows can be added to the list.
-New service columns can be added to the list.
-The list is paginated. e.g. 100 per page
-A list of post codes and services can be exported and imported as a csv file (or alternatively an xls/xlsx file if that is a better development choice - developer will choose what is appropriate).