GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

database website

   Click here to post similar project

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 View PM Post PM
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
Report violation
Job Type:
  • PHP
  • Website Design
Database: MySQL
Operating system: (None)
Bid count: 23
Average bid: N/A

 

Related project
 
Nonpublic project #290907 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
Bids are hidden by project creator. Log in as project creator or bidder as the project creator or as one of the bidders to view bids.
Bid on This Project

 

[ Web Forms ] [ Join GAF Free ] [ View All Projects ] [ Outsourcing Web Design ]

What is GetAFreelancer.com? ( Read about the company )

It's easy, fun and very affordable to outsource your project with our site. Find freelance programmers, web designers, copywriters and translators. Buy services with help from our secure escrow system.

We provide a safe escrow environment and you don't release the money until project is completed. Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world. A freelancer is an independent worker, not on salary, hired instead on a project basis. We have thousands of satisfied clients around the world.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.