Custom PHP based MySQL data viewer

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.

Taidot: PHP, SQL

Näytä lisää: unique jobs, the payroll company, project based jobs, primary jobs, primary job, primary data, php time card, php manual, php create table, php and mysql jobs, one key data, mysql data access, manual labor, labor jobs, job summary, jobs that use excel, jobs manual, how to create a software application with php, entering data jobs, employee needs, data entering software, create table php, cost jobs, company rentals, company background information

Tietoa työnantajasta:
( 5 arvostelua ) Stockbridge, Panama

Projektin tunnus: #486797

Myönnetty käyttäjälle:


Hi, please, check your PM

$500 USD 5 päivässä
(329 Arvostelua)

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 experti Lisää

$400 USD 6 päivässä
(214 arvostelua)

We'd like to help you with this project. Take a look on our portfolio at: [url removed, login to view]

$710 USD 19 päivässä
(41 arvostelua)

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 Lisää

$400 USD 30 päivässä
(55 arvostelua)

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 busin Lisää

$599 USD 6 päivässä
(212 arvostelua)

HI,we understood your requirements and ready to [url removed, login to view] pmb for our portfolio.Thanks..

$500 USD 10 päivässä
(73 arvostelua)

Hi, Please see PMB for details. Thanks, Dharmendra

$495 USD 15 päivässä
(40 arvostelua)

Questions sent to PMB.

$500 USD 15 päivässä
(25 arvostelua)

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

$450 USD 6 päivässä
(13 arvostelua)

Hi,please check PM.

$550 USD 6 päivässä
(5 arvostelua)

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 15 päivässä
(8 arvostelua)

hi,we can do this for you. hope we cooperate. best regards devajas Our work samples: [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] http://www.s Lisää

$380 USD 21 päivässä
(8 arvostelua)

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

$600 USD 45 päivässä
(1 arvostelu)

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 30 päivässä
(5 arvostelua)

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 Developm Lisää

$750 USD 30 päivässä
(3 arvostelua)

Can have this done. Please check PMB

$425 USD 7 päivässä
(0 arvostelua)

Hi, Please see PMB for more details.

$700 USD 28 päivässä
(0 arvostelua)

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

$550 USD 10 päivässä
(0 arvostelua)

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 Ta Lisää

$500 USD 14 päivässä
(0 arvostelua)