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.

score 0 · Answer 1 · answered Oct 22 '15 at 15:46

0

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

answered Oct 22 '15 at 15:46

Ravisha Hesh

1,504
13
19

what realtionship i need to put in models – NikolaSae Oct 22 '15 at 15:55
For LECTURESTYPE model : `public function lectures(){ return $this->hasMany('App\LECTURES','id_lectures'); }` – Ravisha Hesh Oct 22 '15 at 15:58
Call to a member function groupBy() on double – NikolaSae Oct 22 '15 at 16:17

Peter Kota · Answer 2 · 2015-10-22T16:20:59.143

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 '15 at 16:20

answered Oct 22 '15 at 16:15

Peter Kota

8,048
5
25
51

$sum = App\LectureType::with('lecture')->GroupBy('id_lectures')->sum('numb'); – Peter Kota Oct 22 '15 at 16:21
only back to me number 10 no array – NikolaSae Oct 22 '15 at 16:28

score 0 · Answer 3 · answered Oct 22 '15 at 16:21

0

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

answered Oct 22 '15 at 16:21

Jamesking56

3,683
5
30
61

Laravel sum column in table

3 Answers3