Our client is a utility company. They are launching a new service in November. They will systematically roll out service availability in specific geographic areas over the next several months.
We need a function on their website that checks a database to confirm availability when the user enters an address. If service is available, the user is automatically transferred to an ordering page. If service is unavailable, the user is automatically transferred to a "notify me" form that sends an email when service is available in that area.
We also need an administration module that allows the client to turn services addresses "on" in the database.
The client will supply the database of addresses, which contains approx. 18,000 records. Every record will include a? "node" field. The node is the geographic region that is either active or inactive.
Our turn-around time is 2 weeks from when we award the project.