Find Jobs
Hire Freelancers

Custom PHP based MySQL data viewer

$250-750 USD

In Progress
Posted over 14 years ago

$250-750 USD

Paid on delivery
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.
Project ID: 486797

About the project

19 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, please, check your PM
$500 USD in 5 days
5.0 (329 reviews)
7.5
7.5
19 freelancers are bidding on average $516 USD for this job
User Avatar
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.
$400 USD in 30 days
4.8 (55 reviews)
7.3
7.3
User Avatar
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"
$599 USD in 6 days
5.0 (212 reviews)
7.1
7.1
User Avatar
Hi, Please see PMB for details. Thanks, Dharmendra
$495 USD in 15 days
5.0 (40 reviews)
5.7
5.7
User Avatar
Questions sent to PMB.
$500 USD in 15 days
4.9 (25 reviews)
4.9
4.9
User Avatar
I am ready to work., Lets Start., Please check my PM., Thanks.,
$450 USD in 6 days
5.0 (13 reviews)
4.9
4.9
User Avatar
Hi,please check PM.
$550 USD in 6 days
5.0 (5 reviews)
4.8
4.8
User Avatar
Hi, we are a small efficient team of developers ready to work on your project literally around the clock. Please see PM for details.
$500 USD in 15 days
4.9 (8 reviews)
4.8
4.8
User Avatar
Hello I am very interested in this project. Please see PM. Best regards John
$600 USD in 45 days
5.0 (1 review)
2.6
2.6
User Avatar
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.
$300 USD in 30 days
4.6 (5 reviews)
2.0
2.0
User Avatar
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.
$750 USD in 30 days
4.0 (3 reviews)
1.9
1.9
User Avatar
We'll be glad to offer the services. Please, find the questions on the PM.
$550 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Can have this done. Please check PMB
$425 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Please see PMB for more details.
$700 USD in 28 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$500 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PANAMA
Stockbridge, Panama
4.9
5
Member since Jul 12, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.