Project Detail

Custom PHP based MySQL data viewer

Custom PHP based MySQL data viewer is project number 486797
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: NickolaS

Budget: $250-750

Created: 08/12/2009 at 13:48 EDT

Bid Count: 19

Average Bid:
$ 516

08/22/2009 at 13:48 EDT

Project Creator: perfectcopper
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (2 reviews)

Description

Background Information:
We have a client that is spending a lot of time manually entering this information into an Excel spreadsheet. This is very time consuming but it is the only way they know how to track it. The client has purchased a time clock product from a company at timeclockplus.com. They purchased 3 card swipe unit (that connects directly to the internet), 100 employee swipe cards and the software to use the application (custom software & SQL server to collect all needed information). The employees are assigned a swipe card with a unique number. As they begin work on a specific job the card is swiped & a job number is entered. The same is repeated when the employee is done working on that job. This will track who performed labor for which client at which location (naturally the date & time will also be collected). The software that comes with the product does not really fit their needs.

Project Goals:
They would like a custom application to access the information collected by the SQL server. Then add more information to the SQL (e.g. manual labor times in & out, cost of materials used on the job, what the customer was charged for the materials and the cost of equipment rentals). All the needed information to create reports and calculate payroll would be housed within the SQL server. They would like to have a Payroll Report, Job Summary Report, Status Report of all jobs within the company and print invoices.

Project Details:
The SQL server contains many tables setup by the software program. One of these tables contains the swipe card information. The other tables contain information the program needs but for our purposes they are not needed. We have created a table to contain system users, materials, hours (to contain the collected data from the card swipes) and a jobs table (to contain the financial information & contain the primary key that allows all the other tables to associate to it). This will allow the collection of data pertaining to a job to be displayed.

Project Summary:
The person that works the system should have to create the jobs, add the materials (rentals include with this) to the job & then add any labor that was performed manually (not collected by the time clock. Then the system should collect the information on the time swipes to have all the information needed about the job. The user could then view the reports to collect the information they need. This application must be easy to use & work. Its purpose is to allow the easy display of collected information.

Report Violation

Job Type

See more: access, application, card, company, data, easy, excel, financial, job, jobs, mysql, payroll, php, print, report, server, software, sql, sql server, work

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

500

5 days

08-12-2009 14:41 EDT

9.9898/10
(394 reviews)

Hi, please, check your PM

VALUEONWEB

400

6 days

08-12-2009 15:52 EDT

9.9297/10
(185 reviews)

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have expertise and experience in ecommerce site development, flash and animation. Our team can work on HTML,DHTML, JAVA SCRIPT, FLASH , ASP,ASP.NET,PHP,MY SQL, SQL Server, MS SQL. Our Bid includes development , deployment and testing. We are ready to start and send daily reports. we communicate through email,messenger,phone and skype.We will a deliver a professional looking design(s) with proposed functionality to match your concept.

jsinfoway

500

10 days

08-13-2009 01:17 EDT

9.9714/10
(140 reviews)

HI,we understood your requirements and ready to start.check pmb for our portfolio.Thanks..

A2Design

710

19 days

08-12-2009 15:28 EDT

9.8824/10
(51 reviews)

We'd like to help you with this project. Take a look on our portfolio at: http://www.a2design.biz/portfolio_

dagdya99

599

6 days

08-12-2009 13:51 EDT

9.9268/10
(41 reviews)

Hi, We are interested in working with you. We have successfully completed various web projects in different areas like Dating sites, Real Estate sites, Event Management Systems, Classified sites and many business oriented projects. Please let us know if you require any detailed information. Hope to hear back from you soon. Thanks "Great minds can do anything"

sisindia

495

15 days

08-12-2009 14:09 EDT

9.9714/10
(35 reviews)

Hi, Please see PMB for details. Thanks, Dharmendra

sritechnocrat

400

30 days

08-14-2009 15:23 EDT

9.871/10
(31 reviews)

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan. With Regards Sri Technocrat.

borayeris

500

15 days

08-13-2009 07:04 EDT

9.92/10 9.92/10 9.92/10 9.92/10 9.92/10 9.92/10 9.92/10 9.92/10 9.92/10 9.92/10
(25 reviews)

Questions sent to PMB.

sureshmca06

450

6 days

08-12-2009 14:19 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(10 reviews)

I am ready to work., Lets Start., Please check my PM., Thanks.,

joedeveloper

500

15 days

08-12-2009 15:29 EDT

9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10 9.9/10
(10 reviews)

Hi, we are a small efficient team of developers ready to work on your project literally around the clock. Please see PM for details.

andreiandrei

550

6 days

08-12-2009 14:01 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

Hi,please check PM.

devajas

380

21 days

08-13-2009 01:53 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

hi,we can do this for you. hope we cooperate. best regards devajas Our work samples: http://www.seo-authority.com http://www.028edata.cn http://www.02cool.cn http://www.driverchecker.com http://www.spywarecease.com http://www.warcraftmovies.com http://www.xitek.com http://www.registryeasy.com http://www.infotalent.cn:8085/homebook/ http://www.casahair.com http://www.redlinetours.com http://www.piamarine.com http://www.batesias.com http://www.xyssnet.cn http://www.xishuqy.com http://www.ddhjxgs.com http://www.yajfr.cn http://www.scsxtx.com http://www.028cfw.com http://221.10.166.248/ztdx/main.asp http://rsc.suse.edu.cn http://www.ansteelgroup.com/tw/ http://www.ln-huanyu.com/ http://www.cnghg.cn

annakolesnik

550

10 days

08-12-2009 17:01 EDT

(No Feedback Yet)

We'll be glad to offer the services. Please, find the questions on the PM.

vikrammahant

750

30 days

08-13-2009 01:59 EDT

(No Feedback Yet)

We are a team of web designer and web development based in North India, Amritsar, Punjab, with experience of more than ten years. We have professional and creative team for every field like Website Design, Web Development, Flash Website Design, Graphic Design, Logo Design etc. Our creative team can give a unique and attractive look to your project so you can take more benefits from your project.

beaker

425

7 days

08-13-2009 12:29 EDT

(No Feedback Yet)

Can have this done. Please check PMB

aatrapps

300

30 days

08-13-2009 13:56 EDT

(No Feedback Yet)

Works been gone through throughly, we at Attr Apps make sure that the work comes out pixcel perfect! Best Regards! Attr Apps No beating around the bush.

sschelliah

700

28 days

08-14-2009 12:09 EDT

(No Feedback Yet)

Hi, Please see PMB for more details.

jl5501

600

45 days

08-15-2009 13:22 EDT

(No Feedback Yet)

Hello I am very interested in this project. Please see PM. Best regards John

debamlan

500

14 days

08-20-2009 16:36 EDT

(No Feedback Yet)

As per our understanding of your project: 1) There is an existing database that came along the swiping Software(S/W). The table that contains the swiping details is partially useful for the organisation. 2)Two Tables had been created additionally so that additional information can be stored. Table 1: Other than the card swiping Information it also contains feilds like system users, materials, hours etc. Table 2: It is a Job Table which will consist of Job Details along with Financial Details also We need to create forms For entry and generate Reports as per clients requirement. IF the job is awarded to us we will surely meet your expectation right on time.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.