need website design for a php/ mysql database driven information collection for a service providing business, like the service call management ready template database in MS office access with adding the following features to it:
- admin can add / remove / edit fields unlimited
- only admin can see and access the setting page
- multiple admins and multiple users
- admin sets username and passwords for users to access the site and fill thier service reports.
- admin can add / remove / edit products in the product list so users can choose from and add to the service report and generate an invoice
- multiple service calls per customer
- users can add customers and services but need admin approval for deleting
- users enter thier work ours and the form will calculate thier wages according to the time spent and hourly wages set by admin
- database will generate a page for each user showing all services covered by them with thier wages for that service and a weekly total for payroll purposes, and keeping a history record of each user
- ability to print weekly wages record for each user and admin for payroll purposes
- database will check and prevent duplicate entries
- invoice should be generated by adding products and servics automatically with 2 seperate sets of taxes (canadian PST and GST), for services only add GST and for Products add GST AND PST
- invoice should be opened in a seperate browser
- invoice should be printed and can fit on one page
- invoice should have option to add or not add user wages, this option should be able to set in the settings page.
- invoice header should show company logo and their contact information, logo and information should be added and uploaded in settings page.
- automatic invoice number should be generated by database
- invoice header should show invoice number and customer account number
- customer account number should be automatically generated by database and also be able to manually edited by admin only if needed
- admin and users can add / edit notes to each service report
- admin and users can add / edit separate notes to each customers
- none of these notes should show on the invoice.
- ability to generate all the reports listed in the attached ms access database
- website should show a customers list, with their names clickable to open thier info and buttons to generate service reports for them.
- when you click on a customer name a new page will show you their info and a list underneath with all the services for them so far also clickables and buttons to start a new service report for them,
* attached you will find a modified ms access service call database according to our needs to give an idea of where to start from.
** to have a better understanding of our needs, there is already an online service management program but very simple, go to [url removed, login to view] and look at their screenshots.