Käynnissä

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:

NickolaS

Hi, please, check your PM

500 $ USD 5 päivässä
(329 arvostelua)
7.5

19 freelanceria on tarjonnut keskimäärin 516 $ tähän työhön

VALUEONWEB

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)
7.9
A2Design

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)
7.8
sritechnocrat

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)
7.3
dagdya99

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)
7.1
jsinfoway

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)
6.6
sisindia

Hi, Please see PMB for details. Thanks, Dharmendra

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

Questions sent to PMB.

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

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

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

Hi,please check PM.

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

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)
4.8
devajas

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)
3.6
jl5501

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

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

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)
2.0
vikrammahant

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)
1.9
beaker

Can have this done. Please check PMB

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

Hi, Please see PMB for more details.

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

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

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

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)
0.0