1 | <?php |
||
14 | class Movies extends Model implements ItemInterface |
||
15 | { |
||
16 | protected $fillable = ['title', 'description', 'categories_id']; |
||
17 | |||
18 | /** |
||
19 | * Décrit le nom de la table |
||
20 | * que classe fait référence. |
||
21 | */ |
||
22 | protected $table = 'movies'; |
||
23 | |||
24 | /** |
||
25 | * Retourne tous les films. |
||
26 | */ |
||
27 | public function getAllMovies() |
||
31 | |||
32 | /** |
||
33 | * Return moyenne des notes de presse. |
||
34 | */ |
||
35 | public function getAvgNotePresse() |
||
36 | { |
||
37 | $result = DB::table('movies') |
||
38 | ->select(DB::raw('ROUND(AVG(note_presse)) as avgpress')) |
||
39 | ->first(); |
||
40 | |||
41 | return $result; |
||
42 | } |
||
43 | |||
44 | /***************************************************** Relationships ***********************************************************/ |
||
45 | |||
46 | /** |
||
47 | * Retourne la catégorie à laquelle appartient un objet film |
||
48 | * Many To One : n..1. |
||
49 | * |
||
50 | * @return \Illuminate\Database\Eloquent\Relations\BelongsTo |
||
51 | */ |
||
52 | public function categories() |
||
56 | |||
57 | /** |
||
58 | * belongsToMany(): Many To Many. |
||
59 | */ |
||
60 | public function user() |
||
64 | |||
65 | /** |
||
66 | * belongsToMany(): Many To Many. |
||
67 | * |
||
68 | * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany |
||
69 | */ |
||
70 | public function actors() |
||
74 | |||
75 | public function directors() |
||
79 | |||
80 | public function comments() |
||
84 | |||
85 | public function sessions() |
||
89 | |||
90 | public function recommandations() |
||
94 | |||
95 | /** |
||
96 | * @param ItemInterface $item |
||
97 | */ |
||
98 | public function add(ItemInterface $item) |
||
101 | |||
102 | /** |
||
103 | * @param ItemInterface $item |
||
104 | */ |
||
105 | public function remove(ItemInterface $item) |
||
109 | } |
||
110 |