Project Detail

Description

We need a User registration system similar to the one provided at https://www.xero.com/
The back-end needs to be written in PHP / MYSQL.
Preferably it should be be implemented in Adobe Flex with an AMFPHP Backend.
Other solutions will be considered as well.

User input needs to be validated before the registration form can be submitted.
Each email address must be unique and can't exist twice in the database.
The provided email is used as login name and can not be changed later on.
The registration form just needs a standard white background and black foreground colors.

Once a user has filled out all required form items he will get an email confirmation with an activation link.
After clicking on the activation link his account will be enabled and he can log in to the system to review, change his details.

After a user logs in he has the option to buy a monthly recurring subscription that is payable through paypal.
We have 4 products for sale. Each product can be configured with addons.
The price of the monthly subscription will depend on the product and how many addons.

For this to work flexible the implementation needs to be able to read the pricing model from two database tables: products and addons

e.g. products table + content
name | price
product1 | 30
product2 | 40
product3 | 50
product4 | 60

e.g. addons table + content
name | price
addon1 | 10
addon2 | 20

If the payment was successful, the date and the amount of the payment needs to be stored in the user database. If a subscription is canceled the last_payment_date field and last_payment_amount fields need to be set to null


Required fields for sign up form

Title
First Name //required
Last Name //required
Company
email //required, must be unique in database
phone //required

Address //required
Town/City //required
Postcode
Country //required - choose from combobox - use another database table with countries as dataprovider

password
repeat password //passwords must match - min length 5 chars


e.g. client database table fields

id,
title,
firstname,
lastname,
company,
email,
phone,
address,
city,
postcode,
country,
password (SHA1),
application_name,
application_version,
extrastaff,
extrabranch,
register_date,
last_payment_date,
amount_payed
account_activated // 0 or 1