Query to return totals by job number

I have a table that stores job numbers and hours as shown here.

I need to total all hours per job number for a specific period. Therefore period 1 result would look like this.

The data table extends to include 3 job number entries for each day.

Anyone able to help me build the query for this?

Thanks in advance.

Level 15

I'm not sure the way you've set up the database works very well - and it looks like you are making it complicated for yourself.

Would it not be a better idea to have a separate record for each job?

mon_job_number1_hours
mon_job_number2_hours
mon_job_number3_hours

Why not have 1 column for job_number and then another for hours

Doing it this way would allow you to make a query like:

/* Get total hours per job in Period 1 */

SELECT SUM(hours)
FROM your_database
WHERE period = 1
GROUP BY job_number

In eloquent it may look something like this:

App\Timesheet::groupBy('job_number')
    ->selectRaw('sum(hours)')
    ->where('period', '1')

Please or to participate in this conversation.