I have 3 tables that I need to extract meaningful data from and put in charts;
Grouped By: School_code,
payrolls.school_code,
[login to view URL],
payrolls.work_area,
payrolls.full_name,
payrolls.st_hours,
payrolls.st_rate,
payrolls.ot_hours,
payrolls.ot_rate,
payrolls.pay_code,
payrolls.punch_in,
payrolls.punch_out,
[login to view URL],
attendances.school_code,
[login to view URL],
attendances.child_count,
students.school_code,
students.primary_classroom,
students.date_of_birth,
students.primary_classroom == payrolls.work_area (except for work areas where there are no students //kitchen, office)
examples of needed ->
for each payrolls by school_code, department:
"(st_hours * st_rate)+(ot_hours * ot_rate)";
need to get $ / student;
--- can you work with JSON stored in longtext ?
*** at the very least, I need help creating a View in MySQL to reference elsewhere.
- looking also for laravel + jquery assistance
Hi, sir
I have good experience in laravel and i can work in long text with json.
I have great skills in website developing .
I am sure I can complete your project!
If we have chat, then we can be sure for each other.
Let's start this work!
Regards