I gang

database website

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.

Færdigheder: PHP, Web Design

Se mere: www payroll, website management services, website find find, website edit logo online, website design hourly, website design features list, username logo online, understanding by design template, total company logo, the payroll company, template header website, site where you can edit logo online, simple logo to generate, services database, service report template, service database access, products database design, product design website design, product database design, printed names, payroll service company, open php template online, online work website list, online business payroll, office service management logo

Om arbejdsgiveren:
( 7 bedømmelser ) Windsor, Canada

Projekt-ID: #111216