database website

database website is project number 111216 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider girish327)

Status:	Closed
Budget:	$100-300
Created:	11/29/2006 at 21:34 EST
Bidding Ends:	12/04/2006 at 21:34 EST
Project Creator:	saroma   Buyer Rating: (No Feedback Yet)
Description:	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 http://www.service-management.us/ and look at their screenshots. Additional files submitted: smartechno service call.zip
Job Type:	PHP Website Design
Database:	MySQL
Operating system:	(None)
Bid count:	23
Average bid:	N/A