Small database project with web frontend
N/A
Betalades vid leverans
My client currently has a static brochure style website and would like to add a module allowing their customers to log-in and view the stock held for them by my client.
The domain is currently on a shared hosting platform at FastHosts and although the domain is on a Windows 2003 server, there is full PHP support.
The database can be either Access or MySQL
There will be a total of 6 pages as follows: -
Admin Log-in (example layout attached - [url removed, login to view])
A simple username and password log-in
Admin Default (example layout attached [url removed, login to view])
Three key areas
1. Client Search – the ability to search for a client record by Customer Name, Contact Name or Customer ID (automatically generated when a new client record is added)
2. Admin Functions
a. Download List to download a list of all clients held in .csv format
b. Download List & Stock to download a list of all clients and the stockholding for each,
c. Add New Customer – takes the Administrator to [url removed, login to view]
d. Log-out
3. Customer List – A list of existing customer in the database with option for each to View/Edit customer details (link to [url removed, login to view] of selected record), View Stock to view a list of stock held for the selected customer, Upload Stock List to allow for .csv upload of stock for selected customer
Admin – Add New Client (example layout attached - [url removed, login to view])
Three key areas
1. Details – fields to add details of the new customer
2. Admin Functions
a. Send Reminder – send an email to the customer with their username and log-in details
b. Download Stock List – downloads a .csv file of stock held for selected customer
c. Upload Stock List – uploads (with ‘browse for a file’ function) .csv file stock held and overwrites existing
d. Back to Admin Home – takes the Administrator back to Admin Default page
3. Stock list – this will be blank until the stock list is uploaded by the Administrator
Admin – View/Edit Client
Three key areas
1. Details – fields to view or update details of the new customer
4. Admin Functions
a. Send Reminder – send an email to the customer with their username and log-in details
b. Download Stock List – downloads a .csv file of stock held for selected customer
c. Upload Stock List – uploads (with ‘browse for a file’ function) .csv file stock held and overwrites existing
d. Back to Admin Home – takes the Administrator back to Admin Default page
5. Stock list – a list of stock held for the customer
Client Login (example layout attached – [url removed, login to view])
A simple username and password log-in as created by the Administrator for the customer
Client Default (example layout attached [url removed, login to view])
Three key areas
1. Details – ability of customer to change either of these four fields with update button
2. Admin Function to download stock list as .csv or logout
3. Stock list view of stock held for customer
I have created these pages in HTML to help understand the structure and visual layout but these pages will need to be converted to PHP. A MySQL database has not yet been created but can easily be done with FastHosts.
Projekt-id: #316429
