Linux OS / Apache Web Server / mySQL Database
A client management system is required for a web development company (we have been putting this off for months as client projects mean we simply do not have the time to complete).
We require a secure web based interface (user logs in with username and password), whereby client details are shown and managed. All data should be saved in an encrypted form.
A list of company names should be shown (25 to a page, with a 'more' link at the bottom of the list to show further names). The user either clicks a name to view client details, clicks on an 'Edit' link that is shown to the right of each company name to edit a client's details, or clicks on one of the two following options, displayed at the top of the screen:
Add Client | Administration
Clicking on 'Add Client' brings up the following fields:
Company Name
Client Name
Address
Telephone Number
Email Address
Main Website URL
Secondary URL's
Hosting Account Setup Date
Website Launch Date
Annual Hosting Cost (excl. VAT)
Website Cost (excl. VAT)
Annual Maintenance Cost (excl. VAT)
Comments / Details
SAVE | RESET
Clicking on 'Edit Client' displays the same fields, but prepopulated, for the user to amend as necessary.
When clicking on a name itself the following details are shown:
Company Name
Client Name
Address
Telephone Number
Email Address
Main Website URL
Secondary URL's
Hosting Account Setup Date
Website Launch Date
Annual Hosting Cost (Excl. VAT)
VAT (17.5%)
Total Recurring Hosting Cost
Website Cost (Excl. VAT)
VAT (17.5%)
Total Website Cost
Annual Maintenance Cost (Excl. VAT)
VAT (17.5%)
Total Recurring Maintenance Cost
Comments / Details
VAT and total costs are calculated automatically by adding 17.5% to the costs added by the user in the 'Add Client' area.
The 'Administration' area has the following fields:
Admin Username
Admin Password
Admin Email Address
Email Reminders [ON | OFF]
Number of days prior to annual charges being due for sending reminder email
Email Subject Line
If email reminders are turned on an email should be sent to the listed admin email address X days before an annual charge is due, listing the full client details, and charges (same format as shown above).
Note that there are often two annual charges attached to a client (although some clients may have hosting only) which will occur on different dates, i.e. a client's hosting may be set up on 15/10/2004 while the website launch date could be 23/11/2004. Therefore, a reminder email should be sent X days before the annual hosting charge is due, and again X days before the annual maintenance charge (based on the website launch date) is due.
Please provide timings and costs.
Interface needs to look simple but attractive.
IMPORTANT: Please show a list of url's for projects you have worked on. You must have prior ratings on Scriptlance.