Completed
Push — master ( 002bc5...c06b9c )
by Julien
08:45
created

Comments::movies()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 4
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 1
Metric Value
c 1
b 0
f 1
dl 0
loc 4
rs 10
cc 1
eloc 2
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
class Comments extends Model{
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 movies()
39
    {
40
        return $this->belongsTo('\App\Http\Models\Movies');
41
    }
42
43
    public function user()
44
    {
45
        return $this->belongsTo('\App\Http\Models\User');
46
    }
47
48
49
}
50
51
52
53