I have an existing MYSQL table called "time" which has sample timesheet entries from one week. See [login to view URL] for table and data.
The table has many fields, but only a few are needed to pivot for the view- hours, overtime, activity, notes, date_2, wo_number, utility_charge. See ExistingTable.PNG.
I need the view to look like MysqlPivot.PNG.
Each record should be listed separately, but the time as entered into "hours", along as to if it is overtime or not (R is Regular time, O is Overtime) should be in the correct day of the week in the view. Also the total hours for each record should display.
As an example, the first record should look like [login to view URL]
9 freelancere byder i gennemsnit $34 på dette job
I read your requirements and make changes according to you. I have 8+ years of experience. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.
Interesting Wonderful project! We are good team in many experiences in Web developing. We are masters of math and web design. If you keep in touch with us, you can get satisfy result. Thanks a lot!