Laravel sum column in table

Question

I have two tables:

LECTURES
id   name
1 - Lesson 1
2 - Lesson 2
3 - Lesson 3

LECTURESTYPE
id  id_lectures   numb
1 -     1 -        10
2 -     2 -        20
3 -     1 -        30

How can I sum numbs column for each lesson and take result like : name: Lesson 1 numb: 40

I want to display the sum of numb for each lesson.

Ravisha Hesh · Accepted Answer · 2015-10-22 15:46:18Z

0

Try LECTURESTYPE::with('lectures')->sum('numb')->GroupBy('id_lectures')->get()

answered Oct 22, 2015 at 15:46

Ravisha Hesh

1,51513 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

NikolaSae Over a year ago

what realtionship i need to put in models

Ravisha Hesh Over a year ago

For LECTURESTYPE model : public function lectures(){ return $this->hasMany('App\LECTURES','id_lectures'); }

NikolaSae Over a year ago

Call to a member function groupBy() on double

Peter Kota · Accepted Answer · 2015-10-22 16:20:59Z

0

You need the following relation:

Lecture (App\Lecture.php)

namespace App;
class Lecture extends Model {
    protected $table = 'lectures';
    public function lecturetype() {
        return $this->hasMany('App\LectureType');
    }
}

LectureType (App\LectureType.php)

namespace App;
class LectureType extends Model {
    protected $table = 'lecturestype';
    public function lecture() {
        return $this->belongsTo('App\Lecture');
    }
}

Now you can try in the Controller:

$sum = App\LectureType::with('lecture')->GroupBy('id_lectures')->sum('numb');

edited Oct 22, 2015 at 16:20

answered Oct 22, 2015 at 16:15

Peter Kota

8,3905 gold badges29 silver badges53 bronze badges

2 Comments

Peter Kota Over a year ago

$sum = App\LectureType::with('lecture')->GroupBy('id_lectures')->sum('numb');

NikolaSae Over a year ago

only back to me number 10 no array

Jamesking56 · Accepted Answer · 2015-10-22 16:21:25Z

0

Try LECTURESTYPE::with('lectures')->GroupBy('id_lectures')->sum('numb')

answered Oct 22, 2015 at 16:21

Jamesking56

3,9696 gold badges35 silver badges63 bronze badges

Collectives™ on Stack Overflow

Laravel sum column in table

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related