Comments::getAvgNote()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 8
Code Lines 5

Duplication

Lines 0
Ratio 0 %

Importance

Changes 2
Bugs 0 Features 2
Metric Value
c 2
b 0
f 2
dl 0
loc 8
rs 9.4285
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
 * Classe qui va stocker mes requetes autoirs
10
 * de ma table movies
11
 * Hérite de ma super classe Model.
12
 */
13
class Comments extends Model
14
{
15
    /**
16
     * Décrit le nom de la table
17
     * que classe fait référence.
18
     */
19
    protected $table = 'comments';
20
21
    /**
22
     *  Return the average of notes.
23
     */
24
    public function getAvgNote()
25
    {
26
        $results = DB::table('comments')
27
            ->select(DB::raw('ROUND(AVG(note)) as avgnote'))
28
            ->first();
29
30
        return $results;
31
    }
32
33
    /* RELATIONS */
34
35
    public function movies()
36
    {
37
        return $this->belongsTo('\App\Http\Models\Movies');
38
    }
39
40
    public function user()
41
    {
42
        return $this->belongsTo('\App\Http\Models\User');
43
    }
44
}
45