Completed
Push — master ( f00659...1f4cdd )
by Julien
05:36
created

Comments::getAvgNote()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 7
Code Lines 5

Duplication

Lines 7
Ratio 100 %

Importance

Changes 1
Bugs 0 Features 1
Metric Value
c 1
b 0
f 1
dl 7
loc 7
rs 9.4286
cc 1
eloc 5
nc 1
nop 0
1
<?php
2
3
namespace App\Http\Models;
4
5
use Illuminate\Database\Eloquent\Model;
6
use Illuminate\Support\Facades\DB;
7
8
9
/**
10
 * Classe qui va stocker mes requetes autoirs
11
 * de ma table movies
12
 * Hérite de ma super classe Model
13
 */
14 View Code Duplication
class Comments extends Model{
0 ignored issues
show
Duplication introduced by
This class seems to be duplicated in your project.

Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.

You can also find more detailed suggestions in the “Code” section of your repository.

Loading history...
15
16
    /**
17
     * Décrit le nom de la table
18
     * que classe fait référence
19
     */
20
    protected $table = 'comments';
21
22
23
    /**
24
     *  Return the average of notes
25
     */
26
    public function getAvgNote(){
27
        $results = DB::table('comments')
28
            ->select(DB::raw('ROUND(AVG(note)) as avgnote'))
29
            ->first();
30
31
        return $results;
32
    }
33
34
35
36
    /* RELATIONS */
37
38
    public function movie()
39
    {
40
        return $this->belongsTo('\App\Http\Models\Movies', 'movies_id');
41
    }
42
43
    public function user()
44
    {
45
        return $this->belongsTo('\App\Http\Models\Users');
46
    }
47
48
49
}
50
51
52
53