**UK FINANCE LEAD AUTO SUBMISSIONS TO ONLINE DATABASE**
**Short Description:** To build and implement a script that auto submits UK finance lead data to a third party online database. Coder has free reign to make further recommendations. FTP Access will be made available as well as access to third party online database plus anything else required.
**The script's function and further details:**
A user enters their details into an online enquiry form for Debt Management services (similar to the form found at [url removed, login to view]). Details are validated server side (client side would be nice too) and, if valid, submitted to an online database, [url removed, login to view] (u: duncan, p: spaghetti45 - please note this is a test database but identical to real version). Admin should be alerted whenever a new lead is submitted. Admin should also be alerted if a lead is rejected and be given the option to review the details and overide the rejection if details appear ok.
It is extremely important all lead data is absolutely correct once it reaches the online database.
The following form fields will be used, similar to [url removed, login to view], * denotes required.
Title* (drop down menu)
Forename* (text >=2 characters, text only)
Surname* (text >=2 characters, text only)
Address Line 1* (alphanumeric)
Address Line 2 (alphanumeric)
Town* (text only)
County (text only)
Postcode* (UK postcode only, see notes below)
Email address* (appropriate email validation)
Preferred phone* (UK phone number only, see notes below)
Mobile Phone (number only, see notes below)
Best time to contact* (drop down menu)
Monthly Household Income* (number only)
Total Owed in £* (number only >=2000)
Number of Debts* (number only)
**UK phone number validation:**
**UK postcode validation:**
**Current setup:** Currently data is being handled using Tectite's Formmail script ([url removed, login to view]). Data is sent via email to admin as well as being stored in a CSV file on the server. Currently all data is manually copied to the Debt Management Lead form found in the [url removed, login to view] database ([url removed, login to view] - u: duncan p: spaghetti45). Coder may choose to continue using this script or find their own.
We're looking to have the system running as soon as possible for testing. Please email questions to Duncan at dunk[at]kenning.demon.co.uk.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
PHP (server running 4.4.2 I believe)