| 1 | <?php |
||
| 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() |
||
| 39 | |||
| 40 | public function user() |
||
| 44 | } |
||
| 45 |