I have a MySQL database on the internet. The database contains daily work entries from our field technicians. They enter the information though a web page. I would like to find a way to create a report against the database that would be each technicians timecard but there is some data manipulation involved. Each day every technician entry is a separate line item in the database. I would like the report to be able to select one technician, for a specific time range, and add the hours together for each job as a sum total. For example, in a two week time period a single technician may have worked on three jobs, one with overtime. This may be as few as ten entries in the database but could be more depending on if he worked on two jobs in one day. I would like a report in excel that gives me three lines only (the three regular hour jobs with regular time total and the overtime job (same job number, just OT hours) with time total).
I can make a replicant of the current database available for development and an example of what the end report in Excel should look like is included below. All the information in the spreadsheet (minus the sum totals) is available in the database. I am open to suggestion on how to implement this (could be another web page). Some simple security would be needed as well. I can modify the database as need to suite functionality.
61 freelancers are bidding on average $457 for this job
10+ years experience. 600+ projects completed successfully. Very interested in this project. There is no file attached. Please send me complete details. Ready to start ASAP.
I'm expert in web development for more than 12 years, I'm highly skilled in php , ajax, jquery, SEO, SOAP & XML...I'm ready to start I can start right away. Thanks.
Hi Requirement clear Will you send me the sample database to analyze first I am a master of php more than 11 years now ,I can deliver what you need as it is Waiting for a reply