database website

En curso Publicado Nov 29, 2006 Pagado a la entrega
En curso Pagado a la entrega

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.

PHP Diseño de sitios web

Nº del proyecto: #111216

Sobre el proyecto

21 propuestas Proyecto remoto Activo Dec 6, 2006